LS24 Saxton, Stutton, Ulleskelf, Church Fenton, Tadcaster, Toulston cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £368,406
Input Equity (£92,102)
Total Input Equity (£92,102)
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 £368,406 £368,406 £368,406 £368,406 £368,406 £368,406 £368,406 £368,406 £368,406 £368,406 £368,406 £368,406
Finance Amount £276,305 £276,305 £268,050 £259,374 £250,254 £240,667 £230,590 £219,997 £208,862 £197,157 £184,854 £171,921
Monthly Mortgage   (£1,823) (£1,823) (£1,823) (£1,823) (£1,823) (£1,823) (£1,823) (£1,823) (£1,823) (£1,823) (£1,823)
Monthly Rental   £867 £867 £867 £867 £867 £867 £867 £867 £867 £867 £867
Yield to Purchase Price %   2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83%
Yield to Property Value %   2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83% 2.83%
Gross Monthly Cashflow   (£956) (£956) (£956) (£956) (£956) (£956) (£956) (£956) (£956) (£956) (£956)
Gross Annual Cashflow   (£11,473) (£11,473) (£11,473) (£11,473) (£11,473) (£11,473) (£11,473) (£11,473) (£11,473) (£11,473) (£11,473)
Gross Annual Expenses                        
Annual Management Expenses   (£583) (£583) (£583) (£583) (£583) (£583) (£583) (£583) (£583) (£583) (£583)
Gross Annual Cashflow less Expenses   (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994)
Vacancy Expenses                        
Net Annual Cashflow   (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994) (£11,994)
Net Yield %   (3.26%) (3.26%) (3.26%) (3.26%) (3.26%) (3.26%) (3.26%) (3.26%) (3.26%) (3.26%) (3.26%)
Debt Coverage Ratio (1:x)   0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45 0.45
Personal Equity £92,102 £92,102 £100,356 £109,032 £118,152 £127,739 £137,816 £148,409 £159,544 £171,249 £183,552 £196,485
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   (£12,056) (£3,802) £4,874 £13,995 £23,582 £33,659 £44,252 £55,387 £67,091 £79,395 £92,328
Return on Investment %   (13.09%) (4.13%) 5.29% 15.19% 25.60% 36.55% 48.05% 60.14% 72.84% 86.20% 100.25%
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   (£12,056) (£3,726) £4,681 £13,172 £21,751 £30,425 £39,200 £48,083 £57,079 £66,195 £75,438
Real Return on Investment %   (13.09%) (4.05%) 5.08% 14.30% 23.62% 33.03% 42.56% 52.21% 61.97% 71.87% 81.91%