Finance Fundamentals Winter 2020 Assignment 2 Group or Individual Case Assignment Project Evaluation You and your team are financial consultants who have been hired by a large, publicly traded electronics firm, Brilliant Electronics (BE), a leader in its industry. The company is looking into manufacturing its new product, a machine using sophisticated state of the art technology developed by BE's R&D team, overseas. This overseas project will last five years. They've asked you to evaluate this project and to make a recommendation about whether or not the company should pursue it. BE's management team needs your recommendation and the analysis used to arrive at it by no later than April 10, 2020 The following market data on BE's securities are current: Debt: 210,000 6.4 percent coupon bonds outstanding, 25 years to maturity, selling or 108 percent of par; the bonds have $1000 par value each and make semi-annual payments Common Stock: 8,300,000 shares outstanding, selling for $68 per share; bet 1.1 Preferred Stock: 450,000 shares of 4.5% preferred stock outstanding, selling or $81 per share Market: 7 percent expected market risk premium; 3.5 percent risk-free rate 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 after-tax basis. In five years, the after tax 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 will cost $37 million to build At the end of the project (the end of year 5), the plant can be scrapped for $5.1 million. The manufacturing plant will be depreciated using the straight line method. The company will incur $6,700,000 in annual fixed costs excluding depreciation. The plan is to manufacture 15,300 machines per year and sell them at $11.450 per machine, the variable production costs are $9,500 per machine. Selling price and costs are expected to remain unchanged over the life of the project BE uses PK Global (PKG) as its lead underwriter. PKG charges BE spreads of 8% n new common stock issues, 6% on new preferred stock issues, and 4% on new debt issues. PKG has included all direct and indirect issuance costs (along with its profit) in setting these spreads. BE's tax rate is 35 percent. The project requires $1,300,000 in initial networking capital investment to get operational Assume BE raises all equity for new projects externally (that is, BE does not use retained earnings) The weighted average flotation cost is the sum of the weight of each source of funds in the capital structure of the company times the flotation costs, so f ($564.4/5827.65)(0.08) ($36.45/5827.650.06) (5226.8/5827.65)(0.04) - 0.0682, or 6.82% Thus the initial investment is increased by the amount of flotation costs: (Amount raised)(1 -0.0682) = $37,000,000 Amount raised $37,000,000/(1-0.0682) = $39,708,092 Finance Fundamentals Winter 2020 Assignment 2 Group or Individual Case Assignment Project Evaluation ASSIGNMENT DELIVERABLES & OTHER INFORMATION: a. A one-page executive summary for the CEO and CFO that provides the client with your recommendation regarding the project and the analysis that supports it. b. The main body of the report which contains Excel spreadsheets and/or other supporting documentation that the CFO can review in order to gain a thorough understanding of your analysis and to assess its quality and accuracy. This documentation should explain how the consulting team calculated its answers to 1-4 below. It should be labeled in a manner that makes it easy to follow. c. Groups or Individual Submissions: i. If you find it difficult to work with a group due to current circumstances, then you may submit this assignment as an individual. ii. Groups of five or fewer students may work together on the case assignment. You may opt to work with the group members with whom you worked on the first group assignment. For those who form groups and submit the case as a group, an optional peer review process may be used: If a team encounters a member that does not make a material contribution toward completion of this assignment, then that team member may receive a grade of zero. Documentation to support the lack of participation is required (that is, documentation such as emails that support that a reasonable and timely effort was made to include the team member in the process and to accommodate the team member under exceptional circumstances, or emails containing the member's contribution that was determined to be insufficient). d. Please submit a soft copy of your assignment by no later than April 20, 2020 in the appropriate Slate drop box. e. Ensure the names of the team members that contributed to the assignment appear on each document submitted. f. This assignment counts for 20% of your grade. The documents submitted will communicate the level of professionalism, effort and knowledge of those who created them. I. 5%-quality of the executive summary (writing style; appearance: punctuation: completeness; relevancy of content; etc.); ii. 5%-quality of supporting documentation (organization, appearance; the ease with which the reader can follow it; completeness); iii. 10%-quality of analysis (including accuracy of the numbers) Your analysis should include, and your recommendation should be based on the following: 1) Calculate the firm's current cost of capital using the information provided. 2) Calculate the project's cost of capital (the appropriate discount rate to use to evaluate BE's new project) assuming the capital structure will remain the same if the project is undertaken. Finance Fundamentals Winter 2020 Assignment 2 Group or Individual Case Assignment Project Evaluation This project is somewhat riskier than a typical project for BE; therefore, management has asked you to use an adjustment factor of 12% to account for this increased riskiness (that is, to add 12% to the firm's cost of capital) to estimate the project's required rate of return. (NOTE: Flotation costs do not have to be considered when calculating the required rate of return for each class of security - they are addressed in this problem by adjusting the cost of the initial investment to $39,708,092 from $37,000,000). 3) Calculate the project's annual cash flows, taking into account all the relevant cash flows. a. Calculate the project's initial Time 0 cash flow, taking into account all relevant cash flows. b. Calculate the project's annual operational cash flows (OCF) over the life of the project. C Calculate the project's terminal (last year of the project) cash flow. Include all relevant cash flows. (Note: You can present the cash flows from Year Oto Year 5 in a table format) 4) What is the NPV and IRR of the project? You will use these calculations to support your recommendation