Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 11, Problem 3R
To determine
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, what is the first thing you want to identify when approaching a bond problem?
Group of answer choices
A. Annual bond or semiannual bond
B. Whether the market rate is different from the stated rate.
C. The cash flows provided by the bond.
D. The company's debt to equity ratio.
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?
Suppose 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.
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
Similar questions
- Use the worksheet to compute the bond issue price if the effective interest rate is 9%. Bond issue price _____arrow_forwardUse the worksheet to compute the bond issue price and amortization schedules if the effective interest rate is 8.2%. Save the file as BONDS5. Print the worksheet when done. Also, repeat requirement 4 in the space provided below for this bond.arrow_forwarda. 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_forward
- If bonds are redeemed on maturity date, any premium or discount a. Is carried forward and written off in the same manner as that used prior to the maturity date. b. Should be used to calculate the gain or loss resulting from the maturity of the bonds. c. Should be written off directly to a bond retirement account as the bond will be redeemed. d. Will be fully amortized as its amortization period is designed to coincide with the life of the bond issue.arrow_forwardFrom 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 ratearrow_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
- Suppose 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_forwardFrom page 9-3 of the VLN, when determining the issue price of a bond, which interest rate would you use? Group of answer choices A. Stated rate B. Market rate C. Nominal rate D. Compound ratearrow_forwardThe 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_forward
- 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?arrow_forwardPlease see attached. Definitions: Coupon is the regular interest payment of a bond. Coupon rate is the interest rate for the bond coupons, expressed in annual percentage terms. Par value is the principal amount to be repaid at the maturity of the bond. Yield to maturity (YTM) is the return the bond holder receives on the bond if held to maturity. Maturity date is the expiration date of the bond on which the final interest payment is made as well as the principal repayment.arrow_forwardCompute for the following given statement and justify your answer. Consider two bonds. Bond X has a face value of ₱100,000 and five years remaining to maturity. BondY has a face value of ₱100,000 and ten years remaining to maturity. Both bonds have the same statedrate of 12%. Which bond has the greatest interest rate risk?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 Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher: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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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
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