Question

In: Accounting

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

$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:

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, 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.

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, 2016, at 97. They mature on August 31, 2026. 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 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.

1.     Prepare the statement of cash flows.

LAMBERSON COMPANY
Statement of Cash Flows
For Year Ended December 31, 2016

Operating Activities:

Net income

$    

Adjustment for noncash income items:

Add: Depreciation expense

    

Add: Bond discount amortization

    

Add: Loss on sale of equipment

    

Add: Increase in deferred taxes payable

    

Less: Gain on sale of investments

    

Adjustments for cash flow effects from working capital items:

Decrease in accounts receivable

    

Decrease in inventories

    

Increase in prepaid items

    

Increase in accounts payable

    

Decrease in wages payable

    

Increase in income taxes payable

    

Increase in interest payable

    

Net cash provided by operating activities

$    

Investing Activities:

Payment for purchase of short-term marketable securities

$    

Proceeds from sale of long-term investments

    

Proceeds from sale of equipment

    

Payment for purchase of equipment

    

Net cash used for investing activities

    

Financing Activities:

Proceeds from issuance of 12% bonds

$    

Payment of dividends

    

Net cash provided by financing activities

    

Net increase in cash

$    

Cash, January 1, 2016

    

Cash, December 31, 2016

$    

2. Compute the cash flow from operations to sales ratio and the profit margin ratio for 2016. Round your answers to one decimal place.

a.     Cash flows from operations ratio :%

b.     Profit margin:  %

Solutions

Expert Solution

Answer 1: Cash Flow Statement in Spread sheet

LAMBERSON COMPANY
Statement of Cash Flows
For Year Ended December 31, 2016
Operating Activities: $ $
Net income 4,800
Adjustment for noncash income items:
Add: Depreciation expense 2,100
Add: Bond discount amortization 10
Add: Loss on sale of equipment 200
Add: Increase in deferred taxes payable 396
Less: Gain on sale of investments -700
Adjustments for cash flow effects from working capital items:
Add: Decrease in accounts receivable 110
         Decrease in inventories 190
         Increase in accounts payable 350
Increase in interest payable 400
         Increase in income taxes payable 104
Less: Increase in prepaid items -410
          Decrease in wages payable -450
Net cash provided by operating activities $7,100
Investing Activities:
Add: Proceeds from sale of equipment 100
          Proceeds from sale of long-term investments 2,300
Less: Payment for purchase of short-term marketable securities -1300
          Payment for purchase of equipment -16,200
Net cash used for investing activities $ $ -15100
Financing Activities:
Proceeds from issuance of 12% bonds 9,700
Payment of dividends -700
Net cash provided by financing activities 9,000
Net increase in cash 1,000
Add: Cash, January 1, 2016 1,400
Cash, December 31, 2016 $2,400

Answer 2:

a) Cash from operation to Slaes Ratio = Cash from operation ÷ Slaes 100

= $7,100 ÷ $39,930 100 = 17.8 %

b) Profit Margin Ratio = Net Income ÷ Net Slaes

= $4,800 ÷ $39,930 = 0.1202 =12.02 =12%


