9vc Final Project Widget Company - Student Workbook Times New Roman 11 A A E O y ITI D y DX .. (0) BIU Avay av == = y " y% 40809 C19 fx C D F G H J K L M E Company B= Risk Free Rate (R1) = 1.57 0.50% Returns A B 1 S&P 500 Closing Data 2 2 Date Adjusted Close 3 5/1/2022 7165.62 4 4/1/2022 7227.96 5 3/1/2022 7203.47 6 2/1/2022 7090.41 7 1/1/2022 6987.44 8 12/1/2021 7094.08 9 11/1/2021 7007.72 10 10/1/2021 6960.64 11 9/1/2021 6953.75 12 8/1/2021 6850.72 13 7/1/2021 6797.24 14 6/1/2021 6595.22 15 5/1/2021 6506.00 16 4/1/2021 6418.55 17 3/1/2021 6291.43 18 2/1/2021 6300.66 19 1/1/2021 6273.60 20 12/1/2020 6266.76 21 11/1/2020 6160.11 22 10/1/2020 6172.77 23 9/1/2020 6208.72 24 8/1/2020 6152.12 25 7/1/2020 6024.33 26 6/1/2020 5948.21 27 AirPorn 5020 ne > 0.Case Instructions A FullCase MarketData A Grading Rubric Answer Sheet CapitalBudget NPVProfile + + 133% 9vc Final Project Widget Company - Student Workbook Times New Roman 11 A A O y ITI y y .. (0) B I uv a. Av v hy == = v " y% 8 C19 C D E F G G H I 1 J K L L M M 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 A 87172020 7/1/2020 6/1/2020 5/1/2020 4/1/2020 3/1/2020 2/1/2020 1/1/2020 12/1/2019 11/1/2019 10/1/2019 9/1/2019 8/1/2019 7/1/2019 6/1/2019 5/1/2019 4/1/2019 3/1/2019 2/1/2019 1/1/2019 12/1/2018 11/1/2018 10/1/2018 9/1/2018 8/1/2018 7/1/2018 6/1/2018 51 FAX 0.Case Instructions B bl32.12 6024.33 5948.21 5930.08 5840.84 5775.80 5554.03 5499.70 5449.69 5355.49 5271.38 5139.83 5130.09 5080.83 4943.18 4922.69 4919.01 4933.70 4956.59 4925.48 4786.00 4819.85 4680.93 4674.14 4655.37 4587.10 4485.32 dudn pul FullCase 45 46 47 48 49 50 ST MarketData Grading Rubric Answer Sheet CapitalBudget NPVProfile + + 133% 9vc Final Project Widget Company - Student Workbook Times New Roman 11 A A A y y DX .. (0) BIU aAv v av hy y % 40809 19 c D E F G H J K L M 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 x fx A 11/1/2018 10/1/2018 9/1/2018 8/1/2018 7/1/2018 6/1/2018 5/1/2018 4/1/2018 3/1/2018 2/1/2018 1/1/2018 12/1/2017 11/1/2017 10/1/2017 9/1/2017 8/1/2017 7/1/2017 6/1/2017 5/1/2017 B 4819.85 4680.93 4674.14 4655.37 4587.10 4485.32 4446.94 4468.42 4375.44 4239.16 4209.39 4202.96 4159.03 4096.67 4092.86 4055.23 4065.52 4029.37 3957.00 Expected Return Std. Dev , 0.Case Instructions FullCase MarketData Grading Rubric Answer Sheet CapitalBudget NPVProfile + + 133% 9vc Final Project Widget Company - Student Workbook Times New Roman 11 A A E O y ITI D y DX .. (0) BIU Avay av == = y " y% 40809 C19 fx C D F G H J K L M E Company B= Risk Free Rate (R1) = 1.57 0.50% Returns A B 1 S&P 500 Closing Data 2 2 Date Adjusted Close 3 5/1/2022 7165.62 4 4/1/2022 7227.96 5 3/1/2022 7203.47 6 2/1/2022 7090.41 7 1/1/2022 6987.44 8 12/1/2021 7094.08 9 11/1/2021 7007.72 10 10/1/2021 6960.64 11 9/1/2021 6953.75 12 8/1/2021 6850.72 13 7/1/2021 6797.24 14 6/1/2021 6595.22 15 5/1/2021 6506.00 16 4/1/2021 6418.55 17 3/1/2021 6291.43 18 2/1/2021 6300.66 19 1/1/2021 6273.60 20 12/1/2020 6266.76 21 11/1/2020 6160.11 22 10/1/2020 6172.77 23 9/1/2020 6208.72 24 8/1/2020 6152.12 25 7/1/2020 6024.33 26 6/1/2020 5948.21 27 AirPorn 5020 ne > 0.Case Instructions A FullCase MarketData A Grading Rubric Answer Sheet CapitalBudget NPVProfile + + 133% 9vc Final Project Widget Company - Student Workbook Times New Roman 11 A A O y ITI y y .. (0) B I uv a. Av v hy == = v " y% 8 C19 C D E F G G H I 1 J K L L M M 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 A 87172020 7/1/2020 6/1/2020 5/1/2020 4/1/2020 3/1/2020 2/1/2020 1/1/2020 12/1/2019 11/1/2019 10/1/2019 9/1/2019 8/1/2019 7/1/2019 6/1/2019 5/1/2019 4/1/2019 3/1/2019 2/1/2019 1/1/2019 12/1/2018 11/1/2018 10/1/2018 9/1/2018 8/1/2018 7/1/2018 6/1/2018 51 FAX 0.Case Instructions B bl32.12 6024.33 5948.21 5930.08 5840.84 5775.80 5554.03 5499.70 5449.69 5355.49 5271.38 5139.83 5130.09 5080.83 4943.18 4922.69 4919.01 4933.70 4956.59 4925.48 4786.00 4819.85 4680.93 4674.14 4655.37 4587.10 4485.32 dudn pul FullCase 45 46 47 48 49 50 ST MarketData Grading Rubric Answer Sheet CapitalBudget NPVProfile + + 133% 9vc Final Project Widget Company - Student Workbook Times New Roman 11 A A A y y DX .. (0) BIU aAv v av hy y % 40809 19 c D E F G H J K L M 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 x fx A 11/1/2018 10/1/2018 9/1/2018 8/1/2018 7/1/2018 6/1/2018 5/1/2018 4/1/2018 3/1/2018 2/1/2018 1/1/2018 12/1/2017 11/1/2017 10/1/2017 9/1/2017 8/1/2017 7/1/2017 6/1/2017 5/1/2017 B 4819.85 4680.93 4674.14 4655.37 4587.10 4485.32 4446.94 4468.42 4375.44 4239.16 4209.39 4202.96 4159.03 4096.67 4092.86 4055.23 4065.52 4029.37 3957.00 Expected Return Std. Dev , 0.Case Instructions FullCase MarketData Grading Rubric Answer Sheet CapitalBudget NPVProfile + + 133%