Financial Modeling with Excel

Description

This course enables learners to harness the capability of MS Excel for Financial Modeling. You will create integrated models to capture past and future financial for a company or project, use Ratio Analysis and Common Size statements for analyzing performance and understand the flow of numbers in a model – Formula Auditing. You will learn different Analysis tools and models and represent performance metrics using Charts and Dashboards

Additional information

Day 1

Session 1: Introduction
Session 2 & 3: Modeling Past Financials
Session 4: Analyzing Financial Performance

Day 2

Session 1 & 2: Modeling Projected Financials
Session 3: Valuation / Bank Finance Assessment / Corporate Finance Decisions
Session 4: Formula Auditing; Formatting

Day 3

Session 1 & 2: Statistical Analysis and Forecasting
Session 3 & 4: Forecasting Under Different Levels of Complexity

Day 4

Session 1: Modeling with Form Controls
Session 2 & 3: Dashboarding
Session 4: Putting It All Together

Reviews

There are no reviews yet.

Be the first to review “Financial Modeling with Excel”

Your email address will not be published. Required fields are marked *