Part 1 A company provides the following information related to earnings and dividends for its first four years of operations. Required: Calculate the Retained Earnings balance at the end of each year. Part 2 Suppose instead that the company provided the following information, which reflects a 20% increase in revenues in Years 14. Required: Calculate net income and the ending balance of Retained Earnings in this alternative scenario. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 2 Required: 3 Calculate the Retained Earnings balance at the end of each year. 14 (Use cells A4 to C10 from the given information above to complete this question.) Suppose instead that the company provided the following information, which reflects a 20% increase in revenues in Years 1-4. Required: Calculate net income and the ending balance of Retained Earnings in this alternative scenario. (Use cells A25 to D31 from the given information above to complete this question.)