courseraБизнес

Introduction to 3-Statement Modeling

Курс от Corporate Finance Institute

Средний≈ 6 чАнглийский

О курсе

The three-statement financial model forms the foundation on which almost all other types of models and analyses are built, and creating one is a crucial skill for many finance professionals. In this course, we will build a three-statement model from scratch and then review and audit it to make sure it’s working properly. You will gain a step-by-step understanding of how the income statement, balance sheet, and cash flow statement are linked together within a dynamic financial model. The course will emphasize best practices in structuring models, building assumptions, and ensuring accuracy and consistency across all statements. In addition, you will develop practical skills in forecasting financial performance, identifying key drivers of business results, and troubleshooting model errors. By the end of the course, you will be able to confidently build and audit a fully integrated three-statement model for real-world financial analysis.

Навыки, которые вы освоите

Forecasting Income Statement Cash Flows Balance Sheet Financial Statement Analysis Financial Forecasting Financial Statements Cash Flow Forecasting Revenue Forecasting Financial Modeling Auditing Financial Auditing

Программа курса

11 модулей · 62 учебных материалов

013-Statement Modeling7 материалов

Introduction

Getting StartedЧтение IntroductionВидео Downloadable FilesЧтение

Model Overview

Model OverviewВидео

Types of Models

Учитесь у экспертов

CFI (Corporate Finance Institute)

Преподаватель курса

Introduction to 3-Statement Modeling

О курсе

Навыки, которые вы освоите

Программа курса

Introduction

Model Overview

Types of Models

Учитесь у экспертов

CFI (Corporate Finance Institute)

3-Statement is the Foundation

Modeling Structure

Modeling Best Practices

Number Sign Convention

Complex vs Simple Models

Model Inputs

Model Processing

Model Outputs

Structure and Layout

Knowledge Check

Module Content

The Case Study

Module Content

Historical Data Walkthrough

Different Forecasting Methods

Model Assumptions and Drivers

Income Statement Historical Metrics

Historical Metrics vs Guidance Review

Forecasting Methods

Forecasting Revenue

Forecasting Gross Margin and Expenses

Forecasting to EBITDA

Working Capital Overview

Accounts Receivable

Accounts Payable

Inventory

Calculating Working Capital Metrics

Working Capital Scheduling

Forecasting Capital Assets

PP&E Schedule

Knowledge Check

Forecasting Debt and Equity

Introduction to Capital Structure

Debt Corkscrew and Interest Expense

Common Stock Corkscrew with Retained Earnings

Intro to the Cash Flow Statement

Cash from Operating Activities

Cash from Investing and Financing Activities

Cash Flow from Statement Walkthrough

Module Content

Auditing and Reviewing Techniques

Auditing and Reviewing the Model Part 1

Auditing and Reviewing the Model Part 2

Linking Chart Data

Module Content

Final Thoughts

Modular Approach

Next Steps

Qualified Assessment