Question

Nvidia Balance Sheet	2020
Cash & Short Term Investments	10,897
Cash Only	10,896
Short-Term Investments	1
Cash & Short Term Investments Growth	46.82%
Cash & ST Investments / Total Assets	62.93%
Total Accounts Receivable	1,657
Accounts Receivables, Net	1,657
Accounts Receivables, Gross	1,659
Bad Debt/Doubtful Accounts	-2
Accounts Receivable Growth	16.36%
Accounts Receivable Turnover	6.59
Inventories	979
Finished Goods	465
Work in Progress	265
Raw Materials	249
Other Current Assets	157
Miscellaneous Current Assets	157
Total Current Assets	13,690
Net Property, Plant & Equipment	2,292
Property, Plant & Equipment - Gross	3,303
Buildings	340
Land & Improvements	218
Machinery & Equipment	532
Construction in Progress	320
Leases	-
Computer Software and Equipment	908
Other Property, Plant & Equipment	367
Accumulated Depreciation	1,011
Intangible Assets	667
Net Goodwill	618
Net Other Intangibles	49
Other Assets	118
Tangible Other Assets	118
Total Assets	17,315
Assets - Total - Growth	30.27%
Asset Turnover	0.71
Return On Average Assets	18.27%
Nvidia Income Statement	2020
Sales/Revenue	10,918
Sales Growth	-6.81%
Cost of Goods Sold (COGS) incl. D&A	4,135
COGS excluding D&A	3,754
Depreciation & Amortization Expense	381
Depreciation	356
Amortization of Intangibles	25
COGS Growth	-8.17%
Gross Income	6,783
Gross Income Growth	-5.96%
Gross Profit Margin	62.13%
SG&A Expense	3,892
Research & Development	2,829
Other SG&A	1,063
SGA Growth	15.66%
Other Operating Expense	-
EBIT	2,891
Unusual Expense	45
Non Operating Income/Expense	-2
Non-Operating Interest Income	178
Interest Expense	52
Interest Expense Growth	-10.34%
Gross Interest Expense	52
Pretax Income	2,970
Pretax Income Growth	-23.77%
Pretax Margin	27.20%
Income Tax	174
Income Tax - Current Domestic	69
Income Tax - Current Foreign	87
Income Tax - Deferred Domestic	2
Income Tax - Deferred Foreign	16
Consolidated Net Income	2,796
Net Income	2,796
Net Income Growth	-32.48%
Net Margin	25.61%
Net Income After Extraordinaries	2,796
Net Income Available to Common	2,796
EPS (Basic)	4.52
EPS (Basic) Growth	-31.76%
Basic Shares Outstanding	609
EPS (Diluted)	4.52
EPS (Diluted) Growth	-31.72%
Diluted Shares Outstanding	618
EBITDA	3,272
EBITDA Growth	-20.43%
EBITDA Margin	29.97%
EBIT	2,891

Prepare a common size income statement and balance sheet for each.

Answer 1

Nvidia Balance Sheet	2020		%	%
Cash & Short Term Investments		10,897		62.9%
Accounts Receivables, Gross	1,659		9.6%
Bad Debt/Doubtful Accounts	-2		-0.012%
Accounts Receivables, Net		1,657		9.6%
Inventories
Finished Goods	465		2.7%
Work in Progress	265		1.5%
Raw Materials	249	979	1.4%	5.7%
Miscellaneous Current Assets		157		0.9%
Total Current Assets		$  13,690.00		79.1%
Property, Plant & Equipment - Gross	3303		19.1%	0.0%
less :Accumulated Depreciation	-1011		-5.8%	0.0%
Net Property, Plant & Equipment		2,292		13.2%
Net Goodwill		618		3.6%
Net Other Intangibles		49		0.3%
Deferred income tax assets		548		3.2%
Other Assets		118		0.7%
Total Assets		17,315		100.0%
Nvidia Income Statement	2020		%	%
Sales/Revenue		10,918		100%
COGS excluding D&A	3,754		34%
Depreciation & Amortization Expense	381		3%
Cost of Goods Sold (COGS) incl. D&A		4,135		38%
Gross Income		6,783		62%
Operating expenses
Research & Development	2,829		26%
Other SG&A	1,063		10%
Other Operating Expense	0
Total operating expenses		3,892		36%
Income from operations		2,891		26%
Unusual Expense		45		0%
EBIT		2,846		26%
Interest Expense		-2		0%
Non-Operating Interest Income		178		2%
Interest Expense		-52		0%
Pretax Income		2,970		27%
Income Tax - Current Domestic	69		1%
Income Tax - Current Foreign	87		1%
Income Tax - Deferred Domestic	2
Income Tax - Deferred Foreign	16
Income Tax		174		2%
Net Income		2,796		26%

A B с D E 2020 % % =C2/$C$19 10897 1659 -2 =B3/$C$19 =B4/$C$19 1657 =C5/$C$19 465 265 249 =B7/$C$19 =B8/$C$19 =B9/$C$19 9 Raw Materials =SUM(B7:39) 157 =C2+C5+C9+C10 3303 -1011 =B12/$C$19 =B13/$C$19 =B12+B13 618 49 548 118 =SUM(C11C18) =C9/$C$19 =C10/$C$19 =C11/$C$19 =C12/$C$19 =C13/SC$19 =C13/$C$19 =C14/$C$19 C$ =C15/$C$19 =C16/$C$19 =C17/$C$19 =C18/$C$19 =C19/$C$19 19 Total Assets 2020 % % =C22/$C$22 10918 1 Nvidia Balance Sheet 2 Cash & Short Term Investments 3 Accounts Receivables, Gross 4 Bad Debt/Doubtful Accounts 5 Accounts Receivables, Net 6 Inventories 7 Finished Goods Work in Prear 8 Work in Progress 9 10 Miscellaneous Current Assets 44 Total current 11 Total Current Assets 12 Property, Plant & Equipment - Gross 13 less :Accumulated Depreciation 14 Net Property, Plant & Equipment 15 Net Goodwill 16 Net Other Intangibles 1 17 Deferred income tax assets 40 18 Other Assets 10 20 20 20 21 Nvidia Income Statement 22 Sales/Revenue 23 COGS excluding D&A 24 Depreciation & Amortization Expense 25 Cost of Goods Sold (COGS) incl. D&A 26 Gross Income 27 Operating expenses 28 Research & Development 29 Other SG&A 30 Other Operating Expense 31 Total operating expenses 32 Income from operations 33 Unusual Expense 34 EBIT 35 Interest Expense 36 Non-Operating Interest Income 37 Interest Expense APA 38 Pretax Income en con 39 Income Tax - Current Domestic 40 Income Tax - Current Foreign 41 Income Tax - Deferred Domestic 42 Income Tax - Deferred Foreign 43 Income Tax 44 Net Income 45 3754 381 =B23/$C$22 =B24/$C$22 =B23+B24 6783 =C25/$C$22 =C26/$C$22 2829 1063 0 =B28/$C$22 =B29/$C$22 =B28+B29 =C26-031 45 =C32-C33 -2 178 -52 =C34+C35+C36+C37 =C31/$C$22 =C32/$C$22 =C33/$C$22 =C34/$C$22 =C35/$C$22 =C36/$C$22 =C37/$C$22 =C38/$C$22 69 =B39/$C$22 =B40/$C$22 87 2 16 174 =C38-C43 =C43/$C$22 =C44/$C$22