Question

Qualcomm Balance Sheet	2020
Cash & Short Term Investments	12,260
Cash Only	11,839
Short-Term Investments	421
Cash & Short Term Investments Growth	1.42%
Cash & ST Investments / Total Assets	37.20%
Total Accounts Receivable	2,471
Accounts Receivables, Net	2,457
Accounts Receivables, Gross	2,504
Bad Debt/Doubtful Accounts	-47
Other Receivables	14
Accounts Receivable Growth	-14.91%
Accounts Receivable Turnover	9.82
Inventories	1,400
Finished Goods	656
Work in Progress	667
Raw Materials	77
Other Current Assets	634
Miscellaneous Current Assets	634
Total Current Assets	16,765
Net Property, Plant & Equipment	3,081
Property, Plant & Equipment - Gross	7,648
Buildings	1,546
Land & Improvements	170
Machinery & Equipment	4,007
Construction in Progress	182
Computer Software and Equipment	1,356
Other Property, Plant & Equipment	387
Accumulated Depreciation	4,567
Total Investments and Advances	1,130
LT Investment - Affiliate Companies	343
Other Long-Term Investments	787
Intangible Assets	8,454
Net Goodwill	6,282
Net Other Intangibles	2,172
Other Assets	2,331
Tangible Other Assets	2,331
Total Assets	32,957
Assets - Total - Growth	0.73%
Asset Turnover	0.74
Return On Average Assets	13.36%
Qualcomm Income Statement	2020
Sales/Revenue	24,273
Sales Growth	7.35%
Cost of Goods Sold (COGS) incl. D&A	8,596
COGS excluding D&A	7,195
Depreciation & Amortization Expense	1,401
Depreciation	674
Amortization of Intangibles	727
COGS Growth	-15.72%
Gross Income	15,677
Gross Income Growth	26.31%
Gross Profit Margin	64.59%
SG&A Expense	7,596
Research & Development	5,398
Other SG&A	2,198
SGA Growth	-12.25%
EBIT	8,081
Unusual Expense	563
Non Operating Income/Expense	367
Non-Operating Interest Income	316
Equity in Affiliates (Pretax)	-93
Interest Expense	627
Interest Expense Growth	-18.36%
Gross Interest Expense	627
Pretax Income	7,481
Pretax Income Growth	1808.42%
Pretax Margin	30.82%
Income Tax	3,095
Income Tax - Current Domestic	1,565
Income Tax - Current Foreign	-407
Income Tax - Deferred Domestic	2,054
Income Tax - Deferred Foreign	-117
Consolidated Net Income	4,386
Minority Interest Expense	-
Net Income	4,386
Net Income Growth	188.36%
Net Margin	18.07%
Net Income After Extraordinaries	4,386
Net Income Available to Common	4,386
EPS (Basic)	3.6
EPS (Basic) Growth	205.96%
Basic Shares Outstanding	1,210
EPS (Diluted)	3.6
EPS (Diluted) Growth	205.95%
Diluted Shares Outstanding	1,220
EBITDA	9,482
EBITDA Growth	78.33%
EBITDA Margin	39.06%
EBIT	8,081

Prepare a common size income statement and balance sheet for each

Answer 1

Qualcomm Balance Sheet	2020		%	%
Cash Only	11,839		35.92%
Short-Term Investments	421		1.28%
Cash & Short Term Investments	12,260	12,260	37.20%	37.20%
Accounts Receivables, Gross	2,504		7.60%	0.00%
Bad Debt/Doubtful Accounts	-47		-0.14%
Accounts Receivables, Net	2,457		7.46%
Other Receivables	14		0.04%
Total Accounts Receivable		2,471		7.50%
Inventories:
Finished Goods	656		1.99%
Work in Progress	667		2.02%
Raw Materials	77		0.23%
Total Inventories		1400		4.25%
Other Current Assets		634		1.92%
Total Current Assets		16,765		50.87%
Deffered Tax Assets		1196		3.63%
Net Property, Plant & Equipment:
Buildings	1,546		4.69%
Land & Improvements	170		0.52%
Machinery & Equipment	4,007		12.16%
Construction in Progress	182		0.55%
Computer Software and Equipment	1,356		4.11%
Other Property, Plant & Equipment	387		1.17%
Property, Plant & Equipment - Gross	7,648		23.21%
Accumulated Depreciation	-4,567		-13.86%
Net Property, Plant & Equipment		3,081		9.35%
Investments and Advances:
LT Investment - Affiliate Companies	343		1.04%
Other Long-Term Investments	787		2.39%
Total Investments and Advances		1130		3.43%
Intangible Assets:
Net Goodwill	6,282		19.06%
Net Other Intangibles	2,172		6.59%
Total Intangible Assets		8,454		25.65%
Tangible Other Assets		2,331		7.07%
Total Assets		32,957		100.00%
Qualcomm Income Statement	2020		%	%
Sales/Revenue		24,273		100%
COGS excluding D&A	7,195		30%	0%
Depreciation & Amortization Expense	1401		6%	0%
Cost of Goods Sold (COGS) incl. D&A		8,596	0%	35%
Gross Income		15,677	0%	65%
Operating expenses			0%	0%
Research & Development	5,398		22%	0%
Other SG&A	2,198		9%	0%
Other Operating Expense	0		0%	0%
Total operating expenses		7,596	0%	31%
Income from operations		8,081	0%	33%
Unusual Expense		563	0%	2%
Non-Operating Interest Income		367	0%	2%
Non-Operating Interest Exp.		-316	0%	-1%
Equity in Affiliates (Pretax)		-93
Interest Expense		-627	0%	-3%
Pretax Income		7,481	0%	31%
Income Tax - Current Domestic	1565		6%
Income Tax - Current Foreign	-407		-2%
Income Tax - Deferred Domestic	2054		8%
Income Tax - Deferred Foreign	-117		0%
Income Tax		3095		13%
Net Income		4,386		18%

