please solve it in excel !

den aste BIU- B-A Alignment Number Cells Editing Conditional Format as Cell Formatting" Table Styles Styles lipboard Font A B D E F G H 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? Complete the following analysis. Do not hard code values in your calculations. Effective rate (EAR) First National Bank First United Bank Times compounded per year 12 2 Stated rate (APR) 12.4% 12.7%