Download this financial projections Excel template to calculate your startup expenses, payroll costs, sales forecast, cash flow, income statement, balance sheet, break-even analysis, financial ratios, cost of goods sold, amortization and depreciation for your small business.
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.
The 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!