Question

In: Accounting

The following data are for the 2016 fiscal year of Alphabet, Inc., which is the parent...

The following data are for the 2016 fiscal year of Alphabet, Inc., which is the parent company of Google, Inc., and Facebook, Inc. All dollar amounts are in thousands.

Account Title

Alphabet, Inc.

Facebook, Inc.

Current assets

$105,408

$34,401

Total assets

  167,497

64,961

Current liabilities

   16,756

2,875

Total liabilities

    28,461

5,767

Stockholders’ equity

139,036

59,194   

Interest expense

124

10   

Income tax expense

4,672

2,301

Net income

19,478

10,217

Required

  1. Calculate the EBIT for each company.
    1. Calculate each company’s debt-to-assets ratio, current ratio, and the times-interest-earned ratio.
    2. Calculate each company’s return-on-assets ratio using EBIT instead of net earnings. Calculate each company’s return-on-equity ratio using net earnings.
    3. Alphabet reported interest expense of $124 million, before taxes. What was its after-tax interest expense in dollars? (Hint: You will need to compute its tax rate by dividing income tax expense by earnings before taxes, which must be computed.)

    Solutions

    Expert Solution

    a)

    EBIT of Alphabet, Inc. = Net income + Income tax expense + Interest expense

    = 19,478 + 4,672 + 124

    = $24,274

    EBIT of Facebook, Inc. = Net income + Income tax expense + Interest expense

    = 10,217 + 2,301 + 10

    = $12,528

    b)

    For Alphabet, Inc.

    Debt to assets ratio = Total liabilities/Total assets

    = 28,461/167,497

    = 0.17

    Current ratio = Current assets/Current liabilities

    = 105,408/16,756

    = 6.29

    Times interest earned = EBIT/Interest expense

    = 24,274/124

    = 195.76

    For Facebook, Inc.

    Debt to assets ratio = Total liabilities/Total assets

    = 5,767/64,961

    = 0.09

    Current ratio = Current assets/Current liabilities

    = 34,401/2,875

    = 11.97

    Times interest earned = EBIT/Interest expense

    = 12,528/10

    = 1,252.8

    c)

    For Alphabet, Inc.

    Return on assets = EBIT/Total assets

    = 24,274/167,497

    = 14.49%

    Return on equity = Net income/Equity

    = 19,478/139,036

    = 14%

    For Facebook, Inc.

    Return on assets = EBIT/Total assets

    = 12,528/64,961

    = 19.28%

    Return on equity = Net income/Equity

    = 10,217/59,194

    = 17.26%

    d)

    Earnings before tax = Net income + Income tax expense

    = 19,478 + 4,672

    = $24,150

    Income tax rate = Income tax expense/Earnings before tax

    = 4,672/24,150

    = 19.35%

    After-tax interest expense in dollars = interest expense x (1 - tax rate)

    = 124 x (1 - 0.1935)

    = $100

    Note: Exact answers may slightly vary due to rounding off.


    Related Solutions

    The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: 2016...
    The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: 2016 July 1 Issued $71,100,000 of 20-year, 12% callable bonds dated July 1, 2016, at a market (effective) rate of 14%, receiving cash of $61,621,133. Interest is payable semiannually on December 31 and June 30. Oct. 1 Borrowed $250,000 by issuing a six-year, 5% installment note to Nicks Bank. The note requires annual payments of $49,254, with the first payment occurring on September 30, 2017....
    The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: 2016...
    The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: 2016 July 1 Issued $39,500,000 of 20-year, 7% callable bonds dated July 1, 2016, at a market (effective) rate of 8%, receiving cash of $35,590,960. Interest is payable semiannually on December 31 and June 30. Oct. 1 Borrowed $200,000 by issuing a six-year, 4% installment note to Nicks Bank. The note requires annual payments of $38,152, with the first payment occurring on September 30, 2017....
    The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: 2016...
    The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: 2016 July 1 Issued $71,100,000 of 20-year, 12% callable bonds dated July 1, 2016, at a market (effective) rate of 14%, receiving cash of $61,621,133. Interest is payable semiannually on December 31 and June 30. Oct. 1 Borrowed $250,000 by issuing a six-year, 5% installment note to Nicks Bank. The note requires annual payments of $49,254, with the first payment occurring on September 30, 2017....
    Waymo is a division of Alphabet (Google’s parent company) that is developing the technology for driverless...
    Waymo is a division of Alphabet (Google’s parent company) that is developing the technology for driverless cars. Waymo CEO John Krafcik is under pressure to offer a commercial driverless taxi service in the Phoenix area as soon as Fall 2018. Analysis at web-site arstechnica.com suggests that Waymo has by far the most advanced technology available for this type of service. Is it likely that being first into this market will give them a large advantage? Is Waymo likely to earn...
    Aiello, Inc. had the following inventory in fiscal 2016. Beginning Inventory, January 1, 2016: 130 units...
    Aiello, Inc. had the following inventory in fiscal 2016. Beginning Inventory, January 1, 2016: 130 units @ $15.00 Purchase 200 units @ $18.00 Purchase 50 units @ $13.50 Purchase 110 units @ $15.75 Total units sold during the month is 370. a) Compute the company’s cost of goods sold and ending inventory for fiscal 2016 assuming the company used FIFO b) Compute the company’s cost of goods sold and ending inventory for fiscal 2016 assuming the company used LIFO methods...
    The following events apply to Gulf Seafood for the 2016 fiscal year:    1. The company...
    The following events apply to Gulf Seafood for the 2016 fiscal year:    1. The company started when it acquired $37,000 cash by issuing common stock. 2. Purchased a new cooktop that cost $14,900 cash. 3. Earned $21,300 in cash revenue. 4. Paid $14,000 cash for salaries expense. 5. Adjusted the records to reflect the use of the cooktop. Purchased on January 1, 2016, the cooktop has an expected useful life of five years and an estimated salvage value of...
    At the end of the December 31 2016 fiscal year, Yin trucking corporation which follows IFRS...
    At the end of the December 31 2016 fiscal year, Yin trucking corporation which follows IFRS 16, negotiated and closed a long term lease contract for newly constructed truck terminals and freight storage facilities. The buildings were erected to the company’s specifications on land owned by the company. On January 1 2017, Yin trucking corporation took possession of the leased properties and made a cash payment of 1,048,00$. Although the useful life of each terminal is 40 years, the non...
    Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016...
    Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016 (ending January 28, 2017).                Current Forecast Horizon Terminal Year ($ millions) 2016 2017 2018 2019 2020 Total revenues $69,495 $71,580 $73,727 $75,939 $78,217 $78,999 Net operating profit after tax (NOPAT)    3,302      3,436     3,539     3,645     3,754 3,792 Net operating assets (NOA) 21,128 21,757 22,409 23,082 23,774 24,012 Forecast assumptions and other financial information for Target are as follows: Revenue...
    Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016...
    Following are financial statement numbers and select ratios for Target Corp. for the fiscal year 2016 (ending January 28, 2017).                Current Forecast Horizon Terminal Year ($ millions) 2016 2017 2018 2019 2020 Total revenues $69,495 $71,580 $73,727 $75,939 $78,217 $78,999 Net operating profit after tax (NOPAT)    3,302      3,436     3,539     3,645     3,754 3,792 Net operating assets (NOA) 21,128 21,757 22,409 23,082 23,774 24,012 Forecast assumptions and other financial information for Target are as follows: Revenue...
    The following information is available for Marin Inc. for three recent fiscal years. 2017 2016 2015...
    The following information is available for Marin Inc. for three recent fiscal years. 2017 2016 2015 Inventory $546,328 $571,700 $326,238 Net sales 1,934,372 1,695,980 1,327,594 Cost of goods sold 1,554,675 1,312,366 964,008 Calculate the inventory turnover, days in inventory, and gross profit rate for 2017 and 2016. (Round inventory turnover to 1 decimal place, e.g. 5.2, days in inventory to 0 decimal places, e.g. 125 and gross profit rate to 1 decimal place, e.g. 5.2%.) 2017 2016 Inventory Turnover times...
    ADVERTISEMENT
    ADVERTISEMENT
    ADVERTISEMENT