Case 26
Lease Analysis
Prudent Solutions, Inc.
Assistants to Tony Davis
Executive Summary:
The Data Acquisition System (DAS) is initially estimated to cost $41.25 million if purchased outright. This purchase can be done using currently invested short-term marketable securities. Leasing is also an option with payments estimated at $12.75 million per year. After analyzing each scenario using the discounted cash flow method, the best option is to lease the equipment rather than purchase it. The net present value (NPV) for leasing the DAS is a negative ($28.10 million) and the NPV for the purchasing the DAS is a negative ($28.64 million). Our net advantage for leasing is $0.543 million.
Summary
…show more content…
We will have no residual value because the leased equipment will go back to the Lessor.
If we choose to lease the system
Commercial Capital Corporation is the leasing subsidiary of a major regional bank and offers a lease at 12.75 million per year for 4 years. The first payment is due upon delivery and installation. The rest of the payments are due each subsequent year at the beginning of the year. This cost includes the same service contract as what would have been obtained with purchase.
Commercial Capital Corporation’s Analysis
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.
Recommendation:
Although our calculation concluded that leasing has a negative net present value, it is
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.
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%.
The fixed cost is assumed that Larry has discovered the other fixed cost incurred. The total investment is $800,000. The worst case scenario assumes that Larry got a total line of credit from the bank in the amount of $400,000 and invested $400,000 from other source. The Notes payable – short term and the long-term debt is (11.8 + 3.7) = 15.5 % from Table F in the handout. The Loan interest and payment per year is ($400,000 * 0.155)= $62,000. The Income data from Table F indicates that there is a 0.4% of all other expenses net out of the total sales which equals to $109,908 (5,700,666 gallons * $4.82 *0.4%) .
Using the tables (shown below and in Exhibit 1) to calculate cash flow before financing and net proceeds from sale, a DCF method was used to arrive at a NPV of $216,789 and IRR of 13.3% for a 5-year holding period at assumed vacancy of 5% (Exhibit 1). As mentioned earlier, this IRR exceeds the 12.5% initially set out, and therefore seems like a feasible project. Using a higher vacancy rate of 7%, however, lowers the IRR to a point that is no longer feasible. If holding all else same, a vacancy of 7% on the building yields a NPV of $122,420 and an IRR of 11.47% (please see table below and Exhibit 2). This IRR does not meet the minimum required and therefore the assumption of vacancy rates staying at 5% is paramount to our analysis. This aspect of the analysis is considerably risky as an assumed vacancy rate does not necessarily yield a guaranteed rate. If vacancy happens to rise, then the valuation of the property is far different than what was originally envisioned.
Futronics Inc. is a $2 billion firm that sells communications services. Founded in 1937, Futronics Inc. has provided consumer products, as well as government systems and services, for well over half a century. Due to a sharp increase in competition, flattened sales, and external economic conditions, Futronics Inc. is implementing a corporate overhead reduction program. The proposal is to replace the company’s central office stores with outside vendors. The investment will cost $1,000,000 and yield incremental cash flows of $450,000 in year one (1), $350,000 in year two (2), $300,000 in year three (3), and $250,000 in year four (4). There is no salvage value of the asset, and the firm has a cost of capital of 8%. Using capital budget methods, Net Profit Value, Internal Rate of Return and Payback method, the capital investment can be appraised. Futronics Inc.
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.
4. Now consider a second alternative for accumulating funds to buy the new billing system. In lieu of a lump sum investment, assume that five annual payments of $32,000 are made at the end of each year.
The second segment of the simulation dealt with the acquisition of new equipment for the center. The center wishes to acquire a new high-speed CT scanner, a new X-ray machine, and a new ultrasound system. For each piece of equipment there is the option to buy a new one, buy a refurbished one, lease one on an operating lease or lease one on a capital lease. I chose to buy a new high-speed CT scanner
The third and final question from the case is how would the lease classification change under U.S. GAAP. The FASB codification that deals with leases is ASC 840. U.S. GAAP classifies leases as operating leases or capital leases and it has a section for sale-leaseback transactions as well. Under U.S. GAAP, the lease in this case would be classified as a capital lease. This is because ASC 840-10-25-29 says, “If at its inception a lease meets any of the four lease classification criteria in paragraph 840-10-25-1, the lease shall be classified by the lessee as a capital lease.” This lease meets two of those criterions. The lease term is equal to 75% of the economic life of the equipment (3 year lease term / 4 year economic life of equipment = .75 or 75%) and the present value of the minimum lease payments “equals or exceeds 90 percent of the excess of the fair value of the lease property to the lessor at lease inception over any related investment tax credit retained by the lessor and expected to be realized by the lessor” (ASC 840-10-25-1d). The present value of the minimum lease payments does in fact equal or exceed 90 percent of the fair value of the equipment ($248,690 / $265,000 = .94 or 94%). Under ASC 840-10-25-31, the lessee should use the implicit rate to calculate the present value of the lease payments because the lessee already
Changes to the rent roll and vacancy rate as well as the addition of debt cost in the mode yield an npv of $553k. When the initial investment of $400k is taken into consideration this yields a total npv of $153k. This is a positive NPV and therefore the investment is not a losing proposition. However this should be compared to other investments.
Question Number One (1) Value the processing plant proposal. Ignore the Industrial Revenue Bond financing. Assume: Market Risk Premium 8.8%, Riskless Rate 11.41%, and Harris Long Term Debt Rate 13.5%.
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____
9. Assuming that Santa Corporation was required to capitalize its operating lease how would the company’s
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%.
When a lessee signs a lease agreement that is for more than a year, either the Type A and Type B lease approach is taken to account for revenue, cash flows, and expenses correctly. Ultimately, both categories entail different approaches for lease accounting. In additional, the Financial Accounting Standards Board (FASB) new proposed lease standards may involve some effects on various accounting events. These events include the presentation of a company’s financial statements, interest charges, year-end reporting, financial disclosure notes, and income taxes. Leasing is an important part activity for many firms in the business