| |
|
|
|
|
|
|
|
|
|
|
|
|
| |
Instructions: From your
marketing plan enter your projected sales for the next 12 months in step
1; Existing firms should enter historical sales data from the 3 months
immediately prior to this planning period (Step 1a); In
Step 2 you are asked to estimate when those sales will occur. If you have
historical data, take each month of the preceding year and divide it by
that period's sale and enter the % for that month. New
firms should give a "best guess" estimate based on the entrepreneur's
understanding of the market. In Step 3, estimate your
cost of goods sold by using the basic formula shown next to the COGS box -
divide the COGS by sales for the period and enter the %;
In Step 4 calculate or estimate your operating costs and divide by
sales for the period. Next, enter the actual values for
depreciation, interest expense and cash on hand.
Yellow areas are for user input on both
sheets. |
|
|
| |
When you are finished, click on the projections
tab at the top of this sheet to go to the cash flow schedule. |
|
|
| |
|
| |
|
Sales from 3 months ending prior period |
|
| |
Enter Your Assumptions Here |
|
| |
|
|
|
|
|
|
|
| Step 1 |
Project Total Sales for Year |
|
Step 1a |
|
|
|
|
|
|
| |
|
| Step 2 |
Project months by % |
|
| |
Monthly % |
|
| |
Jan |
|
|
| |
Feb |
|
|
| |
March |
|
|
| |
April |
|
|
| |
May |
|
|
| |
June |
|
|
| |
July |
|
|
| |
August |
|
|
| |
September |
|
|
| |
October |
|
|
| |
November |
|
|
| |
December |
|
|
| |
Total Sales - must equal 100% |
|
|
| |
|
Goods Available for Sale
= Beginning inventory +
Freight in + purchases |
| Step 3 |
Project Cost of Goods Sold by % |
|
|
Cost of Goods Sold = Goods Available for Sale -
Ending inventory |
|
| |
|
| Step 4 |
Project General Operating Cost %* |
|
|
| |
*Include all payroll, benefits, selling,
occupancy, and G&A costs. |
|
| |
|
| Step 5 |
Project Total Depreciation for year $ |
|
|
| |
|
| Step 6 |
Project Total Interest for year $ |
|
|
| |
|
| Step 7 |
Project Beginning Cash $ |
|
|
| |
|
| |
|
|
| |
|
| Step 9 |
Go to projection page and put in your own
assumptions for A/R Collection (Line 20) |
|
| |
and Accounts Payable
(Line 24 & 25) in cash budget area. |
|
| |
Put in projected capital purchases in Line 27.
|
|
| |
Put in projected principal and interest payment
in Line 28 |
|
| |
Review ending cash and put in draw down or pay
off on Line of Credit (Line 32). |
|
| |
|
| Step 10 |
Review Graph on Worksheet 3 |
|
