Problem 21-5 Statement of cash flows; direct method [LO21-3, 21-8]

Comparative balance sheets for 2018 and 2017 and a statement of income for 2018 are given below for Metagrobolize Industries. Additional information from the accounting records of Metagrobolize also is provided.

Additional information from the accounting records:

1. Annual payments of $20,000 on the finance lease liability are paid each January 1, beginning in 2018.
2. During 2018, equipment with a cost of $600,000 (90% depreciated) was sold.
3. The statement of shareholders' equity reveals reductions of $225,000 and $370,000 for stock dividends and cash dividends, respectively.

Required:
Prepare the statement of cash flows of Metagrobolize for the year ended December 31, 2018. Present cash flows from operating activities by the direct method. (Enter your answers in thousands (i.e., 5,000 should be entered as 5). Amounts to be deducted should be indicated with a minus sign.)

How to obtain the accumulated depreciate - Training equipment = $34,100?

How to balance the adjusted trail balance?

On 1 October, Hercules Ho sold a treadmill that costs $5,000, with accumulated depreciation of $2,000 as at 31 Dec 2017 for cash of $3,000. Hercules Ho deposited the cash into his personal bank account. Hercules Ho forgot to inform his accountant of this transaction. According to him, the cash taken by him was to be treated as a loan to him.
Both the cost of the treadmill and the accumulated depreciation were included in the amount shown for training equipment at cost and the accumulated depreciation for training equipment in the unadjusted trial balance above. The residual value of the treadmill was originally estimated to be $500.

No depreciation has been charged for the year ended 31 Dec 2018. During the year, no additional non-current assets was purchased. The company depreciates non-current assets held at 31 Dec 2018 as follows:
 Training equipment at cost - straight line over five years. The residual value of the training equipment at cost was estimated to be $15,000.

Exercise 21-27 Statement of cash flows; direct method [LO21-3, 21-5, 21-6, 21-8]

Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information from the accounting records of Red, Inc., are provided below.

Additional information from the accounting records:

1. During 2018, $241 million of equipment was purchased to replace $180 million of equipment (90% depreciated) sold at book value.
2. In order to maintain the usual policy of paying cash dividends of $61 million, it was necessary for Red to borrow $61 million from its bank.

Required:
Prepare the statement of cash flows of Red, Inc., using the direct method to report operating activities. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10). Amounts to be deducted should be indicated with a minus sign.)

Required:Journalize the transactions and the adjusting entries. If an amount box does not require an entry, leave it blank. Do not round intermediate calculations. Round your final answers to the nearest cent.

Exercise 21-17 Indirect method; reconciliation of net income to net cash flows from operating activities [LO21-4]

The accounting records of EZ Company provided the data below.

Prepare a reconciliation of net income to net cash flows from operating activities. (Amounts to be deducted should be indicated with a minus sign.)

Exercise 21-23 Cash flows from operating activities (direct method) [LO21-3]

Portions of the financial statements for Myriad Products are provided below.

Required:
Prepare the cash flows from operating activities section of the statement of cash flows for Myriad Products Company using the direct method. (Amounts to be deducted should be indicated with a minus sign. Enter your answers in millions (i.e., 10,000,000 should be entered as 10).)

Computation of deferred taxes under IFRS is slightly different from GAAP. For example, in the United Kingdom (which follows IFRS), companies use the crystallization approach. An equivalent concept in the United States is “realization.”

The concept underlying this “crystallization” approach is that companies recognize deferred income taxes only if the taxes are expected to crystallize. Therefore, if a liability is deferred indefinitely, then the present value of that liability is zero. No deferred tax liability is recognized if the accumulated deferred tax amount is expected to increase each year, thereby delaying indefinitely the ultimate liquidation of this obligation.

1. Compare and contrast the theory behind the “crystallization” approach with the inter-period allocation approach used in the U.S.
2. How might this same concept be applied to the recognition of liability for accounts payable? That is, if accounts payable are expected to increase each year, should the crystallization concept apply to this liability? Why or why not?
3. How reasonable does this approach seem? Explain.

Alpha-Tech, a rapidly growing distributor of electronic components, is formulating its plans for 20x5. Carol Jones, the firm’s marketing director, has completed the following sales forecast.

Phillip Smith, an accountant in the Planning and Budgeting Department, is responsible for preparing the cash flow projection. The following information will be used in preparing the cash flow projection.

