OVERVIEW

Gain comfort with the core, fundamental mathematical techniques used throughout the financial industry, with an emphasis on the time value of money.

OVERVIEW

• Solve Future Value, Present Value and Yield calculations
• Value Annuities, Perpetuities and Growing Perpetuities
• Apply time value of money techniques to a Discounted Cash Flow (DCF) valuation and bond pricing
• Calculate Annual Equivalent Rates of interest
• Understand and calculate mean, median, variance and standard deviation for a data set.

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

Familiarise yourself with the three key financial statements, the Income Statement, Balance Sheet and Cash Flow Statement, to understand how the three statements give us a variety of information about the performance and current state of a business. This module introduces financial statements with no assumption of prior knowledge.

LEARNING OBJECTIVES

• Understand the Income Statement, calculate and interpret key metrics including margins
• Understand the Balance Sheet, and calculate metrics such as Operating Working Capital and Net Debt
• Understand the Cash Flow Statement
• Interpret and compare a variety of metrics to better understand the strengths and weaknesses of companies relative to their peers

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

WHAT YOU WILL LEARN:

By utilizing both basic and advanced Excel tools, this course is designed to dramatically improve a participant’s ability to use Excel efficiently. Whether you’re an investment banker, consultant, accountant, or specialist in healthcare, technology or industrials, this class offers the broadest, most valuable Excel skill set of any of course we offer.

KEY FEATURES

• The financial services industry (investment banking, consulting, research, asset management, brokerage, sales & trading, insurance, private equity, venture capital, entrepreneurship and start-ups)
• Corporate/strategic development or finance group of a corporation
• Marketing, brand management or operations for a corporation or any position responsible for a product or divisional budget, projections and profit/loss statement
• Enhancing their learning in finance and financial statement analysis classes
• Non-finance roles, but interested in gaining a solid foundation in applied corporate finance
• Optimized for PC based Excel

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

This free course will help you learn to build a fully integrated three statement forecast model for a corporate, learning best practice in formula construction and how to use keyboard shortcuts to eliminate use of the mouse. Throughout the training you will learn the tried and tested habits and techniques to minimize errors, and make models easy to interpret, adapt and audit.

LEARNING OBJECTIVES

• Forecast an Income Statement, Balance Sheet and Cash Flow Statement, given a set of forecast assumptions
• Build all formulae clearly and correctly
• Balance your balance sheet every time from your well-constructed CFS
• Compute interest income and expense based on average balances, and carefully control the resulting intentional circularity
• Check your complete model for errors and save it in a professional manner, ready to be shared with colleagues or clients

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

OVERVIEW

Learn the basics of the three main techniques used to value businesses and shares - Relative Value, DCF and Levered or LBO Valuation. In doing so you will also learn the distinction between equity value and enterprise value, and when each is appropriate to analyse.

LEARNING OBJECTIVES

• Calculate Equity Value and EV for a company given share price and balance sheet information
• Calculate EBIT, EBITDA and P/E multiples
• Perform a basic DCF valuation of a business
• Perform a basic LBO analysis and valuation of a business
• Understand the relative strengths and weaknesses of these techniques, and when one might be more appropriate than another

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.