Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a table on a spreadsheet with columns labelled Count, Date, Interest this Period, and Total. As depicted below. You will begin with the count

Create a table on a spreadsheet with columns labelled Count, Date, Interest this Period, and Total. As depicted below. 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 $39,000 CAD. Above the columns, put the label rate, and in the cell below that, enter your periodically compounding rate of 20%. Put the label Timestep in years and in the cell below that, enter =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. Dont 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 72?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Solitary Auditor

Authors: Michael Knapp

1st Edition

161163878X, 978-1611638783

More Books

Students also viewed these Accounting questions

Question

=+What's the purpose of the piece?

Answered: 1 week ago

Question

=+What benefits are there in direct mail?

Answered: 1 week ago

Question

=+How will this product help them?

Answered: 1 week ago