BOND PRICING #2 for Borrowing Money Inc Borrowing Money Inc (BMI) issues a bond on January 1, 2021 with a face value of $400,000. The bond has an 7 year maturity date and requires SEMI ANNUAL interest payments. The bond's stated interest rate is 3% and the current market interest rate is 2%. Hint : remember to set your expectations PV tables will be needed. Do not round your PVIF, but you may round answers to whole dollars. Required : Prepare the journal entry (in proper form) at issuance of this bond for BMI. Include your journal fo grading on your PDF upload.

BOND PRICING #2 for Borrowing Money Inc Borrowing Money Inc (BMI) issues a bond on January 1, 2021 with a face value of $400,000. The bond has an 7 year maturity date and requires SEMI ANNUAL interest payments. The bond's stated interest rate is 3% and the current market interest rate is 2%. Hint : remember to set your expectations PV tables will be needed. Do not round your PVIF, but you may round answers to whole dollars. Required : Prepare the journal entry (in proper form) at issuance of this bond for BMI. Include your journal fo grading on your PDF upload.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter11: Bond Pricing And Amortization (bonds)

Section: Chapter Questions

Problem 8R: a. Reset the Data Section to its initial values. The price of this bond is 1,407,831. What would it...

See similar textbooks

Similar questions

BOND PRICING #1 for Debt Financing Company Debt Financing Company (DFC) issues a bond on January 1, 2021 with a face value of $2,000,000. The bond has a 15 year maturity date and requires SEMI ANNUAL interest payments. The bond's stated interest rate is 3% and the current market interest rate is 4%. Hint: remember to set your expectations PV tables will be needed. Do not round your PVIF, but round answers to whole dollars. Required: Prepare the journal entry (in proper form) at issuance of this bond for DFC. Include your journal for grading on your PDF upload. Your multiple step calculations must also be shown . . To get a preliminary idea of how you did you may enter your calculated amount for cash received at issuance
Find the duration of a bond with a settlement date of May 27, 2025, and maturity date November 15, 2036. The coupon rate of the bond is 8.0%, and the bond pays coupons semiannually. The bond is selling at a bond- equivalent yield to maturity of 8.0%. Use Spreadsheet 16.3 Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Macaulay duration Modified duration
A Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 5.75 percent, and the bond has a yield to maturity of 5.08 percent. What are the Macaulay duration and modified duration? (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) Macaulay duration Modified duration
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.
A Treasury bond that settles on October 18, 2019, matures on March 30, 2038. The coupon rate is 5.45 percent, and the bond has a yield to maturity of 4.66 percent. What are the Macaulay duration and modified duration? (Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places.) X Answer is complete but not entirely correct. Macaulay duration Modified duration 12.0670 11.5297
Give typing answer with explanation and conclusion 1- Imagine the bond above displayed the following details: $10,000 Matures: January 31, 2030; Interest of $200 payable June 30 and December 31 of each year. Can you calculate the annual effective interest rate for this bond? a)2% b)4% c)6% d)One cannot tell.
Revise your worksheet assumptions as indicated below and then answer the questions that folllow: Face amount Stated rate Number of years Market rate Ⓒ Discount O Premium Required: 1. Was the bond issued at a discount or a premium? Date $3,050,000 2. Complete the first four rows of the amortization schedule. (Round your answers to 2 decimal places.) June 30, 2021 December 31, 2021 June 30, 2022 December 31, 2022 8% 10 9% Cash Paid Interest Change in Carrying Expense Value Carrying Value
Intro You purchase the following bond. The bond makes interest payments on April 10 and Oct. 10 of every year: 1 Purchase date 8/19/2021 2 Maturity date 10/10/2037 3 First call date 4/10/2029 4 Coupon rate 2.8% 5 Price 83.7 6 Face value 100 7 Payment frequency 8 Day count basis 30/360 9 Call price 134.18 What is the bond's yield to maturity using Excel's YIELD function? What is the bond's yield to call using Excel's YIELD function?
A Treasury bond that settles on October 18, 2022, matures on March 30, 2041. The coupon rate is 6.10 percent, and the bond has a yield to maturity of 5.57 percent. What are the Macaulay duration and modified duration? Note: Use the duration functions in Excel to solve the problem. Do not round intermediate calculations. Round your answers to 4 decimal places. Answer is complete but not entirely correct. Macaulay duration 11.4179 Modified duration 10.8154 X
Required: Find the duration of a bond with settlement date June 11, 2018, and maturity date December 15, 2027. The coupon rate of the bond is 4%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 5%. (Do not round intermediate calculations. Round your answers to 4 decimal places.) Answer is complete but not entirely correct. Macaulay duration Modified duration 6.4600 6.8000X
Determine the price of a single bond given the following information. Round your final answer to two decimal places. For example, if your answer is $89.12, enter 89.12 with no currency symbol. 4.39% Cost of Debt (Kd) The company is expected to pay the following forecasted CFFD (Cash Flows For Debt): Year 1: $50.00 interest payment Year 2: $50.00 interest payment Year 3: $50.00 interest payment Year 4: $50.00 interest payment Year 5: $50.00 interest payment The company will also pay the bond's face value of $1,000.00 at the end of year 5. The company faces a 25% tax rate. Type your answer...
Consider the following $1,000 face value bond which makes semi- annual coupon payments, Bond Bank of Montreal Coupon rate 3% Price 108.19 Maturity June 1, 2030 Settlement Date January 3, 2019 What is the total price you would pay for this bond? Enter your answer rounded to two decimal places.