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 download

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.

G18 D E H Use the appropriate tinunce function to calculate the messing information in the table below. Option Bank Naine Total Yearly Bament 1 62 73 813 Bank Bank Bank Bank D Number of Compounding Annual interest Loan Duration Present Future Periods per year Rate Payment per Period In Years I wlue Valun 12 5 $ (1.564) 75,000 $ 14 6.75% s 5.656 70,000 $ 112 5.005 4 $ (1.658.11 IS 12 3.80 3 $ $5,000 9 30 11 12 3 Choose an option that you think will be optimal for the business und create an amortization Schedule for the same Period 14 Meminina Test Payment Principal Payment principal Pay 17 19 20 22 27 24 Scanned with CamScanner CamScanner 08-12-2021 17.21.p X + --2021%2017.21.pdf CD Page view l A Re 2 Ltd Product and store formation Product Information Store Information Dodatne Product Co Toreto ar 1 SOR 1500 101 New York City 2 Bed 1000 102 Philadelphia Study Tale 250 10 Boston 4 Medina 150 104 Chicago Chaw 50 10 Los Angeles Eine 950 106 San Fransisco 2 TV Stand 200 101 Dallas De 250 TO Sante 9 Book Case HO 109 M 10 Sobne 2.75 110 Salt Lake City This worksheet provides product and store formation for different home future plece This contains two table. The first table Product Information take a look at each products active and cost. The second table, Store information, looks at the stones and the city it's located in 5 Below, so instructions that you will need to complete for the following Nam look up to the city and Product value the sims moutodoc Con the Month Function to the monthnum Thu en tot de made during the mattery and Dec 24 Sales who the pop the monthumber in one unit function to cicate the discount bad on the purchase month the e intercount) the sales Amount discounts And Plus Tallinna worksheets the sales Amoure before and whereby. Proin Scanned with CamScanner ISS TUF GAMING %2017.31.pdf Page view | A Read alc Cavant 10 5 SO LIE ME + 1 1 DE S/300 Cinta Code ch ter LO uc) it GENIE 1 1 OT AL 10 Am 10 TH ET WIRE DIE neok/cle WALL 101 11 WE BE w Under 1 HE Scanned with CamScanner TUF GAMING FD ZE ra G18 D E H Use the appropriate tinunce function to calculate the messing information in the table below. Option Bank Naine Total Yearly Bament 1 62 73 813 Bank Bank Bank Bank D Number of Compounding Annual interest Loan Duration Present Future Periods per year Rate Payment per Period In Years I wlue Valun 12 5 $ (1.564) 75,000 $ 14 6.75% s 5.656 70,000 $ 112 5.005 4 $ (1.658.11 IS 12 3.80 3 $ $5,000 9 30 11 12 3 Choose an option that you think will be optimal for the business und create an amortization Schedule for the same Period 14 Meminina Test Payment Principal Payment principal Pay 17 19 20 22 27 24 Scanned with CamScanner CamScanner 08-12-2021 17.21.p X + --2021%2017.21.pdf CD Page view l A Re 2 Ltd Product and store formation Product Information Store Information Dodatne Product Co Toreto ar 1 SOR 1500 101 New York City 2 Bed 1000 102 Philadelphia Study Tale 250 10 Boston 4 Medina 150 104 Chicago Chaw 50 10 Los Angeles Eine 950 106 San Fransisco 2 TV Stand 200 101 Dallas De 250 TO Sante 9 Book Case HO 109 M 10 Sobne 2.75 110 Salt Lake City This worksheet provides product and store formation for different home future plece This contains two table. The first table Product Information take a look at each products active and cost. The second table, Store information, looks at the stones and the city it's located in 5 Below, so instructions that you will need to complete for the following Nam look up to the city and Product value the sims moutodoc Con the Month Function to the monthnum Thu en tot de made during the mattery and Dec 24 Sales who the pop the monthumber in one unit function to cicate the discount bad on the purchase month the e intercount) the sales Amount discounts And Plus Tallinna worksheets the sales Amoure before and whereby. Proin Scanned with CamScanner ISS TUF GAMING %2017.31.pdf Page view | A Read alc Cavant 10 5 SO LIE ME + 1 1 DE S/300 Cinta Code ch ter LO uc) it GENIE 1 1 OT AL 10 Am 10 TH ET WIRE DIE neok/cle WALL 101 11 WE BE w Under 1 HE Scanned with CamScanner TUF GAMING FD ZE ra