ExcelBanter - Continuously Compounded Bond Present Values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Continuously Compounded Bond Present Values (https://www.excelbanter.com/excel-discussion-misc-queries/116314-continuously-compounded-bond-present-values.html)

chris

Continuously Compounded Bond Present Values

Is there a built in function in Excel to find the PV of a bond that is
continuously compounded, ie discounted at e^(-r*t) ??

Thanks!

Fred Smith

Continuously Compounded Bond Present Values

No, there's not. You will need to enter the formula directly.

--
Regards,
Fred

"chris" wrote in message
oups.com...
Is there a built in function in Excel to find the PV of a bond that is
continuously compounded, ie discounted at e^(-r*t) ??

Thanks!

All times are GMT +1. The time now is 07:32 PM.