Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 11, Problem 5R
Use the worksheet to compute the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
From page 9-2 of the VLN, how do you determine the annuity cash flow (the bond interest payment) from an annual bond?
Group of answer choices
A. Bond payable x stated rate
B. Bond liability x stated rate
C. Bond payable x market rate
D. Bond liability x market rate
Compute for the following given statement and justify your answer.
1. Consider two bonds. Bond A has a face value of ₱100,000 and a stated rate of 12%. Bond B has a facevalue of ₱100,000 and a stated rate of 8%. Both bonds have the same maturity. Which bond has thegreatest interest rate risk?
Consider two bonds. Bond A has a face value of ₱100,000 and a stated rate of 12%. Bond B has a face value of ₱100,000 and a stated rate of 8%. Both bonds have the same maturity. Which bond has the greatest interest rate risk?
Provide a computation
Chapter 11 Solutions
Excel Applications for Accounting Principles
Ch. 11 - The University Club recently issued 1,500,000 of...Ch. 11 - The bond pricing formula utilizes the NPV (Net...Ch. 11 - Prob. 3RCh. 11 - Prob. 4RCh. 11 - Use the worksheet to compute the bond issue price...Ch. 11 - Use the worksheet to compute the bond issue price...Ch. 11 - Prob. 7RCh. 11 - a. Reset the Data Section to its initial values....
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.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.arrow_forwardSuppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $700. a. In the table provided below, calculate and enter either the interest rate that the bond would yield to a bond buyer at each of the bond prices listed below or the bond price at each of the interest yields shown. Instructions: Enter your answers in the gray-shaded cells. For bond prices, round your answers to the nearest hundred dollars. For interest yields, round your answers to 2 decimal places.arrow_forwardShow all workings. Complete the following table and draw a graph showing how bond pricefor each bond changes over time as they move towards their maturitydates. Describe the relationship between bond prices and timeremaining for maturity.YearsreminingtomaturityBOND ACoupon rate = 8% p.a.Market interest rate =6% p.a.BOND BCoupon rate = 6% p.a.Market interest rate =6% p.a.BOND CCoupon rate = 4% p.a.Market interest rate =6% p.a.109876543210arrow_forward
- The prices of several bonds with face values of $1,000 are summarized in the following table: For each bond, state whether it trades at a discount, at par, or at a premium.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_forward*See the attached photo The issue price of the bonds is a. P 1,767,120b. P 1,769,640c. P 1,779,120d. P 1,999,200arrow_forward
- The prices of several bonds with face values of $1,000 are summarized in the following table For each bond, state whether it trades at a discount, at par, or at a premium. Bond A is selling at ▼ a discount par a premium . (Select from the drop-down menu.)arrow_forwardPlease advise if the bond interest expense is $29K, $18200 or $21800. Thanks.arrow_forwardSuppose you are provided with the following table of spot rates of different maturity bonds: Year Spot rate 1 8 2 9 3 7 4 8 5 10 Calculate, respectively, one period forward rates of these bonds for year 2, year 3 and year 4.arrow_forward
- Consider an A-rated bond and a B-rated bond. Assume that the one-year probabilities of default for the A- and B-rated bonds are 1% and 3%, respectively, and that default correlation between the two bonds is 20%. What is the joint probability of default of the two bonds?arrow_forwardCalculate the quoted price on June 1, 2011 of the bond outlined below. (Assume that the face value is $100, that the purchase price is $923.19, that the bond interest is paid semiannually, that the bond was originally issues at its face value, that the bond is redeemed for its face value at maturity and that the market rate is compounded semiannually)arrow_forwardIf bonds are issued at 101.25, this means thata. a $1,000 bond sold for $1,012.50.b. a $1,000 band sold for $101.25.c. the bonds sold at a discount.d. The bond rate of interest is 10.125% of the market rate of interest.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781337272124
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial Accounting
Accounting
ISBN:9781305088436
Author:Carl Warren, Jim Reeve, Jonathan Duchac
Publisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Bond Valuation - A Quick Review; Author: Pat Obi;https://www.youtube.com/watch?v=xDWTPmqcWW4;License: Standard Youtube License