ZuoTi.Pro
Question
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 perce
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Coupon rate

7%

Years to maturity

20

NPER

40

(Years to maturity X 2)

PMT

35

(Face valueX coupon rate)/2

Face value

1000

Price

1083

Rate

3.13%

=Rate(NPER,PMT,-pv,fv)

Yield to maturity

3.13 * 2

= 6.27%
0 0
Add a comment
Know the answer?
Add Answer to:
please fill in the blanks as a formula only K Chamberlain Co. wants to issue new...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • please show work in excel formula, Thanks N Chamberlain Co. wants to issue new 20-year bonds...

    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)...

  • Chamberlain Co. wants to issue new 20-year bonds for some much-needed expansion projects The company currently has 7 pe...

    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...

  • I want to know how do I calculate it using excel functions D8 f7% A B...

    I want to know how do I calculate it using excel functions D8 f7% A B D Е F G Н J К 2 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? 4...

  • REVIEW Supra ing DATA VIEW FORMULAS HOME INSERT PAGE LAYOUT B I U - 99 -...

    REVIEW Supra ing DATA VIEW FORMULAS HOME INSERT PAGE LAYOUT B I U - 99 - A. Alignment Number Conditional Format Formatting" Custome Quick Access Toolbar Show Quick Access Toolbar Below the Ribbon Customize the boon Collapse the Ribbon 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...

  • All answers must be entered as a formula. Click OK to begin. OK ? Calculating the...

    All answers must be entered as a formula. Click OK to begin. OK ? Calculating the real rate - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW * Calibri -111 A A = % B Paste B I U . - 3- A 3.12 points Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font Skipped A1 А в E F G H I J K eBook Print References Say...

  • Chamberlain Co. wants to issue new 14-year bonds for some much-needed expansion projects. The com...

    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...

    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

  • If any steps can be performed on a financial calculator please show thank you! Chamberlain Co. wants to issue new 13-ye...

    If any steps can be performed on a financial calculator please show thank you! Chamberlain Co. wants to issue new 13-year bonds for some much-needed expansion projects. The company currently has 10.6 percent coupon bonds on the market that sell for $1,226.22, 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.

  • Chamberlain Co. wants to issue new 19-year bonds for some much-needed expansion projects. The company currently...

    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...

  • built in excel formula please!!!! ???? Both Bond Sam and Bond Dave have 6.5 percent coupons,...

    built in excel formula please!!!! ???? Both Bond Sam and Bond Dave have 6.5 percent coupons, make semiannual payments, and are priced at par value. Bond Sam has 3 years to maturity, whereas Bond Dave has 20 years to maturity. If interest rates suddenly rise by 2 percent, what is the percentage change in the price of Bond Sam? Of Bond Dave? If rates were to suddenly fall by 2 percent instead, what would the percentage change in the price...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT