NG5 Sherwood, Arnold, Bestwood, Carrington, Top Valley, Rise Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £135,333
Input Equity (£33,833)
Total Input Equity (£33,833)
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 £135,333 £135,333 £135,333 £135,333 £135,333 £135,333 £135,333 £135,333 £135,333 £135,333 £135,333 £135,333
Finance Amount £101,500 £101,500 £98,468 £95,280 £91,930 £88,408 £84,706 £80,815 £76,725 £72,425 £67,906 £63,155
Monthly Mortgage   (£670) (£670) (£670) (£670) (£670) (£670) (£670) (£670) (£670) (£670) (£670)
Monthly Rental   £560 £560 £560 £560 £560 £560 £560 £560 £560 £560 £560
Yield to Purchase Price %   4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97%
Yield to Property Value %   4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97% 4.97%
Gross Monthly Cashflow   (£109) (£109) (£109) (£109) (£109) (£109) (£109) (£109) (£109) (£109) (£109)
Gross Annual Cashflow   (£1,313) (£1,313) (£1,313) (£1,313) (£1,313) (£1,313) (£1,313) (£1,313) (£1,313) (£1,313) (£1,313)
Gross Annual Expenses                        
Annual Management Expenses   (£377) (£377) (£377) (£377) (£377) (£377) (£377) (£377) (£377) (£377) (£377)
Gross Annual Cashflow less Expenses   (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649)
Vacancy Expenses                        
Net Annual Cashflow   (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649) (£1,649)
Net Yield %   (1.22%) (1.22%) (1.22%) (1.22%) (1.22%) (1.22%) (1.22%) (1.22%) (1.22%) (1.22%) (1.22%)
Debt Coverage Ratio (1:x)   0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79 0.79
Personal Equity £33,833 £33,833 £36,865 £40,053 £43,403 £46,925 £50,627 £54,518 £58,608 £62,908 £67,427 £72,178
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,689) £1,343 £4,530 £7,880 £11,402 £15,104 £18,995 £23,086 £27,385 £31,905 £36,656
Return on Investment %   (4.99%) 3.97% 13.39% 23.29% 33.70% 44.64% 56.14% 68.23% 80.94% 94.30% 108.34%
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,689) £1,316 £4,351 £7,417 £10,517 £13,653 £16,827 £20,041 £23,298 £26,601 £29,950
Real Return on Investment %   (4.99%) 3.89% 12.86% 21.92% 31.08% 40.35% 49.73% 59.24% 68.86% 78.62% 88.52%