Can you please show work and formulas used? I'd like to actually understand the process. Thank you.

All Ratios as of April 2019 a. Using the average enterprise value to sales multiple in Table 10.1, estimate Nike's share price. Enterprise value (million) Share price estimate b. What range of share prices do you estimate based on the highest and lowest enterprise value to sales multiples in Table 10.1 ? c. Using the average enterprise value to EBITDA multiple in Table 10.1, estimate Nike's share price. Enterprise value (million) million Share price estimate d. What range of share prices do you estimate based on the highest and lowest enterprise value to EBITDA multiples in Table 10.1? \begin{tabular}{|r|l|l|} \hline Requirements \\ \hline 1 & In cell D34, by using cell references, calculate Nike's enterprise value to sales (1 pt.). \\ \hline 2 & IncellD35,byusingcellreferences,calculateNikessharepricebasedontheaverageenterprisevaluetosalesmultipleoftheindustry(1pt.). & IncellD39,byusingtheMAXfunction,displaythehighestenterprisevaluetosalesmultipleoftheindustryexcludingNikeitself(CellH13)(1pt.). \\ \hline 4 & IncellD40,byusingtheMINfunction,displaythelowestenterprisevaluetosalesmultipleoftheindustryexcludingNikeitself(CellH13)(1pt.). \\ \hline 5 & IncellD41,byusingcellreferences,calculateNikessharepricebasedonthehighestenterprisevaluetosalesmultipleoftheindustry(1pt.). \\ \hline 6 & IncellD42,byusingcellreferences,calculateNikessharepricebasedonthelowestenterprisevaluetosalesmultipleoftheindustry(1pt.). \\ \hline 7 & \begin{tabular}{l} In cell D46, by using cell references, calculate Nike's enterprise value to EBITD (1 pt.). \\ \hline 8 \end{tabular} IncellD47,byusingcellreferences,calculateNikessharepricebasedontheaverageenterprisevaluetoEBITDAmultipleoftheindustry(1pt.). \\ \hline 9 & IncellD51,byusingtheMAXfunction,displaythehighestenterprisevaluetoEBITDAmultipleoftheindustryexcludingtheNIKEitself(CellI13)(1pt.). \\ \hline 10 & IncellD52,byusingtheMINfunction,calculatethelowestenterprisevaluetoEBITDAmultipleoftheindustryexcludingtheNIKEitself(CellI13)(1pt.). \\ \hline 11 & IncellD53,byusingcellreferences,calculateNikessharepricebasedonthehighestenterprisevaluetoEBITDAmultipleoftheindustry(1pt.). \\ \hline 12 & IncellD54,byusingcellreferences,calculateNikessharepricebasedonthelowestenterprisevaluetoEBITDAmultipleoftheindustry(1pt.). \\ \hline \end{tabular}