LE17 Leire, Lutterworth, Swinford, Bitteswell, Ullesthorpe cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £368,939
Input Equity (£92,235)
Total Input Equity (£92,235)
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 £368,939 £368,939 £368,939 £368,939 £368,939 £368,939 £368,939 £368,939 £368,939 £368,939 £368,939 £368,939
Finance Amount £276,704 £276,704 £268,438 £259,749 £250,616 £241,015 £230,923 £220,315 £209,164 £197,442 £185,121 £172,170
Monthly Mortgage   (£1,826) (£1,826) (£1,826) (£1,826) (£1,826) (£1,826) (£1,826) (£1,826) (£1,826) (£1,826) (£1,826)
Monthly Rental   £937 £937 £937 £937 £937 £937 £937 £937 £937 £937 £937
Yield to Purchase Price %   3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05%
Yield to Property Value %   3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05% 3.05%
Gross Monthly Cashflow   (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890) (£890)
Gross Annual Cashflow   (£10,675) (£10,675) (£10,675) (£10,675) (£10,675) (£10,675) (£10,675) (£10,675) (£10,675) (£10,675) (£10,675)
Gross Annual Expenses                        
Annual Management Expenses   (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629) (£629)
Gross Annual Cashflow less Expenses   (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237)
Vacancy Expenses                        
Net Annual Cashflow   (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237) (£11,237)
Net Yield %   (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%) (3.05%)
Debt Coverage Ratio (1:x)   0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49
Personal Equity £92,235 £92,235 £100,501 £109,190 £118,323 £127,924 £138,016 £148,624 £159,775 £171,497 £183,818 £196,769
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   (£11,304) (£3,038) £5,650 £14,784 £24,385 £34,477 £45,085 £56,236 £67,957 £80,279 £93,230
Return on Investment %   (12.26%) (3.29%) 6.13% 16.03% 26.44% 37.38% 48.88% 60.97% 73.68% 87.04% 101.08%
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   (£11,304) (£2,978) £5,427 £13,914 £22,492 £31,164 £39,938 £48,820 £57,816 £66,932 £76,176
Real Return on Investment %   (12.26%) (3.23%) 5.88% 15.09% 24.39% 33.79% 43.30% 52.93% 62.68% 72.57% 82.59%