NG24 Newark-on-Trent cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £217,994
Input Equity (£54,499)
Total Input Equity (£54,499)
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 £217,994 £217,994 £217,994 £217,994 £217,994 £217,994 £217,994 £217,994 £217,994 £217,994 £217,994 £217,994
Finance Amount £163,496 £163,496 £158,611 £153,477 £148,081 £142,408 £136,445 £130,177 £123,588 £116,662 £109,382 £101,729
Monthly Mortgage   (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079) (£1,079)
Monthly Rental   £619 £619 £619 £619 £619 £619 £619 £619 £619 £619 £619
Yield to Purchase Price %   3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41%
Yield to Property Value %   3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41% 3.41%
Gross Monthly Cashflow   (£460) (£460) (£460) (£460) (£460) (£460) (£460) (£460) (£460) (£460) (£460)
Gross Annual Cashflow   (£5,520) (£5,520) (£5,520) (£5,520) (£5,520) (£5,520) (£5,520) (£5,520) (£5,520) (£5,520) (£5,520)
Gross Annual Expenses                        
Annual Management Expenses   (£416) (£416) (£416) (£416) (£416) (£416) (£416) (£416) (£416) (£416) (£416)
Gross Annual Cashflow less Expenses   (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892)
Vacancy Expenses                        
Net Annual Cashflow   (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892) (£5,892)
Net Yield %   (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%) (2.70%)
Debt Coverage Ratio (1:x)   0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54 0.54
Personal Equity £54,499 £54,499 £59,383 £64,517 £69,913 £75,586 £81,549 £87,817 £94,406 £101,332 £108,612 £116,265
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   (£5,936) (£1,052) £4,082 £9,479 £15,151 £21,114 £27,382 £33,971 £40,897 £48,177 £55,830
Return on Investment %   (10.89%) (1.93%) 7.49% 17.39% 27.80% 38.74% 50.24% 62.33% 75.04% 88.40% 102.44%
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   (£5,936) (£1,031) £3,920 £8,921 £13,975 £19,086 £24,257 £29,491 £34,794 £40,168 £45,617
Real Return on Investment %   (10.89%) (1.89%) 7.19% 16.37% 25.64% 35.02% 44.51% 54.11% 63.84% 73.70% 83.70%