Reference Series 2

M

Mrinklin

Im haveing difficultly with a graph which has two series. I need to pu
together a chart which will display the data in a smooth upward slopin
curve with a line jutting out to depict where the first series level
of.

The data columns are listed below. The x axis is the first column.
Series 1 is the fourth column. Series 2 is where I'm incurrin
trouble. I cant find a way to smoothly place data above the levelin
off point. Any help would be great. Thanks. Matthew

1) Stock Price
at Maturity

$16.50
$21.50
$26.50
$31.50
$31.51
$32.04
$32.58
$33.11
$33.65
$38.65
$43.65
$48.65

2) Stock Value
at Maturity

$1,650,000
$2,150,000
$2,650,000
$3,150,000
$3,151,000
$3,204,000
$3,258,000
$3,311,000
$3,365,000
$3,865,000
$4,365,000
$4,865,000

3) Value at Maturity
Client receives/(Pays)

$0
$0
$0
$0
$214,000
$161,000
$107,000
$54,000
$0
($500,000)
($1,000,000)
($1,500,000)

4) Net Portfolio
Value at Maturity

$1,650,000
$2,150,000
$2,650,000
$3,150,000
$3,365,000
$3,365,000
$3,365,000
$3,365,000
$3,365,000
$3,365,000
$3,365,000
$3,365,00
 
Top