• Alpha-Tech’s excellent record in accounts receivable collection is expected to continue. Seventy percent of billings are collected the month after the sale, and the remaining 30 percent two months after.
• The purchase of electronic components is Alpha-Tech’s largest expenditure, and each month’s cost of goods sold is estimated to be 30 percent of sales. Seventy percent of the parts are received by Alpha-Tech one month prior to sale, and 30 percent are received during the month of sale.
• Historically, 70 percent of accounts payable has been paid one month after receipt of the purchased components, and the remaining 30 percent has been paid two months after receipt.
• Hourly wages and fringe benefits, estimated to be 30 percent of the current month’s sales, are paid in the month incurred.
• General and administrative expenses are projected to be $15,670,000 for the year. The breakdown of these expenses is presented in the following schedule. All cash expenditures are paid uniformly throughout the year, except the property taxes, which are paid in four equal installments at the end of each quarter.

  20x5 Forecasted General and Administrative Costs
  (in thousands)
  Salaries and fringe benefits	$	3,000
  Promotion		3,500
  Property taxes		1,330
  Insurance		2,830
  Utilities		1,500
  Depreciation		3,510
  Total	$	15,670

• Income-tax payments are made at the beginning of each calendar quarter based on the income of the prior quarter. Alpha-Tech is subject to an income-tax rate of 40 percent. Alpha-Tech’s operating income for the first quarter of 20x5 is projected to be $3,000,000. The company pays 100 percent of the estimated tax payment.
• Alpha-Tech maintains a minimum cash balance of $510,000. If the cash balance is less than $510,000 at the end of each month, the company borrows amounts necessary to maintain this balance. All amounts borrowed are repaid out of the subsequent positive cash flow. The projected April 1, 20x5, opening balance is $510,000.
• Alpha-Tech has no short-term debt as of April 1, 20x5.
• Alpha-Tech uses a calendar year for both financial reporting and tax purposes.

Required:

1. Prepare a cash budget for Alpha-Tech by month for the second quarter of 20x5. For simplicity, ignore any interest expense associated with borrowing. (Negative amounts should be indicated by a minus sign.)

On June 2, 2018, Lokar Corporation purchases a patent for $68,000 from the inventor of a new extrusion process. The patent has 12 years remaining on its legal life. Also, Lokar purchases substantially all the assets of the Barrios Corporation for $750,000 on September 8, 2018. The values of the assets listed in the purchase agreement are as follows:

Refer to the MACRS Depreciation Table to answer the following question.

Note: In your calculations, round amortization percentages to two decimal places, and dollar amounts to the nearest whole dollar. Assume the equipment has a MACRS recovery period of 7 years and that the full election expense is taken in the year of acquisition.

The maximum 2018 cost-recovery deductions for the tangible and intangible assets purchased is $

What the main purpose of the consolidation entries for intercompany sale of inventory and long term asset transactions. I hope you can clearly clarify this for me.

Selected balance sheet and income statement information from CVS Health Corp. for 2014 through 2016 follows ($ millions).

a. Compute times interest earned ratio for each year and discuss any trends for each. Round answers to one decimal place.

Based on your computations above, select the most appropriate answer.

Times interest earned has steadily increased since 2014.

Times interest earned has steadily decreased since 2014.

Times interest earned has remained the same since 2014.

Times interest earned increased in 2015 but then decreased in 2016.

b. Compute the current ratio for each year and discuss any trend in liquidity. Round answers to one decimal place.

Do you believe the company is sufficiently liquid? Explain.

CVS’s current ratio has increased over the past three years and is greater than 1, indicating CVS is liquid.

CVS’s current ratio has decreased over the past three years and it is currently less than 1 indicating CVS is not liquid.

CVS’s current ratio has increased over the past three years, however, it remains less than 1 indicating CVS is not liquid.

CVS’s current ratio has decreased over the past three years, however, it is greater than 1 indicating CVS is liquid.

c. Compute the total liabilities-to-equity ratio for each year and discuss any trends for each.

Round answers to one decimal place.

Based on your computations above, select the most appropriate answer.

CVS's liabilities to equity ratio has increased since 2014, however, the ratio is relatively low, concluding CVS is solvent.

CVS's liabilities to equity ratio has decreased since 2014, remaining relatively low, concluding CVS is solvent.

