HBS. Tristar

Rainbow Products and the paint-mixing machine A) The paint-mixing machine cost 35. 000 dollars, which is the initial cash outflow. The machine will start additional cash inflows of 5. 000 dollars for the next 1 5 years. With cost of capital of 12% the Net shew value rat be calculated use the NP formula in Excel NP= 945. 68 Data Description Rate $0. 12 935,000. 00 Investment $5,000. 00 scofflaws at the end of year $34,054. 32 NP $-945. 68Note that because the cash inflow is constantly reoccurring and occurs for a set period of time the Present value could also be calculated as an annuity and then added to the initial cash outflow. Doing this calculation, one would expect the result to be the same. Internal Rate of Return, AIR, is the return on the investment when NP is zero. AIR can also be calculated using Excel Because AIR is less than the cost of capital (12%) and the NP is negative, both methods suggest that undertaking the investment would remove shareholders value, hush th e investment should not be undertaken.The simple Payback period is when the initial investment is recovered, this will occur at the end of year 7, hence the payback period is 8 years. B) For an additional 500 dollars the machine can get service each year to as-good-as- new and the value of the investment can indeed be calculated as a perpetuity. A Perpetuity is calculated as Thus, NP = -35,000 + 37,500 = 2500 NP is positive with the service contract, so Rainbow Products should undertake the investment, as it will increase shareholder value.C) Rainbows engineers have another way of preserving and increasing the capability of the machine, which allows the annual scofflaws to increase by 4%, this requires reinvesting 20% of the annual scofflaws. The Present Value of an end-of-year perpetuity is calculated as Thus, the NP = -35,000 + 50,000 = 15,000 As the NP of the investment in the machine with engineers added work is 12,500 dollars more than the NP of the investment in the machine with as-good-as-new contract.