NN3 Boothville, Moulton, Weston Favell cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £209,850
Input Equity (£52,463)
Total Input Equity (£52,463)
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 £209,850 £209,850 £209,850 £209,850 £209,850 £209,850 £209,850 £209,850 £209,850 £209,850 £209,850 £209,850
Finance Amount £157,388 £157,388 £152,686 £147,744 £142,549 £137,088 £131,348 £125,314 £118,971 £112,304 £105,296 £97,929
Monthly Mortgage   (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039) (£1,039)
Monthly Rental   £742 £742 £742 £742 £742 £742 £742 £742 £742 £742 £742
Yield to Purchase Price %   4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24%
Yield to Property Value %   4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24% 4.24%
Gross Monthly Cashflow   (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297)
Gross Annual Cashflow   (£3,565) (£3,565) (£3,565) (£3,565) (£3,565) (£3,565) (£3,565) (£3,565) (£3,565) (£3,565) (£3,565)
Gross Annual Expenses                        
Annual Management Expenses   (£498) (£498) (£498) (£498) (£498) (£498) (£498) (£498) (£498) (£498) (£498)
Gross Annual Cashflow less Expenses   (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010)
Vacancy Expenses                        
Net Annual Cashflow   (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010) (£4,010)
Net Yield %   (1.91%) (1.91%) (1.91%) (1.91%) (1.91%) (1.91%) (1.91%) (1.91%) (1.91%) (1.91%) (1.91%)
Debt Coverage Ratio (1:x)   0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68
Personal Equity £52,463 £52,463 £57,164 £62,106 £67,301 £72,762 £78,502 £84,536 £90,879 £97,546 £104,554 £111,921
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   (£4,064) £638 £5,580 £10,775 £16,236 £21,976 £28,010 £34,353 £41,020 £48,028 £55,395
Return on Investment %   (7.75%) 1.22% 10.64% 20.54% 30.95% 41.89% 53.39% 65.48% 78.19% 91.55% 105.59%
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   (£4,064) £625 £5,359 £10,142 £14,976 £19,865 £24,813 £29,823 £34,898 £40,043 £45,262
Real Return on Investment %   (7.75%) 1.19% 10.22% 19.33% 28.55% 37.86% 47.30% 56.85% 66.52% 76.33% 86.27%