Question: Please solve the following questions using EXCEL FILE! Please! 1. Compute the future value of 1000 when it is compounded at 5% annually (once a

 Please solve the following questions using EXCEL FILE! Please! 1. Compute

the future value of 1000 when it is compounded at 5% annually

(once a year) for the following number of years. \begin{tabular}{c|c} \hline number

Please solve the following questions using EXCEL FILE! Please!

1. Compute the future value of 1000 when it is compounded at 5% annually (once a year) for the following number of years. \begin{tabular}{c|c} \hline number of years for & future value of 1000 \\ compounding & \\ \hline 1 & \\ \hline 2 & \\ 3 \\ 4 & \\ 5 & \\ 10 \\ 20 & \\ 30 & \\ 40 & \\ 50 & \\ 60 & \\ 70 & \\ 80 & \\ 90 & \\ 100 & \\ \hline \end{tabular} Using your work in \#1, create a graph (x-y scatter plot) showing the relationship between the two (i.e., number of years for compounding and future value). Create your graph here 3. Compute the future value of 1000 when it earns 5% annually (once a year) WITHOUT COMPOUNDING -- called SIMPLE INTEREST S-for the following number of years. number of years future value for compounding of 1000 12345102030405060708090100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!