M16 Firswood, Old Trafford, Whalley Range cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £149,195
Input Equity (£37,299)
Total Input Equity (£37,299)
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 £149,195 £149,195 £149,195 £149,195 £149,195 £149,195 £149,195 £149,195 £149,195 £149,195 £149,195 £149,195
Finance Amount £111,896 £111,896 £108,554 £105,040 £101,346 £97,464 £93,383 £89,093 £84,584 £79,844 £74,861 £69,624
Monthly Mortgage   (£738) (£738) (£738) (£738) (£738) (£738) (£738) (£738) (£738) (£738) (£738)
Monthly Rental   £673 £673 £673 £673 £673 £673 £673 £673 £673 £673 £673
Yield to Purchase Price %   5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41%
Yield to Property Value %   5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41% 5.41%
Gross Monthly Cashflow   (£66) (£66) (£66) (£66) (£66) (£66) (£66) (£66) (£66) (£66) (£66)
Gross Annual Cashflow   (£788) (£788) (£788) (£788) (£788) (£788) (£788) (£788) (£788) (£788) (£788)
Gross Annual Expenses                        
Annual Management Expenses   (£452) (£452) (£452) (£452) (£452) (£452) (£452) (£452) (£452) (£452) (£452)
Gross Annual Cashflow less Expenses   (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192)
Vacancy Expenses                        
Net Annual Cashflow   (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192) (£1,192)
Net Yield %   (0.80%) (0.80%) (0.80%) (0.80%) (0.80%) (0.80%) (0.80%) (0.80%) (0.80%) (0.80%) (0.80%)
Debt Coverage Ratio (1:x)   0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87 0.87
Personal Equity £37,299 £37,299 £40,641 £44,155 £47,849 £51,731 £55,812 £60,102 £64,611 £69,351 £74,334 £79,571
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,240) £2,103 £5,616 £9,310 £13,192 £17,273 £21,563 £26,072 £30,813 £35,795 £41,033
Return on Investment %   (3.32%) 5.64% 15.06% 24.96% 35.37% 46.31% 57.81% 69.90% 82.61% 95.97% 110.01%
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,240) £2,061 £5,394 £8,762 £12,168 £15,614 £19,102 £22,634 £26,214 £29,844 £33,527
Real Return on Investment %   (3.32%) 5.52% 14.46% 23.49% 32.62% 41.86% 51.21% 60.68% 70.28% 80.01% 89.89%