Course
Build a 13-Week Cash Forecast
Build the cash forecast CFOs rely on, step by step in Excel, using a real manufacturing company.
Companies rarely go out of business because they run out of profit. They run out of cash. In this course you step into the controller's seat at Bean & Bag Roasters, a $6 million coffee manufacturer that is profitable but watching its cash fall, and build a 13-week cash forecast from scratch: the opening balance from the bank, collections from the AR aging, inventory and vendor payments, payroll and fixed costs. Then you use it the way a CFO does: find the crunch week, plan line of credit draws and repayments, protect the cash with the right controls, and keep the forecast running every week. A bonus lecture shows how to update the forecast with Claude from your QuickBooks exports.
- FP&A
- Finance
- Beginner
- Manufacturing
- 3.5 CPE credits
- 2 hours of lectures
- 13 lectures
- Lifetime On-Demand Access
- Downloadable Excel Workbook
- Access To Instructor
- Certificate Of Completion
- 3.5 NASBA CPE Credits
- 14-day Money-back Guarantee
Checkout and course delivery are hosted on Teachable.
Course facts
What's included
3.5
CPE credits
2h
Lecture hours
13
Lectures
Excel workbook with a tab for every lecture, plus sample QuickBooks AR aging, AP aging and bank exports
Templates
Review questions after each module and an 18-question final assessment
Quizzes
- Duration
- 2 hours
- Access Duration
- Lifetime
- Field of Study
- Finance
- CPE Credits - NASBA
- 3.5
- Knowledge Level
- Basic
- Delivery Method
- QAS Self-Study (on-demand video lectures)
- Prerequisites
- Working knowledge of accounting from 1 year in accounting or finance, or a bachelor's degree in accounting or finance
- Advanced Prep
- None
Learning objectives
What you will be able to do
- Distinguish between profit and cash flow using a company's income statement, balance sheet and statement of cash flows.
- Define the structure of a 13-week direct-method cash forecast and the bank-based opening cash balance it starts from.
- Identify the sources and timing of weekly cash receipts from the AR aging, customer payment patterns and forecast sales.
- Identify the sources and timing of weekly cash disbursements for inventory, vendor payments, payroll and fixed obligations, including early-payment discounts.
- Apply a 13-week cash forecast to recognize the crunch week and plan line of credit draws and repayments around a minimum cash balance.
- Recognize key internal controls over cash and the weekly routine for updating and reviewing the forecast.
Inside the course
Curriculum
01Introduction & Course Info
What we're building, and a first look at the finished forecast.
- • Introduction: What We're Building
02The Basics
Meet the company, see where its cash went, and set up the forecast and its opening balance.
- • Lecture 1A: Meet Bean & Bag Roasters
- • Lecture 1B: Where Did the Cash Go?
- • Lecture 2: The 13-Week Cash Forecast
- • Lecture 3: Opening Cash and the Bank Rec
03Cash Receipts
Turn what customers owe, and what they will buy, into weekly collections.
- • Lecture 4: Collecting What's Already Owed
- • Lecture 5: Turning Holiday Sales into Cash
04Cash Spending
Forecast every dollar going out, from green coffee to payroll.
- • Lecture 6: Buying Inventory for the Holidays
- • Lecture 7: Paying Vendors and the 2/10 Net 30 Decision
- • Lecture 8: Payroll, Rent and Everything Else
05Using the Forecast to Run the Business
Find the crunch week, protect the cash and keep the forecast alive.
- • Lecture 9: Finding the Crunch Week
- • Lecture 10: Protecting the Cash
- • Lecture 11: Running the Forecast Every Week
- • Bonus: Rolling the Forecast Forward with Claude
Audience
Who this is for
Enrollment
How it works
- Step 1
Decide whether it is right for you
Review the curriculum, who it is for and the prerequisites.
- Step 2
Enroll
Enrollment opens November 18. Checkout is a one-time payment on Teachable.
- Step 3
Take the course
2 hours of on-demand lectures you watch at your own pace, with the Excel workbook to build the forecast alongside me and review questions after each module.
- Step 4
Earn your CPE
Pass the final assessment to download your certificate of completion with 3.5 CPE credits.
FAQ
Frequently asked questions
Enroll
Build a 13-Week Cash Forecast is coming soon
- Lifetime On-Demand Access
- Downloadable Excel Workbook
- Access To Instructor
- Certificate Of Completion
- 3.5 NASBA CPE Credits
- 14-day Money-back Guarantee
Checkout and course delivery are hosted on Teachable.
Good to know
CPE disclosure
CPE sponsor disclosure

Controller Academy LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website.
