Please show work in excel.

E4-15 (Comprehensive Income) Roxanne Carter Corporation reported the following for 2014: net sales $1,200,000; cost of goods sold $750,000; selling and administrative expenses $320,000; and an unrealized holding gain on available-for-sale securities $18,000. Instructions Prepare a statement of comprehensive income, using (a) the one statement format, and (b) the two statement format. (Ignore income taxes and earnings per share.)