MK13 Bancroft/Bancroft Park, Bluebridge, Bradwell and Bradwell Abbey, Bradwell Common, New Bradwell, Heelands, Stonebridge cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £196,911
Input Equity (£49,228)
Total Input Equity (£49,228)
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 £196,911 £196,911 £196,911 £196,911 £196,911 £196,911 £196,911 £196,911 £196,911 £196,911 £196,911 £196,911
Finance Amount £147,683 £147,683 £143,271 £138,634 £133,759 £128,635 £123,249 £117,587 £111,635 £105,379 £98,803 £91,891
Monthly Mortgage   (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975)
Monthly Rental   £886 £886 £886 £886 £886 £886 £886 £886 £886 £886 £886
Yield to Purchase Price %   5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40%
Yield to Property Value %   5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40% 5.40%
Gross Monthly Cashflow   (£88) (£88) (£88) (£88) (£88) (£88) (£88) (£88) (£88) (£88) (£88)
Gross Annual Cashflow   (£1,061) (£1,061) (£1,061) (£1,061) (£1,061) (£1,061) (£1,061) (£1,061) (£1,061) (£1,061) (£1,061)
Gross Annual Expenses                        
Annual Management Expenses   (£596) (£596) (£596) (£596) (£596) (£596) (£596) (£596) (£596) (£596) (£596)
Gross Annual Cashflow less Expenses   (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593)
Vacancy Expenses                        
Net Annual Cashflow   (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593) (£1,593)
Net Yield %   (0.81%) (0.81%) (0.81%) (0.81%) (0.81%) (0.81%) (0.81%) (0.81%) (0.81%) (0.81%) (0.81%)
Debt Coverage Ratio (1:x)   0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86 0.86
Personal Equity £49,228 £49,228 £53,640 £58,277 £63,152 £68,276 £73,662 £79,324 £85,276 £91,532 £98,108 £105,020
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   (£1,657) £2,755 £7,393 £12,267 £17,392 £22,778 £28,440 £34,391 £40,647 £47,223 £54,136
Return on Investment %   (3.37%) 5.60% 15.02% 24.92% 35.33% 46.27% 57.77% 69.86% 82.57% 95.93% 109.97%
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   (£1,657) £2,700 £7,100 £11,546 £16,041 £20,589 £25,193 £29,856 £34,581 £39,372 £44,233
Real Return on Investment %   (3.37%) 5.48% 14.42% 23.45% 32.59% 41.82% 51.18% 60.65% 70.25% 79.98% 89.85%