Graded Valuation Problem Set
Instructions
Complete 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 Set
Note: 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 Feedback
It 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 used
Problem 2: 0pts – solver not used, NPV function not used
Problem 3: 0pts – cashflow payments incorrect, solver would not have generated IRR based off of this
Problem 4: 1.66pts – part a PMT function not used for payment, part b correct, part c PV calculations incorrect, functions not used
Problem 5: 0pts – XIRR function not used
Problem 6: 0pts – functions not used, incorrect answers for solved cells
I just uploaded my part and hope you can revise it following the instructor feedback and Please use the formula in the excel. Thanks.