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
- FILE HOME INSERT Calibri Paste Clipboard BIU Font A1 1 2 34 сл 5 6 Calculating interest rates - Excel PAGE LAYOUT FORMULAS DATA 11 Α΄ Α΄ % × fx A B C 4 17 REVIEW VIEW Alignment Number Conditional Format as Cell Cells Formatting Table Styles▾ Styles D E F G H Solve for the unknown interest rate in each of the following: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 7 8 Present value Years Interest rate 9 10 11 SA SASA A $ 181 4 $ 335 18 $ 48,000 19 $ 40,353 25 12 13 14 15 16 $ SA SA SA A $ Future value 297 1,080 $ 185,382 $ 531,618arrow_forwardB B Canning Machine 2 Monster Beverage is considering purchasing a new canning machine. This machine costs $3,500,000 up front. Required return = 12.0% Year Cash Flow 0 $-3,500,000 1 $1,000,000 2 $1,200,000 3 $1,300,000 4 $900,000 What is the value of Year 3 cash flow discounted to the present? 5 $1,000,000 Enter a response then click Submit below $ 0 Submitarrow_forwardFinances Income Statement Balance Sheet Finances Income Statement Balance Sheet Materia Income Statement Balance Sheet FY23 FY24 FY23 FY24 FY23 FY24 Sales Cost of Goods Sold 11,306,000,000 5,088,000,000 13,206,000,000 Current Current Assets 5,943,000,000 Other Expenses 4,523,000,000 5,283,000,000 Cash 211,000,000 328,600,000 Liabilities Accounts Payable 621,000,000 532,000,000 Depreciation 905,000,000 1,058,000,000 Accounts 502,000,000 619,600,000 Notes Payable 376,000,000 440,000,000 Earnings Before Int. & Tax 790,000,000 922,000,000 Receivable Interest Expense 453,000,000 530,000,000 Total Current Inventory 41,000,000 99,800,000 997,000,000 972,000,000 Taxable Income 337,000,000 392,000,000 Liabilities Taxes (25%) 84,250,000 98,000,000 Total Current 754,000,000 1,048,000,000 Long-Term Debt 16,529,000,000 17,383,500,000 Net Income Dividends 252,750,000 294,000,000 Assets 0 0 Fixed Assets Add. to Retained Earnings 252,750,000 294,000,000 Net Plant & 20,038,000,000 21,722,000,000…arrow_forward
- Do you know what are Keith Gill's previous projects?arrow_forwardExplain why long-term bonds are subject to greater interest rate risk than short-term bonds with references or practical examples.arrow_forwardWhat does it mean when a bond is referred to as a convertible bond? Would a convertible bond be more or less attractive to a bond holder than a non-convertible bond? Explain in detail with examples or academic references.arrow_forward
- Alfa international paid $2.00 annual dividend on common stock and promises that the dividend will grow by 4% per year, if the stock’s market price for today is $20, what is required rate of return?arrow_forwardgive answer general accounting.arrow_forwardGive me answers in general financearrow_forward
- General Finance Question Solution Please with calculationarrow_forwardGeneral Financearrow_forwardAs CFO for Everything.Com, you are shopping for 6,000 square feet of usable office space for 25 of your employees in Center City, USA. A leasing broker shows you space in Apex Atrium, a 10-story multitenanted office building. This building contains 360,000 square feet of gross building area. A total of 54,000 square feet is interior space and is nonrentable. The nonrentable space consists of areas contained in the basement, elevator core, and other mechanical and structural components. An additional 36,000 square feet of common area is the lobby area usable by all tenants. The 6,000 square feet of usable area that you are looking for is on the seventh floor, which contains 33,600 square feet of rentable area, and is leased by other tenants who occupy a combined total of 24,000 square feet of usable space. The leasing broker indicated that base rents will be $30 per square foot of rentable area Required: a. Calculate total rentable area in the building as though it would be rented to…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College