please answer using excel and explain

11) You are offered an investment that will cost $975 and will pay you interest of $80 per year for the next 10 years. The investment will pay $1,000 at the end of the 10 years. What is the rate of return if you purchase this investment? Use Excel's =RATE(NPER,PMT,PV, [FV], [ TYPE ]) function. NPER is 10, PMT is $80, PV is $975, FV is $1,000, and TYPE is 0 since payments are made at the end of the period. If the [type] argument is omitted, it takes on the default value of 0 . We use PV as a negative value to represent a cash outflow that results from money being invested. In that case, PMT and FV will be positive to represent cash inflows from the investment