Wall Street Prep

ChatGPT just built a DCF model. 🤯 But what does this mean for finance? Economist Richard Baldwin said, "AI won't take your job. It's somebody using AI that will take your job." That reality is now hitting the finance world: AI is changing how models are built and what skills analysts need to stay ahead. Wall Street Prep Founder & CEO Matan Feldman walks through how to build a DCF model from scratch—and what this shift means for the future of analysts. 𝗠𝗮𝘁𝗮𝗻'𝘀 𝗣𝗿𝗲𝗱𝗶𝗰𝘁𝗶𝗼𝗻'𝘀 𝗼𝗻 𝘁𝗵𝗲 𝗙𝘂𝘁𝘂𝗿𝗲 𝗼𝗳 𝗔𝗜 𝗶𝗻 𝗜𝗻𝘃𝗲𝘀𝘁𝗺𝗲𝗻𝘁 𝗕𝗮𝗻𝗸𝗶𝗻𝗴: 𝗖𝗵𝗮𝘁𝗚𝗣𝗧 𝘃𝘀. 𝗔𝗻𝗮𝗹𝘆𝘀𝘁𝘀 Secure AI tools will rapidly replace much of the grunt work analysts do today—financial modeling, slide creation, and valuation analysis. Analysts will shift to higher-level strategic work. 𝗧𝗵𝗲 𝗙𝘂𝘁𝘂𝗿𝗲 𝗼𝗳 𝗙𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗠𝗼𝗱𝗲𝗹𝗶𝗻𝗴 Analysts won’t be building models; they’ll be guiding AI to do it for them and refining outputs. 𝗣𝗶𝘁𝗰𝗵𝗯𝗼𝗼𝗸 𝗖𝗿𝗲𝗮𝘁𝗶𝗼𝗻 AI will generate slides, while analysts will focus on storytelling and refining the messaging. 𝗣𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆 𝗦𝗵𝗶𝗳𝘁 The role of an analyst will look more like today’s associate—less number crunching, more critical thinking. 𝗪𝗵𝗮𝘁 𝗪𝗶𝗹𝗹 𝗛𝗲𝗹𝗽 𝗦𝗲𝘁 𝗔𝗻𝗮𝗹𝘆𝘀𝘁𝘀 𝗔𝗽𝗮𝗿𝘁? • Big-picture thinking • Avoiding "garbage in, garbage out" errors • Deep industry and business understanding • Strong interpersonal and communication skills • Project management expertise 𝗩𝗶𝗱𝗲𝗼 𝗧𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽𝘀: • [0:00-2:00] Setting up an Excel file with basic DCF assumptions • [2:00-2:30] Uploading the file and prompting ChatGPT to perform the valuation • [2:30-4:00] ChatGPT processes the model and delivers the right answer • [4:00-6:40] Key takeaways & what this means for the future of investment banking #AI #InvestmentBanking #ChatGPT #FinancialModeling #WallStreetPrep

