creating a segmented income statement using excel pool accessories inc has two 1571681

Creating a Segmented Income Statement Using Excel . Pool Accessories, Inc., has two divisions—Furniture and Supplies. The following segmented financial information is for the most recent fiscal year ended December 31.

Assume the tax rate is 30 percent.

Required:

a. Prepare an Excel spreadsheet similar to showing Pool Accessories’ segmented income statement and profit margin ratio for each division.