LN12 Mablethorpe, Sutton-on-Sea cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £201,990
Input Equity (£50,498)
Total Input Equity (£50,498)
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 £201,990 £201,990 £201,990 £201,990 £201,990 £201,990 £201,990 £201,990 £201,990 £201,990 £201,990 £201,990
Finance Amount £151,493 £151,493 £146,967 £142,210 £137,209 £131,953 £126,428 £120,620 £114,515 £108,098 £101,352 £94,261
Monthly Mortgage   (£1,000) (£1,000) (£1,000) (£1,000) (£1,000) (£1,000) (£1,000) (£1,000) (£1,000) (£1,000) (£1,000)
Monthly Rental   £527 £527 £527 £527 £527 £527 £527 £527 £527 £527 £527
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   (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473) (£473)
Gross Annual Cashflow   (£5,679) (£5,679) (£5,679) (£5,679) (£5,679) (£5,679) (£5,679) (£5,679) (£5,679) (£5,679) (£5,679)
Gross Annual Expenses                        
Annual Management Expenses   (£354) (£354) (£354) (£354) (£354) (£354) (£354) (£354) (£354) (£354) (£354)
Gross Annual Cashflow less Expenses   (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995)
Vacancy Expenses                        
Net Annual Cashflow   (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995) (£5,995)
Net Yield %   (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%) (2.97%)
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 £50,498 £50,498 £55,023 £59,780 £64,781 £70,037 £75,562 £81,370 £87,475 £93,893 £100,638 £107,729
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,033) (£1,507) £3,250 £8,250 £13,507 £19,032 £24,840 £30,945 £37,362 £44,108 £51,199
Return on Investment %   (11.95%) (2.98%) 6.44% 16.34% 26.75% 37.69% 49.19% 61.28% 73.99% 87.35% 101.39%
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,033) (£1,477) £3,121 £7,765 £12,458 £17,203 £22,004 £26,864 £31,786 £36,775 £41,833
Real Return on Investment %   (11.95%) (2.93%) 6.18% 15.38% 24.67% 34.07% 43.57% 53.20% 62.95% 72.83% 82.84%