Ever get stuck explaining accretion/dilution in an M&A deal? Don’t let it happen to you! There is so much to unpack in every deal, but what really matters to shareholders? Earnings per share! Here is a full breakdown of the expected EPS for the Tapestry x Capri acquisition — clean, clear, and packed with insights! Here’s what you’ll find: 𝗜𝗡𝗖𝗢𝗠𝗘 𝗦𝗧𝗔𝗧𝗘𝗠𝗘𝗡𝗧𝗦 – 𝗦𝗶𝗱𝗲-𝗯𝘆-𝘀𝗶𝗱𝗲 𝘃𝗶𝗲𝘄𝘀 𝗼𝗳 𝗯𝗼𝘁𝗵 𝗰𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀  • Revenue, EBITDA, EBIT, Net Income, and EPS  • Forecasts from 2023A to 2026E  • See standalone vs. pro forma performance 𝗔𝗖𝗖𝗥𝗘𝗧𝗜𝗢𝗡 / 𝗗𝗜𝗟𝗨𝗧𝗜𝗢𝗡 𝗔𝗡𝗔𝗟𝗬𝗦𝗜𝗦 – 𝗞𝗻𝗼𝘄 𝗲𝘅𝗮𝗰𝘁𝗹𝘆 𝗵𝗼𝘄 𝘁𝗵𝗲 𝗱𝗲𝗮𝗹 𝗶𝗺𝗽𝗮𝗰𝘁𝘀 𝗘𝗣𝗦  • Pro forma net income calculations  • Interest expense, foregone interest, synergies & costs  • Accretion shown year by year (2024E–2026E) 𝗧𝗥𝗔𝗡𝗦𝗔𝗖𝗧𝗜𝗢𝗡 𝗢𝗩𝗘𝗥𝗩𝗜𝗘𝗪 – 𝗗𝗲𝗮𝗹 𝘁𝗲𝗿𝗺𝘀 𝗮𝘁 𝗮 𝗴𝗹𝗮𝗻𝗰𝗲  • Offer price, premium, and valuation  • Cash/debt breakdown  • Transaction value and key multiples 𝗦𝗢𝗨𝗥𝗖𝗘𝗦 & 𝗨𝗦𝗘𝗦 + 𝗕𝗔𝗟𝗔𝗡𝗖𝗘 𝗦𝗛𝗘𝗘𝗧 𝗜𝗠𝗣𝗔𝗖𝗧  • See how the deal is financed  • Understand the debt load  • Track pro forma debt/EBITDA and net debt levels 𝗣𝗲𝗿𝗳𝗲𝗰𝘁 𝗶𝗳 𝘆𝗼𝘂'𝗿𝗲 𝗶𝗻:  ✅ Building deal models  ✅ Recruiting and want real-world examples  ✅ Need to explain the why behind the numbers 📥 Save it. Share it with your team. And follow Wall Street Prep for more finance resources that actually make sense. P.S. Download the full accretion/dilution analysis in Excel: https://lnkd.in/dkNSvDR3 #WallStreet #Finance

💰 Use code FVM20 to get 20% off Wall Street Prep’s Financial & Valuation Modeling Boot Camp. If you're serious about building real modeling skills, this is one of the most practical, hands-on trainings out there. 𝗪𝗵𝗮𝘁 𝘆𝗼𝘂’𝗹𝗹 𝗹𝗲𝗮𝗿𝗻:  • Build a full 3-statement model from scratch  • Master DCF, comps, and precedent transaction valuation  • Learn Excel shortcuts used by top analysts   𝗣𝗹𝘂𝘀, 𝗲𝗮𝗿𝗻 𝟮𝟳 𝗖𝗣𝗘 𝗰𝗿𝗲𝗱𝗶𝘁𝘀! 𝗗𝗮𝘁𝗲𝘀: April 23–25, 2025 𝗙𝗼𝗿𝗺𝗮𝘁: Live and virtual, 9am–5pm PT 𝗟𝗲𝗱 𝗯𝘆: Former investment bankers who’ve been in the seat 𝗧𝗵𝗶𝘀 𝗯𝗼𝗼𝘁 𝗰𝗮𝗺𝗽 𝗶𝘀 𝗱𝗲𝘀𝗶𝗴𝗻𝗲𝗱 𝗳𝗼𝗿:  • Aspiring investment bankers and private equity analysts  • FP&A and corporate finance professionals  • MBA students or recent grads looking to stand out 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗻𝗼𝘄 𝗮𝗻𝗱 𝘂𝘀𝗲 𝗰𝗼𝗱𝗲 𝗙𝗩𝗠𝟮𝟬 𝘁𝗼 𝘀𝗮𝘃𝗲 𝟮𝟬%: https://lnkd.in/dYqAvcZF #FinanceBootCamp #FinancialModeling #InvestmentBanking #WallStreetPrep #FPA #Valuation #PrivateEquity #CPECredits

