loan amount = car price - deposit

= 40,000,000 - (20% of 40,000,000)

she will need to borrow 32,000,000 from bank

You are given the opportunity to borrow $32,000,000 for 60 months at 4% ANNUAL interest:

annual payment $ 7,188,067.63

requirement

change the tenor period to 60 months (5 years) and generate the monthly payment spreadsheet. Make 60 monthly installment payments of interest and principal at the end of each month