340-Case-1-Acct Cycle-15a

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 perpetualinventory
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, CMC
declareda 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. CMC
uses 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.