Ever been in a meeting where someone throws around terms like "CapEx" or "FCF" and you’re silently Googling under the table? Yeah, we’ve all been there. Working in FP&A, you’re expected to speak the language of finance fluently—juggling budgets, forecasts, and variance analyses like a pro. 𝗕𝘂𝘁 𝗹𝗲𝘁’𝘀 𝗯𝗲 𝗿𝗲𝗮𝗹: sometimes, it’s helpful to have a cheat sheet. Because knowing these terms isn’t just about sounding smart in meetings. 𝗜𝘁’𝘀 𝗮𝗯𝗼𝘂𝘁 𝗯𝗲𝗶𝗻𝗴 𝗮𝗯𝗹𝗲 𝘁𝗼: • Spot early warning signs when cash flow starts tightening • Explain why a project’s ROI doesn’t justify the investment • Back up your recommendations with data that aligns with the company’s bigger picture When you understand the numbers at a deeper level, 𝘆𝗼𝘂 𝗯𝗲𝗰𝗼𝗺𝗲 𝘁𝗵𝗲 𝗽𝗲𝗿𝘀𝗼𝗻 𝗶𝗻 𝘁𝗵𝗲 𝗿𝗼𝗼𝗺 𝘄𝗵𝗼 𝗰𝗮𝗻 𝘁𝘂𝗿𝗻 𝗿𝗮𝘄 𝗱𝗮𝘁𝗮 𝗶𝗻𝘁𝗼 𝗮𝗰𝘁𝗶𝗼𝗻𝗮𝗯𝗹𝗲 𝗶𝗻𝘀𝗶𝗴𝗵𝘁𝘀—the one leadership leans on when tough financial decisions need to be made. Drop a 👍 if you find this helpful, and feel free to share it with your team! #FPandA #Finance #WallStreetPrep #FinancialPlanning #CorporateFinance #Accounting

Ever been handed a dense financial report or data-heavy slide and told to "make it client-ready"—𝗼𝗻𝗹𝘆 𝘁𝗼 𝘀𝗽𝗲𝗻𝗱 𝗪𝗔𝗬 𝘁𝗼𝗼 𝗹𝗼𝗻𝗴 𝗿𝗲𝗳𝗶𝗻𝗶𝗻𝗴 𝘁𝗵𝗲 𝗹𝗮𝘆𝗼𝘂𝘁? That’s what Taylor from Wall Street Prep calls the PowerPoint Layout Challenge, and in his latest video, he reveals how to quickly generate new layout ideas without manually dragging shapes around. ⚠️ 𝗪𝗵𝘆 𝗶𝘁 𝗺𝗮𝘁𝘁𝗲𝗿𝘀: Wasting time on formatting = less time focusing on actual content. ✅ 𝗧𝗵𝗲 𝗳𝗶𝘅: Use SmartArt to instantly create structured layouts, then ungroup and refine them for full control. 📌 𝗞𝗲𝘆 𝘁𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽𝘀: 00:36 – How to tell if a slide needs a better layout 01:55 – The slow (and painful) way most people try to fix it 02:40 – How to use SmartArt for fast, professional layouts 04:15 – Ungrouping SmartArt for full customization This technique helps you turn a basic list into a polished, client-ready slide in minutes—without second-guessing your design. Who else has spent way too long tweaking slides? 🖐️ #PowerPoint #ProductivityHacks #FinanceSkills #WallStreet #InvestmentBanking #WallStreetPrep

