You are responsible for managing your company’s $1,000,000 worth of short-term investments over the next four years, and you know that the compounding frequency is quite important. Use Excel to calculate the future value of your short-term investments in four years based on a 6% nominal annual rate of return with annual, semiannual, monthly, and daily compounding frequencies.