In this workout, we've analyzed some quarterly results and we're now going to make three changes to our model. We're going to update our revenue growth and margin assumptions for the latest results. We're going to update the model to show reported results as actuals. And finally we're going to change the model layout to include non-recurring costs so that we can track both underlying and reported ebitdar. Now, we're going to make these changes below the original model in this workout so that we can compare versus the original and we're going to do that in the updated forecast section Below in practice. We would usually copy and paste hardcoded versions of our original forecast into a separate tab before updating our live model now, let's scroll down to the updated forecast section.

Latest results showed Revenue growth of 5.4% and margins of 38.2% So let's put these as our forecast assumptions for each of the next three quarters.

The next step is to update the model to show the reported results as actuals.

reported revenues were 1057.7 and underlying ebitda was 404 we can now use the revised assumptions to revise our forecasts.

We then just need to copy our formulas over to the right.

And then just calculate our annual forecasts.

The final step is that we need to create two extra lines in our model so that we can include the non-recurring costs and the reported ebitdr that allows us to track both underlying and reported metrics. now if we look down we can see these two extra lines have already been created for us. So we start by typing in the nonrecating costs and we'll assume that there's no further non-recurring costs going forward. And we just then need to calculate the reported figure.

And we can then sum the quarterly figures. To give the annual reported a bit dial number. So we've now updated the model for the quarterly results.