NE11 Dunston, Metro Centre, Team Valley, Kibblesworth cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £141,885
Input Equity (£35,471)
Total Input Equity (£35,471)
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 £141,885 £141,885 £141,885 £141,885 £141,885 £141,885 £141,885 £141,885 £141,885 £141,885 £141,885 £141,885
Finance Amount £106,414 £106,414 £103,235 £99,893 £96,381 £92,689 £88,807 £84,728 £80,439 £75,932 £71,193 £66,212
Monthly Mortgage   (£702) (£702) (£702) (£702) (£702) (£702) (£702) (£702) (£702) (£702) (£702)
Monthly Rental   £589 £589 £589 £589 £589 £589 £589 £589 £589 £589 £589
Yield to Purchase Price %   4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98%
Yield to Property Value %   4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98% 4.98%
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   (£396) (£396) (£396) (£396) (£396) (£396) (£396) (£396) (£396) (£396) (£396)
Gross Annual Cashflow less Expenses   (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713)
Vacancy Expenses                        
Net Annual Cashflow   (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713) (£1,713)
Net Yield %   (1.21%) (1.21%) (1.21%) (1.21%) (1.21%) (1.21%) (1.21%) (1.21%) (1.21%) (1.21%) (1.21%)
Debt Coverage Ratio (1:x)   0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80 0.80
Personal Equity £35,471 £35,471 £38,650 £41,992 £45,504 £49,196 £53,078 £57,157 £61,446 £65,953 £70,692 £75,673
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,755) £1,424 £4,765 £8,278 £11,970 £15,851 £19,931 £24,219 £28,727 £33,465 £38,446
Return on Investment %   (4.95%) 4.01% 13.43% 23.34% 33.75% 44.69% 56.19% 68.28% 80.99% 94.34% 108.39%
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,755) £1,395 £4,576 £7,791 £11,041 £14,328 £17,655 £21,025 £24,440 £27,902 £31,413
Real Return on Investment %   (4.95%) 3.93% 12.90% 21.96% 31.13% 40.39% 49.77% 59.27% 68.90% 78.66% 88.56%