Companies often make use of computerized spreadsheets to help determine the impact of various adjusting entries before they are formally recorded. By using a spreadsheet, managers can perform calculations to quickly determine the effect of various adjusting entries on account balances.

Required
Use a spreadsheet package.
A. Set up a spreadsheet with debit and credit columns and enter the debit and credit data. Then set up debit and credit columns for the adjustments and the adjusted trial balance. Your spreadsheet should now have seven columns.
B. In the adjustments columns, make the following adjustments and then write a formula in the adjusted trial balance columns so that the correct after- adjustment amount is determined.
1. Supplies used during the period were $ 150.
2. Depreciation on the equipment was $ 250.
3. Unearned revenue earned during the period was $ 300.
4. Revenue earned but not recorded for the period was $ 400.

Transcribed Image Text:

Usadjusted Trial Balance Debits $1,600 1,100 300 3,000 Crodits Cash Accounts recoivable Supplios Equipmont Accumulated depreciation Accounts payable Uneamed revenue Capital stock Retained eamings Sarvice fee revenue Salary expensa Utlities axponse Insurance cxpensa Total $ 900 600 700 1,500 800 3300 equipment 1500 100 $7 800