NG19 Mansfield Woodhouse cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £127,364
Input Equity (£31,841)
Input Equity FX (£31,841)
Total Input Equity (£31,841)
Total Input Equity FX (£31,841)
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 £127,364 £127,364 £127,364 £127,364 £127,364 £127,364 £127,364 £127,364 £127,364 £127,364 £127,364 £127,364
Finance Amount £95,523 £95,523 £92,669 £89,670 £86,517 £83,203 £79,719 £76,056 £72,207 £68,160 £63,907 £59,436
Monthly Mortgage   (£630) (£630) (£630) (£630) (£630) (£630) (£630) (£630) (£630) (£630) (£630)
Monthly Rental   £517 £517 £517 £517 £517 £517 £517 £517 £517 £517 £517
Yield to Purchase Price %   4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87%
Yield to Property Value %   4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87% 4.87%
Gross Monthly Cashflow   (£113) (£113) (£113) (£113) (£113) (£113) (£113) (£113) (£113) (£113) (£113)
Gross Annual Cashflow   (£1,360) (£1,360) (£1,360) (£1,360) (£1,360) (£1,360) (£1,360) (£1,360) (£1,360) (£1,360) (£1,360)
Gross Annual Expenses                        
Annual Management Expenses   (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347) (£347)
Gross Annual Cashflow less Expenses   (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670)
Vacancy Expenses                        
Net Annual Cashflow   (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670) (£1,670)
Net Yield %   (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%) (1.31%)
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 £31,841 £31,841 £34,695 £37,694 £40,847 £44,162 £47,645 £51,308 £55,157 £59,204 £63,457 £67,928
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,707) £1,146 £4,146 £7,299 £10,613 £14,097 £17,759 £21,609 £25,655 £29,909 £34,380
Return on Investment %   (5.36%) 3.60% 13.02% 22.92% 33.33% 44.27% 55.77% 67.86% 80.57% 93.93% 107.97%
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,707) £1,123 £3,982 £6,870 £9,789 £12,743 £15,732 £18,759 £21,826 £24,936 £28,091
Real Return on Investment %   (5.36%) 3.53% 12.50% 21.57% 30.74% 40.02% 49.41% 58.91% 68.55% 78.31% 88.22%