In: Operations Management
1) The machines shown below are under consideration for an improvement to an automated candy bar wrapping process. Determine which machine should be selected on the basis of an Annual Worth Analysis using an interest rate of 10% per year. (50 points) (Remember to include complete calculations for AWmachine C, AWmachine D, and selection) Machine C Machine D First cost, $ –40,000 –75,000 Annual cost, $/year –15,000 –10,000 Salvage value, $ 12,000 25,000 Life, years 3 6 Chapter 7_Rate of Return Analysis (single project)
2) Swagelok Enterprises is a manufacturer of miniature fittings and valves. Over a 10-year period, the costs associated with one product line were as follows: first cost of $30,000 and annual costs of $18,000. Annual revenue was $27,000, and the used equipment was salvaged for $7,000. What rate of return did the company make on this product? (Blank and Tarquin, 6th and 8th edition)
a) Write the ROR equation in the form PW = 0 to determine i* (25 points)
b) Prepare “Year vs. Net Cash Flow” table to find i*. What rate of return did the company make on this product? (Use Spreadsheet to find i*) (25 points)
1
Property | ||||
Discount rate | 10.00% | |||
Year | 0 | 1 | 2 | 3 |
Cash flow stream | -40000 | -15000 | -15000 | -3000 |
Discounting factor | 1 | 1.1 | 1.21 | 1.331 |
Discounted cash flows project | -40000 | -13636 | -12397 | -2253.9 |
NPV = Sum of discounted cash flows | ||||
NPV Property = | -68287 | |||
Where | ||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||
Discounted Cashflow= | Cash flow stream/discounting factor | |||
Equvalent annuity(EAA)=(AW project C) | -19584 | |||
Required rate = | 10.00% | |||
Year | 0 | 1 | 2 | 3 |
Cash flow stream | -19584 | -19584 | -19584 | -19584 |
Discounting factor | 1 | 1.1 | 1.21 | 1.331 |
Discounted cash flows project | -19584 | -17804 | -16185 | -14714 |
Sum of discounted future cashflows = | -68287 | |||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||
Discounted Cashflow= | Cash flow stream/discounting factor | |||
Discount rate | 10.00% | ||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
Cash flow stream | -75000 | -10000 | -10000 | -10000 | -10000 | -10000 | 15000 |
Discounting factor | 1 | 1.1 | 1.21 | 1.331 | 1.464 | 1.611 | 1.772 |
Discounted cash flows project | -75000 | -9090.9 | -8264.5 | -7513.1 | -6830.1 | -6209.2 | 8467.11 |
NPV = Sum of discounted cash flows | |||||||
NPV Property = | -104441 | ||||||
Where | |||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||||
Equvalent annuity(EAA)= (AW project D) | -19502 | ||||||
Required rate = | 10.00% | ||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
Cash flow stream | -19502 | -19502 | -19502 | -19502 | -19502 | -19502 | -19502 |
Discounting factor | 1 | 1.1 | 1.21 | 1.331 | 1.464 | 1.611 | 1.772 |
Discounted cash flows project | -19502 | -17730 | -16118 | -14652 | -13320 | -12109 | -11009 |
Sum of discounted future cashflows = | -104441 | ||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||
Discounted Cashflow= | Cash flow stream/discounting factor |
2)