LN9 Horncastle cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £224,409
Input Equity (£56,102)
Total Input Equity (£56,102)
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 £224,409 £224,409 £224,409 £224,409 £224,409 £224,409 £224,409 £224,409 £224,409 £224,409 £224,409 £224,409
Finance Amount £168,307 £168,307 £163,279 £157,994 £152,438 £146,599 £140,460 £134,008 £127,225 £120,095 £112,601 £104,723
Monthly Mortgage   (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111) (£1,111)
Monthly Rental   £536 £536 £536 £536 £536 £536 £536 £536 £536 £536 £536
Yield to Purchase Price %   2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87%
Yield to Property Value %   2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87% 2.87%
Gross Monthly Cashflow   (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575) (£575)
Gross Annual Cashflow   (£6,895) (£6,895) (£6,895) (£6,895) (£6,895) (£6,895) (£6,895) (£6,895) (£6,895) (£6,895) (£6,895)
Gross Annual Expenses                        
Annual Management Expenses   (£360) (£360) (£360) (£360) (£360) (£360) (£360) (£360) (£360) (£360) (£360)
Gross Annual Cashflow less Expenses   (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217)
Vacancy Expenses                        
Net Annual Cashflow   (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217) (£7,217)
Net Yield %   (3.22%) (3.22%) (3.22%) (3.22%) (3.22%) (3.22%) (3.22%) (3.22%) (3.22%) (3.22%) (3.22%)
Debt Coverage Ratio (1:x)   0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46 0.46
Personal Equity £56,102 £56,102 £61,130 £66,415 £71,971 £77,810 £83,949 £90,401 £97,184 £104,314 £111,808 £119,686
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   (£7,255) (£2,227) £3,058 £8,613 £14,453 £20,591 £27,044 £33,827 £40,956 £48,451 £56,328
Return on Investment %   (12.93%) (3.97%) 5.45% 15.35% 25.76% 36.70% 48.20% 60.29% 73.00% 86.36% 100.40%
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   (£7,255) (£2,183) £2,937 £8,107 £13,331 £18,613 £23,957 £29,366 £34,844 £40,396 £46,024
Real Return on Investment %   (12.93%) (3.89%) 5.23% 14.45% 23.76% 33.18% 42.70% 52.34% 62.11% 72.00% 82.04%