FINANCIAL MANAGEMENT: FINAL PROJECT

profilerdk
AMDReferences.xlsx

Sheet1

New AMD-Powered Supercomputers Unleash Discovery and Accelerate Innovation https://ir.amd.com/news-releases/news-release-details/new-amd-powered-supercomputers-unleash-discovery-and-accelerate
AMD Unveils World’s First 7nm Datacenter GPUs -- Powering the Next Era of Artificial Intelligence, Cloud Computing and High Performance Computing (HPC) https://ir.amd.com/news-releases/news-release-details/amd-unveils-worlds-first-7nm-datacenter-gpus-powering-next-era
AMD Delivers Best-in-Class Performance from Supercomputers to HPC in the Cloud at SC19 https://ir.amd.com/news-releases/news-release-details/amd-delivers-best-class-performance-supercomputers-hpc-cloud
News Releases https://ir.amd.com/news-releases?field_nir_news_date_value%5Bmin%5D=2020&items_per_page=10#views-exposed-form-widget-news-widget-news-ul
AMD Ryzen 3000 Sales Hit All-Time High, Ryzen 7 3700X & Ryzen 5 3600 Sales Reach 2x Total Number of Intel CPUs Sold https://wccftech.com/amd-ryzen-3000-cpu-sales-all-time-high-versus-intel-9th-gen-core/
AMD Balance Sheet https://finance.yahoo.com/quote/AMD/balance-sheet/
AMD Cash Flow https://finance.yahoo.com/quote/AMD/cash-flow?p=AMD
AMD Income Statement https://finance.yahoo.com/quote/AMD/financials?p=AMD
AMD 2019 Annual Report on Form 10-K https://ir.amd.com/static-files/480b482b-79ee-4b43-bcda-0d86dedfeb04
2018 ANNUAL REPORT ON FORM 10-K https://ir.amd.com/static-files/a388f1a0-6bbd-4218-96ec-d9cf41544e6b
https://ir.amd.com/news-releases/news-release-details/new-amd-powered-supercomputers-unleash-discovery-and-accelerate https://ir.amd.com/static-files/a388f1a0-6bbd-4218-96ec-d9cf41544e6b https://ir.amd.com/news-releases/news-release-details/amd-unveils-worlds-first-7nm-datacenter-gpus-powering-next-era https://ir.amd.com/news-releases/news-release-details/amd-delivers-best-class-performance-supercomputers-hpc-cloud https://ir.amd.com/news-releases?field_nir_news_date_value%5Bmin%5D=2020&items_per_page=10 https://wccftech.com/amd-ryzen-3000-cpu-sales-all-time-high-versus-intel-9th-gen-core/ https://finance.yahoo.com/quote/AMD/balance-sheet/ https://finance.yahoo.com/quote/AMD/cash-flow?p=AMD https://finance.yahoo.com/quote/AMD/financials?p=AMD https://ir.amd.com/static-files/480b482b-79ee-4b43-bcda-0d86dedfeb04

Sheet3

Consolidated Income Statement (USD $ in Millions) Year Ending Dec 2019 (Update) Year Ending Dec 2018 (Update) Year Ending Dec 2017 (Restated) Year Ending Dec 2016 (Update)
Net Sales 6,731.00 6,475.00 5,253.00 4,272.00
Revenue 6,731.00 6,475.00 5,253.00 4,272.00
Total Revenue 6,731.00 6,475.00 5,253.00 4,272.00
Cost of Revenue -3,863.00 -4,028.00 -3,466.00 3,274.00
Cost of Revenue, Total -3,863.00 -4,028.00 -3,466.00 3,274.00
Gross Profit 2,868.00 2,447.00 1,787.00 -998
Selling/General/Administrative Expense 471 344 322 294
Labor & Related Expense 62 42 38 35
Advertising Expense 217 176 156 131
Selling/General/Administrative Expenses, Total 750 562 516 460
Research & Development 1,547.00 1,434.00 1,196.00 1,008.00
Amortization of Intangibles, Operating -- -- -- 0
Depreciation/Amortization -- -- -- 0
Investment Income - Operating -- -- -- --
Interest/Investment Income - Operating -- -- -- --
Interest Expense (Income), Net-Operating, Total -- -- -- --
Restructuring Charge -- 0 0 -10
Litigation -- -- -- --
Impairment-Assets Held for Use -- -- -- 0
Impairment-Assets Held for Sale -- -- -- --
Loss (Gain) on Sale of Assets - Operating -- -- -- --
Other Unusual Expense (Income) 116 12 -40 -20
Unusual Expense (Income) 116 12 -40 -30
Total Operating Expense 6,276.00 6,036.00 5,138.00 4,712.00
Operating Income 455 439 115 -440
Interest Expense - Non-Operating -94 -121 -126 -156
Interest Capitalized - Non-Operating -- -- -- --
Interest Expense, Net Non-Operating -94 -121 -126 -156
Interest Income, Non-Operating 15 18 6 --
Investment Income, Non-Operating -1 -3 -3 3
Interest/Investment Income, Non-Operating 14 15 3 3
Interest Income (Expense), Net-Non-Operating, Total -80 -106 -123 -153
Gain (Loss) on Sale of Assets -- -- -- --
Other Non-Operating Income (Expense) -3 -3 0 145
Other, Net -3 -3 0 145
Net Income Before Taxes 372 330 -8 -448
Cash Flow ($ in Millions) Year Ending Dec 2019 (Update) Year Ending Dec 2018 (Update) Year Ending Dec 2017 (Restated) Year Ending Dec 2016 (Update)
Net Income/Starting Line 341 337 -33 -497
Depreciation – Supplemental 222 170 144 133
Depreciation/Depletion 222 170 144.00 133
Deferred Taxes -4 -4 -- 11
Unusual Items 218 84 12.00 68
Equity in Net Earnings (Loss) -- -3.00 -144
Other Non-Cash Items 258 174 136 339
Non-Cash Items 476 258 145 263
Accounts Receivable -623 -806 -103 222
Inventories -137 -151 -3.00 -73
Prepaid Expenses -162 -98 -173 -165
Accounts Payable 7 121 29 138
Payable/Accrued 373 207 6 58
Changes in Working Capital -542 -727 -244 180
Cash from Operating Activities 493.00 34.00 12 90
Purchase of Fixed Assets -217 -163 -113 -77
Capital Expenditures -217 -163 -113 -77
Sale/Maturity of Investment 325 45 223 342
Purchase of Investments -284 -123 -222 --
Other Investing Cash Flow 27 71 58 2
Other Investing Cash Flow Items, Total 68 -7 59 344
Cash from Investing Activities -149 -170 -54 267
Other Financing Cash Flow -7 -1 -13 -4
Financing Cash Flow Items -7 -1 -13.00 -4
Issuance (Retirement) of Stock, Net 523 70 20 687
Issuance (Retirement) of Debt, Net -473 -41 -40 -561
Cash from Financing Activities 43 28 -33 122
Net Change in Cash 387 -108 -75 479
Net Cash - Beginning Balance 1.08M 1.19M 1.27M 785
Net Cash - Ending Balance 1.47M 1.08M 1.19M 1.26M
Liquidity Ratio: Current 1.95 1.78 1.76 1.88
Liquidity Ratio: Quick 1.43 1.21 1.07 1.17
Liquidity Ratio: Cash 0.64 0.58 0.8 0.94