Skip to content
Playback Speed:
Transcript

In this extension, you will complete a cash flow projection for your first year in business.

A “cash flow projection” predicts when, how, and how much money will come in and out of your business.

Predicting when your business has cash on hand helps you plan how to run your business.

If you have positive cash flow, you can hire more employees or invest in additional assets.

If you have negative cash flow, you’ll need to strategize a way to solve the problem.

To make your projection, you will: Estimate cash coming into your business, Estimate cash paid out of your business, And determine your cash flow for a year.

To begin, make a copy of the “12-Month Cash Flow Spreadsheet” and rename it.

Then, read the “notes on preparation.”

Next, add your business name and the date when you want to begin your forecast.

Add the pre-startup cash that your business has on hand before opening.

Listing this information begins a running total of how much cash your business has before paying expenses.

Next, in the “cash receipts” table, add each potential source of cash flow, such as cash sales, collections from credit accounts, and loans and other cash injections.

Then add expected cash coming in to your business for your first month.

Specify for each source.

Total cash available and total cash receipts are automatically calculated.

Select, hold, and drag the value that you added for each category across the row to copy it for each month.

This gives you numbers to start working with.

You can update them later.

Monthly “cash on hand” and “cash receipts” are automatically calculated and added together to find “total cash available before cash out.”

This is how much cash your business has before paying expenses.

Total item estimates for the year are calculated at the end of the table.

Next, repeat the previous steps to list cash paid out by your business.

Begin with your pre-startup costs.

Find these in the “Startup Expenses and Capital Worksheet” that you completed in the main lesson.

The spreadsheet automatically calculates your subtotal.

List estimated expenses for your first month... ...and drag each amount across the table to estimate each additional month.

Then go back and update any one-time monthly expenses.

The spreadsheet automatically calculates subtotal and total cash paid out.

Total cash paid out is then automatically added to your total cash available to calculate your cash on hand.

If you’d like, fill out the non-cash flow information, known as “essential operating data” below.

Then, add a link to your worksheet in your business plan.

Great work, you now have a rough first-year cash flow statement.

Use it to make changes to your business strategy, such as applying for additional loans or planning to scale back your hiring at moments of low cash flow.

Now, it’s your turn: Make a copy of the “cash flow projection spreadsheet” and rename it, Estimate cash coming in to your business, Estimate cash paid out of your business, Review your cash flow totals, And link to your spreadsheet in your business plan.

Choose an Extension
Complete Your Opening Day Balance Sheet
Complete an Opening Day Balance Sheet to estimate your business’s financial positioning when you open.
Complete Your Personal Financial Statement
List financial assets to prepare for loan applications. Prepare financial details to meet with lenders and investors.
Estimate Cash Flow for Your Business
Project your business’s first-year cash flow. Use cash flow information to strategize your business.
Add a Projected Balance Sheet to Your Financial Plan
Project a balance sheet for your business. Determine what additional resources your business needs to succeed.
Complete a Breakeven Analysis
Determine when your business will break even. Analyze variable and fixed costs.
Write a Use of Capital Statement in Your Financial Plan
Explain to lenders and investors how additional funding will benefit your business. Show how you will use a loan or investment to grow your business.
See more extensions
Next Lessons Dashboard
Instructions
Choose one or more of the extensions to continue estimating financing for your business plan.
Shared work attachment
URL not accepted. Please paste a link to a Scratch project. URL not accepted. Please paste a link from google.com (such as a Google Doc). You don't appear to be signed in. Please refresh the page and try again. Something went wrong. Please refresh the page and try again.

This project will be shared with your teachers

Students can submit their work on this page. View their submitted work on the student progress page of My Classes.

Students can submit their work on this page.

Students: sign in to submit your work.
Teachers: sign in to view submitted work.