Please read the instructions and complete the task using excel/table format.

I will give you like and rating if you properly complete the task.

Thanks! :)

INSTRUCTIONS: 1. Please read the case carefully and answer all the questions required. Include a cover page with relevant information and a bibliography if applicable. 2. When using excel ensure to import into the case as required. 3. Round to two (2) decimals as required. Additional Data: 1. Cash Dividends of $10,000 were declared and paid. 2. Net Income for 2023 was $75,000. 3. Depreciation expense of $25,000 4. Long-term investments had a value of $45,000 and were sold for cash for a gain of $10,000. Additional long-term imvestments of $35,000 were Purchased for cash. 5. Principal payment of $47,000 on long term debt 6. Shares sold for $50,000 cash. 7. Equipment with a cost of $25,000 and accumulated depreciation of $23,000 was sold for $14,000 cash. New Equipment was purchased for $35,000 cash. Fyhihit 1 Exhibit 2 Uafu he. Statement of Earnings May 31, 2023 2023 2022 2021 Revernue Cost of Goods Sold Gross Margin Experses: Other Expenses Net hoome $950,000800,000$350,000 $275,000 $75,000 $206,400 $44,600 $43,000