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.

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.

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 7R

See similar textbooks

Similar questions

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 Answer
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
f. Now assume the date is October 25, 2019. Assume further that a 12%,10-year bond was issued on July 1, 2019, pays interest semiannually (onJanuary 1 and July 1), and sells for $1,100. Use your spreadsheet to findthe bond’s yield.
Suppose 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.
You have the following information regarding an annual bond. What is the modified duration of this bond? Payment $40 YTM 6.5% Maturity (in years) 19 Par value $1,000
Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1,000 bonds pay 8 percent interest annually and have 15 years until maturity. You can purchase the bond for $1,075. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 6 percent? Question content area bottom Part 1 a. The yield to maturity on the Saleemi bonds is enter your response here%. (Round to two decimal places.) Part 2 b. You ▼ should should not purchase the bonds because your yield to maturity on the Saleemi bonds is ▼ greater less than the one on a comparable risk bond. (Select from the drop-down menus.)
Q4. A long term bond with a face value of $10,000 has a bond interest rate of 6% per year pay: quarterly. What are the amount of the interest payments? (a) $160 (b) $150 (c) $170 (d) $155 (e) your answer (... ......)
Suppose the current interest rate on a one-year bond is 2% and the current interest rate on a two-year bond is 4%. The term premium on a two-year bond is 1%. According to the expectations hypothesis, what interest rate should we expect on a one-year bond next year? Answer as a percentage to one decimal place and do not include symbols (e.g. $, %, commas) in your answer. Answer:
4. We can define bond as a financial device through which a borrower (a firm or government) is obligated to pay the principal and interest on a loan at specific dates in the future. Answer questions relating to interest rates and bond prices using the following information: The price of a bond with no expiration date is $1000 and its fixed annual interest payment is $50; bond annual rate of interest is 5%. (a) If the price of this bond decreases by $250 to $750, what will its effective interest rate be for the new buyer? %, because (b) If the price of this bond increases to $1200, what will its effective interest rate be for the new buyer? (c) When bond prices go up from (a) to (b), interest rates go (up, down, nowhere). %, because
(Related to Checkpoint 9.2) (Yield to maturity) The Saleemi Corporation's $1,000 bonds pay 12 percent interest annually and have 11 years until maturity. You can purchase the bond for $945. a. What is the yield to maturity on this bond? b. Should you purchase the bond if the yield to maturity on a comparable-risk bond is 14 percent? Question content area bottom Part 1 a. The yield to maturity on the Saleemi bonds is enter your response here%. (Round to two decimal places.)
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.
Caiculate the purchase price of the $1,000 face value bond using the information given below. (Do not round the intermediate calculations. Round your final answer to 2 decimal places.) Issue date Dec 15, 1991 Maturity date Dec 15, 2026 Purchase date ১une 15, 2013 Coupon rate (XY 5.50 Market rate (X). 7,4 Assume that • Bond interest is paid semiannually. • The bond was originally issued at its face value. • Bonds are redeemed at their face value at maturity • Market rates of return are compounded semiannually Bond price