Please see attached document with the assignment information. Please show all formulas and work in excel and give

Please see attached document with the assignment information.  Please show all formulas and work in excel and give a brief explanation in word with references. Purchase the answer to view it