NE12 Killingworth cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £143,797
Input Equity (£35,949)
Total Input Equity (£35,949)
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 £143,797 £143,797 £143,797 £143,797 £143,797 £143,797 £143,797 £143,797 £143,797 £143,797 £143,797 £143,797
Finance Amount £107,848 £107,848 £104,626 £101,239 £97,680 £93,938 £90,004 £85,870 £81,523 £76,955 £72,152 £67,105
Monthly Mortgage   (£712) (£712) (£712) (£712) (£712) (£712) (£712) (£712) (£712) (£712) (£712)
Monthly Rental   £582 £582 £582 £582 £582 £582 £582 £582 £582 £582 £582
Yield to Purchase Price %   4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86%
Yield to Property Value %   4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86% 4.86%
Gross Monthly Cashflow   (£129) (£129) (£129) (£129) (£129) (£129) (£129) (£129) (£129) (£129) (£129)
Gross Annual Cashflow   (£1,551) (£1,551) (£1,551) (£1,551) (£1,551) (£1,551) (£1,551) (£1,551) (£1,551) (£1,551) (£1,551)
Gross Annual Expenses                        
Annual Management Expenses   (£391) (£391) (£391) (£391) (£391) (£391) (£391) (£391) (£391) (£391) (£391)
Gross Annual Cashflow less Expenses   (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901)
Vacancy Expenses                        
Net Annual Cashflow   (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901) (£1,901)
Net Yield %   (1.32%) (1.32%) (1.32%) (1.32%) (1.32%) (1.32%) (1.32%) (1.32%) (1.32%) (1.32%) (1.32%)
Debt Coverage Ratio (1:x)   0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78 0.78
Personal Equity £35,949 £35,949 £39,171 £42,558 £46,117 £49,859 £53,793 £57,927 £62,274 £66,842 £71,645 £76,692
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   (£1,943) £1,279 £4,666 £8,226 £11,968 £15,901 £20,036 £24,382 £28,950 £33,753 £38,801
Return on Investment %   (5.40%) 3.56% 12.98% 22.88% 33.29% 44.23% 55.73% 67.82% 80.53% 93.89% 107.93%
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   (£1,943) £1,254 £4,481 £7,742 £11,038 £14,373 £17,748 £21,166 £24,630 £28,141 £31,703
Real Return on Investment %   (5.40%) 3.49% 12.46% 21.54% 30.71% 39.98% 49.37% 58.88% 68.51% 78.28% 88.19%