Posts

What does an Investment Banker Do?

Image
What do an Investment Banker do each day? What does the day-to-day routine look like for a typical Banker? The short story is that your seniority in the hierarchy largely determines your daily routine. Showing the roles and responsibilities for Senior, Mid-Level, and Junior Investment Bankers There are three major buckets within the Investment Banking hierarchy: Senior Bankers – Managing Directors (‘MDs’) and Senior Vice Presidents (‘SVPs’) build and foster client relationships. Mid-Level Bankers – Vice Presidents (‘VPs’) lead deal execution. Junior Bankers – create supporting materials and analyses used to ‘Pitch’ clients for new business and for ‘Live Deal’ execution. As you can see above, what Investment Banker s do in each role is slightly different. In the coming sections, we’ll dig deeper into the roles and responsibilities at each level. A ‘Typical’ Investment Banking Career Path One of the most common questions at this point is, “What is the ‘typical’ Investment Banking career ...

Financial Modelling with AI

Image
  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 ...

Making 3 Statement Financial Model with the help of AI

  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...