A company provides the following account balances at year end (except for Retained Earnings, which is the beginning balance). The CFO has asked you to use this information to prepare an income statement and balance sheet. Required: 1. Use the information provided to complete the income statement. 2. Use the information provided to complete the balance sheet. 3. Use a conditional statement to evaluate whether the accounting equation balances. A company provides the following account balances at year end (except for Retained Earnings, which is the beginning balance). The CFO has asked you to use this information to prepare an income statement and balance sheet. (Use cell references from the given information above to complete this question. All answers should be input and displayed as positive values.) (Use cell references from the given information above to complete this question. Hint: Ending Retained Earnings = Beginning Retained Earnings + Net Income - Dividends.) 3. Use a conditional statement to evaluate whether the accounting equation balances. (Construct a conditional IF statement to return the word "equal" if the balance sheet is in balance or "not equal" if it is not. In your formula, use cell D54 for total assets and G54 for total liabilities and stockholders' equity.)