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

FAM7091 - 廣東話 28 Sep enrol
FAM7101 - 廣東話 21 Oct enrol
FAM7111 - 廣東話 22 Nov enrol
FAM7121 - 廣東話 01 Dec enrol
FAM7122 - 廣東話 19 Dec enrol
  Excel VBA
  Excel Dashboards and Reports
  Excel for Mac - Advanced
  Excel-formulas & functions
  Financial Accounting with Excel

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