FM Intro and Best Practices
Build a Financial Model
Lay Out Assumptions
Inputs at the top, color-coded blue — never hardcoded in formulas.
Build the Income Statement
Revenue, COGS, OpEx, EBITDA — driven by assumptions.
Add Balance Sheet
Working capital, fixed assets, debt — must balance.
Cash Flow Reconciles
Operating, investing, financing — ties to balance sheet cash.
Noble Desktop's Financial Analyst Training Program covers financial modeling, valuation, accounting, and Excel for finance.
Delve into an informative guide on the most widely used financial models and discover essential tips for reducing errors in your financial modelling process.
The most famous and widely used financial models are:
- Three Statement Model
- DCF model (Discounted Cash Flow Analysis)
- LBO model (Leveraged Buyout)
- M&A Model (Mergers and Acquisitions)
- Trading Comps Model
- Transaction Comps Model
- Other
In order to minimize errors when building your financial models, follow five basic steps:
Excel Tips for Financial Modeling
It’s very important to follow best practices in Excel when building a model:
- Try to limit or eliminate the use of your mouse (keyboard shortcuts are much faster)
- Incorporate a blue font for hard codes and inputs (but formulas should stay black)
- Keep formulas simple and break down complex calculations into steps
- Make use of cell comments (Shift + F2) for explanations, so the model would be easy to follow for you when you come back to it later as well as for the other users
Recommended Set Up (ALT F T F)
