Jiminy's Cricket Farm issued a 30-year, 7 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The company's tax rate is 22 percent. What is the pretax cost of debt? What is the aftertax cost of debt? Settlement 01/01/00 Maturity 01/01/27 Coupon rate 7% Price (% of par) 93 Redemption value (% of par) 100 Payments per year 2 Tax rate 22% Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the YIELD function. You must use the built-in Excel function to answer this question. Pretax cost of debt Aftertax cost of debt
Added by Andr-S R.
Close
Step 1
The YIELD function calculates the yield to maturity of a bond. The syntax is: YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) Where: settlement = 01/01/00 maturity = 01/01/27 rate = 7% pr = 93 redemption = 100 frequency = 2 basis = Show more…
Show all steps
Your feedback will help us improve your experience
Nick Johnson and 95 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
Jiminy's Cricket Farm issued a 20-year, 7 percent, semiannual bond four years ago. The bond currently sells for 108 percent of its face value. What is the aftertax cost of debt if the company's combined tax rate is 23 percent?
Nick J.
S14-08 Calculating Cost of Debt [LO2] Jiminy's Cricket Farm issued a 30-year, 8 percent semiannual bond 3 years ago. The bond currently sells for 93 percent of its face value. The company's tax rate is 35 percent. Suppose the book value of the debt issue is $60 million. In addition, the company has a second debt issue on the market, a zero coupon bond with 10 years left to maturity; the book value of this issue is $35 million, and the bonds sell for 57 percent of par. What is the company's total book value of debt? (Enter your answer in dollars, not millions of dollars, i.e. 1,234,567.) Total book value: $ What is the company's total market value of debt? (Enter your answer in dollars, not millions of dollars, i.e. 1,234,567.) Total market value: $ What is your best estimate of the aftertax cost of debt? (Round your answer to 2 decimal places. (e.g. 32.16)) Cost of debt: %
Sri K.
Akash M.
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD