2. Complete the sinking fund schedule below for the following. I would like to see your...

Transcribed Image Text:

2. Complete the sinking fund schedule below for the following. I would like to see your payment calculation here, but the other values do not have to be shown. We have briefly looked at this process in Excel. If you would like to verify your answers, you can use Excel for this question. Scenario: $500 will be deposited into an account every quarter with the goal of saving $2500. Interest is earned at k% compounded quarterly. Note: You could find the number of payments first or simply fill in the table until the goal is reached. Payment # Payment Amount Interest Amount Increase Amount Balance 2. Complete the sinking fund schedule below for the following. I would like to see your payment calculation here, but the other values do not have to be shown. We have briefly looked at this process in Excel. If you would like to verify your answers, you can use Excel for this question. Scenario: $500 will be deposited into an account every quarter with the goal of saving $2500. Interest is earned at k% compounded quarterly. Note: You could find the number of payments first or simply fill in the table until the goal is reached. Payment # Payment Amount Interest Amount Increase Amount Balance