NE37 Usworth, Sulgrave, Albany cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £106,672
Input Equity (£26,668)
Total Input Equity (£26,668)
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 £106,672 £106,672 £106,672 £106,672 £106,672 £106,672 £106,672 £106,672 £106,672 £106,672 £106,672 £106,672
Finance Amount £80,004 £80,004 £77,614 £75,102 £72,461 £69,685 £66,767 £63,700 £60,476 £57,087 £53,524 £49,780
Monthly Mortgage   (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528) (£528)
Monthly Rental   £510 £510 £510 £510 £510 £510 £510 £510 £510 £510 £510
Yield to Purchase Price %   5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73%
Yield to Property Value %   5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73% 5.73%
Gross Monthly Cashflow   (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18) (£18)
Gross Annual Cashflow   (£221) (£221) (£221) (£221) (£221) (£221) (£221) (£221) (£221) (£221) (£221)
Gross Annual Expenses                        
Annual Management Expenses   (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342) (£342)
Gross Annual Cashflow less Expenses   (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527)
Vacancy Expenses                        
Net Annual Cashflow   (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527) (£527)
Net Yield %   (0.49%) (0.49%) (0.49%) (0.49%) (0.49%) (0.49%) (0.49%) (0.49%) (0.49%) (0.49%) (0.49%)
Debt Coverage Ratio (1:x)   0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92
Personal Equity £26,668 £26,668 £29,058 £31,570 £34,211 £36,987 £39,905 £42,972 £46,196 £49,585 £53,148 £56,892
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   (£563) £1,827 £4,339 £6,980 £9,756 £12,673 £15,741 £18,965 £22,354 £25,916 £29,661
Return on Investment %   (2.11%) 6.85% 16.27% 26.17% 36.58% 47.52% 59.02% 71.11% 83.82% 97.18% 111.22%
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   (£563) £1,790 £4,167 £6,569 £8,998 £11,456 £13,944 £16,464 £19,018 £21,608 £24,235
Real Return on Investment %   (2.11%) 6.71% 15.63% 24.63% 33.74% 42.96% 52.29% 61.74% 71.31% 81.02% 90.88%