You are evaluating an investment alternative that costs $45,000, is expected to last 5 years, and has a $5000 salvage value. The investment is expected to generate a positive net operating cash flow of $11,000 each year for years 1, 2, 3, 4, and 5.

a. Calculate the payback period

b. calculate the simple rate of return

c. using a 9% discount rate, calculate NPV

d. Calculate the IRR

Please show the answers in excel with the formulas