I need help given the information. Like how do I do the multi step income statement, and statement of retained earnings??? I go the text pages online and they are given more information. I think i have to calculate net sales etc.. from this.

Phase

Using Be Prepared, Inc.s adjusted trial balance and prior periods balance sheet (see pages 5 and 6 of this document), prepare the following Financial Reports in good form using Microsoft Excel:

Multi-Step Income Statement for the month of January 2019 (see page 210 in your textbook for guidance).

Statement of Retained Earnings for the month of January 2019 (see page 562 in your textbook for guidance). Note: There are no prior period adjustments and all dividends declared are cash dividends in the amount of $31,060.

Be Prepared Inc. Balance Sheet December 31, 2018 Assets Liabilities Aasbunts Receivable 20,600 Aetgble 50,000 Mortgage Payable 23,600 200,000 232,500 Office Supplies Prepaid Insurance Land Building Accumulated Depreciation, Building Office Equipment 1,500 Total Liabilities 3,000 64.250 400,000 Stockholder's Equity (45,000 Preferred Stock 90,000 Common Stock (15,000) Paid in Capital in Excess of par: Preferred 75,000 Paid in Capital in Excess of par: Common (15,000) Retained Earnings 70,000 Total Stockholder's Equity 250,000 100,000 7,500 71,250 85,000 513,750 746,250 Store Equipment Store Equipment Patents Total Assets 746,250 Total Liabilities and Stockholder's Equity Be Prepared Inc. Balance Sheet December 31, 2018 Assets Liabilities Aasbunts Receivable 20,600 Aetgble 50,000 Mortgage Payable 23,600 200,000 232,500 Office Supplies Prepaid Insurance Land Building Accumulated Depreciation, Building Office Equipment 1,500 Total Liabilities 3,000 64.250 400,000 Stockholder's Equity (45,000 Preferred Stock 90,000 Common Stock (15,000) Paid in Capital in Excess of par: Preferred 75,000 Paid in Capital in Excess of par: Common (15,000) Retained Earnings 70,000 Total Stockholder's Equity 250,000 100,000 7,500 71,250 85,000 513,750 746,250 Store Equipment Store Equipment Patents Total Assets 746,250 Total Liabilities and Stockholder's Equity