Part I:

Assume you can put Annual Savings of $X at the end of each year for N years, at the annual interest rate of R (X, R and N are given in the Given Data Sheet).

Please build a worksheet to show your cumulative savings at the end of each year till the end of N years.

Part II:

Assume you can put savings at the end of each year for N years, at the annual interest rate of R. The first-year savings is $X, then your savings will increase by $100 each year till year N. For example, if your first-year savings is $1000, your second year savings will be $1100, third year $1200 and so on. (X, R and N are given in the Given Data Sheet).

Please build a worksheet to show your cumulative savings at the end of each year till the end of N years.

Part III:

Assume you can put savings at the end of each year for N years. The first-year savings is $X, then your savings will increase by $100 each year till year N. The first-year interest rate is R, then each year, interest rate will increase by 0.1% till year N. That is, if your first-year interest rate is 3%, second year interest rate is 3.1%, third year is 3.2% and so on. (X, R and N are given in the Given Data Sheet).

Please build a worksheet to show your cumulative savings at the end of each year till the end of N years.

Alignment