With companies like Microsoft finalizing its $69 billion Activision Blizzard deal and Boeing navigating costly write-downs, accounting teams are making complex financial decisions every day. How do acquisitions impact goodwill? How do companies handle deferred revenue in restructuring? 𝗧𝗵𝗲𝘀𝗲 𝗮𝗿𝗲 𝘁𝗵𝗲 𝗸𝗶𝗻𝗱𝘀 𝗼𝗳 𝗰𝗿𝗶𝘁𝗶𝗰𝗮𝗹 𝘁𝗵𝗶𝗻𝗸𝗶𝗻𝗴 𝘀𝗸𝗶𝗹𝗹𝘀 𝗶𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿𝘀 𝗮𝗿𝗲 𝗹𝗼𝗼𝗸𝗶𝗻𝗴 𝗳𝗼𝗿. So when you get hit with a question like: 📊 “𝘈 𝘤𝘰𝘮𝘱𝘢𝘯𝘺 𝘢𝘤𝘲𝘶𝘪𝘳𝘦𝘴 𝘢 𝘱𝘪𝘦𝘤𝘦 𝘰𝘧 𝘦𝘲𝘶𝘪𝘱𝘮𝘦𝘯𝘵 𝘧𝘰𝘳 $1𝘔. 𝘞𝘢𝘭𝘬 𝘮𝘦 𝘵𝘩𝘳𝘰𝘶𝘨𝘩 𝘩𝘰𝘸 𝘵𝘩𝘪𝘴 𝘱𝘶𝘳𝘤𝘩𝘢𝘴𝘦 𝘧𝘭𝘰𝘸𝘴 𝘵𝘩𝘳𝘰𝘶𝘨𝘩 𝘵𝘩𝘦 𝘵𝘩𝘳𝘦𝘦 𝘧𝘪𝘯𝘢𝘯𝘤𝘪𝘢𝘭 𝘴𝘵𝘢𝘵𝘦𝘮𝘦𝘯𝘵𝘴 𝘰𝘯 𝘋𝘢𝘺 1 𝘢𝘯𝘥 𝘰𝘷𝘦𝘳 𝘵𝘪𝘮𝘦.” Do you have a structured, confident answer? Or are you second-guessing depreciation, cash flow impact, and balance sheet adjustments? Accounting interviews aren’t just about memorizing definitions—𝘁𝗵𝗲𝘆 𝘁𝗲𝘀𝘁 𝘆𝗼𝘂𝗿 𝗮𝗯𝗶𝗹𝗶𝘁𝘆 𝘁𝗼 𝗰𝗼𝗻𝗻𝗲𝗰𝘁 𝗳𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗰𝗼𝗻𝗰𝗲𝗽𝘁𝘀, 𝘁𝗵𝗶𝗻𝗸 𝗰𝗿𝗶𝘁𝗶𝗰𝗮𝗹𝗹𝘆 𝘂𝗻𝗱𝗲𝗿 𝗽𝗿𝗲𝘀𝘀𝘂𝗿𝗲, 𝗮𝗻𝗱 𝗲𝘅𝗽𝗹𝗮𝗶𝗻 𝘆𝗼𝘂𝗿 𝗿𝗲𝗮𝘀𝗼𝗻𝗶𝗻𝗴 𝗰𝗹𝗲𝗮𝗿𝗹𝘆. That’s why we put together this 𝗔𝗰𝗰𝗼𝘂𝗻𝘁𝗶𝗻𝗴 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁—a quick-reference guide to help you master the essentials, including: • How the income statement, balance sheet, and cash flow statement interact • Accrual vs. cash accounting—when each applies and why it matters • The five-step revenue recognition model (ASC 606)—critical for modern accounting • Goodwill, deferred revenue, and accrued expenses—how they impact financials • Leases, depreciation, and amortization—key differences and accounting treatment You don’t want to be caught off guard in your interview. Be ready to break down these concepts with confidence. #FinanceInterview #Finance #WallStreetPrep #InvestmentBanking

