The following video is borrowed from our BusinessTraining.com platform and was originally recorded for our investment banking training program. Financial modeling is fundamental to a career in investment banking so we’ve enlisted the help of investment banking veterans to help us create high-quality free content on this important topic. Here is the second of a two part series on financial modeling best practices. To watch part one of this series, click here.
Video Transcript/Summary: The strategies and tips provided within this video module include:
Coming soon.
I hope that this video has shown you some important financial modeling best practices. To watch part one of this series, click here.
The following video is borrowed from our BusinessTraining.com platform and was originally recorded for our investment banking training program. Financial modeling is fundamental to a career in investment banking so we’ve enlisted the help of investment banking veterans to help us create high-quality free content on this important topic. Here is the first of a two part series on financial modeling best practices. To watch part two of this series, click here.
Video Transcript/Summary: The strategies and tips provided within this video module include:
Coming soon.
I hope that this video has shown you some important financial modeling best practices. To watch part two of this series, click here.
The following video is borrowed from our BusinessTraining.com platform and was originally recorded for our financial modeling training program. In the following video, we continue with our lesson on Excel formulas and how you can use Excel formulas for financial modeling. If you would like to watch the first part of this lesson on Excel financial formulas, click here.
Video Transcript/Summary: The strategies and tips provided within this video module include:
Coming soon.
I hope that this has been a good introduction to using Excel financial formulas. If you would like to watch the first part of this lesson on Excel financial formulas, click here.
The following video is borrowed from our BusinessTraining.com platform and was originally recorded for our financial modeling training program. In the following video, you will see some common financial model errors and learn how to avoid them.
Video Transcript/Summary: The strategies and tips provided within this video module include:
One of the most common types of error is related to data entry, even for those who are being very careful. Therefore, embedding formulas within the excel model is important, rather than relying on manual calculations.
Ensure to watch out for errors in parenthesis and always check to see the value calculated appears reasonable. If you can, check your formula against simple math. Some of excels financial formulas are also a little tricky so if you don’t know exactly what you are doing, use the excel help function.
Break long formulas into simple steps and add or multiply those formula segments. in these formulas, double-check that your formula refers to the right cells. Finally, know which formula to use and what parameters to specify (i.e. NPV or XNPV, SUM or SUMPRODUCT or SUMIF etc.)
By selecting a cell and clicking F2, it highlights the cell references in your formula in different, easy to see colours. This is particularly useful when working on a new version of a model where changes have been made (i.e. adding or deleting rows and columns). be very patient with these changes.
Excel allows you to name and define ranges, which can really help make formulas easy to develop. The main gains from adopting this is the efficiency, transparency and simplicity of the resulting excel model. To name a cell, simply click on it and type the name you want above.
When in doubt, use the excel help feature. Type your query in the top right of your excel window. If you cant find the answer you are looking for, simply type the query into Google where an answer should be provided.
Be sure to avoid these financial model errors in order to construct better, more accurate financial models.
Your friends here at https://investmentcertifications.com