NE17 Chopwell, Western Chopwell Wood cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £157,737
Input Equity (£39,434)
Total Input Equity (£39,434)
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 £157,737 £157,737 £157,737 £157,737 £157,737 £157,737 £157,737 £157,737 £157,737 £157,737 £157,737 £157,737
Finance Amount £118,303 £118,303 £114,769 £111,054 £107,149 £103,044 £98,729 £94,194 £89,426 £84,415 £79,147 £73,610
Monthly Mortgage   (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781) (£781)
Monthly Rental   £462 £462 £462 £462 £462 £462 £462 £462 £462 £462 £462
Yield to Purchase Price %   3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51%
Yield to Property Value %   3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51% 3.51%
Gross Monthly Cashflow   (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319) (£319)
Gross Annual Cashflow   (£3,825) (£3,825) (£3,825) (£3,825) (£3,825) (£3,825) (£3,825) (£3,825) (£3,825) (£3,825) (£3,825)
Gross Annual Expenses                        
Annual Management Expenses   (£310) (£310) (£310) (£310) (£310) (£310) (£310) (£310) (£310) (£310) (£310)
Gross Annual Cashflow less Expenses   (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102)
Vacancy Expenses                        
Net Annual Cashflow   (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102) (£4,102)
Net Yield %   (2.60%) (2.60%) (2.60%) (2.60%) (2.60%) (2.60%) (2.60%) (2.60%) (2.60%) (2.60%) (2.60%)
Debt Coverage Ratio (1:x)   0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56 0.56
Personal Equity £39,434 £39,434 £42,968 £46,683 £50,588 £54,693 £59,008 £63,543 £68,311 £73,322 £78,590 £84,127
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,135) (£601) £3,114 £7,019 £11,123 £15,438 £19,974 £24,741 £29,752 £35,020 £40,558
Return on Investment %   (10.49%) (1.52%) 7.90% 17.80% 28.21% 39.15% 50.65% 62.74% 75.45% 88.81% 102.85%
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,135) (£589) £2,990 £6,606 £10,260 £13,955 £17,693 £21,478 £25,312 £29,198 £33,139
Real Return on Investment %   (10.49%) (1.49%) 7.58% 16.75% 26.02% 35.39% 44.87% 54.47% 64.19% 74.04% 84.04%