A 5 Calculating APR - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri 11 AA Paste BIU- ER % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard Font A A1 > B D E F G H 1 1 2 3 4 Find the APR, or stated rate, in each of the following cases: S Complete the following analysis. Do not hard code values in your calculations. 6 7 8 9 Times compounded Stated rate (APR) per year 2 12 52 Effective rate (EAR) 12.40% 11.70% 9.50% 10 12 13 14 35