Please Enter Answers as a formula

XD H 5 Calculating EAR - Excel ? - 6 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 I Paste BIU % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A1 fie A 00 D E F G H 1 2 3 First National Bank charges 12.4 percent compounded monthly on its business loans. First United Bank charges 12.7 percent compounded semiannually. As a potential borrower, which bank would you go to for a new loan? 4 5 Complete the following analysis. Do not hard code values in your calculations. 6 7 8 Times compounded per year Effective rate (EAR) D Stated rate (APR) 12.4% 12.7% First National Bank First United Bank 12 10 2 11 12 13 14 Sheet1 E E + 100% READY Attempt(s) Hint Show Me