Ray Summers Company operates at full capacity of 12,438 units per year. The company, however, is still unable to fully meet the demand for its product, estimated at 15,000 units annually. This level of demand is expected to continue for at least another four years To meet the demand, the firm is considering the purchase of new equipment for $580,000. This equipment has an estimated useful life of 4 years; estimated sales (disposal) value of this asset at the end of 4 years is $50,000 (pretax). The engineering division estimates that installing, testing, and training for the use of the equipment will cost $12,000. These costs are to be capitalized as part of the cost of the new equipment. An adjacent vacant warehouse can be leased for the duration of the project for $10,000 per year. Which cost would be included as part of fixed manufacturing overhead. The warehouse needs $58,000 of renovations to make it suitable for manufacturing. The renovation cost is to be capitalized as part of the cost of the new equipment. The lease terms call for restoring the warehouse to its original condition at the end of the lease. The restoration is estimated to cost $20,000, a cost that is fully deductible for tax purposes. Current pretax operating profit per unit is as follows: The new equipment would have no effect on the variable costs per unit. Alt current fixed costs are expected to continue with the same total amount. The per-unit fixed cost includes depreciation expenses of \$5 for manufacturing and \$4 for marketing and administration. Additional frxed manufacturing costs of $140.000 (excluding depreciation on the new equipment) will be incurred each year if the equipment is purchased. The company must also hire an additional matketing manager to serve new customers. The annual cost for the new marketing manager, support staff, and office expense is estimated at approximately $100000. The company expects to be in the 40% tax bracket for each of the next 4 years. The company requires a minimum after-tax rate of return of 12% on irvestments and for tax purposes uses straight-ine depreciation with a $50,000 salvage value assumed. (Use Tabici ind Table-2) Required: 1. What is the required net initial investment outlay (vear of? 2. (a) What is the projected increase in after-tax operating profit for each of the first 3 years if the new equipment is purchased? (Assume for each year that sales equals production) (o) What is the projected year-4 increase in after-tax operating profit if the new equipment is purchased? (Round your onswers to the neorest whole dollot omount) 3. (a) If the new equipment is purchased, what is the projected increase in ofter-tax cash intlow for each of the first 3 years of the asset's ife? (b) What is the projected year 4 increase in after-tax cash inflow if the new equipment is purchased? (Round your answers to the nearest whole dollor amount.) 4. Compute the (unadjusted) payback period of the proposed investment under the assumption that cash inflows occur evenly throughout the year, (Round your onswer to 2 decimal ploces.) 5 . Compute the accounting (book) rate of return (ARR) of the proposed investment, based on the averoge book value of the investment (Round vour onswers to 2 decimnl pinces li.e 01234123494 I 5. Compute the accounting (book) rate of return (ARR) of the proposed investment, based on the average book value of the investment. (Round your answers to 2 decimal pleces. (L.e. 0,1234=12.34% ). 6. Compute the estimated net present value (NPV) of the proposed investment under the assumption that all cash inflows occur at year-end. (Round your onswers to the nearest whole dollar amount) 7. Compute the discounted payback period of the ptoposed investment under the assumption that cash inflows at the end of each year (Round your onswer to the nesrest whole number.) 8. Compute the internal rate of return (IRR) of the proposed imestment (to 1 decimal place) under the assumption that al cash inflows occur at year-end. (Round your onswers to 1 decimal ploce. (i.e. 0.123=12.3%) ) 9. Use the MiRR function in Excel to estimate the modified internal rate of retum (MiRR) for the proposcd investment (Round your answers to 1 decimal place. (0.e. 0.123=12.395) ) 10 Assume now that the company expects the variable manufacturing cost per unit to increase once the new equipment is an place What is the most that the per-und varlable manufacturing cost can increase and still allow the company to eam the minimum rate of retum on this invertment? (Hint Use the Goal Seck option in Excel) (Round your answer to 2 decimal places.)