Financial Projections Template

Download this financial projections Excel template to calculate your startup expenses, payroll costs, sales forecast, cash flow, income statement, balance sheet, breakeven analysis, financial ratios, cost of goods sold, amortization and depreciation for your small business.

Financial Projections Template

This Microsoft Excel Workbook is designed to provide those starting a business or already running a business with information that will allow them to make a "go /no-go" decision. It will help a potential entrepreneur project operating profit, develop a projected income statement, balance sheet and  cash flow forecast.
It is designed for a wide variety of users, from those who have little or no accounting or Excel experience to those who may be well versed in finance, accounting and the use of Microsoft Excel.

The workbook contains a number of worksheets, each documented two ways. Extensive directions and guidance for a particular page or on a specific accounting topic are found in blue boxes (like this one) on pages that are not self-explanatory.

WebinarThe second way this workbook is documented is using Excel comments in a given cell. Comments are normally hidden from sight. If you see a red triangle in the upper right corner of a cell, you can hover your mouse over the triangle to see the note. As your mouse moves away from the triangle, the comment will disappear. 

Comments will have a beige background. Each comment may have a specific direction for that cell, may be a reminder of something the author believes important, or may have some additional information about the accounting topic. The cells and formulas in this workbook are protected. Cells with yellow  or light blue backgrounds are designed for user input. All other cells are designed to generate data based on user input. 

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. 

For assistance in completing this template, we recommend downloading the Financial Projections Template Guide in English or Espanol. You can also see a completed sample by downloading the Ann's Nursery Example.

Have a question about this financial projections template or need help figuring out what the numbers mean? Connect with a SCORE mentor online or in your community today!

Sign up for SCORE Newsletters to get new and exclusive resources like this delivered to your inbox.