FIN515 Homework 5
Problem 10-8: NPVs, IRRs, and MIRRs for Independent Projects
Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year’s capital budget. The projects are independent. The cash outlay for the truck is $17,100 and that for the pulley system is $22,430. The firm’s cost of capital is 14%. After-tax cash flows, including depreciation, are as follows: Year | Truck | Pulley | 1 | $5,100 | $7,500 | 2 | 5,100 | 7,500 | 3 | 5,100 | 7,500 | 4 | 5,100 | 7,500 | 5 | 5,100 | 7,500
…show more content…
Problem 10-9: NPVs and IRRs for Mutually Exclusive Projects
Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Since both forklifts perform the same function, the firm will choose only one. (They are mutually exclusive investments.) The electric-powered truck will cost more, but it will be less expensive to operate; it will cost $22,000, whereas the gas-powered truck will cost $17,500. The cost of capital that applies to both investments is 12%. The life for both types of truck is estimated to be 6 years, during which time the net cash flows for the electric-powered truck will be $6,290 per year and those for the gas-powered truck will be $5,000 per year. Annual net cash flows include depreciation expenses. Calculate the NPV and IRR for each type of truck, and decide which to recommend.
PV (electric-powered) = $22,000
PV (gas-powered) = $17,500
Cost of capital = 12%
Number of years = 6
NCF for electric-powered = $6,290
NCF for gas-powered = $5,000
Electric-powered forklift:
NPV = -$22,000 + $6,290 [(1/i)-(1/(i*(1+i)n)]
NPV = -$22,000 + $6,290 [(1/0.12)-(1/(0.12*(1+0.12)6)]
NPV = -$22,000 + $6,290(4.1114) = -$22,000 + $25,861 = $3,861
IRR =rate (nper,pmt,pv,fv) = rate (6,6290,-22000,0) = 18%
Gas-powered forklift:
NPV = -$17,500 + $5,000 [(1/i)-(1/(i*(1+i)n)]
NPV = -$17,500 + $5,000 [(1/0.12)-(1/(0.12*(1+0.12)6)]
NPV =
Bixton Company’s new chief financial officer is evaluating Biston’s capital structure. She is concerned that the firm might be underleveraged, even though the firm has larger-than-average research and development and foreign tax credits when compared to other firms in its industry. Her staff prepared the industry comparison shown here.
Only the incremental costs and benefits are relevant. In particular, only the variable manufacturing overhead and the cost of the special tool are relevant overhead costs in this situation. The other manufacturing overhead costs are fixed and are not affected by the decision.
Problem 1: Jonathon Barrs is a manager for Easy Manufacturing, LLC. He wishes to evaluate three possible investments. These investments are for the purchase of new machine tools from Germany, Japan, and a local US manufacturer. The firm earns 10% on its investments and they have a risk index of 5%. The chart below lays out the expected return and expected risks of the three projects.
By using the 7.2% after tax rate and assuming the equipment will be sold at the beginning of the 5th year for its book value, if Agro-Chem bought the equipment the company would achieve a project NPV of ($1,043,500.23). In contrast, if Agro-Chem decided to lease the equipment with the same assumptions they would obtain a project NPV of ($1,030,205). Given these assumptions and based off our calculated NPV we recommend that Agro-Chem lease the equipment rather than buy because of the $13,295.23 savings. This $13,295.23 savings is the NAL.
As Pleasure Craft Inc. has publicly held debt; we determined the cost of debt to be the yield to maturity on the outstanding debt on the outboard motor project, so using a financial calculator we establish the YTM to be equal to 2.4827%. Because this is a Semi- annual compounding, rd = YTM * 2 = 4.9654%; for the cost of equity (Rf + β (Rm - Rf)): 12.8420%. The WACC is the discount rate of the projects WACC = rd * (1- Td) * D/V + (re * E/ V) = 4.9654% (1- 35%) * 30% + 12.8420% * 70% = 0.0996, so the WACC is determined to be 9.96% for outboard motors project. The NPV of this project is positive and equal to $35,630,973.63, the IRR for the outboard motors has calculated to be 8%. From these calculation we can know the project’s beta is lower than project front- end loader project and the risk is lower also; from the decision rule the NPV > 0 and IRR > R, so we choose the outboard motor project.
Commercial’s NPV is $.1516 million (see Table 3). This was determined by using the present values of the four year lease agreement between Prudent and Commercial. We concluded that Commercial’s discount rate will be 10% because of their opportunity cost. Commercial needs to have a residual value on the DAS of 6.8 million or greater, which will give them a positive net present value. Therefore, if their net present value shows negative, they would not want to lease to us. Assuming Commercial receives the same 5 year MACRS rate on the equipment purchase, then the system should be worth 7.01 million (book value) at the end of year 4 (see Table 4). This allows Commercial to have a positive NPV of $.1516 million (see Table 4). Therefore, they would be willing to lease the DAS to us.
After evaluating the Super Project for General Foods, the two main things that management needed to address were the relevant incremental and non-incremental cash flows discussed below and incorporate the NPV and the net cash flows (yearly) to make a decision on whether to accept or reject the project. The start-up costs were determined by splitting up the costs of $160,000 in 1967 and $40,000 in 1968. To calculate the yearly cash flows, I used year 1 through 10, and the gross profit was calculated by subtracting out relative cash flows and the before tax depreciation. The NPV of $169,530 is positive for the 10% discount rate, which is less than the IRR of 11.4%.
District Attorney Michael Nifong acknowledged and offered a full and unqualified apology for his crusade to convict three innocent white Duke University students who belonged to the lacrosse team of raping a black woman in March 2006. Nifong acknowledged there had been “no credible evidence” of their guilt. In fact there had been exculpatory evidence that he had quashed. His apology was rendered to a judge who later sentenced him to one day in jail and a $500. fine for contempt of court. He could have received thirty days (Prosecutorial Indiscretion, 2008).
The Kenton Company processes unprocessed milk to produce two products, Butter Cream and Condensed Milk. The following information was collected for the month of June:
Free cash flows of the project for next five years can be calculated by adding depreciation values and subtracting changes in working capital from net income. In 2010, there will be a cash outflow of $2.2 million as capital expenditure. In 2011, there will be an additional one time cash outflow of $300,000 as an advertising expense. Using net free cash flow values for next five years and discount rate for discounting, NPV for the project comes out to be $2907, 100. The rate of return at which net present value becomes zero i.e.
The estimate of total potential market for heater/blower unit is 2737 units and 2737000 units for blankets (see exhibit 1). The direct cost of the heater/blower unit would be $380 and $0.85 per blanket. The initial investment, $500,000, for this system would cover the fixed cost of the company during first year of operation. Based on this basic information and other considerations, the company has to determine its pricing strategy for both
The option to buy for 36 months follows the same logic with one exception. In this case, the hardware is no longer estimated to have a $150/unit salvage value. Instead, it is estimated that 20% of the computers can be sold to AMG employees for $50/unit. According to EPA regulations, the other 80% must be disposed of at a cost of $50. With this in mind, the NPV of cash flows for the 36 month buying option is $(5,687,735). To compare this to the 24 month buying option, the equivalent annual cost was calculated for both scenarios. The 24 month option has an EAC of $(3,063,455) and the 36 month option has an EAC of $(2,491,097), making the 36-month option the obvious choice.
The third scenario was ignoring the option to invest in the second-generation project and selling the equipment in year 2. We evaluated this option as a put option. First, we calculated the probabilities for going up and down based on the assumption of a risk neutral word. As a result, the probability of going upward is calculated as 0.3375 and downward probability is 0.6625. In order to determine the present value of all the sequence cash flow at the end of year 2, we calculated the upside change rate and downside change rate as 64.87% and -39.35%, respectfully. The next step is to analyze the option value by using the “Binomial Tree” method. In order to determine the present value of all the subsequence cash flow at the end of year 2, we calculated the cash flow at each node on the tree, until 2006. We discounted all the cash flow at the risk free rate at 10%. The End of Year NPV of all the subsequence cash flow at Year 2 is calculated as $7,571,752, and the selling price of the equipment at end of 2 is $4,000,000, which is the salvage value. We found the NPV of selling the machine at end of Year 2 to be -$2,951,861 as of Year 0, which is negative. The APV of the project after adding the option turned out to be -$6,321,932. This negative APV suggest that the
The main difference between investing in the Zinser machine and maintaining the status quo is an initial investment of $8.25 million and the receipt of $608,000 in after-tax sales proceeds from selling the existing machine. Additionally, there is an initial $50,000 ($32,000 after-tax) cost for training employees, but this cost is only incurred once (see exhibit 3). In their first year using the Zinser machine there will be a 5% decrease in sales volume, but selling price will increase 10%. Material costs per pound will be the same as the status quo, but conversion costs will decrease to $0.4077 per pound per year due to lower power, maintenance and return costs. Days of inventory held will also drop to about 20 days. All other assumptions are the same as the status quo. In this scenario, the NPV of the Hunter Plant is about $15.87million if Aurora invests in the new Zisner machine (see exhibit 3).
We assumed that the cost of graphite which according to exhibit 8 has been growing slower year on year would grow steadily at 4% and that power costs would grow at 12% per year up to 1989. We also assumed that the benefits of laminate technology will only be felt starting in 1981. With 1980 as the base year, the NPV calculation was done as at December, 1980 and we assumed that the cash injection of $2.5million dollars would occur instantaneously in December 1980. Using a median assumption of power cost savings of 17.5%, we arrive at an NPV of $12.865million for the laminate investment. The applicable range and full calculations are presented below.