Finc312 Case 3

The new canning equipment should be leased over the 14 year term with no bargain purchase option so as to structure it as an operating lease. The major factor to consider is what will boost Net Income the most given that the goal is raise the share price. After a

Failure to handle these situations properly can lead to huge product liability suits and even bankruptcy.

2. Net Present Value – Secondly, Peter needs to investigate the Net Present Value (NPV) of each project scenario, i.e. job type, gross margin, and # new diamonds drills purchased. The NPV will measure the variance of the present value of cash outflow (drilling equipment investment) versus the future value of cash inflows (future profits), at the benchmark hurdle rate of 20%. A positive NPV associated with the investment means that the investment should be undertaken as it exceeds the minimum rate of return. A higher NPV determines which project scenario will have the highest return on cash flow, hence determining the most profitable investment in terms of present money value.

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.

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

Grappling with the potential purchase of Olive Hill Farm, we decided to conduct a financial analysis to determine whether the project should be taken or not. Our financial analysis include scenarios for the best, worse, and most likely outcomes of purchasing the farm. For each scenario a Net Present Worth (NPW) and an Internal Rate of Return (IRR) was calculated and compared. This revealed that there was little gain for the worst case scenario and large gains for the other two scenarios. A sensitivity analysis and a break-even analysis was also conducted. The sensitivity analysis identified the most influential factors on the NPW. In the end, the analysis favored buying Olive Hill Farm because it would be a low risk, high reward investment.

The company can afford to invest more fixed costs and variable costs (shifting assets from “A” to “C”) for additional “C” capacity thereby maximizing capacity utilization.

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.

What is the implied average collection period for the end of March? For the end of June?

I am asked to compute the before-tax Net Present Value or NPV of a new ski lift for Deer Valley Lodge and advise the management there of the profitability. Before I am able to make this calculation there are a few calculations that I will need to make first. First the total amount of the investment, this will be the cost of a lift itself $2 million plus the cost of preparing the slope and installing the lift $1.3 million. Thus the investment amount for one lift is $3.3 million.

2. The current NPV is negative. One way to save money would be to reduce consulting costs. Please set the average consulting cost per month in cell b33 to $5000. At what discount rate is the NPV for the project 0?_____0.026____

The upgrade of the Rotterdam plant involves implementing the Japanese technology and requires a capital expenditure of £8.0 million with £3.5 million spent today, £2.0 million on year one, £1.0 million on year two and £1.0 million on year three. This will also increase polypropylene output by 7% from current levels at a rate of 2.0% per year. In addition, gross margin will improve by 0.8% per year from 11.5% to 16.0%. After auditing the financial models, it is concluded that the static net present value of the upgrade is -£6.35 million using a discount rate of 10% and an expected inflation rate of 3% annually. The Rotterdam upgrade contains an option to switch to the speculated German technology being available in five years. The current value of the option is zero as it is deeply out-of-the-money. The total net present value of the upgrade is -£6.35 million. The incremental earnings per share of the upgrade is £ 0.0013, the payback period is 14.13 years, and the internal rate of return is 18.7%.

AMG Inc, a Fortune 500 financial services company, is implementing 7,542 new PCs in the time frame of twelve months in multiple locations covering eight states. This is a $7.5 million technology financing decision which needs to be investigated. The current decision that Adam Stolz, controller for the CFO, faces is whether AMG should lease or buy the new PCs. Also, he is under pressure from the CEO to keep the transaction off of the balance sheet, in which case the equipment/software would have to be defined as an operating lease, according to the standards defined in FAS 13. The lease options consist of a 24-month lease or a 36-month lease, and AMG could also choose to purchase the computers for the same

What are the key takeaways to remember when determining future lease versus buy decisions of this magnitude?

The present value of the net incremental cash flows, totaling $5,740K, is added to the present value of the Capital Cost Allowance (CCA) tax shield, provided by the Plant and Equipment of $599K, to arrive at the project’s NPV of $6,339K. (Please refer to Exhibit 4 and 5 for assumptions and detailed NPV calculations.) This high positive NPV means that the project will add a significant amount of value to FMI. In addition, using the incremental cash flows (excluding CCA) generated by the NPV calculation, we calculated the project’s IRR to be 28%. This means that the project will generate a higher rate of return than the company’s cost of capital of 10.05%. This is also a positive indication that the company should undertake the project.