Revise the given year end information in your spreadsheet with the following values, and then answer the questions below: Dividends $ 2,700 Year 1 Year 2 Year 3 Year 4 Revenue $17,800 7,800 47,800 92,800 Expenses $ 6,480 11,400 26,400 41,400 5,700 10,700 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 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 Retained Earnings 2 3 4