would like to help me to fix this account problem, please do it in excel. thank you!!!!! give me a lot of explanations will be better. thank you!! have a nice day1!

Bike World, Inc., wholesales a line of custom road bikes. Bike World's inventory. as of November 30, 2014, consisted of 22 mountain bikes costing $1,650 each. Bike World's trial balance as of November 30 appears as follows: During the month of December 2014 Bike Worid, Inc., had the following transactions: Dec 4 Purchased 10 bikes for $1,575 each from Truspoke Bicycle, 00.. on account. Terms, 2115. N45, FOB destination. 6 Sold 14 bikes for $2,100 each on account to leport. Inc. Terms. 3/10. n/30, FOB destination. 8 Paid $375 freight charges to deliver goods to Allsport, Inc. 10 Received $7,200 from Circlemart as payment on a November 1? sale. Terms were N30. 12 Purchased $450 of supplies on account from Ofce Express. Terms, 2/10. n130, FOB destination. 14 Received payment in full from Allsport. Inc., for the Dec 6 sale. 16 Purchased 15 bikes for $1,600 each from anspoke Bicycle. 00.. on account. Terms. 2/15. nl45. FOB destination. 18 Paid Tmspoke Bicycle, 00.. the amount due from the December 4 purchase in full. 19 Sold 18 bikes for $2.125 each on account to Columbia Cycle, Inc. Terms. 2/15. nl45, FOB shipping point. 20 Paid for the supplies purchased on December 12. 22 Paid sales commissions. $1,850. 30 Paid current month's rent, $500. Requirements 1. Using the transactions previously listed, prepare a perpetual inventory record for Bike World, Inc., for the month of December. Bike World, Inc., uses the FIFO inventory costing method. (Bike World records inventory in the perpetual inventory record net of any discounts as it is company policy to take advantage of all purchase discounts.) 2. Open four-column general ledger accounts and enter the balances from the November 30 trial balance. 3. Record each transaction in the general journal. Explanations are not required. Post the journal entries to the general ledger, creating new ledger accounts as necessary. Omit posting references. Calculate the new account balances. 4. Prepare an unadjusted trial balance as of December 31, 2014. 5. Journalize and post the adjusting journal entries based on the following information, creating new ledger accounts as necessary: a. Depreciation expense on office equipment, $1,875. b. Supplies on hand, $245. c. Accrued salary expense for the office receptionist, $845. 6. Prepare an adjusted trial balance as of December 31, 2014. Use the adjusted trial balance to prepare Bike World, Inc.'s multi-step income statement and statement of retained earnings for the year ending December 31, 2014. Also. prepare the balance sheet at December 31, 2014. 7. Journalize and post the closing entries. 8. Prepare a postclosing trial balance at December 31, 2014