valuation on excel please.

NIKE, INC. B NYSE-NKE PRICE 136.64 RATIO 40.8 Medan: 200) PE RATIO 1.04 TIMELINESS 3 Lowered 7/10/20 High: 23.1 24.6 28.7 40.1 49.9 68.2 66.4 65.2 86.0 101.8148.0 147 LOW: 152 17.4 21.3 25.7 34.9 45.3 49.0 50.3 62.1 71.2 60.0 120 SAFETY 1 Raited/11/08 LEGENDS 16.0 x Cash Flowsh TECHNICAL 3 Lowered 18:21 Relative Price Strength 2 for 1 spl 12/12 BETA 1.15 (1.00 - Market font 12/15 Options: Yes 18-Month Target Price Range Shaded area indicates remision Low-High Midpoint (% to Mid) $91-$212 $152 (10%) 2024-26 PROJECTIONS Anni Total Price Gain Return High 175 (30%) 7% www LOW 145 (-5% 3% Institutional Decisions 202020 302020 064 30 889 766 354 20 839 Hid000100581010089231023772 traded 10 LLLLLL 102020 Percent 1065 shares NIKE, INC. 'B' NYSE-NKE a 136.64 mano 40.8 (30) PERATO (5) ENE 1.84 DID no 0.8% 362 who 888888 HHE 31 % ha 302 PE VALUE PRICE LINE TIMELINESS 3 High 231 287 40 400 LIN 65.4 215 800 1018 1400 147.1 40 257 SAFETY Target Price Range 453 1 40.0 03 2.1 LFONDS 712 000 125.4 2024 2025 2026 WO TECHNICAL 387 where 200 NITA 15 More One 18-Month Target Price Range 100 Low High Milo MM 5810121510) PROJECTIONS AT Priem Gal Return H 175 (30N La is Institutional Decisions TOT RETURN Percent NO 20 20 007 traded 10 By SIS 100 101 10937 ORI 16 1000 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 VALUELINE PUB, LC24-26 7:22 810 240 10.07 13.17 14.16 1786 10.25 2091 2273 2295 24.01 27:45 31.10 Salesperah 418 30 104 100 1.15 150 re 18 226 262 301 2.36 23 1.80 25 "Cash Flower 9. 97 110 1.16 135 140 185 216 2.51 240 20 185 215 3.95 Earnings per sh AB 100 14 22 27 20 15 41 42 54 82 70 70 30 104 1.12 Divda Dedd persh TS 10 36 30 21 170 30 30 Cap Spending perth 5 300 340 398 504 518 5.67 EN 622 741 7.29 7.55 5.77 517 2.75 20 Book Valon per sh 10.60 270012072020150120180301530 170 1201018827543091601015620715580 15001586. Common She Outil 15000 153 964 2014 194 22 24 2015 21 23 22 4. Hold free Ang Ann Patio 20 SE 12 104 1.14 130 1.00 127 123 144 1.05 1.37 1.70 20 Relative pe Ratio IN 14 1 tes TR 14 1.5% 135 12 105 1.3 13 11 105 Avg AmlDiv Yield 1.ON CAPITAL STRUCTURE as of 2021 2012 201312313 27799 0801 2378 3050 36397 39117 37403 43350 48020 Sales Smith Total Debt 946mil Duin 5 Yrs 54500 ml 1515 1419 14.5 1515 158 159 159 143 109 11 14 15.5 Operating Marin 2005 LT Debt 9412 mil LT interest 5515 mill 600 4300 STOOD Capital 70607070 70507210 725 770 Depreciation (Smil) 975 2130.0 2030 2040 2003.03273.0 37000 ND 3974D 4009029370 4975 200 Nol Profil 12000 Lesses, Uncapital Amarta 5553 mil 20 23 2225 17 1615706 1705 2005 Income Tax Rate 21.05 No Defined Benefit Pension Plan 2.75 107 11.85 123 10.94 103 79% 13.35 12.75 Net Pro Margin 23 7203007000BD677057KHO 3050012272 Preferred Stock None 15500 16000 Working Capi 18000 2780 220 12100 11900 107920 20100 347103680 34640 960 9300 3500 Long-Term Debt Small 5000 Common Slock 1979 20707 Class A Star 30.0112 981301008111156 023412707 12258 12007981203040 30550 12200 13000 Shr. EquitySmil) 16000 Cass shaw 127455 211 210 200 220 29 289 303 320 25 300S Return on Total Capi 5806 2173 214 215 2499 25853075 342 4051 HEN 3654105 47.53 Return on Sht. Equity 75.05 MARKET CAP: 5215 billion (Large Cup) 180 155 156 1223 3 2750 2 x 27.5 HD Retained to Com E 59.55 CURRENT POSITION 2019 2020 22521 28% 2011 30% 274 27 an 3 335 28 All Divds to Net Prot 215 Eagles SESTER * 11 19 2750 971 27