NG7 New Basford, Forest Fields, Hyson Green, Radford, Lenton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £144,497
Input Equity (£36,124)
Total Input Equity (£36,124)
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 £144,497 £144,497 £144,497 £144,497 £144,497 £144,497 £144,497 £144,497 £144,497 £144,497 £144,497 £144,497
Finance Amount £108,373 £108,373 £105,135 £101,732 £98,155 £94,395 £90,442 £86,288 £81,920 £77,329 £72,504 £67,431
Monthly Mortgage   (£715) (£715) (£715) (£715) (£715) (£715) (£715) (£715) (£715) (£715) (£715)
Monthly Rental   £608 £608 £608 £608 £608 £608 £608 £608 £608 £608 £608
Yield to Purchase Price %   5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05%
Yield to Property Value %   5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05% 5.05%
Gross Monthly Cashflow   (£107) (£107) (£107) (£107) (£107) (£107) (£107) (£107) (£107) (£107) (£107)
Gross Annual Cashflow   (£1,289) (£1,289) (£1,289) (£1,289) (£1,289) (£1,289) (£1,289) (£1,289) (£1,289) (£1,289) (£1,289)
Gross Annual Expenses                        
Annual Management Expenses   (£408) (£408) (£408) (£408) (£408) (£408) (£408) (£408) (£408) (£408) (£408)
Gross Annual Cashflow less Expenses   (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654)
Vacancy Expenses                        
Net Annual Cashflow   (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654) (£1,654)
Net Yield %   (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%) (1.14%)
Debt Coverage Ratio (1:x)   0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81 0.81
Personal Equity £36,124 £36,124 £39,362 £42,765 £46,342 £50,102 £54,055 £58,209 £62,577 £67,168 £71,993 £77,066
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,698) £1,540 £4,943 £8,520 £12,280 £16,233 £20,388 £24,755 £29,346 £34,171 £39,244
Return on Investment %   (4.70%) 4.26% 13.68% 23.59% 33.99% 44.94% 56.44% 68.53% 81.24% 94.59% 108.64%
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,698) £1,509 £4,747 £8,019 £11,327 £14,673 £18,060 £21,490 £24,966 £28,490 £32,065
Real Return on Investment %   (4.70%) 4.18% 13.14% 22.20% 31.36% 40.62% 49.99% 59.49% 69.11% 78.87% 88.76%