Convertible bonds calculation formula

Job ID: 37135030

Budget: $10 – $30 USD

I am looking for a freelancer who can create a convertible bonds calculation formula for me. The purpose of this formula is to determine the conversion price.

I would like the formula to be of Black-Scholes Model

Convertible bonds calculation formula based on the following inputs:
Bond issuance date in days
The lifetime of the bond in years
Coupon rate in %
Coupon per year
Yield to maturity %
Share price in USD
Implied volatility %
Conversion price in USD
The maturity date of the conversion component is equal to the life of the bond
Related categories: Engineering Accounting Excel Finance Mathematics