LL77 Bodffordd, Rhostrehwfa, Talwrn, Llangefni cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £226,016
Input Equity (£56,504)
Total Input Equity (£56,504)
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 £226,016 £226,016 £226,016 £226,016 £226,016 £226,016 £226,016 £226,016 £226,016 £226,016 £226,016 £226,016
Finance Amount £169,512 £169,512 £164,448 £159,125 £153,530 £147,648 £141,466 £134,967 £128,136 £120,955 £113,407 £105,473
Monthly Mortgage   (£1,119) (£1,119) (£1,119) (£1,119) (£1,119) (£1,119) (£1,119) (£1,119) (£1,119) (£1,119) (£1,119)
Monthly Rental   £742 £742 £742 £742 £742 £742 £742 £742 £742 £742 £742
Yield to Purchase Price %   3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94%
Yield to Property Value %   3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94% 3.94%
Gross Monthly Cashflow   (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376) (£376)
Gross Annual Cashflow   (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517) (£4,517)
Gross Annual Expenses                        
Annual Management Expenses   (£499) (£499) (£499) (£499) (£499) (£499) (£499) (£499) (£499) (£499) (£499)
Gross Annual Cashflow less Expenses   (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963)
Vacancy Expenses                        
Net Annual Cashflow   (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963) (£4,963)
Net Yield %   (2.20%) (2.20%) (2.20%) (2.20%) (2.20%) (2.20%) (2.20%) (2.20%) (2.20%) (2.20%) (2.20%)
Debt Coverage Ratio (1:x)   0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63 0.63
Personal Equity £56,504 £56,504 £61,568 £66,891 £72,486 £78,368 £84,550 £91,049 £97,880 £105,061 £112,609 £120,543
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   (£5,016) £48 £5,371 £10,966 £16,847 £23,030 £29,529 £36,360 £43,541 £51,089 £59,023
Return on Investment %   (8.88%) 0.08% 9.50% 19.41% 29.82% 40.76% 52.26% 64.35% 77.06% 90.42% 104.46%
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   (£5,016) £47 £5,158 £10,321 £15,540 £20,817 £26,158 £31,565 £37,043 £42,595 £48,226
Real Return on Investment %   (8.88%) 0.08% 9.13% 18.27% 27.50% 36.84% 46.29% 55.86% 65.56% 75.38% 85.35%