BT76 Clogher cash flow analysis

Customise this data

Cash Flow Chart

Cash Flow Analysis

Transaction Amount
Completion Price £249,950
Input Equity (£62,488)
Total Input Equity (£62,488)
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 £249,950 £249,950 £249,950 £249,950 £249,950 £249,950 £249,950 £249,950 £249,950 £249,950 £249,950 £249,950
Finance Amount £187,463 £187,463 £181,862 £175,976 £169,788 £163,284 £156,447 £149,260 £141,705 £133,764 £125,416 £116,642
Monthly Mortgage   (£1,237) (£1,237) (£1,237) (£1,237) (£1,237) (£1,237) (£1,237) (£1,237) (£1,237) (£1,237) (£1,237)
Monthly Rental   £397 £397 £397 £397 £397 £397 £397 £397 £397 £397 £397
Yield to Purchase Price %   1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91%
Yield to Property Value %   1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91% 1.91%
Gross Monthly Cashflow   (£840) (£840) (£840) (£840) (£840) (£840) (£840) (£840) (£840) (£840) (£840)
Gross Annual Cashflow   (£10,082) (£10,082) (£10,082) (£10,082) (£10,082) (£10,082) (£10,082) (£10,082) (£10,082) (£10,082) (£10,082)
Gross Annual Expenses                        
Annual Management Expenses   (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267) (£267)
Gross Annual Cashflow less Expenses   (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320)
Vacancy Expenses                        
Net Annual Cashflow   (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320)
Taxable Income                        
Tax Payable                        
Net Annual Cashflow Less Tax   (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320) (£10,320)
Net Yield %   (4.13%) (4.13%) (4.13%) (4.13%) (4.13%) (4.13%) (4.13%) (4.13%) (4.13%) (4.13%) (4.13%)
Debt Coverage Ratio (1:x)   0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30 0.30
Personal Equity £62,488 £62,488 £68,088 £73,974 £80,162 £86,666 £93,503 £100,690 £108,245 £116,186 £124,534 £133,308
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   (£10,349) (£4,749) £1,138 £7,326 £13,830 £20,667 £27,854 £35,409 £43,350 £51,697 £60,472
Return on Investment %   (16.56%) (7.60%) 1.82% 11.72% 22.13% 33.07% 44.58% 56.67% 69.37% 82.73% 96.77%
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   (£10,349) (£4,654) £1,093 £6,895 £12,756 £18,681 £24,674 £30,739 £36,880 £43,102 £49,410
Real Return on Investment %   (16.56%) (7.45%) 1.75% 11.03% 20.41% 29.90% 39.49% 49.19% 59.02% 68.98% 79.07%