Basic financial modelling self help!

Introduction to financial modelling.

*This page is to assist beginners and those who want to know what financial modelling is. This page will NOT consist of built models etc.*

**Most information found online, edited by me to provide a comprehensive picture of  financial modelling**

Financial modeling is one of the most highly valued but thinly understood skills in finance.  The objective is to combine accounting, finance, and business metrics to create an abstract representation of a company in Excel, forecasting figures into the future. These can be done by using financial models. These models are usually characterized by performing calculations and making recommendations based on that information. The model may also summarize particular events for the end user such as investment management returns or the Sortino ratio, or it may help estimate market direction, such as the Fed model.

Some standard uses for financial models (from corporatefinanceinstitute.com):

  1. making business decisions at a company.
  2. making investments in a private or public company.
  3. pricing securities
  4. undergoing a corporate transaction such as a merger, acquisition, divestiture, or capital raise.

What YOU need to have in order to do financial modelling (from corporatefinanceinstitute.com):

  1. A solid understanding of accounting
  2. Strong Excel skills
  3. Knowing how to link the 3 financial statements (income statement, balance sheet, cash flow sheet)
  4. Understanding how to build a forecast
  5. A logical framework for problem-solving
  6. Attention to detail
  7. Ability to distill large amounts of data into a simple format
  8. An eye for design and aesthetics
  9. Clear presentation skills
  10. The ability to easily zoom in on details, and zoom out to high-level strategy

 

An example of a financial model: (done by myself, not extracted from anywhere. If there are any errors or you don’t think that this is done right, please feel free to contact me and let me know. Its always fun to learn more)

SS1

SS2.png

**the above model used is known as the Residual Income model**

If you want to be certified as one who knows how to utilize financial models well, please head over to corporatefinanceinstitute.com. They have this certificate known as the FMVA, which is a fully online module that costs $497 USD. Here’s a screenshot of their webpage and the aforementioned module:

cfi-fmva.png

 

Will update more when I’m more knowledgeable about financial modelling. 🙂

 

Sources: www.corporatefinanceinstitute.com

https://www.investopedia.com/terms/f/financialmodeling.asp

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close