Udemy Financial Modeling for Corporates

Video Introducing this tutorial


Jumpstart :
Introduction
Course Aims & Course Structure

Context & Principles for Success :
Overview
Types of Models
How This Training is Different
Overview of How the Model Fits Together
Teaching Principles: The Principles Behind Development of This Course
Principles for Success for Financial Modeling
The Drivers of Financial Model Complexity

Foundations of Best Practice Financial Modeling :
Financial Modeling Best Practices and What Not To Do!

Shoe Business Introduction & Model Infrastructure :
Overview
Introduction to The Start Model (+ .xlsx START FILE)
Inputs Page: Tools in Use (e.g. Data Validation, Named Ranges)
Setup Page, Template Infrastructure & Tools (Cell Styles, Named Ranges)

The Timing Sheet: Transform a Spreadsheet into a Financial Model :
Overview
Inputs & Setting up the Timing Page
The Timing Strip: Dates & Flags
Counters to Help Connect Formula
Escalation to Go From Real to Nominal
Creating the Sheet Template: Copy Sheet

Model the Core Business Operations of Any Business :
Overview
Operational Inputs
Calculating Revenue
Cost of Sales - Calculating Cost Per Unit
Cost of Sales - Volumes & Cost
Calculating Fixed Costs
Variable & Total Costs
Capital Expenditure
Modeling Working Capital - Intro
Modeling Working Capital - Inventory
Modeling Working Capital - Debtors
Modeling Working Capital - Creditors & Net WC Adjustments
The Cashflow Statement
Overview
Linking - from Revenue to Capex

Financing the Business Through Debt & Equity :
Overview
Inputs, Timing & Account Setup
Calculating Interest Expense
Annuity Repayment
Bullet Repayment and Debt Service Summary
Calculating Debt Metrics Overview
Interest Coverage Ratio (ICR) and Debt Service Coverage Ratio (DSCR)
Equity - Share Capital & Distributions
Cashflow Statement - Linking

What is the P&L (Income Statement) & How to Model it :
Overview
Modeling the P&L

Modeling Accounting & Tax Depreciation Flexibly :
Overview
Depreciation Inputs & Capex Additions
Accounting Depreciation
Tax Depreciation

Model Corporate Tax to Calculate Tax Payable & Tax Paid :
Overview
Tax Computation
Tax Loss Account
Tax Payable & Tax Paid

The Balance Sheet - Fitting Everything Together Like a Jigsaw Puzzle :
Overview
Linking in the Balance Sheet

Actuals - Integrate Historicals & Roll Over Quarterly Updates Easily :
Overview
Copy the Statements & Format the Actuals Tab
Copying Actuals Values
Bringing in Actuals Balances to the Calculations Sheets
Updating Accounts with Actuals Balances
Bringing in Actuals P&L to QFS

Valuation Based on Intrinsic & Relative Valuation :
Overview
CAPM & WACC Calculation on the Inputs Sheet
DCF - Terminal Value
DCF - Cashflows & NPV
Multiples Method - Enterprise Value & Getting to Equity Value
Summary & Price Per Share

Using the Scenario Manager to Turbocharge Your Analysis :
Overview & the Scenario Manager Intro
How it Works & How's It's Been Done Historically...
Creating & Connecting the Scenario Manager to the Rest of the Model
Creating the Data Table & Running Key Analysis
Housekeeping: Clearing up Actuals Issues

Present a Beautiful Set of Outputs to Communicate With Impact :
AFS - Modeling the Financial Statements on an Annual Basis
Pulling Together the Summary - Financial & Operational Tables
Pulling Together the Summary - Creating Charts (+ .xlsx END FILE)

©2021 | All rights reserved.