You have spent weeks brainstorming a creative strategy for an MBA case competition. You have defined a target user, designed a product feature, and mapped out a distribution plan. But when you present your deck to corporate judges, the finance director asks:
“What is the capital expenditure required for this launch, and what is our estimated Net Present Value (NPV) over a five-year horizon?”
If your deck does not have a financial model, or if your numbers are clearly made up without any underlying logic, your entire strategy collapses. Judges want to see that your creative ideas make commercial sense. You do not need a 20-sheet Investment Banking model, but you do need a robust, back-of-the-envelope financial projection.
In this guide, we will walk you through how to forecast a P&L statement, calculate Net Present Value (NPV) and Internal Rate of Return (IRR), estimate the Cost of Capital, perform sensitivity analyses, and present your financials to win national finals.
1. Forecasting the P&L (Profit & Loss) Statement
A P&L statement projects the revenues, costs, and profits of your proposed strategy over a fixed period (typically 3 to 5 years). Keep your projections realistic. In the first year, focus on market preparation and pilot launches—do not project massive profits on day one.
Structuring Your P&L Forecast:
$$\text{Revenue} = \text{Total Market Size} \times % \text{ Market Share} \times \text{Average Selling Price}$$
$$\text{Gross Profit} = \text{Revenue} - \text{Cost of Goods Sold (COGS)}$$
$$\text{EBITDA} = \text{Gross Profit} - \text{Operating Expenses (OpEx)} - \text{Marketing Expenses}$$
$$\text{Net Profit (EAT)} = \text{EBITDA} - \text{Depreciation} - \text{Interest} - \text{Taxes}$$
Pro-Tips for Forecasting:
- Match your marketing spend to customer acquisition: If you target 100,000 new customers in Year 2, and your Customer Acquisition Cost (CAC) is ₹500, your marketing budget must be at least ₹5 Crore.
- Account for inflation: Increase your prices and operating costs by 5-6% annually to reflect the Indian macroeconomic environment.
2. Calculating Investment Viability: NPV and IRR
When your strategy requires an initial investment (CapEx)—such as building a new factory, developing a software platform, or launching a massive marketing campaign—you must justify that cost.
Net Present Value (NPV)
NPV measures the value of all future cash flows generated by the project, discounted back to the present day. A positive NPV indicates that the project will generate value.
$$\text{NPV} = \sum_{t=1}^{n} \frac{\text{Free Cash Flow}_t}{(1 + r)^t} - \text{Initial Investment}$$
Where $r$ is the discount rate (Cost of Capital), and $t$ is the year.
Internal Rate of Return (IRR)
IRR is the discount rate at which the NPV of the project becomes zero. In simple terms, it is the expected annual return the project will deliver.
- Decision Rule: Recommend the project if its IRR is higher than the company’s Hurdle Rate (the minimum acceptable return, typically 12% to 15% for corporate investments in India).
3. Determining the Cost of Capital (Discount Rate)
To discount future cash flows, you need a discount rate. A common mistake in case competitions is using a random percentage (like 10%) without explaining why.
You should use the Weighted Average Cost of Capital (WACC). In India, a typical corporate WACC ranges between 11% and 14%:
- Cost of Debt: If the firm borrows money from banks, the interest rate is typically 8% to 10% (pre-tax).
- Cost of Equity: Calculated using the Capital Asset Pricing Model (CAPM). Given India’s risk-free rate (~7% government bond yields) and market risk premiums, cost of equity is usually 13% to 16%.
- Hurdle Rate: For high-risk strategies (like entering a brand new market or launching a new technology), companies often add a risk premium, pushing the hurdle rate to 15% or 18%.
4. Addressing Uncertainty: Sensitivity Analysis
No business plan goes exactly as expected. Proposing a single set of financial numbers looks naive. You must show the judges how your model reacts to changes in key assumptions.
A Sensitivity Matrix (typically built in Excel using the Data Table tool) shows how NPV or IRR changes based on shifts in variables like Pricing and Market Penetration.
EBITDA Margin Sensitivity Matrix (in ₹ Crores)
┌───────────────────────┬──────────────────────────────────────────┐
│ │ Average Selling Price (MRP) │
│ ├────────────┬────────────┬────────────────┤
│ Market Penetration % │ -10% MRP │ Base Case │ +10% MRP │
├───────────────────────┼────────────┼────────────┼────────────────┤
│ 0.5% (Pessimistic) │ ₹1.2 │ ₹3.5 │ ₹5.8 │
├───────────────────────┼────────────┼────────────┼────────────────┤
│ 1.5% (Base Case) │ ₹8.4 │ ₹12.0 │ ₹16.5 │
├───────────────────────┼────────────┼────────────┼────────────────┤
│ 3.0% (Optimistic) │ ₹19.5 │ ₹28.0 │ ₹38.2 │
└───────────────────────┴────────────┴────────────┴────────────────┘Including this table shows judges that you have evaluated downside risks and have plans in place to protect the firm’s capital if market growth slows.
5. How to Present Financials on One Slide
Do not dump your raw Excel sheets onto your slide deck. Keep the presentation executive-ready:
- Make the final metrics prominent: Put the NPV, IRR, Payback Period (in months), and Year 3 Profit Margin in massive, bold font at the top of the slide.
- Use visual summaries: A waterfall chart showing the revenue-to-cost breakdown is much easier to read than a table of numbers.
- Always cite your assumptions: Add a footnote listing the source of your cost and market sizing assumptions (e.g., “Raw material costs assumed at ₹40/kg based on industry reports. Discount rate set at 12% WACC.”).
Validate Your Financial Logic with CaseEdge
Building a realistic financial model is critical to winning corporate case competitions and passing consulting partner interviews.
CaseEdge helps MBA students build structured, logically sound business cases.
- Access financial modeling outlines and check typical margin, CAC, and operational benchmarks across different industries.
- Ensure your revenue models sync perfectly with your market sizing (TAM) and target penetration rates.
- Get AI-powered sanity checks on your NPV/IRR calculations and capital expenditure estimations.
Build business cases that finance directors approve. Step up your preparation with CaseEdge.