NG33 Grantham, Castle Bytham, Corby Glen cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £278,705
Input Equity (£69,676)
Total Input Equity (£69,676)
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 £278,705 £278,705 £278,705 £278,705 £278,705 £278,705 £278,705 £278,705 £278,705 £278,705 £278,705 £278,705
Finance Amount £209,029 £209,029 £202,784 £196,221 £189,321 £182,068 £174,445 £166,431 £158,007 £149,153 £139,845 £130,061
Monthly Mortgage   (£1,379) (£1,379) (£1,379) (£1,379) (£1,379) (£1,379) (£1,379) (£1,379) (£1,379) (£1,379) (£1,379)
Monthly Rental   £667 £667 £667 £667 £667 £667 £667 £667 £667 £667 £667
Yield to Purchase Price %   2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87%
Yield to Property Value %   2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87%
Gross Monthly Cashflow   (£713) (£713) (£713) (£713) (£713) (£713) (£713) (£713) (£713) (£713) (£713)
Gross Annual Cashflow   (£8,551) (£8,551) (£8,551) (£8,551) (£8,551) (£8,551) (£8,551) (£8,551) (£8,551) (£8,551) (£8,551)
Gross Annual Expenses                        
Annual Management Expenses   (£448) (£448) (£448) (£448) (£448) (£448) (£448) (£448) (£448) (£448) (£448)
Gross Annual Cashflow less Expenses   (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951)
Vacancy Expenses                        
Net Annual Cashflow   (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951) (£8,951)
Net Yield %   (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%) (3.21%)
Debt Coverage Ratio (1:x)   0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46
Personal Equity £69,676 £69,676 £75,921 £82,484 £89,384 £96,637 £104,260 £112,274 £120,698 £129,552 £138,860 £148,644
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   (£8,999) (£2,755) £3,809 £10,709 £17,962 £25,585 £33,599 £42,023 £50,877 £60,185 £69,969
Return on Investment %   (12.92%) (3.95%) 5.47% 15.37% 25.78% 36.72% 48.22% 60.31% 73.02% 86.38% 100.42%
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   (£8,999) (£2,699) £3,658 £10,079 £16,567 £23,127 £29,763 £36,481 £43,285 £50,179 £57,170
Real Return on Investment %   (12.92%) (3.87%) 5.25% 14.47% 23.78% 33.19% 42.72% 52.36% 62.12% 72.02% 82.05%