Question

Question 15 Find the future value of a five-year $115,000 investment that pays 8.50 percent and that has the following compounding periods: (Do not round Intermediate calculations, round final answers to 2 decimal places, e.g. 15.25.) Excel Template (Note: This template Includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Value of investment after 5 years a. Quarterly b. Monthly 6. Daily d. Continuous Click if you would like to show Work for this question s on

Answer 1

Hi

The formula are explained in the second image

1 Investment 2 Return 3 Years $115,000.00 8.50% 5 Quarterly 6 Monthly 7 Daily 8 Continuous $175,121.40 $175,639.57 $175,894.20 $175,902.90

1 Investment 2 Return 3 Years 115000 0.085 4 5 Quarterly 6 Monthly 7 Daily 8 Continuous 9 =B1*((1+B2/4)^(B3*4)) =B1*((1+B2/12)^(B3*12)) =B1*((1+B2/365)^(B3*365)) =B1* (EXP(B2*B3))