Working with Financial Tools and Functions & Performing What If Analysis Alfred is a new Taxi driver. He aims to buy his car with the help of ABCY bank. The original value of the car is SAR 120,000. The bank applies the yearly interest percentage of 7.9%. The loan is to be reimbursed in 5 years. Based on the data provided above, complete the installments worksheet in the provided workbook as follows: Go to Installments worksheet and Fill in B3 with the present value (amount 1 borrowed). 2 Fill in B4 with the period in months. 3 Fill in B5 with the monthly rate. In B6, use a financial function to calculate the monthly payment that would Alfred pay each month. 4 Hint: Use PMT function 5 Fill in the monthly amortization schedule. Fill in the cumulative Interest and Principal Payments table. Use the needed 6 financial functions (CUMIPMT and CUMPRINC). Help Alfred who wants to try different scenarios before deciding and agreeing to sign. Using data tables (What-if-Analysis), fill in the table (H18) when the payment 7 period changes from 6 to 9 years. You will have to fill in the "Monthly Installments" row Car Installment Prilor Amount herred Period Rate Payment med monthly Monty PMT Interest Principal Ending Balance Monthly Amortization Schedule Maari Berlin ! 2 3 4 5 6 2 Give Interest & Principal Year 1 Year 1 Veur 1 13 15 Months 12 24 16 Cumulative interest Cumulative Principal Principal Reminin Year 4 37 4N Years 49 60 Data Table 5 60 1 Number of years Number of the Menthly installment 8 6 72 9 10 11 12 13 14 IS 9 TON