Question: In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data

In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for 3M Co. below:

a. Calculate the net profit margin for each year.
b. Calculate the average annual growth rates for revenue and net income using the GEOMEAN function. Is net income growing more slowly or faster than total revenue? Is this a positive for your investment in the company?
c. Calculate the average annual growth rate of total revenue using the AVERAGE function. Is this result more or less accurate than your result in the previous question? Why?
d. Create a Column chart of total revenue and net income. Be sure to change the chart so that the x-axis labels contain the year numbers, and format the axis so that 2013 is on the far right side of the axis.

Fiscal Year 2013 2012 2011 2010 2009 Total Revenue 30,871 29,90429,611 26,66223,123 Net Income 4,6594,444 4,283 4,085 3,193

Step by Step Solution

★★★★★

3.38 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style0 msonumberformatGeneral textaligngeneral vertical... View full answer

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

624-B-A-F-A (2172).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!

In your position as general manager for United Fitness Center, you have been asked to survey the customers of your location to determine whether they want to convert the racquetball courts to an...

1. Calculate the net profit margin for each year. 2. Calculate the average annual growth rates for revenue and net income using the GEOMEAN function. 3. Calculate the average annual growth rate of...

In your position as controller of Tallman Inc., you are responsible for keeping the board of directors informed about the financial activities and status of the company. At the board meeting, you...

3. Repeat Problem 2 using the data below for Kroger Co (NYSE: KR), However, this time you should create a copy of your worksheet to use as a template. Replace the data for Electronic Arts with that...

Please show steps and formulas. 2. In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for...

In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for Electronic Arts, Inc.In your position as...

Please show in excel with formulas In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for 3M Co....

2011 In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for 3M Co. below: Fiscal Year 2013 2012...

Only answer problem3(a) and (b), thanks 2. In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for...

In your position as research assistant to a portfolio manager, you need to analyze the profitability of the companies in the portfolio. Using the data for Oracle Corporation (NASDAQ: ORCL) below:...

What two bodies have authority to set accounting standards in the United States?

For a population of N = 902, verify that by starting in row 05, column 01 of the table of random numbers (Table E. 1), you need only six rows to select a sample of N = 60 without replacement. Random...

A discretionary bonus a . is a bonus, not agreed upon, announced, or promised before payment. b . is an earned bonus. c . is included in the employee's regular rate of pay for overtime purposes. d ....

Owners claims to the company's resources are referred to as: A) Stockholders' equity. B) Revenues. C) Assets. D) Liabilities.

Using the data for Paychex, Inc. (Nasdaq: PAYX), presented below: a. Calculate the ratio of each years' data to the previous year for each of the above items for Paychex, Inc. For example, for the...

Lakewood Laser SkinCare's ending cash balance as of January 31, 2012 (the end of its fiscal year 2011) was $10,000. Its expected cash collections and payments for the next six months are given in the...

Loblaw Manufacturing has asked you to create a cash budget in order to determine its borrowing needs for the June to October period. You have gathered the following information....

C++ Program Fix the errors II main.cpp les 118 SelectionSort (arr, n): 119 break: 120 121 case 3:( 122 123 cout:: const iterator ptr-numerical_comparisions.begin (): ptr!-numerical_comparisions.end...

Define the expected rate of return to bondholders.

The Ajax Corporation has an overhead crane that has an estimated remaining life of 10 years. The crane can be sold now for $8,000. If the crane is kept in service, it must be overhauled immediately...