Investment Z: GPI (4% growth rate) Year 1 168,000 Year 2 174,720 Year 3 181,709 Year...

Transcribed Image Text:

Investment Z: GPI (4% growth rate) Year 1 168,000 Year 2 174,720 Year 3 181,709 Year 4 188,977 Year 5 196,536 Vac. @4% 6,720 6,989 7,268 7,559 7,861 EGI 161,280 167,731 174,440 181,418 188,675 Op.Exp (3% growth rate) 64,000 65,920 67,898 69,935 72,033 NOI 97,280 101,811 106,543 111,484 116,642 Mtg Pmt: Principal Interest 25,610 27170 28824 30580 32442 34,870 33,310 31,656 29,900 28,038 60,480 60,480 60,480 60,480 60,480 BTCF Tax Expense (@30%) ATCF EAT (NI) Other information: Purchase price 800,000 annual depreciation 20,000 annual CCA 12,000 sell at beginning of YR 6 ($600,000 bldg; $200,000 land) 20,000 23,520 20,000 22,579 $ 200,000.00 cash investment 20,000 21,676 20,000 20,809 $800,000 ($450,000 bldg; $350,000 land) Mtg: 75% of purchase price, 6%c/sa, monthly pmts, 15 yr amort., pmt rounded to next whole dollar Investment Z: GPI (4% growth rate) Year 1 168,000 Year 2 174,720 Year 3 181,709 Year 4 188,977 Year 5 196,536 Vac. @4% 6,720 6,989 7,268 7,559 7,861 EGI 161,280 167,731 174,440 181,418 188,675 Op.Exp (3% growth rate) 64,000 65,920 67,898 69,935 72,033 NOI 97,280 101,811 106,543 111,484 116,642 Mtg Pmt: Principal Interest 25,610 27170 28824 30580 32442 34,870 33,310 31,656 29,900 28,038 60,480 60,480 60,480 60,480 60,480 BTCF Tax Expense (@30%) ATCF EAT (NI) Other information: Purchase price 800,000 annual depreciation 20,000 annual CCA 12,000 sell at beginning of YR 6 ($600,000 bldg; $200,000 land) 20,000 23,520 20,000 22,579 $ 200,000.00 cash investment 20,000 21,676 20,000 20,809 $800,000 ($450,000 bldg; $350,000 land) Mtg: 75% of purchase price, 6%c/sa, monthly pmts, 15 yr amort., pmt rounded to next whole dollar