Ann will buy the property in 2014, she will collect NOI for 5 years 2015-2019, and she will sell it in 2019.

Anns loan has a 5/4/3/2/1 prepayment penalty structure, so if she prepays in the first year, she will pay a penalty equal to 5% of the balance, in the second year she will pay a penalty equal to 4% of the balance etc.

Ann forecasts NOI will grow at 2% per year, compounded annually.

Ann forecasts she can sell the property in 2019 at a 6.25% cap rate.

Recall:

(3.a) How much will Ann sell the property for in 2019?

(3.b) How much of a capital gain will Ann earn? (Hint: capital gain = sale price purchase price)

(3.c) What is Anns IRR for this investment?

(3.d) If Anns discount rate is 25%, what is her NPV? Should she make this investment?

(3.e) Plot Anns NPV for discount rates 0%-100%. Copy and paste the chart below.

Project spreadsheet_ Home Draw Page Layout @EBO Review View Tell me Formas Data Calibethody 11 + 18 weet General Free 2-A- EE. ,, Merge Center 6% $ OM % Cordon Form tel Forming Tables man Dette forma NJE 140 f nuta mwen 55.00 051 S. 710 stol 2016 720 Com ty Fund Pus Art 10.00 SON $8.50 31 lowon 1019 WE Sale Land Cache 2. DO 3000 DEN 0000 92 le S ws OP SEO 100 UN 1000 15.00 MOON w 3000 SO DO 100 JOON PV- 100% fisady MEBook Pro Project spreadsheet_ Home Draw Page Layout @EBO Review View Tell me Formas Data Calibethody 11 + 18 weet General Free 2-A- EE. ,, Merge Center 6% $ OM % Cordon Form tel Forming Tables man Dette forma NJE 140 f nuta mwen 55.00 051 S. 710 stol 2016 720 Com ty Fund Pus Art 10.00 SON $8.50 31 lowon 1019 WE Sale Land Cache 2. DO 3000 DEN 0000 92 le S ws OP SEO 100 UN 1000 15.00 MOON w 3000 SO DO 100 JOON PV- 100% fisady MEBook Pro