Mercedes, Company has the following quarterly financial information.
4th Quarter 3rd Quarter 2nd Quarter 1st Quarter
Sales Revenue $ 919,800 $ 929,300 $ 927,600 $ 935,400
Cost of Goods Sold 305,400 318,000 317,600 322,800
Operating Expenses 248,600 260,000 258,200 262,300
Interest Expense 4,050 4,050 4,050 3,950
Income Tax Expense 85,200 88,100 88,100 90,600
Average Number of Common Shares Outstanding 797,530 792,564 794,170 807,500
Stock price when Q4 EPS released $ 24
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.
Required A Required B Required C Required D
Calculate the net profit margin for each quarter.
Note: Do not round intermediate calculations. Round your final answers to 2 decimal places.
Net Profit Margin Q4 Q3 Q2 Q1
30.10 % 27.90 % 28.00 % 27.30 %