I am at the end of finishing my BA degree in business administration with a minor in finance. I thought some of my finance classes would teach me how to build financial models, but that is not the case. I am reaching out to see if any of you could recommend a tutor to help teach me financial modeling? I have tried the online courses, but that is not working for me.
Any help, advice, or feedback would be greatly appreciated.
Air Force Veteran
Ryan - Here are five free or cheap resources you can use to learn more about financial modeling:
You might have to invest a little bit of money in yourself but I think it will be worth it.
Best of luck.
I would like to share some tips with you that have helped me to be able to create any complex financial model as well as update any complex financial model that has been created by someone else.
1. The term financial model is just a fancy word for an excel spreadsheet that has various cells linked together in order to help the user reach a conclusion, make a decision, or understand a particular set of circumstances.
2. Understanding some simple formulas in excel will enable you work and create 75% of the models. Know them well. (if you already know these you are step ahead, I'm not sure of your excel level.)
-Vlookup (though a much better formula is index/match which does the same and is faster. However when explaining to interviewers this skill, refer to vlookup as this is what they all want to hear.)
-countif and countifs
-Using = to link cells on the same page as well as other pages.
-AVG, DIV, + and -
You can quickly master these by typing the =, then the function name with an open parenthesis , and then hitting the fx button on the formula bar. For example type =countif(, then select the fx button and you will get the popup that walks you through entering the formula.
Any more complex formulas or questions can easily be learned by typing your question into google. Google is your friend and makes it easy!
For practice, you can make your own financial model based on your personal finances. Make a list with your monthly expenses with totals, create a list with your monthly income with totals, and create separate a cell for disposable income on another sheet which will be the monthly income total minus the disposable income total. Put some labels on your columns, make them bold and format the cell to have a lower border, and you have just created a simple model!
Remember Modeling is somewhat like an art, you can be as creative as you want. Think of different things to model and practice building them. For example, buying a house that appreciates using a loan versus saving the money at an interest rate . Have a couple cells that are variables so that when you change those cells (with different interest rates or rates of appreciation) and your total estimated profit will change.
The key here is this: If you think you can you can, and if you think you can't you can't!
Please log in to answer this question.