how do you use solver in excel 2003
 

Hi, im not very familar with excel 2003. My professor wants us to use solver
to determine the efficient frontier for a portfolio consisting of 4 asset
classes plus a risk free asset. Ive got my table set up and everything but im
having trouble getting started. Any suggestions?

how do you use solver in excel 2003
 

Larry Orange -

You could start by looking at some of the Efficient Frontier examples at

http://www.solver.com/invframe.htm

- Mike
http://www.mikemiddleton.com


"Larry Orange" <Larry wrote in message
...
Hi, im not very familar with excel 2003. My professor wants us to use
solver
to determine the efficient frontier for a portfolio consisting of 4 asset
classes plus a risk free asset. Ive got my table set up and everything but
im
having trouble getting started. Any suggestions?

how do you use solver in excel 2003
 

Solver is an add-in utility for Excel that is not automatically there when
you load Excel onto a computer. Go to Tools, Add-ins, check Solver Add-In,
and OK. Then go to the help index and read all about Solver. I'm assuming
you understand the finance part but are having trouble getting the formula
started.
--
big-bob


"Larry Orange" wrote:

Hi, im not very familar with excel 2003. My professor wants us to use solver
to determine the efficient frontier for a portfolio consisting of 4 asset
classes plus a risk free asset. Ive got my table set up and everything but im
having trouble getting started. Any suggestions?

how do you use solver in excel 2003
 

I would second this idea. This web page helped me understand the efficient
frontier for the CFA test.

Dave
--
Brevity is the soul of wit.


"Mike Middleton" wrote:

Larry Orange -

You could start by looking at some of the Efficient Frontier examples at

http://www.solver.com/invframe.htm

- Mike
http://www.mikemiddleton.com


"Larry Orange" <Larry wrote in message
...
Hi, im not very familar with excel 2003. My professor wants us to use
solver
to determine the efficient frontier for a portfolio consisting of 4 asset
classes plus a risk free asset. Ive got my table set up and everything but
im
having trouble getting started. Any suggestions?