Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Connor corporation hired a new accountant

29/10/2021 Client: muhammad11 Deadline: 2 Day

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 2015, 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 inventory applications in multiple industries. One of the most basic applications is tracking manufacturing components; if tagged components "go walking" (if employees attempt to take them), companies can easily track and find them. 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 terroristsand 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 common stock at the end of 2015. 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 (2014) on an Excel spreadsheet.

Instructions

(a) Download the excel file “CASE 1 – CMC” 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 to spreadsheets to update the income statement, balance sheet, and retained earnings. You notice that for the fiscal year ended December 31, 2014, 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. Connor and Martin ask 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 an 8 point penalty.

Adjusting Journal Entries (AJE’s):

1. Wages earned by employees during December (’14) and to be paid in January (’15) are $33,875; associated payroll taxes on these wages are $2,710. (Record in two separate adjusting entries. The payroll taxes are an expense to the company for unemployment benefits and recorded as a payable to the state & federal taxing authority.)

2. On July 1, 2014 a client paid CMC $205,720 cash in advance for a 12-month consulting services contract. This was the only prepayment received from clients during the entire 2014 fiscal year and recorded with a credit to Unearned Revenue. Of the remaining balance in Unearned Revenue, 60% of the work has now been completed by year end.

3. You discover that a sale of a product was made on account and recorded in December for $128,600; the product has not yet been shipped (i.e. delivered to the customer). The cost of the product was $68,742. CMC uses the perpetual inventory method.

4. Bad debt expense is estimated to be 7% of ending Accounts Receivable. (Round to the nearest whole dollar.)

5. The Prepaid Expense account has a balance of $22,774. This balance includes $11,200 for a two-year insurance policy purchased on January 1, 2014. Of the remaining prepaid balance, 30% of the benefit has now expired. (Round to the nearest whole dollar.)

6. Annual depreciation rates are 7% for Buildings & Equipment/Furniture. No salvage. (Round to the nearest whole dollar.)

7. The long-term liabilities were outstanding for all of 2014 and accrue interest at 6% APR. CMCrecords accrued interest quarterly (interest was last updated on Sept. 30.) The company is required to pay the interest annually each January 31st.

8. On December 15, CMCdeclareda dividend of $110,000, to be paid on January 20, 2015. It had not yet been recorded.

9. At December 31, the Long-Term Investments (Available-for-sale securities or “AFS”) had a fair value of $160,186. The AFS Investment was originally purchased on May 1, 2014 for $140,186. CMCuses a “Fair Value Adjustment” account (an adjunct/contra account to the Investments) to mark-to-market the investment portfolio at year end. CMC’s tax rate is 35%.

10. Income tax is based on a 35% tax rate.

(b) After making the adjusting entries in (a), make the appropriate closing entries on the spreadsheet provided. Post to the Trial Balance.

(c) Complete the each of the required financial statements (Balance Sheet, Income Statement, Statement of Comprehensive Income, and Statement of Stockholder’s Equity) in good form. The Statement of Stockholder’s Equity should reconcile with your balance sheet, income statement, & Statement of Comprehensive Income. (Use cell referencing to link the appropriate cells from the other financial statements. Keep in mind that not all cells on the Statement of Stockholder’s Equity will require any updates. For example, no new stock was issued during 2014; the balance in the contributed capital accounts will therefore not change.)

General Ledger Account Name

Unadj. Balance 12/31/14


Debit

Credit

Cash and cash equivalents

70,277


Accounts Receivable

10,80,680


Allowance for doubtful accounts


34,962

Inventory

12,72,160


Prepaid expenses

22,774


Other Current Assets

16,063


Building

8,74,418


Equipment and furniture

3,36,983


Land

3,48,791


Accum Depr


5,91,965

Investments

1,40,186


Fair Value Adjustment

0


0

Goodwill

3,97,740


Other intangible assets

2,53,900


Accounts Payable


9,83,002

Dividends payable


Interest payable


26,483

Unearned Consulting Revenue


3,29,220

Wages payable


81,350

Payroll taxes payable


8,850

Income tax payable


Long term liabilities


5,88,500

Common Stock


9,20,000

Paid-in capital common stock


1,05,000

Treasury Stock

4,00,000


Retained Earnings


5,39,069

Dividends


OCI-Unrealized Gain - AFS

0


0

Sales revenue


93,53,346

Service revenue


11,88,785

Sales returns

1,62,400


Sales discounts

2,69,662


Product cost of goods sold

53,84,590


Service cost of goods sold

5,70,811


Advertising

1,63,870


Bad debt expense

0


Depreciation and amortization

0


Professional Dues & subscriptions

21,470


Gain/loss on disposal

0


Income tax expense

0


Insurance

80,144


Interest expense

26,483


Investment income


13,130

Legal and accounting fees

1,06,650


