Ronald_Chen_Corsair_VS_Dell_Project

xlsx

School

Santa Monica College *

*We aren’t endorsed by this school

Course

2

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

22

Uploaded by DrFangParrot18

Report
CONSOLIDATED STATEMENTS OF FINANCIAL POSITION/Balnce Sheet Dell Technologies Inc. Fiscal Year End February 3, 2023 and January 28, 2022 (In Millions) February 3, 2023 ASSETS Current assets: Cash and cash equivalents $ 8,607 Accounts receivable, net of allowance of $78 and $90 12,482 Due from related party, net 378 Short-term financing receivables, net of allowance of $142 and $142 (Note 6) 5,281 Inventories 4,776 Other current assets 10,827 Total current assets 42,351 Property, plant, and equipment, net 6,209 Long-term investments 1,518 Long-term financing receivables, net of allowance of $59 and $47 (Note 6) 5,638 Goodwill 19,676 Intangible assets, net 6,468 Due from related party, net 440 Other non-current assets 7,311 Total assets $ 89,611 LIABILITIES AND STOCKHOLDERS’ EQUITY Current liabilities: Short-term debt $ 6,573 Accounts payable 18,598 Due to related party 2,067 Accrued and other 8,874 Short-term deferred revenue 15,542 Total current liabilities 51,654 Long-term debt 23,015 Long-term deferred revenue 14,744 Other non-current liabilities 3,223 Total liabilities $ 92,636 Commitments and contingencies (Note 12) Stockholders’ equity (deficit): Common stock and capital in excess of $0.01 par value (Note 15) 8,424 Treasury stock at cost (3,813) Accumulated deficit (6,732) Accumulated other comprehensive loss (1,001) Total Dell Technologies Inc. stockholders’ equity (deficit) -3122 Non-controlling interests 97 Total stockholders’ equity (deficit) (3,025)
Total liabilities and stockholders’ equity 89611
Horizontal Analysis January 28, 2022 2022-2021 $ Change % Change $ 9,477 $ (870) -9% 12,912 $ (430) -3% 131 $ 247 189% 5,089 $ 192 4% 5,898 $ (1,122) -19% 11,526 $ (699) -6% 45,033 $ (2,682) -6% 5,415 $ 794 15% 1,839 $ (321) -17% 5,522 $ 116 2% 19,770 $ (94) -0.5% 7,461 $ (993) -13% 710 $ (270) -38% 6,985 $ 326 5% $ 92,735 $ (3,124) -3% $ 5,823 $ 750 13% 27,143 $ (8,545) -31% 1,414 $ 653 46% 7,578 $ 1,296 17% 14,261 $ 1,281 9% 56,219 $ (4,565) -8% 21,131 $ 1,884 9% 13,312 $ 1,432 11% 3,653 $ (430) -12% $ 94,315 $ (1,679) -2% 7,898 $ 526 7% (964) $ (2,849) -296% (8,188) $ 1,456 18% (431) $ (570) -132% -1685 -1437 -0.852818991098 105 $ (8) -8% (1,580) $ (1,445) -91%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
92735 -3124 -0.033687388796
CONSOLIDATED STATEMENTS OF INCOME Dell Technologies Inc. Fiscal Year End February 3, 2023 and January 28, 2022 (In Millions) February 3, 2023 January 28, 2022 Net revenue: Products $ 79,250 $ 79,830 Services 23,051 21,367 Total net revenue 102,301 101,197 Cost of net revenue (a): Products 66,029 67,224 Services 13,586 12,082 Total cost of net revenue 79,615 79,306 Gross margin 22,686 21,891 Operating expenses: Selling, general, and administrat 14,136 14,655 Research and development 2,779 2,577 Total operating expenses 16,915 17,232 Operating income 5,771 4,659 Interest and other, net (2,546) 1,264 Income before income taxes 3,225 5,923 Income tax expense 803 981 Net income from continuing ope 2,422 4,942 Income from discontinued opera 765 Net income 2,422 5,707 Less: Net loss attributable to no (20) (6) Less: Net income attributable to— 150 Net income attributable to Dell $ 2,442 $ 5,563 Earnings per share attributable to Dell Technologies Inc. — basic: Continuing operations $ 3.33 $ 6.49 Discontinued operations $— $ 0.81 Earnings per share attributable to Dell Technologies Inc. — diluted: Continuing operations $ 3.24 $ 6.26 Discontinued operations $— $ 0.76 (a) Includes related party cost of net revenue as follows (Note 21): Products $ 1,634 $ 1,577 Services $ 3,065 $ 2,487
Horizontal Analysis January 29, 2021 2022-2021 $ Change % Change $ 67,744 $ (580) -1% 18,926 $ 1,684 8% 86,670 $ 1,104 1% 56,431 $ (1,195) -2% 10,099 $ 1,504 12% 66,530 $ 309 0.4% 20,140 $ 795 4% 14,000 $ (519) -4% 2,455 $ 202 8% 16,455 $ (317) -2% 3,685 $ 1,112 24% (1,339) $ (3,810) -301% 2,346 $ (2,698) -46% 101 $ (178) -18% 2,245 $ (2,520) -51% 1,260 $ (765) -100% 3,505 $ (3,285) -58% (4) $ (14) -233% 259 $ (150) -100% $ 3,250 $ (3,121) -56% $ 3.02 $ (3) -49% $ 1.35 $ (1) -100% $ 2.93 $ (3) -48% $ 1.29 $ (1) -100% $ 1,493 $ 57 4% $ 1,848 $ 578 23%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CONSOLIDATED STATEMENTS OF CASH FLOW Dell Technologies Inc. Fiscal Year End February 3, 2023 and January 28, 2022 (In Millions) February 3, 2023 Cash flows from operating activities: Net income $ 2,422 Adjustments to reconcile net income to net cash provided by o Depreciation and amortization 3,156 Stock-based compensation expense 931 Deferred income taxes (717) Other, net (a) 961 Changes in assets and liabilities, net of effects from acquisitio Accounts receivable 113 Financing receivables (461) Inventories 875 Other assets and liabilities 973 Due from/to related party, net 649 Accounts payable (8,546) Deferred revenue 3,209 Change in cash from operating activities 3,565 Cash flows from investing activities: Purchases of equity and other investments (94) Purchases of held-to-maturity investments (14) Maturities and sales of equity and other investments 116 Capital expenditures and capitalized software development co (3,003) Acquisition of businesses and assets, net (70) Divestitures of businesses, net Other 41 Change in cash from investing activities (3,024) Cash flows from financing activities: Dividends paid by VMware, Inc. to non-controlling interests Proceeds from the issuance of common stock 5 Repurchases of parent common stock (b) (3,272) Repurchases of subsidiary common stock (9) Net transfer of cash, cash equivalents, and restricted cash to Payments of dividends to stockholders (964) Proceeds from debt 12,479 Repayments of debt (9,825) Debt-related costs and other, net (39) Change in cash from financing activities (1,625) Effect of exchange rate changes on cash, cash equivalents, and (104)
Change in cash, cash equivalents, and restricted cash (1,188) Cash, cash equivalents, and restricted cash at beginning of the 10,082 Cash, cash equivalents, and restricted cash at end of the perio 8,894 Less: Cash, cash equivalents, and restricted cash attributable Cash, cash equivalents, and restricted cash from continuing op $ 8,894 Income tax paid $ 1,208 Interest paid $ 1,169
Horizonta January 28, 2022 January 29, 2021 2022 $ Change $ 5,707 $ 3,505 $ (3,285) 4,551 5,390 $ (1,395) 1,622 1,609 $ (691) (365) (399) $ (352) (3,130) (88) $ 4,091 (2,193) (396) $ 2,306 (241) (728) $ (220) (2,514) (243) $ 3,389 (1,948) (1,656) $ 2,921 479 $ 170 5,742 1,598 $ (14,288) 2,597 2,815 $ 612 10,307 11,407 $ (6,742) (256) (162) $ 162 (158) (176) $ 144 513 169 $ (397) (2,796) (2,082) $ (207) (16) (424) $ (54) 3,957 2,187 $ (3,957) 62 28 $ (21) 1,306 (460) $ (4,330) (2,240) $ 2,240 334 452 $ (329) (663) (241) $ (2,609) (1,175) (1,363) $ 1,166 (5,052) $ 5,052 $ (964) 20,425 16,391 $ (7,946) (26,723) (20,919) $ 16,898 (1,515) (270) $ 1,476 (16,609) (5,950) $ 14,984 (106) 36 $ 2.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(5,102) 5,033 $ 3,914.00 15,184 10,151 $ (5,102.00) 10,082 15,184 $ (1,188.00) 4,770 $ 10,082 $ 10,414 $ (1,188.00) $ 1,257 $ 1,421 $ (49.00) $ 1,825 $ 2,279 $ (656.00)
al Analysis 2-2021 % Change -58% -31% -43% -96% 131% 105% -91% 135% 150% 35% -249% 24% -65% 63% 91% -77% -7% -338% -100% -34% -332% 100% -99% -394% 99% 100% -100% -39% 63% 97% 90% 2%
77% -34% -12% -12% -4% -36%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CONSOLIDATED BALANCE SHEET Corsair Gaming, Inc. Fiscal Year End December 31, 2022 and December 31, 2021 (In Thousands) December 31, 2022 Assets Current assets: Cash $ 151,180 Restricted cash 2,647 Accounts receivable, net 235,656 Inventories 192,717 Prepaid expenses and other current assets 40,593 Total current assets 622,793 Restricted cash, noncurrent 233 Property and equipment, net 34,927 Goodwill 347,747 Intangible assets, net 216,255 Other assets 75,290 Total assets $ 1,297,245 Liabilities Current liabilities: Debt maturing within one year, net $ 6,495 Accounts payable 172,033 Other liabilities and accrued expenses 164,470 Total current liabilities 342,998 Long-term debt, net 232,170 Deferred tax liabilities 18,054 Other liabilities, noncurrent 48,589 Total liabilities $ 641,811 Commitments and Contingencies (Note 9) Temporary equity Redeemable noncontrolling interest 21,367 Permanent equity Corsair Gaming, Inc. stockholders’ equity: Preferred stock, $0.0001 par value: 5,000 shares authorized, nil and nil shares Common stock, $0.0001 par value: 300,000 shares authorized, 101,385 and 94,5 10 Additional paid-in capital 593,486 Retained earnings 37,223 Accumulated other comprehensive loss (6,881) Total Corsair Gaming, Inc. stockholders’ equity 623838 Nonredeemable noncontrolling interest 10,229
Total permanent equity 634,067 Total liabilities, temporary equity and permanent equity 1297245
Horizontal Analysis 2021 2022-2021 $ Change % Change $ 62,415 $ 88,765 142% 2,734 $ (87) -3% 291,287 $ (55,631) -19% 298,315 $ (105,598) -35% 51,024 $ (10,431) -20% 705,775 $ (82,982) -12% 231 $ 2 1% 16,819 $ 18,108 108% 317,054 $ 30,693 10% 225,709 $ (9,454) -4% 71,808 $ 3,482 5% $ 1,337,396 $ (40,151) -3% $ 4,753 $ 1,742 37% 236,120 $ (64,087) -27% 205,874 $ (41,404) -20% 446,747 $ (103,749) -23% 242,898 $ (10,728) -4% 25,700 $ (7,646) -30% 53,871 $ (5,282) -10% 769,216 $ (127,405) -17% $ 21,367 100% 9 $ 1 11% 470,364 $ 123,122 26% 98,147 $ (60,924) -62% (340) $ (6,541) -1924% 568180 55658 0.097958393466859 $ 10,229 100%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
568,180 $ 65,887 12% 1337396 -40151 -0.03002177365567
CONSOLIDATED STATEMENT OF OPERATION/INCOME STATEMENT Corsair Gaming, Inc. Fiscal Year End December 31, 2022 and December 31, 2021 (In Thousands) Year Ended December 31, 2022 2021 Net revenue $ 1,375,098 $ 1,904,060 Cost of revenue 1,078,466 1,390,206 Gross profit 296,632 513,854 Operating expenses: Sales, general and administrative 284,932 315,672 Product development 66,493 60,288 Total operating expenses 351,425 375,960 Operating income (loss) (54,793) 137,894 Other (expense) income: Interest expense, net (9,186) (17,673) Other (expense) income, net 213 (5,661) Total other expense, net (8,973) (23,334) Income (loss) before income tax (63,766) 114,560 Income tax benefit (expense) 9,820 (13,600) Net income (loss) (53,946) 100,960 Less: Net income attributable to 442 Net income (loss) attr ($54,388) $ 100,960 Calculation of net income (loss) per share attributable to common stockholders of Corsair Gaming, Inc.: Net income (loss) attr ($54,388) $ 100,960 Change in redemption value of r (6,536) Net income (loss) att ($60,924) $ 100,960 Net income (loss) per share attributable to common stockholders of Corsair Gaming, Inc.: Basic ($0.63) $ 1.08 Diluted ($0.63) $ 1.01 Weighted-average common shares outstanding: Basic 96,280 93,260 Diluted 96,280 100,004
Horizontal Analysis 2020 2022-2021 $ Change % Change $ 1,702,367 $ (528,962) -28% 1,236,938 $ (311,740) -22% 465,429 $ (217,222) -42% 257,004 $ (30,740) -10% 50,064 $ 6,205 10% 307,068 $ (24,535) -7% 158,361 $ (192,687) -140% (35,137) $ 8,487 48% (1,182) $ 5,874 104% (36,319) $ 14,361 62% 122,042 $ (178,326) -156% (18,825) $ 23,420 172% 103,217 $ (154,906) -153% $ 442 100% $ 103,217 $ (155,348) -154% $ 103,217 $ (155,348) -154% $ (6,536) -100% $ 103,217 $ (161,884) -160% $ 1.20 $ (1.71) -158% $ 1.14 $ (1.64) -162% 86,256 $ 3,020 3% 90,577 $ (3,724) -4%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
CONSOLIDATED STATEMENT OF CASH FLOW Corsair Gaming, Inc. Fiscal Year End December 31, 2022 and December 31, 2021 (In Thousands) Ye 2022 Cash flows from operating activities: Net income (loss) ($53,946) Stock-based compensation 22,158 Depreciation 10,728 Amortization 42,795 Debt issuance costs amortization 398 Loss on debt extinguishment Deferred income taxes (21,736) Other 4,469 Changes in operating assets and liabilities: Accounts receivable 55,845 Inventories 111,288 Prepaid expenses and other assets 1,268 Accounts payable (65,928) Other liabilities and accrued expenses (40,950) Net cash provided by operating activities 66,389 Cash flows from investing activities: Acquisition of businesses, net of cash acquired (19,534) Payment of deferred and contingent consideration (185) Purchase of property and equipment (26,315) Investment in available-for-sale convertible note (1,000) Net cash used in investing activities (47,034) Cash flows from financing activities: Proceeds from issuance of debt, net Repayment of debt and debt issuance costs (9,483) Borrowings from line of credit 701,500 Repayment of line of credit (701,500) Proceeds from public offering, net of underwriting discounts and commissio 81,655 Payment of other offering costs (296) Proceeds from issuance of shares through employee equity incentive plans 7,015 Payment of taxes related to net share settlement of equity awards (1,532) Dividend paid to noncontrolling interest (4,312) Payment of contingent consideration (438) Net cash provided by (used in) financing activities 72,609 Effect of exchange rate changes on cash (3,284) Net increase (decrease) in cash and restricted cash 88,680 Adjustments to reconcile net income (loss) to net cash provided by operating activities:
Cash and restricted cash at the beginning of the year 65,380 Cash and restricted cash at the end of the year $ 154,060 Supplemental cash flow disclosures: Cash paid for interest $ 9,019 Cash paid for income taxes 14,221 Supplemental disclosure of non-cash investing and financing activities: Equipment purchased and unpaid at period end $ 4,985 Issuance of common stock relating to business acquisitions 14,505 Deferred purchase consideration related to business acquisitions Measurement period adjustments relating to business acquisitions
ear Ended December 31, Horizontal Analysis 2021 2020 2022-2021 $ Change % Change $ 100,960 $ 103,217 $ (154,906) -153% 17,235 5,796 $ 4,923 29% 10,300 9,318 $ 428 4% 34,794 33,916 $ 8,001 23% 1,458 2,550 $ (1,060) -73% 4,868 4,114 $ (4,868) -100% (11,962) (7,476) $ (9,774) -82% 3,291 2,594 $ 1,178 36% 444 (91,492) $ 55,401 12478% (71,316) (80,086) $ 182,604 256% (13,177) (7,953) $ 14,445 110% (63,722) 116,522 $ (2,206) -3% 7,019 77,933 $ (47,969) -683% 20,192 168,953 $ 46,197 229% (4,846) (1,291) $ (14,688) -303% (4,721) $ 4,536 96% (10,974) (8,989) $ (15,341) -140% $ (1,000) -100% (20,541) (10,280) $ (26,493) -129% 248,513 $ (248,513) -100% (328,392) (190,588) $ 318,909 97% 63,500 $ 638,000 1005% (63,500) $ (638,000) -1005% 118,575 $ 81,655 100% (8,455) $ (296) -100% 14,872 1,337 $ (7,857) -53% (397) $ (1,135) -286% $ (4,312) -100% $ (438) -100% (65,404) (79,131) $ 138,013 211% (2,435) 2,079 $ (849) -35% (68,188) 81,621 $ 156,868 230%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
133,568 51,947 $ (68,188) -51% $ 65,380 $ 133,568 $ 88,680 136% $ 11,267 $ 27,957 $ (2,248) -20% 41,243 13,505 $ (27,022) -66% $ 2,122 $ 1,832 $ 2,863 135% $ 14,505 100% 202 145 $ (202) -100% 50 1,531 $ (50) -100%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help