Question
Can you assist with using excel equation short cuts: 9. Florida Company (FC) and Minnesota Company (MC) are both service companies. Their historical return for
Can you assist with using excel equation short cuts:
9. Florida Company (FC) and Minnesota Company (MC) are both service companies. Their historical return for the past three years are: FC: -5%, 15%, 20%; MC: 8%, 8%, 20%. Calculate the variances of return for FC and MC.
11. The historical returns data for the past three years for Stock B and the stock market portfolio are: Stock B: 24%, 0%, 24%, Market Portfolios: 10%, 12%, 20%. Calculate the covariance of returns between Stock B and the market portfolio.
12. The historical returns data for the past four years for Stock C and the stock market portfolio returns are: Stock C: 10%, 30%, 20%,20%; Market Portfolio: 5%, 15%, 25%, 15%. Calculate the beta for the stock:
Step 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