Common Financial Modelling Mistakes
Building a financial model can be a complex task, especially when you have already spent a lot of time setting up formulas, and now your model keeps throwing errors that you can’t figure out. Below is a list of a few common mistakes that one must keep in mind while building your model in Excel.
Be careful while using sum formulas in excel. If you have subtotals, and totals, ensure that correct cells have been selected while calculating sums. No entry should be included twice, especially the cells containing subtotals.
Avoid hardcoding numbers if possible. When you need to make an assumption about a number, create an input cell in a separate area and refer to that cell in your model or formula.
Scan for formula errors. Check if the formula in parenthesis is the way it should be. Verify for one or two data sets, before you actively use it in your model.
You are likely to make more mistakes if you have a large formula. Simplify the number of steps of large formula into smaller, doable steps that you can check and pinpoint errors far more quickly.
Ensure that the numbers are entered at the right places. Be clear in using relative referencing and where to use absolute referencing. Use absolute referencing to lock in places for certain values. This is important especially when you have the same formula replicating in many cells.
Very often models are built from a source file that has come through e-mail. It is extremely important that the source file data is accurate and usable for further modeling or references.
Mixing up positive and negative numbers is a very common error in a cash flow model, any outflow should carry a negative sign and any inflow a positive sign.
Date functions can be annoying. Avoid manual calculating such as adding 30 days to reach another month, and instead use intelligent date functions provided in excel.