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

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

Looking for a similar assignment? Our writers will offer you original work free from plagiarism. We follow the assignment instructions to the letter and always deliver on time. Be assured of a quality paper that will raise your grade. Order now and Get a 15% Discount! Use Coupon Code "Newclient"