Skip to content

Course

Build a 13-Week Cash Forecast

Build the cash forecast CFOs rely on, step by step in Excel, using a real manufacturing company.

4.9/5 ReviewsRated 4.9 out of 5 by students

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
3.5 CPE credits
$249
Coming November 18
  • 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

  1. 01Introduction & Course Info

    What we're building, and a first look at the finished forecast.

    • • Introduction: What We're Building
  2. 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
  3. 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
  4. 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
  5. 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

Staff and senior accountants who want the cash skills controllers and CFOs are expected to have
Accounting and finance graduates with a year of experience or a degree who want a practical, job-ready skill
Bookkeepers and fractional CFOs who want to offer cash forecasting to their clients
Business owners who want to see their cash crunch coming weeks before it hits
Career switchers moving into corporate finance or FP&A

Enrollment

How it works

  1. Step 1

    Decide whether it is right for you

    Review the curriculum, who it is for and the prerequisites.

  2. Step 2

    Enroll

    Enrollment opens November 18. Checkout is a one-time payment on Teachable.

  3. 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.

  4. 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

$249
Coming November 18
  • 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

NASBA National Registry of CPE Sponsors

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.