A good Financial Modelling and Valuation Course does not only teach students how to use Excel formulas. It also helps them understand where numbers come from, why a particular assumption is used and how changing that assumption can affect the business forecast.
What Are Assumptions in Financial Modelling?
Assumptions are estimates or inputs used to build a financial model. They help convert historical business information into future projections.
For example, a model may use assumptions for:
Revenue growth
Gross margin
Employee costs
Marketing expenses
Tax rates
Working capital
Capital expenditure
Depreciation
Debt and interest costs
These assumptions are usually based on historical performance, management guidance, industry trends, company strategy and other available information.
CFA Institute also highlights the importance of forecasting revenues, costs, working capital and capital investments when developing financial statement models.
Why Are Assumptions Important?
Suppose a company generated ₹100 crore in revenue last year. If the model assumes 10% annual growth, the forecast revenue would be ₹110 crore.
But what if the assumption changes to 15%?
The projected revenue becomes ₹115 crore.
That difference can affect operating profit, cash flow, valuation and potentially the overall investment view.
This shows why assumptions are not simply numbers entered into an Excel sheet. They influence the entire model.
Types of Assumptions Students Learn
A Financial Modelling and Valuation Course may introduce students to several categories of assumptions.
Revenue Assumptions
Revenue can be forecast using historical growth, volume and price assumptions, customer numbers, market growth or other business-specific drivers.
For example:
Revenue = Number of Customers × Average Revenue per Customer
This approach can sometimes provide a more meaningful forecast than simply applying a percentage growth rate.
Cost Assumptions
Costs may be forecast as a percentage of revenue or through individual business drivers.
Common examples include:
Employee expenses
Raw material costs
Selling expenses
Administrative costs
Technology expenses
Understanding whether a cost is fixed or variable can make the model more realistic.
Working Capital Assumptions
Working capital is another important area of financial modelling.
Receivables, inventory and payables can affect how much cash a company needs to operate. A change in these items can therefore influence projected cash flows.
Capital Expenditure Assumptions
Businesses often need to invest in property, equipment, technology or other assets. Financial models may include assumptions about future capital expenditure and depreciation.
Financing Assumptions
Models may also include assumptions related to debt, interest rates, repayment schedules and equity.
Historical Data vs Future Assumptions
One common mistake beginners make is treating historical trends as guaranteed future results.
Historical data is useful, but it should not automatically become the forecast.
A company may have grown by 20% for several years, but future growth could slow because of competition, market maturity or changing customer behaviour.
Therefore, financial modelling requires both numerical analysis and business understanding.
CFA Institute notes that valuation and forecasting require judgement when selecting inputs and considering business and industry conditions.
How Scenario Analysis Helps
Another useful technique is scenario analysis.
Instead of creating only one forecast, a model can consider different possibilities.
For example:
Base Case: 10% revenue growth
Optimistic Case: 15% revenue growth
Downside Case: 5% revenue growth
The model can then show how each scenario affects revenue, profitability and valuation.
This gives the user a better understanding of potential outcomes instead of relying on one fixed forecast.
What Students Can Learn in a Financial Modelling and Valuation Course
A practical course can help students understand how assumptions flow through a financial model.
The learning process may include:
Studying historical financial statements
Identifying important business drivers
Creating an assumptions sheet
Forecasting revenue and expenses
Linking assumptions with financial statements
Building supporting schedules
Testing different scenarios
Reviewing the impact on valuation
The WallStreet School's Financial Modeling & Valuation program focuses on practical model building, including integrated financial models and valuation techniques.
Common Mistakes in Financial Model Assumptions
Beginners may make several mistakes while creating assumptions.
Some common ones include:
Using unrealistic growth rates
Ignoring historical trends
Applying the same assumption to every year
Forgetting business seasonality
Mixing assumptions with formulas
Not testing different scenarios
Using unsupported estimates
A well-structured model should make assumptions easy to identify, review and change.
Who Should Learn This Skill?
Understanding financial model assumptions can be useful for students, finance professionals, analysts and anyone interested in areas such as investment banking, equity research, corporate finance or valuation.
It is especially useful for learners who want to move beyond basic Excel skills and understand how financial analysis works in practice.
Conclusion
Financial modelling is not just about building formulas in Excel. It is about understanding a business, identifying its important drivers and translating those drivers into reasonable financial assumptions.
A Financial Modelling and Valuation Course can help learners develop this approach by combining financial statements, forecasting, Excel and valuation. When assumptions are logical and clearly structured, the resulting model becomes much more useful for analysis and decision-making.
