Comerze › Blogs › Skills & Careers

Financial Modelling Basics for Commerce Students: Build Your First Model

Employers love people who can build a clean model. Here is a simple start.

By Comerze DeskUpdated 10 November3 min read

Reviewed by Comerze Desk

The 5 building blocks

  1. Assumptions sheetPut every input (growth rate, price, cost %) in one place.
  2. Revenue forecastUnits x price, by month or year.
  3. CostsFixed and variable costs separately.
  4. StatementsProfit and loss, cash flow, balance sheet linked by formulas.
  5. ScenariosBest, base and worst case switch.

A tiny worked example

A coffee cart sells 100 cups a day at Rs 60 for 30 days. Revenue = 100 x 60 x 30 = Rs 1,80,000 a month. Variable cost is Rs 25 a cup = Rs 75,000. Fixed cost is Rs 40,000. Profit before tax = 1,80,000 - 75,000 - 40,000 = Rs 65,000. (Illustrative numbers.) Now change cups per day to 70 and see profit fall. That is a scenario.

ItemFormulaResult (Rs)
Revenue100 x 60 x 301,80,000
Variable cost100 x 25 x 3075,000
Fixed costInput40,000
Profit before taxRevenue - costs65,000

Excel habits that make you look professional

  • Blue for inputs, black for formulas
  • One formula per row, copy across
  • No hard-coded numbers inside formulas
  • Add checks (balance sheet must balance)
  • Label units and periods
Pro tipPractise on real data

Pick a listed company's public annual report and model one year ahead. Compare your assumptions with management commentary.

Strengthen the basics: Excel skills and financial statements.

Keep reading

Tools & courses for CA studentsMarketplace