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