NG18 Mansfield cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £158,297
Input Equity (£39,574)
Total Input Equity (£39,574)
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 £158,297 £158,297 £158,297 £158,297 £158,297 £158,297 £158,297 £158,297 £158,297 £158,297 £158,297 £158,297
Finance Amount £118,723 £118,723 £115,176 £111,448 £107,529 £103,410 £99,080 £94,528 £89,744 £84,715 £79,428 £73,871
Monthly Mortgage   (£784) (£784) (£784) (£784) (£784) (£784) (£784) (£784) (£784) (£784) (£784)
Monthly Rental   £522 £522 £522 £522 £522 £522 £522 £522 £522 £522 £522
Yield to Purchase Price %   3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96%
Yield to Property Value %   3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96% 3.96%
Gross Monthly Cashflow   (£262) (£262) (£262) (£262) (£262) (£262) (£262) (£262) (£262) (£262) (£262)
Gross Annual Cashflow   (£3,139) (£3,139) (£3,139) (£3,139) (£3,139) (£3,139) (£3,139) (£3,139) (£3,139) (£3,139) (£3,139)
Gross Annual Expenses                        
Annual Management Expenses   (£351) (£351) (£351) (£351) (£351) (£351) (£351) (£351) (£351) (£351) (£351)
Gross Annual Cashflow less Expenses   (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452)
Vacancy Expenses                        
Net Annual Cashflow   (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452) (£3,452)
Net Yield %   (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%) (2.18%)
Debt Coverage Ratio (1:x)   0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63
Personal Equity £39,574 £39,574 £43,121 £46,849 £50,768 £54,887 £59,217 £63,769 £68,553 £73,582 £78,869 £84,426
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,490) £57 £3,785 £7,704 £11,823 £16,153 £20,705 £25,489 £30,518 £35,805 £41,362
Return on Investment %   (8.82%) 0.14% 9.56% 19.47% 29.88% 40.82% 52.32% 64.41% 77.12% 90.47% 104.52%
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,490) £56 £3,635 £7,251 £10,905 £14,601 £18,341 £22,128 £25,964 £29,852 £33,796
Real Return on Investment %   (8.82%) 0.14% 9.19% 18.32% 27.56% 36.90% 46.35% 55.91% 65.61% 75.43% 85.40%