Graded Valuation Problem Set 1Question Description InstructionsComplete Problem 1 through 6 in the provided Excel template. Use Excel or save as an Excel file (.XLS or .XLSX) for all calculations. All formulas should flow through the spreadsheet and entries should not be hard-keyed. Use APA formatting to cite any resources used. To access this assignment: 1-3 Graded Valuation Problem SetNote: When submitting Problem Set assignments, regardless of what software you are using to perform the assignment, please export or save your assignment as an Excel .XLS or .XLSX file to receive instructor feedback.Instructor FeedbackIt looks like you may have misunderstood the need to use the formulas within excel to demonstrate your work. Please see breakdown below.Problem 1: 2.5pts – PMT function not usedProblem 2: 0pts – solver not used, NPV function not usedProblem 3: 0pts – cashflow payments incorrect, solver would not have generated IRR based off of thisProblem 4: 1.66pts – part a PMT function not used for payment, part b correct, part c PV calculations incorrect, functions not usedProblem 5: 0pts – XIRR function not usedProblem 6: 0pts – functions not used, incorrect answers for solved cellsI just uploaded my part and hope you can revise it following the instructor feedback and Please use the formula in the excel. Thanks.