Project Evaluation [LO3, 4] This is a comprehensive project evaluation problem bringing together much of what you have learned in this and previous chapters. 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 built a piping system to safely discard the chemicals instead. The land was appraised last week for $4.4 million on an aftertax basis. In five years, the aftertax value of the land will be $4.8 million, but the company expects 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 $37 million to build. The following market data on DEI’s securities are current:
Debt: | 210,000 6.4 percent coupon bonds outstanding, 25 years to maturity, selling for 108 percent of par; the bonds have a $1,000 par value each and make semiannual payments. |
Common stock: | 8,300,000 shares outstanding, selling for $68 per share; the beta is 1.1. |
450,000 shares of 4.5 percent preferred stock outstanding, selling for $81 per share. | |
Market: | 7 percent expected market risk premium; 3.5 percent risk-free rate. |
DEI uses G.M. Wharton as its lead underwriter. Wharton charges DEI spreads of 8 percent on new common stock issues, 6 percent on new preferred stock issues, and 4 percent on new debt issues. Wharton has included all direct and indirect issuance costs (along with its profit) in setting these spreads. Wharton has recommended to DEI that it raise the funds needed to build the plant by issuing new shares of common stock. DEI’s tax rate is 35 percent. The project requires $1,300,000 in initial net working capital investment to get operational. Assume Wharton raises all equity for new projects externally.
a. Calculate the project’s initial Time 0 cash flow, taking into account all side effects.
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.
c. The manufacturing plant has an eight-year tax life, and DEI uses straight-line
d. The company will incur $6,700,000 in annual fixed costs. The plan is to manufacture 15,300 RDSs per year and sell them at $11,450 per machine; the variable production costs are $9,500 per RDS. What is the annual operating cash flow (OCF) from this project?
e. 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 is the accounting break-even quantity of RDSs sold for this project?
f. Finally, DEI’s president wants you to throw all your calculations, assumptions, and everything else into the report for the chief financial officer; all he wants to know is what the RDS project’s
a)
To determine: The initial cash flow of the project at Time 0.
Introduction:
Project evaluation refers to the process of evaluating the project for its feasibility and economic viability.
Answer to Problem 30QP
The initial cash flow at Time 0 is $45,408,091.87.
Explanation of Solution
Given information:
Company D manufactures radar detection systems. It is planning to open a new manufacturing plant overseas. The project will take five years. It had purchased a land overseas at $3,900,000 for dumping chemical waste. However, the company found an alternative to dispose of waste and the land remained unused.
The current after-tax valuation of the land is $4,400,000. It would be worth $4,800,000 in five years. The company wants to implement the project on this unused land. The cost of plant and equipment would be $37,000,000. The current market data for Company D is as follows:
- Debt: Company D has bonds with a face value of $1,000 and a coupon rate of 6.4 percent. There are 210,000 outstanding bonds. The bonds will mature in 25 years, and they make semiannual coupon payments. The bond currently sells at 108 percent of the face value.
- Common equity: The common equity of Company D has 8,300,000 shares outstanding. The current selling price of the share is $68. The stock has a beta of 1.1. The risk-free rate is 3.5 percent, and the market risk premium is 7 percent.
- Preferred stock: Company D has 450,000 outstanding preferred shares. The dividend is 4.5 percent, and the current market value is $81 per share. Assume that the face value of the share is $100.
The flotation costs of raising common stock, preferred stock, and debt is 8 percent, 6 percent, and 4 percent respectively. The underwriter recommends Company D to raise all the funds through common stock. The tax rate applicable to Company D is 35 percent. The project needs an initial net working capital of $1,300,000 to begin the operations. The company raises all the common stock externally.
The calculations necessary for parts (a) and (b) of the solution:
- The market value of debt
- The market value of equity
- The market value of preferred stock
- The cost of equity
- The cost of preferred stock
- The after-tax cost of debt
The formula to calculate the market value of debt:
The formula to calculate the market value of equity:
The formula to calculate the market value of preferred stock:
The formula to calculate the total market value of the capital structure:
The formula to calculate the cost of equity using the Security market line (SML) approach:
Where,
“RE” refers to the expected return on equity or the cost of equity
“Rf” refers to the risk-free rate
“RM” refers to the expected return on the market portfolio
“βE” refers to the beta or risk of the equity
The formula to calculate the cost of preferred stock:
Where,
“RP” refers to the return on preferred stock or cost of preferred stock
“D” refers to the dividend earned on the preferred stock
“P0” refers to the current price of preference stock
The formula to calculate annual coupon payment:
The formula to calculate the current price or the market value of the debt:
The formula to calculate the yield to maturity:
Where,
“C” refers to the coupon paid per period
“F” refers to the face value paid at maturity
“r” refers to the yield to maturity
“t” refers to the periods to maturity
The formula to calculate the after-tax cost of debt:
Where,
“RD” refers to the cost of debt
“TC” refers to the corporate tax rate
Compute the market value of debt:
Hence, the market value of debt is $226,800,000.
Compute the market value of equity:
Hence, the market value of common equity is $564,400,000.
Compute the market value of preferred stock:
Hence, the market value of preferred stock is $36,450,000.
Compute the total market value of the capital structure:
Hence, the total market value of the capital structure is $827,650,000.
Compute the cost of equity:
Hence, the cost of equity is 11.20 percent.
Compute the cost of preferred stock:
The face value of the preferred stock is $100. The dividend percent is 4.5. Hence, the dividend is $4.5
Hence, the cost of preferred stock is 5.56 percent.
Compute the annual coupon payment:
Hence, the annual coupon payment is $64.
Compute the current price of the bond:
The face value of the bond is $1,000. The bond value is 108% of the face value of the bond.
Hence, the current price of the bond is $1,080.
Compute the semiannual yield to maturity of the bond as follows:
The bond pays the coupons semiannually. The annual coupon payment is $64. However, the bondholder will receive the same is two equal installments. Hence, semiannual coupon payment or the 6-month coupon payment is $32
The remaining time to maturity is 25 years. As the coupon payment is semiannual, the semiannual periods to maturity are 50
Finding “r” in Equation (1) would give the semiannual yield to maturity. However, it is difficult to simplify the above the equation. Hence, the only method to solve for “r” is the trial and error method.
The first step in trial and error method is to identify the discount rate that needs to be used. The bond sells at a premium in the market if the market rates (Yield to maturity) are lower than the coupon rate. Similarly, the bond sells at a discount if the market rate (Yield to maturity) is greater than the coupon rate.
In the given information, the bond sells at a premium because the market value of the bond is higher than its face value. Hence, substitute “r” with a rate that is lower than the coupon rate until one obtains the bond value close to $1,080.
The coupon rate of 6.4 percent is an annual rate. The semiannual coupon rate is 3.2 percent
The attempt under the trial and error method using 2.895 percent as “r”:
The current price of the bond is $1,080.60 when “r” is 2.895 percent. Hence, 2.895 percent is the semiannual yield to maturity.
Compute the annual yield to maturity:
Hence, the yield to maturity is 5.79 percent.
Compute the after-tax cost of debt:
The pre-tax cost of debt is equal to the yield to maturity of the bond. The yield to maturity of the bond is 5.79 percent. The corporate tax rate is 35 percent.
Hence, the after-tax cost of debt is 3.76 percent.
The formula to calculate the weighted average flotation cost:
Where,
“fA” refers to the weighted average flotation cost
“fE” refers to the flotation cost of equity
“fP” refers to the flotation cost of preferred stock
“fD” refers to the flotation cost of debt
“E” refers to the amount of common equity capital
“D” refers to the amount of debt
“P” refers to the amount of preferred stock
“V” refers to the total amount of capital
The formula to calculate the total amount of capital that the firm should raise after taking into account the flotation costs:
Here, “fA” refers to the weighted average flotation cost
Compute the weighted average flotation cost:
The market value of equity (E) is $564,400,000, the market value of preferred stock (P) is $36,450,000, and the market value of debt (D) is $226,800,000. The total market value (V) is $827,650,000. The flotation cost of equity “fE” is 8 percent, the flotation cost of preferred stock “fE” is 6 percent, and the flotation cost of debt “fD” is 3.5 percent.
Hence, the weighted average flotation cost is 6.82percent.
Compute the total capital to be raised:
The project cost includes the cost plant and equipment. Hence, the amount to be raised before the flotation costs is $37,000,000. The company has already purchased the land. Assume that the company will fund the initial net working capital from internal sources. The weighted average flotation cost is 6.82 percent.
Hence, the total capital to be raised is $39,708,091.87.
Compute the initial cash outflow:
The initial cash flow includes the cost of the land, plant and equipment, and the initial net working capital. The land currently values at $4,400,000. The cost of buying plant and equipment including the flotation costs is $39,708,091.87. The initial working capital required is $1,300,000. Hence, the initial cash outflow at Time 0 is $45,408,091.87
b)
To determine: The discount rate
Answer to Problem 30QP
The discount rate is 10.91 percent.
Explanation of Solution
The company can use the weighted average cost of capital as its discount rate if the new project’s risk is similar to the company’s risk. It is given that the project is riskier than the firm is. The company adds 2 percent to its weighted average cost of capital to match the riskiness of the project. Therefore, the discount rate for the project would we equal to the sum of the weighted average cost of capital and the adjustment factor of 2 percent.
The formula to calculate the weighted average cost of capital:
Where,
“WACC” refers to the weighted average cost of capital
“RE” refers to the return on equity or cost of equity
“RD” refers to the return on debt or cost of debt
“RP” refers to the return on debt or cost of preferred stock
“E” refers to the amount of common equity capital
“D” refers to the amount of debt
“P” refers to the amount of preferred stock
“V” refers to the total amount of capital
“TC” refers to the corporate tax rate
Compute the weighted average cost of capital:
The market value of equity (E) is $564,400,000, the market value of preferred stock (P) is $36,450,000, and the market value of debt (D) is $226,800,000. The total market value (V) is $827,650,000. The cost of equity “RE” is 11.20 percent, the cost of preferred stock “RP” is 5.56 percent, and the after-tax cost of debt “RD” is 3.76 percent. As the after-tax cost of debt is available, omit “1‑TC” from the formula.
Hence, the weighted average cost of capital is 8.91 percent.
Compute the discount rate:
The company adds 2 percent to its weighted average cost of capital to match the riskiness of the project. The weighted average cost of capital is 8.91 percent. Hence, the discount rate is 10.91 percent
c)
To determine: The after-tax salvage value after 5 years
Answer to Problem 30QP
The after-tax salvage value after 5 years is $8,171,250.
Explanation of Solution
The formula to calculate the depreciation per year:
The formula to calculate the book value after 5 years:
The formula to calculate the after-tax salvage value:
Compute the depreciation per year:
The cost of the equipment is $37,000,000, and its tax life is 8 years (Given).
Hence, the depreciation per year is $4,625,000.
Compute the book value after 5 years:
Hence, the book value after five years is $13,875,000.
Compute the after-tax salvage value:
It is given that the market value of the equipment after 5 years is $5,100,000. The book value after 5 years is $13,875,000. The tax rate is 35 percent.
Hence, the after-tax salvage value is $8,171,250.
d)
To determine: The operating cash flow of the project
Answer to Problem 30QP
The operating cash flow of the project every year is $16,656,500.
Explanation of Solution
Given information:
The new project has annual fixed costs worth $6,700,000. The new plant will manufacture 15,300 products. The selling price of each product is $11,450, and the cost of production is $9,500.
The formula to calculate the operating cash flow:
Compute the operating cash flow:
The selling price of each product is $11,450, and the cost of production is $9,500. The depreciation per year is $4,625,000. The fixed costs are $6,700,000. The tax rate is 35 percent.
Hence, the operating cash flow is $16,656,500.
e)
To determine: The accounting break-even quantity
Answer to Problem 30QP
The break-even quantity is 5,808 units.
Explanation of Solution
The break-even point is a point where the total cost of the manufacturing is equal to the total revenue. The fixed costs of the project divided by the contribution per product give the break-even units.
The formula to calculate the break-even quantity:
Compute the break-even quantity:
The selling price of each product is $11,450, and the cost of production is $9,500. The depreciation per year is $4,625,000. The fixed costs are $6,700,000.
Hence, the break-even quantity is 5,808 units.
f)
To determine: The net present value and the internal rate of return
Answer to Problem 30QP
The net present value is $24,795,955.34, and the internal rate of return is 28.94 percent.
Explanation of Solution
Net present value is a tool that helps in evaluating a new project. It determines whether the present value of cash flows from the project exceed the initial cost of investment. The internal rate of return in a return where the net present value of the project is zero.
The formula to calculate the net present value and the internal rate of return:
Where,
“CF1 to CFt” refer to the cash flow from period 1 to period t
“r” refers to the discount rate
Compute the net present value:
The initial investment in the project is $45,408,091.87. The operating cash flow of the project is $16,656,500. Hence, it is the cash flow from Year 1 to Year 4. For Year 5, the cash flow should include the operating cash flow plus the after-tax salvage value, after-tax land value, and the recovery of the initially invested working capital.
The after-tax salvage value is $8,171,250, the after-tax land value is $4,800,000, and the initial working capital is $1,300,000. Hence, the cash flow in Year 5 is $30,927,750
Hence, the net present value is $24,795,955.34.
Compute the internal rate of return:
The internal rate of return in a return where the net present value of the project is zero. It is possible to determine the internal rate of return only through the trail and error method or by using a software. The net present value is positive. Hence, the trial and error rate should be higher than the discount rate. Use a trial rate of 28.94 percent to determine whether the net present value is zero.
Hence, the approximate internal rate of return is 28.94 percent
Want to see more full solutions like this?
Chapter 14 Solutions
Fundamentals of Corporate Finance
- K You are a manager at Northern Fibre, which is considering expanding its operations in synthetic fibre manufacturing. Your boss comes into your office, drops a consultant's report on your desk, and complains, "We owe these consultants $1.5 million for this report, and I am not sure their analysis makes sense. Before we spend the $21 million on new equipment needed for this project, look it over and give me your opinion." You open the report and find the following estimates (in millions of dollars): Sales revenue -Cost of goods sold = Gross profit - General, sales, and administrative expenses - Depreciation = Net operating income Income tax = Net income 1 30.000 18.000 2 30.000 18.000 12.000 12.000 1.680 1.680 2.100 2.100 8.2200 2.877 8.2200 2.877 5.343 5.343 ... 9 30.000 18.000 12.000 1.680 2.100 8.2200 2.877 5.343 10 30.000 18.000 12.000 1.680 2.100 8.2200 2.877 5.343 *** b. If the cost of capital for this project is 15%, what is your estimate of the value of the new project? Value…arrow_forwardSuppose 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.9 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. The land was appraised last week for $5.7 million. In five years, the aftertax value of the land will be $6.1 million, but the company expects 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 $32.32 million to build. The following market data on DEI's securities is current: Debt: 234,000 7.4 percent coupon bonds outstanding, 25 years to maturity, selling for 109 percent of par; the…arrow_forwardSuppose 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.9 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 $5.7 million after taxes. In five years, the land will be worth $6.4 million after taxes. The company wants to build its new manufacturing plant on this land; the plant will cost $25.7 million to build. The following market data on DEI's securities are current Debt: 70,000 5.8 percent coupon bonds outstanding, 25 years to maturity, selling for 98 percent of par, the bonds have a $1,000 par value each and make semiannual…arrow_forward
- -The patriot missile, developed by Lockheed Martin, is designed to detect, identify, and shoot down aircraft and other missiles. The Patriot Advanced Capability- 3 was originally promised to cost $3.9 billion, but due to extra time needed to develop computer code and scrapped tests (due to high winds) at White Sands Missile Range, the actual cost was much higher. If the total project development time was 10 years and costs increased at a rate of 0.5% per month, what was the final cost of the project?(Do not use excel)arrow_forwardPlease answer this and kindly show the solution/computation and final answers using microsoft excel. I'll give you a like. Thank you!arrow_forwardSuppose 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.3 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.79 million after taxes. In five years, the land will be worth $8.09 million after taxes. The company wants to build its new manufacturing plant on this land; the plant will cost $13.76 million to build. The following market data on DEI’s securities are current: Debt: 93,800 7.2 percent coupon bonds outstanding, 26 years to maturity, selling for 93.1 percent of par; the bonds have a $1,000 par value each…arrow_forward
- 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.3 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.79 million after taxes. In five years, the land will be worth $8.09 million after taxes. The company wants to build its new manufacturing plant on this land; the plant will cost $13.76 million to build. The following market data on DEI’s securities are current: Debt: 93,800 7.2 percent coupon bonds outstanding, 26 years to maturity, selling for 93.1 percent of par; the bonds have a $1,000 par value each…arrow_forwardHi there, I am working on this problem. Can you please show me each step in solving this question without using excel? I am trying to figure out how to calculate the payback period for each project and also how do I calculate the IRR for each project? Riley Ltd. has the following 5 investment projects to choose from, the company needs to select one project.arrow_forwardUse Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial investment is $60,000. The returns on investment in dollars for the following 5 years are (a) $10,000, (b) $12,000, (c) $15,000, (d) $21,000, and (e) $26,000. Use the IRR function to compute the internal rate of return after 2, 4, and 5 years. Next, assume that the loan for the initial $60,000 is at 8 percent and you are earning 16 percent on the annual returns. Use the MIRR function to calculate the internal rate of return. Required: 1. What is the Internal Rate of Return after 2 years? -46% -20% -1% -10% Required: 2. What is the Internal Rate of Return after 4 years? -46% -20% -1% 10% Required: 3. What is the Internal Rate of Return after 5 years? 10% 16% 8% 20%arrow_forward
- You are the investment manager of an appliance company. The industry is currently in the expansion face and the CEO would like to capture as much of the market share as possible. You asked your analysts to submit project proposals as summarized below. Project Discount Rate Investment Annual Cash Flow Project Life (Years) 10 3M 1M 5 12 4M 1M 8 8 5M 2M 4 8 3M 1.5M 3 12 3M 1M 6 Which projects should the manager choose? If you were given unlimited capital, which projects should be implemented? ABCDEarrow_forwardSuppose you have been hired as a financial consultant to Defense Electronics, Incorporated (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.8 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. The land was appraised last week for $6.9 million on an aftertax basis. In five years, the aftertax value of the land will be $7.3 million, but the company expects 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 $33.5 million to build. The following market data on DEI’s securities are current: Debt: 145,000 bonds with a coupon rate of 6.9 percent outstanding, 22…arrow_forwardSuppose you have been hired as a financial consultant to Defense Electronics, Incorporated (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.8 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. The land was appraised last week for $6.9 million on an aftertax basis. In five years, the aftertax value of the land will be $7.3 million, but the company expects 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 $33.5 million to build. The following market data on DEI’s securities are current: Debt: 145,000 bonds with a coupon rate of 6.9 percent outstanding, 22…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College