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
- Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1,000 bonds pay 8 percent interest annually and have 15 years until maturity. You can purchase the bond for $1,075. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 6 percent? Question content area bottom Part 1 a. The yield to maturity on the Saleemi bonds is enter your response here%. (Round to two decimal places.) Part 2 b. You ▼ should should not purchase the bonds because your yield to maturity on the Saleemi bonds is ▼ greater less than the one on a comparable risk bond. (Select from the drop-down menus.)arrow_forwardYou have the following information regarding an annual bond. What is the modified duration of this bond? Payment $40 YTM 6.5% Maturity (in years) 19 Par value $1,000arrow_forwardPls select the correct option and explain it.. A 50,000$ bond has a maturity date of 6 years. the bond interest rate is 6% per annum payable semi-annually. At a market interest rate of 4% per annum payable semi-annually, the present value of the bond is approximately: A) 52 341$ B) 55 288$ C) 44 291$ D) 41 695 $arrow_forward
- A callable bond has a call price of 103 and a call date of 7 years from date of issuance. It was originally a 10 year bond issued 2 years ago. What will be the n (number of periods) that you will put into your calculator to determine the yield. Question options: 5 103 32 10 8 64 16arrow_forwardK Assume that a bond will make payments every six months as shown on the following timeline (using six-month periods): 0 2 5 Period $19.53 a. What is the maturity of the bond (in years)? b. What is the coupon rate (as a percentage)? c. What is the face value? Cash Flows View an example Get more help. ★ a. What is the maturity of the bond (in years)? The maturity is years. (Round to the nearest integer.) A 6 1 MacBook Pro & 7 $19.53 * 8 9 C 59 $19.53 60 $19.53+$1,000 Clear all BUB 0 {arrow_forwardConsider the following figure which shows the relationship between a three-year bond's price (vertical axis) and the passage of time (measured in years - horizontal axis). $106.000 $104.000 $102.000 $100.000 $98.000 $96.000 $94.000 594.846 0.00 S96.688 598.567 0.50 Bond Price as Time Passes $100.4 1 $102.433 $96.433 1.00 $98.307 $100.217 1.50 $102.13 58148 2.00 Which of the following statements are consistent with the figure above? $104.148 $100.055 $106.000 $101.99 250 $103.980 This pattern of prices is consistent with a bond whose yield to maturity is below the band's coupon rate. This bond pays a coupon of $8. This bond pays coupons on an annual basis. None of the other statements are correct. 100arrow_forward
- For a one year bond of $2,300 at a simple interest rate of 10% per year, find the semiannual interest payment and the total interest earned over the life of the bond. The semiannual interest on the bond is s (Simplify your answer. Type an integer or a decimal. Round to the nearest cent as needed.) The total interest on the bond is $. (Simplify your answer. Type an integer or a decimal. Round to the nearest cent as needed.)arrow_forwardAnswer the question based on the following information for a bond having no expiration date: bond price = $1,000; bond fixed annual interest payment = $100; bond annual interest rate = 10 percent. If the price of this bond increases to $2,500, the interest rate will Multiple Choice rise to 25 percent. fall to 5 percent. fall to 2.5 percent. rise to 14 percent. fall to 4 percent.arrow_forwardQuestion Help ▼ Assume that a bond will make payments every six months as shown on the following timeline (using six- month periods): Period 1 39 Cash Flows 20.72 $20.72 $20.72 $20 a. What is the maturity of the bond (in years)? b. What is the coupon rate (as a percentage)? c. What is the face value? a. What is the maturity of the bond (in years)? The maturity is years. (Round to the nearest integer.) b. What is the coupon rate (as a percentage)? The coupon rate is %. (Round to two decimal places.) c. What is the face value? The face value is $ (Round to the nearest dollar.) Enter your answer in each of the answer boxes.arrow_forward
- Assume that a bond will make payments every six months as shown on the following timeline: 0 2 21 Period Cash Flow $57.50 $57.50 a. What is the maturity of the bond (in years)? b. What is the coupon rate (in percent)? c. What is the face value? a. What is the maturity of the bond (in years)? The maturity of the bond is 11 years. (Round to the nearest integer.) b. What is the coupon rate (in percent)? The coupon rate is 10.87 %. (Round to two decimal places.) $57.50 22 $1,057.50arrow_forwardK Assume that a bond will make payments every six months as shown on the following timeline (using six-month periods): Period 0 2 Cash Flows $19.12 $19.12 a. What is the maturity of the bond (in years)? b. What is the coupon rate (as a percentage)? c. What is the face value? a. What is the maturity of the bond (in years)? The maturity is years. (Round to the nearest integer.) 39 $19.12arrow_forwardConsider a one-year discount bond that has a present value of P1,500. If the rate of discount is 4 percent, the future value of the bond (the amount the bond pays in one year) is? a. P1,560.00 b. P1,540.00 c. P1,440.00 d. 1,442.31arrow_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning