5-year forecast of Net Income
Not what you're looking for?
Prepare a 5-year forecast of Net Income using the data provided for the base year and the following anticipated annual changes;
* Annual growth in sales is forecasted at 12% per year
* Annual growth in operating expenses projected at 15% per year - EXCEPT for Salaries and wages which are forecast to grow at only 5%.
* Payroll taxes are forecast to be 18% of salaries
* Benefits are forecast to be 28% of salaries
You have been provided with the beginnings of a forecasting template - you will be required to complete the template using EXCEL formula, which can be based on those already entered. The formula should calculate annual forecasted amounts which will then feed into the calculation of the 5-year cumulative totals.
Purchase this Solution
Solution Summary
Solution explains of how to do a 5-year forecast of Net Income
Solution Preview
These are the steps:
1) First find out Sales for five years. Next year sales= Previous year sales*(1+growth)
2) In the ...
Purchase this Solution
Free BrainMass Quizzes
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking