Excel financial modelling
You can search our site for finance training topics.
Or you can find out more about our Excel financial modelling course training:
Sometimes in financial modelling you want to keep a key result or error check in view while you are working. Perhaps you want to keep an eye on a balance sheet error check, or a key financial ratio while you are modelling. Perhaps you want to make sure that no step...3D referencing allows you to apply the same formula across a number of tabs. In financial modelling 3D referencing can be useful if you have a large model, with a large number of identical tabs. Perhaps each tab represents an operating subsidiary, and you’d...Prices in an Excel financial model often escalate for example by inflation. Escalation factors in a financial model: the problem In financial modelling a problem can occur when the escalation factor (e.g. the Retail Price Index) is published at the end of one time...Excel’s date functions can be helpful in financial modelling. If you have a monthly or quarterly financial model, you will want to roll months or quarters (= three months) forward. Of course Excel stores dates as numbers, which the next day one integer longer...Excel data tables can be used to output results of financial modelling, plotting one key variable against another, showing the impact on the main result. A common example might be plotting the impact of two key inputs (e.g discount rate and long term growth rate) on a...