</3 excel

[B R I E F S 0]

g. On an excel spreadsheet, calculate the possible returns and the associated risk for portfolios that range from 100% stock A to 100% stock B. (Note: since you are using an excel spreadsheet, it is expected that you will calculate more than a minimal number of points.) (5 marks)

 

Anyone know how to do this? I already have the numbers for 100% A and 100% B calculated on paper, no clue how to do this tho

[rainefardreamer 0]

1. look at paper

2. type in formulas into excel with variables either filled in or using other cells for data

3. ????

4. profit?

[Rocket Rob 0]

1. look at paper

2. type in formulas into excel with variables either filled in or using other cells for data

3. ????

4. profit?

lmfao

[Phonetically Phamous (dice 0]

scan your paper and upload it

 

i r excel master

[MasterP 0]

Come up with the basic equations and then do a full breakdown for each combination of stocks, IE 100% A with 0% B, 99% A with 1% B, all the way up to 0% A with 100% B. The risks for each combination should also be part of an equation. In excel, once you get one item working it should be easy to get everything else going.

[B R I E F S 0]

1. look at paper

2. type in formulas into excel with variables either filled in or using other cells for data

3. ????

4. profit?

LEWL hahaha

[B R I E F S 0]

Come up with the basic equations and then do a full breakdown for each combination of stocks, IE 100% A with 0% B, 99% A with 1% B, all the way up to 0% A with 100% B. The risks for each combination should also be part of an equation. In excel, once you get one item working it should be easy to get everything else going.

i'll try that

[B R I E F S 0]

I figured it out, my friend emailed it to me.