Graded Valuation Problem Set

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.