1. Calculate the Annual rate of return. * . ? 1 - Solving for Rates - Excel FORMULAS DATA FILE HOME INSERT PAGE LAYOUT REVIEW VIEW Sign In Arial -12 A A Paste BIU- % Alignment Number Conditional Format as Cell Formatting Table - Styles Styles Cells Editing Clipboard Font C4 V fx What annual rate of return is earned on a $5,000 investment when it grows to A B D E H What annual rate of return is earned on a $5,000 investment when it grows to $10,750 in six years? (Do not round intermediate calculations and round your final answer to 2 decimal places.) 5 6 7 8 000 Present value Future value Number of periods $ 5,000 $ 10,750 6 9 10 11 12 Complete the following analysis. Do not hard code values in your calculations. 13 14 15 Annual rate of return 16 17 18 19 4 Sheet1 . READY FH --+ 100%