- With information from above, calculate the BTCFs for each of the 5-year holding period. Include debt service to get final BTCF
F G H ( All figures are in $) No. of years 3 330,972.00 8,018.00 21,672.00 4 338,419.00 8,198.00 21,672.00 5 346,033.00 8,382.00 21,672.00 317,318.00 324,945.00 332,743.00 21,722.00 1,219.00 12,507.00 22,211.00 1,246.00 12,788.00 22,711.00 1,274.00 13,076.00 D E B) Five year forecast for net operating income Sr.No. Particulars 1 2 Potential gross rent 316,566.00 323,689.00 B other income 7,669.00 7,842.00 Vacancies in market 21,672.00 21,672.00 Effective gross total D income(A+B-C) 302,563.00 309,859.00 E Operating expenses resident manager 20,777.00 21,244.00 Utilities 1,166.00 1,192.00 Property insurance 11,963.00 12,232.00 Workman compensation insur 143.00 146.00 Supplies and misc. 765.00 782.00 Landscaping & ground maint 3,374.00 3,450.00 Maint. & Repairs 7,976.00 7,976.00 F Management fees 15,128.00 15,493.00 76,374.00 G 76,374.00 Property taxes Total operating 138,889.00 H 137,666.00 exp.(E+F+G) Net Operating 170,970.00 164,897.00 income(D-H) Sheet1 Sheet2 Sheet3 149.00 800.00 152.00 818.00 155.00 836.00 3,528.00 7,976.00 15,866.00 80,048.00 3,607.00 7,976.00 16,247.00 80,048.00 3,688.00 7,976.00 16,637.00 80,048.00 143,815.00 145,093.00 146,401.00 173,503.00 179,852.00 186,342.00 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 F G H ( All figures are in $) No. of years 3 330,972.00 8,018.00 21,672.00 4 338,419.00 8,198.00 21,672.00 5 346,033.00 8,382.00 21,672.00 317,318.00 324,945.00 332,743.00 21,722.00 1,219.00 12,507.00 22,211.00 1,246.00 12,788.00 22,711.00 1,274.00 13,076.00 D E B) Five year forecast for net operating income Sr.No. Particulars 1 2 Potential gross rent 316,566.00 323,689.00 B other income 7,669.00 7,842.00 Vacancies in market 21,672.00 21,672.00 Effective gross total D income(A+B-C) 302,563.00 309,859.00 E Operating expenses resident manager 20,777.00 21,244.00 Utilities 1,166.00 1,192.00 Property insurance 11,963.00 12,232.00 Workman compensation insur 143.00 146.00 Supplies and misc. 765.00 782.00 Landscaping & ground maint 3,374.00 3,450.00 Maint. & Repairs 7,976.00 7,976.00 F Management fees 15,128.00 15,493.00 76,374.00 G 76,374.00 Property taxes Total operating 138,889.00 H 137,666.00 exp.(E+F+G) Net Operating 170,970.00 164,897.00 income(D-H) Sheet1 Sheet2 Sheet3 149.00 800.00 152.00 818.00 155.00 836.00 3,528.00 7,976.00 15,866.00 80,048.00 3,607.00 7,976.00 16,247.00 80,048.00 3,688.00 7,976.00 16,637.00 80,048.00 143,815.00 145,093.00 146,401.00 173,503.00 179,852.00 186,342.00 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
