Given the following information provide an analysis that answers the questions at the end of the assignment.
Purchase Price: $4,250,000
Rents:
Tenant |
Unit 1 |
Unit 2 |
Unit 3 |
Unit 4 |
Unit 5 |
Unit 6 |
Unit 7 |
Unit 8 |
Monthly Rent |
$5,400 |
$5,400 |
$6,200 |
$3,500 |
$3,600 |
$3,300 |
$3,700 |
$3,100 |
Year 1 NOI: $248,678
NOI Growth Rate: 2.6%
Loan:
LTV: 75%
Amortization Period: 25 years, Term: 10 years
Interest Rate: 3.35%
Lender Points: 2%
Selling Costs: 3%
Going Out Cap Rate: 5.5%
Discount Rate: 10%
Questions:
Can you teach me how to do this on excel?
Given the following information provide an analysis that answers the questions at the end of the...
Given the following information provide an analysis that answers the questions at the end of the assignment. Purchase Price: $4,100,000 Rents: Tenant Unit 1 Unit 2 Unit 3 Unit 4 Unit 5 Unit 6 Unit 7 Unit 8 Monthly Rent $5,600 $5,600 $5,800 $3,200 $3,200 $3,200 $3,200 $3,200 Year 1 NOI: $259,578 NOI Growth Rate: 3% Loan: LTV: 75% Amortization Period: 27 years, Term: 10 years Interest Rate: 4.35% Lender Points: 2% Selling Costs: 5% Going...
Please fill out the rest
Please fill out the property pro forma (last picture)
Your investment firm is considering acquiring a 76-unit, 43,548 rentable-square-foot multifamily property in Phoenix, Arizona (“Arcadia Gardens”). The Asking Price is $9.775 million, which equates to $128,618 per apartment unit and $225 per rentable square foot. Comparable properties have sold for median figures of $120,000 per unit and $157 per rentable square foot. The previous owner of Arcadia Gardens spent $3.5 million on a renovation, during...
Required information Great Adventures Problem AP3-1 The following information applies to the questions displayed below Tony and Suzie graduate from college in May 2021 and begin developing their new business. They begin by offering clinics for basic outdoor activities such as mountain biking or kayaking. Upon developing a customer base, they'll hold their first adventure races. These races will involve four-person teams that race from one checkpoint to the next using a combination of kayaking, mountain biking, orienteering, and trail...