NN4 Brackmills, East Hunsbury, West Hunsbury, Great Houghton, Hardingstone, Wootton, Grange Park cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £253,127
Input Equity (£63,282)
Total Input Equity (£63,282)
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 £253,127 £253,127 £253,127 £253,127 £253,127 £253,127 £253,127 £253,127 £253,127 £253,127 £253,127 £253,127
Finance Amount £189,845 £189,845 £184,174 £178,213 £171,946 £165,359 £158,435 £151,157 £143,506 £135,464 £127,011 £118,125
Monthly Mortgage   (£1,253) (£1,253) (£1,253) (£1,253) (£1,253) (£1,253) (£1,253) (£1,253) (£1,253) (£1,253) (£1,253)
Monthly Rental   £879 £879 £879 £879 £879 £879 £879 £879 £879 £879 £879
Yield to Purchase Price %   4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17%
Yield to Property Value %   4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17% 4.17%
Gross Monthly Cashflow   (£374) (£374) (£374) (£374) (£374) (£374) (£374) (£374) (£374) (£374) (£374)
Gross Annual Cashflow   (£4,487) (£4,487) (£4,487) (£4,487) (£4,487) (£4,487) (£4,487) (£4,487) (£4,487) (£4,487) (£4,487)
Gross Annual Expenses                        
Annual Management Expenses   (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591) (£591)
Gross Annual Cashflow less Expenses   (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014)
Vacancy Expenses                        
Net Annual Cashflow   (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014) (£5,014)
Net Yield %   (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%) (1.98%)
Debt Coverage Ratio (1:x)   0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67 0.67
Personal Equity £63,282 £63,282 £68,953 £74,914 £81,181 £87,768 £94,692 £101,970 £109,621 £117,663 £126,116 £135,002
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   (£5,078) £594 £6,555 £12,821 £19,408 £26,332 £33,611 £41,261 £49,303 £57,757 £66,643
Return on Investment %   (8.02%) 0.94% 10.36% 20.26% 30.67% 41.61% 53.11% 65.20% 77.91% 91.27% 105.31%
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   (£5,078) £582 £6,295 £12,067 £17,902 £23,802 £29,774 £35,820 £41,945 £48,155 £54,452
Real Return on Investment %   (8.02%) 0.92% 9.95% 19.07% 28.29% 37.61% 47.05% 56.60% 66.28% 76.10% 86.05%