LL78 Brynteg cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £201,178
Input Equity (£50,295)
Total Input Equity (£50,295)
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 £201,178 £201,178 £201,178 £201,178 £201,178 £201,178 £201,178 £201,178 £201,178 £201,178 £201,178 £201,178
Finance Amount £150,884 £150,884 £146,376 £141,638 £136,658 £131,423 £125,920 £120,135 £114,055 £107,663 £100,944 £93,882
Monthly Mortgage   (£996) (£996) (£996) (£996) (£996) (£996) (£996) (£996) (£996) (£996) (£996)
Monthly Rental   £510 £510 £510 £510 £510 £510 £510 £510 £510 £510 £510
Yield to Purchase Price %   3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04%
Yield to Property Value %   3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04%
Gross Monthly Cashflow   (£486) (£486) (£486) (£486) (£486) (£486) (£486) (£486) (£486) (£486) (£486)
Gross Annual Cashflow   (£5,834) (£5,834) (£5,834) (£5,834) (£5,834) (£5,834) (£5,834) (£5,834) (£5,834) (£5,834) (£5,834)
Gross Annual Expenses                        
Annual Management Expenses   (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342)
Gross Annual Cashflow less Expenses   (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140)
Vacancy Expenses                        
Net Annual Cashflow   (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140) (£6,140)
Net Yield %   (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%)
Debt Coverage Ratio (1:x)   0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49
Personal Equity £50,295 £50,295 £54,802 £59,540 £64,520 £69,755 £75,258 £81,043 £87,123 £93,515 £100,234 £107,296
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,176) (£1,669) £3,069 £8,049 £13,285 £18,788 £24,572 £30,653 £37,044 £43,763 £50,825
Return on Investment %   (12.28%) (3.32%) 6.10% 16.00% 26.41% 37.36% 48.86% 60.95% 73.65% 87.01% 101.06%
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,176) (£1,635) £2,948 £7,576 £12,253 £16,983 £21,767 £26,610 £31,516 £36,487 £41,528
Real Return on Investment %   (12.28%) (3.25%) 5.86% 15.06% 24.36% 33.77% 43.28% 52.91% 62.66% 72.55% 82.57%