

Financial projections use existing or estimated financial data to forecast your business’s future income and expenses. They often include different scenarios so you can see how changes to one aspect of your finances (such as higher sales or lower operating expenses) might affect your profitability.
Financial projections are an important business planning tool for several reasons.
This financial projections template pulls together several different financial documents, including:
You can either use this template to create the documents from scratch or pull in information from documents you’ve already created. The template also includes diagnostic tools you can use to test the numbers in your financial projections and make sure they are within reasonable ranges.
All of these areas are closely related, so as you work on your financial projections, you’ll find that changes to one element affect the others. You may want to include a best-case and worst-case scenario to account for all possibilities. Make sure you know the assumptions behind your financial projections and can explain them to others.
Startup business owners often wonder how to create financial projections for a business that doesn’t exist yet. Financial projections are always educated guesses. To make yours as accurate as possible, do your homework and get help. Use the information you unearthed in researching your business plans, such as statistics from industry associations, data from government sources, and financials from similar businesses. An accountant with experience in your industry can be useful in fine-tuning your financial projections. So can business advisors such as SCORE mentors.
Once you complete your financial projections, don’t put them away and forget about them. Compare your projections to your actual financial statements on a regular basis to see how well your business is meeting your expectations. If your projections turn out to be too optimistic or too pessimistic, make the necessary adjustments to make them more accurate.
*NOTE: The cells with formulas in this workbook are locked. If changes are needed, the unlock code is "1234." Please use caution when unlocking the spreadsheets. If you want to change a formula, we strongly recommend that you save a copy of this spreadsheet under a different name before doing so.
You can also see a completed sample by downloading the Ann's Nursery Example.
Do you need help creating your financial projections? Take SCORE’s online course on-demand on financial projections or connect with a SCORE mentor online or in your community today.
Copyright © 2023 SCORE Association, SCORE.org
Funded, in part, through a Cooperative Agreement with the U.S. Small Business Administration. All opinions, and/or recommendations expressed herein are those of the author(s) and do not necessarily reflect the views of the SBA.