Please answer A$,$ B and C

Excel required

Assume that today$$s date is February $21,2023.$ PPL Corporation, a Moody$$s investment grade corporation, has issued the following convertible bond issue

Par value $$1,000/$bond

Maturity $5$ years

Coupon $2\mathrm{.}875\%,$ payable semi$-$annually

Each bond can be converted to $29\mathrm{.}3432$ shares of PPL common stock

Yield$-$to$-$maturity $5\mathrm{.}48\%$ per year on a comparable risk, straight bond $($i$.$e$.,$ bond with no options$)$

PPL$$s stock price $$28/$share

Determine the following.$\text{'}$ Show cells and calcultions where possible

A$.$ Straight$-$bond value $($or textbook$$s $$investment value$)$

B$.$ Conversion value

C$.$ Minimum value for this PPL convertible bond