LA16 Askam-in-furness cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £177,099
Input Equity (£44,275)
Total Input Equity (£44,275)
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 £177,099 £177,099 £177,099 £177,099 £177,099 £177,099 £177,099 £177,099 £177,099 £177,099 £177,099 £177,099
Finance Amount £132,824 £132,824 £128,856 £124,686 £120,301 £115,693 £110,848 £105,756 £100,403 £94,777 £88,862 £82,645
Monthly Mortgage   (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877) (£877)
Monthly Rental   £922 £922 £922 £922 £922 £922 £922 £922 £922 £922 £922
Yield to Purchase Price %   6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25%
Yield to Property Value %   6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25% 6.25%
Gross Monthly Cashflow   £46 £46 £46 £46 £46 £46 £46 £46 £46 £46 £46
Gross Annual Cashflow   £550 £550 £550 £550 £550 £550 £550 £550 £550 £550 £550
Gross Annual Expenses                        
Annual Management Expenses   (£620) (£620) (£620) (£620) (£620) (£620) (£620) (£620) (£620) (£620) (£620)
Gross Annual Cashflow less Expenses   (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4)
Vacancy Expenses                        
Net Annual Cashflow   (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4)
Taxable Income   £550 £550 £550 £550 £550 £550 £550 £550 £550 £550 £550
Tax Payable                        
Net Annual Cashflow Less Tax   (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4) (£4)
Net Yield %   (0.00%) (0.00%) (0.00%) (0.00%) (0.00%) (0.00%) (0.00%) (0.00%) (0.00%) (0.00%) (0.00%)
Debt Coverage Ratio (1:x)   1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
Personal Equity £44,275 £44,275 £48,243 £52,414 £56,798 £61,406 £66,251 £71,343 £76,696 £82,322 £88,237 £94,454
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   (£70) £3,898 £8,069 £12,453 £17,062 £21,906 £26,998 £32,351 £37,977 £43,892 £50,109
Return on Investment %   (0.16%) 8.80% 18.22% 28.13% 38.54% 49.48% 60.98% 73.07% 85.78% 99.14% 113.18%
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   (£70) £3,820 £7,749 £11,721 £15,737 £19,801 £23,916 £28,085 £32,310 £36,595 £40,943
Real Return on Investment %   (0.16%) 8.63% 17.50% 26.47% 35.54% 44.72% 54.02% 63.43% 72.98% 82.65% 92.47%