5.1A (Algo) Completing the worksheet. LO 5-2, 5-3 The trial balance of Ortiz Company as of January 31, 20X1, after the company completed the first month of operations, is shown in the partial worksheet below. Required: Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,800; expired insurance, $7,300; depreciation expense on equipment for the period, $3,400. Analyze: How does the insurance adjustment affect Prepaid Insurance? Complete this question by entering your answers in the tabs below. Partial Worksheet Analyze Complete the worksheet by making the following adjustments: supplies on hand at the end of the month, $7,800; expired insurance, $7,300; depreciation expense on equipment for the period, $3,400. ORTIZ COMPANY Cash Account Name Accounts receivable Supplies Prepaid insurance Equipment Accumulated depreciation-Equipment Accounts payable Frank Ortiz, Capital Frank Ortiz, Drawing Fees income Supplies expense Insurance expense Salaries expense Depreciation expense-Equipment Utilities expense Sub-totals Totals $ Worksheet (Partial) Month Ended January 31, 20X1 Trial Balance Adjustments Adjusted Trial Balance Debit Credit Debit Credit Debit Credit Income Statement Debit Balance Sheet Credit Debit Credit 103,200 20,000 37,600 55,200 107,200 24,000 251,200 13,600 94,400 30,400 2,400 $ 369,600 $ 369,600 $ 0 $ 0 $ $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0