In: Finance
Managers of Coronado Embroidery have decided to purchase a new monogram machine and are considering two alternative machines. The first machine costs $114,000 and is expected to last five years. The second machine costs $182,000 and is expected to last eight years. Assume that the opportunity cost of capital is 8 percent. What is the equivalent annual cost for each system? (Do not round intermediate calculations. Round final answers to 2 decimal places, e.g. 2.75.) Equivalent Annual Cost First machine $ Second machine $ Which machine should Coronado Embroidery purchase? Coronado Embroidery should purchase the machine.
Machine 1 | ||||||
Discount rate | 8.000% | |||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow stream | -114000.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 | 1.360 | 1.469 |
Discounted cash flows project | -114000.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
NPV = Sum of discounted cash flows | ||||||
NPV Machine 1 = | -114000.00 | |||||
Where | ||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
Discounted Cashflow= | Cash flow stream/discounting factor | |||||
Equvalent annuity(EAA)= | -28552.04 | |||||
Required rate = | 8.000% | |||||
Year | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow stream | 0.00 | -28552.04 | -28552.04 | -28552.04 | -28552.04 | -28552.04 |
Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 | 1.360 | 1.469 |
Discounted cash flows project | 0.000 | -26437.070 | -24478.769 | -22665.527 | -20986.599 | -19432.036 |
Sum of discounted future cashflows = | -114000.00 | |||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||
Discounted Cashflow= | Cash flow stream/discounting factor |
Machine 2 | |||||||||
Discount rate | 8.000% | ||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Cash flow stream | -182000.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 | 1.360 | 1.469 | 1.587 | 1.714 | 1.851 |
Discounted cash flows project | -182000.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 |
NPV = Sum of discounted cash flows | |||||||||
NPV Machine 2 = | -182000.00 | ||||||||
Where | |||||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||||||
Equvalent annuity(EAA)= | -31670.69 | ||||||||
Required rate = | 8.000% | ||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Cash flow stream | 0.00 | -31670.69 | -31670.69 | -31670.69 | -31670.69 | -31670.69 | -31670.69 | -31670.69 | -31670.69 |
Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 | 1.360 | 1.469 | 1.587 | 1.714 | 1.851 |
Discounted cash flows project | 0.000 | -29324.710 | -27152.509 | -25141.212 | -23278.900 | -21554.537 | -19957.905 | -18479.541 | -17110.686 |
Sum of discounted future cashflows = | -182000.00 | ||||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||||||
Discounted Cashflow= | Cash flow stream/discounting factor |
Choose Machine 1 as it has lower EAC