NG17 Sutton-in-Ashfield, Kirkby-in-Ashfield, Stanton Hill, Skegby cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £131,112
Input Equity (£32,778)
Total Input Equity (£32,778)
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 £131,112 £131,112 £131,112 £131,112 £131,112 £131,112 £131,112 £131,112 £131,112 £131,112 £131,112 £131,112
Finance Amount £98,334 £98,334 £95,396 £92,309 £89,063 £85,651 £82,065 £78,295 £74,332 £70,166 £65,788 £61,185
Monthly Mortgage   (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649) (£649)
Monthly Rental   £511 £511 £511 £511 £511 £511 £511 £511 £511 £511 £511
Yield to Purchase Price %   4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67%
Yield to Property Value %   4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67% 4.67%
Gross Monthly Cashflow   (£138) (£138) (£138) (£138) (£138) (£138) (£138) (£138) (£138) (£138) (£138)
Gross Annual Cashflow   (£1,659) (£1,659) (£1,659) (£1,659) (£1,659) (£1,659) (£1,659) (£1,659) (£1,659) (£1,659) (£1,659)
Gross Annual Expenses                        
Annual Management Expenses   (£343) (£343) (£343) (£343) (£343) (£343) (£343) (£343) (£343) (£343) (£343)
Gross Annual Cashflow less Expenses   (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966)
Vacancy Expenses                        
Net Annual Cashflow   (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966) (£1,966)
Net Yield %   (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%)
Debt Coverage Ratio (1:x)   0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75
Personal Equity £32,778 £32,778 £35,716 £38,803 £42,049 £45,461 £49,047 £52,817 £56,780 £60,946 £65,324 £69,927
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,002) £935 £4,023 £7,269 £10,681 £14,267 £18,037 £22,000 £26,165 £30,544 £35,147
Return on Investment %   (6.11%) 2.85% 12.27% 22.18% 32.58% 43.53% 55.03% 67.12% 79.83% 93.18% 107.23%
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,002) £916 £3,864 £6,841 £9,851 £12,896 £15,978 £19,099 £22,260 £25,466 £28,717
Real Return on Investment %   (6.11%) 2.80% 11.79% 20.87% 30.06% 39.34% 48.75% 58.27% 67.91% 77.69% 87.61%