Excel for Finance: Building a Three-Statement Operating Model

سرفصل های دوره

A three-statement operating model incorporates your company’s income statement, balance sheet, and cash flow statement to provide an integrated and complete view of your organization’s financial health. Follow along with Chris Reilly, financial modeling expert and experienced Excel trainer, as he shows you how to build a three-statement model in Excel. Chris explains how to clean up source data, build the cash flow statement, build EBITDA, and forecast the income statement, balance sheet, debt schedule, and more.

01 - Introduction

01 - FP&A in Excel

02 - What you should know

03 - What youre going to build

02 - 1. Cleaning Up Your Source Data

01 - Call with the CFO

02 - Initial groundwork and freeze frames

03 - Identifying hardcoded data

04 - Applying the currency format

05 - The value of a placeholder row

06 - Initial error checking

07 - Expanding on error checking

08 - Formatting guide

09 - Indenting and cleanup

03 - 2. Building the Cash Flow Statement

01 - Build the cash from operations

02 - Build the cash from investing

03 - Build the cash from financing

04 - Build the change in cash and ending cash

04 - 3. Building EBITDA

01 - An overview of EBITDA

02 - Building the EBITDA schedule

05 - 4. Forecasting the Income Statement

01 - Foundation of a good forecast

02 - Build the annual income statement

03 - Build the annual balance sheet

04 - Calculating year-over-year growth

05 - Forecasting the revenue

06 - Forecasting the cost of goods sold

07 - Forecasting the variable expenses

08 - Forecasting the fixed expenses

09 - Forecasting the headcount

10 - Headcount in outer years

11 - Forecast the income tax expense

06 - 5. Forecasting the Balance Sheet Current Assets and Liabilities

01 - An overview of the balance sheet

02 - How to lay the net working capital

03 - Forecasting the accounts receivable

04 - Forecasting the inventory

05 - Forecasting the accounts payable

06 - Modeling prepaid expenses and accruals

07 - Building the bonus accrual

08 - Building the tax accrual

07 - 6. Forecasting Balance Sheet Assets Long-Term Assets and Liabilities

01 - An overview of CapEx and depreciation

02 - How to lay the fixed assets schedule

03 - Building the CapEx forecast

04 - Building the depreciation waterfall

05 - Modeling existing depreciation

06 - Connecting the fixed assets to the model

07 - Quick cleanup

08 - How to lay the debt schedule

09 - Groundwork of the cash flow sweep

10 - Finishing the cash flow sweep

11 - Modeling the revolver

12 - Getting started with term debt

13 - Setting up term debt amortization

14 - Modeling the term debt amortization

15 - Connecting the debt schedule to the model

08 - 7. Building the Covenants

01 - Model the leverage ratio

02 - Model the fixed charge coverage ratio

09 - 8. Building the Summary

01 - Pre-summary cleanup

02 - Link up the one-pager Part 1

03 - Link up the one-pager Part 2

04 - Stress testing the model

10 - Conclusion

01 - Email to the CFO

02 - Epilogue Real-life application of the model

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)