Wall Street Training Certification Bundle [for PC]

The world of accounting starts and ends with financial statements. Whether you’re looking to boost your business skills or commit to a career counting dollars, this course is the perfect place to start. Solidify your skills with the chance to earn an official certification upon completion.

• Study the basics of financial accounting & statements w/ this 4 hour course (2.5 hours of video)
• Understand income statements, balance sheets, cash flow statements & more
• Learn about the different components of a major financial statement
  • IS: Revenue & expense items, EBITDA defined and discussed
  • BS: assets, liabilities & shareholders’ equity
  • CF: cash flow from operations, investing activities & financing
• Understand the relationships between financial statements
• Dive into an explanation of accrued expenses, receivables & payables

Provide your company or any entity with the data needed to make smart financial decisions. This course will teach you to be an Excel pro, while extracting impressive and accurate reports at the drop of a hat.

• Learn to utilize Excel for analyzing data w/ 2 hours of coursework
• Easily summarize financial records or trading statistics
• Analyze historical results to make assumptions
• Make well-informed estimates based on data
• Seamlessly navigate Excel
• Build trading statistics summaries showing standard market valuation multiples

This course is anything but “basic”, but is the essential stepping stone to working efficiently in Excel. Perfect your skills by building models that accurately represent financial performance and estimated value.

• Absorb the fundamentals of advanced Excel usage w/ 5 hours of training
• Earn an official certification upon completion
• Create a top-down, five year income statement projection model
• Construct a basic discounted cash flow analysis on top of your projection model
• Input historical financial results & make changes as they emerge
• Calculate growth rates & margins to make smarter decisions
• Estimate your profitability— revenue to EPS
• Accurately calculate outstanding diluted shares
• View differences between U.S. & international GAAP

The term Merger and Acquisition refers to the process of consolidating companies, and of course the financial institutions thats handle the nitty gritty details. Learn the ins-and-outs of structuring and handling these complex transactions to expand your financial skillset into a vital area of expertise.

• Set up the major steps & timelines of M&A w/ 2.5 hours of training
• Understand, analyze & structure a deal
• Grasp the motivation behind M&A and the financial implications
• Be aware of common structural issues in transactions
• Study the major stages of a deal including negotiation & closing
• Learn about payment schedules & tax implementations
• Differentiate between stock & cash considerations
• Get a detailed analysis of the line-by-line accretion/dilution model

Take your newfound M&A knowledge to the next level by mastering the nuances of mergers. What are the implications associated? Get the answer to that question and more with this deep dive into finance modeling.

• Quickly grasp the implications of mergers w/ this .75-hour course
• Earn an official certification upon completion
• Build an accretion / dilution merger consequences model to augment your skills
• Understand synergies switch, cash vs. stock sensitivity
• Explore amortization of goodwill switch (depending on purchase price allocation)
• Navigate common structural issues: stock vs asset deals and 338 (h)(10) elections
• Consider the tax implications of transactions based on deal structure & FASB 142 goodwill amortization
• Analyze the breakeven PE for both 100% stock & 100% cash considerations
• Calculate pre-tax & after-tax synergies / cushion required to breakeven