Using your spreadsheet from Part 1, assume the following information and change your spreadsheet setup/formulas as needed to solve for the missing values. (Remember, only use cell referencing and formulas). Relationship #1 Relationship #2 Revenues ? Beginning Retained Earnings Expenses Net Income 35,000 85,000 Net Income Dividends Ending Retained Earnings Required: 1. Complete the table below based on your results: Revenues $ 120,000 Beginning Retained Earnings 69,000 Net Income (Relationship #2) 85,000 Liabilities 64,000 Retained Earnings (Relationship #3) 134,000 Relationship #3 ? Assets ? Liabilities 20,000 Common Stock 134,000 Retained Earnings 240,000 ? 42,000 ? Required information O =J15-J16-J17 O=G15+G16-G17 O=G18-G15+G17 3. Assume the Net Income was actually a Net Loss of $20,000, Expense were $68,000, Beginning Retained Earnings was $90,000, and Ending Retained Earnings was unknown. Which of the following amounts will change? O Ending Retained Earnings only O Revenues and Common Stock Ending Retained Earnings and Common Stock Ending Retained Earnings and Revenue 4. What is the revised ending balance in Retained Earnings? O $50,000 $58,000 O $68,000 $57,000