On 1/1/xx, company a purchases 100% of company b for $100,000 cash. on 12/31/xx, company b realizes profit of $20,000 and pays dividends of $5,000. using the act470_mod01-option01.xlsx excel spreadsheet in the module 1 folder, you are to: prepare all required entries for company a associated with the above activities utilizing the equity method. determine the balance in company a’s investment account at the end of the year. highlight the 12/31/xx balance in yellow. submission requirements: clearly identify the requirements being addressed. show all calculations within the cells of an excel spreadsheet. this means that you must use formulas and links so that the thought process can be examined. populating a result, without showing the supporting calculation, will not be sufficient. make good use of comments to convey your thought process as well. no hard coding of solutions. submit a single ms excel file for grading. review the grading rubric following this assignment, to understand how you will be graded on this assignment. reach out to your instructor if you have questions about the assignment.