Question

In: Accounting

As part of your new job responsibilities as an analyst for Lachute Lumber, you have been...

As part of your new job responsibilities as an analyst for Lachute Lumber, you have been asked to help evaluate a new project. Lachute has a market value debt-to-equity ratio of .6667. The firm's cost of equity is 15% and its pre-tax cost of debt is 4.917%. Flotation costs of debt and equity are 1.71% and 5%, respectively. The firm has a tax rate of 40%.

The new project requires purchasing equipment that will cost $2,000,000 plus an additional $200,000 in shipping & installation costs and $50,000 in training costs. Management estimates that the firm will generate annual operating revenues before taxes of $1,000,000 and incur annual operating expenses before taxes of $500,000 over the economic life of the project. The economic life of the machine is ten years and management estimates that at the end of the economic life, the machine will have a salvage value of $200,000. This machine is in asset class 8 which has a CCA rate of 20%. The asset class is expected to remain open at the end of the project. Assume this project will have the same level of risk as the firm, flotation costs are expensed and the company has no internally generated funds available.

a) What is Lachute’s weighted average cost of capital?
b) Calculate the Initial Investment.
c) Calculate the PV of Operating (Incremental) cash flows after tax

d) Calculate the PV of the ending cash flows
e) Calculate the PV of the CCA tax shield
f) Calculate the NPV. Should the project be accepted?

Solutions

Expert Solution

After-Tax flotation cost of equity (5%(1-40%)) = 3%

a.Lachute's WACC=
(Wt.d*kd)+(Wt.e*ke)
ie.(0.6667/1.6667*(4.917+1.71)%*(1-40%))+
(1/1.6667*(15+3)%)=
12.39%
b.Initial investment
Cost of equipment $       2,000,000
Shipping & installation $          200,000
Training costs $            50,000
Total $      -2,250,000
c.PV of incremental opg.After-tax cash flows
(1000000-500000)*(1-40%)=
300000
P/A,300000,i=12.39%,n=10 yrs.
300000*5.56115= $       1,668,345
d. PV of ending cash flows
ie.PV of After-tax salvage
Loss on salvage
216637/1.1239^10= $            67,368
e.PV of CCA tax shields
As per table $          537,171
f. NPV of the project
sum(b….e) $            22,884
YES. It should be accepted
e.PV of CCA tax shields
Year Depn. Carrying value ITS PV F at 12.39% PV at 12.39%
1 2=Prev.3*20% 3=prev.3-2 4=2*40% 1/1.1239^Yr.n 6=4*5
0 $      2,250,000
1 $          450,000 $      1,800,000 $      180,000 0.88976 $      160,157
2 $          360,000 $      1,440,000 $      144,000 0.79167 $      114,001
3 $          288,000 $      1,152,000 $      115,200 0.7044 $        81,146
4 $          230,400 $         921,600 $        92,160 0.62674 $        57,761
5 $          184,320 $         737,280 $        73,728 0.55765 $        41,114
6 $          147,456 $         589,824 $        58,982 0.49617 $        29,266
7 $          117,965 $         471,859 $        47,186 0.44148 $        20,831
8 $            94,372 $         377,487 $        37,749 0.39281 $        14,828
9 $            75,497 $         301,990 $        30,199 0.3495 $        10,555
10 $            60,398 $         241,592 $        24,159 0.31097 $          7,513
$       2,008,408 $      803,363 5.56115 $      537,171
Carrying Value $         241,592
Less:Salvage $         200,000
Loss on salvage $           41,592
Tax saved on loss(loss*40%) $           16,637
After tax salvage(200000+16637) $         216,637

Related Solutions

In your new role as compensation​ analyst, you have been asked to estimate the dollar amount...
In your new role as compensation​ analyst, you have been asked to estimate the dollar amount of the​ profit-sharing pool based on three approaches as well as the allocation of​ profit-sharing awards to eligible employees. The​ company's profits equal​ $35 million. You are considering the following three formulas for determining the total​ profit-sharing pool. ​First-Dollar of Profits​: The company agrees to share 3.0 percent of all profits up to​ $12 million. Graduated First-Dollar-of-Profits​: The company agrees to share 2.0 percent...
As part of their job responsibilities, engineers often have to make decisions related to the financial...
As part of their job responsibilities, engineers often have to make decisions related to the financial well-being of their organization. This includes the process of downsizing: reducing their staff and subcontracting the work/jobs. Some of the reasons for downsizing include: To reduce the cost of production/operations by shifting work to lower-cost wage regions (domestically or internationally). To reduce the cost of production/operations by introducing advanced technologies (e.g. automation) that require fewer employees To gain market share in other regions by...
As a senior analyst for the company you have been asked to evaluate a new IT...
As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $100,000 for a test marketing analysis. After looking at the project plan, you anticipate that the project will need to acquire computer hardware for a cost of $450,000. The Australian Taxation Office rules allow an effective life for the computer hardware of five years. The equipment can be depreciated on a straight-line (prime cost)...
As a senior analyst for the company you have been asked to evaluate a new IT...
As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $100,000 for a test marketing analysis. After looking at the project plan, you anticipate that the project will need to acquire computer hardware for a cost of $450,000. The Australian Taxation Office rules allow an effective life for the computer hardware of five years. The equipment can be depreciated on a straight-line (prime cost)...
As part of an interview for a summer job with the Coast Guard, you have been...
As part of an interview for a summer job with the Coast Guard, you have been asked to help determine the search area for two sunken ships by calculating their velocity just after an accident. According to the last radio transmission from the luxury liner Apollo (3.9 × 104 metric tons), it was going due east at a steady speed of 21 knots in calm seas through a rare fog just before it was struck broadside by the freighter Blake...
You have been hired as new analyst at Foxconn Interconnect Technology Limited (FIT) and have been...
You have been hired as new analyst at Foxconn Interconnect Technology Limited (FIT) and have been asked to evaluate the new manufacturing plant to produce new state of art internet security system. Suppose that FIT is considering expanding its wireless home networking appliance, called EasyNet, that will provide both the hardware and the software necessary to run an entire home from any Internet connection. EasyNet will also control new Internet-capable stereos, digital video recorders, heating and air-conditioning units, major appliances,...
You have been hired as an analyst for Melvin Bank and your team is working on...
You have been hired as an analyst for Melvin Bank and your team is working on an independent assessment of TWINKY, which is a firm that specializes in the production and distribution of ice and glass products in Sweden. Your assistant has provided you with the following data about the company and its industry. You analysis should include intra-company, inter-company, and industry benchmark comparisons. What can you say about the firm's overall management in terms of the following? (Be as...
You have been hired as an analyst for Bank WA and your team is working on...
You have been hired as an analyst for Bank WA and your team is working on an independent assessment of a firm that specializes in the production of freshly imported farm products from New Zealand. Your assistant has provided you with the following data about the company and its 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...
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...
You have been hired as an analyst for Bank WA and your team is working on...
You have been hired as an analyst for Bank WA and your team is working on an independent assessment of Duck Food Inc. (DF Inc.). DF Inc. is a firm that specializes in the production of freshly imported farm products from New Zealand.  Your assistant has provided you with the following data about the company and its industry. Ratio 2018 2017 2016 2018- 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT