Godrej Consumer Products, sheet by sheet — why the order you study it in matters more than the sheets themselves.
Open any professional financial model for the first time and it looks intimidating — a dozen tabs, hundreds of rows, formulas referencing formulas. It’s tempting to treat it like one enormous spreadsheet you either understand or don’t.
It isn’t one thing. It’s a connected system where each sheet does one job and hands its output to the next. Once you see the wiring, the model stops being scary and starts being readable — almost like a story with a beginning, middle and end.
In this series we’ll take apart a complete financial model of Godrej Consumer Products Limited (GCPL), not to memorise its numbers, but to understand how a real model is built and how its parts talk to each other.
What a financial model actually is
An Excel-based representation of a company’s financial performance, built from historical results and pushed forward using assumptions.
- Historical financials
- Business assumptions
- Forecasting techniques
- Financial statements
- Supporting schedules
- Valuation methods
- Financial ratios
Meet the 17 worksheets of Financial Model
The workbook’s own index lists these in a fairly neutral order. Grouped by what each sheet is actually for, the shape of the model becomes clearer:
Here’s the part beginners miss: you should not study these in index order. You can’t forecast profit before revenue and costs exist. You can’t run a DCF before you have cash flows to discount. The model has dependencies — and dependencies dictate the reading order.
Why the Overview sheet comes first
Before a single number is forecast, the Overview sheet grounds you in the business itself: company background, industry classification, management, and a set of qualitative lenses.
- Demand & supply
- Future of FMCG
- Porter’s Five Forces
- SWOT analysis
This matters because you can’t sensibly forecast an FMCG company’s revenue without a feel for its products, markets, competition, raw material costs, distribution reach and the broader economic backdrop. Those qualitative factors are exactly what turn into the quantitative assumptions a few sheets later.
Historical data vs. Forecast data
The first skill in reading any model is spotting where “what actually happened” ends and “what we expect to happen” begins.
Historical
Taken straight from the company’s financial statements and annual reports. It’s a record, not an opinion.
Forecast
Historical data plus an assumption — usually a growth rate, margin, or ratio applied forward.
Every line item in the model uses this same logic — history plus an assumption — even where the assumptions get far more detailed than a single growth rate.
Why supporting schedules exist
New modellers often try to forecast the Income Statement and Balance Sheet directly. It works, until someone asks you to justify a number and you can’t trace where it came from.
The shortcut
- Guess inventory directly on the Balance Sheet
- Guess depreciation expense directly
- Guess interest expense directly
The schedule approach
- Working Capital schedule → forecasts inventory → feeds the Balance Sheet
- Depreciation schedule → feeds both the Income Statement and Balance Sheet
- Debt schedule → opening debt, borrowing, repayment, closing debt → interest expense → Income Statement
Supporting schedules are what make a model auditable. Anyone can open the Working Capital tab and see exactly why inventory grew the way it did — instead of a number that just appears.
How the 17 sheets actually talk to each other
This is the map worth bookmarking. Everything above feeds into this.
The order we’ll actually study this in
Not the workbook’s index order — the order the model is built in, so each sheet makes sense the moment you reach it.
Revenue Buildup
How historical sales are analysed and segments are forecast.
Cost Sheet
How different cost lines are analysed and projected forward.
Income Statement
Revenue and costs combine into operating profit and net profit.
Working Capital
Inventory, receivables and payables — the cash tied up in day-to-day operations.
Depreciation & Amortization
How fixed and intangible assets work their way into the financial statements.
Balance Sheet
Every supporting schedule converges here.
Cash Flow
The Income Statement and Balance Sheet combine to show actual cash generated.
Equity & Debt
How the business is financed, and how that financing evolves over time.
WACC, Beta & Market Return
The inputs needed for an appropriate discount rate.
DCF Valuation
Projected free cash flows, discounted, to estimate intrinsic value.
Ratios & DuPont Analysis
Standing back to judge how well the business actually performed.
What You Will Learn From This Series
By the end of this series, you should be able to understand not only what each financial modelling schedule does, but also why it exists and where its numbers come from.
You will learn how to move from:
Company Information
→ Revenue Forecast
→ Cost Forecast
→ Income Statement
→ Working Capital
→ Balance Sheet
→ Cash Flow
→ Debt & Equity
→ WACC
→ DCF Valuation
→ Financial Analysis
This is the approach we will use throughout the series.
The goal is to make the financial model understandable even if you are still learning financial modelling.
Read More: Marico Ltd. Financial Model: How I Built a DCF Valuation in Excel
Pingback: How Revenue Buildup is actually Forecasted? - The EquityVerse