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
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…
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,…
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
- 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_forwardThere 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_forwardPls help with below homework.arrow_forward
- Select 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_forwardYou 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_forward
- 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.arrow_forwardPlease answer both. This is part A and Barrow_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
- Calculate YTC using a financial calculator by entering the number of payment periods until call for N, the price of the bond for PV, the interest payments for PMT, and the call price for FV. Then you can solve for 1/YR YTC. Again, remember you need to make the appropriate adjustments for a semiannual bond and realize that the calculated 1/YR is on a periodic basis so you will need to multiply the rate by 2 to obtain the annual rate. In addition, you need to make sure that the signs for PMT and FV are identical and the opposite sign is used for PV; otherwise, your answer will be incorrect. A company is more likely to call its bonds if they are able to replace their current high-coupon debt with less expensive financing. A bond is more likely to be called if its price is above par-because this means that the going market interest rate is less than its coupon rate. Quantitative Problem: Ace Products has a bond issue outstanding with 15 years remaining to maturity, a coupon rate of 8.4%…arrow_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_forwardIf 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_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
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
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