Financial Modeling With Excel

Financial Modeling With Excel

  Change Country / City:

Overview

Key Features

Course Outline

Who can Attend

Prerequisites

Financial modeling is the task of building a financial model, or the process of using a financial model for financial decision making and analysis. Financial modeling is used to do historical analysis of a company’s performance, and to do projections of its financial performance into the future. Project finance is another area that lends itself to financial models. A project (such as a real estate investment or a new factory) can be analyzed using a financial model. It does not have to be complete business.

Financial Modeling is not just for the accountant or financial consultant, who are called upon to develop financial projections, but also for business owners and managers. With improved user interfaces and heavy use of graphics, it is now feasible for non-technical people to use a financial model to test options and make decisions based on the projected impact on profits and cash flow.

3 Days Classroom or 24 hours Instructor led Online Training

Hard/Soft copy of study materials

150 days online access

Course Completion Certificate

24 PDU Certificate

Case studies based on each chapter

Real time Practical exercises and examples

Get exposure with experienced Trainer

Post training support

10% discount on any other Course

25% discount on any Online Course

Overview of financial modeling

Understanding projections

Excel best practices foundation and exercises

Useful Excel shortcuts and functions

Gathering historical documents / information

Preparation of Income and Cash Flow statements and Balance Sheet

Ratio Analysis

Du Pont Analysis

Financial Statement Analysis

Valuation of Companies

Valuation of IPOs

Valuation of Merger & Acquisitions

Valuation of Bonds

Valuation of Equity

Leverage Buyout Analysis (LBOs)

Sensitivity/Scenario Analysis

Monte Carlo Simulation

Case Study

Software Analysts

Finance Managers

Risk Managers

Chief Financial Officer

Credit Managers

Buyout Specialists

Financial Analysts

Financial Controllers

Any people who are graduates, post-graduates, Engineers and MBA finance, FRM degree holders.

Some knowledge of basic word processing, computing, and spreadsheets

Familiarity with the Microsoft Office work environment

An understanding of the Internet and web-page functionality.