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 6R
Use the worksheet to compute the
Bond issue price $ _____
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
From 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 rate
You find a bond quote online listing a bond's price as "91". The bond's current price is $_______.
A bond is currently selling for $980. This is a _____ bond which will ultimately experience a capital _____.
Premium; gain
Premium; loss
Discount; gain
Discount; loss
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
- Use 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_forwardSelect the correct answer to each of the following statements. A. Increase B. Decrease C. Remain Constant 1. The amount of interest expense will _______ each payment period for a bond issued at a discount. 2. When a bond is issued at a discount, the cash interest payment will _________ over the life of the bond. 3. When a bond is issued at a premium, the carrying value of the bond will _______ over the life of the bond.arrow_forwardCalculate the value of each bond and discuss whether it sells at par, discount, or premium. (Annual interest rate) O A. Bond Bond Value A B C O B. Bond A B C O C. Bond A B с O D. Bond A B C $1,149.39 Discount $1,000.00 Par $85.60 Premium Bond Value Sells at par/discount/premium Bond Value $1,149.39 Premium $1,000.00 Par $85.60 Discount Sells at par/discount/premium Bond Value Sells at par/discount/premium $1,149.39 Premium $1,000.00 Par $85.60 Premium Sells at par/discount/premium $1,049.39 Premium $1,100.00 Premium $85.60 Discount Bond Par value Coupon interest Years to rate maturity JA B IC $1000 14% $1000 18% $100 10% 120 16 18 Required return 12% 8% 13%arrow_forward
- Listen Assume that there is a bond that pays $20.00 at the and of year 2, and $105.00 at the end of year 7. It sells at a total =$(20.00+105.00). The Macauley duration of the bond is? Answer with two digits decimal accuracy. Blank Excel Worksheet Your Answerarrow_forwardGiven the information below, which bond(s) will be issued at a discount? Stated Rate of Return Market Rate of Return. Bond 1. O Bond 2. Bond 4. O Bonds 1 and 2. Bond 1 5% 7% Bond 2 7% 8% Bond 3 12% 12% Bond 4 10% 9%arrow_forwardWhat is assumed the be the face value aka par value aka principal aka loan amount of a bond? It's also assumed to be a bond's FV. 10% $0 $100 $1,000arrow_forward
- Review the following three bonds payable assumptions: (Click the icon to view the bond assumptions.) Journalize issuance of the bond and the first semiannual interest payment under each of the three assumptions. The company amortizes bond premium and discount by the effective-interest amortization method. Explanations are not required. (Record debits first, then credits. Exclude explanations from any journal entries. Round your final answers to the nearest whole dollar.) x lid semiannually. The market rate of interest is 10% at issuance. The present value of the bonds at issuance is $84,000. More Info 1. Seven-year bonds payable with face value of $84,000 and stated interest rate of 10%, paid semiannually. The market rate of interest is 10% at issuance. The present value of the bonds at issuance is $84,000. 2. Same bonds payable as in assumption 1, but the market interest rate is 12%. The present value of the bonds at issuance is $76,167. 3. Same bonds payable as in assumption 1, but…arrow_forwardPls help with below homework.arrow_forwardSuppose a bond with no expiration date has a face value of $10,000 and annually pays a fixed amount of interest of $750, calculate the interest rate that the bond would yield to a bond buyer. Show all work.arrow_forward
- Review the following three bonds payable assumptions: 1 (Click the icon to view the bond assumptions.) Journalize issuance of the bond and the first semiannual interest payment under each of the three assumptions. The company amortizes bond premium and discount by the effective-interest amortization method. Explanations are not required. (Record debits first, then credits. Exclude explanations from any journal entries. Round your final answers to the nearest whole dollar.) O More Info semiannually. 1. Ten-year bonds payable with face value of $89,000 and stated interest rate of 14%, paid semiannually. The market rate of interest is 14% at issuance. The present value of the bonds at issuance is $89,000. 2. Same bonds payable as in assumption 1, but the market interest rate is 16%. The present value of the bonds at issuance is $80,301. 3. Same bonds payable as in assumption 1, but the market interest rate is 12%. The present value of the bonds at issuance is $99,226. Print Donearrow_forwardReview the following three bonds payable assumptions: (Click the icon to view the bond assumptions.) Journalize issuance of the bond and the first semiannual interest payment under each of the three assumptions. The company amortizes bond premium and discount by the effective-interest amortization method. Explanations are not required. (Record debits first, then credits. Exclude explanations from any journal entries. Round your final answers to the nearest whole dollar.) More Info - X Jaid semiannually. The market rate of interest is 10% at issuance. The present value of the bonds at issuance is $86.0000. 1. Seven-year bonds payable with face value of $86,000 and stated interest rate of 10%, paid semiannually. The market rate of interest is 10% at issuance. The present value of the bonds at issuance is $86.000. 2. Same bonds payable as in assumption 1, but the market interest rate is 12%. The present value of the bonds at issuance is $77,981. 3. Same bonds payable as in assumption 1,…arrow_forwardThe table below shows current and expected future one-year interest rates, as well as current interest rates on multiyear bonds. Use the table to calculate the liquidity premium for each multiyear bond. Year One-Year Bond Rate Multlyear Bond Rate 1 2.00% 2.00% 2 5.00% 5.00% 6.00% 7.00% 7.00% 9.00% 9.00% 11.00% The liquidity premiums for each year are given as: (Enter your responses rounded to two decimal places) 111 = 121= ly= 141. = 151 135 %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
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
Bond Valuation - A Quick Review; Author: Pat Obi;https://www.youtube.com/watch?v=xDWTPmqcWW4;License: Standard Youtube License