Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

*PLEASE SHOW THE FORMULAS AND CELL REFERENCING TO USE FOR POSTING THE AJE TO THE TRIAL BALANCE Case 1 - Accounting Cycle: CM Corporation (40

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

*PLEASE SHOW THE FORMULAS AND CELL REFERENCING TO USE FOR POSTING THE AJE TO THE TRIAL BALANCE

Case 1 - Accounting Cycle: CM Corporation (40 points) CM Corporation (CMC) was founded in 2010 by Eric Conner and Phil Martin. The company designs, installs, and services security systems for high-tech companies. The founders, who describe themselves as "entrepreneurial geeks," met in a computer lab when they were teenagers and found they had common interests in working on security systems for critical industries. In early January 2018, CMC hired you as an accounting intern to assist the CFO and the entire corporate accounting team. Lately, Conner and Martin have been working with "radio frequency identification (RFID) technology. They have developed a detailed system designed to track inventory items using RFID tags embedded invisibly in products. This technology has numerous applications in multiple industries. Conner and Martin have sold their system to several high-tech companies in the area. These companies have a number of government contracts that require extensive security systems to protect sensitive data from infiltration by terrorists and competitors. To date, CMC's cash flow from sales and services has adequately funded its operations. CMC anticipates growth potential for its products. As a result, it is planning a new public offering of their commorn stock at the end of 2018. The accounting department is currently quite small and the CFO has requested additional staff to help keep pace with the company's fast-paced growth. Therefore, as an accounting intern you can immediately become a valuable member to their corporate accounting team. To familiarize you with the company's operations, the CFO has provided an unadjusted trial balance from the end of their last fiscal year (2017) on an Excel spreadsheet. Instructions (a) Download the excel file which has the unadjusted trial balance with the existing accounts. This file also contains an accounting "system" comprised of a series of linked spreadsheets. The linkages enable the effects of all accounting entries (journal, adjusting, and closing) to flow through the spreadsheets to update the income statement, balance sheet, and retained earnings. You notice that for the fiscal year ended December 31, 2017, the bookkeeper has made all the routine general journal entries throughout the year, but none of the adjusting or closing entries have been recorded The following information is provided for adjustments prior to closing the books. The CFO asks you to enter the adjustments into the spreadsheet using the tab labeled "AJE's & Closing Entries". Also post these adjustments to the Trial Balance in the two columns to the right of the unadjusted trial balance CMC uses a perpetual inventory system.) You MUST use cell referencing when posting to the Trial Balance or your grade will be assessed a 10 point penalty (b) Case 1 - Accounting Cycle: CM Corporation (40 points) CM Corporation (CMC) was founded in 2010 by Eric Conner and Phil Martin. The company designs, installs, and services security systems for high-tech companies. The founders, who describe themselves as "entrepreneurial geeks," met in a computer lab when they were teenagers and found they had common interests in working on security systems for critical industries. In early January 2018, CMC hired you as an accounting intern to assist the CFO and the entire corporate accounting team. Lately, Conner and Martin have been working with "radio frequency identification (RFID) technology. They have developed a detailed system designed to track inventory items using RFID tags embedded invisibly in products. This technology has numerous applications in multiple industries. Conner and Martin have sold their system to several high-tech companies in the area. These companies have a number of government contracts that require extensive security systems to protect sensitive data from infiltration by terrorists and competitors. To date, CMC's cash flow from sales and services has adequately funded its operations. CMC anticipates growth potential for its products. As a result, it is planning a new public offering of their commorn stock at the end of 2018. The accounting department is currently quite small and the CFO has requested additional staff to help keep pace with the company's fast-paced growth. Therefore, as an accounting intern you can immediately become a valuable member to their corporate accounting team. To familiarize you with the company's operations, the CFO has provided an unadjusted trial balance from the end of their last fiscal year (2017) on an Excel spreadsheet. Instructions (a) Download the excel file which has the unadjusted trial balance with the existing accounts. This file also contains an accounting "system" comprised of a series of linked spreadsheets. The linkages enable the effects of all accounting entries (journal, adjusting, and closing) to flow through the spreadsheets to update the income statement, balance sheet, and retained earnings. You notice that for the fiscal year ended December 31, 2017, the bookkeeper has made all the routine general journal entries throughout the year, but none of the adjusting or closing entries have been recorded The following information is provided for adjustments prior to closing the books. The CFO asks you to enter the adjustments into the spreadsheet using the tab labeled "AJE's & Closing Entries". Also post these adjustments to the Trial Balance in the two columns to the right of the unadjusted trial balance CMC uses a perpetual inventory system.) You MUST use cell referencing when posting to the Trial Balance or your grade will be assessed a 10 point penalty (b)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Audit Value Factor Making Managements Head Turn Internal Audit And IT Audit Series

Authors: Daniel Samson

1st Edition

1138198129, 978-1138198128

Students also viewed these Accounting questions

Question

Describe ERP and how it can create efficiency within a business

Answered: 1 week ago