ExcelBanter - How do I draw a Security Market Line in Excel?

It's a straight line on a chart. Figure out the Y intercept (the risk free
rate of return) and the slope (market risk premium). Figure what the minimum
and maximum X values of your chart will be, and put them into two cells, say
E2 and E3. In the next two cells (F2 and F3) calculate Y values using

Y = Y-intercept + X * slope

Then copy these four cells, select the chart, then use Paste Special to add
this data as a new series, with series in columns and the category values in
the first column. If necessary, change this series to an XY type with a line
and no markers, and assign it to the primary axes.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Luminita Flintasu" wrote in
message ...
How do I draw a Security Market Line in Excel?