IN EXCEL FORMAT PLS

Step #2

Using Be Prepared, Inc.s adjusted trial balance and prior periods balance sheet, prepare the following Financial Report in good form using Microsoft Excel:

Comparative Balance Sheet for the months of December 2021 and January 2022 (See page 608 Exhibit 17.1 in your textbook for guidance).

Step #3

Use the Comparative Balance Sheet you prepared in Required #1, step #3 and the following additional information to prepare the Statement of Cash Flows for the month of January 2022. Use the indirect method to prepare the operating activities section.

Issued 20,000 new shares of common stock in exchange for a Building. The stock was selling on the market at an average price of $10 per share on the date of sale and the par value of the stock was 50 cents.

Purchased land with a cost $300,000. A down payment was made in the amount of $100,000 cash and a 10% 5-year note payable was signed for the difference.

Purchased additional store equipment for $30,000 paying cash.

The notes receivable were related to the sale of merchandise inventory to a credit customer this period. Hint: The increase in notes receivable should be reported as an item in the operating activities section of the statement of cash flows.

Issued bonds with a face amount of $375,000 at 97. Hint: The amortization of the bond discount in the amount of $750 should be reported as an addition to the operating activities section.

Used the cash proceeds from the bond issue to pay off the mortgage payable of $210,000.

The company repurchased 20,000 shares of its common stock on the open market for $9 per share.

The company reissued 10,000 of the treasury shares at a price of $18 per share.

Issued 1,500 shares of preferred stock at $105 per share.

Paid cash dividends of $5,615 to preferred and common stockholders.

Step #4

Prepare the following Ratios for January 2022:

Current Ratio

Acid-Test Ratio

Debt Ratio

Profit Margin Ratio

Gross Margin Ratio