![]() 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 |