NG4 Carlton, Gedling Village, Netherfield cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £177,248
Input Equity (£44,312)
Total Input Equity (£44,312)
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 £177,248 £177,248 £177,248 £177,248 £177,248 £177,248 £177,248 £177,248 £177,248 £177,248 £177,248 £177,248
Finance Amount £132,936 £132,936 £128,965 £124,790 £120,402 £115,790 £110,942 £105,845 £100,488 £94,857 £88,937 £82,715
Monthly Mortgage   (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877)
Monthly Rental   £631 £631 £631 £631 £631 £631 £631 £631 £631 £631 £631
Yield to Purchase Price %   4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27%
Yield to Property Value %   4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27%
Gross Monthly Cashflow   (£247) (£247) (£247) (£247) (£247) (£247) (£247) (£247) (£247) (£247) (£247)
Gross Annual Cashflow   (£2,961) (£2,961) (£2,961) (£2,961) (£2,961) (£2,961) (£2,961) (£2,961) (£2,961) (£2,961) (£2,961)
Gross Annual Expenses                        
Annual Management Expenses   (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424) (£424)
Gross Annual Cashflow less Expenses   (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339)
Vacancy Expenses                        
Net Annual Cashflow   (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339) (£3,339)
Net Yield %   (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%)
Debt Coverage Ratio (1:x)   0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68
Personal Equity £44,312 £44,312 £48,283 £52,458 £56,846 £61,458 £66,306 £71,403 £76,760 £82,391 £88,311 £94,533
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,384) £587 £4,761 £9,149 £13,762 £18,610 £23,707 £29,064 £34,695 £40,615 £46,837
Return on Investment %   (7.64%) 1.32% 10.75% 20.65% 31.06% 42.00% 53.50% 65.59% 78.30% 91.66% 105.70%
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,384) £575 £4,573 £8,611 £12,693 £16,822 £21,000 £25,231 £29,517 £33,862 £38,269
Real Return on Investment %   (7.64%) 1.30% 10.32% 19.43% 28.65% 37.96% 47.39% 56.94% 66.61% 76.42% 86.36%