Question
Please show calculations on Excel. A 1.00 0.80 0.10 A 16% 25% B 1.00 0.15 B 12% 22% C 1.00 C 15% 25% a. Proportion
Please show calculations on Excel.
| A | 1.00 | 0.80 | 0.10 |
| A | 16% | 25% |
| B |
| 1.00 | 0.15 |
| B | 12% | 22% |
| C |
|
| 1.00 |
| C | 15% | 25% |
| a. |
|
|
|
|
|
|
|
| Proportion of A | 0.25 |
|
|
|
|
|
|
| Proportion of B | 0.25 |
|
|
|
|
|
|
| Proportion of C | 0.5 | <-- =1-SUM(B7:B8) |
|
|
|
|
|
| Expected return |
|
|
|
|
|
|
|
| Variance |
|
|
|
|
|
|
|
| Standard deviation |
|
|
|
|
|
|
|
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
Capital Markets Institutions And Instruments
Authors: Frank J. Fabozzi, Franco Modigliani
4th Edition
0136026028, 9780136026020
