Please scan your band-written homework or take a picture of it and upload it to BrichtSpace. If the questions are from my lecture notes, don't copw the answers on the notes. (No points for copied answers.) Please show details of your calculations. Rik and return - forward-Hookine scenarios Dandwritten solutions reguired] a bok retarn, and a aok chance of producing a valin return. What is the firm's copected rate of tetum? What is the variance on the firm's retarn? What is the standant devtatioe on the ffrms inture? Do not round your interinediate calculat sans. a taknturn, and a as\% chance of produering a -18\$ rntum. What it the firm't riphocted rite of ruturn? What in the variance on the firmh neturn? What is the atandard deviation on the firm retum? Do not round your intermediate calculations. Risk and Return with Historical Data (Video 8, Fxeel Fuercise) 1. Download historical month-end price from Jan. 2010 to Jant. 2022 for your favorite stock from finatice.yahoo com and sase them in an Fucel file. After you download the Fxecl, you only need to keep ad fuated closing price. This is the price adjusted for dividend and stock splis. Calculate its risk and enpected return. Remember to label your answers. 2. Following video 12, download historical month-end price from Jan sono to Jan. 2023 SP500 index (Ticker: ^ GSPC) finance yahoo.com and save them in an Excel file. Keep adjasted closing price. calculate SPsoo, the market portiolio's risk and return. Label your answers. - The "download" button is not anallahle on financesahos, anymoce. Here is how to download the data. - Highlight the data including the beader for each colnmn en financesnhoe, pase choose "paste special" m=> choose "Text" Coefficient of Variance (Mandwritten solutions required) 1. Cheng tne. Is considering a capital budgetinik project that has an expected retura of 24% and a standard deviation of 30%. What is the project's coefficient of variation? Do not round your intermodiate calculations, Round the final anner to 2 decimal places. 2. Bae fac is coesidering an invertment that has an expected return of 45% and a standard deviation of 100 . What is the imvestmear's coetficient of variation? Do not roand your intermedliate calculations. Round the final answer to 2 decimal places