Excel for Finance Building a Three-Statement Operating Model

Files Included :

01 - FP&A in Excel.mp4 (4.1 MB)
MP4
02 - What you should know.mp4 (2.26 MB)
MP4
03 - What you're going to build.mp4 (20.02 MB)
MP4
01 - Call with the CFO.mp4 (5.82 MB)
MP4
02 - Initial groundwork and freeze frames.mp4 (17.17 MB)
MP4
03 - Identifying hardcoded data.mp4 (10.13 MB)
MP4
04 - Applying the currency format.mp4 (15.22 MB)
MP4
05 - The value of a placeholder row.mp4 (17.87 MB)
MP4
06 - Initial error checking.mp4 (12.45 MB)
MP4
07 - Expanding on error checking.mp4 (16.95 MB)
MP4
08 - Formatting guide.mp4 (7.43 MB)
MP4
09 - Indenting and cleanup.mp4 (12.93 MB)
MP4
01 - Build the cash from operations.mp4 (27.6 MB)
MP4
02 - Build the cash from investing.mp4 (9.51 MB)
MP4
03 - Build the cash from financing.mp4 (10.14 MB)
MP4
04 - Build the change in cash and ending cash.mp4 (21.78 MB)
MP4
01 - An overview of EBITDA.mp4 (9.76 MB)
MP4
02 - Building the EBITDA schedule.mp4 (36.89 MB)
MP4
01 - Foundation of a good forecast.mp4 (34.97 MB)
MP4
02 - Build the annual income statement.mp4 (24.37 MB)
MP4
03 - Build the annual balance sheet.mp4 (17.84 MB)
MP4
04 - Calculating year-over-year growth.mp4 (19.66 MB)
MP4
05 - Forecasting the revenue.mp4 (26.73 MB)
MP4
06 - Forecasting the cost of goods sold.mp4 (25.23 MB)
MP4
07 - Forecasting the variable expenses.mp4 (26.65 MB)
MP4
08 - Forecasting the fixed expenses.mp4 (16.45 MB)
MP4
09 - Forecasting the headcount.mp4 (24.01 MB)
MP4
10 - Headcount in outer years.mp4 (24.19 MB)
MP4
11 - Forecast the income tax expense.mp4 (12.76 MB)
MP4
01 - An overview of the balance sheet.mp4 (8.2 MB)
MP4
02 - How to lay the net working capital.mp4 (16.8 MB)
MP4
03 - Forecasting the accounts receivable.mp4 (20.25 MB)
MP4
04 - Forecasting the inventory.mp4 (9.54 MB)
MP4
05 - Forecasting the accounts payable.mp4 (11.42 MB)
MP4
06 - Modeling prepaid expenses and accruals.mp4 (26.83 MB)
MP4
07 - Building the bonus accrual.mp4 (45.29 MB)
MP4
08 - Building the tax accrual.mp4 (35.4 MB)
MP4
01 - An overview of CapEx and depreciation.mp4 (9.58 MB)
MP4
02 - How to lay the fixed assets schedule.mp4 (12.18 MB)
MP4
03 - Building the CapEx forecast.mp4 (16.71 MB)
MP4
04 - Building the depreciation waterfall.mp4 (27.79 MB)
MP4
05 - Modeling existing depreciation.mp4 (11.55 MB)
MP4
06 - Connecting the fixed assets to the model.mp4 (24.31 MB)
MP4
07 - Quick cleanup.mp4 (16.97 MB)
MP4
08 - How to lay the debt schedule.mp4 (15.14 MB)
MP4
09 - Groundwork of the cash flow sweep.mp4 (23.33 MB)
MP4
10 - Finishing the cash flow sweep.mp4 (16.54 MB)
MP4
11 - Modeling the revolver.mp4 (17.68 MB)
MP4
12 - Getting started with term debt.mp4 (12.69 MB)
MP4
13 - Setting up term debt amortization.mp4 (14.57 MB)
MP4
14 - Modeling the term debt amortization.mp4 (16.95 MB)
MP4
15 - Connecting the debt schedule to the model.mp4 (28.24 MB)
MP4
01 - Model the leverage ratio.mp4 (23.93 MB)
MP4
02 - Model the fixed charge coverage ratio.mp4 (31.42 MB)
MP4
01 - Pre-summary cleanup.mp4 (26.87 MB)
MP4
02 - Link up the one-pager Part 1.mp4 (26.09 MB)
MP4
03 - Link up the one-pager Part 2.mp4 (17.11 MB)
MP4
04 - Stress testing the model.mp4 (15.86 MB)
MP4
01 - Email to the CFO.mp4 (7.51 MB)
MP4
02 - Epilogue Real-life application of the model.mp4 (27.94 MB)
MP4