Reference no: EM13743989 , Length:

Prepare

1) transaction spreadsheet for 2013 using the data of events for 2013 identified as 1-10 and the additional information a-d.

2) Prepare the Income Statement for 2013.

3) Prepare the balance sheet for 2013.

The Operating Cycle and Financial Statements. Presented below is the year-end 2012 balance sheet for The Little Corporation.

THE Lints CORPORATION
Balance Sheet
December 31, 2012

Assets Current			Liabilities & Shareholders' Equity Current liabilities
Cash.........................		$ 510,000	Accounts payable .................	$ 650,000
Accounts receivable (net)....		564,000	Wages payable	173,000
Inventory .......................		720,000	interest payable	56,000
Prepaid rent.....................		222,000	Total current liabilities ............	879,000
Total current assets ........		2,016,000	Noncurrent liabilities	'
Noncurrent			Bank loan..	450,000
Long-term investments......		496,500	Bonds payable	1,950,000
Equipment...............................	$1,440,000		Total liabilities	3,279,000
Less Accum. depreciation ..	(288,000)	1,152,000	Shareholders' equity
Machinery .......................	2,850,000		Common stock ..........................	1,200.000
			Retained earnings	1,548,000
Less Accum. depreciation ...	(712,500)
		2,137,500	Total shareholders' equity	2,748,000
Intangible assets (net) ......		225,000	Total liabilities &
Total assets...............................		$6,027,000	shareholders' equity...................	$6,027,000

During 2013, the company entered into the following events:

1. Sales to customers totaled $2 million, of which $1.6 million were on credit and the remainder was cash sales. The cost of goods sold totaled $800,000.

2. Purchased $700,000 of inventory on credit.

3. Paid $620,000 cash to employees as wages. (This amount includes the wages payable at December 31, 2012.)

4. Collected $1.75 million cash from customers as payment on outstanding accounts receivable.

5. Paid $1.2 million cash to suppliers on outstanding accounts payable.

6. Sold machinery for $120,000 cash on January 1, 2013. The machinery had cost $370,000 and at the time of sale it had a net book value of $160,000.

7. Paid miscellaneous expenses totaling $98,000 cash.

8. Sold common stock for $450,000 cash.

9. Invested $200,000 of excess cash in short-term marketable securities.

10. Declared and paid a cash dividend of $100,000.

As part of the year-end audit,. the internal audit staff identified the following additional information:

a. $180,000 of prepaid rent was consumed during the year.

b. The equipment had a useful life of 10 years and the machinery of 20 years. The company uses straight-line depreciation. (No depreciation should be recorded for machinery in Item 6 above.)

c. The intangible assets had a remaining useful life of 10 years.

d. Interest on the bank loan and bonds payable was 10 percent. During the year, interest payments totaling $260,000 had been paid in cash.

Required

1. Using the balance sheet equation as illustrated in this chapter, prepare a spreadsheet reflecting the events of The Little Corporation during 2013.

2. Prepare the income statement for 2013.

3. Prepare the statement of shareholders' equity, balance sheet, and statement of cash flow for 2013.

4. How has the company's use of leverage changed from 2012 to 2013?