Chapter 10 Case 2 The saloon is considering adding a new machine. The machine cost $32,000 plus $3,007 to install. The annual revenue and expenses (all cash) are as follows: The machine is expected to have a 5 year itie. The required rate of return for the machine is 10%. Create a computer spreadsheet to calculate the following items. Be sure to show your calculations. Explain how you got the internal Rate of Return in part b using the present value table. a. Payback (3.89) b. Internal Rate of Return (9%) c. Net Present Value (5890)