N12 North Finchley, Woodside Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £539,184
Input Equity (£134,796)
Total Input Equity (£134,796)
Item On Purchase On Completion Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
Property Price/Value £539,184 £539,184 £539,184 £539,184 £539,184 £539,184 £539,184 £539,184 £539,184 £539,184 £539,184 £539,184
Finance Amount £404,388 £404,388 £392,308 £379,609 £366,261 £352,230 £337,481 £321,978 £305,681 £288,551 £270,544 £251,616
Monthly Mortgage   (£2,669) (£2,669) (£2,669) (£2,669) (£2,669) (£2,669) (£2,669) (£2,669) (£2,669) (£2,669) (£2,669)
Monthly Rental   £1,460 £1,460 £1,460 £1,460 £1,460 £1,460 £1,460 £1,460 £1,460 £1,460 £1,460
Yield to Purchase Price %   3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25%
Yield to Property Value %   3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25% 3.25%
Gross Monthly Cashflow   (£1,209) (£1,209) (£1,209) (£1,209) (£1,209) (£1,209) (£1,209) (£1,209) (£1,209) (£1,209) (£1,209)
Gross Annual Cashflow   (£14,511) (£14,511) (£14,511) (£14,511) (£14,511) (£14,511) (£14,511) (£14,511) (£14,511) (£14,511) (£14,511)
Gross Annual Expenses                        
Annual Management Expenses   (£981) (£981) (£981) (£981) (£981) (£981) (£981) (£981) (£981) (£981) (£981)
Gross Annual Cashflow less Expenses   (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387)
Vacancy Expenses                        
Net Annual Cashflow   (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387) (£15,387)
Net Yield %   (2.85%) (2.85%) (2.85%) (2.85%) (2.85%) (2.85%) (2.85%) (2.85%) (2.85%) (2.85%) (2.85%)
Debt Coverage Ratio (1:x)   0.52 0.52 0.52 0.52 0.52 0.52 0.52 0.52 0.52 0.52 0.52
Personal Equity £134,796 £134,796 £146,876 £159,575 £172,923 £186,954 £201,703 £217,206 £233,503 £250,633 £268,640 £287,568
Effective Gearing % 75.00% 75.00% 72.76% 70.40% 67.93% 65.33% 62.59% 59.72% 56.69% 53.52% 50.18% 46.67%
Potential Profit   (£15,492) (£3,411) £9,287 £22,635 £36,666 £51,415 £66,918 £83,215 £100,345 £118,352 £137,280
Return on Investment %   (11.49%) (2.53%) 6.89% 16.79% 27.20% 38.14% 49.64% 61.73% 74.44% 87.80% 101.84%
Cumulative Inflation Rate %     2.00% 4.04% 6.12% 8.24% 10.41% 12.62% 14.87% 17.17% 19.51% 21.90%
Real Potential Profit   (£15,492) (£3,343) £8,919 £21,304 £33,820 £46,475 £59,279 £72,241 £85,370 £98,676 £112,168
Real Return on Investment %   (11.49%) (2.48%) 6.62% 15.80% 25.09% 34.48% 43.98% 53.59% 63.33% 73.20% 83.21%