LN6 Doddington Park, Birchwood, North/South Hykeham cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £232,024
Input Equity (£58,006)
Input Equity FX (£58,006)
Total Input Equity (£58,006)
Total Input Equity FX (£58,006)
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 £232,024 £232,024 £232,024 £232,024 £232,024 £232,024 £232,024 £232,024 £232,024 £232,024 £232,024 £232,024
Finance Amount £174,018 £174,018 £168,820 £163,355 £157,611 £151,573 £145,226 £138,555 £131,542 £124,171 £116,422 £108,277
Monthly Mortgage   (£1,148) (£1,148) (£1,148) (£1,148) (£1,148) (£1,148) (£1,148) (£1,148) (£1,148) (£1,148) (£1,148)
Monthly Rental   £638 £638 £638 £638 £638 £638 £638 £638 £638 £638 £638
Yield to Purchase Price %   3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30%
Yield to Property Value %   3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30% 3.30%
Gross Monthly Cashflow   (£510) (£510) (£510) (£510) (£510) (£510) (£510) (£510) (£510) (£510) (£510)
Gross Annual Cashflow   (£6,124) (£6,124) (£6,124) (£6,124) (£6,124) (£6,124) (£6,124) (£6,124) (£6,124) (£6,124) (£6,124)
Gross Annual Expenses                        
Annual Management Expenses   (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429) (£429)
Gross Annual Cashflow less Expenses   (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507)
Vacancy Expenses                        
Net Annual Cashflow   (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507) (£6,507)
Net Yield %   (2.80%) (2.80%) (2.80%) (2.80%) (2.80%) (2.80%) (2.80%) (2.80%) (2.80%) (2.80%) (2.80%)
Debt Coverage Ratio (1:x)   0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53 0.53
Personal Equity £58,006 £58,006 £63,204 £68,669 £74,413 £80,451 £86,798 £93,469 £100,482 £107,853 £115,602 £123,747
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,553) (£1,354) £4,110 £9,854 £15,892 £22,239 £28,910 £35,923 £43,295 £51,044 £59,189
Return on Investment %   (11.30%) (2.33%) 7.09% 16.99% 27.40% 38.34% 49.84% 61.93% 74.64% 88.00% 102.04%
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,553) (£1,327) £3,948 £9,275 £14,658 £20,102 £25,610 £31,186 £36,834 £42,557 £48,362
Real Return on Investment %   (11.30%) (2.29%) 6.81% 15.99% 25.27% 34.66% 44.15% 53.76% 63.50% 73.37% 83.37%