Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following information was taken from Lamberson Company's accounting records: Account Balances Account Titles January 1, 2016 December 31, 2016 Debits Cash $ 1,400 $
The following information was taken from Lamberson Company's accounting records:
Account Balances | ||
Account Titles | January 1, 2016 | December 31, 2016 |
Debits | ||
---|---|---|
Cash | $ 1,400 | $ 2,400 |
Accounts Receivable (net) | 2,800 | 2,690 |
Marketable Securities (at cost) | 1,700 | 3,000 |
Allowance for Change in Value | 500 | 800 |
Inventories | 8,100 | 7,910 |
Prepaid Items | 1,300 | 1,710 |
Investments (long-term) | 7,000 | 5,400 |
Land | 15,000 | 15,000 |
Buildings and Equipment | 32,000 | 46,200 |
Discount on Bonds Payable | — | 290 |
$69,800 | $85,400 | |
Credits | ||
Accumulated Depreciation | $16,000 | $16,400 |
Accounts Payable | 3,800 | 4,150 |
Income Taxes Payable | 2,400 | 2,504 |
Wages Payable | 1,100 | 650 |
Interest Payable | — | 400 |
Note Payable (long-term) | 3,500 | — |
12% Bonds Payable | — | 10,000 |
Deferred Taxes Payable | 800 | 1,196 |
Convertible Preferred Stock, $100 par | 9,000 | — |
Common Stock, $10 par | 14,000 | 21,500 |
Additional Paid-in Capital | 8,700 | 13,700 |
Unrealized Increase in Value of Marketable Securities | 500 | 800 |
Retained Earnings | 10,000 | 14,100 |
$69,800 | $85,400 |
Additional information for the year:
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 - Dividends declared and paid totaled $700.
- On January 1, 2016, 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.
- Long-term nonmarketable investments that cost $1,600 were sold for $2,300.
- The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the year.
- 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.
- Equipment was purchased at a cost of $16,200.
- The 12% bonds payable were issued on August 31, 2016, at 97. They mature on August 31, 2026. The company uses the straight-line method to amortize the discount.
- Taxable income was less than pretax accounting income, resulting in a $396 increase in deferred taxes payable.
- 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
- Prepare a spreadsheet to support Lamberson Company's 2016 statement of cash flows. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments.
LAMBERSON COMPANY
Cash Flows Worksheet
For Year Ended December 31, 2016Balances Worksheet Entries Account Titles 01/01/2016 12/31/2016 Change Debit Credit Debits Cash 1,400 2,400 Noncash Accounts: Accounts Receivable 2,800 2,690 Marketable Securities 1,700 3,000 Allow for Change in Value 500 800 Inventories 8,100 7,910 Prepaid Items 1,300 1,710 Investments (long-term) 7,000 5,400 Land 15,000 15,000 Buildings and Equipment 32,000 46,200 Discount on Bonds Payable 290 Totals 69,800 85,400 Credits Accumulated Depreciation 16,000 16,400 Accounts Payable 3,800 4,150 Income taxes Payable 2,400 2,504 Wages Payable 1,100 650 Interest Payable 400 Notes Payable (long-term) 3,500 12% Bonds Payable 10,000 Deferred Income Taxes 800 1,196 Convertible Preferred Stock 9,000 Common Stock, $10 par 14,000 21,500 Additional Paid-in Capital 8,700 13,700 Unrealized Increase in Value of Marketable Securities 500 800 Retained Earnings 10,000 14,100 Totals 69,800 85,400 Worksheet Entries Debit Credit Cash Flows from Operating Activities: Net income Add: Depreciation expense Add: Loss from sale of building Cash Flows from Investing Activities: Cash Flows from Financing Activities: Investing and Financing Activities Not Affecting Cash: Totals Prepare the statement of cash flows.
LAMBERSON COMPANY
Statement of Cash Flows
For Year Ended December 31, 2016Operating Activities: Adjustment for noncash income items: Adjustments for cash flow effects from working capital items: Net cash provided by operating activities Investing Activities: Net cash used for investing activities Financing Activities: Net cash provided by financing activities Cash, January 1, 2016 Cash, December 31, 2016 - Compute the cash flow from operations to sales ratio and the profit margin ratio for 2016. Round your answers to one decimal place.
- Cash flows from operations ratio :
- Profit margin:
Step by Step Solution
★★★★★
3.43 Rating (172 Votes )
There are 3 Steps involved in it
Step: 1
1 Prepare a spreadsheet to support L Companys 2016 statement of cash flows A B D E F 1 Account Title...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started