MK11 Fullers Slade, Galley Hill, Kiln Farm, Stony Stratford cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £249,576
Input Equity (£62,394)
Input Equity FX (£62,394)
Total Input Equity (£62,394)
Total Input Equity FX (£62,394)
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 £249,576 £249,576 £249,576 £249,576 £249,576 £249,576 £249,576 £249,576 £249,576 £249,576 £249,576 £249,576
Finance Amount £187,182 £187,182 £181,590 £175,713 £169,534 £163,039 £156,212 £149,036 £141,493 £133,564 £125,229 £116,467
Monthly Mortgage   (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235)
Monthly Rental   £913 £913 £913 £913 £913 £913 £913 £913 £913 £913 £913
Yield to Purchase Price %   4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39%
Yield to Property Value %   4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39% 4.39%
Gross Monthly Cashflow   (£322) (£322) (£322) (£322) (£322) (£322) (£322) (£322) (£322) (£322) (£322)
Gross Annual Cashflow   (£3,864) (£3,864) (£3,864) (£3,864) (£3,864) (£3,864) (£3,864) (£3,864) (£3,864) (£3,864) (£3,864)
Gross Annual Expenses                        
Annual Management Expenses   (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614) (£614)
Gross Annual Cashflow less Expenses   (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412)
Vacancy Expenses                        
Net Annual Cashflow   (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412) (£4,412)
Net Yield %   (1.77%) (1.77%) (1.77%) (1.77%) (1.77%) (1.77%) (1.77%) (1.77%) (1.77%) (1.77%) (1.77%)
Debt Coverage Ratio (1:x)   0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70 0.70
Personal Equity £62,394 £62,394 £67,986 £73,864 £80,042 £86,537 £93,364 £100,540 £108,083 £116,012 £124,347 £133,109
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   (£4,477) £1,114 £6,992 £13,171 £19,665 £26,492 £33,668 £41,212 £49,141 £57,476 £66,237
Return on Investment %   (7.18%) 1.79% 11.21% 21.11% 31.52% 42.46% 53.96% 66.05% 78.76% 92.12% 106.16%
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   (£4,477) £1,092 £6,715 £12,396 £18,139 £23,947 £29,825 £35,777 £41,807 £47,920 £54,121
Real Return on Investment %   (7.18%) 1.75% 10.76% 19.87% 29.07% 38.38% 47.80% 57.34% 67.01% 76.80% 86.74%