Gyaanleikh

  How to use, put case study and prompt both. CASE STUDY 1 — DCF VALUATION (WORD-TO-WORD) Valuing a Consumer Goods Company — DCF Fundamental intrinsic valuation · Entry-to-mid level interview · Foundational You are a junior analyst at a bulge bracket bank. Your MD hands you a task: value BeverageCo, a mid-size FMCG company generating ₹2,400 Cr in revenue. Management projects 12% revenue CAGR over 5 years with gradual margin expansion. Your job is to build a DCF model, arrive at an equity value per share, and present a bull/base/bear scenario. Company Financials (LTM) Revenue (₹ Cr): 2,400 EBITDA Margin: 18% EBIT Margin: 12% D&A (₹ Cr): 145 Capex (₹ Cr): 210 Net Debt (₹ Cr): 380 Shares Outstanding (Cr): 50 Tax Rate: 25% DCF Assumptions Parameter Bear Base Bull Revenue CAGR (Yr 1–5) 8% 12% 16% Terminal EBITDA Margin 17% 20% 23% WACC 13% 11% 10% Terminal Growth Rate 4% 5% 6% Implied EV/EBITDA (exit) ~10x ~13x ~16x Questions you must answer Build the ...

  1. Introduction What This Prompt Achieves: Creates a fully linked 3 Statement financial model using a single AI prompt This is not an industry-ready detailed model Industry models require much more thought: detailed revenue builds, cost and SG&A assumptions, and scenario & sensitivity analysis With current LLM context restrictions, it is not feasible to create detailed models with a single prompt As context windows increase and computing costs decrease, we will be able to create more detailed models from single prompts very soon ​​ Ideal Use Case For This Prompt:   If you work with boutique companies, boutique investment banks, or early-stage investment firms with simpler financials, this prompt creates functional operating models in minutes   2. Three-Statement Models vs. DCF Models Key Differences: DCF Models: Can be built with single prompts to a reasonable leve...