Calculate the following using the appropriate functions in Excel.1 please 8. Samir bought a Honda Civic for $17,345. He put down $6,000 and financed the rest through the dealer at an APR of 4.9% for 4 years. What is the effective annual interest rate (EAR) if the loan payments are made monthly (try using the EAR formula 1st, then use EFFECT)? What is his monthly payment? How much total interest will he pay on the loan if he does not pay off the loan early?