CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.
EL21220011
This four module course demonstrates how a number of mathematical formulas can be used to conduct detailed analysis on a set of data and/or variables.
MODULE 1 - DISCOUNTED CASH FLOWS
• Understand the concept of the time value of money
• Explain terms such as present value, future value, NPV, DCF, annuities, and perpetuities
• Use DCF techniques to calculate present values
• Calculate the present value of cash flow streams such as annuities and perpetuities?
MODULE 2 - BOND PRICING AND YIELDS
• Use DCF to find the price of an annual or semi-annual bond
• Calculate the different yields used to assess bond return
• Understand the relationship between bond prices and yields
• Identify whether a bond is trading at par, premium, or discount
MODULE 3 - KEY STATISTICAL SKILLS
• Learn to calculate different measures of central tendency including arithmetic mean, weighted mean, WACC, and expected values
• Calculate simple moving and weighted moving averages
• Calculate different types of statistical dispersions such as range, variance, and standard deviation
MODULE 4 - COVARIANCE, CORRELATION & REGRESSION
• Use correlation and covariance to describe the relationship between two variables
• Calculate covariance and correlation using Excel
• Use regression analysis to describe the relationship between two variables
• Undertake regression analysis in Excel and interpret the results
½ Passport Day - 3 Hours