-
Oppenheimer Pre-Work Package
- 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
-
Complex Trading Comps Analysis
- Accounting & Financial Statements Bootcamp
- Accounting & Financial Statement Integration
- How to Analyze a 10K
- Company Profiles
- Company Overview
- Corporate Valuation Methodologies & Corporate Finance
- Basic Valuation Techniques
- Advanced Financial Modeling - Core Model
- Complex Trading Comps Analysis
- Deal Comps Analysis (Precedent Transactions)
- Finance 101 - Introduction to Finance
- Basic Financial Modeling + DCF Modeling
- Quick & Dirty Trading Comps Analysis
- Relative Valuation - Football Field
Complex Trading Comps Analysis
- Trading Comps Overview (26 post(s))
- WMT Inputs (2 post(s))
- TGT Inputs (2 post(s))
- KSS Inputs (2 post(s))
- JCP Inputs (4 post(s))
- COST Fiscal Yr (6 post(s))
- COST Inputs (20 post(s))
- SHLD Inputs (9 post(s))
- Multiples & WACC (10 post(s))
Last 10 posts
Other income
Other income under revenue is different from other income below EBIT line right? ie the former does not have to be reclassified to below EBIT line?
Other income under revenue is different from other income below EBIT line right? ie the former does not have to be reclassified to below EBIT line?
Clarification on LIFO/FIFO adjustment & tax savings
1. Adjustment after tax (cell H54): formula = 2.4*0.6-4.9. you add 2.4*0.6 because you generate lower pretax income so you should be paying less tax hence you add back 2.4*0.6 as tax savings after adjusting back to LIFO (since you are converting all comps to LIFO standard for apple to apple comparis... Read More
1. Adjustment after tax (cell H54): formula = 2.4*0.6-4.9. you add 2.4*0.6 because you generate lower pretax income so you should be paying less tax hence you add back 2.4*0.6 as tax savings after adjusting back to LIFO (since you are converting all comps to LIFO standard for apple to apple comparis... Read More
Clarification on cost method and tax differences in the 10K
1. Adjustments – 1st one – page 2 of 10K: “Including a favorable fourth-quarter adjustment of $1 million related to taxes, the sale resulted in a pre-tax gain of $26 million and a loss of $7 million on an after- tax basis. The relatively high tax cost is largely due to the tax basis of the Com... Read More
1. Adjustments – 1st one – page 2 of 10K: “Including a favorable fourth-quarter adjustment of $1 million related to taxes, the sale resulted in a pre-tax gain of $26 million and a loss of $7 million on an after- tax basis. The relatively high tax cost is largely due to the tax basis of the Com... Read More
Question on adjustment of pre opening expense on diluted normalized EPS
Cell F87 of diluted normalized EPS $0.94 is after adjusting for pre-opening expense of $15,999. Since this not a one-off item and it was added back on the pre tax adjustment in cell F78, then the normalized diluted EPS is not $0.94 right? It should be: $0.94 + 15.999*0.6/491.717 = $0.95 (using dilu... Read More
Cell F87 of diluted normalized EPS $0.94 is after adjusting for pre-opening expense of $15,999. Since this not a one-off item and it was added back on the pre tax adjustment in cell F78, then the normalized diluted EPS is not $0.94 right? It should be: $0.94 + 15.999*0.6/491.717 = $0.95 (using dilu... Read More
Questions on the slide (various aspects) - 6 questions
1. pro forma vs reported numbers: Why take pro forma instead of reported numbers? When you are projecting the consolidated company post M&A, which financials to use? 2. organic vs inorganic growth: When you are trying to project organic vs inorganic growth and % of growth in the combined company... Read More
1. pro forma vs reported numbers: Why take pro forma instead of reported numbers? When you are projecting the consolidated company post M&A, which financials to use? 2. organic vs inorganic growth: When you are trying to project organic vs inorganic growth and % of growth in the combined company... Read More
Questions on the slides (8 questions)
1. Do you always have to include cost of preferred equity in WACC? In which case you MUST include cost of preferred equity? 2. Since preferred equity is closer to debt, does that mean cost of debt < cost of preferred equity < cost of equity? How do you calculate the returns and valuation multiple... Read More
1. Do you always have to include cost of preferred equity in WACC? In which case you MUST include cost of preferred equity? 2. Since preferred equity is closer to debt, does that mean cost of debt < cost of preferred equity < cost of equity? How do you calculate the returns and valuation multiple... Read More
Relationship between P/E and inverse of P/E (2 questions)
Hi! First, awesome videos! Follow up questions on multiples, esp for listed companies valuation when analysing a stock in a long short fund context: 1. Is inverse of P/E = earnings yield = cost of equity? I was looking through this link and it states that this statement is wrong ie inverse o... Read More
Hi! First, awesome videos! Follow up questions on multiples, esp for listed companies valuation when analysing a stock in a long short fund context: 1. Is inverse of P/E = earnings yield = cost of equity? I was looking through this link and it states that this statement is wrong ie inverse o... Read More
Adjustments for non-recurring items to calculate adjusted EV/FCFF or other cashflow ratios
i. Does this mean you have to adjust for cashflow statement and balance sheets? Can you give an example for such adjustments for items that affects both cashflow statements and balance sheets? e.g. deferred tax impairments etc
i. Does this mean you have to adjust for cashflow statement and balance sheets? Can you give an example for such adjustments for items that affects both cashflow statements and balance sheets? e.g. deferred tax impairments etc
2005A EBIT
Hi, would you like us to use the 2005A EBIT numbers from the video (which for Kohl's, Sears, and Target seem to be the unadjusted EBIT numbers) or would you like us to use the ones that are automatically pulled by the links on the given template? Thank you for the assistance.
Hi, would you like us to use the 2005A EBIT numbers from the video (which for Kohl's, Sears, and Target seem to be the unadjusted EBIT numbers) or would you like us to use the ones that are automatically pulled by the links on the given template? Thank you for the assistance.
Multiples 1. For P/E, you only use net income from continued operations and income to common shareholders (excluding minority interest), correct? 2. Do you need to take out the EBITDA from discontinued operation from EV/EBITDA? usually EBITDA isn’t broken out that way and I don’t know if t... Multiples 1. For P/E, you only use net income from continued operations and income to common shareholders (excluding minority interest), correct? 2. Do you need to take out the EBITDA from discontinued operation from EV/EBITDA? usually EBITDA isn’t broken out that way and I don’t know if there is usually any disclosure on EBITDA from discontinued vs continued operation. Is that why you usually do not adjust EBITDA for discontinued operation? 3. When you take forward or historical P/E or EV/EBITDA, EV/revenue etc multiples from capiq, Bloomberg etc, are these already adjusted for you? (taking out minority interest and discontinued operation) or do you have to recalculate one by one? 4. Are you including MI in total debt because you are including these in TEV calculation? You exclude MI from total debt when you are calculating solvency and liquidity ratios right? 5. Adjustments for non-recurring items: these should have been captured in the company disclosures of their reconciliation from GAAP non GAAP numbers right? So less need to read through the footnotes to look through item by item? 6. If you are calculating FCF ratios eg EV/FCFF, how do you adjust for these non recurring items? Diluted share calculation 7. Diluted share outstanding number is from WACSO or from financials, what if the number has changed since the release of the latest financials? Say the company has issued additional share and the number from Bloomberg or capiq is the latest share count since the release of the financials? Which number do you use to calculate equity value and to calculate diluted share? Does this change the exercisable share number stated on the financials to use to calculate the diluted share as well? 8. How do you calculate diluted share outstanding if you have different class of stocks (class A, B, C etc)? Are these all usually common stocks? 9. Currently exercisable options on the financials are those that can be exercised per that date in the financials (hence outdated). Do you need to update this to include any other potentially exercisable options at the time of you spreading the comps? (just by comparing current share price and exercise price) Thank you so much for taking the time to respond to my questions! :) You have been a big help! Read More