Financial Analysis and Modelling with Excel

Excel Financial Modeling Training Course

The Financial Analysis and Modelling with Excel training course is aimed to equip students with computation skills to analyse and evaluate projects, budgets and other finance related activities on their suitability for investment. With the help of the Excel’s business data analysis tools, financial models can be constructed to calculate, forecast, estimate financial numbers which can help companies to allocate resources and evaluate potential projects for maximum return-on-investment.

The course will cover Excel financial functions, Excel’s business modelling tools, forecasting techniques, financial statement analysis tools, time value of money and more. As there is no simply way to learn without doing it, students will have extensive practice chance to work on the easy to follow exercises.

The daytime or evening classes are offered to match students’ different training needs. If you are business owners, finance and accounting professionals, business analyst, consultants or individuals for personal finance will find that course useful.

Excel Financial Modeling Training Course

What you’ll learn

Building Financial Formulas

  • Working with Interest Rates
  • Calculating the Future Value
  • Calculating the Present Value
  • Calculating Net Present Value
  • Discounting Cash Flows
  • Calculating the Payback Period

Using Excel's Business-Modeling Tools

  • Using What-If Analysis
  • Working with Goal Seek
  • Working with Scenarios

Financial Statement Analysis Tools

  • Ratio Analysis
  • Analyzing Liquidity Ratios
  • Analyzing Profitability Ratios
  • Leverage Ratios
  • Activity Ratios

Time Value of Money

  • Single Cash Flow
  • Annuity
  • NPV Using Constant Discounting
  • NPV Using General Discounting
  • Loan Amortization
  • Sensitivity Analysis

SCHEDULES
 
FAM0022 - 廣東話 16 Feb enrol
 
FAM0031 - 廣東話 02 Mar enrol
 
FAM0032 - 廣東話 16 Mar enrol
 
FAM0043 - 廣東話 14 Apr enrol
 
FAM0042 - 廣東話 15 Apr enrol

Forecasting with Moving Average and Chart

  • Using Moving Average Add-In
  • Creating Moving Average Forecasts with Excel’s Charts
  • Analyzing Trends Using Best-Fit Lines
  • Plotting a Best-Fit Trendlines

Forcasting on Linear Data

  • Understanding the Regression Equation
  • Understanding R2 - coefficient of determination
  • Making Linear Forecasts: The TREND and LINEST Function

Forcasting on Nonlinear Data

  • Working with an Exponential Trend
  • Working with a LogarithmicTrend
  • Making Nonlinear Forecasts: The GROWTH Function
  • Working with a PowerTrend
  • Using Polynomial Regression Analysis
  • Using Mulitple Regression Analysis

Building Capital Budgeting Models

  • Forecasting Cash Flows
  • Working Capital
  • Sensitivity Analysis
  • Break-Even Analysis on accounting profit
  • Break-Even Analysis on NPV