If any steps can be performed on a financial calculator please show thank you!

Calculating Yield to Maturity of Bond,
Using TVM Calculation,
I = [PV = -1,226.22, FV = 1,000, N = 26, PMT = 53]
I = 7.80%
For bond to sell at par value,
YTM = Coupon Rate
Coupon Rate = 7.80% semi-annually
If any steps can be performed on a financial calculator please show thank you! Chamberlain Co. wants to issue new 13-ye...
Chamberlain Co. wants to issue new 14-year bonds for some much-needed expansion projects. The company currently has 7.8 percent coupon bonds on the market that sell for $762.45, make semiannual payments, and mature in 14 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? Assume a par value of $1,000.
Chamberlain Co. wants to issue new 14-year bonds for some much-needed expansion projects. The company currently has 11.4 percent coupon bonds on the market that sell for $1,434.26, make semiannual payments, and mature in 14 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? Assume a par value of $1,000
Chamberlain Co. wants to issue new 19-year bonds for some much-needed expansion projects. The company currently has 7 percent coupon bonds on the market that sell for $1,060, make semiannual payments, and mature in 19 years. 10 points What coupon rate should the company set on its new bonds if it wants them to sell at par? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) eBook Print Coupon rate...
Seether Co. wants to issue new 13-year bonds for some much-needed expansion projects. The company currently has 10.4 percent coupon bonds on the market that sell for $1,000.00, make semiannual payments, and mature in 13 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? Assume a par value of $1,000.
please show work in excel formula, Thanks
N Chamberlain Co. wants to issue new 20-year bonds for some much-needed expansion projects. The company currently has 7 percent coupon bonds on the market that sell for $1,083, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? 1/1/2000 1/1/2020 Settlement date Maturity date Annual coupon rate Coupons per year Redemption value (% of par)...
please fill in the blanks as a formula only
K Chamberlain Co. wants to issue new 20-year bonds for some much-needed expansion projects. The company currently has 7 percent coupon bonds on the market that sell for $1,083, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? Settlement date Maturity date Annual coupon rate Coupons per year Redemption value (% of par)...
Chamberlain Co. wants to issue new 20-year bonds for some much-needed expansion projects The company currently has 7 percent coupon bonds on the market that sell for $1,083, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? Settlement date 1/1/2000 Maturity date Annual coupon rate Coupons per year Redemption value (% of par) Bond price (% of par) 1/1/2020 7% 2 100...
Seether Co. wants to issue new 17-year bonds for some much-needed expansion projects. The company currently has 6.8 percent coupon bonds on the market that sell for $754.07, make semiannual payments, and mature in 17 years. What coupon rate should the company set on its new bonds if it wants them to sell at par?
Seether Co. wants to issue new 15-year bonds for some much-needed expansion projects. The company currently has 11.6 percent coupon bonds on the market that sell for $1,423.02, make semiannual payments, and mature in 15 years. What coupon rate should the company set on its new bonds if it wants them to sell at par?
Bond Yields [LO2] Seether Co. wants to issue new 20-year bonds needed expansion projects. The company currently has 8 percent coupon bonds on the market that sell for $930, make semiannual payments, and mature in 20 years. What coupon rate should the company set on its new bonds if it wants them to sell at par? 19.