Kenny Whitelaw-Jones

Download the reference file to practice the steps below: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. The golden rule of modelling that everybody knows is to separate inputs, calculations and outputs. However, when we are building up the calculations in our model,

We always keep a template sheet with the column structure and timeline set up in the model. Whenever we need a new sheet, we will copy this template. The keyboard sequence to copy a sheet is somewhat laborious. This is one of the few occasions when the mouse is more

Download the reference file to practice: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. Whenever we need to model a balance, we are generally going to use a corkscrew structure. Again, we strive to do things the same way each time, increasing efficiency

Download the reference file to practice: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. When I introduced Core skill 5 (Creating a calculation), I recommended not to apply row anchoring in a calculation. Row anchoring in a calculation makes it harder to copy

Note: there is no new reference file for this section. Consistent formatting is an important way of maintaining order in our models. Excel's built-in formatting tools are not very helpful. This chapter looks at the Productivity Pack shortcuts for applying formatting. By defining the formats we use, we

Download the reference file to practice: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. When creating a new calculation, most of your thinking time occurs when gathering the ingredients. This is the work of understanding what we're trying to model. Sometimes,

Download the reference fill to practice: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. We've already seen how to create a new link. We don't always have to create links from scratch. If we already have a link to

Download the reference file to practice: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. The next line item we need in our calculation block is an escalation factor. We have not modelled anything to do with inflation at this stage in the model

To obtain the worked example file to accompany this chapter buy the financial modelling handbook. When we created the power tariff input, we expressed the value in USD / kWh. The standard monetary unit in the model is thousands of dollars. We have modelled electricity generation in GWh. We, therefore, need