• Post category:StudyBullet-15
  • Reading time:7 mins read


Quickly learn and apply finance concepts in Microsoft Excel – Perfect for Beginners

What you will learn

Build a basic financial model in Excel.

Understand financial formulae in Excel and understand how to apply finance principles in Excel.

Learn the building blocks of a well structured financial model.

Description

Microsoft Excel is a powerful tool that is widely used in the finance industry for financial modelling. Financial modelling refers to the process of creating a mathematical model of a financial situation or project. It involves using Excel functions to calculate and analyze financial data to help make informed business decisions.

In this course Microsoft Excel Tools for Financial Modelling, you will:

  • Learn about the Excel tools to build financial models.
  • Discover the most useful Excel functions, add-ons, and formulas to build financial models, perform lookups, assess risk and scenarios and build reports.
  • Uncover the secrets of Goal Seek, Solver and Data Tables for optimisation and scenario analysis.
  • Understand the financial modelling process
  • See why cash flow waterfalls are so important.

PLUS get:

  • Downloads such as Excel shortcuts, model templates and more
  • Full course slides
  • Recommended reading, podcasts, and websites
  • Discount codes for the annual Financial Modelling Summit, the world’s largest gathering of financial modellers

Curriculum


Get Instant Notification of New Courses on our Telegram channel.


  • The layout of a financial model
  • Excel basics
  • NPVs and IRRs
  • Scenario Analysis
  • Data Tables
  • Goal Seek and Solver
  • Project Finance Models Overview
  • Model Auditing and Addins
  • Common Model Errors
  • Model Protection
  • Downloads
  • Recommended Reading
  • Bonus โ€“ Financial Modelling for Startups

About the Instructor

The course is presented by Financial Modelling Podcast and Summit Host Matthew Bernath. Matthew is an experienced financial modeller, entrepreneur, and CFAยฎ charterholder with a passion for finance, alternative data and analytics.

Matthew hosts the Financial Modelling Podcast, which has been rated as one of the top finance podcasts by the Corporate Finance Institute and Financial Edge. Matthew was previously in a large investment bankโ€™s Infrastructure Finance division focusing on project finance deal structuring and modelling.

English
language

Content

Introduction

Introduction

Layout of a Financial Model

What is a Financial Model?
Model Lifecycle and Typical Layout

Excel Basics and Not So Basics

Excel Basics
Conditional Formatting
Conditional Formatting Example
Advanced Conditional Formatting Overview
Naming Cells and Ranges
Introduction to Data Validation
Data Validation and Sumproducts for Data Analysis
Sumproduct Example with Drop Downs

NPVs and IRRs

Overview of Core Finance Principles: NPV and IRR
NPV and IRR in More Detail
NPV and IRR Formulas in Excel
Converting Rates
NPV Example
NPV Lecture 2
NPV – Micro-Loans Example Explained
XNPV – Net Present Value of a Bank Loan
XNPV – Bank Loan Example Walkthrough
Discounted Payback Periods
Preppy Property Fund Example Walkthrough
Weighted Average Cost of Capital (WACC)
WACC Example Explained
Finance Formulas Practice Workbook

Scenario Analysis

Introduction to Sensitivity Analysis
Scenario Manager Example

Data Tables: Performing single and multi variable sensitivity analysis

Introduction to Data Tables
Data Tables Part Two
Data Tables Part Three: Two Variable Data Tables
Data Tables Part Four: IRR Example

Goal Seek and Solver

Introduction to Goal Seek
Goal Seek Example
Introduction to Optimisation Using Solver
Solver Example – Optimising Deals

Overview of Project Finance Models

Introduction to Project Finance
Project Finance Cashflow Waterfall

Model Auditing and Useful Tools

Formula Auditing and Error Solving
Formula Auditing Example
Arixcel Demo

Common Model Errors and How to Avoid Them

Common Errors and Causes

Model Protection

Protecting Financial Models

Additional Downloads

Rates Conversion
DateDif