LS22 Collingham, Linton, Wetherby cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £430,553
Input Equity (£107,638)
Total Input Equity (£107,638)
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 £430,553 £430,553 £430,553 £430,553 £430,553 £430,553 £430,553 £430,553 £430,553 £430,553 £430,553 £430,553
Finance Amount £322,915 £322,915 £313,268 £303,128 £292,470 £281,265 £269,488 £257,108 £244,095 £230,416 £216,037 £200,922
Monthly Mortgage   (£2,131) (£2,131) (£2,131) (£2,131) (£2,131) (£2,131) (£2,131) (£2,131) (£2,131) (£2,131) (£2,131)
Monthly Rental   £1,116 £1,116 £1,116 £1,116 £1,116 £1,116 £1,116 £1,116 £1,116 £1,116 £1,116
Yield to Purchase Price %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Yield to Property Value %   3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11% 3.11%
Gross Monthly Cashflow   (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015) (£1,015)
Gross Annual Cashflow   (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181) (£12,181)
Gross Annual Expenses                        
Annual Management Expenses   (£750) (£750) (£750) (£750) (£750) (£750) (£750) (£750) (£750) (£750) (£750)
Gross Annual Cashflow less Expenses   (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850)
Vacancy Expenses                        
Net Annual Cashflow   (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850) (£12,850)
Net Yield %   (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%) (2.98%)
Debt Coverage Ratio (1:x)   0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.50
Personal Equity £107,638 £107,638 £117,285 £127,425 £138,084 £149,288 £161,065 £173,445 £186,458 £200,137 £214,516 £229,631
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,931) (£3,284) £6,856 £17,515 £28,719 £40,496 £52,876 £65,889 £79,568 £93,947 £109,062
Return on Investment %   (12.01%) (3.05%) 6.37% 16.27% 26.68% 37.62% 49.12% 61.21% 73.92% 87.28% 101.32%
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,931) (£3,218) £6,584 £16,485 £26,489 £36,605 £46,840 £57,200 £67,694 £78,328 £89,111
Real Return on Investment %   (12.01%) (2.99%) 6.12% 15.31% 24.61% 34.01% 43.52% 53.14% 62.89% 72.77% 82.79%