Chrome File Edit View History Bookmarks Profiles Tab Window Help Mon Apr 3 1:43 AM PG Campus X Unit 8 Lab Assignment - N X Do Homework - Unit 8 Lab X Unit 9 Assignment - MT43 x *Dashboard X C mylab.pearson.com/Student/PlayerHomework.aspx?homeworkld=645239712&questionld=13&flushed=false&cld=7325124&back=DoAssig... (1 # O PG Campus G Sir W. Arthur Lewi... FREE Digital Down... My Best Buy@ Cre... T T-Mobile ED Writing Center Tut... TikTok de noeherd... (2) How to Create.. MT217 Finance Christopher Williams 04/03/23 1:43 AM Homework: Unit 8 Lab Assignment Question 18, P8-10 (similar to) HW Score: 68.44%, 13.69 of 20 points Part 1 of 7 O Points: 0 of 1 Save (Related to Checkpoint 8.3) (CAPM and expected returns) a. Given the following holding-period returns, , compute the average returns and the standard deviations for the Sugita Corporation and for the market. b. If Sugita's beta is 0.84 and the risk-free rate Data Table , what would be an expected return for an investor owning Sugita? (Note: Because the preceding returns are based on monthly data, you will need to annualize the returns to make them comparable with the risk-free rate. For simplicity, you can convert from monthly to yearly returns by multiplying the average monthly returns by 12.) c. How does Sugita's historical average return compare with the return you should expect based on the Capital Asset Pricing Model and the firm's systematic risk? O a. Given the holding-period returns shown in the table, the average monthly return for the Sugita Corporation is %. (Round to three decimal places.) O O Help me solve this View an example Get more help - Clear all Check answer Ready Accessibility: Good to go Q J - + 100% APR 3 8 tv T 4Excel File Edit View Insert Format Tools Data Window Help Q 8 Mon Apr 3 1:45 AM AutoSave OFF - G... data-4_3_2023-1_43 AM Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments LE Share Calibri 11 AA ab General Insert 2 x Delete v V v Paste B IUV MV Av = += = = $ ~ % " Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v Filter Select Data A1 X V fx Month B C D E F G H K M N O P Q R S T U V W 1 Month Sugita Corp. Market 2 1 2.29 1.0% 2 -0.8% 4.0% 3 -1.0% 3.0% 4 1.0% 1.0% 5 4.0% 7.0% 6 4.0% 0.0% 11 12 13 Microsoft Excel + Ready Accessibility: Good to go X + 100% APR 3 T