Business Finance Homework Help
Arizona Christian University Valuate Homes Real Estate Questions
1. How much would you offer for the following homes? Please explain (or show- run a CMA) your work. Please list all the factors that affected your decision (hint: not all factors are financial)?
- 5830 Oakdale Road SE, Mableton, GA 30126
- Offer Amount:
- Factors and Reasoning:
- 10426 W Illini St, Tolleson, AZ 85353
- Offer Amount:
- Factors and Reasoning:
2 Choose one of the two homes above. At your offer price, what is the implied Cap Rate?(consider that this purchase is a lease to buy option) Build a (simple) model in Excell showing your assumptions.
- Background to help you solve the problem:
- Example terms for a $100,000 home :
- Down payment: $2,000 (2% down payment savings held in escrow account for customer to eventually buy the home)
- Year 1: ($Y1 rent + $222 savings in escrow acct)
- Year 2: ($Y2 rent + $222 savings in escrow acct)
- Year 3: ($Y3 rent + $222 savings in escrow acct)
- 18-month Buyback: $X (fixed at 1.5 yr appreciation rate above offer price)
- 36-month Buyback: $Y (fixed at 3 yr appreciation rate above offer price)
- Y2 rent is 2% higher than Y1 rent; Y3 is 2% higher than Y2
- We have not provided rent or buyback numbers, because we want you to make those assumptions
- ).