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?