Question

In: Finance

Can you show the formulas for each step also, please? Suppose you have been hired as...

Can you show the formulas for each step also, please?

Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDSs). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. The company bought some land three years ago for $7.1 million in anticipation of using it as a toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead. If the land were sold today, the net proceeds would be $7.62 million after taxes. In five years, the land will be worth $7.92 million after taxes. The company wants to build its new manufacturing plant on this land; the plant will cost $13.08 million to build. The following market data on DEI’s securities are current:

Debt: 90,400 7 percent coupon bonds outstanding, 24 years to maturity, selling for 94.8 percent of par; the bonds have a $1,000 par value each and make semiannual payments.

Common stock: 1,520,000 shares outstanding, selling for $94.20 per share; the beta is 1.22.

Preferred stock: 71,000 shares of 6.3 percent preferred stock outstanding, selling for $92.20 per share.

Market: 7.1 percent expected market risk premium; 4.9 percent risk-free rate.

DEI’s tax rate is 22 percent. The project requires $835,000 in initial net working capital investment to get operational.

a. Calculate the project’s Time 0 cash flow, taking into account all side effects. Assume that any NWC raised does not require floatation costs. (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, e.g., 1,234,567.)

b. The new RDS project is somewhat riskier than a typical project for DEI, primarily because the plant is being located overseas. Management has told you to use an adjustment factor of +2 percent to account for this increased riskiness. Calculate the appropriate discount rate to use when evaluating DEI’s project. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

c. The manufacturing plant has an eight-year tax life, and DEI uses straight-line depreciation. At the end of the project (i.e., the end of Year 5), the plant can be scrapped for $1.52 million. What is the aftertax salvage value of this manufacturing plant? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, e.g., 1,234,567.)

d. The company will incur $2,320,000 in annual fixed costs. The plan is to manufacture 13,200 RDSs per year and sell them at $10,600 per machine; the variable production costs are $9,800 per RDS. What is the annual operating cash flow, OCF, from this project? (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, e.g., 1,234,567.)

e. Calculate the project's net present value. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89)

f. Calculate the project's internal rate of return. (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

a. Time cash 0 cash flow?

b. Discount rate?

c. Aftertax salvage value?

d. Operating cash flow

e. NPV

f. IRR

Solutions

Expert Solution


Related Solutions

Case: Please show your calculations and formulas used. Suppose you have been hired as a financial...
Case: Please show your calculations and formulas used. Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large, publicly traded firm that is the market share leader in radar detection systems (RDSs). The company is looking at setting up a manufacturing plant overseas to produce a new line of RDSs. This will be a five-year project. The company bought some land three years ago for $4 million in anticipation of using it as a...
please show formulas You have been given the following information on a call option on the...
please show formulas You have been given the following information on a call option on the stock of Puckett Industries: P = $65 X = $70 t = 0.5 rRF= 5% s = 0.50 a. Using the Black-Scholes Option Pricing Model, what is the value of the call option? First, we will use formulas from the text to solve for d1and d2. Hint: use the NORMSDIST function. (d1) = N(d1) = (d2) = N(d2) = Using the formula for option...
Please show work step by step, No Excel. Thank you! Suppose miller motors can either expense...
Please show work step by step, No Excel. Thank you! Suppose miller motors can either expense or capitalize an asset it has just purchased for $9,000. if it capitalizes the asset, it will depreciate the asset to a book value of zero on a straight line basis of three years. The firm has a marginal tax rate of 38%, and the cost of capital for this asset is 12%. What is the present-value difference to the firm between expensing and...
question 2 - please show your work in excel or paper. You have been hired by...
question 2 - please show your work in excel or paper. You have been hired by the CFO of Lugones Industries to help estimate its cost of common equity. You have obtained the following data: (1) rd = yield on the firm’s bonds = 7.00% and the risk premium over its own debt cost = 4.00%. (2) rRF = 5.00%, Market Risk Premium = 6.00%, and β = 1.25. (3) D1 = $1.20, P0 = $35.00, and g = 8.00%...
(Explain each step in depth and show your logic. Show formulas and the reasons for doing...
(Explain each step in depth and show your logic. Show formulas and the reasons for doing what your doing) You are an analyst evaluating Up-and-Coming Airlines Inc., a very hot potential acquisition candidate your company is considering. Up-and-Coming currently has no debt and you estimate that it should be able to generate $1 million a year from its existing assets (after tax cash flow). Furthermore, it has the opportunity to invest one-half of its earnings indefinitely. You estimate that because...
please do it step by step with the use of formulas , thank you.. The following...
please do it step by step with the use of formulas , thank you.. The following are monthly percentage price changes for four market indexes. Month DJ SP500 1 0.03 0.02 2 0.07 0.06 3 −0.02 −0.01 4 0.01 0.03 5 0.05 0.04 6 −0.06 −0.04 Russ500 Nicky 0.04 0.04 0.10 −0.02 −0.04 0.07 0.03 0.02 0.11 0.02 −0.08 0.06 (17 points) Compute the following. a. Average monthly rate of return for each index b. Standard deviation for each index...
Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma...
Please solve in Excel format and show step-by-step formulas Not wanting to leave his beloved alma mater, Will Anderson has come up with a scheme to stay around for 5 more years: He has decided to bid on the fast-food concession rights at the football stadium. He feels sure that a bid of $60,000 will win the concession, which gives him the right to sell food at football games for the next 5 years. He estimates that annual operating costs...
How can I solve this problem? Can you please show step by step how to solve...
How can I solve this problem? Can you please show step by step how to solve this? Qd = 2,000 − 10P MC = 0.1Q
Please show me how to do the following in excel. An additional "show formulas" would also...
Please show me how to do the following in excel. An additional "show formulas" would also be helpful. NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates that new project will require $7,500 in inventory, and result in a $7,500 increase in accounts receivable and a $5,000 increase in accounts payable. The latter...
Can you show how to do this step by step using Matlab please. Write a function...
Can you show how to do this step by step using Matlab please. Write a function with header [S] = myAddString(S1, S2), where S is the concatenation of the stings S1 and S2. Test Cases: S = myAddString(myAddString('Programming', ' '), myAddString(' is ', 'fun! ')) S = Programming is fun!
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT