Financial Modelling in Excel

by Ted Learning Claim Listing

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

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Ted Learning Logo

img Duration

2 Days

Course Details

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.

 

What Will I Learn From This Course? 

 

  • 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

 

 

Pre-requisites:

  • Completion of basic & intermediate Microsoft Excel course or equivalent knowledge. Basic financial-related working knowledge is required.

 

Methodology:

  • This Is Practical Lab Exercises Using Microsoft Office Tools Such As Powerpoint, Word And Excel

 

Course Outline For This Programme:
Module 1: Forecasting With Excel:

  • A. Moving Average

  • B. Exponential Smoothing

  • C. Trend Lines

  • D. Handling Seasonality & Trend

  • E. Correlation

  • F. Regression Analysis

 

Module 2: Excel Tools & Functions In Financial Modelling

  • a. Linking Data

  • b. Consolidating Data

  • c. Consolidating With Formulas

  • d. What If Analysis

  • e. Introduction To Macro Programming


Module 3: Building An Automated Budget Model

  • a. Sales Budget

  • b. Cost Of Sales Budget

  • c. Inventory Budget

  • d. Budgeted Income Statement

  • e. Budgeted Balance Sheet

  • f. Budgeted Cashflow


Module 4: Investment Appraisal

  • a. Net Present Value Function

  • b. Internal Rate Of Return Function

  • c. Mutually Exclusive Project

  • d. Non Mutually Exclusive Projects


Module 5: Optimisation Models With Solver

  • a. Using Excel’s Solver

  • b. Building An Optimising Investment Model

  • Kuala Lumpur Branch

    12-07, Binjai 8 Premium SOHO, Kuala Lumpur
  • Teacher's Name
  • Julian
  • Teacher's Experience
  • Academic Qualifications Diploma in Accountancy ACCA (Association of Chartered Certified Accountants), UK Professional Certifications Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer Microsoft Certified Trainer (MCT) Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications
  • Gender
  • Male
  • Teacher's Nationality
  • N/A

Check out more MS Excel courses in Malaysia

NexTrain Logo

Microsoft PowerPoint (Intermediate Level)

Microsoft PowerPoint training is offered by NexTrain. NexTrain Consultancy Sdn. Bhd. was established with the prime objective to train and upgrade the technical and management skills of the Malaysian workforce in manufacturing industries and commercial sectors.

by NexTrain [Claim Listing ]
AC Interactive Solutions Sdn Bhd (ACIS) Logo

Microsoft Office Specialist (Word)

Microsoft Office Specialist (Word) training is offered by AC Interactive Solutions Sdn Bhd (ACIS). Our passionate team of expert trainers is qualified and highly experienced in countless training fields.

by AC Interactive Solutions Sdn Bhd (ACIS) [Claim Listing ]
New Horizons Malaysia Logo

Microsoft Word

Microsoft Office Certification proves that you have core to advanced skills in Microsoft Office applications. Certification is helpful for those new to the workforce or transitioning to a more analytical role, since it proves you can perform tasks at a higher level. This gives you a leg up against ...

by New Horizons Malaysia [Claim Listing ]
IPA Training Logo

Microsoft Excel (Intermediate To Advanced Level)

Microsoft Excel provides you with the relevant tools to transform data into formatted and meaningful information. It also allows you to generate great business reports, graphs and charts for business analysis and presentation.

by IPA Training [Claim Listing ]
Iverson Associates Sdn Bhd Logo

Microsoft Word 2016 (Advance) WOR16A

In this Microsoft Word 2016 training class, students learn advanced techniques, such as working with tables of contents, footnotes, and endnotes, adding comments, tracking changes, comparing and combining documents, creating envelopes and labels.

by Iverson Associates Sdn Bhd [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy