Question

In: Finance

Instructions: Show all your work to get partial credit. Answers without any work-even correct-will not receive...

Instructions: Show all your work to get partial credit. Answers without any work-even correct-will not receive any credit. Good Luck!

A firm is considering investing in a new project. According to its cost of capital while using debt, preferred stock and new common stock, the project is expected to have an initial after-tax cost of $5,000,000. Furthermore, the project is expected to provide after-tax operating cash flows of $1,800,000 in year 1, $2,900,000 in year 2, $2,700,000 in year 3 and $2,300,000 in year 4.

A firm has determined its optimal capital structure, which is composed of the following sources and target market value proportions.


Source of Capital

Target Market
Proportions

Long-term debt

   40%

Preferred stock

   10%

Common stock equity

   50%

Debt: The firm can raise debt by selling 15-year, $1,000 par value, 9% coupon interest rate bonds that pay annual interest. A flotation cost of 4 percent of the face value would be required in addition to the premium of $10.

Preferred Stock: Preferred stock, regardless of the amount sold, can be issued with an $80 par value and a 12% annual dividend rate. The cost of issuing and selling the stock is $3 per share.

Common Stock: The firm’s common stock is currently selling for $10 per share. The dividend that was paid last year was $0.87. Its dividend payments have been growing at a constant rate of 5% per year. It is expected that to attract buyers, a new common stock issue must be underpriced $2 per share, and the firm must also pay $1 per share in flotation costs.

Retained Earnings: A corporation expects to have earnings available to common shareholders (net income) of $1,000,000 in the coming year. The firm plans to pay 40 percent of earnings available in cash dividends. The retained earnings have been already exhausted. Therefore, the firm will use new common stock as the form of common equity financing. Additionally, the firm’s marginal tax rate is 40 percent.

  1. Maximum acceptable payback period of this project is 3 years. Calculate the payback period for this project.
  2. Calculate the project’s NPV.
  3. Calculate the project’s IRR.
  4. Should the firm make the investment? Why?

Solutions

Expert Solution

CALCULATION OF COST OF CAPITAL:
1] Before tax cost of debt = YTM
YTM using a online calculator = 9.38%.
[Inputs for YTM are, Price = 1000+10-40 = 970;
Coupon = 9%, Frequency = Annual, Years = 15]
After tax cost of debt = YTM*(1-t) = 9.38%*(1-40%) = 5.63%
2] Cost of preferred stock = Preferred dividend/Price = 80*12%/(80-3) = 12.47%
3] Cost of new equity using constant dividend growth model = Next expected dividend/(Price-discount-Flotation cost)+Growth rate = 0.87*1.05/(10-2+1)+0.05= 15.15%
4] WACC = 5.63%*40%+12.47%*10%+15.15%*50% = 11.07%
a] Year Cash flow Cumulative Cash Flow
0 $ -50,00,000 $ -50,00,000
1 $      18,00,000 $ -32,00,000
2 $      29,00,000 $ -3,00,000
3 $      27,00,000 $      24,00,000
4 $      23,00,000 $      47,00,000
Payback period = 2+300000/2700000 = 2.11 Years
b] Year Cash flow PVIF at 11.07% PV at 11.07%
0 $ -50,00,000 1 $ -50,00,000
1 $      18,00,000 0.90090 $       16,21,622
2 $      29,00,000 0.81162 $       23,53,705
3 $      27,00,000 0.73119 $       19,74,217
4 $      23,00,000 0.65873 $       15,15,081
NPV $       24,64,625
c] IRR is that discount rate for which NPV = 0. It has to be found out by trial and error by discounting
the cash flows at various interest rates till 0 NPV is got.
Year Cash flow PVIF at 32% PV at 32% PVIF at 31% PV at 31%
0 $ -50,00,000 1 $ -50,00,000 1 $ -50,00,000
1 $      18,00,000 0.75758 $       13,63,636 0.76336 $   13,74,046
2 $      29,00,000 0.57392 $       16,64,371 0.58272 $   16,89,878
3 $      27,00,000 0.43479 $       11,73,929 0.44482 $   12,01,019
4 $      23,00,000 0.32939 $         7,57,586 0.33956 $ 7,80,985
NPV $           -40,477 $ 45,928
0 NPV is got between discount rates of 31% and 32%.
By simple interpolation, IRR = 31%+1%*45928/(45928+40477) = 31.53%
d] The investment should be made as:
*The payback perioid is less than the maximum acceptable payback period.
*NPV is positive [because of which IRR>WACC]

Related Solutions

