What discount rate should be used for the DCF of a hybrid floating raare te bond. What are the step by step excel to create this specific DCF$,$ to get the present value of cashflows. The bond has the following terms and structure:

Coupon

Benchmark US SOFR $3$m but assume Rates scenario provided, or through your own monte carlo analysis

Fix Frequency Quarterly

Next Cpn Date $3/28/2024$

Previous Cpn Date $12/29/2023$

Reset Days Prior $2$

Margin $292\mathrm{.}661$

Current Coupon $8\mathrm{.}27475\%$

Pay Calender US

Call Schedule

First Call Date $3/30/2017$

Bond Callable on and anytime after that, quarterly

Call with minimum $30$ days notice

Call Price $100$

Maturity $3/30/2067$

Make$-$Whole $+35$bps

Amount outstanding USD$480$mn

No cap, no floor

Current Price $90$

PPL Weighted Average Cost of Capital Components

Cost of Equity $8\mathrm{.}30\%$

Cost of Debt $($senior$)4\mathrm{.}30\%$

Assume the following interest rates:

Terminal Rate: $3\mathrm{.}4$

Meeting

$03/20/20245\mathrm{.}3$

$5/1/20245\mathrm{.}1$

$6/12/20244\mathrm{.}9$

$07/31/20244\mathrm{.}7$

$09/18/20244\mathrm{.}5$

$11/7/20244\mathrm{.}3$

$12/18/20244\mathrm{.}1$

$01/29/20254\mathrm{.}0$

$03/20/20253\mathrm{.}4$

$05/20/20253\mathrm{.}4$

$6/12/20253\mathrm{.}4$

$07/31/20253\mathrm{.}4$

$09/18/20253\mathrm{.}4$

$11/18/20253\mathrm{.}4$

$12/18/20253\mathrm{.}4$

Thereafter: $3\mathrm{.}4$