Excel 05.xlsx Download Excel 05.xlsx (13.9 KB) Complete the End of Period Worksheet using the following Information. Unadjusted Trial Bal Adjustments Adjusted Account Number Description (Account Name) Debit Credit REF Debit REF Credit Debit 1000 Cash 40,000 1010 Accounts Receivable 8,000 1020 Supplies 2,200 1030 Office Equipment 10,000 1040 Accumulated Deprec. - Office Equip 8,000 1050 Prepaid Insurance 1,500 2000 Accounts Payable 12,000 2010 Wages Payable 2020 Unearned Fees 4,000 3000 Austin Case, Capital 29,400 4000 Fees Earned 14,000 5000 Wages Expense 5,000 5010 Insurance Expense 5020 Utilities Expense 400 5030 Supplies Expense 5040 Deprec. Expense - Office Equipment 5050 Misc. Expense 300 Totals 67,400 67,400 Net Incom 2 12345 Here is the data needed for month-end adjustments Pre-paid insurance at the end of the month is Depreciation on office equipment is Wages payable at the end of the month Supplies on hand at the end of the month were Amount of unearned fees earned during the month 1,000 400 1,400 1,400 2,500 Totals