Prepare a 10-column work sheet for fiscal year 2005, starting with the unadjusted trial balance and including adjustments based on these additional facts:
a. The supplies available at the end of fiscal year 2005 had a cost of $3,200.
b. The cost of expired insurance for the fiscal year is $3,900.
c. Annual depreciation on equipment is $8,500.
d. The June utilities expense of $550 is not included in the unadjusted trial balance because the bill arrived after the trial balance was prepared. The $550 amount owed needs to be recorded.
e. The company’s employees have earned $1,600 of accrued wages at fiscal year-end.
f. The rent expense incurred and not yet paid or recorded at fiscal year-end is $200.
g. Additional property taxes of $900 have been assessed for this fiscal year but have not been paid or recorded in the accounts.
h. The long-term note payable bears interest at 1% per month. The unadjusted Interest Expense account equals the amount paid for the first 11 months of the 2005 fiscal year. The $240 accrued interest for June has not yet been paid or recorded. (Note that the company is required to make a $5,000 payment toward the note payable during the 2006 fiscal year.)

I have attaached a sample worksheet for you.

Your adjusting entries (#a through #h) will go in the Adjustment columns, then you rebalance your accounts in the Adjusted trial balance columns. Next you transfer your accounts to the appropriate financial statement columns(Income Statement or Balance sheet).