Скачать с ютуб LBO Modeling: How to Layer PIPE Investments (Excel Walkthrough) в хорошем качестве

LBO Modeling: How to Layer PIPE Investments (Excel Walkthrough)

💻Download Free Model Templates: https://resources.roadtocarry.com/pip... 💡 Subscribe to our weekly PE newsletter on buyout case studies and roll-up playbooks read by investors at top firms like Blackstone, Apax, and Goldman Sachs: https://www.penewsletter.com/ Read the Petco PIPE newsletter post for more context. Part 1: https://www.penewsletter.com/p/petco-... Part 2: https://www.penewsletter.com/p/petco-... Learn how to model PIPE investments, which combines LBO modeling with advanced securities such as convertible preferred and warrants. In this in-depth Excel tutorial, I walk through: What PIPEs are and when they’re used How to build a financial forecast from public filings How to model convertible preferred and warrant securities ⏱Timestamps: 0:29 - Overview of PIPE 3:30 - Building a financial forecast from public filings 14:00 - Creating a feeder tab for multiple forecast cases 15:32 - Transaction assumptions (incl. treasury stock method) 25:51 - Debt paydown modeling (P&L, cash flow, debt paydown) 39:00 - Calculating returns (convertible preferred, warrant modeling) 47:42 - Creating returns sensitivity tables Road to Carry is a private equity career training program started by Edwin Yun, who spent nearly a decade in PE and investment banking—as a VP at Tailwind Capital, Senior Associate at Providence Equity, and Analyst at Barclays in New York. Over the years, he's been directly responsible for hiring, onboarding, and promoting junior private equity investors. Join the early access waitlist for the private equity course: https://resources.roadtocarry.com/pip... LinkedIn:   / edwinyun   #PrivateEquity #LBO #LeveragedBuyout #PIPE #FinancialModel