Rate function-what is yield-to-maturity

Assignment Help Financial Accounting

Reference no: EM133208443

You must use the "Rate" function in Excel to solve this problem. Assume Art Levinsen Corporation is contemplating purchasing its own 6%, 20-year bonds on the open market on December 31, 20X6 for $748,485. These bonds pay interest every six months (June 30 and December 31), and the market interest rate is 10%. HINTS: Interest payments (Pmt) and the future value (Fv) must be entered as negative numbers into the Rate function fields. Assume interest payments are at the end of the period. For "Guess" use .11 to represent 11%. The resulting rate will be for 6 months and therefore must be multiplied by 2 for an annual yield.

a. What is the yield-to-maturity for these bonds at 12/31/20X6 with 14 remaining years until maturity.

Reference no: EM133208443

Questions Cloud

Describe how signal transduction occurs : Describe how signal transduction occurs in your chosen special sense organ. Distinguish how it is different from signal transduction in a somatic peripheral

Anatomical concepts associated with skeletal muscles : Explain the anatomical concepts associated with skeletal muscles and joints. Summarize this module's key points in 5-6 sentences

Explain how the motivation theories are relevant in scenario : You will write a minimum of 250 words in Word document for this journal assignment - Explain how the motivation theories are relevant in scenario

What are the two main solutes found in urine : What are the four different triggers that can trigger the thirst response? 6. Where is the thirst center found and What are the two main solutes found in urine

Rate function-what is yield-to-maturity : You must use the "Rate" function in Excel to solve this problem.What is the yield-to-maturity for these bonds at 12/31/20X6

Documenting the risks for each vulnerability : Develop a 10- to 12-slide Microsoft PowerPoint presentation documenting the risks for each vulnerability to be presented to the leadership

Describe what specific instruments should be used : Describe what specific instruments should be used when embalming from the femoral site, and from the carotid site

How does muscle contraction occur for mike to run : BIO 227 Northwestern Michigan College - How does muscle contraction occur for Mike to run? What are three steps (there may be more, I only need three)

What did was most interesting about the circulatory system : What did was the most interesting about the circulatory system and Name at least two things not known before watching the video

User Account

All Pages