NE15 Lemington, Throckley, Newburn cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £235,846
Input Equity (£58,962)
Total Input Equity (£58,962)
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 £235,846 £235,846 £235,846 £235,846 £235,846 £235,846 £235,846 £235,846 £235,846 £235,846 £235,846 £235,846
Finance Amount £176,885 £176,885 £171,600 £166,046 £160,207 £154,070 £147,619 £140,837 £133,709 £126,216 £118,340 £110,060
Monthly Mortgage   (£1,167) (£1,167) (£1,167) (£1,167) (£1,167) (£1,167) (£1,167) (£1,167) (£1,167) (£1,167) (£1,167)
Monthly Rental   £616 £616 £616 £616 £616 £616 £616 £616 £616 £616 £616
Yield to Purchase Price %   3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13%
Yield to Property Value %   3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13% 3.13%
Gross Monthly Cashflow   (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552) (£552)
Gross Annual Cashflow   (£6,618) (£6,618) (£6,618) (£6,618) (£6,618) (£6,618) (£6,618) (£6,618) (£6,618) (£6,618) (£6,618)
Gross Annual Expenses                        
Annual Management Expenses   (£414) (£414) (£414) (£414) (£414) (£414) (£414) (£414) (£414) (£414) (£414)
Gross Annual Cashflow less Expenses   (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988)
Vacancy Expenses                        
Net Annual Cashflow   (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988) (£6,988)
Net Yield %   (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%) (2.96%)
Debt Coverage Ratio (1:x)   0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50
Personal Equity £58,962 £58,962 £64,246 £69,800 £75,639 £81,776 £88,227 £95,009 £102,137 £109,630 £117,506 £125,786
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   (£7,032) (£1,748) £3,806 £9,645 £15,782 £22,233 £29,015 £36,143 £43,636 £51,513 £59,792
Return on Investment %   (11.93%) (2.97%) 6.46% 16.36% 26.77% 37.71% 49.21% 61.30% 74.01% 87.37% 101.41%
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   (£7,032) (£1,713) £3,655 £9,078 £14,557 £20,097 £25,703 £31,377 £37,124 £42,949 £48,854
Real Return on Investment %   (11.93%) (2.91%) 6.20% 15.40% 24.69% 34.09% 43.59% 53.22% 62.96% 72.84% 82.86%