⇧ Build offers into financial model

Your CEO Vanessa Williams has just sent you an email:

“Well done for obtaining three offers – this is great news!

I am keen to understand the financial implications of each offer to determine their total financing costs and overall impact on share capital dilution.

Please can you build the three offers into our financial model and show the impact that they would have on our income statement, financial position, cash flows and share capital table for each month from 1 January 20X3 until 31 December 20X7.

You should assume that all options will convert in full on the 31 December 20X5 maturity date at a VSC business valuation of $500 million.”

⇧ Action required

Update your financial model to show the impact of the three offers as requested by Vanessa and upload it below.