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

Your pitch deck is due in an hour—don’t let this PowerPoint mistake slow you down. Mastering list level shortcuts will save you HOURS of frustration. ⚠️𝗪𝗵𝘆 𝗶𝘁 𝗺𝗮𝘁𝘁𝗲𝗿𝘀: If you don’t use proper list levels, hitting “Reset” wipes out your formatting, forcing you to start over. ✅ 𝗧𝗵𝗲 𝗳𝗶𝘅: Use Alt + Shift + Left/Right Arrow to adjust list levels the right way and keep your formatting intact. 📌 𝗞𝗲𝘆 𝘁𝗶𝗺𝗲𝘀𝘁𝗮𝗺𝗽𝘀: 00:36 – How to tell if a slide is incorrectly formatted 02:15 – The difference between tabbing and list level shortcuts 03:40 – How to fix bad formatting in seconds PowerPoint should save you time, not steal it. Learn these shortcuts, and you'll spend less time fixing slides—and more time impressing clients and bosses. #PowerPoint #ProductivityHacks #FinanceSkills #WallStreet

In private equity, time is money—and so is precision. When you’re managing deals, talking to LPs, or navigating complex fund structures, 𝘁𝗵𝗲𝗿𝗲’𝘀 𝗻𝗼 𝗿𝗼𝗼𝗺 𝗳𝗼𝗿 𝗴𝘂𝗲𝘀𝘀𝘄𝗼𝗿𝗸. You need to understand the mechanics inside and out. Knowing terms like 𝗰𝗮𝗿𝗿𝗶𝗲𝗱 𝗶𝗻𝘁𝗲𝗿𝗲𝘀𝘁, 𝗵𝘂𝗿𝗱𝗹𝗲 𝗿𝗮𝘁𝗲, 𝗮𝗻𝗱 𝘃𝗶𝗻𝘁𝗮𝗴𝗲 𝘆𝗲𝗮𝗿 isn’t just for talking the talk—it’s about making smarter, faster decisions that drive returns. 𝗕𝗲𝗰𝗮𝘂𝘀𝗲 𝘄𝗵𝗲𝗻 𝘆𝗼𝘂 𝗺𝗮𝘀𝘁𝗲𝗿 𝘁𝗵𝗲 𝗳𝘂𝗻𝗱𝗮𝗺𝗲𝗻𝘁𝗮𝗹𝘀, 𝘆𝗼𝘂 𝗰𝗮𝗻: • Articulate fund performance clearly to LPs and stakeholders, building trust and credibility • Spot inefficiencies or risks in portfolio companies before they impact ROI • Navigate deal structures confidently, avoiding missteps that could cost millions We put together this 𝗣𝗿𝗶𝘃𝗮𝘁𝗲 𝗘𝗾𝘂𝗶𝘁𝘆 𝗧𝗲𝗿𝗺𝘀 𝗖𝗵𝗲𝗮𝘁 𝗦𝗵𝗲𝗲𝘁 to help you sharpen your knowledge and move quicker when it matters most. If you think your team could use this, drop a 👍 and repost it. #PrivateEquity #WallStreetPrep #Finance #Investing #PE

👇 Want to break into private equity—or sharpen your deal-making skills? 𝗧𝗵𝗶𝘀 𝗶𝘀 𝘁𝗵𝗲 𝘀𝗮𝗺𝗲 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴 𝗽𝗿𝗼𝗴𝗿𝗮𝗺 𝘁𝗼𝗽 𝗣𝗘 𝗳𝗶𝗿𝗺𝘀 𝘂𝘀𝗲 𝘁𝗼 𝘁𝗿𝗮𝗶𝗻 𝘁𝗵𝗲𝗶𝗿 𝗻𝗲𝘄 𝗵𝗶𝗿𝗲𝘀, equipping you with the real-world skills, frameworks, and confidence to navigate the full deal process—from sourcing to execution. You'll also gain access to comprehensive training materials, including detailed manuals, online exercises, and reusable Excel model templates to reinforce your learning long after the course ends. 📅 𝗩𝗶𝗿𝘁𝘂𝗮𝗹 𝗕𝗼𝗼𝘁 𝗖𝗮𝗺𝗽 | 𝗠𝗮𝗿𝗰𝗵 𝟯𝟭 | 𝟵 𝗔𝗠 – 𝟱 𝗣𝗠 (𝗘𝗧) • Earn 9.5 CPE credits • Master the full deal process from sourcing to exit • Build practical, real-world skills used by top PE investors Here’s what past participants have said: ⭐️ “It was super beneficial to me. 𝗕𝗹𝗼𝘄𝘀 𝗮𝗻𝘆 𝗼𝘁𝗵𝗲𝗿 𝗽𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹 𝘁𝗿𝗮𝗶𝗻𝗶𝗻𝗴 𝗜’𝘃𝗲 𝗵𝗮𝗱 𝗼𝘂𝘁 𝗼𝗳 𝘁𝗵𝗲 𝘄𝗮𝘁𝗲𝗿.” — Matt K. ⭐️ "It definitely gave me a 𝗴𝗿𝗲𝗮𝘁 𝘃𝗶𝗲𝘄 𝗶𝗻𝘁𝗼 𝘁𝗵𝗲 𝗳𝘂𝗹𝗹 𝗱𝗲𝗮𝗹 𝗽𝗿𝗼𝗰𝗲𝘀𝘀 and parts that I had missed. I was able to ask a lot of questions. Also, the materials are very useful for future reference." — Maria Luisa E. ⏳ Spots are limited. Secure yours today: https://lnkd.in/drRvty3t