please help for the excel assignment, this is all the information from the original question

A project will cost a firm an initial investment of $39,000 and is estimated to yield the after-tax cash fllow given below over 8 years. If the WACC is 7.8%, calculate the NPV, IRR, Payback, Discounted Payback, and PI for the project.
WACC	7.8%	Use the blue cells for subcalculations
0	1	2	3	4	5	6	7	8
(39,000)	5,000	5,500	6,000	7,000	7,500	8,500	9,500	11,000
NPV:
IRR:
Payback:		use the MATCH() function
Disc. Payback:		use the MATCH() function
PI: