50.1K

Verified Solution

Link Copied!

Kroger Co. (KR) (in millions)
Year	2020
Total Revenue	122,286
Net Income	1,640
	Q4
Net Profit Margin	0.013411
	Q5
Annual Growth Rate of Total Revenue (Change in Total Revenue)
	Q6
CAGR for Total Revenue (FORMULA)
	Q7
CAGR for Total Revenue (GEOMEAN)
	Q8
Simple Average of the Annual Growth Rate of Total Revenue (AVERAGE)

Q4. Calculate the net profit margin for each year in Excel worksheet. Format the net profit margin as percentages with TWO decimal places. What is the net profit margin for 2020?

Q5. Calculate the annual growth rate of total revenue for each year in Excel worksheet. Format the annual growth rate of total revenue with FOUR decimal places. What is the annual growth rate of total revenue for 2020?

Q6. Using CAGR FORMULA below, calculate the compound average annual growth rates (CAGR) for total revenue as percentages with TWO decimal places.

Q7. Using the GEOMEAN function, calculate the compound average annual growth rates (CAGR) for total revenue as percentages with TWO decimal places. Be sure to subtract 1 from the result to arrive at a percent change.

Q8. Using the AVERAGE function, calculate simple average of the annual growth rate of total revenue as percentages with TWO decimal places. Be sure to subtract 1 from the result to arrive at a percent change.

Answer & Explanation Solved by verified expert

See Answer