IN EXCEL FORMAT PLS

Step #1

Using Be Prepared, Inc.s adjusted trial balance and prior periods balance sheet, prepare the following Financial Reports:

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

Statement of Retained Earnings for the month of January 2022 (see page 471 in your textbook for guidance). Note: There are no prior period adjustments and all dividends declared and paid are cash dividends in the amount of $5,615.