NE21 Blaydon, Winlaton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £141,533
Input Equity (£35,383)
Total Input Equity (£35,383)
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 £141,533 £141,533 £141,533 £141,533 £141,533 £141,533 £141,533 £141,533 £141,533 £141,533 £141,533 £141,533
Finance Amount £106,150 £106,150 £102,979 £99,645 £96,142 £92,459 £88,587 £84,518 £80,240 £75,743 £71,016 £66,048
Monthly Mortgage   (£701) (£701) (£701) (£701) (£701) (£701) (£701) (£701) (£701) (£701) (£701)
Monthly Rental   £505 £505 £505 £505 £505 £505 £505 £505 £505 £505 £505
Yield to Purchase Price %   4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28%
Yield to Property Value %   4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28% 4.28%
Gross Monthly Cashflow   (£196) (£196) (£196) (£196) (£196) (£196) (£196) (£196) (£196) (£196) (£196)
Gross Annual Cashflow   (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349) (£2,349)
Gross Annual Expenses                        
Annual Management Expenses   (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339) (£339)
Gross Annual Cashflow less Expenses   (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651)
Vacancy Expenses                        
Net Annual Cashflow   (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651) (£2,651)
Net Yield %   (1.87%) (1.87%) (1.87%) (1.87%) (1.87%) (1.87%) (1.87%) (1.87%) (1.87%) (1.87%) (1.87%)
Debt Coverage Ratio (1:x)   0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68
Personal Equity £35,383 £35,383 £38,554 £41,888 £45,391 £49,074 £52,946 £57,015 £61,293 £65,790 £70,517 £75,485
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   (£2,688) £483 £3,816 £7,320 £11,003 £14,875 £18,944 £23,222 £27,719 £32,445 £37,414
Return on Investment %   (7.60%) 1.37% 10.79% 20.69% 31.10% 42.04% 53.54% 65.63% 78.34% 91.70% 105.74%
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   (£2,688) £474 £3,665 £6,890 £10,149 £13,446 £16,782 £20,160 £23,582 £27,051 £30,570
Real Return on Investment %   (7.60%) 1.34% 10.36% 19.47% 28.68% 38.00% 47.43% 56.98% 66.65% 76.45% 86.40%