Assignment 13 | Business & Finance homework help

Please read the attached document for instructions and complete the assignment in excel. I have attempted all the questions; however, i was only able to corrrectly answer the second question. Please help calculate the first and last question. Show all steps for calculations.