There wouldn't be a direct tool in Excel to do this since convertible
do not have standard terms like a regular corporate bond. Typically,
convertible price is calculated by splitting it into two pieces - th
straight bond (which excel can handle) and an equity option (whic
excel does not have a built in function for). You may want to searc
for a pricing model on the internet, or you could probably build on
with the help of a finance textbook. If you need a hand, and no on
else chimes in, I can try to help later this week. Cha
