Balance sheet items such as accounts receivable, inventory, accounts payable, and retained earnings will be manually input, while items such as cash, property and equipment, and long-term debt will be linked to other parts of this financial projection template. This balance sheet worksheet consists of two main sections: balance sheet and supporting schedules. The income statements for the current year and forecast period are built up by linking to values in the sales worksheets and operating expenses worksheets. In the operating expenses (forecast) worksheet, the operating expenses forecast for the next few years will be calculated using the assumptions for each of the expense items. These will help build up the forecast for operating expenses and the income statement. The operating expenses (current year) worksheet is for you to enter the actual operating expenses for the current year. In the sales (current year) worksheet, assumptions on sales growth rate are entered for the forecast period to generate the predicted revenue, COGS, and gross margin for the following years. You’ll be able to quickly understand the sales and margin for each product for the current year. The model will automatically calculate the monthly revenue, COGS, and gross margin for each product line, which are linked to the summary tables at the top of the worksheet. In the sales (current year) worksheet, you’ll input the per-unit sales price, the number of units sold, and the per-unit cost of goods sold for each product line under the “sales breakdown” section. You’ll also be able to estimate the total amount of taxes, employee insurance, and pension expenses for each of the years. Once the assumptions are filled in, the pre-entered formulas will generate the payroll forecast for the rest of the period and calculate average hourly wages by staff type. These are the only manual inputs required for the model. In the payroll ( forecast) worksheet, you will put your own assumptions for the growth rate of the number of workers for the period of forecast. These individual monthly payrolls then roll up to the summary tables, which automatically calculate the average hourly wage and net pay for each month (all expenses except bonuses) by staff type. The model helps you break down the salary, taxes, employee insurance, pension, and employee bonus expenses so you can easily track the total amount for each of the items. In the payroll (current year) worksheet, you will input the payroll expenses for each of the full-time employees, part-time employees, and contractors. This financial projection template contains the following sections: #1 Payroll (current year) Components of a financial projection template
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |