Chapter 6 - Discounted Cash Flow Valuation - Excel 01 Saved 2 Calculating EAR - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 % Paste 1 BIU Alignment Number Conditional Format as Cell Cells Editing points Clipboard Font Formatting Table Styles Styles Skipped A1 fx A B C D E F G H 1 eBook 2 3 4 Print 5 Find the EAR in each of the following cases: Complete the following analysis. Do not hard code values in your calculations. 6 References 7 Times compounded 8 Stated rate (APR) per year Effective rate (EAR) 9 7% 4 10 17% 12 11 13% 365 12 13 14 15 DEADY Sheet1 Sign In 400% ^