AutoSave . Off) MBA 640 Fall 2021 Case Study(1) Search (Alt+Q) Joshua OLUBAMBI JO O X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments & Cut Calibri 11 ~ A A _ AutoSum ap Wrap Text General AY O [ Copy Fill Paste BIUTY Av E E Merge & Center Insert Delete Format Sort & Find & Analyze Format Painter $ ~ % " Conditional Format as Cell Formatting > Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A41 : X Vfx A B C D E F G H J K L M N O P 15 Total assets 7,336,750 1,589,422 1,962,149 16 Current liabilities: 17 Accounts payable 18,359 7,090 31,210 18 Accrued liabilities 469,591 67,652 79,073 19 Deferred revenue 3,867,193 63,310 109,056 20 Other current liabilities 33,665 5,063 3,464 21 Total current liabilities 4,388,808 143,115 222,803 22 Contract with Customer, Liability, Noncurrent 177,419 138,995 165,352 23 Operating lease liabilities, non-current 97,421 93,675 10,006 24 Financing lease liabilities, non-current 109,874 38,689 33,489 25 Other non-current liabilities 1,853 138 258 26 Total liabilities 4,775,375 414,612 431,908 27 Commitments and contingencies (Note 12) 28 Stockholders' equity: 29 Common stock, par value $0.0001 40 34 33 30 Additional paid-in capital 4,801,849 2,669,426 2,538,155 31 Accumulated other comprehensive gain 3,004 1,804 (1,320) 32 Accumulated deficit (2,243,518) (1,496,454) (1,006,627) 33 Total stockholders' equity 2,561,375 1,174,810 1,530,241 34 Total liabilities and stockholders' equity $ 7,336,750 $ 1,589,422 $ 1,962,149 35 36 37 38 39 40 41 42 43 Moderna Balance Sheet Moderna Income Statement | J& Balance Sheet | J& Income Statement + Ready + 100% Type here to search O 9 x 45F Cloudy 9:55 PM 10/28/2021AutoSave . Off) MBA 640 Fall 2021 Case Study(1) Search (Alt+Q) Joshua OLUBAMBI JO X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments & Cut _ AutoSum Calibri v 11 ~ A" A " E ce Wrap Text General X AY O [ Copy Fill Paste EE Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Format Painter BIUT DAY E Merge & Center $ ~ % " 00 0 Formatting > Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A17 X fx Loans and notes payable (Note 7) B C D E F G H K L M N O P Consolidated Balance Sheets - USD ($) $ in Millions Dec. 31, 2020 Dec. 31, 20 Dec. 31, 2018 2 Current assets Cash and cash equivalents (Notes 1 and 2) $ 13,985 $ 17,305 $ 18,107 Marketable securities (Notes 1 and 2) 11,200 1,982 1,580 5 Accounts receivable trade, less allowances for doubtful accounts 13,576 14,481 14,098 6 Inventories (Notes 1 and 3) 9,344 9,020 8,599 7 Prepaid expenses and other receivables 3,132 2,392 2,699 8 Assets held for sale (Note 18) 94 950 9 Total current assets 51,237 45,274 46,033 10 Property, plant and equipment, net (Notes 1 and 4) 18,766 17,658 17,035 11 Intangible assets, net (Notes 1 and 5) 53,402 47,643 47,611 12 Goodwill (Notes 1 and 5) 36,393 33,639 30,453 13 Deferred taxes on income (Note 8) 8,534 7,819 7,640 14 Other assets 6,562 5,695 4,182 15 Total assets 174,894 157,728 152,954 16 Current liabilities: 17 Loans and notes payable (Note 7) 2,631 1,202 2,796 18 Accounts payable 9,505 8,544 7,537 19 Accrued liabilities 13,968 9,715 7,601 20 Accrued rebates, returns and promotions 11,513 10,883 3,380 21 Accrued compensation and employee related obligations 3,484 3,354 860'S 22 Accrued taxes on income (Note 8) 1,392 2,266 818 23 Total current liabilities 42,493 35,964 31,230 24 Long-term debt (Note 7) 32,635 26,494 27,684 25 Deferred taxes on income (Note 8) 7,214 5,958 7,506 26 Employee related obligations (Notes 9 and 10) 10,771 10,663 9,951 OneDrive X 27 Long-term taxes payable (Note 1) 6,559 7,444 8,242 28 Other liabilities Screenshot saved 11,944 11,734 8,589 29 Total liabilities 111,616 98,257 93,202 The screenshot was added to your Moderna Balance Sheet | Moderna Income Statement J&J Balance Sheet J&J Income Statement + OneDrive. Ready Type here to search O x 9:56 PM 45OF Cloudy 10/28/2021AutoSave . Off) MBA 640 Fall 2021 Case Study(1) Search (Alt+Q) Joshua OLUBAMBI JO X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments X Cut v 11 ~ A" A _ AutoSum Calibri ce Wrap Text General X AY O [ Copy Fill Paste E Merge & Center $ ~ % " 00 -80 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Format Painter Formatting * Table Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A15 : X V fx Total assets A B C D E F G H K L M N O P 15 Total assets 174,894 157,728 152,954 16 Current liabilities: 17 Loans and notes payable (Note 7) 2,631 1,202 2,796 18 Accounts payable 9,505 3,544 7,537 19 Accrued liabilities 13,968 9,715 7,601 20 Accrued rebates, returns and promotions 11,513 10,883 9,380 21 Accrued compensation and employee related obligations 3,484 3,354 3,098 22 Accrued taxes on income (Note 8) 1,392 2,266 818 23 Total current liabilities 42,493 35,964 31,230 24 Long-term debt (Note 7) 32,635 26,494 27,684 25 Deferred taxes on income (Note 8) 7,214 5,958 7,506 26 Employee related obligations (Notes 9 and 10) 10,771 10,663 9,951 27 Long-term taxes payable (Note 1) 6,559 7,444 8,242 28 Other liabilities 11,944 11,734 8,589 29 Total liabilities 111,616 98,257 93,202 30 Shareholders' equity: 31 Common stock - par value $1.00 per share 3,120 3,120 3,120 32 Accumulated other comprehensive income (loss) (Note 13) (15,242) (15,891) 15,222) 33 Retained earnings 113,890 110,659 106,216 34 Stockholders' Equity before Treasury Stock 101,768 97,888 94,114 35 Less: common stock held in treasury, at cost 38,490 38,417 34,362 36 Total shareholders' equity 63,278 59,471 59,752 37 Total liabilities and shareholders' equity $ 174,894 $ 157,728 $ 152,954 38 39 40 41 42 43 Moderna Balance Sheet | Moderna Income Statement J&J Balance Sheet J& Income Statement + Ready + 100% Type here to search O 9 OM MW 9:56 PM 45F Cloudy 10/28/2021 EAutoSave . Off) MBA 640 Fall 2021 Case Study(1) Search (Alt+Q) Joshua OLUBAMBI JO X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments & Cut Calibri 11 ~ A A ap Wrap Text General X _ AutoSum AY O Fill Paste DE Copy BIUT DAY E Merge & Center $ ~ % " 00 -20 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Format Painter Formatting > Table Styles v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis B21 X Y fx B C D E F G H K L M N O P CA Consolidated Statements of Earnings - USD ($) $ in Millions 12 Months Ended N Jan. 03, 2021 Dec. 29, 2019 Dec. 30, 2018 3 Income Statement Revenues $ 82,584 $ 82,059 $ 81,581 5 Cost of products sold 28,427 27,556 27,091 6 Gross profit 54,157 54,503 54,490 7 Selling, marketing and administrative expenses 22,084 22,178 22,540 8 Research and development expense 12,159 11,355 10,775 9 In-process research and development (Note 5) 181 890 1,126 10 Interest income (111) (357) (611) 11 Interest expense, net of portion capitalized (Note 4) 201 318 1,005 12 Other (income) expense, net 2,899 2,525 1,405 13 Restructuring (Note 20) 247 266 251 14 Earnings before provision for taxes on income 16,497 17,328 17,999 15 Provision for taxes on income (Note 8) 1,783 2,209 2,702 16 Net income $ 14,714 $ 15,119 $ 15,297 17 18 Net earnings per share $ 5.59 $ 5.72 $ 5.70 19 20 Stock Price S 156.05 $ 145.30 21 22 23 24 25 26 OneDrive X 27 28 Screenshot saved 29 The screenshot was added to your Moderna Balance Sheet | Moderna Income Statement | JOU Balance Sheet J&J Income Statement + OneDrive. Ready Type here to search O 9 0 P D W x 9:56 PM 45OF Cloudy 10/28/2021AutoSave . Off) MBA 640 Fall 2021 Case Study(1) Search (Alt+Q) Joshua OLUBAMBI JO X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments & Cut Calibri v 11 ~ A" A " _ AutoSum = de Wrap Text General AY O Paste [ Copy Fill SEE E Merge & Center $ ~ % " Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Format Painter Formatting > Table * Styles Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A1 X fx CONSOLIDATED BALANCE SHEETS - USD ($) $ in Thousands B C D E F G H J K L M N O P CONSOLIDATED BALANCE SHEETS - USD ($) $ in Thousands Dec. 31, 20 Dec. 31, 2019 c. 31, 2018 2 Current assets: 3 Cash and cash equivalents $ 2,623,850 $ 235,876 $ 658,364 Investments 1,983,758 867,124 863,063 5 Accounts receivable 1,390,560 5 ,369 12,585 6 Inventory 46,527 7 Prepaid expenses and other current assets 252,152 19,403 28,399 8 Restricted cash 1,032 1,032 595 9 Total current assets 6,297,879 1,128,804 1,563,006 10 Investments, non-current 638,848 159,987 172,990 11 Property and equipment, net 296,889 201,495 211,977 12 Right-of-use assets, operating leases 90,201 86,414 13 Restricted cash, non-current 11,053 10,791 11,532 14 Other non-current assets 1,880 1,931 2,644 15 Total assets 7,336,750 1,589,422 1,962,149 16 Current liabilities: 17 Accounts payable 18,359 7,090 31,210 18 Accrued liabilities 469,591 67,652 79,073 19 Deferred revenue 3,867,193 63,310 109,056 20 Other current liabilities 33,665 5,063 3,464 21 Total current liabilities 4,388,808 143,115 222,803 22 Contract with Customer, Liability, Noncurrent 177,419 138,995 165,352 23 Operating lease liabilities, non-current 97,421 93.675 10,006 24 Financing lease liabilities, non-current 109,874 38,689 33,489 25 Other non-current liabilities 1,853 138 258 26 Total liabilities 4,775,375 414,612 431,908 27 Commitments and contingencies (Note 12) 28 Stockholders' equity: 29 Common stock, par value $0.0001 40 34 33 Moderna Balance Sheet Moderna Income Statement | J& Balance Sheet | JOU Income Statement + Ready + 100% Type here to search O OM MW 45F Cloudy 9:55 PM 10/28/2021