MK46 Clifton Reynes, Cold Brayfield, Emberton, Lavendon, Olney, Ravenstone, Warrington, Weston Underwood cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £474,526
Input Equity (£118,632)
Total Input Equity (£118,632)
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 £474,526 £474,526 £474,526 £474,526 £474,526 £474,526 £474,526 £474,526 £474,526 £474,526 £474,526 £474,526
Finance Amount £355,895 £355,895 £345,263 £334,087 £322,340 £309,991 £297,011 £283,367 £269,025 £253,949 £238,101 £221,443
Monthly Mortgage   (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349)
Monthly Rental   £929 £929 £929 £929 £929 £929 £929 £929 £929 £929 £929
Yield to Purchase Price %   2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35%
Yield to Property Value %   2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35% 2.35%
Gross Monthly Cashflow   (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420) (£1,420)
Gross Annual Cashflow   (£17,039) (£17,039) (£17,039) (£17,039) (£17,039) (£17,039) (£17,039) (£17,039) (£17,039) (£17,039) (£17,039)
Gross Annual Expenses                        
Annual Management Expenses   (£624) (£624) (£624) (£624) (£624) (£624) (£624) (£624) (£624) (£624) (£624)
Gross Annual Cashflow less Expenses   (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596)
Vacancy Expenses                        
Net Annual Cashflow   (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596) (£17,596)
Net Yield %   (3.71%) (3.71%) (3.71%) (3.71%) (3.71%) (3.71%) (3.71%) (3.71%) (3.71%) (3.71%) (3.71%)
Debt Coverage Ratio (1:x)   0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38
Personal Equity £118,632 £118,632 £129,263 £140,439 £152,186 £164,535 £177,515 £191,159 £205,501 £220,577 £236,425 £253,083
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   (£17,663) (£7,032) £4,144 £15,891 £28,240 £41,220 £54,864 £69,207 £84,283 £100,130 £116,788
Return on Investment %   (14.89%) (5.93%) 3.49% 13.40% 23.80% 34.75% 46.25% 58.34% 71.05% 84.40% 98.45%
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   (£17,663) (£6,891) £3,980 £14,957 £26,047 £37,260 £48,601 £60,080 £71,705 £83,483 £95,425
Real Return on Investment %   (14.89%) (5.81%) 3.35% 12.61% 21.96% 31.41% 40.97% 50.64% 60.44% 70.37% 80.44%