Question

Please answer question 1. Thank you.

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; beta=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% on 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 net working 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:

fT = ($564.4/$827.65)(0.08) + ($36.45/$827.65)(0.06) + ($226.8/$827.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

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. Your analysis should include, and your recommendation should be based on, the following:

1) What is the NPV and IRR of the project? You will use these calculations to support your recommendation.

Answer 1

1) What is the NPV and IRR of the project? You will use these calculations to support your recommendation

Sol:

To calculate NPV and IRR for project, first we need to calculate the post tax cashflows for the project.
Note:
(1) Floatation costs include to be include in the initial investment of the project.
(2) Growth rate for terminal value is considered as zero, since there is no expected increase in selling price or volume of sales. Terminal Value = Post tax cash inflow in year 5 / (WACC - growth rate)
(3) Depreciation calculation:
Cost of plant = US$ 37 Mn
Salvage Value = US$ 5.1 Mn
Life of project = 5 years
Straight line depreciation = (37.0 - 5.1)/5
Annual depreciation = US$ 6.4 Mn
(4) WACC calculations:
Cost of Equity:
Using CAPM method to calculate cost of equity
Re = Rf + β (Rm - Rf)
where: Rf = risk free rate of return = 3.5%
β = Beta of stock = 1.1
(Rm - Rf) = Market risk premium = 7%
putting values in the formula:
Re = 3.5% + 1.1 (7%)
Re = 3.5% + 7.7%
Re = 11.2%
Cost of Debt (post tax):
Rd = Cost of debt = 6.4%
t = 35%
Rd (post tax) = Rd * (1 - t)
Rd (post tax) = 6.4% * (1 - 35%)
Rd (post tax) = 6.4% * (65%)
Rd (post tax) = 4.16%
Cost of Preferred Equity:
Rp = Cost of preferred Equity = 4.5%
Flotation cost:
fT = 6.82%
WACC (including flotation cost) = Re * E/V + Rd (post tax) * D/V + Rp * P/V + flotation cost
where: E = Equity value in new Capital structure
D = Debt Value in new capital structure
P = Preferred Equity Value in new capital structure
V = E + D + P
putting values in the WACC formula:
WACC = 11.2% * (564.4/827.65) + 4.16% * (36.45/827.65) + 4.5% * (226.8/827.65) + 6.82%
WACC = 15.87%
(5) Tax rate is 35%.
US$ Million
Year	0	1	2	3	4	5
Selling Price per Unit (a)		11,450	11,450	11,450	11,450	11,450
Volume of Machine (b)		15,300	15,300	15,300	15,300	15,300
Revenue (c ) = (a) * (b)		175.2	175.2	175.2	175.2	175.2
Variable cost per unit (d)		9,500	9,500	9,500	9,500	9,500
Total Variable Cost (e ) = (b) * (d)		-145.4	-145.4	-145.4	-145.4	-145.4
Fixed Cost (f)		-6.7	-6.7	-6.7	-6.7	-6.7
Depreciation (g)		-6.4	-6.4	-6.4	-6.4	-6.4
Cash Inflows before Corporate tax (h) = (c ) + (e ) + (f) + (g)		16.8	16.8	16.8	16.8	16.8
Corporate Tax @ 35% (i) = (h)* 35%		-5.9	-5.9	-5.9	-5.9	-5.9
Depreciation (j) = -(g)		6.4	6.4	6.4	6.4	6.4
After tax Cash inflows (k) = (h) + (i) + (j)		17.3	17.3	17.3	17.3	17.3
US$ Million
Year	0	1	2	3	4	5
Cash Inflows		17.3	17.3	17.3	17.3	17.3
Terminal cash flows						108.87
Initial Investment	-39.7
Total Cashflows	-39.7	17.3	17.3	17.3	17.3	126.1
Discount factor @15.87%	1/(1+0.1587)^0	1/(1+0.1587)^1	jeff jeffy Next > < Previous Related Solutions For this activity, you have been hired as a team of consultants on a multi-year basis... For this activity, you have been hired as a team of consultants on a multi-year basis for a global washer and dryer manufacturer. They currently offer two core washer and dryer sets: a high-end model and an economic model. You are tasked to complete several calculations and present your findings to the company stakeholders. You may use any presentation software (Google Slides, Prezi, PowerPoint, etc.) and your completed presentation should consist of 8 – 12 slides. A copy of the... For this activity, you have been hired as a team of consultants on a multi-year basis... For this activity, you have been hired as a team of consultants on a multi-year basis for a global washer and dryer manufacturer. They currently offer two core washer and dryer sets: a high-end model and an economic model. You are tasked to complete several calculations and present your findings to the company stakeholders. You may use any presentation software (Google Slides, Prezi, PowerPoint, etc.) and your completed presentation should consist of 12 – 15 slides. A copy of the... You are consultants who have been called in to address a significant security breach in a... You are consultants who have been called in to address a significant security breach in a medium sized manufacturing company. Detailed in the following link the organization was forced to halt the production of boots because a dismissed IT employee took steps to sabotage. https://www.bleepingcomputer.com/news/security/sysadmin-gets-18-months-in-prison-for-shutting-down-former-employers-network/ Your goal is to recommend a security policy and associated implementation of this policy (procedures supported by standards and guidelines) that limits or eliminates the security risks associated with departing employees. task is to “slam... Please answer the matching question below to the best of your knowledge. Thank you in advance... Please answer the matching question below to the best of your knowledge. Thank you in advance for your participation. Matching questions    Treasury stock Stock split Record date Outstanding stock Retained earnings Publicly held corporation Preferred stock Legal capital Cumulative dividend Par value stock   1-  Net income that is retained in the business. 2- The amount per share of stock that must be retained in the business for the protection of corporate creditors.     Capital stock that has contractual preferences... Please Answer Question 2 Only You have been contracted by the government of your country to... Please Answer Question 2 Only You have been contracted by the government of your country to provide recommendations on the regulation of the national textile industry. Currently, the textile industry which resembles features of the perfectly competitive market is completely unregulated. Using the concepts covered in the class, please provide your advice to the problems below. One of the biggest social problems in the textile industry is child labour which, among other things, reduces school attendance. The government is considering... Please answer questions 1 - 5. Thank you. 1. What are the three types of financial... Please answer questions 1 - 5. Thank you. 1. What are the three types of financial assets? Please give one example or each asset category. 2. What is the difference between commercial papers and treasury bills? 3. List five money market instruments. 4. What are the benefits that are unique to municipal bonds? 5. What are the differences between common stock and preferred stock? Please answer All, I do not have computer to solve. Thank you ! 1. You have... Please answer All, I do not have computer to solve. Thank you ! 1. You have chosen biology as your college major because you would like to be a medical doctor. However, you find that the probability of being accepted to medical school is about 20 percent. If you are accepted to medical school, then your starting salary when you graduate will be $320,000 per year. However, if you are not accepted, then you would choose to work in a... Need a solution for question no.1 For this activity, you have been hired as a team... Need a solution for question no.1 For this activity, you have been hired as a team of consultants on a multi-year basis for a global washer and dryer manufacturer. They currently offer two core washer and dryer sets: a high-end model and an economic model. You are tasked to complete several calculations and present your findings to the company stakeholders. You may use any presentation software (Google Slides, Prezi, PowerPoint, etc.) and your completed presentation should consist of 8 –... Please answer each question and show calculation/ provide explanations. Thank you so much. Question 1 You... Please answer each question and show calculation/ provide explanations. Thank you so much. Question 1 You have just been hired as the staff accountant for Maximum Corporation. However, the accounting manager is unclear about your ability to determine where certain increases and decreases should be placed. Indicate in the columns below by placing a check-mark (√        ) in the appropriate column identified. Office rent is increased.                                   Service Revenue is increased. Prepaid Expense is reduced. Cash is decreased. Plant and machinery... 1. You have been hired as an analyst for an advisory company and your team is... 1. You have been hired as an analyst for an advisory company and your team is working on an independent assessment of G-Aviation. G-Aviation is a firm that specializes in the production of aviation material. Your assistant has provided you with the following data for G-Aviation and their industry. Ratio 2019 2018 2017 2019- Industry Average Long-term debt 0.45 0.40 0.35 0.35 Inventory Turnover 62.65 42.42 32.25 53.25 Depreciation/Total Assets 0.25 0.014 0.018 0.015 Days’ sales in receivables 113 98... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions A neurologist needs to counsel a stroke victim and her husband about possible outcomes, treatment options,... Case Study: Personal Beliefs in the Workplace Don Shakow was a prominent professional who worked in... 1: Competency framework usage is the modern best practice in management. What is meant by competency... A 19.34 g mixture of sugar (C12H22O11) and table salt (NaCl) is dissolved in 231 g... Young and Company claims that its pressurized diving bell will, on average, maintain its integrity to... 1) Alternative compiled code sequence using instructions in classes A, B, C. What is the average... An asset is purchased on January 1 for $48,700. It is expected to have a useful... ADVERTISEMENT About @ 2020 WizEdu