Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Revenue Expenses Dividends Year 1 Year 2 Year 3 Year 4 $18,200 8,200 48,200 93,200 $ 6,600 $ 2,900 11,600 0 26,600 5,800 41,600 10,800 Required: 1. Complete the table below based on your spreadsheet results: (Negative amount should be indicated by a minus sign.) Year Net Income Retained Earnings 1 2 3 4 2. Assume revenues increase 20% in both Years 1 and 4, what would the revised balances be? (Negative amount should be indicated by a minus sign.) Year Net Income 1 2 3 4 Retained Earnings