1. Calculate the Annual rate of return. Solving for Rates - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Connections 22 Clear H Properties From From From From Other Access Web Text Sources Existing Connections Refresh All- A Sort Reapply Filter Edit Links Advanced Data Tools Outline Get External Data Connections Sort & Filter v fx A1 A B 123 st 7 8 56900 9 10 11 12 13 14 15 C D E F G H 1 J 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.) Present value Future value Number of periods $ 5,000 $ 10,750 6 Complete the following analysis. Do not hard code values in your calculations. Annual rate of return