ZuoTi.Pro
Question

NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Find Cost of Debt: Suppose the average bond information...

NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE

Find Cost of Debt:
Suppose the average bond information is below for an annual coupon paying bond:
Maturity 5
Coupon 4.00%
FV $5,000.00
P $4,500.00
YTM
business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

B8 fRATE(B1, B6, -B4, B3) 1 Maturity 2 Coupon 3 FV 4 Price 4.00% $ 5,000.00 $4,500.00 6 Annual Coupon 200.00 B2 B3 RATE(B1, B

0 0
Add a comment
Know the answer?
Add Answer to:
NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Find Cost of Debt: Suppose the average bond information...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Calculate WACC: Debt Weight: 60.00% Equity Weight: 40.00% Tax...

    NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE Calculate WACC: Debt Weight: 60.00% Equity Weight: 40.00% Tax rate: 35.00% WACC: Use CAPM Cost of Equity The below information is given. I need to solve for WACC. Cost of Equity: Stock quote link Stock price: $                                           65.95 Dividend: $                                             1.66 Key statistics link Beta:                                                  1.43 Shares outstanding:                                   148,610,000 Analysts' estimates link 5-year dividend growth: 6.85% Bond center link: Risk-free rate: 0.13% Market Risk Premium: 7.00% Cost of Equity: Use DDM:...

  • Solution (s) is needed in EXCEL Format (EXCEL Formula only please) Example 2: Bond YTM Input...

    Solution (s) is needed in EXCEL Format (EXCEL Formula only please) Example 2: Bond YTM Input area: Annual coupon rate 7% Settlement date 1/1/00 Maturity date 1/1/09 Coupons per year                       1 Bond price (% of par)             96.150 Face value (% of par)                   100 Output area: Yield to maturity

  • NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE 1. Cost of Equity: Stock quote link Stock price:...

    NEED EXCEL SOLUTION: EXCEL FORMULA ONLY PLEASE 1. Cost of Equity: Stock quote link Stock price: $                                           65.95 Dividend: $                                             1.66 Key statistics link Beta:                                                  1.43 Shares outstanding:                                   148,610,000 Analysts' estimates link 5-year dividend growth: 6.85% Bond center link: Risk-free rate: 0.13% Market Risk Premium: 7.00% Cost of Equity: Use DDM: r = D/P + g Cost of Equity: Use CAPM: r = rf + B * (Rm - Rf) Please provide Excel solutions for the above two...

  • please use interpolation method only ( formula) Dont use excel or table QUESTION 4 (16 MARKS)...

    please use interpolation method only ( formula) Dont use excel or table QUESTION 4 (16 MARKS) A RM100 par value bond issued by AT&N with maturity date of 2032 and a static coupon rate of 8.50 percent. AT&N pays interest to hondholders on a semi-annual basis on Januar 15 and July 15. On January 1, 2013. the bond had 20 years left to maturity. The market's required yield to maturity for a similarly rated debt was 7.5 percent per year....

  • Cost of debt using both methods​ (YTM and the approximation​ formula)   ​Currently, Warren Industries can sell...

    Cost of debt using both methods​ (YTM and the approximation​ formula)   ​Currently, Warren Industries can sell 20-year​,​$1,000​-par-value bonds paying annual interest at a 9​% coupon rate. As a result of current interest​ rates, the bonds can be sold for ​$1,030 each before incurring flotation costs of $35 per bond. The firm is in the 30​% tax bracket. a.  Find the net proceeds from the sale of the​ bond, Nd. b.  Calculate the​ bond's yield to maturity (YTM​) to estimate the​...

  • Solution is needed in EXCEL format please (EXCEL formula needed) Example 1: Bond Pricing As with...

    Solution is needed in EXCEL format please (EXCEL formula needed) Example 1: Bond Pricing As with any financial instrument, the price of a bond is just the present value of the future cash flows. What is the price of a bond with semiannual coupon payments and the following characteristics? Coupon rate: 8.00% Years to maturity:                        10 Yield to maturity: 7.50% Par value: $               1,000 Since the bond has semiannual payments, the coupon payments will be: Coupon payments: Of course,...

  • Cost of debt using both methods (YTM and the approximation formula) Currently, Warren Industries can sell...

    Cost of debt using both methods (YTM and the approximation formula) Currently, Warren Industries can sell 10-year, $1,000-par-value bonds paying annual interest at a 7% coupon rate. Because current market rates for similar bonds are just under 7%, Warren can sell its bonds for $1,080 each; Warren will incur flotation costs of $30 per bond. The firm is in the 27% tax bracket. a. Find the net proceeds from the sale of the bond, Nd. b. Calculate the bond's yield...

  • Cost of debt using both methods (YTM and the approximation formula) Currently, Warren Industries can sell...

    Cost of debt using both methods (YTM and the approximation formula) Currently, Warren Industries can sell 10-year, $1,000-par-value bonds paying annual interest at a 11% coupon rate. Because current market rates for similar bonds are just under 11%, Warren can sell its bonds for $1,060 each; Warren will incur flotation costs of $20 per bond. The firm is in the 29% tax bracket a. Find the net proceeds from the sale of the bond, Nd. b. Calculate the bond's yield...

  • Cost of debt using both methods (YTM and the approximation formula) Currently, Warren Industries can sell 15-year, $1,0...

    Cost of debt using both methods (YTM and the approximation formula) Currently, Warren Industries can sell 15-year, $1,000-par-value bonds paying annual interest at a 9% coupon rate. Because current market rates for similar bonds are just under 9%, Warren can sell its bonds for $1,020 each; Warren will incur flotation costs of $20 per bond. The firm is in the 26% tax bracket. a. Find the net proceeds from the sale of the bond, Nd- b. Calculate the bond's yield...

  • Cost of debt using both methods​ (YTM and the approximation​ formula)   ​Currently, Warren Industries can sell...

    Cost of debt using both methods​ (YTM and the approximation​ formula)   ​Currently, Warren Industries can sell 20 dash year​, ​$1 comma 000​-par-value bonds paying annual interest at a 11​% coupon rate. Because current market rates for similar bonds are just under 11​%, Warren can sell its bonds for ​$1 comma 060 ​each; Warren will incur flotation costs of ​$20 per bond. The firm is in the 29​% tax bracket. a.  Find the net proceeds from the sale of the​ bond,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT