You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem: (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Round all answers to two decimal places.
Raven Co. expects to pay a dividend of $7.10 per share in one year. The current price of Raven common stock is $63.40 per share. Flotation costs are $5.00 per share when Raven issues new stock. What is the cost of internal common equity if the long-term growth in dividends is projected to be 4.75 percent indefinitely?
For Internal Common Equity, we don't use flotation costs in the calculation, as they are only considered for the new issues or external equity.
So,
r = [D1/P0] + g
= [$7.10 / $63.40] + 0.0475 = 0.1120 + 0.0475 = 0.1595, or 15.95%
You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve 10 problems related to the cost of capital. You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. iii) Calculate the correct solution to the problem. Round all answers to two decimal places. CosaNostra Pizza is...
You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. QUESTION : Raven Co. expects to pay a dividend of $3.15 per share in one year. The current price of their...
Jiffy Co. expects to pay a dividend of $3.25 per share in one year. The current price of Jiffy common stock is $54.50 per share. Flotation costs are $8.00 per share when Jiffy issues new stock. What is the cost of internal common equity if the long-term growth in dividends is projected to be 4.75 percent indefinitely?
11-23 Floatation cost. Please use Excel to show formula.
11-22 WACC Weights WhackAmOle has 2 million shares of common stock outstanding, 1.5 million shares of preferred stock outstanding, and 50,000 bonds. If the common shares are selling for $63 per share, the preferred shares are selling for $52 per share, and the bonds are selling for 103 percent of par, what would be the weights used in the calculation of WhackAmOle's WACC? (LG11-4) 11-23 Flotation Cost Suppose that Brown-Murphies' common...
I need someone to show me step by step explanations. If you use
excel please attach two photos, one showing the results in each
cell. Plus another photo showing the formula in the cell. Also
please highlight the results for a, b, c and d.
Question 18 is worth 15 points 18.Black Diamond, Inc., a manufacturer of carbon and graphite products for the aerospace and transportation industries, is considering several funding alternatives for an investment project. To finance the project,...
Use an excel spreadsheet to solve the following problem. Please submit your spreadsheet with your answer. Make sure to use variable costs and fixed cost appropriately. You have been asked to perform a break-even analysis on the summer art camp. You need to determine how many students must attend in order for the camp to break-even this summer. Setup an Excel spreadsheet with the data below and use the goal seek option in Excel to determine your answer. Submit the...
You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. QUESTION: Enzo, Inc. has a target capital structure of 40% debt and 60% common equity and is in the 40% marginal...
Saccar Inc. expects to pay a dividend of $1.83 per share in one year. The current price of Saccar common stock is $30.04 per share. Flotation costs are $2.36 per share when the corporation issues new stock. What is the cost of internal common equity (retained earnings) if the long-term growth in dividends is projected to be 4 percent indefinitely? Submit your answer as a percentage and round to two decimal places (Ex. 0.00%) Cantink Corporation plans to issue new...
You are required to show the following 3 steps for each problem (sample questions and solutions are provided for guidance): (i) Describe and interpret the assumptions related to the problem. (ii) Apply the appropriate mathematical model to solve the problem. (iii) Calculate the correct solution to the problem. Submit all answers as percentages and round to two decimal places. QUESTION: Lee Airlines plans to issue 15-year bonds with a par value of $1,000 that will pay $50 every six months....
Ch 10: Assignment- The Cost of Capital 6. Cost of new common stock True or False: The following statement accurately describes how firms make decisions related to issuing new common stock. Taking flotation costs into account will reduce the cost of new common stock. O True: Taking flotation costs into account will reduce the cost of new common stock, because you will muitiply the cost of new common stock by 1 minus the flotation cost-similar to how the after-tax cost...