Case UA Excel answers 20240410

.xlsx

School

University Of Chicago *

*We aren’t endorsed by this school

Course

30130

Subject

Economics

Date

May 5, 2024

Type

xlsx

Pages

43

Uploaded by BaronElectron14141 on coursehero.com

UA annual P&Ls 2000-21 S-1/A S-1/A S-1/A 10-K Prof. Hand 4/10/24 2000 2001 2002 2003 Reported Net Revenues REV ($000s) $ 5,347 $ 19,732 $ 49,550 $ 115,419 COGS 3,027 9,348 26,329 64,757 Gross Profit 2,320 10,384 23,221 50,662 SG&A 1,612 7,035 18,908 40,709 Restructuring & Impairment charges Income (Loss) from Operations 708 3,349 4,313 9,953 Interest Expense, net Other Expense, net (97) (305) (894) (2,214) Income (Loss) before Income Taxes 611 3,044 3,419 7,739 Income Tax Expense (Benefit) - 36 653 1,991 Income (Loss) from Equity Method Investment Net Income ($000s) $ 611 $ 3,008 $ 2,766 $ 5,748
10-K 10-K 10-K 10-K 10-K 10-K 10-K 10-K 2004 2005 2006 2007 2008 2009 2010 2011 $ 205,181 $ 281,053 $ 430,689 $ 606,561 $ 725,244 $ 856,411 $ 1,063,927 $ 1,472,684 109,748 145,203 215,089 302,083 372,203 446,286 533,420 759,848 95,433 135,850 215,600 304,478 353,041 410,125 530,507 712,836 70,280 100,040 158,682 218,213 276,116 324,852 418,152 550,069 25,153 35,810 56,918 86,265 76,925 85,273 112,355 162,767 749 (850) (2,344) (2,258) (3,841) (1,057) (2,836) 2,169 2,029 (6,175) (511) (1,178) (2,064) 24,096 32,974 59,087 89,043 69,900 82,418 108,919 156,862 7,774 13,255 20,108 36,485 31,671 35,633 40,442 59,943 $ 16,322 $ 19,719 $ 38,979 $ 52,558 $ 38,229 $ 46,785 $ 68,477 $ 96,919
10-K 10-K 10-K 10-K 10-K 10-K 10-K 10-K 2012 2013 2014 2015 2016 2017 2018 2019 $ 1,834,921 $ 2,332,051 $ 3,084,370 $ 3,963,313 $ 4,825,335 $ 4,989,244 $ 5,193,185 $ 5,267,132 955,624 1,195,381 1,572,164 2,057,766 2,584,724 2,737,830 2,852,714 2,796,599 879,297 1,136,670 1,512,206 1,905,547 2,240,611 2,251,414 2,340,471 2,470,533 670,602 871,572 1,158,251 1,497,000 1,831,143 2,099,522 2,182,339 2,233,763 124,049 183,149 208,695 265,098 353,955 408,547 409,468 27,843 (25,017) 236,770 (5,183) (2,933) (5,335) (14,628) (26,434) (34,538) (33,568) (21,240) (73) (1,172) (6,410) (7,234) (2,755) (3,614) (9,203) (5,688) 203,439 260,993 342,210 386,685 380,279 (10,309) (67,788) 209,842 74,661 98,663 134,168 154,112 131,303 37,951 (20,552) 70,024 (59,000) 934 (47,679) $ 128,778 $ 162,330 $ 208,042 $ 232,573 $ 189,976 $ (48,260) $ (46,302) $ 92,139
10-K 10-K 2020` 2021 2000-21 $ 4,474,667 $ 5,683,466 $ 47,479,482 2,314,572 2,821,967 24,876,682 2,160,095 2,861,499 22,602,800 2,171,934 2,334,691 19,235,485 601,599 40,518 949,315 (613,438) 486,290 2,418,000 (47,259) (44,300) (243,962) 168,153 (51,113) 67,758 (492,544) 390,877 2,241,796 49,387 32,072 1,009,780 (7,246) 1,255 (111,736) $ (549,177) $ 360,060 $ 1,120,280
UA quarterly P&Ls 2005-21 Prof. Hand 4/10/24 Q1:2005 Q2: 2005 Q3:2005 Quarterly Net Revenues ($000s) As Reported $ 58,187 $ 48,957 $ 86,606 COGS As Reported 32,349 24,406 43,641 Gross Profit As Reported 25,838 24,551 42,965 SG&A As Reported 20,941 20,906 28,482 Restr & Impairment charges As Reported Income (Loss) from Operations As Reported 4,897 3,645 14,483 Interest Expense, net As Reported (589) (699) (836) Other Expense, net As Reported Income (Loss) bef Income Taxes As Reported 4,308 2,946 13,647 Income Tax Expense (Benefit) As Reported 1,799 1,116 5,261 Income (Loss) from Eq Meth Inv As Reported Net Income (Loss) As Reported $ 2,509 $ 1,830 $ 8,386 Q1:2005 Q2: 2005 Q3:2005 1. Quarterly Reported Net Revenues ($000s) REV $ 58,187 $ 48,957 $ 86,606 2. REV Pulled Forward into the Q (per SEC) RPF 3. REV if no Rev was Pulled Forward into the Q TRUE_REV $ 58,187 $ 48,957 $ 86,606 5. Analyst REV consensus (mostly per SEC) AN_REV 4a. False REV meet-or-beat F_MOB_REV 4b. False Rev meet-or-beat (% of AN_REV) F_MOB_REV% 6a. True REV meet-or-beat T_MOB_REV 6b. True Rev meet-or-beat (% of AN_REV) T_MOB_REV% Q1:2005 Q2: 2005 Q3:2005 1. Quarterly Reported Net Revenues ($000s) REV $ 58,187 $ 48,957 $ 86,606 2a. Loss of REV Pulled Forward from prior Q RPF_LPQ 2b. REV Pulled Forward into the Q (per SEC) RPF 3. REV if no Rev was Pulled Forward into the Q TRUE_REV $ 58,187 $ 48,957 $ 86,606 5. Analyst REV consensus (mostly per SEC) AN_REV 4a. False REV meet-or-beat F_MOB_REV 4b. False Rev meet-or-beat (% of AN_REV) F_MOB_REV% 6a. True REV meet-or-beat T_MOB_REV 6b. True Rev meet-or-beat (% of AN_REV) T_MOB_REV% REV with no RPF (for graph only) REV Growth Definitions: D2. "Q0_Qm1" = Q_t-1 → Q_t D3. "Y0_Ym1" = Last4Q_t-4 → L4Q_t Also "CC" contcomp Q0_Qm4 UA's quarterly REV if UA had pulled no REV forward from the next quarter (under the "all else held equal" counterfactual) UA's quarterly REV if UA had pulled no REV forward from the next quarter (under the "never any RPFs" counterfactual) D1. "Q0_Qm4" = Q_t-4 → Q_t
Q5b Statement = "Over the next decade, UA continued to see strong financial performance, primarily d T or F Q5b ? D1. "Q0_Qm4" = Q_t-4 → Q_t 0 31% D2. "Q0_Qm1" = Q_t-1 → Q_t 0 10% D3. "Y0_Ym1" = Last4Q_t-4 → L4Q_t 0 30% Also "CC" = contin. compounded Q0_Qm4 0 30% Q5c Statement = "Plank focused on UA's 20% quarter-over-quarter REV growth for the past 5 years ..." T or F Q5c ? D1. "Q0_Qm4" = Q_t-4 --> Q_t 0 30% D2. "Q0_Qm1" = Q_t-1 --> Q_t 0 10% D3. "Y0_Ym1" = Last4Q_t-4 --> L4Q_t 0 30% Also "CC" contcomp Q0_Qm4 0 32% Assume: "next decade" = the 40 Qs --> Q1:2006-Q4:2015. Note: If instead you assume: "next decade" = Q4:2005-Q3:2015, it's still FALSE! Avg. 40 quarters = Q1:2006 → Q4:2015 Assume: "past 5 years" = the 20 Qs → Q4:2010-Q3:2015. Note: If instead you assume "past 5 years" = 5 Q_t vs Q_t-4 comparisons over Q4:2010-Q3:2015, it's still FALSE! Avg. 20 quarters = Q4:2010 → Q4:2015
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