Create A Cash Flow Projection

Learn how to create a projection with a basic template for Excel/Google Sheets. I show you step-by-step.

Last updated 2022-01-10 | 4.1

- Use a template supplied in this course to create a cash flow projection.

What you'll learn

Use a template supplied in this course to create a cash flow projection.

* Requirements

* None

Description

Lost profits due to poor financial management are common with small businesses.

  • More than half of U.S. businesses have lost $10,000 or more by foregoing a project or sales specifically due to issues created by insufficient cash flow. (Quickbooks study)

  • 82% of small businesses fail because of poor cash flow management skills or poor understanding of cash flow (U.S. Bank)

A cash flow projection is the most important tool to master your cash flow. It can help you:

  • Identify “cash leaks” that are draining your profits

  • Spot periods of low cash flow before they become a crisis

  • Know when you have the cash to capture opportunities

  • Plan your dividends and equity distribution

This course provides an easy template and shows you how to use it to reduce stressful cash flow surprises and position you to capture the next big opportunity. You’ll also receive:

  • A cash flow template for Microsoft Excel (can also be used in Google Sheets)

  • Step-by-step video instructions on how to use the template.

  • Video courses on the importance of cash flow, understanding your past cash flows, and the benefits of cash flow projections.

  • A document that explains different methods for projecting your cash flows.


Who this course is for:

  • Small business owners and managers who want to improve the plan for their financial future.

Course content

2 sections • 12 lectures

Overview and the Importance of Cash Preview 05:50

PDF of Slides Preview 00:08

How Historical Cash Flow Statements Help You Understand Your Cash Flow Preview 04:03

Benefits of a Cash Flow Projection Preview 05:52

Cash Flow Projection Template Preview 00:04

Ways to Project Numbers Preview 07:47

Landon's Landscape Supplies Documents Preview 00:09

Overview of the Projection Template Preview 08:39

Operational Cash Inflows Preview 08:11

Operational Cash Outflows Preview 13:36

Modeling Your Options Preview 11:27

Bonus Lecture Preview 02:01