Mercedes, Company has the following quarterly financial Information. Sales Revenue Cost of Goods Sold Operating Expenses...

  

Transcribed Image Text:

Mercedes, Company has the following quarterly financial Information. Sales Revenue Cost of Goods Sold Operating Expenses Interest Expense Income Tax Expense Average Number of Common Shares Outstanding Stock price when Q4 EPS released Required: a. Calculate the gross profit percentage for each quarter. b. Calculate the net profit margin for each quarter. c. Calculate the Earnings per share (EPS) for each quarter. d. Calculate the Price/Earnings ratio at the end of the year. Complete this question by entering your answers in the tabs below. Gross Profit Percentage Q4 % Required D 4th Quarter $ 901,800 304,500 247,700 Q3 Required A Required B Required C Calculate the gross profit percentage for each quarter. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) < Required A 3,600 84,300 793,030 $ 24.00 % 3rd Quarter $ 911,300 317,100 259,100 3,600 87,200 788,064 Q2 % Required B Q1 2nd Quarter $ 909,600 316,700 257,300 3,600 87,200 789,670 % 1st Quarter $ 917,400 321,900 261,400 3,500 89,700 803,000 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Calculate the net profit margin for each quarter. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Net Profit Margin Q4 % Q3 % Q2 % Q1 % Required A Required B Required C Required D Calculate the Earnings per share (EPS) for each quarter. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Earnings per share (EPS) Q4 Q3 Q2 < Required B Q1 Required D > Complete this question by entering your answers in the tabs below. Required A Required B Calculate the Price/Earnings ratio at the end of the year. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) P/E Ratio Required C Required D Mercedes, Company has the following quarterly financial Information. Sales Revenue Cost of Goods Sold Operating Expenses Interest Expense Income Tax Expense Average Number of Common Shares Outstanding Stock price when Q4 EPS released Required: a. Calculate the gross profit percentage for each quarter. b. Calculate the net profit margin for each quarter. c. Calculate the Earnings per share (EPS) for each quarter. d. Calculate the Price/Earnings ratio at the end of the year. Complete this question by entering your answers in the tabs below. Gross Profit Percentage Q4 % Required D 4th Quarter $ 901,800 304,500 247,700 Q3 Required A Required B Required C Calculate the gross profit percentage for each quarter. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) < Required A 3,600 84,300 793,030 $ 24.00 % 3rd Quarter $ 911,300 317,100 259,100 3,600 87,200 788,064 Q2 % Required B Q1 2nd Quarter $ 909,600 316,700 257,300 3,600 87,200 789,670 % 1st Quarter $ 917,400 321,900 261,400 3,500 89,700 803,000 Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Calculate the net profit margin for each quarter. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Net Profit Margin Q4 % Q3 % Q2 % Q1 % Required A Required B Required C Required D Calculate the Earnings per share (EPS) for each quarter. (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Earnings per share (EPS) Q4 Q3 Q2 < Required B Q1 Required D > Complete this question by entering your answers in the tabs below. Required A Required B Calculate the Price/Earnings ratio at the end of the year. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) P/E Ratio Required C Required D