Cash Flow Pro Forma Statement

Linkage THO T-1 T - 2 T - 3 Cap rate r (increases by 0.5%) 5.00% 5.50% 6.00% NOI A (grows @ 5%) 10.00 10.50 11.03 [-] Capital expenditure B = 10% x A 1.00 1.05 1.10 [-] Cost to purchase C = 10 / 5% 200.00 [+] Proceeds from sale D = 11.03 / 6% 183.75 [+] Loan borrowed E 80.00 [-] Loan repaid F = E 80.00 [-] Interest G = E x 5% 4.00 4.00 Net Cash flows A - B - C +D +E - F - G -120.00 5.00 109.20