NN6 Brixworth, Cold Ashby, Earls Barton, Ecton, Guilsborough, Long Buckby Spratton, Sywell, West Haddon cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £316,326
Input Equity (£79,082)
Total Input Equity (£79,082)
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 £316,326 £316,326 £316,326 £316,326 £316,326 £316,326 £316,326 £316,326 £316,326 £316,326 £316,326 £316,326
Finance Amount £237,245 £237,245 £230,157 £222,707 £214,876 £206,645 £197,992 £188,897 £179,336 £169,286 £158,722 £147,617
Monthly Mortgage   (£1,566) (£1,566) (£1,566) (£1,566) (£1,566) (£1,566) (£1,566) (£1,566) (£1,566) (£1,566) (£1,566)
Monthly Rental   £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £800
Yield to Purchase Price %   3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04%
Yield to Property Value %   3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04% 3.04%
Gross Monthly Cashflow   (£766) (£766) (£766) (£766) (£766) (£766) (£766) (£766) (£766) (£766) (£766)
Gross Annual Cashflow   (£9,187) (£9,187) (£9,187) (£9,187) (£9,187) (£9,187) (£9,187) (£9,187) (£9,187) (£9,187) (£9,187)
Gross Annual Expenses                        
Annual Management Expenses   (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538) (£538)
Gross Annual Cashflow less Expenses   (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667)
Vacancy Expenses                        
Net Annual Cashflow   (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667) (£9,667)
Net Yield %   (3.06%) (3.06%) (3.06%) (3.06%) (3.06%) (3.06%) (3.06%) (3.06%) (3.06%) (3.06%) (3.06%)
Debt Coverage Ratio (1:x)   0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49 0.49
Personal Equity £79,082 £79,082 £86,169 £93,619 £101,450 £109,681 £118,334 £127,429 £136,990 £147,040 £157,604 £168,709
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   (£9,724) (£2,637) £4,813 £12,644 £20,875 £29,528 £38,624 £48,184 £58,234 £68,798 £79,903
Return on Investment %   (12.30%) (3.33%) 6.09% 15.99% 26.40% 37.34% 48.84% 60.93% 73.64% 87.00% 101.04%
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   (£9,724) (£2,584) £4,622 £11,900 £19,255 £26,691 £34,214 £41,830 £49,544 £57,361 £65,287
Real Return on Investment %   (12.30%) (3.27%) 5.84% 15.05% 24.35% 33.75% 43.26% 52.89% 62.65% 72.53% 82.56%