-
Package: Super-Complex M...
- 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
Super-Advanced Merger Modeling - IS
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
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
(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