Related Solutions

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 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...
The following information was taken from the accounting records of JBD Company as of December 31,...
The following information was taken from the accounting records of JBD Company as of December 31, 2020: Inventory ................. $17,000 Accounts Payable .......... $36,000 Common Stock .............. $78,000 Accounts Receivable ....... $11,000 Retained Earnings ......... $24,000 (at January 1, 2020) Copyright ................. $20,000 Salaries Expense .......... $28,000 Supplies .................. $12,000 Mortgage payable .......... $80,000 (due March 1, 2040) Land ...................... $93,000 Notes Payable ............. $17,000 (due November 1, 2022) Trademark ................. $37,000 Sales Revenue ............. $97,000 Equipment ................. $85,000 Income...
The following information was taken from the accounting records of CJTR Company as of December 31,...
The following information was taken from the accounting records of CJTR Company as of December 31, 2020: Accounts Payable .......... ? Accounts Receivable ....... $44,000 Building .................. $68,000 Cash ...................... $17,000 Common Stock .............. $56,000 Cost of Goods Sold ........ $41,000 Dividends ................. ? Equipment ................. $79,000 Interest Revenue .......... $40,000 Inventory ................. $63,000 Land ...................... $82,000 Notes Payable ............. $67,000 Rent Expense .............. $23,000 Retained Earnings ......... ? Salaries Expense .......... $52,000 Salaries Payable .......... $34,000 Sales Revenue ................
In preparing a company's statement of cash flows using the indirect method , the following information...
In preparing a company's statement of cash flows using the indirect method , the following information is available: Net income $76,000 Accounts payble increaded by 20,400 accounts receivable decreased by 27,400 inventories increased by 9,800 depreciation expense 37,200 Net cash provided by operating activities was?
The following information was taken from the accounting records of Dunbar Mifflin Company in 2018. ​​​​​​Beginning...
The following information was taken from the accounting records of Dunbar Mifflin Company in 2018. ​​​​​​Beginning of 2018​Ending of 2018 Direct materials inventory​​​135,000​​83,000 Work-in-process inventory​​​185,000​​154,000 Finished-goods inventory​​​255,000​​216,000 Purchases of direct materials​​​​​​270,000 Direct manufacturing labor​​​​​​225,000 Indirect manufacturing labor​​​​​​103,000 Plant insurance​​​​​​​11,000 Depreciation-plant, building, and equipment​​​​48,000 Plant utilities​​​​​​​​29,500 Repairs and maintenance-plant​​​​​13,500 Equipment leasing costs​​​​​​66,800 Marketing, distribution, and customer-service costs​​​129,500 General and administrative costs​​​​​72,500 Required: 1. Prepare a schedule of cost of goods manufactured. Question 2​​​​​​​​​(Total: 38 marks) Following are the account balances for...
The following information is taken from the accounting records of four different companies. Provide the missing...
The following information is taken from the accounting records of four different companies. Provide the missing amounts. Assume there are no indirect materials used in the company’s finished product. Company 1 Company 2 Company 3 Company 4 Direct Materials Inventory, beginning $15,400 $ $6,000 $165,300 Purchases of direct materials 86,400 52,600 258,800 Total direct materials available for use 394,600 111,600 Direct Materials Inventory, ending 26,700 59,350 Direct materials used in production 90,800 Direct labor 212,700 25,500 299,100 Total manufacturing overhead...
The following information is taken from the accounting records of four different companies. Provide the missing...
The following information is taken from the accounting records of four different companies. Provide the missing amounts. Assume there are no indirect materials used in the company’s finished product. Company 1 Company 2 Company 3 Company 4 Direct Materials Inventory, beginning $15,900 $ $6,500 $166,000 Purchases of direct materials 86,400 52,600 258,900 Total direct materials available for use 394,900 112,000 Direct Materials Inventory, ending 26,200 59,750 Direct materials used in production 91,100 Direct labor 212,000 25,000 298,500 Total manufacturing overhead...
Statement of cash flows.(show your work) The information shown below is taken from the accounts of...
Statement of cash flows.(show your work) The information shown below is taken from the accounts of Waverly Corporation for the year ended December 31, 2017 Net income $314,000 Amortization of patent 12,000 Proceeds from issuance of common stock 103,000 Decrease in inventory 27,000 Sale of building at a $15,000 gain 85,000 Decrease in accounts payable 15,000 Purchase of equipment 185,000 Payment of cash dividends 24,000 Depreciation expense 55,000 Decrease in accounts receivable 23,000 Payment of mortgage 75,000 Increase in short-term...
The following information is taken from the cash records of Grouper Delivery Services: 1 The June...
The following information is taken from the cash records of Grouper Delivery Services: 1 The June cash receipts journal recorded $98,620 of deposits made in June. 2 The June bank statement showed total credits (deposits) of $94,500 in June. 3 At May 31, the bank reconciliation showed deposits in transit of $3,530. 4 The June bank statement shows an ending balance of $25,316. 5 At May 31, the bank reconciliation showed outstanding cheques of $14,180. 6 The June general ledger,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT