NG16 Kimberley, Eastwood, Nuthall, Langley Mill, Pinxton, Selston, Awsworth, Ironville, Jacksdale, Underwood, Brinsley, Watnall cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £157,829
Input Equity (£39,457)
Total Input Equity (£39,457)
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 £157,829 £157,829 £157,829 £157,829 £157,829 £157,829 £157,829 £157,829 £157,829 £157,829 £157,829 £157,829
Finance Amount £118,372 £118,372 £114,836 £111,119 £107,211 £103,104 £98,787 £94,249 £89,479 £84,464 £79,193 £73,653
Monthly Mortgage   (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781)
Monthly Rental   £524 £524 £524 £524 £524 £524 £524 £524 £524 £524 £524
Yield to Purchase Price %   3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98%
Yield to Property Value %   3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98% 3.98%
Gross Monthly Cashflow   (£258) (£258) (£258) (£258) (£258) (£258) (£258) (£258) (£258) (£258) (£258)
Gross Annual Cashflow   (£3,092) (£3,092) (£3,092) (£3,092) (£3,092) (£3,092) (£3,092) (£3,092) (£3,092) (£3,092) (£3,092)
Gross Annual Expenses                        
Annual Management Expenses   (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352) (£352)
Gross Annual Cashflow less Expenses   (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406)
Vacancy Expenses                        
Net Annual Cashflow   (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406) (£3,406)
Net Yield %   (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%) (2.16%)
Debt Coverage Ratio (1:x)   0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64 0.64
Personal Equity £39,457 £39,457 £42,993 £46,710 £50,618 £54,725 £59,042 £63,580 £68,350 £73,365 £78,636 £84,176
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   (£3,444) £92 £3,809 £7,716 £11,823 £16,141 £20,679 £25,449 £30,463 £35,734 £41,275
Return on Investment %   (8.73%) 0.23% 9.65% 19.56% 29.97% 40.91% 52.41% 64.50% 77.21% 90.56% 104.61%
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   (£3,444) £90 £3,658 £7,263 £10,906 £14,590 £18,318 £22,093 £25,917 £29,793 £33,725
Real Return on Investment %   (8.73%) 0.23% 9.27% 18.41% 27.64% 36.98% 46.43% 55.99% 65.68% 75.51% 85.47%