Category: Quantitative analysis
-
Things to know before building the financial model | List of required Excel worksheets
There are few things that a modeler should know before building the financial model. We will try to keep this post as short as possible and most importantly to the point, which will help you to build the model with much more ease. Start with determining the number of tabs or worksheets to be…
-
Excel best practices while preparing financial models | List of important MS-Excel shortcuts
As a Financial Analyst, your key goal, while building a financial model, is to improve its transparency and audibility. Below are some of the Excel best practices while preparing financial models and list of important MS-Excel shortcuts 1. Color Coding: There are no hard and fast rules in assigning color codes to various inputs,…
-
What is financial modeling – It’s scope, uses, types, and how to build a financial model? | Explained
What is financial modeling? Financial modeling is a tool for decision making, let me elaborate, whenever you want to make a decision or let’s say a sensible decision, you need some data, some information, some calculation to support that. That usage of information, data to decide something is nothing but a financial model. Let’s narrow…
-
Porter 5 Forces Model – Explained | Industry analysis
Porter 5 forces model, a strategic framework that probably every business students and practitioner has heard about. But do you also know how to use it properly? Today you will be finding it out because I’m going to tell you everything you need to know about Porter’s 5 forces. History: In 1979, Michael Porter,…