1. With information from above, calculate the BTCFs for each of the 5 year holding period.

C) Five year forecast for net operating income with loan Sr.No. Paticulas (Allfigures a ein $) No. of years 1 2 3 A 5 Potentialgrossrent 316,566.00 323,689.00 330,972.00 338,419.00 346,033.00 B other income 7,669.00 7,842.00 8,018.00 8,198.00 8,382.00 C Vacancies in market 21,672.00 21,672.00 21,672.00 21,672.00 21,672.00 Effective gross total D income(A+B-C) 302,563.00 309,859.00 317,318.00 324,945.00 332,743.00 IE Operating expenses resident manager 20,777.00 21,244.00 21,722.00 22,211.00 22,711.00 Utilities 1,166.00 1,192.00 1,219.00 1,246.00 1,274.00 Property insurance 11,963.00 12,232.00 12,507.00 12,788.00 13,076.00 Workman compensation insur 143.00 146.00 149.00 152.00 155.00 Supplies and misc. 765.00 782.00 800.00 818.00 836.00 Landscaping & ground maint 3,374.00 3,450.00 3,528.00 3,607.00 3,688.00 Interest on loan 127,500.00 121,125.00 114,750.00 108,375.00 102,000.00 Maint. & Repairs 7,976.00 7,976.00 7,976.00 7,976.00 7,976.00 F Management fees 15,128.00 15,493.00 15,866.00 16, 247.00 16,637.00 G Property tae 76,374.00 76,374.00 80,048.00 80,048.00 80,048.00 Total operating H 265,166.00 exp.(E=F+G 260,014.00 258,565.00 253,468.00 248,401.00 Net Operating income(D-H) 37,397.00 49,845.00 58,753.00 71,477.00 84,342.00 F D E C) Loan amortization scheduled for 5 years, all figure are in $) Year Loan Principal Interest@8.5% Loan outstanding at end 1 1500000 75000 127500 1425000 2 1425000 75000 121125 1350000 3 1350000 75000 114750 1275000 4 1275000 75000 108375 1200000 5 1200000 75000 102000 1125000