Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fintech For Finance Professionals

Authors: David Kuo Chuen Lee, Joseph Lim, Kok Fai Phoon, Yu Wang

1st Edition

9811241864, 978-9811241864

More Books

Students also viewed these Finance questions