Harvard Business School
9-291-031
Rev. November 17, 1993
Investment Analysis and Lockheed Tri Star
1. Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs. The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. The machine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost of capital for such an investment is 12%. [A] Compute the payback, net present value (NPV), and internal rate of return (IRR) for this machine. Should Rainbow purchase it? Assume that all cash flows (except the initial purchase) occur at the end of the year, and do not consider taxes. [B] For a $500 per year additional expenditure, Rainbow can get a
…show more content…
Using the net present value rule (NPV), which proposal(s) do you recommend? How do you explain any differences between the IRR and NPV rankings? Which rule is better?
3. MBATech, Inc., is negotiating with the mayor of Bean City to start a manufacturing plant in an abandoned building. The cash flows for MBAT’s proposed plant are: Year 0 - 1,000,000 Year 1 371,739 Year 2 371,739 Year 3 371,739 Year 4 371,739
The city has agreed to subsidize MBAT. The form and timing of the subsidy have not been determined, and depend on which investment criterion is used by MBAT. In preliminary discussions, MBAT suggested four alternatives: [A] [B] [C] [D] Subsidize the project to bring its IRR to 25%. Subsidize the project to provide a two-year payback. Subsidize the project to provide an NPV of $75,000 when cash flows are discounted at 20%. Subsidize the project to provide an accounting rate of return (ARR) of 40%. This is defined as:
2
Investment Analysis and Lockheed Tri Star
291-031
Average Annual Cash Flow − ARR = Investment ÷ 2
Investment # of Years
You have been hired by Bean City to recommend a subsidy that minimizes the costs to the city. Subsidy payments need not occur right away; they may be scheduled in later years if appropriate. Please indicate how much of a subsidy you would recommend for each year under each alternative suggested by MBAT. Which of the four subsidy plans would you recommend to
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.
Now we want to examine the analysis business report concerning the cost of capital that has been increased at 28% in accordance with the Net Present Value which is $500,000 the question being would still be worth it to make the investment to the company (Needles, 2010). While at the same time the internal rate of return is still at 21% which is lower than the 25% in the expenditures. In reflection of these calculations the investment would not
31) Your firm uses the payback method but does not discount any of the cash flows. Calculate the payback for the following investment: A machine costs $200,000 with after-tax installation costs of $15,000. After-tax cash inflows are expected to be 36,000 per year for the next seven years.
1. (TCO C) Silver City, Inc., has collected the following operating information below for its current month’s activity. Using this information, prepare a flexible budget analysis to determine how well Silver City performed in terms of cost control.
If Marlene Herbert were to discontinue place mats, he would miss $270,000 that will go toward Mendel paper company fixed cost. The company currently has a plant overhead that is estimated at $420,000 for the quarter. In addition to the fixed plant overhead, the plant incurs fixed selling and administrative expenses per quarter of $118,000. This draws the company to a total fixed cost of $538,000. If Marlene Herbert were to discontinue the second highest contributor to the fixed cost, he would need to increase the volume of computer paper and lower material cost to help pull the contribution margin of the lowest product up to help support the lost of a whole product line.
Thus, by year three the company will be making a profit off the investment as year three is 86.73 million profit by 55.35 cost giving the company a 31.38 million dollar surplus. Generally, a period of payback of three year or less is acceptable (Reference Entry) causing this project to be viable based off the payback analysis. Although, these calculations are flawed. The reason for this is because the time value of money is not taken into effect when calculating payback periods which is where IRR can further assist in a more realistic financial picture (Reference Entry).
A down payment of $70,000 would be required, and a first year interest payment of $45,370 (Exhibit 9). It is expected that the two machines would run at 40% capacity bringing in incremental revenue of $613,225, and incremental operating income of $234,855. The cost breakdown structure and the incremental gains for the laser cutter and water cutter can be seen in Exhibit 10. The ROI at 40% capacity is 33.80% (Exhibit 5), which is well above the banks lending rate. The payback period at 40% capacity is the lowest of all options at 3 years (Exhibit 6). With a score of 30, this option scored the highest against the decision criteria (Exhibit 7). This is largely due strongest cash flow, highest ROI, and emphasis on maintaining a high quality product and excellent costumer service.
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.
Using the sample data given in Table 2-20, make a recommendation for how many units of each style Wally should make during the initial phase of production. Assume that all of the 10 styles in the sample problem are made in Hong Kong and that Wally’s initial production commitment must be at least 10,000 units. Ignore price differences among styles in your initial analysis.
The use of an accounting rate of return also underscores a project 's true future profitability because returns are calculated from accounting statements that list items at book or historical values and are, thus, backward-looking. According to the ARR, cash flows are positive due to the way the return has been tabulated with regard to returns on funds employed. The Payback Period technique also reflects that the project is positive and that initial expenses will be retrieved in approximately 7 years. However, the Payback method treats all cash flows as if they are received in the same period, i.e. cash flows in period 2 are treated the same as cash flows received in period 8. Clearly, it ignores the time value of money and is not the best method employed. Conversely, the IRR and NPV methods reflect that The Super Project is unattractive. IRR calculated is less then the 10% cost of capital (tax tabulated was 48%). NPV calculations were also negative. We accept the NPV method as the optimal capital budgeting technique and use its outcome to provide the overall evidence for our final decision on The Super Project. In this case IRR provided the same rejection result; therefore, it too proved its usefulness. Despite that, IRR is not the most favorable method because it can provide false results in the case where multiple negative
There are several traditional methods that can be used in appraising investment decisions. For instance, the net present value method (NPV) which entails estimating the costs and revenues of a project and discounting these figures to get their present values. Projects with the biggest positive net present value are the ones chosen as they represent the best stream of benefits of investing in the project over and above recovering the cost of initiating the projects. The discount rate is another method which is similar to the net present value method but reflects more on the time preference. This approach may focus on the opportunity cost of
Internal rate of return (IRR) and Payback period “IRR of a project provides useful information regarding the sensitivity of the project’s NPV to errors in the estimate of its cost of capital” (Pierson et al.2011, pp.157).This proposal also shows the project is profitable by using Excel to get the IRR of 18.9%, which is
4. Increase add-on business by $3 million dollars within the first quarter of project completion by improving the company’s completed current service obligation rate to 95%
Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per year. Themachine costs $35,000 and is expected to last for 15 years. Rainbow has determined that the cost ofcapital for such an investment is 12%.[A] Compute the payback, net present value (NPV), and internal rate of return (IRR) for this machine.Should Rainbow purchase it? Assume that all cash flows (except the initial purchase) occur at the endof the year, and do not consider taxes. Rainbow Products is considering the purchase of a paint-mixing machine to reduce labor costs.The savings are expected to result in additional cash flows to Rainbow of $5,000 per
Yes, in the investment center. The managers are responsibility for the segments,investmentand asset base as well as the profits. Usually, evaluate based on the return on assetsemployed, evaluation might include a variety of measures such as profit, return oninvestment, residual income, economical valued added and a range of non-financialmeasures. Hence the manager in the districts should consider about the acquisition of newequipment which is an investment for the segment. And also, they evaluated equipments andaccounts receivable etc. based on the return on assets employed. May be it can also be the profit center because the managers usually evaluated in terms of effectiveness in raisingsegment profit level and controlling costs.QMSC should use EVA instead of ROA as the measure of district and manager performance. Since EVA is the best proxy for shareholder value at the business unit level, improving EVA will also improve the companys overall performance. The managers district objectives will then be congruent with the companys overall objectives. This will induce Mr. Richards to employ additional assets