The following data for the current year ended June 30 were extracted from the accounting records of Excel Co.:
Cost of merchandise sold $195,000
Operating expenses $65,000
sales $548,000
Prepare a multiple-step income statement for the year ended June 30, 2011.