LL14 Wrexham, Rhosllanerchrugog, Cefn Mawr, Ponciau, Rhostyllen, Chirk, Ruabon cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £210,544
Input Equity (£52,636)
Total Input Equity (£52,636)
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 £210,544 £210,544 £210,544 £210,544 £210,544 £210,544 £210,544 £210,544 £210,544 £210,544 £210,544 £210,544
Finance Amount £157,908 £157,908 £153,191 £148,232 £143,020 £137,541 £131,782 £125,728 £119,364 £112,675 £105,644 £98,253
Monthly Mortgage   (£1,042) (£1,042) (£1,042) (£1,042) (£1,042) (£1,042) (£1,042) (£1,042) (£1,042) (£1,042) (£1,042)
Monthly Rental   £623 £623 £623 £623 £623 £623 £623 £623 £623 £623 £623
Yield to Purchase Price %   3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55%
Yield to Property Value %   3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55% 3.55%
Gross Monthly Cashflow   (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419)
Gross Annual Cashflow   (£5,032) (£5,032) (£5,032) (£5,032) (£5,032) (£5,032) (£5,032) (£5,032) (£5,032) (£5,032) (£5,032)
Gross Annual Expenses                        
Annual Management Expenses   (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419) (£419)
Gross Annual Cashflow less Expenses   (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406)
Vacancy Expenses                        
Net Annual Cashflow   (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406) (£5,406)
Net Yield %   (2.57%) (2.57%) (2.57%) (2.57%) (2.57%) (2.57%) (2.57%) (2.57%) (2.57%) (2.57%) (2.57%)
Debt Coverage Ratio (1:x)   0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57 0.57
Personal Equity £52,636 £52,636 £57,353 £62,312 £67,524 £73,003 £78,762 £84,816 £91,180 £97,869 £104,900 £112,291
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   (£5,451) (£734) £4,225 £9,437 £14,916 £20,675 £26,729 £33,093 £39,782 £46,813 £54,205
Return on Investment %   (10.36%) (1.39%) 8.03% 17.93% 28.34% 39.28% 50.78% 62.87% 75.58% 88.94% 102.98%
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   (£5,451) (£719) £4,058 £8,882 £13,758 £18,689 £23,678 £28,729 £33,845 £39,031 £44,289
Real Return on Investment %   (10.36%) (1.37%) 7.71% 16.87% 26.14% 35.51% 44.98% 54.58% 64.30% 74.15% 84.14%