Please complete on excel!

The following select account data is taken from the records of Brown lnc for 2019. Use this information to create an excel spreadsheet answering the following (show your work}: 1. Compute Net Sales for 2019 20 points possible 2. Prepare a simple income statement for the year ended December 2019 30 points possible 3. Compute the Gross Margin for 2019 20 points possible 4. Prepare a multi-step income statement for the year ended December 2019 40 points possible Points off for not following instructions, errors, formatting, etc. Sales $790,866 Merchandise Inventory 465,000 Accounts receivable 1 15,509 Office sup lies expense , 2.312 Rent reven e 42,900 Sales salaries expense 65,300 Accounts payable 158,234 Common stock 80,963 Marketing eXpense 25,450 Sales discounts , 62,750 Interest expense 5.444 Sales returns and allowances 1 00,043 Interest revenue 12,321 Cost of goods sold 295,840 Rent expense 12,678 Depreciation expense: ofce equipment 4,210 Insurance expense 2.000 Advertising expense 14.650 n (MM. .' a