Question

In: Accounting

The following information was taken from Lamberson Company's accounting records: Account Balances Account Titles January 1,...

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:

  1. 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
  2. Dividends declared and paid totaled $700.
  3. 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.
  4. Long-term nonmarketable investments that cost $1,600 were sold for $2,300.
  5. The long-term note payable was paid by issuing 250 shares of common stock at the beginning of the year.
  6. 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.
  7. Equipment was purchased at a cost of $16,200.
  8. 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.
  9. Taxable income was less than pretax accounting income, resulting in a $396 increase in deferred taxes payable.
  10. 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 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, 2016
    Balances 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
  2. Prepare the statement of cash flows.

    LAMBERSON COMPANY
    Statement of Cash Flows
    For Year Ended December 31, 2016
    Operating 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
  3. Compute the cash flow from operations to sales ratio and the profit margin ratio for 2016. Round your answers to one decimal place.
    1. Cash flows from operations ratio :
    2. Profit margin:

Solutions

Expert Solution

1.

2.

3.

The difference in the results of the two ratios is due primarily to the $2,100 depreciation expense, which was deducted to compute net income, but did not involve an operating cash outflow.


Related Solutions

The following selected account balances were taken from ABC Company's accounting records during 2018: January 1,...
The following selected account balances were taken from ABC Company's accounting records during 2018: January 1, 2018 December 31, 2018 Inventory 69,000 35,000 Accounts payable 47,000 41,000 Long-term notes payable 165,000 130,000 Income tax payable 11,000 7,000 Investments 89,000 68,000 Accounts receivable 77,000 84,000 Land 60,000 89,000 Common stock 100,000 175,000 Retained earnings 26,000 41,000 The following information was taken from ABC Company's 2018 income statement: Sales revenue $422,000 Cost of goods sold 361,000 Gain on sale of investments 11,000...
The following account balances were taken from the accounting records of the Senior Citizen Alternative Living...
The following account balances were taken from the accounting records of the Senior Citizen Alternative Living Center. Cash $4,750 Building $102,600 Revenue $42,500 Accounts receivable $11,400 Notes payable (due 19*9) $30,000 Restricted fund balance $19,500 Pledges receivable $31,600 Wages payable $5,100 Supplies on hand $1,250 Salary expense $46,000 Unearned revenue $7,100 Unrestricted fund balance $89,700 Depreciation expense $12,500 Accounts payable $3,800 Utilities expense $6,100 Long-term investments $26,800 Prepaid insurance $1,800 Insurance expense $900 Endowment fund balance $25,000 Supplies used expense...
Visual Inspection Noble Company's accounting records provided the following changes in account balances and other information...
Visual Inspection Noble Company's accounting records provided the following changes in account balances and other information for 2016: Net Changes for 2016 Debit Credit Cash $2,000 Accounts Receivable $1,900 Inventory 2,400 Land 1,700 Buildings and Equipment 23,000 Accumulated Depreciation 4,500 Accounts Payable 1,600 Salaries Payable 600 Bonds Payable 5,000 Common Stock, no par 3,000 Retained Earnings 5,300 $25,500 $25,500 Additional information: Net income was $9,900. Dividends were declared and paid. Land was sold for $1,700. No land was purchased. A...
Spreadsheet and Statement of Cash Flows The following information was taken from Lamberson Company's accounting records:...
Spreadsheet and Statement of Cash Flows 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...
Spreadsheet and Statement of Cash Flows The following information was taken from Lamberson Company's accounting records:...
Spreadsheet and Statement of Cash Flows 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...
The following account titles and balances were taken from the adjusted trial balance of Prince Co....
The following account titles and balances were taken from the adjusted trial balance of Prince Co. for Year 2. The company uses the periodic inventory system. Sales returns and allowances $11,700 Miscellaneous expense $6,300 Transportation-out $19,300 Sales $21,400 Advertising expense $930 Salaries expense $163,000 Transportation-in $3,350 Purchases $21,250 Interest expense $59,500 Merchandise inventory, January 1 $333,000 Rent expense $9,300 Merchandise inventory, December 31 $6,850 Purchase returns and allowances $11,450 Loss on sale of land $5,300 Utilities expense $12,500 a. Prepare...
The following selected account balances were taken from XYZ Company's general ledgers during 2021: January 1,...
The following selected account balances were taken from XYZ Company's general ledgers during 2021: January 1, 2021 December 31, 2021 Accounts receivable 44,000 ? Inventory 53,000 88,000 For 2021, XYZ Company had an average collection period of 50 days, an inventory turnover ratio of 4.75, and a gross profit of $79,400. Calculate the accounts receivable balance at December 31, 2021.
The company’s bookkeeper prepared the following balances from the company's accounting records for the month ended...
The company’s bookkeeper prepared the following balances from the company's accounting records for the month ended October 31, 2019: Retained Earnings, 10/1/19 508,000 Prepaid Insurance 50,000 Cash 37,000 Contributed Capital 400,000 Accounts Payable 95,000 Accounts Receivable 70,000 Sales Revenue Dividends 560,000 3,000 Interest Income Interest Expense 1,000 2,000 Supplies 18,000 Utilities Expense 5,000 Cost of Goods Sold 300,000 Wage Expense 50,000 Land Buildings Equipment Accumulated Depreciation Depreciation Expense 650,000 1,000,000 450,000 800,000 15,000 Income Tax Expense Advertising Expense Unearned Revenue...
2. The following selected accounts and account balances were taken from the records of Nowell Company....
2. The following selected accounts and account balances were taken from the records of Nowell Company. Except as otherwise indicated, all balances are as of December 31, 2018, before the closing entries were recorded. Consulting revenue $ 9,300 Cash 8,400 Cash received from common stock issued during 2017 3,600 Travel expense 550 Dividends 1,200 Cash flow from investing activities 3,000 Rent expense 1,450 Payment to reduce debt principal 18,200 Retained earnings, January 1, 2018 14,300 Salary expense 2,500 Cash flow...
The following selected accounts and account balances were taken from the records of Nowell Company. Except...
The following selected accounts and account balances were taken from the records of Nowell Company. Except as otherwise indicated, all balances are as of December 31, Year 2, before the closing entries were recorded. Consulting revenue $ 10,400 Cash 8,100 Cash received from common stock issued during Year 1 4,000 Travel expense 500 Dividends 1,500 Cash flow from investing activities 2,800 Rent expense 1,100 Payment to reduce debt principal 23,300 Retained earnings, January 1, Year 2 14,600 Salary expense 3,400...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT