Case Study- 1: Showcase Scheduling at Fred Astaire East Side Dance Studio

. Case Study- 2: Spreadsheet Model Helps Assign Medical Residents Fletcher Allen Health Care (FAHC)

Based on the above case studies discussion complete the following tasks in class or home given exercise:

1. Using Microsoft excel design a car loan calculator based on the following conditions:
   1. Define at least 5 different cars with different prices
   2. User may select car and related price should appear automatically in the next cell.
   3. Financing amount can be 50% to 100%
   4. Interest rate is fixed 5% on the financing amount.
   5. Use can opt the installment duration from 12 months to 60 months.

Calculate and display the monthly installment based on the number of months opted by the user and financing amount + interest rate