D E F G H Qualcomm Balance Sheet 2020 =E3+E4 11839 421 12260 2504 -47 =E6+E7 14 =E3/$F$38 =E4/$F$38 =E5/$F$38 =E6/$F$38 =E7/$F$38 =E8/$F$38 =E9/$F$38 =F5/$F$38 =F6/$F$38 =E8+E9 =F10/$F$38 656 667 77 =E12/$F$38 =E13/$F$38 =E14/$F$38 =SUM(E12:E14) 634 =F5+F10+F15+F16 1196 =F15/$F$38 =F16/$F$38 =F17/$F$38 =F18/$F$38 Cash Only Short-Term Investments Cash & Short Term Investments Accounts Receivables, Gross Bad Debt/Doubtful Accounts Accounts Receivables, Net Other Receivables Total Accounts Receivable Inventories: Finished Goods Work in Progress Raw Materials Total Inventories Other Current Assets Total Current Assets Deffered Tax Assets Net Property, Plant & Equipment: Buildings Land & Improvements Machinery & Equipment Construction in Progress Computer Software and Equipment Other Property, Plant & Equipment Property, Plant & Equipment - Gross Accumulated Depreciation Net Property, Plant & Equipment Investments and Advances: LT Investment - Affiliate Companies Other Long-Term Investments Total Investments and Advances Intangible Assets: Net Goodwill Net Other Intangibles Total Intangible Assets 1546 170 4007 182 1356 387 =SUM(E20:E25) -4567 =E20/$F$38 =E21/$F$38 =E22/$F$38 =E23/$F$38 =E24/$F$38 =E25/$F$38 =E26/$F$38 =E27/$F$38 -E26+E27 =F28/$F$38 343 787 =E30/$F$38 =E31/$F$38 =E30+E31 =F32/$F$38 6282 2172 =E34/$F$38 =E35/$F$38 =E34+E35 =F36/$F$38

A B B с D D E F G H 6282 2172 8454 6282 2172 2331 2331 32957 0.0073 0.74 0.1336 Intangible Assets: Net Goodwill Net Other Intangibles Total Intangible Assets Tangible Other Assets Total Assets =E34/$F$38 =E35/$F$38 =E34+E35 2331 =F17+F28+F32+F36+F37+ =F36/$F$38 =F37/$F$38 =F38/$F$38 2020 % =B45 7195 1401 =E42+E43 =F41-F44 5398 2198 0 33 Intangible Assets 34 Net Goodwill 35 Net Other Intangibles 36 Other Assets 37 Tangible Other Assets 38 Total Assets 39 Assets - Total - Growth 40 Asset Turnover 41 Return On Average Assets 42 43 . 44 Qualcomm Income Statement 45 Sales/Revenue 46 Sales Growth 47 Cost of Goods Sold (COGS) incl. D&A 48 COGS excluding D&A 49 Depreciation & Amortization Expense preciation 50 Depreciation . 51 Amortization of Intangibles 52 COGS Growth 53 Gross Income 54 Gross Income Growth 55 Gross Profit Margin 56 SG&A Expense 57 Research & Development 58 Other SG&A 59 SGA Growth 60 EBIT 61 Unusual Expense 62 Non Operating Income/Expense 63 Non-Operating Interest Income 64 Equity in Affiliates (Pretax) 65 Interest Expense 66 Interest Expense Growth 67 Gross Interest Expense 68 Pretax Income Qualcomm Income Statement Sales/Revenue COGS excluding D&A Depreciation & Amortization Expense Cost of Goods Sold (COGS) incl. D&A DA Gross Income Operating expenses Pelang Research & Development acced Other SG&A Other Operating Expense Total operating expenses Income from operations Unusual Expense Non-Operating Interest Income Non-Operating Interest Exp. repera Equity in Affiliates (Pretax) Interest Expense Pretax Income Income Tax - Current Domestic Income Tax - Current Foreign Income Tax - Deferred Domestic Income Tax - Deferred Foreign Income Tax Net Income =E42/$F$41 =E43/$F$41 =E44/$F$41 =E45/$F$41 exceea =E46/$F$41 een =E47/$F$41 ** =E48/$F$41 . =E49/$F$41 . =E50/$F$41 verent =E51/$F$41 =E52/$F$41 =E53/$F$41 =E54/$F$41 % =F41/$F$41 =F42/$F$41 =F43/$F$41 =F44/$F$41 =F45/$F$41 =F46/$F$41 =F47/$F$41 =F48/$F$41 =F49/$F$41 =F50/$F$41 =F51/$F$41 =F52/$F$41 =F53/$F$41 =F54/$F$41 2020 24273 0.0735 8596 7195 1401 674 727 -0.1572 15677 0.2631 0.6459 7596 5398 e 2198 -0.1225 8081 303 563 367 307 316 31 -93 627 -0.1836 =E47+E48 =F45-F50 563 367 -316 -93 -627 7481 =F56/$F$41 =F57/$F$41 1565 -407 2054 -117 =E56/$F$41 =E57/$F$41 =E58/$F$41 =E59/$F$41 =E60/$F$41 =E61/$F$41 =SUM(E58:E61) =F57-F62 =F62/$F$41 =F63/$F$41 627 7481 10 0012 60 Dratav Inroma Granth