Question: Learning Objectives 1. Create a pivot table in Excel 2. Add new calculated field to pivot table 3. Create a pivot chart with appropriate labels

Learning Objectives 1. Create a pivot table in Excel 2. Add new calculated field to pivot table 3. Create a pivot chart with appropriate labels 4. Apply appropriate numeric format on pivot table and chart 5. Analyze and interpret outcome of pivot tables and calculated fields Data Set Background In the previous Excel project, you analyzed the merits of investing of two companies operating in the discount retail industry. This time, you will This time, you will investigate two aspects of the relative desirability of investing in stock of those two companies, Circuit Discount TV and General Brands, Inc. To do so you will calculate the return on stockholders' equity and performance ratios to allow you to compare and contrast the two companies. The data set contains the elements of the financial statements of both companies for the five years 2019 through 2023. Requirements: 1. Create one pivot table to summarize the income from continuing operations, earnings per share (EPS), and dividends paid for the five-year period 2019 through 2023 on a separate worksheet. The data should be summarized by each company for all relevant years. Add a calculated field to calculate the dividend payout ratio for each company (carried

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!