please include excel functions and or steps to complete. thank you!!

6-7. the shop foreman at Santa Barbara Rig Service proposed a portable service unit requiring an initial outlay of $100,000 and providing the following year-end cash flows. Year Cash Flows 1 $30,000 2 -$50.000 3 $70,000 $60,000 5 $50,000 At a 10 percent required return, find the net present value. Is the investment desirable? Explain why this is desirable or undesirable assuming your audience is not trained in finance 6-9. Find the internal rate of return and modified internal rate of return for the above project in 6-7. Interpret these measures for a manager who is not trained in finance