The following information was taken from the accounting records of the Lamberson Company:

Additional information for the year:
(a)
Sales ............$ 39,930
Cost of goods sold .........(19,890)
Depreciation expense .......(2,100)
Wages expense .........(11,000)
Other operating expenses .......(1,000)
Bond interest expense .........(410)
Dividend revenue ...........820
Gain on sale of investments .......700
Loss on sale of equipment .....(200)
Income tax expense .........(2,050)
Net income ...........$ 4,800
(b) Dividends declared and paid totaled $700.
(c) On January 1, 2007, convertible preferred stock that had originally been issued at par value were converted into 500 shares of common stock. The book value method was used to account for the conversion.
(d) Long-term nonmarketable investments that cost $1,600 were sold for $2,300.
(e) The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the year.
(f) Equipment with a cost of $2,000 and a book value of $300 was sold for $100. The company uses one Accumulated Depreciation account for all depreciable assets.
(g) Equipment was purchased at a cost of $16,200.
(h) The 12% bonds payable were issued on August 31, 2007 at 97. They mature on August 31, 2017. The company uses the straight-line method to amortize the discount.
(i) Taxable income was less than pretax accounting income, resulting in a $396 increase in deferred taxes payable.
(j) Short-term marketable securities were purchased at a cost of $1,300. The portfolio was increased by $300 to a $3,800 fair value at year-end by adjusting the related allowance account.
Required
1. Prepare a worksheet (spreadsheet) to support the Lamberson Company€™s statement of cash flows for 2007.
2. Prepare the statement of cash flows.
3. Compute the cash flow from operations to sales ratio and the profit margin ratio for 2007. What is the primary reason for the difference in the results of theratios?

Transcribed Image Text:

Account Balances anuary 1, 2007 December 3, 2007 S 1,400 2,800 1,700 2,400 2,690 3,000 Accounts receivable (net) Marketable securities (at cost) Allowance for change in value Inventories 8,100 1,300 7,000 15,000 32,000 7.910 1,710 5,400 15,000 46,200 Investments (long-term) Buildings and equipment Discount on bonds payable 585,400 Credits Accumulated depreciation Accounts payable 516,000 3,800 2,400 1,100 $16,400 4,150 2,504 Wages payable Interest payable Note payable (long-term) 12% bonds payable 0,000 1,196 800 9,000 14,000 8,700 Convertible preferred stock, $100 par 21,500 13,700 Additional paid-in capital Unrealized increase in value of marketable securities Retained earnings 10,000 14,100 585,400