(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 B49 for total assets and D49 for total liabilities and stockholders' equity.) 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. 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. (Use cell references from the given information above to complete this question. All answers should be input and displayed as positive values.) 2. Use the information provided to complete the balance sheet. 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. (Use cell references from the given information above to complete this question. All answers should be input and displayed as positive values.) 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 B49 for total assets and D49 for total liabilities and stockholders' equity.)