Question: please show step by step how you got the answer using excel YMMV Inc. issues a bond with a face value of $85,000,000 with a

please show step by step how you got the answer using

please show step by step how you got the answer using excel

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 annual deposits into a sinking fund paying 1.750% compounded monthly. YMMV defaults on the bond after 24 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. $484,216.29. O b. $430,414.48. C. $443,864.93. d. $448,348.42. e. $511,117.20. Certainty @ : OC=1 (Unsure: 67%) OC=3 (Quite sure: >80%)

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 Accounting Questions!

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

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Need to complete 10 homework but now i need 5 homework then after some time 5 homework more. Here it is attachment. Chapter 5 HW Questions [ALL OF THESE MUST BE DONE IN EXCEL] 1. Future value: Chuck...

I've attached the question as a word file, thanks! JWCL165_c10_444-505.qxd 8/12/09 7:24 AM Page 444 10 Liabilities Chapter STUDY OBJECTIVES After studying this chapter, you should be able to: 1...

Read the following information East Coast Yachts was founded 10 years ago by Larissa Warren. The companys operations are located near Hilton Head Island, South Carolina. The company has manufactured...

Please provide excel spreadsheet detailing how you got to the multiple choice answer. I am trying to get ahead and understand each of the practiceproblems in prep for a exam so it would be very...

Excel Case #2 - United Parcel Service, Inc. (UPS) D1 Total points available 20 1 U 1 The Answer Schedule shows the points per question / answer 5 Points available for each answer are all or nothing -...

Executive Memorandum (EM) Guidelines Prepare an executive summary of the papers that is only one page long.The assignment should be typed in Word, font size 11 double spaced, with minimum margins of...

Hello, Can I get some help figuring out the "solution" portion of this excel file. Thank you Ross, Westerfield, and Jordan's Spreadsheet Master Fundamentals of Corporate Finance, 10th edition by Brad...

Each of the following compounds is incorrectly named. What is wrong with each name, and what is the correct name for each compound? a. FeCl3, iron chloride b. NO2, nitrogen(IV) oxide c. CaO,...

Assume the economy is in a recession, and a stimulus package of $800 billion is passed by the federal government. The administration predicts that this measure will provide a $3,200 billion boost to...

The ability to generate positive market expectations is called: 45:04 Multiple Choice O Liquidity and solvency. O Profitability. O Liquidity and efficiency. O Creditworthiness. O Market prospects

An ethical challenge with performance management is to do so , equitably, within what? a corporate framework that seeks to look at fairness in the big picture a diverse team a limited timeframe a...

Do your professors use consistent standards in terms of the work they require in their courses and the performance appraisal grades they give? Or do some professors require more work than others? Do...

Can a multinational company have one organizational culture, or does it need to have different cultures based on its business unit in each country?

Analysts have called for a change in GoPros top management, in particular, its founder, Nick Woodman. Why do you think the firm has not made that change?