NE71 Wooler cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £229,287
Input Equity (£57,322)
Total Input Equity (£57,322)
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 £229,287 £229,287 £229,287 £229,287 £229,287 £229,287 £229,287 £229,287 £229,287 £229,287 £229,287 £229,287
Finance Amount £171,965 £171,965 £166,828 £161,428 £155,752 £149,785 £143,513 £136,921 £129,990 £122,706 £115,049 £106,999
Monthly Mortgage   (£1,135) (£1,135) (£1,135) (£1,135) (£1,135) (£1,135) (£1,135) (£1,135) (£1,135) (£1,135) (£1,135)
Monthly Rental   £614 £614 £614 £614 £614 £614 £614 £614 £614 £614 £614
Yield to Purchase Price %   3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21%
Yield to Property Value %   3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21% 3.21%
Gross Monthly Cashflow   (£521) (£521) (£521) (£521) (£521) (£521) (£521) (£521) (£521) (£521) (£521)
Gross Annual Cashflow   (£6,251) (£6,251) (£6,251) (£6,251) (£6,251) (£6,251) (£6,251) (£6,251) (£6,251) (£6,251) (£6,251)
Gross Annual Expenses                        
Annual Management Expenses   (£413) (£413) (£413) (£413) (£413) (£413) (£413) (£413) (£413) (£413) (£413)
Gross Annual Cashflow less Expenses   (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620)
Vacancy Expenses                        
Net Annual Cashflow   (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620) (£6,620)
Net Yield %   (2.89%) (2.89%) (2.89%) (2.89%) (2.89%) (2.89%) (2.89%) (2.89%) (2.89%) (2.89%) (2.89%)
Debt Coverage Ratio (1:x)   0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51 0.51
Personal Equity £57,322 £57,322 £62,459 £67,859 £73,535 £79,502 £85,774 £92,366 £99,297 £106,581 £114,239 £122,288
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   (£6,664) (£1,527) £3,873 £9,549 £15,516 £21,788 £28,381 £35,311 £42,596 £50,253 £58,302
Return on Investment %   (11.63%) (2.66%) 6.76% 16.66% 27.07% 38.01% 49.51% 61.60% 74.31% 87.67% 101.71%
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   (£6,664) (£1,496) £3,720 £8,988 £14,312 £19,695 £25,141 £30,654 £36,239 £41,898 £47,637
Real Return on Investment %   (11.63%) (2.61%) 6.49% 15.68% 24.97% 34.36% 43.86% 53.48% 63.22% 73.09% 83.10%