NG34 Sleaford cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £244,867
Input Equity (£61,217)
Total Input Equity (£61,217)
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 £244,867 £244,867 £244,867 £244,867 £244,867 £244,867 £244,867 £244,867 £244,867 £244,867 £244,867 £244,867
Finance Amount £183,650 £183,650 £178,164 £172,397 £166,335 £159,963 £153,265 £146,224 £138,823 £131,044 £122,866 £114,270
Monthly Mortgage   (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212)
Monthly Rental   £621 £621 £621 £621 £621 £621 £621 £621 £621 £621 £621
Yield to Purchase Price %   3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05%
Yield to Property Value %   3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05%
Gross Monthly Cashflow   (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591)
Gross Annual Cashflow   (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087) (£7,087)
Gross Annual Expenses                        
Annual Management Expenses   (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418) (£418)
Gross Annual Cashflow less Expenses   (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460)
Vacancy Expenses                        
Net Annual Cashflow   (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460) (£7,460)
Net Yield %   (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%)
Debt Coverage Ratio (1:x)   0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49
Personal Equity £61,217 £61,217 £66,703 £72,470 £78,532 £84,904 £91,602 £98,643 £106,044 £113,823 £122,001 £130,597
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   (£7,505) (£2,019) £3,748 £9,810 £16,182 £22,880 £29,921 £37,322 £45,102 £53,279 £61,875
Return on Investment %   (12.26%) (3.30%) 6.12% 16.03% 26.43% 37.38% 48.88% 60.97% 73.68% 87.03% 101.08%
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   (£7,505) (£1,978) £3,600 £9,233 £14,926 £20,682 £26,505 £32,400 £38,371 £44,422 £50,557
Real Return on Investment %   (12.26%) (3.23%) 5.88% 15.08% 24.38% 33.78% 43.30% 52.93% 62.68% 72.56% 82.59%