You have been asked to develop a worksheet for Global Steel to show its annual growth for the next five years based on the prior year’s sales and growth data
business
Description
You have been asked to develop a worksheet for Global
Steel to show its annual growth for the next five years based on the prior
year’s sales and growth data. Include an embedded 3-D Pie chart that shows the
contribution of each year’ gross margin to the total gross margin. Table 1 in
the following shows the data and general layout of the worksheet, with
assumptions. Table 2 provides the formulas to be used. Design and format the
worksheet and enter the formulas shown in Table 2 with proper cell references.
The values in the Total column should be calculated using the SUM function.
Table
1 Global Steel Sales Data with Assumptions
Sales for Year 0 (Prior Year’s Sales for Year 1) 26300000
Annual Growth Rate 2.250%
Annual Cost Rate 41.25%
Table
2 Global Steel Sales Projection Formulas
|
Formula A: Sales =
Prior Year’s Sales * (1 + Annual Growth Rate) |
|
Formula B: Cost
of Goods = Sales * Annual Cost Rate |
|
Formula C: Gross
Margin = Sales – Cost of Goods |
Instruction Files
20210222132445.pdf
154.0 KB
