Question
How to compute a tangency portfolio and optimal capital allocation in excel with 3 stocks given their monthly returns over 5 years and a risk
How to compute a tangency portfolio and optimal capital allocation in excel with 3 stocks given their monthly returns over 5 years and a risk free rae of .167% (2%/12)?
I don't know how to include my excel file so just any instructions on how to use the excel solver would be great.
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
International financial management
Authors: Jeff Madura
12th edition
1133947832, 978-1305195011, 978-1133947837
