help i am not getting this?

Question

The following unadjusted trial balance is for Adams Construction Co. as of the end of its 2005 fiscal
year. The June 30, 2004, credit balance of the owner’s capital account was $52,660, and the owner
invested $25,000 cash in the company during the 2005 fiscal year.e. The company’s employees have earned $1,600 of accrued wages at fiscal year-end.
required
1. 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.
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.)
http://s101.photobucket.com/albums/m69/doooooobug/?action=view¤t=help.png

Answer 1

This is an extremely long question and I've done it on excel, but can you email me your email address so I can attach the excel file? (Just for this once!)

Btw, I'm 12 to 15 hours ahead of you.

Answer 2

Look this is an accounting problem. You really should look in your textbook for an example, or you can go to one of the tax sites and purchase the tax software for a corporation. It will make it a lot easier. But remember when you have a test you will not be allowed to use this software. You will need to understand what you are doing and why.

http://www.taxact.com/products/index_personal.asp