Forecasting profit, loss and cash flow

By Dean Swanson
SCORE District Director

When I am working with a SCORE business CEO and also teaching SCORE classes, I stress the importance of “knowing your business numbers.” This is vital for a new or existing business because this process helps you predict the cost of your products or services, the amount of sales revenue, and the profit you can anticipate. If your business is not already off the ground, financial forecasting will explain/determine how much you’ll have to invest or borrow.

I started this discussion with one of three common techniques in last week’s column, the Break-Even Analysis. Now, I will discuss the other two.

 

The Profit and Loss (P&L) Forecast

This is really the next step after the Break-Even Analysis. This is where you refine the sales and expense estimates you used for your break-even analysis, into a formal, month-by-month projection of your business’s profit for one or two years of operation. It’s basically a spreadsheet that details your expected expenses and revenue on a month-by-month basis. For example, you plug in estimates of monthly revenue and of expenses like phone service, depreciation, shipping and other expenses. I happen to be a strong advocate of forecasting dollars for all line items but also including the percentage each one is of the Gross Sales/Revenue line, which is always 100. It is a very good management tool as it allows for a quick assessment of the relationship between your “forecast numbers” to your “actual results” when reviewing any P&L statement. Percentages keep one focused whereas fluctuation of dollar numbers can lead to misleading and confusing conclusions.

 

Cash Flow Projection

This forecast focuses on day-to-day operations and tries to help you predict whether you can survive those in-between times when you must pay bills but there is no revenue. For example, the cash flow for the first few months of a business is often negative. In order to survive, you may need to borrow money during that period. Cash flow projections are useful for every business, but they’re particularly helpful if you have not yet opened.

To make your cash flow projection you’ll have to prepare a spending plan, setting out items your business needs to buy and expenses you will need to pay. You then feed these numbers, along with information from your profit and loss forecast, into a spreadsheet. You’ll need to determine and add in details such as whether you will be making credit sales and how much time is granted-for example, you grant 90 days to pay a bill (Net 90) on your invoices. That helps determine when you can expect payments.

Forecasting your business numbers is very helpful. Start with your break-even analysis, continue to the profit and loss forecast, and finish the process with your cash flow projection. Your local SCORE Mentors can help you access templates to use for this analysis. You may also want to ask them about a business planning tool that helps you do these forecasts as a part of the business plan and then has the option to import data from your business QuickBooks to update and compare your plan to your actual results.

SportsPlus

News

2024 Election Rundown

Mower County

Patricia Mueller retains District 23B seat

Mower County

Zielke wins special election to round out Green’s school board seat

Mower County

Incumbents hold seats for Mayor, City Council; Waller returns to council in Ward 2

Mower County

Glynn earns fourth term on County Board, Mueller a second term

News

Trump wins the White House in political comeback rooted in appeals to frustrated voters

Mower County

Technical issues causing delay in upload of Mower voter tallies

News

Democrat Amy Klobuchar of Minnesota wins 4th Senate term, defeating GOP ex-NBA player Royce White

News

AP Race Call: Republican Brad Finstad wins reelection to U.S. House in Minnesota’s 1st Congressional District

Mower County

Author to present winter legends and history at Austin Public Library

News

About 24 states say they’ll send National Guard troops to DC for vote certification and inauguration

News

An Israeli strike kills 20 in north Gaza, where Palestinians say they’ve had little food for weeks

News

Election Day voting unfolds generally smoothly with some scattered issues and delays reported

Mower County

City honors Legion, VFW Color Guard

Mower County

In Your Community: First three prizes claimed from Holiday Bing-Oh!

News

New North Shore livestream offers moment of Zen amid info overload

News

Public input sought on major powerline proposed for southwest Minnesota

News

Minneapolis musician Tyka Nelson, Prince’s sister and only full sibling, dies at 64

News

Federal Reserve is set to cut rates again while facing a hazy post-election outlook

News

Ruby slippers from ‘The Wizard of Oz’ are for sale nearly 2 decades after they were stolen

News

‘I thought it would be fun.’ 92-year-old election judge has served voters for 7 decades

Albert Lea

Albert Lea teacher living in Austin arrested for solicitation of a minor

Mower County

Reschedule bridge demo of Fourth Street NW to begin Friday

Education

Mock vote at Pacelli involves students in the process