Miscellaneous

9,048


Office expense

2,20,114


Payroll taxes

1,36,975


Property taxes

1,04,570


Repair and maintenance

42,028


Research and development

4,70,680


Telephone

20,085


Travel and entertainment

38,391


Utilities

47,049


Wages

9,64,670


Wages - Officers

7,10,000


Income Summary

0

0

147,63,662

147,63,662

To Submit your finished Case:

1. Make a cover page for your Case 1 which includes your name. Hand in (1) print copy of your TB, AJE’s & Closing Entries, and a copy of each financial statement at the start of class (stapled together with your cover page on top). The due date is Wednesday, February 18th.

2. Using the “Cases” tab through Blackboard, attach your completed Case 1 excel file to the assignment for grading.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Quality Assignments
Finance Professor
Peter O.
Custom Coursework Service
Financial Assignments
Coursework Assignment Help
Writer Writer Name Offer Chat
Top Quality Assignments

ONLINE

Top Quality Assignments

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$39 Chat With Writer
Finance Professor

ONLINE

Finance Professor

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$36 Chat With Writer
Peter O.

ONLINE

Peter O.

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$24 Chat With Writer
Custom Coursework Service

ONLINE

Custom Coursework Service

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

$45 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$27 Chat With Writer
Coursework Assignment Help

ONLINE

Coursework Assignment Help

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$23 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

5.COURSE NAME: MANAGERIAL ECONOMICS - Theory of Human Caring on APN Role Student Presentation - Blondie heart of glass guitar lesson - English sba written report sample - Does chuck die maze runner - Under what circumstances is an inventory rollback typically performed - Sexuality now embracing diversity 5th edition online free - The large group intervention organizational development model applies to - Chapter 1 developing a business mindset - Reynolds intellectual assessment scales iq - Cloud Computing - Identify the expanded accounting equation from the options below - Research paper (Chicago Format) - Rory sutherland sweat the small stuff - Fairness by chinelo okparanta - Fluke 114 electrical multimeter - Optocoupler current transfer ratio - Glifeeis.grantham.edu - Gedling access road map - Halliday functions of language - General mills case study solution - Uncp qualtrics - What is the latitude and longitude of rome italy - Uses of psychological test ppt - A3 project plan template - Johnny b goode song - Linear approximation tangent plane - Cert iv training and assessment cheat sheet - Directing coaching supporting delegating - Tac physiotherapy treatment notification plan - Exercise 2 16 preparing an income statement - Lenny scares mr burns - Hsu's lactobacillus pediococcus medium - Tony stark case study answers - Computing - Ryan wood under armour net worth - Essay - Componential analysis in semantics - Pr 5 - What does it mean when cadences are elided - Financial statements are typically prepared in the following order - Theatre - Psychographic segmentation of nivea - Dr joseph john cmc ludhiana - Bsbres401 answers - Criminal justice the essentials 5th edition pdf free - Assignment - Amazon buys whole foods case study pdf - Oxford islamiyat book 2 teaching guide in english - Phrase wheel cheats disney movies - Internal forces and trends considerations - Lysaght longline 305 price - Week 2 Assignment - Advanced Skills Transcript Counseling Session Transcript - CONTINUATION OF EBP ASSIGNMENT - Australian unity health insurance dental - Is social business working out - How many beagles weigh between 22.5 and 29.5 - Larson and lafasto eight characteristics of effective teams - Where is mufy recognised - Percent alcohol in wine cooler - Herman's hermits starring peter noone curtis peterson auditorium february 9 - Cmi adjusted discharge calculation - Werner ladder instructions - Dr debra heathrow brown fat - K too everwear corporation can manufacture - How to remove master admin in quickbooks online - Separation of ownership and control ppt - Wolfson college oxford accommodation - Observation journal example - Order 2527986: short answer questions and graphs - Smoke detector dust cover home depot - The Artwork Of Jeff Koons Relate - How many pounds of raw material are needed to make one unit of alpha and one unit of beta? - School begins political cartoon questions and answers - Size 4 us baby shoes age - BI A - Access data registry viewer - Major steps in accounting process - Discussion Board - Cisco 8841 speed dial - Discussion: Policy Proposals-WK6 - Assignment on security architecture and design - Canadian virtual assistant network - Watch gargoyles the movie the heroes awaken online free - Hsc advanced english module b past questions - Antioch company makes ebook readers - The goal book eliyahu m goldratt - Hhps and whmis symbols quiz - Asus p6x58 e pro manual - Dulux electro dark bronze - Todd v nicol - Original pfc stepney green - Prg 420 java programming i - Interpersonal communication concepts in the blind side - Chapter 1 homework financial accounting - 1002 2 - Standing soldiers kneeling slaves summary - Accounting chapter 10 answer key - TLDQ3-2 - Lesson Plan Perfectiom