LN5 Waddon cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £217,968
Input Equity (£54,492)
Total Input Equity (£54,492)
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 £217,968 £217,968 £217,968 £217,968 £217,968 £217,968 £217,968 £217,968 £217,968 £217,968 £217,968 £217,968
Finance Amount £163,476 £163,476 £158,592 £153,459 £148,063 £142,391 £136,429 £130,161 £123,573 £116,648 £109,369 £101,717
Monthly Mortgage   (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079)
Monthly Rental   £647 £647 £647 £647 £647 £647 £647 £647 £647 £647 £647
Yield to Purchase Price %   3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56%
Yield to Property Value %   3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56% 3.56%
Gross Monthly Cashflow   (£432) (£432) (£432) (£432) (£432) (£432) (£432) (£432) (£432) (£432) (£432)
Gross Annual Cashflow   (£5,179) (£5,179) (£5,179) (£5,179) (£5,179) (£5,179) (£5,179) (£5,179) (£5,179) (£5,179) (£5,179)
Gross Annual Expenses                        
Annual Management Expenses   (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435)
Gross Annual Cashflow less Expenses   (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567)
Vacancy Expenses                        
Net Annual Cashflow   (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567) (£5,567)
Net Yield %   (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%) (2.55%)
Debt Coverage Ratio (1:x)   0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57
Personal Equity £54,492 £54,492 £59,376 £64,509 £69,905 £75,577 £81,539 £87,807 £94,395 £101,320 £108,599 £116,251
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   (£5,614) (£730) £4,403 £9,799 £15,471 £21,434 £27,701 £34,289 £41,214 £48,493 £56,145
Return on Investment %   (10.30%) (1.34%) 8.08% 17.98% 28.39% 39.33% 50.83% 62.92% 75.63% 88.99% 103.03%
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   (£5,614) (£716) £4,229 £9,223 £14,270 £19,374 £24,539 £29,767 £35,063 £40,431 £45,875
Real Return on Investment %   (10.30%) (1.31%) 7.76% 16.93% 26.19% 35.55% 45.03% 54.63% 64.35% 74.20% 84.19%