Using the data in the Alphabet Financials.xlsx:

Data from Alphabet Financials.xlsx

Alphabet Inc. Class C
Income Statement (Industrial)
All figures in millions of U.S. Dollar.
	6/30/2019	3/31/2019	12/31/2018	9/30/2018	6/30/2018	3/31/2018	12/31/2017	9/30/2017	6/30/2017	3/31/2017	12/31/2016	9/30/2016	6/30/2016	3/31/2016	12/31/2015	9/30/2015	6/30/2015	3/31/2015	12/31/2014	9/30/2014	6/30/2014	3/31/2014	12/31/2013	9/30/2013
Sales	38,836	36,202	39,151	33,656	32,758	31,393	32,521	27,963	26,007	24,533	25,877	22,346	21,422	20,088	20,998	18,389	17,256	16,947	17,956	16,513	15,949	15,412	16,855	14,871
Cost of Goods Sold (COGS) incl. D&A	17,296	16,012	17,918	14,281	13,883	13,467	14,267	11,148	10,373	9,795	10,661	8,699	8,130	7,648	8,188	7,037	6,583	6,356	6,921	6,317	6,114	5,961	7,443	6,413
Gross Income	21,540	20,190	21,233	19,375	18,875	17,926	18,254	16,815	15,634	14,738	15,216	13,647	13,292	12,440	12,810	11,352	10,673	10,591	11,035	10,196	9,835	9,451	9,412	8,458
SG&A Expense	12,468	12,022	13,155	11,149	10,896	10,678	10,392	8,842	8,769	8,387	8,764	7,985	7,402	7,267	7,761	6,930	6,319	6,455	6,783	6,104	5,583	5,344	5,522	5,025
EBIT (Operating Income)	9,072	8,168	8,078	8,226	7,979	7,248	7,862	7,973	6,865	6,351	6,452	5,662	5,890	5,173	5,049	4,422	4,354	4,136	4,252	4,092	4,252	4,107	3,890	3,433
Nonoperating Interest Income	653	522	542	481	456	399	400	306	294	312	325	318	307	270	274	259	240	226	222	187	169	168	215	201
Equity in Earnings of Affiliates	(16)	(40)	19	(27)	(105)	(7)	(63)	(31)	(13)	(49)	7	(61)	(43)	(105)	-	-	-	-	-	-	-	-	-	-
Other Income (Expense)	(341)	363	1,710	277	226	378	(198)	(234)	(15)	401	(37)	321	128	129	(30)	297	452	378	(64)	33	79	182	(81)	(77)
Interest Expense	25	35	29	28	27	30	36	27	21	25	33	29	32	30	26	26	26	26	25	25	27	24	21	22
Unusual Expense - Net	(2,804)	832	248	(1,154)	4,314	(2,555)	(53)	8	2,733	171	(143)	166	131	308	67	61	64	110	(142)	430	70	(39)	(44)	67
Pretax Income	12,147	8,146	10,072	10,083	4,215	10,543	8,018	7,979	4,377	6,819	6,857	6,045	6,119	5,129	5,200	4,891	4,956	4,604	4,527	3,857	4,403	4,472	4,047	3,468
Income Taxes	2,200	1,489	1,124	891	1,020	1,142	11,038	1,247	853	1,393	1,524	984	1,242	922	277	912	1,025	1,018	737	859	913	822	666	513
Other After Tax Adjustments	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	(522)	-	-	-	-	-	-	-
Net Income	9,947	6,657	8,948	9,192	3,195	9,401	(3,020)	6,732	3,524	5,426	5,333	5,061	4,877	4,207	4,923	3,979	3,409	3,586	3,790	2,998	3,490	3,650	3,381	2,955
Discontinued Operations	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	227	(185)	(68)	(198)	-	-
Net Income available to Common	9,947	Fantastic news! We've Found the answer you've been seeking! Answer rating: 66% (6 reviews) To solve a question using the data provided from Alphabet Financialsxlsx its crucial to have a clear ...View the full answer Answered By Shebla K I am an MBA graduate having experience as an Assistant Professor at University level for two years. I always prepare well for a class as I believe that only if you become an ocean you can give a bucket of water. Being a teacher was not only my profession but also my passion. 5.00+ 1+ Reviews 10+ Question Solved Related Book For   Financial Analysis With Microsoft Excel ISBN: 9780357442050 9th Edition Authors: Timothy R. Mayes See More Books Question Posted: May 15, 2023 03:32 AM See More Questions Students also viewed these Business questions Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank... The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan... A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first... After the car reaches 1 0 0 km / hthe driver immediately steps on the brakes and comes to a stop in 2 . 5 5 s . The brakes are at a distance 1 5 . 9 cm from the center of the wheel and the force they... Determine the sample size necessary under the following conditions. a. To estimate with = 44,E = 3,and 95% confidence b. To estimate with a range of values from 20 to 88 with E = 2 and 90%... Randy and Joseph share profits and losses in a 7:3 ratio. Partnership books show the following before liquidation: Cash: P 30, 000; A/R (net): P 380, 000; Inventory: P 260, 000; Furniture (net): P... E 7-7 Parent purchases subsidiary bonds Comparative balance sheets of Pam and Sun Corporations at December 31, 2016, follow: Pam Sun Assets Accounts receivablenet $ 2,048,600 $ 600,000 Interest... Following are income statements for Hossa Corporation for 2017 and 2016. Percentage of sales amounts are also shown for each operating expense item. Hossas income tax rate was 38% in 2016 and 40% in... Beginning inventory, purchases, and sales data for prepaid cell phones for December are as follows: Inventory Dec. 1 1 , 6 0 0 units at $ 3 3 Purchases Dec. 1 0 8 0 0 units at $ 3 5 2 0 7 2 0 units... The Socrates II European program supports cooperation in education in eight areas, from school to higher education, from new technologies, to adult learners. Within Socrates II is the program Erasmus... Using the same workbook, copy both datasets into one worksheet so that they can be used together in a pivot table. Transpose them using Paste Special Transpose. Data from Alphabet Financials.xlsx... You are considering investing in the following securities and have developed the probability distributions for their returns over the next year. a. Calculate the expected return and standard... Green Consultants Pty Ltd specialise in consulting on landscape design. The company developed a predetermined charge-out rate based on hours for each of its consultants on 1 July 2025 to assign the... Juanita Poblamo makes large ceramic pots for use in outdoor landscape. She currently has two models, one square and the other round. Because of the size of Juanitas creations, only one pot can be... EPI educational products are currently sold without any supplemental materials. The company is considering the inclusion of instructional materials such as an overhead slide presentation, potential... EPI is considering eliminating a product from its ToddleTown Tours collection. This collection is aimed at children one to three years of age and includes tours of a hypothetical town. Two products,... Suppose we estimate the model y i = + u i , where u i N [ 0 , i 2 ] . (a) Show that the OLS estimator of simplifies to ^ = y . (b) Hence directly obtain the variance of y . Show that this... This question presumes access to software that allows NLS and ML estimation. Consider the gamma regression model of Exercise 5-2. An appropriate gamma variate can be generated using \(y=-\lambda \ln... Suppose that the current Canadian dollar (CAD) to U.S. dollar exchange rate is $.85 CAD = $1 US and that the U.S. dollar price of an Apple iPhone is $300. What is the Canadian dollar price of an... Complete problem P10-21 using ASPE. Data from P10-21 Original cost ................................................................. $7,000,000 Accumulated depreciation... ArroySnackfoods is considering replacing a five-year-old machine that originally cost $50,000. It was being depreciated using straight-line to an expected salvage value of zero over its original... Chicago Turkey is considering a new turkey farm to service its western region stores. The stores currently require 650,000 turkeys per year, and they are purchased from various local turkey farms for... The Chief Financial Officer of Eaton Medical Devices has determined that the firm's capital investment budget will be $5,000,000 for the upcoming year. Unfortunately, this amount is not sufficient to... the internal operation rulea of cooperation are known As ? "When it comes to audit sampling, both statistical and non-statistical sampling are equally effective." Defend or refute the preceding statement. (1 Mark). ACC 2 0 2 Milestone One: Operational Costs Data Appendix You plan to open a small business for manufacturing pet collars, leashes, and harnesses. You have found a workshop space you can use for... Science Matters Achieving Scientific Literacy Revised Edition - ISBN: 0307454584 - Free Book Study smarter with the SolutionInn App Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Company Info Security Copyrights Privacy Policy Terms & Condition SolutionInn Fee Scholarship Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Copyright © 2024 SolutionInn All Rights Reserved. Get the SolutionInn - Study Help App