Question
show all work please and all the steps without using excel.
Instructions: Show all of your work for maximum credit. You may use a financial calculator and show your entries (i.e., FV =
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Step 1: Calculate the before-tax cost of debt as follows: MS-Excel → Formulas → Financials → Rate =2*RATE(15*2,8%/2*1000,-104

Step 2: Calculate the after-tax cost of debt as follows: After-tax cost of debt =Before-tax cost of debtx (1 - Tax rate) = 7.

Step 3: Calculate the cost of equity as follows: Expected dividend Cost of equity = +Growth rate Stock price x(1-flotation co

Add a comment
Know the answer?
Add Answer to:
show all work please and all the steps without using excel. Instructions: Show all of your...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

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
  • show all work pleae withot using excel. instructions: Show all of your work for maximum credit....

    show all work pleae withot using excel. instructions: Show all of your work for maximum credit. You may use a financial calculator and show your entries (i.e., FV = 1000, ete). There are 20 points possible. 1. (10 points) Moose River Industrial is in the process of expanding and raising new capital through an initial public offering of common equity. The company has a target capital structure consisting of a debt to value (wa) ratio of 30%. A current debt...

  • you may ude financial calculator and show your entries (i.e., FV = 1000, etc) . show all work and all steps without usi...

    you may ude financial calculator and show your entries (i.e., FV = 1000, etc) . show all work and all steps without using an excel. 2. (10 points) You are an outside analyst attempting to estimate the cost of capital for SSK Industrial. You do not know the corporation's target capital structure. However, the balance sheet shows a total of $55 million of long term debt with a coupon rate of 8%. The yield to maturity is 10.70% (before tax)...

  • A company has two bonds outstanding, both with semiannual coupons. The first one has a coupon...

    A company has two bonds outstanding, both with semiannual coupons. The first one has a coupon rate of 3%, a maturity of 15 years and a YTM of 9%. 39,000 of these bonds are outstanding. The second bond has a coupon rate of 9%, a maturity of 20 years and a price of $1,346.72. The book value of this issue is $19 million. The company has no preferred stock, but 6 million shares of common stock outstanding, trading at $65,...

  • 11-17, WACC. please show formula using Excel 11-15 WACC Suppose lidl Tup 35 percent debt, and...

    11-17, WACC. please show formula using Excel 11-15 WACC Suppose lidl Tup 35 percent debt, and that its before-tax cost of UED 10 equity is 13 percent. If the appropriate weighted average tax rate is 34 percent will be TapDance's WACC? (LG11-2) 11-16 WACC Suppose that JB Cos, has a capital structure of 78 percent equity, 22 percent debt, and that its before-tax cost of debt is 11 percent while its cost of equity is 15 percent. If the appropriate...

  • please show all your work 11.18 The following financial information is available on Husky Enterprises Current...

    please show all your work 11.18 The following financial information is available on Husky Enterprises Current per share market price: $10.25 Current (t-0) per share dividend: $1.00 Expected long-term growth rate: 10.5% Husky can issue new common stock to net the company $6.50 per share. Determine the cost of external equity capital using the dividend capitalization model approach. Ch12 О 25.88% О 22.97% 27.50% О 21.83% Wentworth Industries sold a 20 year $1,000 face value bond with a 12.5 percent...

  • PLEASE SHOW ALL WORK ON PAPER (So I can understand the steps) Problem 4 Assume the...

    PLEASE SHOW ALL WORK ON PAPER (So I can understand the steps) Problem 4 Assume the following: T-Bill rate = 1%, Market Risk Premium = 9%, Tax rate = 20%, Beta = 2 Stock Price = $82/per share Current Dividend = $2.75 (growth rate = 5%) Shares outstanding 100 million. Total bonds =10.526 million bonds. Price of each bond = 950 Cost of Debt = 5.15%. (a): Find the cost of equity using CAMP and the dividend growth model. Calculate...

  • The Rolling Dough Dessert Company currently has debt which consists of 8 percent coupon bonds (semi-annual...

    The Rolling Dough Dessert Company currently has debt which consists of 8 percent coupon bonds (semi-annual coupon payments) which have a maturity of 14 years and are currently priced at $1,154 per bond. There are 12,000 of these bonds outstanding. The firm also has an issue of 1 million preferred shares outstanding with a market price of $14.00 per share. The preferred shares pay an annual dividend of $0.85. RDDC also has 1.5 million shares of common stock outstanding with...

  • Can someone please show me the break down on how to figure this out using Excel...

    Can someone please show me the break down on how to figure this out using Excel or Google spreadsheet? Thanks! Merger Bid Hastings Corporation is interested in acquiring Vandell Corporation. Vandell has 1 million shares outstanding and a target capital structure consisting of 30% debt; its beta is 1.50 (given its target capital structure). Vandell has $10.88 million in debt that trades at par and pays an 7.7% interest rate. Vandell's free cash flow (FCFO) is $2 million per year...

  • The Rolling Dough Dessert Company currently has debt which consists of 8 percent coupon bonds (semi-annual...

    The Rolling Dough Dessert Company currently has debt which consists of 8 percent coupon bonds (semi-annual coupon payments) which have a maturity of 14 years and are currently priced at $1,154 per bond. There are 12,000 of these bonds outstanding. The firm also has an issue of 1 million preferred shares outstanding with a market price of $14.00 per share. The preferred shares pay an annual dividend of $0.85. RDDC also has 1.5 million shares of common stock outstanding with...

  • Part B Cost of Capital (Show all workings ) Grainwaves Ltd is an Australian firm which...

    Part B Cost of Capital (Show all workings ) Grainwaves Ltd is an Australian firm which is publicly-listed on the ASX. The company has a long term target capital structure of 55% Ordinary Equity, 5% Preference Shares, and 40% Debt. All of the shareholders of Grainwaves are Australian residents for tax purposes. To fund a major expansion Grainwaves Ltd needs to raise a $150 million in capital from debt and equity markets. Grainwaves Ltd’s broker advises that they can sell...

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