Please help solve this problem in Excel and show the steps taken to obtain the proper answers for this question. Thank you.

Countywide Cable Services, Inc., is organized with three segments: Metro, Suburban, and Outlying. Data for these segments for the year just ended follow. In addition to the expenses listed above, the company has $95,000 of common fixed expenses. Income-tax expense for the year is $145,000. Required: 1. Prepare a segmented income statement for Countywide Cable Services, Inc