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-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
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
Create a table with the price of the two bonds in the case where the discount rate is 8%, 11% and 14% respectively and briefly comment on the results.
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 if the effective interest rate is 9%. Bond issue price _____arrow_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.) 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_forwardReview 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_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.) 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_forwardCalculate the accrued interest (in $) and the total proceeds (in $) of the bond sale. (Round your answers to the nearest cent.)arrow_forwardDescribe a way to estimate the inflation premium(IP) for a t-year bond.arrow_forward
- There are certain patterns we should expect to see on a bond amortization table. Complete the following statements regarding these patterns. Item Statements A. Assuming a term bond is issued at a premium, the cash interest payment calculated every period should: B. Assuming a term bond is issued at a premium, the interest expense amount calculated every period using the effective interest method should be C. Assuming a term bond is issued at a premium, the carrying value over time should be D. Assuming a term bond is issued at either a premium or a discount, the carrying value on the issuance date should be equal to the bond'sarrow_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_forwardPart I(1) What does it mean to amortize a bond premium or discount? Why is it necessary? (2) What are the two bond amortization methods mentioned in the book and how are they different? Part IIPlease select ONE of the problems below and record the proper journal entry for recording the issuance of the bond. Hint: You will need to refer to the Present Value Tables.pdf Download Present Value Tables.pdf. Please indicate which scenario you are answering. (a) On January 1, a corporation issued a $1 million, five-year, 10 percent bond that pays interest semiannually. The market interest rate on January 1 was 12 percent. (b) On January 1, a corporation issued a $1 million, five-year, 11 percent bond that pays interest semiannually. The market interest rate on January 1 was 10 percent. Part IIIPlease describe what is meant by “Times Interest Earned.” How is it calculated? Suppose you calculated this ratio for a company for two consecutive years and the results were the following: Year…arrow_forward
- You find a bond quote online listing a bond's price as "91". The bond's current price is $_______.arrow_forwardWrite down an equation for the three main components of the nominal long term interest rate on a bond, clearly explaining what each symbol stands for.arrow_forwardJournalize the first interest payment and the amortization of the related bond premium. Round to the nearest dollar. If an amount box does not require an entry, leave it blank.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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Bond Valuation - A Quick Review; Author: Pat Obi;https://www.youtube.com/watch?v=xDWTPmqcWW4;License: Standard Youtube License