How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask linda_us Your Own Question
linda_us, Master's Degree
Category: Business and Finance Homework
Satisfied Customers: 7291
Experience:  A tutor for Business, Finance, Accounts and other related topics.
Type Your Business and Finance Homework Question Here...
linda_us is online now
A new question is answered every 9 seconds

To finance the purchase, Ranch Manufacturing will sell 10-year

This answer was rated:

To finance the purchase, Ranch Manufacturing will sell 10-year bonds paying 6.6% per year at the market value of the firm's capital structure as follows:
Bonds $4,400,000
Preferred Stock $2,500,000
Common Stock $5,900,000

To finance the purchase, Ranch Manufacturing will sell 10-year bonds paying 6.6% per year at the market price of $1,054. Preferred stock paying a $1.95 dividend can be sold for $25.76. Common stock for Ranch Manufacturing is currently selling for $54.96 per share and the firm paid a $2.91 dividend last year. Dividends are expected to continue growing at a rate of 4.6% per year into the indefinite future. If the firm's tax rate is 30%, what is their WACC?

linda_us :

Welcome to the Site.

linda_us :

My name is XXXXX XXXXX I can help you with this quesiton.

linda_us :

I am working on it and will post the solution soon.

linda_us and other Business and Finance Homework Specialists are ready to help you

Click here for solution

Please rate my solution by clicking smiley face so that I get paid.

Let me know if you need any further help. You can request me in future by writing "FOR LINDA" at start of your post.
Customer: replied 3 years ago.
Hi Linda,

Thank you for your reply. Can you give me more detail on the bond calculation? I do not have a financial calculator and need to perform this calculation manually.

Thank you.
I have used the Rate formula in Excel. We can use the Approximate yield formula or long formula (where we equate cash inflows to cash outflows).

Refer this link for Approximate Yield formula

For long formula we will need to solve the following equations

1054 = 66/(1+r) + 66/(1+r)^2 + 66/(1+r)^3 + 66/(1+r)^4 + 66/(1+r)^5 + 66/(1+r)^6 + 66/(1+r)^7 + 66/(1+r)^8 + 66/(1+r)^9 + 66/(1+r)^10 + 1000/(1+r)^1000.

Solving by Approximate formula we give us a approximate result and will not be 100% accurate and solving by long formula is also a tedious process and we might have to try various figure (we still can make mistake or not arrive at correct answer).

I have done this questions atleast 50 time and even a small difference in answer (say .002%) would also be recognized as incorrect answer so the best way to solve is use excel or financial calculator.

I hope this helps. Let me know if you need any further clarification.
Customer: replied 3 years ago.

Got it. I see you put the formulas in the spreadsheet you provided. Thank you so much!

Customer: replied 3 years ago.

I have another question that I'd like you to help me learn the process of solving, if you're available.

I am available and would be happy to help.

You can create a new thread and write "FOR LINDA" at start of your post to request me.

Related Business and Finance Homework Questions