1. Record the journal entries for all items (#1 - #28) in the GJ (General Journal) for Fifth Cousin Media LLC in EXCEL. Use Data-validation tool List (for the list use chart of accounts) for column C in GJ. This tool is explained in the instructional video.

2. Post the transactions shown above in the appropriate general ledger accounts, use T-accounts tab in EXCEL. Post the transactions by referencing cells in the GJ tab. Do not simply re-type the amounts. Use formulas to calculate balances for all T-accounts.

3. Prepare an Adjusted Trial Balance in EXCEL. Use cell references from T-accounts or the GJ when appropriate; use formulas to total the debits and credits.

4. Name your file using your initials (e.g. ACC3313 FCM_Part1_LK.xls) and upload the file to TRACS in the Assignments section by 7:30am Tuesday, Sept. 4, 2018. PRINT OUT AND BRING hard copies of your GJ entries, t-accounts and Adjusted Trial Balance to class on Tuesday, Sept. 4. The solution will be reviewed in class.

5. A correct Adjusted Trial Balance will be available on TRACS at 9am on September 4. Use it to prepare an Income Statement, a Statement of Retained Earnings, and an unclassified Balance Sheet in EXCEL. Use formulae as appropriate.

6. Prepare closing entries on the separate tab in EXCEL.

7. Prepare a Post-Closing Trial Balance in EXCEL; use formulae to total the debits and credits. Name your file using your initials (e.g. ACC3313 FCM_Part2_LK.xls) and upload the file to TRACS in the Assignments by 7:30am Tuesday, September 11.

Note: Part of your grade will relate to your use of EXCEL. You must use cell references and formulas where possible.

FIFTH COUSIN MEDIA CASE (60 points). ACC3313 FALL-18

Fifth Cousin Media (FCM) provides social media marketing and consultation services for its clients. The following transactions occurred in December 2017. Transactions up to November 30 have been correctly recorded unless otherwise specified. On December 1, you took over the controller position and are now responsible for recording all transactions and preparing the financial statements.

The chart of accounts and trial balance as of November 30, 2017 are in ACC3313 FCM Template.xls (TRACS-Resourses-Part1-Accounting Cycle Problem)

1. On February 3, 2017, FCM signed an agreement with Deion Sanders to provide media consulting for his football camp. On December 1, FCM completed some of the work for Sanders, and issued an invoice for $15,000. Full payment was received on January 15, 2018. Note: the project did not involve video production.

2. On December 1, to prepare for expansion, FCM issued 1,000 shares of stock for $90 per share and signed a $20,000 note that is due November 20, 2022. The note carries a 4.5% annual rate of interest which is to be paid semi-annually so the first interest payment will be made May 31, 2018. (Do not forget to record accrued interest at the end of the year). On December 3, FCM purchased land for $100,000 on which to build a 4,000 sq. ft. facility.

3. On November 15, 2017, FCM sent an invoice for $170,000 to the Livestrong Foundation for creating a promotional video. On December 2, FCM received the $170,000 payment from the Livestrong Foundation

4. On November 30, 2017, FCM purchased, received, and recorded $4,000 of supplies from VimBoot on account. On December 4, FCM paid VimBoot for the supplies purchased the previous month.

5. On November 30, 2017, FCM accrued $230 for that months AT&T Internet and telephone bill. That ATT&T bill was paid on December 5.

6. FCM recorded the purchase of a $1,600 insurance policy on May 31, 2017, for coverage from June 6 through December 6, 2017. No other entries related to this insurance policy have been made. FCM purchased a new 12-month policy on December 6 for $2,920 cash.

7. On December 7, NBC Sports contacted FCM about a potential video project. On December 15, FCM paid $1,000 to a consultant to gather focus groups to determine if there was sufficient demand for the project NBC Sports proposed. On December 30, the consultant provided TCM with the report discussing the results of the focus groups.

8. On December 11, FCM purchased two computers from Dell Inc. for $4,900 each. FCM paid $500 down with a check; the remaining balance is due in 30 days (n/30). The computers have an estimated life of three years and a salvage value of $100.

9. On December 12, an invoice in the amount of $120 was received from FedEx for transportation-in on the computers purchased on December 11. The invoice was paid the same day by check.

10. On December 15, a $55,000 social marketing project was completed for JonyJones. The invoice was sent with a due date of January 25, 2018. FCM failed to record transaction.

11. On August 1, 2017, a $12,000 contract was signed for a social marketing project with Outright Fitness and FCM received the full payment on that date. On December 17, FCM completed the project for Outright Fitness.

12. On December 18, FCM had an unpleasant communication with O-Dij-Games, a company producing on-line video games and a long-time customer of FCM. O-Dij-Games had recently difficulties with revenue generation and financing. O-Dij-Games management expresses an unwillingness to pay FMC the remaining $1,500 due to FMC because of dissatisfaction with the outcomes from FCMs social media campaigns. O-Dij-Games indicated its intention to never use FMC services in the future. FCM wrote off the O-Dij-Games outstanding balance. FCM uses the allowance method for bad debts.

13. On December 19, FCM received $28,000 payment for a promotional project that was completed for Chuck Nash Chevy in October 2017. The receivable had been recorded upon completion of the project.

14. On November 22, FCM borrowed $15,000 on a 5%, 30-day note from SocialVid Consulting. On December 22, FCM repaid the note and interest.

15. On December 22, FCM issued a $340 check to reimburse an employee for travelling to Houston to make a presentation to potential customers.

16. On December 29, supplies of $900 were purchased on account (n/30) and delivered.

17. A cash dividend of $9,700 was declared and paid on December 30.

18. Beginning in April 2017, FCM performed a variety of social media services for Art Unlimited over a period of six months. Art Unlimited failed to make its last payment of $11,000, which was due November 15, 2017, because it was waiting for money to be transferred to it from a related art foundation. On December 31, FCM allowed Art Unlimited to replace its account receivable with a six-month note receivable due June 30, 2018; the note carries a 5% interest rate.

19. All six FCM employees are monthly paid. Wages and Salary Expense for December 2017 was $9,180, which will be paid on January 2, 2018.

FCM used the following information to make adjusting entries:

20. A physical count of supplies indicated that, as of December 31, 2017, $800 worth of supplies were on hand.

21. On December 15, a $55,000 social marketing project had been completed for JonyJones, but FCM forgot to record the transaction. You identify this oversight on December 31^st.

22. On November 1, YMCA-Austin began negotiations with FCM for $42,000 of video production services. FCM would perform the video production services for YMCA-Austin over a 12-month period. FCM signed the contract on December 1, 2017 and began shooting immediately. Payments for the work are to be spread evenly throughout the 12-month period, with FCM billing YMCA-Austin on the last day of every month. The check for Decembers work for YMCA was not received until January 1^st, 2018.

23. December 2017s electricity bill of $100 was accrued on December 31 but was received and paid on January 2^nd, 2018.

24. Decembers Internet and telephone bill of $230 was accrued at month end and paid on January 3, 2018.

25. Make the adjusting entry necessary to record depreciation expense for all of 2017. Your assistant has calculated depreciation for the year, as shown in in the Extra Info tab. FCMs management has decided that a full month of depreciation is recorded if an asset is held for 15 days or more; if the asset is used less than 15 days in a month, no depreciation is recognized. For example, the equipment acquired on March 19 is depreciated as if it had been purchased bought on April 1. A computer sold on November 11 is depreciated as if it had only been used until October 31.

26. A lease payment of $6,000 for renting the office was made on October 1, 2017, for rental through September 30, 2018. The asset account was properly adjusted for October and November. The cost of leasing the office needs to be made for December 2017.

27. The Allowance for Doubtful Accounts should be established at 1% of Accounts Receivable as of December 31, 2017. Compute the balance after making the December adjusting entries.

28. During 2017 there were four notes payable outstanding (the three indicated below and the one repaid on December 22). Interest for two of these notes (SnapCut and WestBestVideo) is paid at maturity; interest on the Wells Fargo note is paid semiannually. Proper accruals of the interest were made as of November 30, 2017. Interest for December 2017 needs to be recorded.

Your assistant calculated interest for December 2017 below:

SnapCut Inc., 6%, 6 months, due Feb. 28, 2018	10,000 x 0.06 x (1/12) =	50
WestBestVideo, 8%, 6 months, due Apr. 30, 2018	2000 x 0.08 x (1/12) =	13
Wells Fargo, 4.5%, 5 years, due Nov. 20, 2023	20,000 x 0.045 x (1/12) =	75

29. Insurance expense for December 2017 needs to be recorded using the number of days in the insurance policy.