Calculate Betas and Peer Groups for all 4 projects. Please show your excel equations and all work. It is pretty simple, the data is below, please use the format that is in step 2 when calculating both the betas and peer group for all 4 projects.

Step 2: Calculate betas for each project and the peer group for the following periods (use Market portfolio): Project 1 BETAS Peer Group 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Project 4 Peer Group -12% Project 1 Project 2 2007 -3.00% 2008 -7.23% 2009 7.85% 2010 8.37% 2011 9.05% 2012 -11.30% 2013 9.17% 2014 10.55% 2015 12.27% 2016 13.52% 2017 -8.30% 2018 12.65% 2019 15.24% 2020 -8.30% 2021 12.00% 2022 14% 2023 11% * 2022-2023 years data are forecasts Portfolio weights Scenario 1 18% Portfolio weights Scenario 2 22% Project 3 -4.15% 1.22% 5.50% 8.05% 10.15% -3.30% 8.90% 9.33% 10.60% 9.50% -3.30% 8.60% 7.95% 5.10% 11.00% 16% 18% 11.35% 7.20% 3.50% 10.27% 7.33% 2.57% 2.90% 4.53% 6.20% 8.05% 7.30% 6.50% 6.35% 27% 9% Project 5 -17.75% -18.25% -7.60% 12.55% 10.30% 9.64% 11.55% 10.90% 8.30% 9.25% 8.78% 8.87% 9.33% 7.27% 33% 11% -10.50% 5.50% -7.75% 11.22% 10.65% 5.35% 1.33% 17.21% 15.00% 12.00% 9.37% 3.37% 3.30% 8.15% 9.85% 11.27% 12.75% Market (for betas) -7.35% -3% -9.27% -1.20% 8.25% 3.75% 11.37% 4.50% 10.95% 7.10% 10.50% 6.17% 7.75% 3.19% 8.30% 3.30% 8.92% 4.22% 6.70% 5.70% -7.90% 2.55% 10.35% 2.47% 11.28% 2.15% 6.05% -3.35% 8.73% 7.05% 12.0% 5.10% 11.0% 4.2% 8% 9% 15% 22% 27% 18% 100% 27% 12% 21% 18% 100% Step 2: Calculate betas for each project and the peer group for the following periods (use Market portfolio): Project 1 BETAS Peer Group 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Project 4 Peer Group -12% Project 1 Project 2 2007 -3.00% 2008 -7.23% 2009 7.85% 2010 8.37% 2011 9.05% 2012 -11.30% 2013 9.17% 2014 10.55% 2015 12.27% 2016 13.52% 2017 -8.30% 2018 12.65% 2019 15.24% 2020 -8.30% 2021 12.00% 2022 14% 2023 11% * 2022-2023 years data are forecasts Portfolio weights Scenario 1 18% Portfolio weights Scenario 2 22% Project 3 -4.15% 1.22% 5.50% 8.05% 10.15% -3.30% 8.90% 9.33% 10.60% 9.50% -3.30% 8.60% 7.95% 5.10% 11.00% 16% 18% 11.35% 7.20% 3.50% 10.27% 7.33% 2.57% 2.90% 4.53% 6.20% 8.05% 7.30% 6.50% 6.35% 27% 9% Project 5 -17.75% -18.25% -7.60% 12.55% 10.30% 9.64% 11.55% 10.90% 8.30% 9.25% 8.78% 8.87% 9.33% 7.27% 33% 11% -10.50% 5.50% -7.75% 11.22% 10.65% 5.35% 1.33% 17.21% 15.00% 12.00% 9.37% 3.37% 3.30% 8.15% 9.85% 11.27% 12.75% Market (for betas) -7.35% -3% -9.27% -1.20% 8.25% 3.75% 11.37% 4.50% 10.95% 7.10% 10.50% 6.17% 7.75% 3.19% 8.30% 3.30% 8.92% 4.22% 6.70% 5.70% -7.90% 2.55% 10.35% 2.47% 11.28% 2.15% 6.05% -3.35% 8.73% 7.05% 12.0% 5.10% 11.0% 4.2% 8% 9% 15% 22% 27% 18% 100% 27% 12% 21% 18% 100%