can somebody verify my answers and the rest of the sheet with work?

CHALLENGE #10 ACC 212 Name: CAPITAL BUDGETING Containers Company manufactures glass jars used to package a variety of liquid consumer products such a Auce, soft drinks, alcoholic beverages, sauces, and various food items). The containers are manufactured on a lob orier basis to customer specifications. Creative Containers has received five proposals for capital investment projects. Your job is to evaluate these proposals and determine which one, if any, should be funded. Management requires a minimum 20% accounting rate of return on the investment and a cash payback period of no more than 3.5 years. Project A. This proposal requests funds to purchase hardware and software that will allow the accounting department to process payroll in-house. Paychecks are currently processed by an outside payroll service company. The company expects an annual reduction in costs and increase in cash flows if the payroll function is no longer contracted to an putside company. Cost $192,000 Annual project income $19,500 Life (in years) Annual net cash flows $67,500 Salvage Value Project B: This proposal requests funds for new manufacturing equipment. This equipment will allow Creative Containers to make glass containers as large as 2 gallons. Currently, the company cannot make containers that are larger than 1 Rallon and the company thinks there is a market for the larger containers, especially in the alcoholic beverages industry. $270,000 Cost Life (in years) Salvage Value Annual project income Annual net cash flows $26,000 $71,000 Project. This proposal requests funds for equipment to take stick-on labels that are applied to the bottles. Currently, all stick-on labels are ordered from another company. This label supplier has not proven very reliable in meeting delivery deadlines so the company expects making their own labels will help them satisfy their customers more reliably. Cost $348,000 Annual project income $38,454 Life (in years) Annual net cash flows $96,454 Salvage Value Project D: This proposal requests funds for automated manufacturing equipment that will reduce the cycle time from receipt of a customer order to delivery of that order. Creative Containers' cycle time is currently 7 days. The automated equipment will reduce the cycle time to 4 days while saving costs due to the elimination of seven jobs. It will also make Creative Containers more competitive: the company's major competitor currently has a cycle time of 5 days, $480,000 Cost Life (in years) Salvage Value Annual project income Annual net cash flows $58,000 $138,000 Proiecte: This proposal requests funds for computerized drafting and design equipment that will allow engineers to olete manufacturing Instructions on special orders more quickly. This equipment should reduce Creative Containers time from 7 to 5 days. Currently, about 40% of the company's business is considered to be "special order. Cost $275,000 Annual project income $35,000 Annual net cash flows $103,750 107 Life (in years) Salvage Value CC 212 Excerpt from a present value of an annuity table! Challenge #10 Name: Present Value of an Annuity of $1 at Compound Interest Period 14% 15% 19% 15% 16% 17% 18% 2-9137 2.8550 2792 2.7437 2 6901 26356 6 38887 3.7845 3.4098 3.6847 3 .5892 3.4976 1. Begin your analysis by computing the accoun on your analysis by computing the accounting rate of return AND cash payback gerlad for each of the five proposals. Any that has an accounting rate of return of less than 20% and a cash payback period of longer than 3.5 years should be eliminated from further consideration and collations when necessaryro s paces to the right of the decimal point Projects: DE eft Accounting rate of return 10.156 9.63 11.05 12.683 12.727 Cash Payback Period 2.844 3.803 3.608 3.478 2.651 2. After the initial screening, compute the net present value (using a 15% discount ratel, profitability index, and internal rate of return for any projects that were not eliminated after the accounting rate of return AND cash payback calculations. Net Present Value Profitability Index Internal Rate of Return Acceptable? Ves/No Yes/No Yes/No Yes/No Yes/No 3. Rank all projects based on both their profitability (the numbers) and the qualitative factors (this information is provided on the first pare of the challenge). You must consider the overall merit to the corporation before making a final decision Rank in Order: 1/2/3/4/5 1/2/3/4/ 5 1 /2/3/4/5 1/2/3/4/5 1/2/3/4/5 4. Select one project to support and provide an explanation of why you chose that particular one. Your explanation must mention the impact that the qualitative factors had on your final decision. Why? 108