🎓 EXCITING PARTNERSHIP ANNOUNCEMENT 🎓 Wall Street Prep has partnered with Columbia Business School Executive Education to launch a groundbreaking new program: The AI for Business & Finance Certificate! Enrollment is now officially OPEN! 🚀 Over the past year, we've collaborated closely with our clients—the world's leading financial institutions—to identify the practical AI skills most in demand: 1️⃣ Deep understanding of AI technology and popular AI tools and frameworks 2️⃣ Ability to identify use cases where AI can automate, streamline, and enhance processes 3️⃣ Know-how to implement AI tools that drive productivity across roles and throughout organizations This comprehensive 8-week program delivers exactly this skillset by combining Columbia Business School Executive Education's expertise in teaching AI to MBAs with Wall Street Prep's experience in delivering AI training to top financial institutions. The curriculum features lessons from industry leaders who are directly driving the AI revolution in finance. Don't miss this opportunity to gain the AI skills that are rapidly becoming essential in today's business and finance landscape! Learn more and enroll here: https://bit.ly/41RxVjk #AI #Finance #ArtificialIntelligence #MachineLearning #WallStreetPrep #ColumbiaBusinessSchoolExecutiveEducation #FinanceInnovation Wall Street Prep Columbia Business School Executive Education Matan Feldman Daniel Guetta Malek Ben Sliman Olivier Toubia Stijn Van Nieuwerburgh Haylie Miller

Learn how finance pros build decks FAST. Join PowerPoint Speed Trainer Taylor Croonquist on April 15 and learn how to create high-impact presentations without the burnout. 𝗛𝗲𝗿𝗲’𝘀 𝘄𝗵𝗮𝘁 𝘆𝗼𝘂’𝗹𝗹 𝘄𝗮𝗹𝗸 𝗮𝘄𝗮𝘆 𝘄𝗶𝘁𝗵: 𝗔 𝗿𝗲𝗽𝗲𝗮𝘁𝗮𝗯𝗹𝗲 𝘀𝘆𝘀𝘁𝗲𝗺 to build clean, professional slides using just shapes, lines & text boxes 𝗧𝗼𝗻𝘀 𝗼𝗳 𝘁𝗶𝗺𝗲-𝘀𝗮𝘃𝗶𝗻𝗴 𝘀𝘁𝗿𝗮𝘁𝗲𝗴𝗶𝗲𝘀, tips, and tricks you can apply immediately 𝗠𝗮𝘀𝘁𝗲𝗿𝘆 𝗼𝗳 𝟰 𝘀𝗵𝗼𝗿𝘁𝗰𝘂𝘁 𝘁𝘆𝗽𝗲𝘀 to speed up everything you do in PowerPoint 💥 𝗕𝗼𝗻𝘂𝘀: Get 𝗙𝗥𝗘𝗘 𝗹𝗶𝗳𝗲𝘁𝗶𝗺𝗲 𝗮𝗰𝗰𝗲𝘀𝘀 to our best-selling PowerPoint Crash Course to keep leveling up after the session. 👉 Don’t miss out. Your future self (and your manager) will thank you! 𝗪𝗵𝗲𝗻: Tuesday, April 15, 2025 (1–5 PM ET) 𝗪𝗵𝗲𝗿𝗲: Online #PowerPointTips #FinanceCareers #ProductivityHacks #WallStreetPrep #ExcelToPowerPoint #FinanceTraining #WorkSmarter Save your seat: https://lnkd.in/dya_ih7D

