Answered: (i) Based on the details of the three…

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter5: The Cost Of Money (interest Rates)

Section: Chapter Questions

Problem 7PROB

See similar textbooks

Similar questions

a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it be if there were only 9 or 8 years to maturity? Use the worksheet to compute the bond issue prices and enter them in the spaces provided. Bond issue price (9 years to maturity) __________________ Bond issue price (8 years to maturity) __________________ b. Compare these prices to the bond-carrying values found in the effective interest amortization schedule you originally printed out in requirement 3. Explain the similarity. c. Click the Chart sheet tab. The chart presented shows the price behavior of this bond based on years to maturity. Explain what effect years to maturity has on bond prices. Check your explanation by trying 8% as the effective rate (cell E10) and clicking the Chart sheet tab again. Also try 9%. When the assignment is complete, close the file without saving it again. Worksheet. Modify the BONDS3 worksheet to accommodate bonds with up to 20-year maturity. Use your new model to determine the issue price and amortization schedules of a 2,000,000, 18-year, 10% bond issued to yield 9%. Preview the printout to make sure that the worksheet will print neatly, and then print the worksheet. Save the completed file as BONDST. Hint: Expand both amortization schedules to 20 years. Expand the scratch pad to 20 years. Modify FORMULA1 in cell F17 to include the new ranges. Chart. Using the BONDS3 file, prepare a line chart that plots annual interest expense over the 10-year life of this bond under both the straight-line and effective interest methods. No Chart Data Table is needed. Put A23 to A32 in the Label format and then select A23 to A32, D23 to D32, and B40 to B49 as a collection. Enter all appropriate titles, legends, formats, and so forth. Enter your name somewhere on the chart. Save the file again as BONDS3. Print the chart.

Recommended textbooks for you

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

Financial Accounting: The Impact on Decision Make…

Accounting

ISBN:

9781305654174

Author:

Gary A. Porter, Curtis L. Norton

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

(i) Based on the details of the three bonds, analyse which bond will be priced at the biggest discount. (ii) If the interest rate were to increase, discuss which bond will be affected most. (iii) If the bond rating for Bond A is lowered to BBB, discuss what must happen to the yield to maturity.