Anyone in any industry wishing to learn how to create a clear, concise model ..fast! The principles taught in this course could equally be applied to a non-financial model as well, in any industry.
We start with assumptions/inputs for a global manufacturing company with operations in six different countries, (thus six different currencies) and with a construction and an operations phase. You will then create a model “from scratch”, containing key outputs (shown quarterly) to arrive at a valuation of the business, and then in a few keystrokes you will create key outputs (shown annually), and a report with impressive presentation, and then look at sensitivities (and the best Excel tools to use for such). We will be employing some advanced Excel formulae, which we will cover initially on Day 1.
In this course we will be constructing a model with not too many variants, however in real life businesses are complex i.e. you could be asked to forecast ( i.e. model), the annual quantity of petrol required for 2,000 trucks, which have an option of 38 different routes, depending on weight of goods transported, destination, number of drivers available, weather conditions, and 20 other inputs …thus it will make your job easier if you can adhere to the tenets of best practice modelling- which we will teach in this course.
Starting with a list of inputs, we teach how to build a financial model from a blank Excel sheet:
Think you got it right? Before we go on to performing sensitivities (below) we need to check we got the base case correct. In addition to the error checks we have built in we cover the following:
Now that we’ve created the “base case” above, we look at sensitivities: