Financial Projection Model-Excel
An Excel Workbook of 21 Worksheets that develops a three year financial plan or financial projection example. Produces balance sheet, sample profit and loss and cash flow statements template. It will help you make those Go/No Go decisions. User provides source data in first six worksheets and the program generates the balance of the projection. Directions are available in two ways: Blue boxes on a specific page, or, comments within a specific cell. Formulas in this workbook are locked but can be unlocked with the code "1234", but, be careful to save a copy if you change a formula.
This is a powerful tool in Microsoft Excel. A user should have some knowledge of Excel and accounting or have some help to maximize the use of this Workbook. The first six worksheets are required to populate worksheets 7-21 with results. These six are: 1) Startup Funds Needed, 2) Salaries and Wages, 3) Fixed Operating Expenses, 4 & 5) Projected Sales and Cost of Goods Sold for four (4) products/services, and 6) Cash Receipts parameters.
Some special Worksheets in the results 7-21, are #18 - Financial Ratios, #19 - Break Even Analysis, #20 - Loan Amortization calculations, and #21 - a PC driven Diagnostics of the results.
The workbook is downloaded to the users computer after registering with SCORE.