Instructions: Show all calculations in detail. No partial credit will be given for just answers. 3....
Instructions: Show all calculations in detail. No partial credit will be given for just answers. 3. An importer of Swiss watches has an account payable of CHF750,000 due in 90 days. The following data is available: Rates and prices in US-cents/CHF.               Spot rate: 71.42 cents/CHF 90-day forward rate: 71.14 cents/CHF US –dollar 90-day interest rate: 3.75% per year Swiss franc 90-day interest rate: 5.33% per year Option Data in cents/CHF _______________________________                         Strike                     Call                  Put 70                          2.55                1.42 72                          1.55               ...
Show all your calculations. Answers without explanations or calculations will receive a mark of zero. (This...
Show all your calculations. Answers without explanations or calculations will receive a mark of zero. (This question is worth 20 marks in total.) Telstra is a monopolist. Suppose it operates at the market with demand P = 5 – Q and has the following cost structure: MC=AC = 1. Draw the market demand curve and the marginal cost curve on the graph with Q on X-axis. (Include a large and accurate graph). d. Suppose that now Telstra can identify each...
Please show all work, calculation, or explanation to receive full credit and circle the correct answer....
Please show all work, calculation, or explanation to receive full credit and circle the correct answer. Use the following Information to Answer Problems 1 and 2 Bradford Services Inc. (BSI) is considering a project that has a cost of $10 million and an expected life of 3 years. There is a 30 percent probability of good conditions, in which case the project will provide a cash flow of $9 million at the end of each year for 3 years. There...
For this question, you must show all work to receive any credit. DONOT USE MATLAB FOR...
For this question, you must show all work to receive any credit. DONOT USE MATLAB FOR THIS QUESTION. for k = 3*1:6:21 j = k/3; if rem(j,6) >= 3 disp(k) elseif rem(j,3) < 2 disp(j) else disp(3) end end write out the solution
Show all of your work in the space provided. Show all of your work to get...
Show all of your work in the space provided. Show all of your work to get full credit. All answers have to be in SI units(20 pints for each questions). 2.Following are the two sets of position and time data collected using a motion sensor and cart.        Table 1. table 2 Time (s) Position (m) V(instantaneous) (m/s) 0 10.0 0.25 13.0 0.50 16.5 0.75 21.0 1.00 26.5 1.25 32.3 1.50 38.0 1.75 44.5 2.00 52.0 2.25 60.0 2.50 68.5...
For any mathematical computations, you must show your work to receive full credit. 2. For a...
For any mathematical computations, you must show your work to receive full credit. 2. For a sample of 900 police officers at a local police department, a researcher believes there is a relationship between “number of arrests per month” and “police use of force.” Using the following data, test the null hypothesis at the .01 level of significance that police use of force does not differ by the number of arrests per month that an officer makes. In so doing,...
I will not give credit for any unsupported answer -- even if it is correct!!. All...
I will not give credit for any unsupported answer -- even if it is correct!!. All cash flows are end-of-period unless otherwise stated . Problems 1 and 2 relate to this information : The current monthly income statement for JRT, Inc., represents the results of selling 8,000 coffee mugs: Sales (revenue) $56,000 Cost of goods sold (33,000) Gross margin $23,000 S & A expenses (16,000) Income before taxes $ 7,000 Income taxes (@ 30%) (2,100) Net income $ 4,900 Cost...
The correct answers are already bolded, but please show your work/explain how you get the answer....
The correct answers are already bolded, but please show your work/explain how you get the answer. 1. Rick can cut 6 pieces of wood or catch 6 fish per day. Timmy can cut 9 pieces of wood or catch 18 fish per day. Which one of the following points is not on the Timmy’s production possibility frontier fish is on the horizontal axis and pieces of wood is on the vertical axis? a. (0, 9) b. (18, 0) c. (8,...
fill in the missing information: Must show all your work to receive credit. Case A Case...
fill in the missing information: Must show all your work to receive credit. Case A Case B Case C Units Produced 1,000 1,500 800 Standard hours per unit 3.5 ? 3 Standard hours for production ? ? ? Standard rate per hour $7.25 $7.00 $7.00 Actual hours worked 3,400 4,900 2,330 Actual total labor cost ? $31,850 ? Labor price variance $850 F ? $466 F Labor usage variance ? $2,800 U ? Please show work for how each missing...
Instructions: In this section, please show all calculations. Partial credit will be given wherever possible, when...
Instructions: In this section, please show all calculations. Partial credit will be given wherever possible, when your calculations are shown and they are completed correctly. 33. – 35. Corporate Income Taxes Corporate Tax Schedule If Corporation's Taxable It Pays This Amount on the Plus this Percentage on the Income is: Base of the Bracket: Excess Over the Base: Up to $50,000 0 15% $50,000 -- $75,000 $7,500 25% $75,000 -- $100,000 $13,750 34% $100,000 -- $335,000 $22,250 39% $335,000 --...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT