For each of the scenarios, add the required information in the blank cells. Using the proper formula, determine the answer for the blue-shaded cells. USE CELL REFERENCES, not numbers! Karl wants to purchase a car and is analyzing his financial situation before he visits any dealers. Scenario 1: Loan amount would be $20,000 for a period of 5 years. Payments are due monthly. Interest rate is 4.65% yearly. What would be his monthly payment? Scenario 2: If Karl could only afford a monthly payment of $300, how much of a loan would he get for that payment amount? Scenario 3: What interest rate would Karl need in order to get a $20,000 loan with the same terms and a payment of $300 ? (Hint: the RATE function returns the rate per period) For each of the scenarios, add the required information in the blank cells. Using the proper formula, determine the answer for the blue-shaded cells. USE CELL REFERENCES, not numbers! Karl wants to purchase a car and is analyzing his financial situation before he visits any dealers. Scenario 1: Loan amount would be $20,000 for a period of 5 years. Payments are due monthly. Interest rate is 4.65% yearly. What would be his monthly payment? Scenario 2: If Karl could only afford a monthly payment of $300, how much of a loan would he get for that payment amount? Scenario 3: What interest rate would Karl need in order to get a $20,000 loan with the same terms and a payment of $300 ? (Hint: the RATE function returns the rate per period)