Question: I need step by step TQ Don't copy others answer You place $100 into a fund at the end of each month for 3 years.
I need step by step TQ
Don't copy others answer

You place $100 into a fund at the end of each month for 3 years. The annual nominal interest rate is 2% in the first year, 2.5% in the second year, and 3% in the third year. (a) Using a spreadsheet programme (Excel, WPS or the likes), find the interest and accumulated amount at each compounding period over the three years. Display your results in a table as the one shown below: Interest Accumulated Amount Month Deposit 1 100 100 2 100 ? ? You do not need to include screenshots of your answer here. Submit your spreadsheet. (b) Refer to Example 2.4 of Chapter 2. Use a similar process to find the accumulated value of the fund at the end of the third year. Round your answer to the nearest cent. You place $100 into a fund at the end of each month for 3 years. The annual nominal interest rate is 2% in the first year, 2.5% in the second year, and 3% in the third year. (a) Using a spreadsheet programme (Excel, WPS or the likes), find the interest and accumulated amount at each compounding period over the three years. Display your results in a table as the one shown below: Interest Accumulated Amount Month Deposit 1 100 100 2 100 ? ? You do not need to include screenshots of your answer here. Submit your spreadsheet. (b) Refer to Example 2.4 of Chapter 2. Use a similar process to find the accumulated value of the fund at the end of the third year. Round your answer to the nearest cent
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
