PLS do it on Excel

PLS do it on Excel

Excel Project: Accumulation Functions Assuming $1 is invested at t-0, calculate the accumulated value at time t, A(t), fort -0-40 for the following functions: 1.1. Simple Interest of 4% 1.2. Simple Interest of 8% 1.3. Compound interest of 4% 1.4. compound interest of 8% 1. 2. 2.1. Graph A(t) for each of the functions in Part 1 2.2. What type of mathematical graph is each of these functions 3. How would the graphs in Part 2 change if $500 is invested att O instead of $1? 4. Use an effective rate of interest of 4% for the following: 4.1. Calculate the equivalent effective rate of discount 4.2. Using the effective rate of discount from part 4.1 calculate the amount at time t, A(t), fort-040 assuming $1 is invested 4.3. Graph A(t) 4.4. Compare and contrast the graph from 4.3 to the graph from 13 Use an effective rate of interest of 4% for the following: 5.1. Calculate an equivalent nominal rate of interest (choose your own compounding 5. period) 5.2. Using the equivalent nominal rate of interest from part 5.1 calculate the amount at time t, A(t), fort-040 assuming $1 is invested 5.3. Graph A(t) 5.4. Compare and contrast the graph from 5.3 to the graph from 1.3 and 4.3