Create a Cash Flow Projection With a 12-Month Template
Learn how to create a projection with a basic template for Excel/Google Sheets. I show you step-by-step.
Updated on Oct, 2023
Language - English
Duration -1 hours
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.
What will you learn in this course:
- Use a template supplied in this course to create a cash flow projection.
What are the prerequisites for this course?
Check out the detailed breakdown of what’s inside the course
Understanding Cash Flow Statements and Projections
- Overview and the Importance of Cash 05:50 05:50
- PDF of Slides
- How Historical Cash Flow Statements Help You Understand Your Cash Flow 04:03 04:03
- Benefits of a Cash Flow Projection 05:52 05:52
- Cash Flow Projection Template
- Ways to Project Numbers 07:47 07:47
Rob StephensFounder of CFO Perspective
Rob Stephens is the Founder of CFO Perspective, where he provides financial consulting and education to small businesses. Rob has a 20-year career that includes serving as CFO for two banks and a health clinic system. He was also Director of Operations at a $4 Billion bank and SVP of Finance of a $2 Billion credit union, where he was Program Manager of an investment advisory group with $170 Million in assets under management. Rob is an adjunct instructor at Gonzaga University.
Rob holds a Masters of Science in Personal Financial Planning and a Graduate Certificate in Financial Therapy from Kansas State University. He received a B.A. in Business Administration from the University of Washington and is a CPA.
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now