Required #2 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 2021. Use the indirect method to prepare the operating activities section. Issued 10,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 $250,000. A down payment was made in the amount of $100,000 cash and a 10% 5year note payable was signed for the difference. Purchased additional store equipment for $20,000 paying cash. The $15,000 notes receivable was related to the sale of merchandise inventory to a credit customer this period. Hint: The increase in notes receivable should be reported as an addition to 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 $150,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 $25,000 to preferred and common stockholders. Required #3 Prepare the following Ratios for January 2021: 1. 2. 3. 4. 5. Current Ratio Acid-Test Ratio Debt Ratio Profit Margin Ratio Gross Margin Ratio Account ID 1001 1021 1022 1027 1031 1051 1101 1111 1125 1401 1411 1412 1431 1432 1451 1452 1501 2001 2005 2031 2101 2301 2303 3001 3011 3101 3111 3121 3300 3351 4001 4002 4003 4101 5001 5010 5012 5015 5020 5025 5027 5030 5035 6005 6010 6015 6020 6022 6025 6030 6040 7001 Be Prepared Adjusted Trial Balance January 31, 2021 Account Description Cash Accounts Receivable Allowance for Doubtful Acc Interest Receivable Notes Receivable Merchandise Inventory Store Supplies Office Supplies Prepaid Insurance Land Building Accum Dep: Building Office Equipment Accum Dep: Office Equipm Store Equipment Accum Depr: Store Equipm Patents Accounts Payable Income Taxes Payable Interest Payable Notes Payable long term Bonds Payable Discount on Bonds Payable Preferred Stock Common Stock Paid in Capital In Excess of par: Prefer Paid in Capital In Excess of par: Com $ Debits 423,615.00 25,000.00 Credits $ 540.00 100.00 15,000.00 7,200.00 8,000.00 500.00 1,600.00 375,000.00 500,000.00 72,000.00 70,000.00 17,500.00 95,000.00 15,800.00 65,000.00 30,000.00 12,500.00 5,500.00 325,000.00 375,000.00 10,500.00 210,000.00 120,000.00 61,250.00 295,000.00 90,000.00 850.00 Paid in Capital Treasury Stock Retained Earnings Treasury Stock Sales Revenue Sales Discount Sales Returns & Allowances Interest Revenue Cost of Goods Sold Insurance Expense - General Repairs Expense: Office Depreciation Expense: Building - General Depreciation Exp: Office Eq Supplies Expense - Selling Utilities Expense: Office Office Salaries Expense Office Payroll Tax Expense Depreciation Exp: Store Eq Amortization Expense: Pat - General Sales Salaries Expense Sales Payroll Tax Expense Utilities Expense: Store Delivery Expense - General Repairs Expense: Store Bad Debts Expense - Selling Interest Expense 90,000.00 275,575.00 750.00 5,250.00 50.00 $ 125,500.00 300.00 2,100.00 9,000.00 2,500.00 2,400.00 1,100.00 25,000.00 7,000.00 800.00 800.00 20,000.00 5,600.00 1,200.00 1,500.00 750.00 2,000.00 6,500.00 1,906,565.00 $ 1,906,565.00 Be Prepared Inc. Balance Sheet December 31, 2020 Assets Cash Accounts Receivable Merchandise Inventory Office Supplies Prepaid Insurance Land Building Accumulated Depreciation, Building Office Equipment Accumulated Depreciation, Office Equipment Store Equipment Accumulated Depreciation, Store Equipment Patents Total Assets Liabilities $ $ 74,800 40,000 50,000 1,500 3,000 125,000 400,000 (63,000) 70,000 (15,000) 75,000 (15,000) 65,800 812,100 Accounts Payable Income Taxes Payable Note Payable Mortgage Payable Total Liabilities Stockholder's Equity Preferred Stock Common Stock Paid in Capital in Excess of par: Preferred Paid in Capital in Excess of par: Common Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ $ 25,000 7,500 175,000 150,000 357,500 52,500 115,000 61,250 200,000 25,850 454,600 812,100