Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Date S&P 500 REYNOLDS HASBRO janv-02 -1,70% 6,13% 1,66% fvr-02 -2,31% 9,87% -13,27% mars-02 4,37% -1,37% 10,55% avr-02 -5,06% 6,87% 1,01% mai-02 -1,19% 2,17% -4,26%

Date S&P 500 REYNOLDS HASBRO
janv-02 -1,70% 6,13% 1,66%
fvr-02 -2,31% 9,87% -13,27%
mars-02 4,37% -1,37% 10,55%
avr-02 -5,06% 6,87% 1,01%
mai-02 -1,19% 2,17% -4,26%
juin-02 -7,15% -23,97% -11,37%
juil-02 -8,23% 1,64% -9,66%
aot-02 0,64% 7,71% 7,35%
sept-02 -10,14% -31,48% -15,36%
oct-02 7,35% 0,57% -8,18%
nov-02 5,96% -4,81% 25,44%
dc-02 -5,50% 9,09% -9,91%
janv-03 -2,46% 0,59% 3,90%
fvr-03 -1,72% -5,78% 0,92%
mars-03 0,89% -19,17% 14,70%
avr-03 8,12% -12,68% 15,19%
mai-03 6,18% 21,02% 0,06%
juin-03 1,48% 9,15% 9,24%
juil-03 2,18% -4,54% 7,78%
aot-03 2,34% -3,86% -1,86%
sept-03 -1,06% 15,78% 0,97%
oct-03 5,89% 21,47% 16,70%
nov-03 1,51% 14,93% 1,42%
dc-03 4,39% 5,34% -3,75%
janv-04 2,20% 1,56% -7,19%
fvr-04 1,40% 4,52% 10,73%
mars-04 -1,20% -1,99% -0,55%
avr-04 -2,56% 7,06% -13,15%
mai-04 1,24% -13,23% 4,08%
juin-04 2,00% 20,27% -3,36%
juil-04 -3,88% 6,45% -4,37%
aot-04 0,11% 4,93% 1,98%
sept-04 1,91% -9,88% 1,46%
oct-04 1,66% 1,21% -5,90%
nov-04 4,43% 9,83% 7,57%
dc-04 3,34% 3,93% 1,84%
janv-05 -2,74% 2,32% 1,14%
fvr-05 2,09% 1,90% 7,76%
mars-05 -1,86% -1,66% -3,17%
avr-05 -2,66% -3,25% -7,48%
mai-05 3,59% 6,34% 6,66%
juin-05 0,99% -4,96% 3,02%
juil-05 4,22% 5,72% 5,53%
aot-05 -0,78% 0,76% -5,65%
sept-05 0,93% -1,10% -5,07%
oct-05 -2,19% 2,38% -4,12%
nov-05 3,82% 4,73% 8,39%
dc-05 0,19% 7,09% -1,18%
janv-06 3,90% 6,08% 5,05%
fvr-06 -0,36% 4,96% -4,29%
mars-06 1,76% -0,61% 3,99%
avr-06 1,15% 3,93% -6,59%
mai-06 -3,30% 0,26% -5,94%
juin-06 -0,19% 4,88% -2,32%
juil-06 -0,28% 9,96% 3,26%
aot-06 2,30% 2,65% 8,56%
sept-06 1,81% -4,76% 12,07%
oct-06 3,60% 1,92% 13,93%
nov-06 2,13% 1,71% 3,20%
dc-06 0,91% 1,91% 1,87%

Calculate the rate of return for each portfolio, that is, 100% S&P 500 portfolio; or 99% S&P 500 and 1% Cash; or 99% S&P 500 and 1% Reynolds; or 99% S&P and 1% Hasbro. Could you plesae give the formula on excel. The risk free rate is of 3%

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

Finance Applications And Theory

Authors: Marcia Cornett, Troy Adair, John Nofsinger

6th Edition

1264101589, 9781264101580

More Books

Students also viewed these Finance questions

Question

Describe the primary concerns and hopes of ecopsychologists.

Answered: 1 week ago

Question

What is the general process for selecting expatriates?

Answered: 1 week ago