LL59 Menai Bridge, Llandegfan, Llansadwrn cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £258,054
Input Equity (£64,514)
Input Equity FX (£64,514)
Total Input Equity (£64,514)
Total Input Equity FX (£64,514)
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 £258,054 £258,054 £258,054 £258,054 £258,054 £258,054 £258,054 £258,054 £258,054 £258,054 £258,054 £258,054
Finance Amount £193,541 £193,541 £187,759 £181,681 £175,293 £168,578 £161,519 £154,099 £146,299 £138,101 £129,483 £120,424
Monthly Mortgage   (£1,277) (£1,277) (£1,277) (£1,277) (£1,277) (£1,277) (£1,277) (£1,277) (£1,277) (£1,277) (£1,277)
Monthly Rental   £777 £777 £777 £777 £777 £777 £777 £777 £777 £777 £777
Yield to Purchase Price %   3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61%
Yield to Property Value %   3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61% 3.61%
Gross Monthly Cashflow   (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500) (£500)
Gross Annual Cashflow   (£6,001) (£6,001) (£6,001) (£6,001) (£6,001) (£6,001) (£6,001) (£6,001) (£6,001) (£6,001) (£6,001)
Gross Annual Expenses                        
Annual Management Expenses   (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522) (£522)
Gross Annual Cashflow less Expenses   (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467)
Vacancy Expenses                        
Net Annual Cashflow   (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467) (£6,467)
Net Yield %   (2.51%) (2.51%) (2.51%) (2.51%) (2.51%) (2.51%) (2.51%) (2.51%) (2.51%) (2.51%) (2.51%)
Debt Coverage Ratio (1:x)   0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58 0.58
Personal Equity £64,514 £64,514 £70,295 £76,373 £82,761 £89,476 £96,535 £103,955 £111,755 £119,953 £128,571 £137,630
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,523) (£741) £5,336 £11,725 £18,440 £25,499 £32,919 £40,718 £48,917 £57,535 £66,594
Return on Investment %   (10.11%) (1.15%) 8.27% 18.17% 28.58% 39.52% 51.03% 63.12% 75.82% 89.18% 103.22%
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,523) (£726) £5,125 £11,035 £17,008 £23,049 £29,161 £35,348 £41,617 £47,969 £54,412
Real Return on Investment %   (10.11%) (1.13%) 7.94% 17.11% 26.36% 35.73% 45.20% 54.79% 64.51% 74.36% 84.34%