NG2 Nottingham City Centre, Sneinton, The Meadows, West Bridgford cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £166,957
Input Equity (£41,739)
Total Input Equity (£41,739)
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 £166,957 £166,957 £166,957 £166,957 £166,957 £166,957 £166,957 £166,957 £166,957 £166,957 £166,957 £166,957
Finance Amount £125,218 £125,218 £121,477 £117,545 £113,412 £109,067 £104,500 £99,700 £94,654 £89,349 £83,773 £77,912
Monthly Mortgage   (£826) (£826) (£826) (£826) (£826) (£826) (£826) (£826) (£826) (£826) (£826)
Monthly Rental   £732 £732 £732 £732 £732 £732 £732 £732 £732 £732 £732
Yield to Purchase Price %   5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26%
Yield to Property Value %   5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26% 5.26%
Gross Monthly Cashflow   (£94) (£94) (£94) (£94) (£94) (£94) (£94) (£94) (£94) (£94) (£94)
Gross Annual Cashflow   (£1,132) (£1,132) (£1,132) (£1,132) (£1,132) (£1,132) (£1,132) (£1,132) (£1,132) (£1,132) (£1,132)
Gross Annual Expenses                        
Annual Management Expenses   (£492) (£492) (£492) (£492) (£492) (£492) (£492) (£492) (£492) (£492) (£492)
Gross Annual Cashflow less Expenses   (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571)
Vacancy Expenses                        
Net Annual Cashflow   (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571) (£1,571)
Net Yield %   (0.94%) (0.94%) (0.94%) (0.94%) (0.94%) (0.94%) (0.94%) (0.94%) (0.94%) (0.94%) (0.94%)
Debt Coverage Ratio (1:x)   0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84 0.84
Personal Equity £41,739 £41,739 £45,480 £49,412 £53,545 £57,890 £62,457 £67,257 £72,303 £77,608 £83,184 £89,045
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   (£1,624) £2,116 £6,049 £10,182 £14,526 £19,093 £23,894 £28,940 £34,244 £39,820 £45,681
Return on Investment %   (3.89%) 5.07% 14.49% 24.39% 34.80% 45.74% 57.25% 69.34% 82.04% 95.40% 109.44%
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   (£1,624) £2,074 £5,809 £9,583 £13,399 £17,259 £21,166 £25,124 £29,134 £33,200 £37,325
Real Return on Investment %   (3.89%) 4.97% 13.92% 22.96% 32.10% 41.35% 50.71% 60.19% 69.80% 79.54% 89.42%