-
Package 5: Merger Modeling Topics
- WST Free Trial - Professional Development
- WST Corporate Valuation Quiz/Exam
- Capital Group - 2021 Assessment - Quizzes
- WST Webinars
- Analyst Essentials
- Analyst Essentials Pro
- Merger Modeling Basics
- Overview of Financial Markets
- Accounting for Finance
- DBS MODULE 1: FUNDAMENTAL/FOUNDATION
- WST Internal Instructors
- Advanced Excel for Data Analysis (2016 Singapore)
- Fundamentals of Financial Modeling (PKA)
- Fundamentals of Valuation Modeling (PKA)
- JPM-AM 2015 Excel Exam
- JPM-IM 2015 Valuation Exam
- Strategic Alternatives: M&A and Buyout Options
- Excel for Entrepreneurs
- Wall Street Certification Bundle
- Financial Modeling Starter Kit
- WST Professional Development
- Quizzes & Exams - WST Internal
- Keys to Success
- Oppenheimer Pre-Work Package
- Package: Intensive Accounting Boot Camp
- Package 1: Basic & Fundamental Concepts
- Quiz/Exam for Package 1 - Finance 101
- Quizzes/Exams for Package 1
- Package 2: Core Fundamental Concepts
- Quizzes/Exams for Package 2
- USF - Corporate Valuation Methodologies
- Package 3: Advanced Financial Modeling
- Package 4: Valuation Modeling Topics
- Package 5: Merger Modeling Topics
- Package 6: Leveraged Buyout Modeling
- Package: Technical Applications - Excel
- Package: Private Company Valuation
- Package: Super-Complex M&A LBO Modeling
- Package: Distressed Financial Modeling
- Package: Bank Financial Modeling
- Package: Insurance Financial Modeling
- Package: Real Estate Development Modeling
- Package: REIT Financial Modeling
- Package: Buy-Side Series
- Overview of Financial Markets + Exhibits
- Verification
- Certification
- AIB Add-on
Intermediate / Advanced Merger Modeling
- FMV Allocation (2 post(s))
- GW Consolidation (0 post(s))
- Model: Acq & Target (2 post(s))
- Model: Merger (8 post(s))
- Purchase Price Allocation (8 post(s))
Last 10 posts
Cash Flow and Balance Sheets for M&A Models
I just wanted to confirm that when building full-blown M&A models (like the PEP-TAP Intermediate Model in Module 5) that it is not common practice to build out the entire B/S and C/F statements, such as we did for the advanced financial model in Module 3.
I just wanted to confirm that when building full-blown M&A models (like the PEP-TAP Intermediate Model in Module 5) that it is not common practice to build out the entire B/S and C/F statements, such as we did for the advanced financial model in Module 3.
Intermed-Adv merger model
Where do you get the 2006A tax rate, and interest rate on cash, and interest rate on debt from? (2007-2010E projections use the 2006A metrics/data) The model/module simply uses stated hardcoded/assumptions/manual inputs.
Where do you get the 2006A tax rate, and interest rate on cash, and interest rate on debt from? (2007-2010E projections use the 2006A metrics/data) The model/module simply uses stated hardcoded/assumptions/manual inputs.
Stock issued: calculated off Equity Value or EV?
I noticed that the calculation for stock issued in an M&A deal differs in your Simple Merger Model vs the Int-Adv Model. Why in the simple merger model do you calculate stock issued based on EV whereas in the Int-Adv Merger Model with PEP and TAP you calculate it based off the equity value?
I noticed that the calculation for stock issued in an M&A deal differs in your Simple Merger Model vs the Int-Adv Model. Why in the simple merger model do you calculate stock issued based on EV whereas in the Int-Adv Merger Model with PEP and TAP you calculate it based off the equity value?
Dividend payment for Debt Paydown
In the int-Adv model (and this is the case for the AdvFM Model as well, why do we build the Cash Available Before Debt calculation to include a dividend payout when, in theory, dividends have the last priority to payouts. Shouldn't the debt sweep sweep through first and then we decide if dividends a... Read More
In the int-Adv model (and this is the case for the AdvFM Model as well, why do we build the Cash Available Before Debt calculation to include a dividend payout when, in theory, dividends have the last priority to payouts. Shouldn't the debt sweep sweep through first and then we decide if dividends a... Read More
Identifiable Intangible Assets
My video for the M&A package has expired so I'm just going off of what I have in my notes and in the Pepsi/Molson M&A excel model. It seems the differentiating factor between Tax Deductible and Non-Tax Deductible Intangibles is whether the asset has a finite or infinite life. Separately, I w... Read More
My video for the M&A package has expired so I'm just going off of what I have in my notes and in the Pepsi/Molson M&A excel model. It seems the differentiating factor between Tax Deductible and Non-Tax Deductible Intangibles is whether the asset has a finite or infinite life. Separately, I w... Read More
Hi there, Does anyone there can help me understanding why we have deferred tax liability (DTL) creation in M&A/purchase price allocation? What is the rationale to create DTLs in this circumstance? I appreciate your help on this matter. Cheers.