Why take this course
  • Provides a solid foundation in applied corporate valuation in a condensed, practical manner (for both finance and
    non-finance job functions)
  • Essential foundation before interviews and internships
  • Enhances the learning experience in finance and financial statement analysis classes

COMPLETE BUNDLE

Please note – our Complete Bundle does not include Online Leveraged Buyout Modeling
DESCRIPTION

This package will start from the ground up accounting basics to Excel and modeling and continue onto the advanced intricacies of relative valuation and merger analysis by combining all of our courses including Accounting, Corporate Valuation, Excel Best Practices, Financial Modeling, Relative Valuation, and Merger Modeling. This course is the self-study version of one of our most popular live training programs at the top investment banks, consulting firms, and other Fortune 500 companies, as well as the top MBA programs.

KEY FEATURES

Accounting: This is will give you the an accounting foundation for finance professionals and take you through all you need to know even if you have no prior accounting knowledge so you can understand the key accounting principles, the financial statements, and perform financial ratio analysis.

  • Over 300 pages of content, including 150 practice problems and exercises
  • Estimated time to complete is 12-15 hours
  • Note: There is no online / multimedia content for this product

Corporate Valuation: This will explore the corporate valuation skills used by investment bankers and finance practitioners. How do you value companies for situations such as initial public offerings (IPO), general investing, leveraged buyouts (LBO), and mergers and acquisitions? What kinds of valuation tools are typically used by practitioners? Real world examples (e.g., Twitter's IPO) are used to enhance the experience.

  • Includes a core book
  • Over 250 pages of real-world examples, pen and paper exercises, and professional insight
  • Estimated time to complete is 12-15 hours
  • Note: There is no online / multimedia content for this product

Excel Best Practices: Learn how to quickly and efficiently use shortcuts to navigate, format, and build formulas and projections so you can model without touching the mouse.

  • Flip Chart book with shortcut keys and techniques
  • Excel drills and exercises
  • Over 4 hours of online video instruction
  • Estimated time to complete is 6 hours
  • 12 months free access to Online Companion
  • Compatible with PC Excel 2007 / 2010 / 2013 / 2016
  • Note: This course is not optimized for Mac Versions of Excel

Financial Modeling: Learn the actual hands-on step by step process of constructing of a dynamic model with 5 years of projections from scratch.

  • 180 page book, Excel models (template + solutions) and over 4 hours of online videos
  • Estimated time to complete is 12-15 hours
  • Case study with real-world disclosure
  • 12 months free access to Online Companion
  • Optimized for PC Excel 2007 / 2010 / 2013 / 2016
  • Note: The Excel shortcuts in this course are not optimized for Mac Versions of Excel, but this will not detract substantially from the course experience

Relative Valuation: This is an essential valuation methodology and this course takes a deep dive into the detailed intricacies of spreading comps, interpreting and analyzing the multiples, all the common complexities a practitioner might encounter.

  • Excel models (template + solutions)
  • 360 pages of a step-by-step guide with our professional insight
  • Suggested time to completion: 15-20 hours
  • 12 months free access to Online Companion

Merger Modeling: This intensive course is designed to develop merger modeling skills through in-depth M&A theory and the actual hands-on construction of a model from “scratch”.

  • 270 pages of a step-by-step guide
  • Approximately 5 hours of online instruction
  • Estimated time to complete is 12-15 hours
  • 12 months free access to Online Companion
  • Optimized for PC Excel 2007 / 2010 / 2013 / 2016
  • Note: The Excel shortcuts in this course are not optimized for Mac Versions of Excel, but this will not detract substantially from the course experience

TOPICS COVERED

Accounting

  • How to read and analyze an annual report
  • Analysis of a real world public company
  • Locating the latest and most relevant company information on the web
  • Detailed understanding of income statement, balance sheet and statement of cash flows
  • Relationships between three core statements, which will also aid in understanding corporate valuation and financial modeling
  • A primer on the time value of money
  • Understanding the importance of working capital on cash flow
  • Over 35 financial statement ratios delivered with example calculations and explanations
  • Over 150 exercises and knowledge checks

Corporate Valuation

  • Investment banking and mergers and acquisitions (M&A) overview
  • Corporate valuation terminology
  • Public comparables analysis
  • Acquisition comparables analysis
  • Discounted cash flow analysis
  • Merger consequences analysis
  • Leveraged buyout analysis

Excel Best Practices

  • Navigating in Excel
  • Optimizing your modeling environment
  • Modeling standards used by practitioners
  • Modeling and Excel efficiencies
  • Advanced modeling techniques
  • Data table analysis
  • Conditional formatting
  • TTS’ famous shortcut keys and function keys
  • TTS’ popular macro toolkit (TTS Turbo Macros)

Financial Modeling

  • Income statement, balance sheet and cash flow statement relationships
  • Working capital, depreciation and capital expenditure schedules
  • Intangibles amortization schedule
  • Shareholders’ equity schedule with a share repurchase table
  • Debt and interest schedule with a “cash sweep”
  • Understanding and controlling circular references
  • Strategies for balancing a model
  • Sensitivity analysis to match expected financial performance
  • How to build a quick discounted cash flow analysis (DCF)

Relative Valuation

  • Foundations of public comparables
  • Foundations of acquisition comparables
  • Normalizing and adjusting the income statement
  • Adjusting for restricted stock and restricted stock units
  • Complications such as dual share structures and foreign listed shares
  • How preferred stock, equity in affiliates, noncontrolling interest, and pensions affect valuation
  • Summarizing valuation through a Football Field or floating bar chart

Merger Modeling

  • Overview of the merger process from the buyer's and seller's perspective
  • Purchase accounting and modeling write-up of assets
  • Accretion / dilution analysis modeling
  • Relative P/E analysis and other useful techniques
  • Advanced analysis such as exchange ratio analysis, contribution analysis and premium paid analysis
  • Deal mechanisms such as collar agreements and defense against hostile takeovers

PREREQUISITES

  • None, this course assumes no prior accounting or valuation knowledge

TESTIMONIALS

Corporate Valuation

  • “Better than my MBA!”
  • “My first year of B School included a two day workshop where TTS came to campus and worked us through this entire course in person. The conceptual and technical information within this coursepack is great. I actually used them my first week of my MBA internship when valuing an acquisition target and presenting my valuation, along with a comps analysis, to senior management.”

Excel Best Practices

  • “Nothing is more key to becoming a successful investment banking analyst or associate than speed and proficiency. Becoming fast is achieved by becoming efficient. In Excel, program setup and the associated shortcuts can make you incredibly efficient. This course is extremely practical and honed in on the best way to become efficient navigating Excel. As a living testament to the benefits of this program, every analyst at the bulge bracket investment bank where I work has the TTS list of excel shortcuts printed out and posted on his/her cube wall.”
  • “I took a TTS Excel course this past year during my MBA program and found the course immediately useful both on the job and during class. Currently, I am using the online refresher to prepare for job interviews.”
  • “I have always considered myself to have a high proficiency in Excel through my experiences in Finance and Data Management. This course still proved to be invaluable.”

Financial Modeling

  • “As someone who has passed all three CFA exams and worked in private equity, this course is a great tool in applying acquired knowledge.”
  • “Love it. My usage is actually for use in nonprofits and small business - but I got plenty of tips and methods I can use to do my financial projections and analysis more efficiently. Lessons easy to follow at least at my level”
  • “TTS is the best on the Street. I've had training with them through a bulge bracket investment bank for summer internship and through business school classes. Their courses deliver a simple to follow natural progression to building a model. It’s all based on real world application and not just theoretical. After going through the course, you will have the flexibility of building a bare bones model in 30 minutes or a much more elaborate model with additional add-ons that are company specific. Due to the strong foundation TTS develops, it’s easy to add additional complexity. The time saved from learning all the shortcuts is necessary to survive banking and worth the class itself (would recommend doing the excel best practices course for this as well).”
  • “Mastering financial modeling is becoming an essential part of business career even as a management consultant, not even working in a finance role/ within the financial industry. Perhaps just knowing the advanced features of Excel USED to be sufficient. But even then you still don’t have an understanding of how to organize the data from financial statements and 10-Ks in the most efficient manner that delivers the maximum insights. The TTS online course takes a comprehensive, soup to nuts approach and walks you through the entire process through the lens of Excel. Definitely the most practical and comprehensive training I’ve seen. Highly recommended!!!”

Merger Modeling

  • “Excellent course. It’s all based on real world application and not just theoretical. After going through the course, you will have the flexibility of building a bare bones model in 30 minutes or a much more elaborate model with additional add-ons that are company specific. Due to the strong foundation TTS develops, it’s easy to add additional complexity. I've used the concepts from the merger model to quickly evaluate M&A deal news released in morning to trade by the open. Also recommend the financial modeling course and the excel best practices”
  • “Kudos to TTS for a very efficient learning tool, from the incredible material for beginners and finance professionals alike, delivered in via a great interface. Each module is concise, enabling information download and the support material provided fosters a practical experience equivalent to being in an actual classroom.”