Markets are volatile, interest rates are shifting, and M&A activity is making headlines. In this environment, 𝘃𝗮𝗹𝘂𝗮𝘁𝗶𝗼𝗻 𝗾𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝘀𝗲𝗽𝗮𝗿𝗮𝘁𝗲 𝘁𝗵𝗲 𝘀𝘁𝗿𝗼𝗻𝗴 𝗰𝗮𝗻𝗱𝗶𝗱𝗮𝘁𝗲𝘀 𝗳𝗿𝗼𝗺 𝘁𝗵𝗲 𝗼𝗻𝗲𝘀 𝘄𝗵𝗼 𝗴𝗲𝘁 𝘁𝗿𝗶𝗽𝗽𝗲𝗱 𝘂𝗽. So, if you’re walking into an interview and hear: 📉 “𝘞𝘢𝘭𝘬 𝘮𝘦 𝘵𝘩𝘳𝘰𝘶𝘨𝘩 𝘢 𝘋𝘊𝘍 𝘢𝘯𝘢𝘭𝘺𝘴𝘪𝘴. 𝘏𝘰𝘸 𝘸𝘰𝘶𝘭𝘥 𝘺𝘰𝘶 𝘷𝘢𝘭𝘶𝘦 𝘢 𝘤𝘰𝘮𝘱𝘢𝘯𝘺 𝘶𝘴𝘪𝘯𝘨 𝘵𝘩𝘪𝘴 𝘮𝘦𝘵𝘩𝘰𝘥?” Are you able to break it down effortlessly, step by step? Or do you scramble, trying to recall WACC, terminal values, and discount rates? Whether it's 𝗗𝗖𝗙, 𝗧𝗿𝗮𝗱𝗶𝗻𝗴 𝗖𝗼𝗺𝗽𝘀, 𝗼𝗿 𝗣𝗿𝗲𝗰𝗲𝗱𝗲𝗻𝘁 𝗧𝗿𝗮𝗻𝘀𝗮𝗰𝘁𝗶𝗼𝗻𝘀, you need to be able to walk through these concepts fluently and apply them in real-world scenarios. That’s why we put together this 𝗩𝗮𝗹𝘂𝗮𝘁𝗶𝗼𝗻 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁—a quick-reference guide covering: • The 3 primary valuation methods (DCF, Trading Comps, Precedent Transactions) • Key formulas, including how to calculate free cash flow and WACC • Enterprise value vs. equity value—know the difference • How valuation multiples like EV/EBITDA and P/E are used • The difference between intrinsic and relative valuation Make sure you’re ready before stepping into the interview. #FinanceInterview #Finance #WallStreetPrep #InvestmentBanking #WallStreet #Valuation

🙌 We were able to build a custom Excel add-in with ChatGPT—no coding required. In less than 10 minutes, with zero coding knowledge, Wall Street Prep founder and CEO Matan Feldman had ChatGPT create an Excel add-in tailored exactly to what he needed. And now he uses it every day. 𝗠𝗮𝘁𝗮𝗻’𝘀 𝗕𝗶𝗴-𝗣𝗶𝗰𝘁𝘂𝗿𝗲 𝗧𝗮𝗸𝗲𝗮𝘄𝗮𝘆𝘀: 𝗣𝗿𝗼𝗺𝗽𝘁𝗶𝗻𝗴 𝗶𝘀 𝘁𝗵𝗲 𝗻𝗲𝘄 𝗰𝗼𝗱𝗶𝗻𝗴. I can’t stress this enough—your ability to write clear, specific prompts is now more valuable than traditional coding skills in many scenarios. Poor prompts = poor results. 𝗧𝗵𝗲 𝗯𝗮𝗿𝗿𝗶𝗲𝗿 𝘁𝗼 𝗲𝗻𝘁𝗿𝘆 𝗶𝘀 𝗱𝗶𝘀𝗮𝗽𝗽𝗲𝗮𝗿𝗶𝗻𝗴. You don’t need coding knowledge anymore to create hyper-customized tools. But even a tiny bit of coding understanding? That’s a superpower now. 🤖 𝗪𝗵𝗮𝘁 𝘀𝗵𝗼𝘂𝗹𝗱 𝘄𝗲 𝗯𝘂𝗶𝗹𝗱 𝗻𝗲𝘅𝘁 𝘄𝗶𝘁𝗵 𝗔𝗜? 𝗩𝗶𝗱𝗲𝗼 𝗧𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽𝘀: [0:00-3:47] Explaining what I want the add-in to do [3:47-6:51] Crafting the prompt for ChatGPT [6:51-10:03] Following ChatGPT’s instructions to create the add-in [10:03-11:36] Testing the add-in [11:36-12:20] Wrap-up & key takeaways #Excel #ChatGPT #InvestmentBanking #WallStreetPrep #AI #Finance #WallStreet