Please upgrade your web browser

These pages are built with modern web browsers in mind, and are not optimized for Internet Explorer 8 or below. Please try using another web browser, such as Internet Explorer 9, Internet Explorer 10, Internet Explorer 11, Google Chrome, Mozilla Firefox, or Apple Safari.

AdvisorNet

Private Equity...Financial Modeling

Veteran

Ryan Brown Melbourne, FL

Greetings everyone,

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.

Thank you,

Ryan Brown
Air Force Veteran

25 January 2019 2 replies Career Advancement

Answers

Advisor

Emanuel Carpenter Atlanta, GA

Ryan - Here are five free or cheap resources you can use to learn more about financial modeling:

https://www.udemy.com/topic/financial-modeling/

https://www.edx.org/professional-certificate/babsonx-financial-decision-making-for-leaders#courses

https://www.coursera.org/specializations/wharton-business-financial-modeling

https://www.pluralsight.com/courses/financial-modeling-business-plan

https://www.linkedin.com/learning/topics/small-business-and-entrepreneurship

You might have to invest a little bit of money in yourself but I think it will be worth it.

Best of luck.

26 January 2019 Helpful answer

Veteran

Peter Holmes Arlington, TX

Hi Ryan,

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.)
-Sumif sumifs
-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
--sum
-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!

25 January 2019 Helpful answer

Your Answer

Please log in to answer this question.

Sign Up

You can join as either a Veteran or an Advisor.

An Advisor already has a career, with or without military experience, and is willing to engage with and help veterans.
Sign Up as an Advisor.

A Veteran has military experience and is seeking a new career, or assistance with life after service.
Sign Up as a Veteran.