Financial Modelling Handbook

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

Download the reference file to practice: To obtain the worked example file to accompany this chapter buy the financial modelling handbook. There are two options for adding a new input. 1. Create the input on the input sheet, then link to it. 2. Create the input on the calculation sheet,

Getting proficient in these twelve skills will transform your model build effectiveness.

Your reputation as a financial modelling ninja awaits.

Learning keyboard shortcuts is a must for efficient working.