Question

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!

Answer 1

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