LL72 Moelfre cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £213,974
Input Equity (£53,494)
Total Input Equity (£53,494)
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,974 £213,974 £213,974 £213,974 £213,974 £213,974 £213,974 £213,974 £213,974 £213,974 £213,974 £213,974
Finance Amount £160,481 £160,481 £155,686 £150,647 £145,350 £139,782 £133,929 £127,776 £121,309 £114,511 £107,365 £99,853
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   £725 £725 £725 £725 £725 £725 £725 £725 £725 £725 £725
Yield to Purchase Price %   4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07%
Yield to Property Value %   4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07% 4.07%
Gross Monthly Cashflow   (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334) (£334)
Gross Annual Cashflow   (£4,009) (£4,009) (£4,009) (£4,009) (£4,009) (£4,009) (£4,009) (£4,009) (£4,009) (£4,009) (£4,009)
Gross Annual Expenses                        
Annual Management Expenses   (£487) (£487) (£487) (£487) (£487) (£487) (£487) (£487) (£487) (£487) (£487)
Gross Annual Cashflow less Expenses   (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444)
Vacancy Expenses                        
Net Annual Cashflow   (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444) (£4,444)
Net Yield %   (2.08%) (2.08%) (2.08%) (2.08%) (2.08%) (2.08%) (2.08%) (2.08%) (2.08%) (2.08%) (2.08%)
Debt Coverage Ratio (1:x)   0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65 0.65
Personal Equity £53,494 £53,494 £58,288 £63,327 £68,624 £74,192 £80,045 £86,198 £92,665 £99,463 £106,609 £114,121
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   (£4,496) £298 £5,337 £10,634 £16,202 £22,055 £28,208 £34,675 £41,473 £48,619 £56,131
Return on Investment %   (8.41%) 0.56% 9.98% 19.88% 30.29% 41.23% 52.73% 64.82% 77.53% 90.89% 104.93%
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   (£4,496) £292 £5,126 £10,009 £14,944 £19,936 £24,988 £30,102 £35,284 £40,536 £45,863
Real Return on Investment %   (8.41%) 0.55% 9.58% 18.71% 27.94% 37.27% 46.71% 56.27% 65.96% 75.78% 85.74%