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 agoRelated 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
ADVERTISEMENT
Latest Questions
- Case Study: Personal Beliefs in the Workplace Don Shakow was a prominent professional who worked in...
- 1: Competency framework usage is the modern best practice in management. What is meant by competency...
- A 19.34 g mixture of sugar (C12H22O11) and table salt (NaCl) is dissolved in 231 g...
- Young and Company claims that its pressurized diving bell will, on average, maintain its integrity to...
- 1) Alternative compiled code sequence using instructions in classes A, B, C. What is the average...
- An asset is purchased on January 1 for $48,700. It is expected to have a useful...
- Do we have any online or offline tool to convert c and cpp programs into MIPS...
ADVERTISEMENT