Prepare the problem below using Excel. Upload the workbook using the link. 1. (32 points) The adjusted trial balance of Blackwell Financial Planners appears below. Using the information from the adjusted trial balance, prepare the following in good form for the month ending December 31: a. an income statement. b. a retained earnings statement. c. a balance sheet. Cash Accounts Receivable Supplies Equipment $3,860 2,360 1,940 15,000 Accumulated Depreciation-Equipment $3,700 Accounts Payable Unearned Service Revenue Common Stock Retained Earnings 2,420 4,520 10,460 4,895 Dividends Service Revenue 2,160 4,100 Supplies Expense 560 Bad Debts Expense 70 Allowance for Doubtful Accounts 175 Depreciation Expense 1,440 Prepaid Rent 2,880 $30,270 $30,270