CVS's liabilities to equity ratio has increased since 2014, and is relatively high, concluding CVS is insolvent.

CVS's liabilities to equity ratio has decreased since 2014, remaining relatively low, concluding CVS is insolvent.

d. What is your overall assessment of the company’s credit risk from the analyses in (a), (b), and (c)?

CVS is a low credit risk as it has a low level of debt, is liquid and can easily meet its interest expenses.

CVS is a low credit risk as its liabilities to equity ratio, current ratio, and times interest earned ratio have all decreased since 2014.

CVS is a medium to high credit risk as its level of debt has increased and its current ratio and times interest ratio have decreased.

CVS is a medium to high credit risk as its liabilities to equity ratio, current ratio, and times interest earned ratio have all increased since 2014.

Badlands, Inc. manufactures a household fan that sells for $40 per unit. All sales are on account, with 30 percent of sales collected in the month of sale and 70 percent collected in the following month. The data that follow were extracted from the company’s accounting records.

• Badlands maintains a minimum cash balance of $14,000. Total payments in January 20x1 are budgeted at $220,000.
• A schedule of cash collections for January and February of 20x1 revealed the following receipts for the period:

  	Cash Receipts
  	January			February
  From December 31 accounts receivable	$	112,000
  From January sales		94,000		$	150,000
  From February sales					65,400

• March 20x1 sales are expected to total 5,000 units.
• Finished-goods inventories are maintained at 30 percent of the following month’s sales.
• The December 31, 20x0, balance sheet revealed the following selected figures: cash, $24,300; accounts receivable, $112,000; and finished goods, $25,050.

1. Determine the number of units that Badlands sold in December 20x0.

2. Compute the sales revenue for March 20x1.

3. Compute the total sales revenue to be reported on Badlands’ budgeted income statement for the first quarter of 20x1.

4. Determine the accounts receivable balance to be reported on the March 31, 20x1, budgeted balance sheet.

5. Calculate the number of units in the December 31, 20x0, finished-goods inventory.

6. Calculate the number of units of finished goods to be manufactured in January 20x1.

7. Calculate the financing required in January, if any, to maintain the firm’s minimum cash balance.

Mary and Kay, Inc., a distributor of cosmetics throughout Florida, is in the process of assembling a cash budget for the first quarter of 20x1. The following information has been extracted from the company’s accounting records:

• All sales are on account. Sixty percent of customer accounts are collected in the month of sale; 30 percent are collected in the following month. Uncollectibles amounting to 10 percent of sales are anticipated, and management believes that only 20 percent of the accounts outstanding on December 31, 20x0, will be recovered and that the recovery will be in January 20x1.

• Sixty percent of the merchandise purchases are paid for in the month of purchase; the remaining 40 percent are paid for in the month after acquisition.

• The December 31, 20x0, balance sheet disclosed the following selected figures: cash, $55,000; accounts receivable, $220,000; and accounts payable, $77,000.

• Mary and Kay, Inc. maintains a $55,000 minimum cash balance at all times. Financing is available (and retired) in $1,000 multiples at an 9 percent interest rate, with borrowings taking place at the beginning of the month and repayments occurring at the end of the month. Interest is paid at the time of repaying principal and computed on the portion of principal repaid at that time.

• Additional data:

1.Prepare a schedule that discloses the firm’s total cash collections for January through March.

2. Prepare a schedule that discloses the firm’s total cash disbursements for January through March.

3. Prepare a schedule that summarizes the firm’s financing cash flows for January through March.

1-. Write the General Ledger and Reporting General Controls used in companies to overcome the threats.

2- Identify the three basic rules that apply to the REA model pattern

Accounting Information System

The following transaction refers to one of the Districts a. The District issues general obligation bonds in the amount of $900,000, receiving cash for the full-face amount of the bonds. The cash will be used to buy capital assets. b. The District buys a prefabricated building for $750, 000, using part of the bond proceeds. The building is delivered and the invoice for the building is approved. c. The invoice approved in b. is paid. d. The General Fund transfers cash of $55,000 to another fund in anticipation of the payment of the first installment of interest ($30,000) and principal ($25,000) on the debt. e. The first installment of debt service on bonds issued in ‘a’ becomes due and payable. f. Debt service on the bonds issued in a. is paid

Required

Prepare entries to record the above transactions related to acquisition of capital assets by a district. Identify the fund(s) used. The District uses encumbrance accounting