Please do the problem on a computer like Excel sheet

OK 1 Add text 1 V Draw A Read aloud Page view P5-9 (Appendix) Northern Lights Corporation supplies you with the following information applicable to the current year, December 31, 2019. $ 3,000 Transportation-in 2,000 Delivery expense Sales 100,000 Merchandise inventory (Jan. 1) 12,000 Merchandise inventory (Dec. 31) 15,000 Purchases 70,000 Office supplies expense 7,000 Purchase discounts 4,000 Purchase returns and allowances 6,000 Sales returns and allowances 10,000 Unused supplies 5,000 Required: 1. Prepare in proper form a classified, partial income statement including sales, cost of goods sold, and gross profit. 2. Prepare closing entries. 3. What is net income for the year