Question

In: Accounting

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 toxic dump site for waste chemicals, but it built a piping system to safely discard the chemicals instead. If the company sold the land today, it would receive $5.1 million after taxes. In five years, the land can be sold for $6.0 million after taxes, but DEI intends to keep the land for a future project. The company wants to build its new manufacturing plant on this land; the plant and equipment will cost $35 million to build. The following market data on DEI's securities are current:

Debt:     240,000 7.5 percent coupon bonds outstanding, 20 years to maturity, selling for 94 percent of par; the bonds have a $1,000 par value each and make semiannual payments.

Common stock: 9,000,000 shares outstanding, selling for $71 per share; the estimated beta is 1.2.

Preferred stock: 400,000 shares of 5.5 percent preferred stock outstanding, par value of $100 per share, selling for $81 per share.

Market: 8 percent expected market risk premium; 5 percent risk-free rate.

DEI uses G. M. Wharton as its lead underwriter. Wharton charges DEI spreads of 8 percent on new common equity (stock) issues, 6 percent on new preferred stock issues and 4 percent on new debt (bond) issues. Wharton has included all direct and indirect costs (along with its profit) in setting these spreads. In estimating DEI’s WACC, you should assume that DEI retains their existing capital structure weights for debt, common stock and preferred stock in order to finance the project. DEI's tax rate is 35 percent. The project requires $1,300,000 in initial net working capital (NWC) investment to get operational. Assume Wharton raises all financing for the new project, to include the amount needed for NWC, externally.

Questions:

1 - The manufacturing plant and equipment 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 and equipment can be sold for $6 million. Do not confuse the market value of the plant and equipment with the market value of the land. What is the after-tax salvage value of the equipment?

2 - The company will incur $7,000,000 in annual fixed costs. The plan is to manufacture 18,000 RDSs per year and sell them at $10,900 per machine; the variable production costs are $9,400 per RDS. What is the annual operating cash flow, OCF, from this project?

3 - DEI's comptroller is primarily interested in the impact of DEI's investments on the bottom line of reported accounting statements. What will you tell her are both the Accounting and Financial Break-Even quantity of RDSs sold for this project? For an understanding of Accounting and Financial Break-Even (Break-Even Point), “the break-even approach determines the sales needed to break even on the project investment – the point where the project generates no profits or loss.”

4 - What will be your estimate of NPV and IRR if the average RDS sales price per unit must be reduced by 5 percent (from $10,900 per unit to $10,355 per unit) in order to sell the 18,000 proposed units that are being manufactured? Will you still recommend the project?

Solutions

Expert Solution

The $4 million cost of the land 3 years ago is a sunk cost and irrelevant; the $6

million appraised value of the land is an opportunity cost and is relevant. The

relevant market value capitalization weights are:

       MVD = 240,000($1,000)(0.94) = $225,600,000

       MVE = 9,000,000($71) = $639,000,000

       MVP = 400,000($81) = $3,240,000

The total market value of the company is:

      

       V = $225,600,000 + 639,000,000 + 3,240,000 = $897,000,000

Next we need to find the cost of funds. We have the information available to calculate the cost of equity using the CAPM, so:

       RE = .05 + 1.2(.08) = .1460 or 14.60%

The cost of debt is the YTM of the companys outstanding bonds, so:

       P0 = $940 = $37.5(PVIFAR%,40) + $1,000(PVIFR%,40)

       R = 4.06%

       YTM = 4.06% × 2 = 8.11%

And the aftertax cost of debt is:      

       RD = (1 .35)(.0811) = .0527 or 5.27%

       The cost of preferred stock is:

       RP = $5.5/$81 = .0679 or 6.79%

The initial cost to the company will be the opportunity cost of the land, the cost of the plant, and the net working capital cash flow, so:

               CF0 = –$6,000,000 – 35,000,000 – 1,300,000 = –$42,300,000

To find the required return on this project, we first need to calculate the WACC for the company. The company’s WACC is:

               WACC = [($639/$897)(.1460) + ($3.24/$897)(.0679) + ($225.6/$897)(.0527)] = .1197

       The annual depreciation for the equipment will be:

               $35,000,000/8 = $4,375,000

               So, the book value of the equipment at the end of five years will be:

               BV5 = $35,000,000 – 5($4,375,000) = $13,125,000

       a.     So, the aftertax salvage value will be:

              

               Aftertax salvage value = $6,000,000 + .35($13,125,000 – 6,000,000) = $8,493,750

