NE3 Gosforth, Fawdon, Kingston Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £169,383
Input Equity (£42,346)
Total Input Equity (£42,346)
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 £169,383 £169,383 £169,383 £169,383 £169,383 £169,383 £169,383 £169,383 £169,383 £169,383 £169,383 £169,383
Finance Amount £127,037 £127,037 £123,242 £119,253 £115,060 £110,652 £106,019 £101,148 £96,029 £90,647 £84,991 £79,045
Monthly Mortgage   (£838) (£838) (£838) (£838) (£838) (£838) (£838) (£838) (£838) (£838) (£838)
Monthly Rental   £672 £672 £672 £672 £672 £672 £672 £672 £672 £672 £672
Yield to Purchase Price %   4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76%
Yield to Property Value %   4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76% 4.76%
Gross Monthly Cashflow   (£167) (£167) (£167) (£167) (£167) (£167) (£167) (£167) (£167) (£167) (£167)
Gross Annual Cashflow   (£2,002) (£2,002) (£2,002) (£2,002) (£2,002) (£2,002) (£2,002) (£2,002) (£2,002) (£2,002) (£2,002)
Gross Annual Expenses                        
Annual Management Expenses   (£451) (£451) (£451) (£451) (£451) (£451) (£451) (£451) (£451) (£451) (£451)
Gross Annual Cashflow less Expenses   (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405)
Vacancy Expenses                        
Net Annual Cashflow   (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405) (£2,405)
Net Yield %   (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%) (1.42%)
Debt Coverage Ratio (1:x)   0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76 0.76
Personal Equity £42,346 £42,346 £46,141 £50,130 £54,323 £58,731 £63,364 £68,235 £73,354 £78,736 £84,392 £90,338
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   (£2,453) £1,342 £5,331 £9,524 £13,932 £18,565 £23,435 £28,555 £33,936 £39,593 £45,539
Return on Investment %   (5.79%) 3.17% 12.59% 22.49% 32.90% 43.84% 55.34% 67.43% 80.14% 93.50% 107.54%
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   (£2,453) £1,315 £5,120 £8,964 £12,850 £16,781 £20,760 £24,789 £28,872 £33,011 £37,209
Real Return on Investment %   (5.79%) 3.10% 12.09% 21.17% 30.35% 39.63% 49.03% 58.54% 68.18% 77.96% 87.87%