-
Oppenheimer Pre-Work Pac...
- 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
-
Deal Comps Analysis (Pre...
- 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
May Inputs
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Color Coding
I am slightly confused about the color coding: in the Dealcomps sheet, when entering a hardcoded formula (for example, cash for May Dept. Stores was "-22-40"), we use the color black; however, in the Complex Trading Comps worksheet, when entering a hardcoded formula (for example, debt for Walmart wa...
I am slightly confused about the color coding: in the Dealcomps sheet, when entering a hardcoded formula (for example, cash for May Dept. Stores was "-22-40"), we use the color black; however, in the Complex Trading Comps worksheet, when entering a hardcoded formula (for example, debt for Walmart was "3754+4595+26429+1467"), we use the color blue. Furthermore, in the Complex Trading Comps worksheet, some cells that include a reference to another cell and a hardcoded number (for example, cell 54, which is JCP's Adjustments (After-Tax) number and is "-5+G48*.6"), are black, while others (for example, cell H54, which is Kohl's Adjustments (After-Tax) and is "H48*.6-4.9") are blue.
Read More
Show All 2 Replies
Login to Reply
0
by Guest X.
added 9 years ago
additional adjustments
On page 8 of the 10k there was a one time $42 million lease expense adjustment to synchronize accounting assumptions. On page 10 there was an $18 million tax provision reduction resulting from the resolution of various federal and state income tax issues. What is the reason for not including these t...
Read More