Votiable Pivot Tables Picture 2 B D E THUNDER CAT SERVICES Trial Balance 11/30/18 Credits Debits $19,400 1.500 7.200 83,700 240,000 $9,800 Accounts Cash Supplies Prepaid Rent Equipment Buildings Accounts Payable Deferred Revenue Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Advertising Expense Uties Expense 2,000 125,000 75,500 9,000 264,000 65,000 18.200 323,00 476.300 $478.300 Page 102 The following transactions occur during December 2018 December 1-31 December 4 Throughout the month, Thunder Cat provides services to customers for cash $27400. (Hint Record the entire month services in a single entry) Purchase pet supplies on account. $2.900 Pay for fiers to be distributed to local residences to advertise the company's services $3,200 December 8 December 9 Pay for supplies purchased on December 4 12-Dec issue additional shares of common stock for cash $5,000 16-Dec Pay cash on accounts payable, 56,300 19-Dec Purchase equipment with cash. 57.700. with an estimated of 10 yrs, no salvage Value 22 Dec Pay utilities for December, Sam Table Recommended Table Pivot Tables Data from Picture Pictures Shapes Icons My Add-ir x fx B D E als $78.300 $478.300 Page 1 ollowing transactions occur during December 2018 umber 1-31 mber 4 Throughout the month, Thunder Cat provides services to customers for cash, $27400. (Hint: Record the entire month's services in a single entry.) Purchase pet supplies on account, $2,900. Pay for fliers to be distributed to local residences to advertise the company's services, $3,200. mber 8 mber 9 Pay for supplies purchased on December 4. ac Issue additional shares of common stock for cash, $5,000 Pay cash on accounts payable, 55,300. Purchase equipment with cash, $7,700 with an estimated life of 10 yrs, no salvage Value Pay tiles for December, 54,500 Receive cash from customers for services to be provided next January, $2,300 One of Thunder Cars trainers takes a part-time job at the 200 and earns a salary of $1.200. The zoo and Thunder Cat Services are separate companies. Pay employee salaries for the current month $7.000 Pay dividends to stockholders, $3,000 able Recommended Table Pivot Tables Data from Picture Pictures Shapes Icons My Add-ins . F G H J D Sitional Information to help you adjust the books at 12/31/2018: Supplies on Hand had an actual balance of $1,250 at 12/31/2018 The $7200 prepaid rent at 11/30/2018 was paid on 11/30 and represents the next 12 months rent from that date Equipment was purchased on 2/1/18 and has a useful life of 10 yrs, no SV and is depreciated on the SL Basis Building was purchased on 1/1/18 and has a useful life of 40 yrs, no SV and is depreciated on the SL basis Deferred Revenue at 11/30/2018 represents 3 months of training services paid in advance on that date We provided Emergency medical services to a cat who was on its 8th life on Dec 31, 2018 (and of course lived!!!) mese services will billed for $3600 on January 4, 2019 Received a bill of $1000 on 1/5/2019 for medicines used in December YTD TB and Trans Adiuti B C D E F Requirements: G H 1) Set up a worksheet with the beginning Balances as of 11/31/2018 2) Prepare in Good form the transactions for December and Post them to the Worksheet 3) Prepare an "Unadjusted Trial Balance" on the worksheet 4) Prepare in Good form the adjustements at 12/31/2018 and Post them to the worksheet 5) Prepare an "Adjusted Trial Balance" on the worksheet 6) Finish the worksheet for the income statement and balance sheet 17) Prepare the income statement and Balance Sheet at 12/31/2018 8) Prepare in Good form the Closing Entries 9) Post them to the worksheet 10) Prepare the Post Close Trial Balance on the worksheet 0 + YTD TB and Trans ady Adjusting Entries Requirements Sheet 240,000 $9,800 2,000 125,000 75,500 ildings ccounts Payable ferred Revenue Common Stock Retained Earnings Dividends Service Revenue Salaries Expense Advertising Expense Uites Expense 9,000 254,000 66,000 18.200 Total 32800 $478.300 $476200 P100 The following transactions occur during December 2018: December 1-31 December 4 Throughout the month, Thunder Cat provides services to customers for cash, 527 400. (Hint: Record the entire month's services in a single entry) Purchase pet supplies on account, $2,900. Pay for flers to be distributed to local residences to advertise the company's services, $3.200 December 8 5 December 26 Pay for supplies purchased on December 4 12-Dec 27 Issue additional shares of common stock for cash 55.000 28 Pay cash on accounts payabia, 56,300 10-Dec 29 Purchase equipment with cash 37.700 with an estimated of 10 yrs, no salvage Vw 30 Pays for December, SUSO YTD TB and Trans Adjusting Entries Requirements + esc O BC 000 000 customers for cash, $27,400. (Hint: Record the entire ma services in a single entry.) Purchase pet supplies on account, $2,900. Pay for fliers to be distributed to local residences to advert the company's services, $3,200. Pay for supplies purchased on December 4. Issue additional shares of common stock for cash, $5,000. Pay cash on accounts payable, $6,300 Purchase equipment with cash, 57,700. with an estimated life of 10 yrs, no salvage Value Pay utilities for December, $4,500 Receive cash from customers for services to be provided next January, 52,300 One of Thunder Cat's trainers takes a part-time job at the zoo and earns a salary of $1.200. The zoo and Thunder Cat Services are separate companies Pay employee salaries for the current month, 57.000 Pay dividends to stockholders, $3,000 YTD TB and Trans Adjusting Entries Requirements + Paste BIU lili . Open recovered workbooks? Your recent changes were saved. Do you want to continue working whe A12 fx F G . 2 4 6 J 1 Additional Information to help you adjust the books at 12/31/2018: 31) Supplies on Hand had an actual balance of $1,250 at 12/01/2018 52) The $7200 prepaid rent at 11/30/2018 was paid on 11/30 and represents the next 12 months rent from that date 7 3) Equipment was purchased on 2/1/18 and has a useful life of 10 yrs, no SV and is depreciated on the SL Basis 9 4) Building was purchased on 1/1/18 and has a useful life of 40 yrs, no SV and is depreciated on the St. basis 11 S) Deferred Revenue at 11/30/2018 represents 3 months of training services paid in advance on that date G) We provided Emergency medical services to a cat who was on its 8th life on Dec 31, 2018 (and of course lived!!!) 13 These services will billed for $3600 on January 4, 2019 8 10 12 14 15 7) Received a bill of $1000 on 1/5/2019 for medicines used in December 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 YTD TB and Trans Adjusting entries Requirements Requirements: 2 3 4 5 6 7 1) Set up a worksheet with the beginning Balances as of 11/31/2018 2) Prepare in Good form the transactions for December and Post them to the Worksheet 3) Prepare an "Unadjusted Trial Balance" on the worksheet 4) Prepare in Good form the adjustements at 12/31/2018 and Post them to the worksheet 5) Prepare an "Adjusted Trial Balance" on the worksheet 6) Finish the worksheet for the income statement and balance sheet 7) Prepare the Income statement and Balance Sheet at 12/31/2018 8) Prepare in Good form the Closing Entries 9) Post them to the worksheet 10) Prepare the Post Close Trial Balance on the worksheet 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 YTD TB and Trans Adjusting Entries Requirements