BT64 Craigavon, Knockmenagh, Mandeville cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £96,893
Input Equity (£24,223)
Total Input Equity (£24,223)
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 £96,893 £96,893 £96,893 £96,893 £96,893 £96,893 £96,893 £96,893 £96,893 £96,893 £96,893 £96,893
Finance Amount £72,670 £72,670 £70,499 £68,217 £65,818 £63,297 £60,646 £57,860 £54,932 £51,853 £48,618 £45,216
Monthly Mortgage   (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480) (£480)
Monthly Rental   £467 £467 £467 £467 £467 £467 £467 £467 £467 £467 £467
Yield to Purchase Price %   5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78%
Yield to Property Value %   5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78% 5.78%
Gross Monthly Cashflow   (£13) (£13) (£13) (£13) (£13) (£13) (£13) (£13) (£13) (£13) (£13)
Gross Annual Cashflow   (£155) (£155) (£155) (£155) (£155) (£155) (£155) (£155) (£155) (£155) (£155)
Gross Annual Expenses                        
Annual Management Expenses   (£314) (£314) (£314) (£314) (£314) (£314) (£314) (£314) (£314) (£314) (£314)
Gross Annual Cashflow less Expenses   (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435)
Vacancy Expenses                        
Net Annual Cashflow   (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435) (£435)
Net Yield %   (0.45%) (0.45%) (0.45%) (0.45%) (0.45%) (0.45%) (0.45%) (0.45%) (0.45%) (0.45%) (0.45%)
Debt Coverage Ratio (1:x)   0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92 0.92
Personal Equity £24,223 £24,223 £26,394 £28,676 £31,075 £33,596 £36,246 £39,032 £41,961 £45,039 £48,275 £51,677
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   (£469) £1,702 £3,984 £6,383 £8,904 £11,554 £14,340 £17,269 £20,347 £23,583 £26,985
Return on Investment %   (1.94%) 7.03% 16.45% 26.35% 36.76% 47.70% 59.20% 71.29% 84.00% 97.36% 111.40%
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   (£469) £1,668 £3,826 £6,007 £8,213 £10,444 £12,703 £14,992 £17,311 £19,662 £22,048
Real Return on Investment %   (1.94%) 6.89% 15.80% 24.80% 33.90% 43.12% 52.44% 61.89% 71.46% 81.17% 91.02%