Calculate the net profit margin for each year

Reference no: EM131365119

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: EM131365119

Questions Cloud

Do the same dynamic factors at the federal level occur : HLS420- You know that the environment in which current homeland security strategic planning is occurring is dynamic. Do the same dynamic factors at the federal level occur at the state levels of government? Explain.

Examine the key individual and organizational factors : Examine the key individual and organizational factors that influence an ethical decision making framework in resolving ethical dilemmas. Outline a guide that HR can use to implement principles and core values in ethical decision making in an organ..

Swimming pool look shallower from the outside : Why is it that when you look at a coin in a fountain or cup of water, its position is not exactly what it appears from the top? Or, why does the water in a swimming pool look shallower from the outside than when you step in?

Discuss three commonalities between stocks and bonds : Discuss three commonalities between stocks and bonds. Discuss three differences. If you were a business owner, would you prefer to issue stocks or bonds to raise money

Calculate the net profit margin for each year : 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?

What factors account for the rise of managed care : HE320: Is it ethical for the federal government to pay the costs of kidney dialysis for all patients, regardless of age or income, as it now does, but not to pay the costs of other illnesses? Which would be more reasonable and more feasible: exten..

Discuss organizational interventions to recommend : Discuss organizational interventions to recommend. Take into consideration your previous diagnosis and the emotional state of your employees from your interview

How old will you be when you arrive : Suppose you board a space ship when you are 20 years old and travel to a star located 43 light years from earth. If the ship travels at 0.993 c, how old will you be when you arrive?

Review the current nshs and assess the states role : HLS420-Review the current NSHS, and assess the states' role. In your opinion, does the NSHS place an unfair burden on states with respect to planning? Explain.

User Account

All Pages