LL27 Trefriw cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £275,510
Input Equity (£68,878)
Total Input Equity (£68,878)
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 £275,510 £275,510 £275,510 £275,510 £275,510 £275,510 £275,510 £275,510 £275,510 £275,510 £275,510 £275,510
Finance Amount £206,633 £206,633 £200,460 £193,971 £187,151 £179,981 £172,445 £164,523 £156,196 £147,443 £138,242 £128,570
Monthly Mortgage   (£1,364) (£1,364) (£1,364) (£1,364) (£1,364) (£1,364) (£1,364) (£1,364) (£1,364) (£1,364) (£1,364)
Monthly Rental   £627 £627 £627 £627 £627 £627 £627 £627 £627 £627 £627
Yield to Purchase Price %   2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73%
Yield to Property Value %   2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73% 2.73%
Gross Monthly Cashflow   (£737) (£737) (£737) (£737) (£737) (£737) (£737) (£737) (£737) (£737) (£737)
Gross Annual Cashflow   (£8,844) (£8,844) (£8,844) (£8,844) (£8,844) (£8,844) (£8,844) (£8,844) (£8,844) (£8,844) (£8,844)
Gross Annual Expenses                        
Annual Management Expenses   (£421) (£421) (£421) (£421) (£421) (£421) (£421) (£421) (£421) (£421) (£421)
Gross Annual Cashflow less Expenses   (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220)
Vacancy Expenses                        
Net Annual Cashflow   (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220) (£9,220)
Net Yield %   (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%) (3.35%)
Debt Coverage Ratio (1:x)   0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44 0.44
Personal Equity £68,878 £68,878 £75,050 £81,539 £88,359 £95,529 £103,065 £110,987 £119,314 £128,067 £137,268 £146,940
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   (£9,265) (£3,093) £3,396 £10,216 £17,386 £24,922 £32,844 £41,171 £49,924 £59,125 £68,797
Return on Investment %   (13.45%) (4.49%) 4.93% 14.83% 25.24% 36.18% 47.68% 59.77% 72.48% 85.84% 99.88%
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   (£9,265) (£3,031) £3,261 £9,616 £16,036 £22,528 £29,095 £35,742 £42,474 £49,296 £56,212
Real Return on Investment %   (13.45%) (4.40%) 4.74% 13.96% 23.28% 32.71% 42.24% 51.89% 61.67% 71.57% 81.61%