NG3 Carlton, St Ann's, Mapperley cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £143,464
Input Equity (£35,866)
Total Input Equity (£35,866)
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 £143,464 £143,464 £143,464 £143,464 £143,464 £143,464 £143,464 £143,464 £143,464 £143,464 £143,464 £143,464
Finance Amount £107,598 £107,598 £104,384 £101,005 £97,453 £93,720 £89,796 £85,671 £81,335 £76,777 £71,985 £66,949
Monthly Mortgage   (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710) (£710)
Monthly Rental   £563 £563 £563 £563 £563 £563 £563 £563 £563 £563 £563
Yield to Purchase Price %   4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71%
Yield to Property Value %   4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71% 4.71%
Gross Monthly Cashflow   (£147) (£147) (£147) (£147) (£147) (£147) (£147) (£147) (£147) (£147) (£147)
Gross Annual Cashflow   (£1,768) (£1,768) (£1,768) (£1,768) (£1,768) (£1,768) (£1,768) (£1,768) (£1,768) (£1,768) (£1,768)
Gross Annual Expenses                        
Annual Management Expenses   (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378) (£378)
Gross Annual Cashflow less Expenses   (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106)
Vacancy Expenses                        
Net Annual Cashflow   (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106) (£2,106)
Net Yield %   (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%) (1.47%)
Debt Coverage Ratio (1:x)   0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75 0.75
Personal Equity £35,866 £35,866 £39,080 £42,459 £46,011 £49,744 £53,668 £57,793 £62,129 £66,687 £71,479 £76,515
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   (£2,147) £1,068 £4,446 £7,998 £11,731 £15,656 £19,781 £24,117 £28,675 £33,466 £38,502
Return on Investment %   (5.99%) 2.98% 12.40% 22.30% 32.71% 43.65% 55.15% 67.24% 79.95% 93.31% 107.35%
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   (£2,147) £1,046 £4,270 £7,528 £10,821 £14,151 £17,523 £20,936 £24,395 £27,902 £31,459
Real Return on Investment %   (5.99%) 2.92% 11.91% 20.99% 30.17% 39.46% 48.86% 58.37% 68.02% 77.80% 87.71%