NE43 Stocksfield, Painshawfield, Newton cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £292,702
Input Equity (£73,176)
Total Input Equity (£73,176)
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 £292,702 £292,702 £292,702 £292,702 £292,702 £292,702 £292,702 £292,702 £292,702 £292,702 £292,702 £292,702
Finance Amount £219,527 £219,527 £212,969 £206,075 £198,829 £191,212 £183,206 £174,789 £165,943 £156,643 £146,868 £136,593
Monthly Mortgage   (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449) (£1,449)
Monthly Rental   £586 £586 £586 £586 £586 £586 £586 £586 £586 £586 £586
Yield to Purchase Price %   2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40%
Yield to Property Value %   2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40% 2.40%
Gross Monthly Cashflow   (£863) (£863) (£863) (£863) (£863) (£863) (£863) (£863) (£863) (£863) (£863)
Gross Annual Cashflow   (£10,351) (£10,351) (£10,351) (£10,351) (£10,351) (£10,351) (£10,351) (£10,351) (£10,351) (£10,351) (£10,351)
Gross Annual Expenses                        
Annual Management Expenses   (£394) (£394) (£394) (£394) (£394) (£394) (£394) (£394) (£394) (£394) (£394)
Gross Annual Cashflow less Expenses   (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703)
Vacancy Expenses                        
Net Annual Cashflow   (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703) (£10,703)
Net Yield %   (3.66%) (3.66%) (3.66%) (3.66%) (3.66%) (3.66%) (3.66%) (3.66%) (3.66%) (3.66%) (3.66%)
Debt Coverage Ratio (1:x)   0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38 0.38
Personal Equity £73,176 £73,176 £79,733 £86,627 £93,873 £101,490 £109,496 £117,913 £126,759 £136,059 £145,834 £156,109
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   (£10,745) (£4,187) £2,707 £9,953 £17,570 £25,576 £33,992 £42,839 £52,138 £61,914 £72,189
Return on Investment %   (14.68%) (5.72%) 3.70% 13.60% 24.01% 34.95% 46.45% 58.54% 71.25% 84.61% 98.65%
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   (£10,745) (£4,103) £2,599 £9,367 £16,206 £23,119 £30,112 £37,190 £44,357 £51,620 £58,984
Real Return on Investment %   (14.68%) (5.61%) 3.55% 12.80% 22.15% 31.59% 41.15% 50.82% 60.62% 70.54% 80.61%