Microsoft Excel Financial Modeling & Analysis Calculation

Excel Financial Modeling for Project Budgeting, Variance, Performance, Discounted Cash Flow Analysis etc

Financial Modeling and Analysis Using Microsoft Excel

Trainer

Financial Modeling and Analysis Advanced Level

Target Audience: Any financial management personal wanting to learn and apply many of the sophisticated data analysis tools available in Excel for decision making purposes.

Learning Outcome: Participants will be able to apply analytical techniques for financial and project budgeting, variance analysis, performance analysis, discounted cash flow analysis and perform various sensitivity analysis calculations. Participants will also acquire hands-on knowledge of sophisticated statistical and mathematical tools for resource planning, customer service analysis and a myriad of other management functions.

Pre-requisite: Participants should have working knowledge of basic Excel functions, formulas, and number formatting techniques.

Financial Modeling Analysis

Training / Course Outline:

1. DECISION SUPPORT PROCESS

Analyzing various types of data available
Gathering Data
Modeling Data
Interpreting Data
Sampling Data
Storing and Retrieving Data in Excel

2. ASPECTS OF MODELLING

Identifying relationships graphically
Correlation
Fitting a “best-fit” curve in Excel

3. PIECEWISE MODELING

Locating “breakpoints” in data
Calculating CUSUM (Cumulative Summation)
Identifying trends, cycles and noise
Application of CUSUMs
Linear and non-linear models
Regression analysis

4. PREDICTION AND ESTIMATION

Calculating future values based on past and historic values

5. CORPORATE FINANCIAL ANALYSIS

Comparable company analysis
Liquidity of a company
Asset management and activity
Assessing profitability management
Market and valuation

6. WORKING WITH EXCEL FUNCTIONS

Looking up specific values from a database or table
Applying the various COUNT functions
Performing specific analysis of data with SUMIF, AVERAGEIF, and COUNTIF

7. APPLICATION OF EXCEL’S FINANCIAL FUNCTIONS

Understanding Time Value of Money
Future Value (FV), Present Value (PV) and Net Present Value (NPV)
Internal Rate of Return (IRR) and Multiple Internal Rate of Return (MIRR)
Using XNPV and XIRR
Loan calculations based on principal amount and interest rates
Cumulative principal and interest payments

8. APPLICATION OF EXCEL’S ADVANCED FEATURES

Performing a sensitivity “what-if” analysis using Goal Seek in Excel
Creating a one-input and two-input Data Tables for financial analysis
Consolidating data from multiple sheets and performing calculations automatically
Creating a drop-down list option within a single cell

9. CASE STUDY USING EXCEL

Share
Share