|
Course Overview
|
:
|
Microsoft Excel is one of the most popular tools to integrate financial models in an effective and secure manner. It is a primary financial management tool that has the ability to identify and track all the connecting points that help to manage enormous volumes of calculations involved in building a durable financial model.
Financial Modeling skills are essential for finance and commerce professionals, particularly for seasoned executives. It helps users gain a firm understanding of financial modeling techniques to succeed in today’s competitive environment.
This course is aimed at both intermediate and experienced staff and includes the construction of an integrated set of simplified financial statements and subsequent investment appraisal. You will learn key tools of Excel which are useful for business analysis and how to construct a reliable financial model encompassing three financial statements (balance sheet, profit and loss statement and cash flow).
|
|
|
|
|
Key Learning Outcomes
|
:
|
By the end of this interactive course, the attendees will:
- Improve their efficiency in using Excel shortcuts;
- Use several of the support tools and techniques in spreadsheet programs;
- Build a robust financial model;
- How to forecast working capital using excel;
- Analyze results from excel sheet based on financial statement input.
- Understand projection parameters.
- Understand how to forecase Revenue, Exp, Dep, WC, Debt, Share & Equity, CapEx.
- Understand the flow of Financial Model.
- Understand the approach to be used for all your financial modeling projects.
- Learn how to use time series, checks, assumption, calculations and outputs.
- Balance the balance sheet in seconds.
- Avoid the most common mistakes and pitfalls in model design.
|
|
Target Audience
|
:
|
The course is ideal for anyone looking to improve their skills in Excel. It will be of particular benefit to corporate and project financiers, finance managers, accountants and bankers.
Specifically, the course will be beneficial to:
- Financial analysts;
- CFO;
- Financial controllers;
- Analysts;
- Credit managers;
- Risk managers;
- Corporate finance staff;
- Ideal for candidates who are Graduates, Post Graduates, Post Doctoral, or have completed courses in Engineering and Commerce who want to have a career in finance.
|
|
Course Detailed Outline
|
:
|
Module One: Financial modeling introduction
- Model benefits
- Model best practice
Module Two: Basic Financial Modeling Tools
- Excel overview and keyboard shortcuts
- Some relevant financial functions
- Some relevant created functions using VBA
- Some relevant logical functions
- Some relevant lookup functions
- Some relevant date and time functions
- Building charts
- Naming conventions, formatting conventions, organisation of spreadsheets and use of range names
- Using spinners for sensitivity analysis
- Using solver vs. goal seek
- Data validation and creating a drop down menu
- Sheet protection
- Hiding items, calculations, etc.…
- Hyperlinks
- Inserting notes
- Conditional formatting
Module Three: Best Application Models with Basic Excel and VBA Functions
- Investment decision criteria (FV, PV, NPV, IRR, MIRR, Payback, Discounted Payback, XIRR and XNPV)
- Breakeven and sensitivity analysis
- Differential analysis
- Mortgage
- Using macros
- Recording macros
- Creating functions using Visual Basic Applications (VBA®)
- Application examples using VBA®
Wrap UP
|
|
Methods of Delivery
|
:
|
- This training course will combine:
- Presentations with instructor-guided interactive discussions between participants relating to their individual interests.
- Practical exercises,
- Video material case studies,
- Presentations and group discussion in an active and participative way supported by reading and reference materials.
- All participants receive a comprehensive binder containing copies of the presentation slides, handouts and other course material.
|
|
Course Details
|
:
|
Course Date: 24-26 November 2020
Number of Days: 3 Days
Timing: 5:00 PM- 9:00 PM
Language of the Course and Material: English
Venue: Hotel Venue/ Virtual Training
|
|
Registration
|
|
For registration, please send an email with the names and designation of nominee/s to the following E-mail:
Or Call us @
Fax:
Please ask about our corporate discount policy
|
