BSc Calculating the number of periods - Excel ? ES 5 FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri - 11 M Paste BIU Cells Editing | A A % . Alignment Number Conditional Format as Cell Formatting Table Styles Styles f Clipboard Font A1 B D E F G H 2 1 2 3 4 Solve for the unknown number of years in each of the following: 5 5 Complete the following analysis. Do not hard code values in your calculations. Years a 10 Present value $ 560 $ 810 $ 18,400 $ 21,500 Interest rate 6% $ 9% $ 11% $ 13% $ Future value 1,389 1,821 289,715 430,258 11 12 13 14 15