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?

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?

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?

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?