LL13 Wrexham, Abenbury, Bowling Bank, Holt, Llan-y-Pwll, Pentre Maelor, Ridley Wood, Bangor-on-Dee, Gyfelia, Marchwiel, Overton, Penley, Worthenbury cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £250,123
Input Equity (£62,531)
Total Input Equity (£62,531)
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 £250,123 £250,123 £250,123 £250,123 £250,123 £250,123 £250,123 £250,123 £250,123 £250,123 £250,123 £250,123
Finance Amount £187,592 £187,592 £181,988 £176,098 £169,906 £163,397 £156,555 £149,363 £141,803 £133,856 £125,503 £116,723
Monthly Mortgage   (£1,238) (£1,238) (£1,238) (£1,238) (£1,238) (£1,238) (£1,238) (£1,238) (£1,238) (£1,238) (£1,238)
Monthly Rental   £713 £713 £713 £713 £713 £713 £713 £713 £713 £713 £713
Yield to Purchase Price %   3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42%
Yield to Property Value %   3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42% 3.42%
Gross Monthly Cashflow   (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525) (£525)
Gross Annual Cashflow   (£6,294) (£6,294) (£6,294) (£6,294) (£6,294) (£6,294) (£6,294) (£6,294) (£6,294) (£6,294) (£6,294)
Gross Annual Expenses                        
Annual Management Expenses   (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479) (£479)
Gross Annual Cashflow less Expenses   (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723)
Vacancy Expenses                        
Net Annual Cashflow   (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723) (£6,723)
Net Yield %   (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%) (2.69%)
Debt Coverage Ratio (1:x)   0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55 0.55
Personal Equity £62,531 £62,531 £68,135 £74,025 £80,217 £86,726 £93,568 £100,760 £108,320 £116,267 £124,620 £133,400
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,774) (£1,170) £4,721 £10,913 £17,422 £24,263 £31,455 £39,015 £46,962 £55,315 £64,096
Return on Investment %   (10.83%) (1.87%) 7.55% 17.45% 27.86% 38.80% 50.30% 62.39% 75.10% 88.46% 102.50%
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,774) (£1,147) £4,534 £10,271 £16,069 £21,932 £27,865 £33,870 £39,953 £46,119 £52,371
Real Return on Investment %   (10.83%) (1.83%) 7.25% 16.43% 25.70% 35.07% 44.56% 54.17% 63.89% 73.75% 83.75%