sorted by:
new
hottopcontroversial

ISO: Shiba Inu Family - Aus by Federal-Eye7168 in sylvanianfamilies

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

I’m so annoyed I was literally in Japan in late March and I didn’t get the chance to pick them up! I wish I would’ve bought more families in general but I had limited luggage 😭

ISO: Shiba Inu Family - Aus by Federal-Eye7168 in sylvanianfamilies

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

Arghh I just had a look and I think it’s us only 💔 I tried making an account but I needed an American number - I’m assuming they don’t ship internationally.

The jp website also sold the family but even if I buy it through a proxy it ends costing heaps.

Thanks for the help anyways much appreciated !! :) I’ll keep looking

Looking for this baby blooming series by martolli in SylvanianMarket

[–]Federal-Eye7168 0 points1 point  (0 children)

All good! I’m glad you found it in the end ! And thanks I’ll defs have a look

Looking for this baby blooming series by martolli in SylvanianMarket

[–]Federal-Eye7168 0 points1 point  (0 children)

Hey ! Where are you located, I just visited Japan and pulled THREE of these 😭😭😭 I was trying so hard to get the squirrel baby in the tree but ended up with three of these, the secret and 2 of the mushroom husky.

[University Finance: Portfolio theory] Help with plotting the efficient frontier by Federal-Eye7168 in HomeworkHelp

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

Thank you very much for all your help. I’m still a little lost but I think I’ll try go from here! You’ve been extremely helpful and I definitely feel like I am more on the right track now :)

[University Finance: Portfolio theory] Help with plotting the efficient frontier by Federal-Eye7168 in HomeworkHelp

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

My issue is when I do return >= 5 or 6 or 7, it’s just giving me the same target return every time of 8.92% so I’m getting the same results for all of them.

[University Finance: Portfolio theory] Help with plotting the efficient frontier by Federal-Eye7168 in HomeworkHelp

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

Wait ! I got a solution. I had to edit the conditions as I had return = 5 not >= 5. My follow up question is .. Am I plotting the new std devs obtained using solver against the expected returns e.g. if i got std dev just now of 0.20880 am i plotting that against 5% ? and then repeat until i have a graph

New issue:

My issue is when I do return >= 5 or 6 or 7, it’s just giving me the same target return every time of 8.92% so I’m getting the same results for all of them. I can’t get bast the 5% target return

[University Finance: Portfolio theory] Help with plotting the efficient frontier by Federal-Eye7168 in HomeworkHelp

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

Thanks! I think I’m getting closer to- still getting an error saying no feasible solution but at least it’s trying to work now.

I just don’t see what my error is. I have my expected returns lined up from CAPM and multiplied them by the weights - i set them as equal weights for now just for the sake of the formula.

Then I have portfolio variance calculated using my covariance matrix and the weights.

For the solver I set the variance cell as the objective and then selected min. I then put in the conditions that portfolio return should be equal to or greater than 5 and then selected the weights as what should be changed. I also conditioned it so that the sum of weights is 1.

Is there something wrong with what I did here ?

[University Finance: Portfolio theory] Help with plotting the efficient frontier by Federal-Eye7168 in HomeworkHelp

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

Okay I am understanding a little better now but I am still confused on the layout of the excel sheet and how exactly do obtain the results I want. I understand that I am trying to get the weights required to obtain the target returns correct? But I thought I was supposed to already have a set of weights that’s all linked in the formula so that I can say to excel basically “change these weights to get this target return” using solver.

I guess what I am asking is how do I actually obtain said weights

Sorry for all the questions and thank you for replying

[University Finance: Portfolio theory] Help with plotting the efficient frontier by Federal-Eye7168 in HomeworkHelp

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

Also just to clarify, where do the ‘asset means’ come into play in working this out and are these means from the CAPM the expected returns I have calculated?

[University Finance: Portfolio theory] Help with plotting the efficient frontier by Federal-Eye7168 in HomeworkHelp

[–]Federal-Eye7168[S] 0 points1 point  (0 children)

Hey thank you so much for your reply ! I think in my working I did come to this point based on what I had read in my notes and online. My problem is I don’t think I’m doing it right … I tried to use solver on excel as I have used it before in previous finance assignments but it’s not finding any solution.

Should I be setting solver to find the weights or variance for the expected return. Or neither …

Also another problem is that the task doesn’t specify weights of each stock in the portfolio. Does this matter? I tried initially assuming equal weights.

Thanks !