LN1 Lincoln city centre, Stow cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £244,883
Input Equity (£61,221)
Input Equity FX (£61,221)
Total Input Equity (£61,221)
Total Input Equity FX (£61,221)
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 £244,883 £244,883 £244,883 £244,883 £244,883 £244,883 £244,883 £244,883 £244,883 £244,883 £244,883 £244,883
Finance Amount £183,662 £183,662 £178,176 £172,408 £166,346 £159,974 £153,275 £146,234 £138,832 £131,052 £122,874 £114,277
Monthly Mortgage   (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212) (£1,212)
Monthly Rental   £608 £608 £608 £608 £608 £608 £608 £608 £608 £608 £608
Yield to Purchase Price %   2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98%
Yield to Property Value %   2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98% 2.98%
Gross Monthly Cashflow   (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604) (£604)
Gross Annual Cashflow   (£7,248) (£7,248) (£7,248) (£7,248) (£7,248) (£7,248) (£7,248) (£7,248) (£7,248) (£7,248) (£7,248)
Gross Annual Expenses                        
Annual Management Expenses   (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409) (£409)
Gross Annual Cashflow less Expenses   (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613)
Vacancy Expenses                        
Net Annual Cashflow   (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613) (£7,613)
Net Yield %   (3.11%) (3.11%) (3.11%) (3.11%) (3.11%) (3.11%) (3.11%) (3.11%) (3.11%) (3.11%) (3.11%)
Debt Coverage Ratio (1:x)   0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48 0.48
Personal Equity £61,221 £61,221 £66,707 £72,475 £78,537 £84,909 £91,608 £98,649 £106,051 £113,831 £122,009 £130,606
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   (£7,657) (£2,171) £3,597 £9,659 £16,032 £22,730 £29,771 £37,173 £44,953 £53,131 £61,728
Return on Investment %   (12.51%) (3.55%) 5.88% 15.78% 26.19% 37.13% 48.63% 60.72% 73.43% 86.79% 100.83%
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   (£7,657) (£2,127) £3,454 £9,091 £14,787 £20,546 £26,373 £32,271 £38,244 £44,298 £50,436
Real Return on Investment %   (12.51%) (3.47%) 5.64% 14.85% 24.15% 33.56% 43.08% 52.71% 62.47% 72.36% 82.38%