Modelling a refinancing - retesting our hypotheses

With our early share capital redemption structure in place, we can now test our hypothesis about refinancing.

Reference start file for this assignment:  

Running our 10 to 14-year scenarios gives us a progression of incoming investor IRR that looks like this, confirming our hypothesis:

If you remember back to when we first talked about our “F11 quick chart” - we should always be looking at any discontinuities we see in our charts. In this chart, we can see that the slope of the IRR progression changes when we move from 13 to 14 years. What’s going on here?

If we check the cash flow statement, we can see that with a 14-year refinancing, we hit the limit of the cash we can extract through early share capital redemption.

We can see that the refinancing creates a $28m surplus. However, we are only able to distribute $22.4m through dividends and early share capital redemption. We are therefore retaining $5.7m of cash on the balance sheet, reducing the IRR gain from the refi.

Throughout this section, we have seen how our model can be used for exploratory analysis.

Your task is now to test for yourself how the debt sizing DSCR and interest margin impact shareholder IRR.

Reference file completed to this point:


Sign in or become a Financial Modelling Handbook member to join the conversation.
Just enter your email below to get a log in link.

Subscribe to Financial Modelling Handbook

Don’t miss out on the latest financial modelling guides. Sign up now to get access to the library of members-only guides.