-
Package: Super-Complex M&A LBO Modeling
- WST Free Trial - Professional Development
- WST Corporate Valuation Quiz/Exam
- Capital Group - 2021 Assessment - Quizzes
- 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
Complex, Super-Advanced Merger Modeling
- Acquiror Standalone Model (TGT) (0 post(s))
- Merger Summary (10 post(s))
- Super-Advanced Merger Modeling - IS (5 post(s))
- Balance Sheet (4 post(s))
- Cash Flow & Debt Sweep (7 post(s))
- Interest & Ratios (0 post(s))
Last 10 posts
Super-advanced merger modeling
Hi there, Could you please explain me in more detail what is the rationale behind those percentages on cells F42:F44 used to allocate the purchase price in the Super-advanced merger modeling? (2). To be more specific, why is it a percentage of Equity and not a percentage of the purchase price??? (... Read More
Hi there, Could you please explain me in more detail what is the rationale behind those percentages on cells F42:F44 used to allocate the purchase price in the Super-advanced merger modeling? (2). To be more specific, why is it a percentage of Equity and not a percentage of the purchase price??? (... Read More
Merger modeling - Purchase price allocation
Hi there, a couple of doubts here: 1. In the purchase price allocation, why do we allocate the excess (Purchase price of equity – Tangible Book value) without the transaction costs? Any specific rule here? 2. In the same purchase price allocation, shouldn’t we have to add a line in that purcha... Read More
Hi there, a couple of doubts here: 1. In the purchase price allocation, why do we allocate the excess (Purchase price of equity – Tangible Book value) without the transaction costs? Any specific rule here? 2. In the same purchase price allocation, shouldn’t we have to add a line in that purcha... Read More
Pref stock included in debt for target M&A?
Hello, I was wondering why on the merger summary type of the advanced financial model, particularly cell F20 where we are calculating the total existing debt for the target company, why is that we are adding preferred stock? Is this b/c preferred stock is a hybrid of debt and equity? Can someone ... Read More
Hello, I was wondering why on the merger summary type of the advanced financial model, particularly cell F20 where we are calculating the total existing debt for the target company, why is that we are adding preferred stock? Is this b/c preferred stock is a hybrid of debt and equity? Can someone ... Read More
Merger modeling - Merger IS
In relation to some concepts in the 'MERGER IS' tab, I have some questions that you guys may be able to help me with: 1. From line 25 to 28 in the ‘MERGER IS’ tab, could we have used the MIN formula to amortize those items? Only because we cannot amortize more than what we have as beginning bal... Read More
In relation to some concepts in the 'MERGER IS' tab, I have some questions that you guys may be able to help me with: 1. From line 25 to 28 in the ‘MERGER IS’ tab, could we have used the MIN formula to amortize those items? Only because we cannot amortize more than what we have as beginning bal... Read More
Merger modeling - Merger BS
Hi, On the ‘MERGER BS’, cell G17, why are we reducing the target’s existing “Intangible Assets” balance (in the pro forma adj. column) if the calculation that we have in the ‘MERGER Summary’ for Intangibles is not a post-transaction Intangibles (opposed to GW, that is a post-transactio... Read More
Hi, On the ‘MERGER BS’, cell G17, why are we reducing the target’s existing “Intangible Assets” balance (in the pro forma adj. column) if the calculation that we have in the ‘MERGER Summary’ for Intangibles is not a post-transaction Intangibles (opposed to GW, that is a post-transactio... Read More
MERGER Debt Sweep
Hi, Shouldn't we have set up line 19 of the MERGER Debt Sweep (from the Complex Merger modeling course) to only pre pay term loan after we have paid all our existing mandatory repayments PLUS our Revolver as well, in order to make sure that only if we have EXCESS cash left (after revolver!) then we ... Read More
Hi, Shouldn't we have set up line 19 of the MERGER Debt Sweep (from the Complex Merger modeling course) to only pre pay term loan after we have paid all our existing mandatory repayments PLUS our Revolver as well, in order to make sure that only if we have EXCESS cash left (after revolver!) then we ... Read More
M&A Debt Sweep CF Recapture Feature
Hello, I was just wondering what the rationale behind the CF Recapture feature (switch) is on the Debt Sweep for the advanced M&A model. What is the rationale? How does it work and its practicality? Thank you.
Hello, I was just wondering what the rationale behind the CF Recapture feature (switch) is on the Debt Sweep for the advanced M&A model. What is the rationale? How does it work and its practicality? Thank you.
I just finished the "Super-Advanced Merger Modeling IS" module. I have two questions: (1) Line 28, Amortization of Transaction Debt Financing Fees => Since "Transaction Debt Financing Fees" is a financing decision = It does not affect EBITDA => Therefore, it should not be included in the EBITDA... I just finished the "Super-Advanced Merger Modeling IS" module. I have two questions: (1) Line 28, Amortization of Transaction Debt Financing Fees => Since "Transaction Debt Financing Fees" is a financing decision = It does not affect EBITDA => Therefore, it should not be included in the EBITDA calculation. However, in the video, you included it in the EBITDA calculation. You also contradicted your reply to the same question posted by another viewer three years ago. (2) Line 54, Plus: D&A from Transaction (Book) and Line 55, Less: D&A from Transaction (Tax) => I believe the values for cells "I54" and "I55" shall both be fully anchored (i.e. I54 "=Merger Summery! $Y$42" and I55 "=Merger Summary! $Y$50" before performing the next step of shifting from "I53" down to "I56" and shift right to "Column M" and then, "Ctrl R". As a result, line 58, Income Tax Expense (GAAP) for 2009(P) should be $2,909 (NOT $2,901); NI should be $4,933 (NOT $4,940), EBITDA should be $10,451 (NOT $10,455), Diluted EPS is still at $4.69 (Reason: No difference due to 2-decimal; but, I am sure there is a difference with more decimal places). Thank you very much in advance for looking into my questions and responding accordingly. Read More