Question: PLEASE SHOW CALCULATION STEPS AND FORMULA IN EXCEL WACC Problem Harvey LLCs capital structure consists of a 25-year bond issued 5 years ago with a

PLEASE SHOW CALCULATION STEPS AND FORMULA IN EXCEL

WACC Problem

Harvey LLCs capital structure consists of a 25-year bond issued 5 years ago with a coupon of 6% and a par value of $14,000,000. The companys main competitor just issued a similar bond paying 5%. The company has 1,000,000 common shares outstanding at a market price of $14.35 per share and a Beta from Yahoo Finance of 1.53. It has also issued 25,000 shares of preferred stock which is selling today at $235 per share and an annual dividend per share of 13.50. The firm has a 10-year $12,500,000 loan with annual payments at 6.25% interest that it received 2 years ago. The T-note rate is 1.9% and Money Magazine forecasts the return of the S&P 500 for this year at 8.5%. The tax rate for the company is 33%. Calculate the companys w.a.c.c.

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!

Please show all calculations and formulas. If using Excel (or tables), please show data, formulas, etc. Practice question 14: Calculate the companys w.a.c.c. using the info below. ***assume this is a...

Please show calcualtions and formulas. If using Excel, please show data, formulas, etc. Practice Example 14: From the below information, what is the firm's WAAC Harvey LLC's capital structure...

1.Harvey LLC's capital structure consists of a 25-year bond issued 5 years ago with a coupon of 6% and a par value of $14,000,000. The company's main competitor just issued a similar bond paying 5%....

8.1. Dulles Electric Company buys 1 million tons of coal annually to burn at its power plant. The company wants to invest in a unit train that will haul coal from the mine to the power house, where...

I. Rule of 72 Use the Rule of 72 to answer Questions 1-4. Remember to show all steps in your work, not just the answer. 1. You invest $5,000 for 12 years and earn 6% per year. What is your...

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

please let me know if you can help, I am looking to see how to arrive at the answer. Excel answers are preferred 1. QUESTION 1 A parent holding company sells shares in its subsidiary such that the...

In March 2012, President Obamas approval ratings were the highest they had been in almost a year: 46% of those that Gallup sampled approved of the job Obama was doing as president...

Incremental Analysis of Special sales order decision per unit total order (11,000 units) Revenue from special order Less Variable expense associated with the order Direct materials direct labor...

6 . A shipping employee is shipping goods to an accomplice and creating fictitious sales orders for the shipments. Which category of internal controls is being violated? Specifically, which missing...

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