The Wildhorse Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a rate of 10.375 percent. The current market rate for similar securities is 10.50 percent. Assume that the face value of the bond is $1,000, Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Problem 8.29 a-d (Excel Video)(a) What is the current market value of one of these bonds? (Round answer to 2 decimal places, eg 15.25)

The Wildhorse Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a rate of 10.375 percent. The current market rate for similar securities is 10.50 percent. Assume that the face value of the bond is $1,000, Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Problem 8.29 a-d (Excel Video)(a) What is the current market value of one of these bonds? (Round answer to 2 decimal places, eg 15.25)

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

The Pharoah Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a rate of 10.425 percent. The current market rate for similar securities is 10.30 percent. Assume that the face value of the bond is $1,000. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Problem 8.29 a-d (Excel Video)(a) Your answer is incorrect. What is the current market value of one of these bonds? (Round answer to 2 decimal places, e.g. 15.25.) Current market value $
The Pharoah Department of Transportation has issued 25-year bonds that make semiannual coupon payments at a rate of 10.425 percent. The current market rate for similar securities is 10.30 percent. Assume that the face value of the bond is $1,000. Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Problem 8.29 a-d (Excel Video)(a) ✓ Your answer is correct. What is the current market value of one of these bonds? (Round answer to 2 decimal places, e.g. 15.25.) Current market value $ eTextbook and Media Using multiple attempts will impact your score. 50% score reduction after attempt 2 Problem 8.29 a-d (Excel Video)(b) ✓ Your answer…
Create an essay using the following information: Assume you are evaluating whether to purchase the following $1,000 face value bonds: Co. X bond with a 6% coupon rate that matures in 9 years. Co. Y bond with an 11% coupon rate that matures in 7 years. Also, you may wish to review https://t.ly/wJqNM and https://t.ly/2EX2k about corporate junk (junk bonds). Given the scenario and information about junk bonds, address the following: Value these bonds assuming a market rate on similar risk bonds is 7% and interest is paid annually. Value these bonds assuming a market rate on similar risk bonds is 7% and interest is paid semi-annually. Value these bonds assuming a market rate on similar risk bonds is 12% and interest is paid annually. Assuming both bonds were issued at the same time, why would the Co. Y bond pay a higher coupon rate?
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using the Present Value Tables. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=C3” was entered, the formula would output the result from cell C3, or $500,000 in this example. Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation…
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using the Present Value Tables. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=C3” was entered, the formula would output the result from cell C3, or $500,000 in this example. Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate tab in the worksheet. When using the multi-tab cell reference, type the equal sign first, then click on the other tab and then click on the cell you want to reference. The syntax of a multi-tab cell reference looks different than a normal cell reference, since it includes the tab name surrounded by apostrophes and also an exclamation…
3. Assume you purchased a bond for $9,186. The bond pays $300 interest every six months. You sell the bond after 18 months for $10,000. Calculate the following: a. Income. b. Capital gain (or loss). c. Total return in dollars and as a percentage of the original investment. Review Only Click the icon to see the Worked Solution. a. The current income is $ (Round to the nearest dollar.) b. The capital gain (or loss) is $ (Enter a loss as a negative number and round to the nearest dollar.) c. The total return in dollars is $ (Round to the nearest dollar.) The total return as a percentage of the original investment is %. (Enter as a percentage and round to two decimal places.)
Your answer is partially correct. Swifty Ltd. issued a $1,184,000, 10-year bond dated January 1, 2023. The bond was sold to yield 12% effective interest. The bond paid 10% interest on January 1 and July 1 each year. The company's year-end was December 31, and Swifty followed IFRS. Using 1. factor Tables 2. a financial calculator, or 3. Excel function PV, calculate the amount received for the bond, and any discount or premium on the bond.
You are called in as a financial analyst to appraise the bonds of Olsen’s Clothing Stores. The $1,000 par value bonds have a quoted annual interest rate of 13 percent, which is paid semiannually. The yield to maturity on the bonds is 10 percent annual interest. There are 10 years to maturity. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Compute the price of the bonds based on semiannual analysis. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) b. With 5 years to maturity, if yield to maturity goes down substantially to 8 percent, what will be the new price of the bonds? (Do not round intermediate calculations. Round your final answer to 2 decimal places.)
please solve step by step if using BA caluculater please explain what values use for what. if using excel show the formula A broker receives an order for three bonds: (a) 7% bond (pays interest on March and September 15) maturing on September 15, 2030; (b) 5.5% bond (pays interest on May and November 1) maturing on May 1, 2035; and (c) 10% bond (pays interest on January and July 8) maturing on July 8, 2025. All three bonds pay semi-annual interest and the current market interest rate is 9% (for all three). What prices would the broker quote for each of the three bonds if the sale is settled on May 4, 2022? (a) Show your work. (b) (c) How much accrued interest would the buyer need to pay on each of the bond? Show your work. How much would the buyer actually pay for each of the bond? Show your work.
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.)
(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.)
ou are considering a 30-year, $1,000 par value bond. Its coupon rate is 11%, and interest is paid semiannually. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet If you require an "effective" annual interest rate (not a nominal rate) of 11.29%, how much should you be willing to pay for the bond? Do not round intermediate steps. Round your answer to the nearest cent. $ fill in the blank 2