used excel

Bramble Vita produces a wide range of herbal supplements sold nationwide through independent distributors. In response to an increasing demand for its products, the company is considering the purchase of a new packaging machine to replace the seven-yearold machine currently in use. The new machine will cost $176,300, and installation will require an additional $3,275. The machine has a useful life of 10 years and is expected to have a salvage value of $3,730 at that time. The variable cost to operate the new machine is $11.80 per carton compared to the current machine's variable cost of $11.90 per carton, and Bramble Vita expects to pack 258,000 cartons each year. If the new machine is purchased, Bramble Vita will avoid a required $11,550 overhaul of the current machine in four years. The current machine has a market value of $13.150. Click here to view the factor table. (a) Calculate the net present value of the new packaging machine. Assume that Bramble Vita uses an 9% discount rate. (For calculation purposes, use 4 decimal places as displayed in the factor table provided and round final answer to 2 decimal places, eg. 58,971.75. Enter negative amount using a negative sign preceding the number, eg. -59,991 or parentheses eg. (59,991).) Net present value (b) Do you recommend that Bramble Vita purchase the new machine? (c) Assume that Bramble Vita has adopted a new 11\% discount rate. Calculate the net present value of the new packaging machine. (For calculation purposes, use 4 decimal places as displayed in the factor table provided and round final answer to 2 decimal places, eg. 58,971.75. Enter negative amount using a negative sign preceding the number, e.g. 59,991 or parentheses eg. (59,991). Net present value Do you recommend that Bramble Vita purchase the new machine