accounting hw help 4 part record transaction may be journal entry balance statement income s
Presented below are an organization’s (Company-A) opening financial position and a series of transactions that take place over a year. You should determine the appropriate manner in which to record these transactions and then produce three financial statements for the organization at the end of the year. All of the balance sheet items from December 31, 2012, are shown below along with the events that occurred during 2013. Please ignore all taxes (income and sales) in preparing your answer.
Presented below are an organization’s (Company-A) opening financial position and a series of transactions that take place over a year. You should determine the appropriate manner in which to record these transactions and then produce three financial statements for the organization at the end of the year.
COMPANY-A offers its clients security systems and alarm monitoring services on a retail basis. COMPANY-A specializes in offering the most up-to-date services with the most technologically advanced equipment. For example, the high-end alarm system, called DAS59, is widely recognized as an industry leader. All of the balance sheet items from December 31, 2012, are shown below along with the events that occurred during 2013. Please ignore all taxes (income and sales) in preparing your answer.
Part 1: Opening Balances
Company-A, Inc. Balance Sheet Items As of December 31, 2012 |
Accounts payable $380,000 |
Accounts receivable $611,000 |
Accumulated depreciation $1,245,000 |
Cash $267,000 |
Common shares $1,152,000 |
Short-term bank loan $125,000 |
Plant, property, and equipment $2,111,000 |
Interest payable $37,000 |
Inventory $850,000 |
Licenses (net) $180,000 |
Long-term bank loan $525,000 |
Goodwill $80,000 |
Retained earnings $304,000 |
Advances from customers $340,000 |
Salaries payable $180,000 |
Short-term investments (trading securities) $180,000 |
Office supplies $9,000 |
The following events occurred during 2013:
(Part 2: Transactions A-N)
A. New credit sales for the year were $1,910,000.
B. New cash sales for the year were $333,000.
C. COMPANY-A acquired office supplies on credit for $32,000.
D. Cash collections from credit sales were $1,720,000.
E. Cash payments for items purchased on credit during the year were $344,000.
F. Paid $363,000 for administrative expenses during the year.
G. COMPANY-A acquired $212,000 of inventory on credit.
H. At the end of the year, COMPANY-A owed the bank $19,000 in interest.
I. COMPANY-A collected $327,000 of cash advances from customers.
J. COMPANY-A offers a “satisfaction guarantee” to its clients for security services. If clients are unhappy with the services they purchased, they are eligible for free additional security services (i.e., this is a form of “after sales warranty” service). The company estimates that future expenditures of approximately $67,000 will be required to perform these “after sales warranty” activities to keep clients satisfied for services originally rendered to clients in 2013.
K. COMPANY-A spent $125,000 during 2013 on research and development activities related to new services the company could offer clients. It is expected that some of these products would be marketable within one or two years, but nobody is sure which products will be successful.
L. On the last day of business in 2013, COMPANY-A declared an $80,000 dividend, which will be paid sometime in the next year.
M. At the end of the year, COMPANY-A owed its employees a total of $66,000 in wages.
N. COMPANY-A paid down the long-term loan by $140,000.
(Part 3: Transactions O-Z)
O. Sales of $272,000 were earned from prior period cash advances from customers.
P. At the end of the year, the market value of the short-term investments was $157,000.
Q. A total of $3,000 in office supplies remained on hand at the end of the year.
R. COMPANY-A’s policy is to write off all intangible assets over 3 years using straight-line amortization. 2013 is the second year for amortizing licenses.
S. At the end of the year, it was determined that $513,000 of inventory remained on-hand.
T. At the end of the year, it was determined that the carrying value of goodwill had declined by $28,000.
U. Old equipment, which had originally cost $147,000 and was fully depreciated, was scrapped on the first day of business of the year.
V. COMPANY-A acquired all of the assets and liabilities of Smith Alarms, LLC for $555,000 cash. The assets included equipment valued at $425,000 (this equipment was carried on the books of Smith Alarms, LLC at $300,000 net), accounts receivable of $230,000, accounts payable of $250,000, and a demand loan of $52,000. There were no intangible assets.
W. COMPANY-A paid salaries to employees of $390,000 in cash.
X. Paid the bank $58,000 cash towards interest payments during the year.
Y. Depreciation on plant, property, and equipment for 2013 was determined to be $123,000.
Z. At the end of the year, the accountant estimated that $22,000 of accounts receivable owed to the firm would not likely be collected.
Part 4: Financial Statements
Create the three financial statements on an Excel spreadsheet. Use standard financial statement heading and formatting conventions.
- A Balance Sheet for Company-A as of December 31, 2013.
- An Income Statement for Company-A for the year ending December 31, 2013.
- A Statement of Cash Flows for Company-A for the year ending December 31, 2013
Sample Transaction Recording – Classification needed of opening balances.
Company-A. Balance Sheet Items As of December 31, 2012 |
|||
Transaction |
Amount |
Asset, ContraAsset, Liability, Stockholders’ Equity |
Debit (Left) Credit (Right) |
Accounts payable |
$380,000 |
|
|
Accounts receivable |
$611,000 |
|
|
Accumulated depreciation |
$1,245,000 |
|
|
Cash |
$267,000 |
|
|
Common shares |
$1,152,000 |
|
|
Short-term bank loan |
$125,000 |
|
|
Plant, property, and equipment |
$2,111,000 |
|
|
Interest payable |
$37,000 |
|
|
Inventory |
$850,000 |
|
|
Licenses (net) |
$180,000 |
|
|
Long-term bank loan |
$525,000 |
|
|
Goodwill |
$80,000 |
|
|
Retained earnings |
$304,000 |
|
|
Advances from customers |
$340,000 |
|
|
Salaries payable |
$180,000 |
|
|
Short-term investments (trading securities) |
$180,000 |
|
|
Office supplies |
$9,000 |
|
|
In addition to the A-Z transactions, other events were posted to the General Ledger.
Use the General Ledger’s ending balances (shown below in alphabetical order) to
prepare the company’s Income Statement and Balance Sheet for fiscal year 2014.
Company-A, Inc. |
Trial Balance |
December 31, 2014 |
Accounts Payable 555,000 |
Accounts receivable (net) 1,125,000 |
Accum.Depreciation 1,273,000 |
Administrative Expenses 380,000 |
Advances from Customers 450,000 |
Bad Debt Expense 27,000 |
Cash 695,000 |
Common Stock 1,291,000 |
Cost of Goods Sold 600,000 |
Decline in ST Investments 25,000 |
Demand Loan Payable 225,000 |
Depreciation Expense 145,000 |
Dividends Payable 80,000 |
Dividends, declared 100,000 |
Equipment & Buildings 2,533,000 |
Goodwill (net) 325,000 |
Goodwill Impairment 30,000 |
Interest Expense 50,000 |
Interest Payable 33,000 |
Inventory 535,000 |
Licenses (net) 140,000 |
Licenses, Amortization 110,000 |
Long-term Loan Payable 415,000 |
Research & Development Expense 140,000 |
Retained Earnings, Beg.Balance 304,000 |
Salaries Expense 325,000 |
Salaries Payable 97,000 |
Sales Revenue 2,750,000 |
Short-term Investments (net) 164,000 |
Supplies 6,000 |
Supplies Expense 43,000 |
Warranties Expense 75,000 |
Warranty Payable 100,000 |
Statement of Cash Flows
The following information was obtained from the company’s General Ledger’s Cash account. Use these events to create a Statement of Cash Flows for the current fiscal year.
NOTE: The cash amounts in this listing are NOT meant to correlate to the Income Statement or various non-Cash accounts on the Balance Sheet!
267,000 Cash, beginning balance
695,000 Cash, ending balance
Cash Generated/Used by the company:
a |
500,000 |
Accounts Payable |
b |
1,825,000 |
Accounts Receivable collections |
c |
400,000 |
Administrative Expenses |
d |
600,000 |
Buying a competitor’s business |
e |
375,000 |
Customer Advances |
f |
25,000 |
Dividends to Investors |
g |
15,000 |
Furniture & Equipment purchases |
h |
60,000 |
Interest Expense |
i |
3,000 |
Interest Revenue |
j |
100,000 |
Issued additional shares of CommonStock |
k |
150,000 |
Research and Development |
l |
475,000 |
Salaries and Wages |
m |
350,000 |
Sales Revenue |
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!
NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.
