USING EXCEL SOLVE: If you take out a bank loan with a 17% quoted nominal interest rate that is co…

USING EXCEL SOLVE: If you take out a bank loan with a 17% quoted nominal interest rate that is compounded semiannually what is the effective annual rate (EAR)? What is the EAR if the loan compounds continuously? explain steps.