Hi everyone. Please see attached the excel document to use for your case study. As mentioned in class, it is due the 16th (same day as final) by 7:00pm. If you have any questions, feel free to email me!

Excel Case Study-1.xlsx

Rubric:

• 2 pts: Successfully performed a V-lookup to get City & Product Cost information in the Sales worksheet
• 3 pts: Used nested if function, to get the Sales Amount after discount
• 2 pts: Successfully Created a Pivot table to show the Sales Amount after Discount by City and Product ID
• 3 pts: Successfully created an amortization schedule.