NG12 Cotgrave, Radcliffe on Trent, Keyworth cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £249,411
Input Equity (£62,353)
Input Equity FX (£62,353)
Total Input Equity (£62,353)
Total Input Equity FX (£62,353)
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 £249,411 £249,411 £249,411 £249,411 £249,411 £249,411 £249,411 £249,411 £249,411 £249,411 £249,411 £249,411
Finance Amount £187,058 £187,058 £181,470 £175,596 £169,422 £162,932 £156,109 £148,938 £141,399 £133,475 £125,146 £116,390
Monthly Mortgage   (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235) (£1,235)
Monthly Rental   £702 £702 £702 £702 £702 £702 £702 £702 £702 £702 £702
Yield to Purchase Price %   3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38%
Yield to Property Value %   3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38% 3.38%
Gross Monthly Cashflow   (£532) (£532) (£532) (£532) (£532) (£532) (£532) (£532) (£532) (£532) (£532)
Gross Annual Cashflow   (£6,389) (£6,389) (£6,389) (£6,389) (£6,389) (£6,389) (£6,389) (£6,389) (£6,389) (£6,389) (£6,389)
Gross Annual Expenses                        
Annual Management Expenses   (£472) (£472) (£472) (£472) (£472) (£472) (£472) (£472) (£472) (£472) (£472)
Gross Annual Cashflow less Expenses   (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810)
Vacancy Expenses                        
Net Annual Cashflow   (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810) (£6,810)
Net Yield %   (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%) (2.73%)
Debt Coverage Ratio (1:x)   0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54
Personal Equity £62,353 £62,353 £67,941 £73,815 £79,989 £86,479 £93,302 £100,473 £108,012 £115,936 £124,265 £133,021
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,861) (£1,273) £4,601 £10,775 £17,266 £24,088 £31,259 £38,798 £46,722 £55,051 £63,807
Return on Investment %   (11.00%) (2.04%) 7.38% 17.28% 27.69% 38.63% 50.13% 62.22% 74.93% 88.29% 102.33%
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,861) (£1,248) £4,419 £10,142 £15,925 £21,774 £27,691 £33,681 £39,749 £45,899 £52,135
Real Return on Investment %   (11.00%) (2.00%) 7.09% 16.27% 25.54% 34.92% 44.41% 54.02% 63.75% 73.61% 83.61%