must use excel/ show work/equations

Nike is looking to invest in a new running hat that will cost $375,000 in initial funds. The following profits for this project can be found in the following cash flow statement. What is the discounted payback period for this machine at a 15% interest rate? Year Cash Flow 0 (375.000,00) 1 30,000.00 39,913.64 2 3 44,683.05 4 5 46,042.05 59,851.88 70,478 27 6 7 92,328.27 118.999.04 8 9 10 11 12 137,696.22 173,913.72 226,00157 286,23776 286,494.19 376,62717 493,714.61 13 14 15 10-11 7-8 09-10 O11-12 12-13