Use the following to answer questions 9-12.
Five years later, you are offered your dream job in Costa Rica. You need to sell this house in order to purchase a new one where you are moving. Rents have increased since you purchased the home and you estimate that the home will rent for $1700 per month (net). You have found a high quality tenant willing to sign a five year lease under the following conditions. Rent will be $1,700 for the first three years, and increase to $2,000 for the remaining two years. The average investor’s holding period on residential rental properties is five years. You have estimated sale proceeds will be $339,427 at the end of the investor’s holding period. The appropriate discount rate is 4.25%.
9. What is the minimum price you should list the property for (i.e. the maximum an investor would be willing to pay)? Round up to the nearest whole dollar. *Remember, the value of an investment property comes from its cash flows. That is, you need to consider both the estimated proceeds at the end of the holding period AND the stream of cash flows the investor will receive from rent while they own the property.
10. What will the investor’s “going-in” IRR be if they pay exactly list price? Round to two decimal places.
11. Assume your original loan amount was $246,296 and that you have been making payments of $1,000 per month. You will close on the home after making your last payment in year 5. How much will your loan payoff amount be (in other words, what is the outstanding balance on your loan after 5 years)? Round to the nearest whole dollar.
12. Assuming you sell the home for exactly list price, pay a 6% real estate broker commission and $4,500 in Seller closing costs, what will be your net proceeds from the sale? Round to the nearest whole dollar. *don’t forget to include your loan payoff amount!
Question 9
For the solution, the table below is to considered
Q9 | Year | ||||||
1 | 2 | 3 | 4 | 5 | |||
Rent paid by the tenant as per the agreement | $20,400.00 | $20,400.00 | $20,400.00 | $24,000.00 | $24,000.00 | ||
Proceeds from the sale of the house | $3,39,427.00 | ||||||
Appropriate Discount rate | 4.25% | ||||||
Pv of the rent inflows | $19,568.35 | $18,770.60 | $18,005.37 | $20,319.22 | $19,490.86 | ||
PV of the sales proceeds | $2,75,655.12 | ||||||
Sum of PV | $3,71,809.50 |
The minimum price to be listed at : $3,71,809.50
Q 10:
Q 10 | Year | Cash Flows |
0 | -$3,71,809.50 | |
1 | $20,400.00 | |
2 | $20,400.00 | |
3 | $20,400.00 | |
4 | $24,000.00 | |
5 | $24,000.00 | |
Discount Rate | 4.25% | |
NPV | ($2,75,655.12) | |
IRR | -30% |
Q11
Q 11 | Year | Cash Flows |
0 | -$2,46,296.00 | |
1 | $12,000.00 | |
2 | $12,000.00 | |
3 | $12,000.00 | |
4 | $12,000.00 | |
5 | $12,000.00 | |
Discount Rate | 4.25% | |
NPV | ($1,93,247.25) |
The outstanding loan amount would be $1,93,247.25
Q12:
Q 12 | ||
Proceeds from the sale | $3,71,809.50 | |
Broker commision | $22,308.57 | |
Seller closing costs | $4,500.00 | |
Outflow | $3,94,118.07 | |
Dioscount rate | 4.25% | |
PV of the sale | 3,20,070.78 | |
outstanding loan amount | 1,93,247.25 | |
Net proceeds from the sale | 1,26,823.53 |
Use the following to answer questions 9-12. Five years later, you are offered your dream...
Use the following to answer questions 1-4. You currently live (rent free) in your parents' basement but it's a bit awkward when you bring dates home. Your friends are looking for a new roommate and have asked if you're interested in moving in. Your share of the rent (which includes all utilities) will be $1,000 per month, due at the beginning of the month, and you will be signing a three-year lease. You parents think you should save your money...
The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30 years and had an interest rate of 9% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance, that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125 % (APR). a....
The mortgage on your house is five years old. It required monthly payments of $ 1 422 , had an original term of 30 years, and had an interest rate of 9 % (APR). In the intervening five years, interest rates have fallen and so you have decided to refinancelong dashthat is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.625...
When you purchased your car, you took out a five-year annual-payment loan with an interest rate of 5.6% per year. The annual payment on the car is $5,400. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)? b. You have owned the...
The mortgage on your house is five years old. It required monthly payments of $ 1,422, had an original term of 30 years, and had an interest rate of 9 % (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance long dash that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.125...
Use the following to answer questions 1-4. You currently live (rent free) in your parents' basement but it's a bit awkward when you bring dates home. Your friends are looking for a new roommate and have asked if you're interested in moving in. Your share of the rent (which includes all utilities) will be $800 per month, due at the beginning of the month, and you will be signing a two-year lease. You parents think you should save your money...
When you purchased your car, you took out a five-year annual payment loan with an interest rate of 5.9% per year. The annual payment on the car is $5,300. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)? b. You have owned...
When you purchased your car, you took out a five-year annual-payment loan with an interest rate of 6.3% per year. The annual payment on the car is $5,100. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)? b. You have owned the...
The mortgage on your house is five years old. It required monthly payments of $1,450, had an original term of 30 years, and had an interest rate of 10% (APR). In the intervening five years, interest rates have fallen and so you have decided to refinance — that is, you will roll over the outstanding balance into a new mortgage. The new mortgage has a 30-year term, requires monthly payments, and has an interest rate of 6.625% (APR). a. What...
(round the the nearest cent) When you purchased your car, you took out a five-year annual-payment loan with an interest rate of 6.2% per year. The annual payment on the car is $5,200. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for one year (so there are four years left on the loan)?...