Financial Modeling With Microsoft Excel

Financial Modeling With Microsoft Excel Financial Modeling With Microsoft Excel
By TED Integrated
PSMB HRDF Claimable
Course Title:
Building Financial Models With Microsoft Excel
Training Category:
Information Technology
Target Audience:
This course is suitable for Accountants, Financial Professionals, Investment Analysts, professionals who manage accounting and financial tasks and individuals who are interested in personal financial management.
Duration:
2 Days
Public Program* Now Available! »
Dec 2017 ›
Venue:
TED Learning Centre, Binjai 8, Kuala Lumpur, Malaysia
Schedule:
Thu 14 Dec 2017 - Fri 15 Dec 2017
9:00AM - 5:00PM

Fee Per Person:
RM1,400.00
Promotions:
  • 10% discount for group registration of 3 paxs or more from the same organization.
Register Now!

* Other terms & conditions apply.
Apr 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Thu 12 Apr 2018 - Fri 13 Apr 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
May 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 23 May 2018 - Thu 24 May 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Jul 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 18 Jul 2018 - Thu 19 Jul 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Aug 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 15 Aug 2018 - Thu 16 Aug 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Oct 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Wed 17 Oct 2018 - Thu 18 Oct 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
Nov 2018 ›
Venue:
The Zon Hotel, Jalan Ampang, Kuala Lumpur, Malaysia
Schedule:
Mon 19 Nov 2018 - Tue 20 Nov 2018
9:00AM - 5:00PM

Fee Per Person:
RM1,484.00
Register Now!

* Other terms & conditions apply.
For In-house Training »
Request for Quotation Request for Quotation
For Customization & Other Inquiries »
Contact TED Integrated
Contact customer service +603-2386-7788
Email customer service [email protected]
Delivery Methods
  • Language: English
  • Workshop
  • PowerPoint Presentation
  • Presentation Handouts
  • Computer Lab Work
  • Certificate of Participation
Ad by Google
*Terms & Conditions
Microsoft Excel Training Series:

Building Financial Models With Microsoft® Excel

“Let Microsoft Excel does something more on the financial aspects of your business and gain back a greater ROI out of it!”

By TED Integrated


PSMB Certified Training Provider
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Register for Public TrainingRegister for Public Training
Email Customer Service [email protected] Contact Customer Service+603-2386-7788

Introduction

The most fundamental and widely sought after skills in the finance industry is financial modelling. The Microsoft Excel financial model depicts the financial statement and investment analysis. In addition, Participants gain various techniques in investment appraisal, budgeting, financial analysis and forecasting. The presentation of the performance of a business, a project or any other investment cab represent by financial models.

Prerequisites

Completion of Basic & Intermediate Microsoft Excel course or equivalent knowledge. Basic financial related working knowledge is required.

Course Objectives

The repetitive tasks can be time consuming. The macro programming allows users to automate repetitive tasks and leverage on Excel's built in to consolidate data in the most efficient way in order to minimise errors.

The process of learning step by step where each component build up or feed into another component in a budget model is significantly important. Majority of professional are familiar with output of financial statement, only few are truly adept a building an accurate and effective financial from scratch.

Using Excel Solver helps to find the parameter that optimize cost and find best way to achieve an objective in many situations.

Course Outline

DAY 1

Forecasting With Excel

  • Moving Average
  • Exponential Smoothing
  • Trend lines
  • Handling Seasonality & Trend
  • Correlation
  • Regression Analysis

Excel Tools & Functions in Financial Modelling

  • Linking Data
  • Consolidating Data
  • Consolidating With Formulas
  • What If Analysis
  • Introduction To Macro Programming

DAY 2

Building an Automated Budget Model

  • Sales Budget
  • Cost Of Sales Budget
  • Inventory Budget
  • Budgeted Income Statement
  • Budgeted Balance Sheet
  • Budgeted Cashflow

Investment Appraisal

  • Net Present Value Function
  • Internal Rate Of Return Function
  • Mutually Exclusive Project
  • Non Mutually Exclusive Projects

Optimisation Models with Solver

  • Using Excel's Solver
  • Building An Optimising Investment Model

For In-house Training:

Request for Quotation

Request for Quotation Now

For Content Customization & Other Inquiries:

Contact TED Integrated

Contact Customer Service

+603-2386-7788

Email Customer Service [email protected]

Ad by Google

Related Training Courses:

More Other Training Courses:

Published by: ,