b. Using the tax shield approach, the OCF for this project is:

              

               OCF = [(P – v)Q – FC](1 – t) + tCD

               OCF = [($10,900 – 9,400)(18,000) – 7,000,000](1 – .35) + .35($35M/8) = $17,375,000

c. The accounting breakeven sales figure for this project is:

                 QA = (FC + D)/(P – v) = ($7,000,000 + 4,375,000)/($10,900 – 9,400) = 7,583 units

d. We have calculated all cash flows of the project. We just need to make sure that in Year 5 we add back the aftertax salvage value, the recovery of the initial NWC, and the aftertax value of the land. The cash flows for the project are:

                         Year          Flow Cash               

                           0        –$42,300,000

                           1            17,375,000

                           2           17,375,000

                           3           17,375,000

                           4           17,375,000

                           5             33,168,750

               Using the required return of 11.97 percent, the NPV of the project is:

              

               NPV = –$42,300,000 + $17,375,000(PVIFA11.97%,4) + $33,168,750/1.11975

               NPV = $29,353,372.96

               And the IRR is:

               NPV = 0 = –$42,300,000 + $17,375,000(PVIFAIRR%,4) + $33,168,750/(1 + IRR)5

               IRR = 34.75%


Related Solutions

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...
Please show all calculations and formulas. If using Escel, please show data/formulas. practice 10: Show the...
Please show all calculations and formulas. If using Escel, please show data/formulas. practice 10: Show the effects of these transactions on the balance sheet equity accounts. Presently the stock price is $20 per share. You started with: common stock ($1 par value) $10,000, capital surplus $100,000, retained earnings $200,000: a. 12% stock dividend b. repurchased 1,000 shares (repurchase price is PV of 20)
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%...
Please explain your answer clearly. Please show all the formulas and calculations (please do not use...
Please explain your answer clearly. Please show all the formulas and calculations (please do not use excel): Anchor Ltd paid $15,000 last quarter for a feasibility study regarding the demand for motorboat replacement parts which would require the purchase of a new metal-shaping machine. Today, they wish to conduct an analysis of the proposed project. The machine costs $250,000 and will operate for five years and tax rules allow the machine to be depreciated to zero over a five-year life....
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/formulas and financial calculator steps, if used. Answer as much as you can (The...
Please show work/formulas and financial calculator steps, if used. Answer as much as you can (The following information applies to Problems 1-4) The Collins Group, a leading producer of custom automobile accessories, has hired you to estimate the firm's weighted average cost of capital. The balance sheet and some other information are provided below. Assets Current assets                                        $ 38,000,000 Net plant, property, and equipment                    101,000,000 Total assets                                          $139,000,000 Liabilities and Equity Accounts payable                                      $ 10,000,000 Accruals                                                9,000,000 Current liabilities                                   $...
Please explain in detail and show work where applicable. Please show any formulas or calculations and...
Please explain in detail and show work where applicable. Please show any formulas or calculations and explain them. - perhaps you would Soft Peg the small coutry to a basket of Germany and France's currencies? - please explain? Practice # 10 You have been hired as a consultant to the central bank for a small country that, for many years, has suffered from repeated currency crises and rampant inflation. The country depends heavily on both the German and French financial...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
Show your calculations in detail please.. Suppose that a researcher is conducting a study on fast...
Show your calculations in detail please.. Suppose that a researcher is conducting a study on fast food habits and assumes that 55% of adults prefer hamburger to pizza. He randomly selects 10 adults and ask whether they prefer hamburger to pizza or not. Based on this information, answer the following questions. a) (20 pts) Define the random variable (in words) and check whether it is a binomial random variable or not and write your conclusion. Explain your answer. b) (10...
Suppose you have been hired as a financial consultant to Defense Electronics, Inc. (DEI), a large,...
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 $3.9 million in anticipation of using it as a toxic dump site for waste chemicals, but it...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT