Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please use the CAPM formula to find the expected return for VWAGY over this time period And Please use the WACC formula to find the
please use the CAPM formula to find the expected return for VWAGY over this time period And Please use the WACC formula to find the weight average cost of capital for VWAGY over this time thanks!
(The risk free rate still needs to be found, I don't know how that's why I am posting)
H Mutual Fund Div Return Correlations Stock and Mutual Fund Stock and Market Mutual Fund and Market 0.806825 0.640194 0.892970 Betas Stock B Mutual Fund B= 0.2292052593 4.734945864 30.94 Expected Return (VWAGY)= WACC of (VWAGY)= Date (VWAGY) Stock Price 10/4/2021 30.90 10/5/2021 30.93 10/6/2021 29.86 10/7/2021 31.00 10/8/2021 31.20 10/11/2021 30.87 10/12/2021 30.59 10/13/2021 31.29 10/14/2021 31.85 10/15/2021 31.73 10/18/2021 31.12 10/19/2021 10/20/2021 31.49 10/21/2021 32.00 10/22/2021 32.35 10/25/2021 33.06 10/26/2021 34.11 10/27/2021 33.35 10/28/2021 33.25 10/29/2021 32.61 11/1/2021 33.47 11/2/2021 33.42 11/3/2021 33.98 11/4/2021 34.00 11/5/2021 34.64 11/8/2021 33.09 11/9/2021 33.08 11/10/2021 32.52 11/11/2021 32.66 11/12/2021 32.53 11/15/2021 31.79 11/16/2021 31.58 11/17/2021 31.81 11/18/2021 32.35 11/19/2021 31.26 11/22/2021 31.14 Total 1.16 Standard Deviation of Stock Sheet1 Stock Div Return - (BPTIX) Mutual Fund Price 178.72 0.10% 182.76 -3.46% 182.73 3.82% 185.43 6.50% 184.04 -1.06% 184.09 -0.91% 186.51 2.29% 188.28 1.79% 190.96 -0.38% 194.33 -1.92% 197.11 -0.58% 197.87 1.78% 197.91 1.62% 202.07 1.09% 204.18 2.19% 216.46 3.18% 215.67 -2.23% 215.12 -0.30% 220.39 -1.92% 225.55 2.64% 234.25 -0.15% 228.84 1.68% 231.60 0.06% 233.89 1.88% 233.87 -4.47% 227.27 -0.03% 212.29 1.69% 215.81 0.43% 215.18 -2.66% 213.29 -2.27% 211.05 -0.66% 215.23 0.73% 218.12 1.70% 218.17 -3.37% 221.73 -0.38% 222.03 0.24% 17.18 Average Stock Standard Deviation of Return Mutual Fund 2.26% -0.02% 1.48% -0.75% 0.03% 1.31% 0.95% 1.42% 1.76% 1.43% 0.39% 0.02% 2.10% 1.04% 6.01% -0.36% -0.26% 2.45% 2.34% 3.86% -2.31% 1.21% 0.99% -0.01% -2.82% -6.59% 1.66% -0.29% -0.88% -1.05% 1.98% 1.34% 0.02% 1.63% 0.14% 0.64% Average Mutual Fund Return Market Index - Market Index Return 107.88 108.96 1.00% 109.36 0.37% 110.43 0.98% 110.12 -0.28% 109.38 -0.67% 109.33 -0.05% 109.79 0.42% 111.63 1.68% 112.31 0.61% 112.71 0.36% 113.49 0.69% 113.92 0.38% 114.33 0.36% 114.11 -0.19% 114.69 0.51% 114.75 0.05% 113.89 -0.75% 115.14 1.10% 115.35 0.18% 115.88 0.46% 116.21 0.28% 117.07 0.74% 117.46 0.33% 117.94 0.41% 118.14 0.17% 117.80 -0.29% 116.63 -0.99% 116.82 0.16% 117.67 0.73% 117.64 -0.03% 118.13 0.42% 117.66 -0.40% 117.84 0.15% 117.54 -0.25% 116.94 -0.51% 3.24 0.23% Market Average Market Standard Dev Return H Mutual Fund Div Return Correlations Stock and Mutual Fund Stock and Market Mutual Fund and Market 0.806825 0.640194 0.892970 Betas Stock B Mutual Fund B= 0.2292052593 4.734945864 30.94 Expected Return (VWAGY)= WACC of (VWAGY)= Date (VWAGY) Stock Price 10/4/2021 30.90 10/5/2021 30.93 10/6/2021 29.86 10/7/2021 31.00 10/8/2021 31.20 10/11/2021 30.87 10/12/2021 30.59 10/13/2021 31.29 10/14/2021 31.85 10/15/2021 31.73 10/18/2021 31.12 10/19/2021 10/20/2021 31.49 10/21/2021 32.00 10/22/2021 32.35 10/25/2021 33.06 10/26/2021 34.11 10/27/2021 33.35 10/28/2021 33.25 10/29/2021 32.61 11/1/2021 33.47 11/2/2021 33.42 11/3/2021 33.98 11/4/2021 34.00 11/5/2021 34.64 11/8/2021 33.09 11/9/2021 33.08 11/10/2021 32.52 11/11/2021 32.66 11/12/2021 32.53 11/15/2021 31.79 11/16/2021 31.58 11/17/2021 31.81 11/18/2021 32.35 11/19/2021 31.26 11/22/2021 31.14 Total 1.16 Standard Deviation of Stock Sheet1 Stock Div Return - (BPTIX) Mutual Fund Price 178.72 0.10% 182.76 -3.46% 182.73 3.82% 185.43 6.50% 184.04 -1.06% 184.09 -0.91% 186.51 2.29% 188.28 1.79% 190.96 -0.38% 194.33 -1.92% 197.11 -0.58% 197.87 1.78% 197.91 1.62% 202.07 1.09% 204.18 2.19% 216.46 3.18% 215.67 -2.23% 215.12 -0.30% 220.39 -1.92% 225.55 2.64% 234.25 -0.15% 228.84 1.68% 231.60 0.06% 233.89 1.88% 233.87 -4.47% 227.27 -0.03% 212.29 1.69% 215.81 0.43% 215.18 -2.66% 213.29 -2.27% 211.05 -0.66% 215.23 0.73% 218.12 1.70% 218.17 -3.37% 221.73 -0.38% 222.03 0.24% 17.18 Average Stock Standard Deviation of Return Mutual Fund 2.26% -0.02% 1.48% -0.75% 0.03% 1.31% 0.95% 1.42% 1.76% 1.43% 0.39% 0.02% 2.10% 1.04% 6.01% -0.36% -0.26% 2.45% 2.34% 3.86% -2.31% 1.21% 0.99% -0.01% -2.82% -6.59% 1.66% -0.29% -0.88% -1.05% 1.98% 1.34% 0.02% 1.63% 0.14% 0.64% Average Mutual Fund Return Market Index - Market Index Return 107.88 108.96 1.00% 109.36 0.37% 110.43 0.98% 110.12 -0.28% 109.38 -0.67% 109.33 -0.05% 109.79 0.42% 111.63 1.68% 112.31 0.61% 112.71 0.36% 113.49 0.69% 113.92 0.38% 114.33 0.36% 114.11 -0.19% 114.69 0.51% 114.75 0.05% 113.89 -0.75% 115.14 1.10% 115.35 0.18% 115.88 0.46% 116.21 0.28% 117.07 0.74% 117.46 0.33% 117.94 0.41% 118.14 0.17% 117.80 -0.29% 116.63 -0.99% 116.82 0.16% 117.67 0.73% 117.64 -0.03% 118.13 0.42% 117.66 -0.40% 117.84 0.15% 117.54 -0.25% 116.94 -0.51% 3.24 0.23% Market Average Market Standard Dev ReturnStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started