Record the journal entries for all items

Reference no: EM132132364

Assignment - FIFTH COUSIN MEDIA CASE

Instructions: Download ACC3313 FCM Template.xls from TRACS-Resourses-Part1.

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.

Attachment:- Assignment Files.rar

Reference no: EM132132364

Questions Cloud

What is the purpose of the control function : What is the purpose of the control function within an organization? What is the difference between bureaucratic, market, and clan control?

Analyse application of the updated remuneration principles : Critically analyse the application of the updated remuneration principles on the resolution of agency conflicts

After brainstorming with the leadership team : After brainstorming with the leadership team, you have identified four options:

For each plant compute the physical units of production : Thakin Industries Inc. manufactures dorm furniture in separate processes. For each plant compute the physical units of production

Record the journal entries for all items : ACC3313 Assignment - FIFTH COUSIN MEDIA CASE. Record the journal entries for all items for column C in GJ. Prepare an Adjusted Trial Balance in EXCEL

How would the affordable care act have affected services : What strengths of the U.S. health care system are illustrated in this case? How would the Affordable Care Act have affected the services provided in this case?

Disacuss about the acceptable level of risk : In this research-based paper, analyze what the literature presents as an acceptable level of risk within the healthcare organization.

Record both debit and credit to the notes payable account : Paid Audi Company the interest due on the note of April 15 and renewed the loan by issuing a new 60-day, Record both the debit and credit to the notes payable

Define groups and organizations : Define “groups” and “organizations.” What benefits do you see in group membership?

User Account

All Pages