how do you use solver in excel 2003

L

Larry Orange

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?
 
B

big-bob

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.
 
D

Dave F

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

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use Excel Solver (for an Iteration in a row) for several no.of times? 0
how do i enter 16-22 november, 2009 as a date in excel 2003 7
Excel 2007 how to set solver options as available in Excel 2003 2
How to replace Excel solver with some free solver codes in Excel V 2
how do i use the markowitz method with solver? 1
how do you print colored headers with Excel 2003 3
Deleting rows in Excel 2007 using filters 1
how to use arabic numers in excel 2003 1

Top