USE EXCEL AND SHOW WORK PLEASE. THANKS!

2. J. Walker Manufacturing Co. is financially distressed and must pay "cash before delivery" for its raw materials. It pays $40 per assembly at the time of order. The parts are received 30 days after the order. Five days after they are eceived they are taken out of inventory and used in the manufacturing process. Walker incurs additional processing costs of $6.5 per assembly at the point in time when it manufactures its finished products. On average, it sells each finished assembly 95 days after manufacturing takes place a. Draw a cash flow timeline of the events above, being careful to denote which flows are negative and which are positive. Figure out how much Walker must sell each assembly for to break even on the present value basis. Use a discount rate of 15 percent. Now assume that Walker decides to sell the finished goods for $48.50. How high could the discount rate be for Walker to still break even on a present value basis? You may use the "Goal Seek" co b. c. mmand in the Tools menu in Microsoft Excel