M17 Trafford Park, The Trafford Centre cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £156,225
Input Equity (£39,056)
Total Input Equity (£39,056)
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 £156,225 £156,225 £156,225 £156,225 £156,225 £156,225 £156,225 £156,225 £156,225 £156,225 £156,225 £156,225
Finance Amount £117,169 £117,169 £113,669 £109,989 £106,122 £102,056 £97,783 £93,291 £88,569 £83,606 £78,388 £72,904
Monthly Mortgage   (£773) (£773) (£773) (£773) (£773) (£773) (£773) (£773) (£773) (£773) (£773)
Monthly Rental   £788 £788 £788 £788 £788 £788 £788 £788 £788 £788 £788
Yield to Purchase Price %   6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05%
Yield to Property Value %   6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05% 6.05%
Gross Monthly Cashflow   £15 £15 £15 £15 £15 £15 £15 £15 £15 £15 £15
Gross Annual Cashflow   £176 £176 £176 £176 £176 £176 £176 £176 £176 £176 £176
Gross Annual Expenses                        
Annual Management Expenses   (£529) (£529) (£529) (£529) (£529) (£529) (£529) (£529) (£529) (£529) (£529)
Gross Annual Cashflow less Expenses   (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297)
Vacancy Expenses                        
Net Annual Cashflow   (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297)
Taxable Income   £176 £176 £176 £176 £176 £176 £176 £176 £176 £176 £176
Tax Payable                        
Net Annual Cashflow Less Tax   (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297) (£297)
Net Yield %   (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%) (0.19%)
Debt Coverage Ratio (1:x)   0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97 0.97
Personal Equity £39,056 £39,056 £42,556 £46,236 £50,103 £54,169 £58,442 £62,934 £67,656 £72,619 £77,837 £83,321
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   (£353) £3,147 £6,826 £10,694 £14,759 £19,032 £23,524 £28,246 £33,210 £38,427 £43,911
Return on Investment %   (0.90%) 8.06% 17.48% 27.38% 37.79% 48.73% 60.23% 72.32% 85.03% 98.39% 112.43%
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   (£353) £3,084 £6,556 £10,065 £13,613 £17,204 £20,839 £24,521 £28,254 £32,038 £35,879
Real Return on Investment %   (0.90%) 7.90% 16.79% 25.77% 34.86% 44.05% 53.36% 62.78% 72.34% 82.03% 91.86%