Is this a positive for your investment in the company

Reference no: EM131368506

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 Chevron Corporation 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 2010 is on the far right side of the axis.

Reference no: EM131368506

Questions Cloud

What are similarities and differences between both companies : PHIL101-1701A-01: What are the similarities and differences between both companies regarding their corporate social responsibility efforts? What positive strides are both companies trying to make with their corporate social responsibility efforts?

Discuss the general principles of classifying microorganisms : Discuss the general principles of classifying microorganisms. Discuss the different environmental factors that influence microbial growth. What would be the basic profile of a microbe pathogenic to humans

It professional to support database reporting functionality : Suppose you have been hired as an IT professional to support database reporting functionality for a Human Resources system. Compose at least two aggregate function queries that can be useful for the executives of the organization to extract summa..

Write a paper showing your work in modern america : Write a paper showing your understanding of work in modern America. Included in this paper must be an analysis of positive and negative aspects of our relatively new service/knowledge based economy and our place in the global economy. You must als..

Is this a positive for your investment in the company : 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?

What was the purpose of the software : Select a failed software project and run a postmortem analysis on it. You may research one yourself. In your analysis, identify the following: What was the purpose of the software?

Michael porter five forces model : Video and article: What are 'Porter's 5 Forces'explains Michael Porter's five forces model. Video: The Five Competitive Forces That Shape Strategy- Michael Porter discusses his five forces model that is used to describe industry dynamics, which are..

Provide critical analysis of high speed rail in california : Provide critical analysis of High Speed Rail in California and policy intended to address it. Note that there is a California State High Speed Rail authority (www.hsr.ca.gov) which has the new Business Plan for viewing. Develop the topic into a f..

Topic paper based on the criteria provided below : Select from one of the three topics provided and write a topic paper based on the criteria provided below. Each student may select a topic of his or her own choosing, but the topic must be pre-approved by the course instructor. Each topic paper sh..

User Account

All Pages