Concept explainers
- 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.
Trending nowThis is a popular solution!
Chapter 11 Solutions
Excel Applications for Accounting Principles
- Issue Price The following terms relate to independent bond issues: 500 bonds; $1,000 face value; 8% stated rate; 5 years; annual interest payments 500 bonds; $1,000 face value; 8% stated rate; 5 years; semiannual interest payments 800 bonds; $1,000 face value; 8% stated rate; 10 years; semiannual interest payments 2,000 bonds; $500 face value; 12% stated rate; 15 years; semiannual interest payments Required Assuming the market rate of interest is 10%, calculate the selling price for each bond issue.arrow_forwardGoodwynn & Wolf Incorporated (G&W) issued a bond 7 years ago. The bond had a 20-year maturity, a 14% coupon paid annually, a 9% call premium and was issued at par, $1,000. Today, G&W called the bonds. If the original investors had expected G&W to call the bonds in 7 years, what was the yield to call at the time the bonds were issued?arrow_forwardOn July 1, Somerset Inc. issued $200,000 of 10%, 10-year bonds when the market rate was 12%. The bonds paid interest semi-annually. Assuming the bonds sold at 58.55, what was the selling price of the bonds? Explain why the cash received from selling this bond is different from the $200,000 face value of the bond.arrow_forward
- Which of these two bonds offers the highest current yield? Which one has the highest yield to maturity? a. A 6.55 percent, 22-year bond quoted at 52.000 b. A 10.25 percent, 27-year bond quoted at 103.625arrow_forwardSmashing Cantaloupes Inc. issued 5-year bonds with a par value of $35,000 and an 8% semiannual coupon (payable June 30 and December 31) on January 1, 2018, when the market rate of interest was 10%. Were the bonds issued at a discount or premium? Assuming the bonds sold at 92.288, what was the sales price of the bonds?arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningFinancial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax College