However, a model is more than just a spreadsheet. Unlike a standard financial report, which looks backward at historical data, a financial model is forward-looking. It is dynamic, meaning that changing a single input (an assumption) triggers a cascade of updates throughout the entire forecast. For instance, if you adjust the expected growth rate of sales from 5% to 10%, the model should instantly recalculate everything from tax obligations to the need for new inventory, ultimately changing the company’s valuation.
Do not mix millions with thousands. Decide on a scale (e.g., all numbers in $000s) and stick to it. A common error is dividing a number in thousands by a number in millions, resulting in an output that is off by a factor of 1,000.
This is the baseline. It links the Income Statement, Balance Sheet, and Cash Flow Statement dynamically. If you change revenue growth in the Income Statement, the Balance Sheet automatically updates retained earnings and cash. Every aspiring analyst must master this first.
This is the most artistic part. Do not project "Revenue" by just adding 5% per year. Use .
: Summarizes revenues and expenses to show net income.
Think of it as a flight simulator for business. Before a pilot flies a real plane, they spend hours in a simulator. Similarly, before a company raises debt, acquires a competitor, or launches a new product, they run a financial model.