← Back to Curriculum

Foundation

Practice Drills: Building a Simple Cash Flow Forecast

A hands-on drill course for startup founders, treasury teams, HR and L&D professionals, and employees outside finance who need to know where the company's cash will be next month. You take one illustrative small Indian business and build its 13-week cash flow forecast from scratch in Google Sheets or Excel: turn open invoices into expected receipts, schedule supplier payments with the MSME 45-day rule in mind, place payroll, PF, ESI, GST, TDS and advance tax on the calendar, roll the balance week by week, find the shortfall week, stress test it, close the gap, and keep the forecast alive with a weekly forecast-versus-actual review.

Cash Flow Forecasting13-Week Cash ForecastWorking CapitalStatutory Payment CalendarForecast vs Actual Review

MODULES

5

DURATION

~3.5 hrs

TRACK

Corporate Finance

What You'll Master

How to set up a clean 13-week cash forecast template with a direct receipts-and-payments layout

How to turn open invoices and the sales pipeline into week-by-week expected receipts using real customer payment behaviour

How to schedule supplier payments, payroll, PF, ESI, rent, EMIs and one-off payments into the right weeks

How to place GST, TDS and advance tax due dates on the forecast so tax outflows never surprise you

How to roll opening and closing balances, set a minimum cash buffer and spot the shortfall week early

How to stress test the forecast for late customers or a lost order and plan the fix before the gap arrives

How to run a weekly forecast-versus-actual review and present the forecast on one page to a founder or CFO

Access Level

LEARNER

Start Learning Now →Sign in to resume

Everything included

Full Text Playbooks

Actionable Exercises

Mobile Reading Mode

Lifetime Updates

Curriculum Breakdown

Chapter 1: Setting Up the Drill

3 Lessons

The Drill Brief: Thirteen Weeks of Cash for a Small Indian Business10 min read

Gathering the Inputs: Bank Balance, Open Invoices and Bills Due12 min read

Laying Out the 13-Week Forecast Template in a Spreadsheet14 min read

Chapter 2: Drill 1, Forecasting Cash Inflows

3 Lessons

Turning Open Invoices Into Expected Receipts14 min read

Forecasting Collections From New Sales13 min read

Adding Other Inflows: Loan Drawdowns, Refunds and Owner Capital10 min read

Chapter 3: Drill 2, Forecasting Cash Outflows

4 Lessons

Scheduling Supplier Payments and the MSME 45-Day Rule13 min read

Payroll, PF, ESI and Rent: The Fixed Outflows12 min read

Placing GST, TDS and Advance Tax on the Forecast Calendar14 min read

Loan EMIs, Capex and One-Off Payments10 min read

Chapter 4: Drill 3, Closing and Testing the Forecast

3 Lessons

Rolling the Opening and Closing Balance Week by Week12 min read

Setting a Minimum Cash Buffer and Finding the Shortfall Week12 min read

Stress Testing the Forecast: Late Customers and a Lost Order14 min read

Chapter 5: Drill 4, Using and Maintaining the Forecast

3 Lessons

Closing the Gap: Collections, Payment Timing and Short-Term Credit13 min read

Forecast vs Actual: Rolling the Forecast Forward Every Week12 min read

Presenting the Forecast on One Page to a Founder or CFO12 min read