Financial Modeling Crash Course with detailed Excel Models

Name: Financial Modeling Crash Course with detailed Excel Models
Rating: 4.3 (259 reviews)

Business Modeling that includes creating a Business Plan and Discounted Cash Flow method with real life case study

Created byFinXcel Academy

Last updated 8/2021

English

What you'll learn

Financial Modeling
Concepts of Business Planning, DCF valuation

Course content

3 sections • 18 lectures • 2h 7m total length

Introduction to the Course1:54
Introduction to the course and structure
Excel Refresher32:29
A quick refresher of some Microsoft Excel features and functions used in the model in later videos. Covers absolute referencing, date and time functions, finance functions, conditional and boolean expressions and offset function.

Introduction to Business Planning & Case study1:03
Introduction to Business Planning Module and structure
Business Model of a Company2:21
Discussion on how to understand business model of a company and introduce the case study
Structure of a Model1:31
Understand best practices to structure a financial model
Develop Model Timelines5:35
Develop timelines section in the model
Revenue Modeling7:30
Understand revenue drivers and develop revenue section in the model
Cost Modeling10:01
Understand cost drivers and develop cost section of the model
Working Capital Modeling8:23
Calculation of Accounts Payable, Accounts Receivables and Inventory
Capex Modelling3:19
Forecasting of capital expenditure in the business
Depreciation Modeling9:22
Understand straight line and reducing balance depreciation approach
Capital Modelling3:50
Develop model for debt and equity
Integrated Financial Statement - Part 18:05
Preparation of financial statement structure
Integrated Financial Statement - Part 29:16
Integration of revenue, cost, capex and other metrics in financial statements

Requirements

Conversant with excel
Conversant with Finance concepts

Description

This Course covers the financial management topics including business plan and valuation with real life case examples. The course includes building Dynamic Business Models built from scratch with multiples scenarios.

Apart from the concepts, the videos include working knowledge of building of the financial models highlighting the assumptions and formulaes involved

Who this course is for:

Students doing MBA finance,
Job aspirants in equity research , investment banking/management
Starters in Business Modeling jobs

Financial Modeling Crash Course with detailed Excel Models

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 34min

Introduction to business planning modeling12 lectures • 1hr 10min

Valuation using DCF Model4 lectures • 23min

Requirements

Description

Who this course is for: