You will begin with the count at $0,$ and the date of Sept $30,2016.$ For that first row,

the "Interest this period" $$ is zero, and the total is $$14,000$ CAD. Above the columns,

put the label "rate" $,$ and in the cell below that, enter your periodically compounding

rate of $7\%.$ Put the label "Timestep in years" $$ and in the cell below that, enter $=\frac{1}{4}.$

For each subsequent row of the table, use formulas to set the count equal to one more

than the previous count, and set the date equal to the previous date plus ${365}^{**}[$the

value in the timestep cell$].$ The "Interest this Period" $$ is the "Total" $$ from the

previous "Date" $,$ times the "rate" $$ cell, times the "timestep" $$ cell. The "Total'

for each row is the "Total" $$ from the previous row plus the "Interest this period" $.$

Make sure that you use dollar signs for absolute addresses where appropriate in order

to be able to copy these formulas to later rows. Copy that new row, and paste it into

the rows below it so that the count goes to at least $100.$

You can validate your spreadsheet by checking that the total comes out right if the

interest rate and initial total from a previous question is used with a timestep of $1.$

Don't forget to restore the timestep and rate to the values for this problem when done.

$($a$)$ What is the date that Excel shows for the row whose count is $100?($Copy and

paste the content of that cell into the answer box below.$)$

$($b$)$ What is the interest earned for the period with count $63?$

You will begin with the count at $0,$ and the date of Sept $30,2016.$ For that first row,

the "Interest this period" $$ is zero, and the total is $$14,000$ CAD. Above the columns,

put the label "rate" $,$ and in the cell below that, enter your periodically compounding

rate of $7\%.$ Put the label "Timestep in years" $$ and in the cell below that, enter $=\frac{1}{4}.$

For each subsequent row of the table, use formulas to set the count equal to one more

than the previous count, and set the date equal to the previous date plus ${365}^{**}[$the

value in the timestep cell$].$ The "Interest this Period" $$ is the "Total" $$ from the

previous "Date" $,$ times the "rate" $$ cell, times the "timestep" $$ cell. The "Total'

for each row is the "Total" $$ from the previous row plus the "Interest this period" $.$

Make sure that you use dollar signs for absolute addresses where appropriate in order

to be able to copy these formulas to later rows. Copy that new row, and paste it into

the rows below it so that the count goes to at least $100.$

You can validate your spreadsheet by checking that the total comes out right if the

interest rate and initial total from a previous question is used with a timestep of $1.$

Don't forget to restore the timestep and rate to the values for this problem when done.

$($a$)$ What is the date that Excel shows for the row whose count is $100?($Copy and

paste the content of that cell into the answer box below.$)$

$($b$)$ What is the interest earned for the period with count $63?$