Question: please show the answer in excel thx YMMV Inc. issues a bond with a face value of $65,000,000 with a coupon rate of 8.750% maturing

please show the answer in excel thx YMMV Inc. issues a

please show the answer in excel thx

YMMV Inc. issues a bond with a face value of $65,000,000 with a coupon rate of 8.750% maturing in 24 years. The current yield rate is r(26) = 2.500%. TFC will secure the bond by making monthly deposits into a sinking fund paying 10.000% compounded monthly. YMMV defaults on the bond after 23 years (just after making their coupon payment, and sinking fund deposit). The bondholders receive the balance in the sinking fund. How much money do they lose? a. $10,760,567.68 b. $9,146,482.53. X c. $10,545,356.33. d. $8,823,665.50 e. $10,007,327.94. Certainty : C=1 (Unsure: 67%) C=3 (Quite sure: >80%) Your answer is incorrect. The correct answer is: $10,760,567.68

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

YMMV Inc. issues a bond with a face value of $65,000,000 with a coupon rate of 8.750% maturing in 24 years. The current yield rate is r(26) = 2.500%. TFC will secure the bond by making monthly...

please help YMMV Inc. issues a bond with a face value of $85,000,000 with a coupon rate of 3.750% maturing in 26 years. The current yield rate is r(365) = 8.500%. TFC will secure the bond by making...

"Global Manufacturing has 2,550,000, shares of common stock outstanding. The current share price is 115.67. Global also has two semi-annual bond issues outstanding. The first bond issue has a face...

:Help me answer all questions . This problem examines the effects of an increase in ?on the optimal choice of the fraction of risky assets (?) in the portfolio choice model presented in Lecture 10....

Hi I need answers immediately. Attached is a file. I need the detailed solutions (no excel, can be typed or handwritten) to the long answer portions ONLY. Please read instructions for rounding rules....

!Answer all please. 53. Assume the spot rates for year 1, year 2 and year 3 are 3.5%, 4% and 4.5%, respectively. There are a 3-year zero coupon bond and a 3-year coupon bond that pays a 5% coupon...

i am taking Cooperate finance which is FIN222 can help me to answer.. ? Tutorial 1 Topic 1 Chapter 1 4. What are the main advantages and disadvantages of organising a firm as a corporation? 6. You...

BACKGROUND An SM bond is a 35-year Australian government bond with a face value of $1. They are marketed to consumers saving for retirement (who buy the S part) and investors (who buy the M part)....

need this done in 2hrs...multiple choice..see attached QUESTION 1 The tax rate that determines the amount of tax that will be due on the next dollar of taxable income earned is called the: 1. average...

Please show Excel formula and show work fully to answer these problems 3 3 Dinklage Corp. has 8 million shares of common stock outstanding. The current share price is $73. The most recent dividend...

What determines the maximum potential to which the dome of a Van de Graaff generator can be raised?

1) Is the United States doing enough to prevent offshore transactions similar to those found in the Pandora Papers? 2) What laws are the United States implementing to prevent offshore transactions or...

All commercially available infant formulas are based on milk proteins and therefore contain hastose. True False

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...