LU1 Luton (South), Aley Green, Caddington, Lower Woodside, Pepperstock, Skimpot, Slip End, Woodside cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £242,355
Input Equity (£60,589)
Input Equity FX (£60,589)
Total Input Equity (£60,589)
Total Input Equity FX (£60,589)
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 £242,355 £242,355 £242,355 £242,355 £242,355 £242,355 £242,355 £242,355 £242,355 £242,355 £242,355 £242,355
Finance Amount £181,766 £181,766 £176,336 £170,629 £164,629 £158,322 £151,693 £144,724 £137,399 £129,699 £121,606 £113,098
Monthly Mortgage   (£1,200) (£1,200) (£1,200) (£1,200) (£1,200) (£1,200) (£1,200) (£1,200) (£1,200) (£1,200) (£1,200)
Monthly Rental   £863 £863 £863 £863 £863 £863 £863 £863 £863 £863 £863
Yield to Purchase Price %   4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27%
Yield to Property Value %   4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27% 4.27%
Gross Monthly Cashflow   (£337) (£337) (£337) (£337) (£337) (£337) (£337) (£337) (£337) (£337) (£337)
Gross Annual Cashflow   (£4,039) (£4,039) (£4,039) (£4,039) (£4,039) (£4,039) (£4,039) (£4,039) (£4,039) (£4,039) (£4,039)
Gross Annual Expenses                        
Annual Management Expenses   (£580) (£580) (£580) (£580) (£580) (£580) (£580) (£580) (£580) (£580) (£580)
Gross Annual Cashflow less Expenses   (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557)
Vacancy Expenses                        
Net Annual Cashflow   (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557) (£4,557)
Net Yield %   (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%) (1.88%)
Debt Coverage Ratio (1:x)   0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68 0.68
Personal Equity £60,589 £60,589 £66,019 £71,726 £77,726 £84,033 £90,662 £97,631 £104,956 £112,656 £120,749 £129,257
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   (£4,619) £811 £6,519 £12,519 £18,825 £25,455 £32,423 £39,748 £47,448 £55,542 £64,050
Return on Investment %   (7.62%) 1.34% 10.76% 20.66% 31.07% 42.01% 53.51% 65.60% 78.31% 91.67% 105.71%
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   (£4,619) £795 £6,261 £11,782 £17,364 £23,009 £28,722 £34,506 £40,367 £46,308 £52,333
Real Return on Investment %   (7.62%) 1.31% 10.33% 19.45% 28.66% 37.98% 47.40% 56.95% 66.62% 76.43% 86.37%