NE41 Wylam cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £213,901
Input Equity (£53,475)
Total Input Equity (£53,475)
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 £213,901 £213,901 £213,901 £213,901 £213,901 £213,901 £213,901 £213,901 £213,901 £213,901 £213,901 £213,901
Finance Amount £160,426 £160,426 £155,633 £150,596 £145,300 £139,734 £133,883 £127,733 £121,268 £114,472 £107,328 £99,819
Monthly Mortgage   (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059) (£1,059)
Monthly Rental   £553 £553 £553 £553 £553 £553 £553 £553 £553 £553 £553
Yield to Purchase Price %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Yield to Property Value %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Gross Monthly Cashflow   (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505) (£505)
Gross Annual Cashflow   (£6,063) (£6,063) (£6,063) (£6,063) (£6,063) (£6,063) (£6,063) (£6,063) (£6,063) (£6,063) (£6,063)
Gross Annual Expenses                        
Annual Management Expenses   (£372) (£372) (£372) (£372) (£372) (£372) (£372) (£372) (£372) (£372) (£372)
Gross Annual Cashflow less Expenses   (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395)
Vacancy Expenses                        
Net Annual Cashflow   (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395) (£6,395)
Net Yield %   (2.99%) (2.99%) (2.99%) (2.99%) (2.99%) (2.99%) (2.99%) (2.99%) (2.99%) (2.99%) (2.99%)
Debt Coverage Ratio (1:x)   0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50
Personal Equity £53,475 £53,475 £58,268 £63,305 £68,601 £74,167 £80,018 £86,168 £92,633 £99,429 £106,573 £114,082
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   (£6,435) (£1,643) £3,395 £8,690 £14,257 £20,108 £26,258 £32,723 £39,519 £46,662 £54,171
Return on Investment %   (12.03%) (3.07%) 6.35% 16.25% 26.66% 37.60% 49.10% 61.19% 73.90% 87.26% 101.30%
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   (£6,435) (£1,610) £3,261 £8,179 £13,150 £18,176 £23,260 £28,408 £33,621 £38,905 £44,262
Real Return on Investment %   (12.03%) (3.01%) 6.10% 15.30% 24.59% 33.99% 43.50% 53.12% 62.87% 72.75% 82.77%