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
- A.arrow_forwardnot use ai pleasearrow_forwardBackground Hyde Park Technologies Pty Ltd (HPT), a medium-sized enterprise with a turnover of $100 million per year is considering the purchase of an ERP system. As they have an urgent need to update their accounting system, they plan on purchasing an ERP financial module as the first step and then over time, they plan on integrating this module as part of a larger ERP rollout through the company. Eileen Dover, the CEO of HPT recently issued a request for proposal (RFP) to a number of ERP vendors. To assist the vendors in the preparation of their responses, Eileen has provided the following information: . HPT was founded by Eileen's father (Hans Dover) in 1986. Even though Hans is now in his 70s, he still plays an important figurehead role in the company and will have influence in the choice of vendor. Eileen has emphasised that whilst the presentation materials be to a high professional standard, it is imperative that they clearly and simply articulate the "Hansefits" of the new…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 $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_forwardYour manager has asked you to advise your client Kofi Gyato, owner and director of Kofi Gyato Limited, on the implications of the proposed transaction.Your client has identified an opportunity to develop his business by manufacturing the products which he sells. To do this he would need to buy a machine which will have an expected life of ten years. He has received this quotation for the machine.GHȼPrice of machine70,000Delivery and installation3,500Commissioning costs1,500Annual maintenance costs3,500Required:Prepare a report to your client. Your report should:(a) Explain the difference between capital and revenue expenditure, and how each type of expenditure affects the accounts of a business.(b) Indicate which of the costs of the machine should be considered as capital cost and which should be considered as revenue cost.(c) Define depreciation and explain how the accounting entries for depreciation affect each element of the accounting equation.(d) Indicate:(i) What the annual…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_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_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
- Please use excel and show work/formulas if used.arrow_forwardNeed all 4 ques...arrow_forwardYou are a manager at Permeable Fiber, which is considering adding a new product line. Your boss said to you "We already owe these consultants $1.1 million, and all they estimated is Net Income. Before we spend $32 million on new equipment for this project, look the report over and give me your opinion." Here are the report's estimates (in millions of dollars; note that the question is continued below, so you need to scroll down to see it all): 1 2 Sales revenue 77.0 77.0 - Cost of goods sold 42.0 42.0 Gross profit 35.0 35.0 -Selling, gen. & admin. exp. 4.0 4.0 -Depreciation 16.0 16.0 Net operating income 15.0 15.0 - Income tax 4.1 4.1 Net Income 11.0 11.0 Everything that the consultants have calculated is correct, as far as it goes. The project will require $25 million in working capital upfront (year 0), which will be fully recovered in the last year of the project (year 2). The first relevant period's FCF is: The second relevant period's FCF is: The third relevant period's FCF (if…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College