NE62 Scotland Gate, Guidepost, Stakeford, West Sleekburn, Bomarsund cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £94,991
Input Equity (£23,748)
Total Input Equity (£23,748)
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 £94,991 £94,991 £94,991 £94,991 £94,991 £94,991 £94,991 £94,991 £94,991 £94,991 £94,991 £94,991
Finance Amount £71,243 £71,243 £69,115 £66,878 £64,526 £62,054 £59,456 £56,725 £53,853 £50,836 £47,663 £44,329
Monthly Mortgage   (£470) (£470) (£470) (£470) (£470) (£470) (£470) (£470) (£470) (£470) (£470)
Monthly Rental   £370 £370 £370 £370 £370 £370 £370 £370 £370 £370 £370
Yield to Purchase Price %   4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68%
Yield to Property Value %   4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68% 4.68%
Gross Monthly Cashflow   (£100) (£100) (£100) (£100) (£100) (£100) (£100) (£100) (£100) (£100) (£100)
Gross Annual Cashflow   (£1,199) (£1,199) (£1,199) (£1,199) (£1,199) (£1,199) (£1,199) (£1,199) (£1,199) (£1,199) (£1,199)
Gross Annual Expenses                        
Annual Management Expenses   (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249) (£249)
Gross Annual Cashflow less Expenses   (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421)
Vacancy Expenses                        
Net Annual Cashflow   (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421) (£1,421)
Net Yield %   (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%) (1.50%)
Debt Coverage Ratio (1:x)   0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75
Personal Equity £23,748 £23,748 £25,876 £28,113 £30,465 £32,937 £35,535 £38,266 £41,137 £44,155 £47,328 £50,662
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,448) £680 £2,917 £5,269 £7,741 £10,339 £13,070 £15,942 £18,959 £22,132 £25,466
Return on Investment %   (6.10%) 2.86% 12.28% 22.19% 32.60% 43.54% 55.04% 67.13% 79.84% 93.20% 107.24%
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,448) £667 £2,802 £4,959 £7,140 £9,346 £11,578 £13,839 £16,130 £18,452 £20,808
Real Return on Investment %   (6.10%) 2.81% 11.80% 20.88% 30.07% 39.35% 48.76% 58.28% 67.92% 77.70% 87.62%