LN2 Nettleham, Ermine & St Giles Estates cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £197,005
Input Equity (£49,251)
Total Input Equity (£49,251)
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 £197,005 £197,005 £197,005 £197,005 £197,005 £197,005 £197,005 £197,005 £197,005 £197,005 £197,005 £197,005
Finance Amount £147,754 £147,754 £143,340 £138,700 £133,823 £128,697 £123,308 £117,643 £111,689 £105,430 £98,850 £91,935
Monthly Mortgage   (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975) (£975)
Monthly Rental   £681 £681 £681 £681 £681 £681 £681 £681 £681 £681 £681
Yield to Purchase Price %   4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15%
Yield to Property Value %   4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15% 4.15%
Gross Monthly Cashflow   (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294) (£294)
Gross Annual Cashflow   (£3,533) (£3,533) (£3,533) (£3,533) (£3,533) (£3,533) (£3,533) (£3,533) (£3,533) (£3,533) (£3,533)
Gross Annual Expenses                        
Annual Management Expenses   (£457) (£457) (£457) (£457) (£457) (£457) (£457) (£457) (£457) (£457) (£457)
Gross Annual Cashflow less Expenses   (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941)
Vacancy Expenses                        
Net Annual Cashflow   (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941) (£3,941)
Net Yield %   (2.00%) (2.00%) (2.00%) (2.00%) (2.00%) (2.00%) (2.00%) (2.00%) (2.00%) (2.00%) (2.00%)
Debt Coverage Ratio (1:x)   0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66 0.66
Personal Equity £49,251 £49,251 £53,665 £58,305 £63,182 £68,308 £73,697 £79,362 £85,316 £91,575 £98,155 £105,070
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   (£3,990) £423 £5,063 £9,940 £15,067 £20,456 £26,120 £32,075 £38,334 £44,913 £51,829
Return on Investment %   (8.10%) 0.86% 10.28% 20.18% 30.59% 41.53% 53.03% 65.12% 77.83% 91.19% 105.23%
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   (£3,990) £415 £4,863 £9,356 £13,897 £18,490 £23,138 £27,845 £32,613 £37,446 £42,348
Real Return on Investment %   (8.10%) 0.84% 9.87% 19.00% 28.22% 37.54% 46.98% 56.54% 66.22% 76.03% 85.98%