Question

In: Finance

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”....

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”. As depicted below.
1    timesteps in years rate.   
2 <enter timestep> <enter your rate>
3 count date interest this period total$
4 0 30-Sep-16 <enter your total>
5 1
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 $22,000 CAD. Above the columns, put the label “rate”, and in the cell below that, enter your periodically compounding rate of 19%. 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. 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 86?

Solutions

Expert Solution

a)

Count Date Interest this period Total
100 9/24/2041 103363.0754 $2,279,428

b)

Count Date Interest this period Total
86 3/26/2038 53977.0294 $1,190,336

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”....
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 $22,000 CAD. Above the columns, put the label “rate”, and in the cell below that, enter your periodically compounding rate of 19%. Put the label “Timestep in years” and in the cell...
Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”....
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...
Which of the following accounts would appear in the Income Statement columns of the end-of-period spreadsheet?...
Which of the following accounts would appear in the Income Statement columns of the end-of-period spreadsheet? Select one: a. Unearned Revenue b. Cash c. Prepaid Insurance d. Net Loss
The following accounts were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following accounts were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30, for Finnegan Co.: Accumulated Depreciation $32,000 Fees Earned 78,000 Depreciation Expense 7,250 Rent Expense 34,000 Prepaid Insurance 6,000 Supplies 400 Supplies Expense 1,800 ​ Prepare an income statement.
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30 for Abigail Company: Accumulated Depreciation $42,400 Prepaid Rent 6,800 Supplies 850 Unearned Fees 7,310 Trucks 49,300 Cash 3,400 Common Stock 2,000 Retained Earnings ? ​ Prepare a classified balance sheet.
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for...
The following data were taken from the Adjusted Trial Balance columns of the end-of-period spreadsheet for April 30 for Abigail Trucking: Accounts Amount Accounts Payable $42,600 Accounts Receivable 83,400 Accumulated Depreciation-Trucks 28,000 Cash ? Common Stock 100,000 Prepaid Insurance 6,500 Prepaid Rent 12,000 Retained Earnings 215,000 Salaries Payable 12,500 Trucks 206,000 Supplies 4,700 Unearned Fees 5,000 Required: Prepare a classified balance sheet. Be sure to complete the statement heading. Refer to the lists of Accounts in the information given, Labels,...
Create a table showing the payment of a mortgage of $239,000 month by month. Create columns...
Create a table showing the payment of a mortgage of $239,000 month by month. Create columns for: - Time (in years) - Interest (for that month) - Payment (always the same value) - Payment against principal - Remaining Principal The mortgage is to last 33 years, and the nominal interest rate is 6.03% (a) What is the monthly payment? (b) What is the interest paid at the end of the 9th month? (c) How much of the principal is paid...
1. Write the statements to create a table named REQUIREMENTS. The table has the following columns:...
1. Write the statements to create a table named REQUIREMENTS. The table has the following columns: credits number (primary key) and degree name. 2. Write the statements to create a table named CANDIDATE with the following columns names. Pick the best column type: student_id, first name, last name, credits and graduation date. The credits column is a foreign key to the credits column in the REQUIREMENTS table. 3. Write the statement(s) to Insert 2 rows in your REQUIREMENTS table. Make...
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving...
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions: You will charge $995 per person for a two-day class. You estimate that 30 people will attend the class, but you should keep an option to change this input. Your fixed costs include $500 total to rent a room for both days, setup fees of $500 for registration, and $300 for designing a postcard for...
Create a table with two columns. Name the table First Initial _ Last Name (e.g. John...
Create a table with two columns. Name the table First Initial _ Last Name (e.g. John Dow will create table j_dow). You have to audit all DML statements on your table. To do this you write two triggers: 1. To log any DML statements that users might run on this table. The results must be stored in the First Initial _ Last Name _ Log table (e.g. John Dow will create table j_dow_log). The table should have unique event ID,...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT