
Package 1: Basic & Funda...
 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)
 JPMAM 2015 Excel Exam
 JPMIM 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 PreWork 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: SuperComplex 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: BuySide Series
 Overview of Financial Markets + Exhibits
 Verification
 Certification
 AIB Addon
Financial Summary
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Control D
when you used control d to paste down, then had to underline the bottom cell, if you used paste special  formulas instead, the bottom cell would still be underlined
Show All 1 Replies
Login to Reply
0
by Casey L.
added 2 years ago
2008 Diluted EPS
That number should be 3.34, not 3.33. this changes the growth rate from the erroneous 10.5% in the video to the correct 10.2%
Control R vs Paste Special
Why use Control R over Paste Special when pasting to the right? Control R may paste over some unwanted stuff or remove borders. For example, for Diluted EPS growth if you'd pasted it in it removes the bottom borders. I know you redid the formulas for that one, but Paste Special Formulas worked perfe...
Read More
End of Year vs Beginning of Year
Looking for clarity. We input $352,541 for the 2006 total revenue column, however it is listed under the 01/2007 row of the forecast document. Is it because $352,541 represents the total revenue for the entire 2006? The 01/2007 row would then represent the end of 2006.
error
Hi as someone mentioned before, there is an error for the eps for 2007 which should be 3.34.
In order to get full credit do I put the incorrect number from the video or do I put the correct one from the pdf?
In order to get full credit do I put the incorrect number from the video or do I put the correct one from the pdf?
Total Debt
Why is there a total debt cell ($34,778) but then when we calculate the total debt/total capitalization, and the total debt/EBITDA the numerator is total debt + preferred stock + minority interest?
total debt definition
May I know why preferred stock and minority interest are included in total debt? I see them as equity.
Company Overview: Typo $3.34 not $3.33
Errata: Please note that at approximately 9:42 of the Financial Summary  Part 2 video the correct input should be $3.34 not $3.33 as the video mistakenly inputs.