Master Excel: Build a Dynamic 13-Week Cash Flow Model
Focused View
2:29:24
01 - Unlocking the power of cash flow forecasting.mp4
00:50
01 - 13-week cash flow overview.mp4
02:51
02 - A simple cash flow.mp4
02:44
03 - What were going to build.mp4
03:14
04 - Email from the CFO.mp4
02:36
01 - Format bank data.mp4
03:50
02 - Inserting helper columns.mp4
03:53
03 - Add the week-ending date.mp4
03:24
04 - Import cash forecast template.mp4
03:49
05 - Build the error checking tab.mp4
03:23
06 - Conditional format error checking.mp4
03:55
07 - Build transaction mapping tab.mp4
04:13
08 - Build unique IDs and categories.mp4
07:08
09 - Build an exact match formula.mp4
04:28
10 - Build a text contains formula.mp4
06:48
01 - Calculate the history.mp4
07:00
02 - Bring in the AP aging report.mp4
03:59
03 - Bring in the AR aging report.mp4
03:17
04 - Link the AR and AP aging reports.mp4
05:10
05 - Finish the cash forecast.mp4
06:29
01 - Establish summary dates.mp4
02:31
02 - Populate the summary.mp4
05:28
03 - Build a cash flow chart.mp4
05:52
01 - New email from CFO.mp4
02:12
02 - Duplicate the cash forecast.mp4
02:27
03 - Bring in new bank data.mp4
04:16
04 - Bring in the AR and AP reports.mp4
04:01
05 - Refresh the history in the cash forecast.mp4
02:29
06 - Update the forecast.mp4
04:12
07 - Update the summary.mp4
02:11
01 - Add variance tags.mp4
03:06
02 - Begin the variance report.mp4
03:23
03 - Bring in the variance report layout.mp4
01:00
04 - Start populating the bridge.mp4
04:25
05 - Calculate the category variances.mp4
06:54
06 - Finish the bridge.mp4
03:51
07 - Close out the file.mp4
04:30
01 - Course summary and conclusion.mp4
03:35
More details
Course Overview
Learn to create a professional 13-week cash flow forecast in Excel with Christopher Reilly. This hands-on course covers data preparation, forecasting techniques, variance analysis, and model maintenance for effective financial management.
What You'll Learn
- Clean and structure financial data for forecasting
- Build a dynamic cash flow model from scratch
- Perform variance analysis between projections and actuals
Who This Is For
- Financial analysts and accountants
- Small business owners managing cash flow
- FP&A professionals building forecasting models
Key Benefits
- Create a reusable cash flow forecasting template
- Master advanced Excel techniques for finance
- Gain practical skills for immediate application
Curriculum Highlights
- Cash Flow Forecasting Fundamentals
- Data Preparation & Model Construction
- Analysis & Model Maintenance
Focused display
Category
- language english
- Training sessions 38
- duration 2:29:24
- Release Date 2025/04/19
