IJ L M A B D E F G H 1 QUIZ WEDNESDAY SEPT 30, 2020 Problem #2: SCENARIO MANAGER 2 3 1. USE THE FOLLOWING 3 SCENARIOS IN SCENARIO MANAGER, TO CALCULATE MONTHLY PAYMENT IN EACH CASE 4 2. OBTAIN AND DISPLAY A SUMMARY TABLE, SHOWING FINAL RESULTS FOR ALL 3 SCENARIOS 5 SCENARIOS 6 Scenario A Scenario Scenario C PARAMETERS 7 Principal (Loan Amount) A 34500 53800 71200 Annual rate 9% 8 Annual Rate 5% 4% 3% Principal $30,000.00 9 # of Years n 10 9 6 6 Number of Years 4 10 11 Monthly Payment P is given by the formula A*(r/12) CALCULATIONS 12 1 Numerator $225.00 13 {1 (12n) Denominator $0.30 14 12 Monthly Payment $746.55 15 r 7. 16 17 18