in formula please

1. Calculate the loan's effective annual rate (EAR). ? X B . . FILE HOME BX - Sign In INSERT Effective Annual Rate - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW " AA = % . . A Alignment Number Conditional Format as Cell Formatting Table Styles Paste BIU B Cells Editing Clipboard Styles A loan is offered with monthly payments and a 9.00 percent APR. What's the loan's effective annual rate (EAR)? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Payments per year APR 12 9.00% Complete the following analysis. Do not hard code values in your calculations EAR