Question

4: Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this period”, and “Total”. As depicted below. A B D E 1 2 Timestep in years Rate <enter timestep> <enter your rate> 3 4 5 6 Count 0 Date 30-Sep-16 Interest this period Total $ <enter your total> 7 8 1 9 10 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 $37,000 CAD. Above the columns, put the label "rate", and in the cell below that, enter your periodically compounding rate of 10%. 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 82?

Answer 1

(a) The date at count 100 is 24- Sep-2041

(b) Interest earned for the period with count 82 is $ 6835.57

Below is Spreadsheet

Count	Date	Interest in this Period	Total
0	30-Sep-16	$                                       -	$     37,000.00
1	30-Dec-16	$                             925.00	$     37,925.00
2	31-Mar-17	$                             948.13	$     38,873.13
3	30-Jun-17	$                             971.83	$     39,844.95
4	30-Sep-17	$                             996.12	$     40,841.08
5	30-Dec-17	$                          1,021.03	$     41,862.10
6	31-Mar-18	$                          1,046.55	$     42,908.66
7	30-Jun-18	$                          1,072.72	$     43,981.37
8	30-Sep-18	$                          1,099.53	$     45,080.91
9	30-Dec-18	$                          1,127.02	$     46,207.93
10	31-Mar-19	$                          1,155.20	$     47,363.13
11	30-Jun-19	$                          1,184.08	$     48,547.21
12	30-Sep-19	$                          1,213.68	$     49,760.89
13	30-Dec-19	$                          1,244.02	$     51,004.91
14	30-Mar-20	$                          1,275.12	$     52,280.03
15	29-Jun-20	$                          1,307.00	$     53,587.03
16	29-Sep-20	$                          1,339.68	$     54,926.71
17	29-Dec-20	$                          1,373.17	$     56,299.88
18	30-Mar-21	$                          1,407.50	$     57,707.37
19	29-Jun-21	$                          1,442.68	$     59,150.06
20	29-Sep-21	$                          1,478.75	$     60,628.81
21	29-Dec-21	$                          1,515.72	$     62,144.53
22	30-Mar-22	$                          1,553.61	$     63,698.14
23	29-Jun-22	$                          1,592.45	$     65,290.60
24	29-Sep-22	$                          1,632.26	$     66,922.86
25	29-Dec-22	$                          1,673.07	$     68,595.93
26	30-Mar-23	$                          1,714.90	$     70,310.83
27	29-Jun-23	$                          1,757.77	$     72,068.60
28	29-Sep-23	$                          1,801.72	$     73,870.32
29	29-Dec-23	$                          1,846.76	$     75,717.07
30	29-Mar-24	$                          1,892.93	$     77,610.00
31	28-Jun-24	$                          1,940.25	$     79,550.25
32	28-Sep-24	$                          1,988.76	$     81,539.01
33	28-Dec-24	$                          2,038.48	$     83,577.48
34	29-Mar-25	$                          2,089.44	$     85,666.92
35	28-Jun-25	$                          2,141.67	$     87,808.59
36	28-Sep-25	$                          2,195.21	$     90,003.81
37	28-Dec-25	$                          2,250.10	$     92,253.90
38	29-Mar-26	$                          2,306.35	$     94,560.25
39	28-Jun-26	$                          2,364.01	$     96,924.26
40	28-Sep-26	$                          2,423.11	$     99,347.36
41	28-Dec-26	$                          2,483.68	$   101,831.05
42	29-Mar-27	$                          2,545.78	$   104,376.82
43	28-Jun-27	$                          2,609.42	$   106,986.24
44	28-Sep-27	$                          2,674.66	$   109,660.90
45	28-Dec-27	$                          2,741.52	$   112,402.42
46	28-Mar-28	$                          2,810.06	$   115,212.48
47	27-Jun-28	$                          2,880.31	$   118,092.79
48	27-Sep-28	$                          2,952.32	$   121,045.11
49	27-Dec-28	$                          3,026.13	$   124,071.24
50	28-Mar-29	$                          3,101.78	$   127,173.02
51	27-Jun-29	$                          3,179.33	$   130,352.35
52	27-Sep-29	$                          3,258.81	$   133,611.16
53	27-Dec-29	$                          3,340.28	$   136,951.44
54	28-Mar-30	$                          3,423.79	$   140,375.22
55	27-Jun-30	$                          3,509.38	$   143,884.60
56	27-Sep-30	$                          3,597.12	$   147,481.72
57	27-Dec-30	$                          3,687.04	$   151,168.76
58	28-Mar-31	$                          3,779.22	$   154,947.98
59	27-Jun-31	$                          3,873.70	$   158,821.68
60	27-Sep-31	$                          3,970.54	$   162,792.22
61	27-Dec-31	$                          4,069.81	$   166,862.03
62	27-Mar-32	$                          4,171.55	$   171,033.58
63	26-Jun-32	$                          4,275.84	$   175,309.42
64	26-Sep-32	$                          4,382.74	$   179,692.15
65	26-Dec-32	$                          4,492.30	$   184,184.46
66	27-Mar-33	$                          4,604.61	$   188,789.07
67	26-Jun-33	$                          4,719.73	$   193,508.79
68	26-Sep-33	$                          4,837.72	$   198,346.51
69	26-Dec-33	$                          4,958.66	$   203,305.18
70	27-Mar-34	$                          5,082.63	$   208,387.81
71	26-Jun-34	$                          5,209.70	$   213,597.50
72	26-Sep-34	$                          5,339.94	$   218,937.44
73	26-Dec-34	$                          5,473.44	$   224,410.87
74	27-Mar-35	$                          5,610.27	$   230,021.15
75	26-Jun-35	$                          5,750.53	$   235,771.67
76	26-Sep-35	$                          5,894.29	$   241,665.97
77	26-Dec-35	$                          6,041.65	$   247,707.62
78	26-Mar-36	$                          6,192.69	$   253,900.31
79	25-Jun-36	$                          6,347.51	$   260,247.81
80	25-Sep-36	$                          6,506.20	$   266,754.01
81	25-Dec-36	$                          6,668.85	$   273,422.86
82	26-Mar-37	$                          6,835.57	$   280,258.43
83< Add a comment Know the answer? Add Answer to: 4: Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this period”, and... Your Answer: Post as a guest Your Name: What's your source? Earn Coins Coins can be redeemed for fabulous gifts. Log In Sign Up Post as anonymous Post Your Answer Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free. Similar Homework Help Questions Excel is allowed! For this lab, we will create a spreadsheet that allows somebody to type... Excel is allowed! For this lab, we will create a spreadsheet that allows somebody to type in a loan amount, interest rate, and length of the loan in years. The spreadsheet will then calculate the monthly payment required and the actual amount paid on the loan. First, setup your spreadsheet: • In Cell A1, put the label Loan Amount:. The corresponding value would be input in Cell B1. • In Cell A2, put the label Interest Rate:. The corresponding value... Suggest form 1. Open a new Excel Spreadsheet. 2. Create a bold-faced heading for your spreadsheet... Suggest form 1. Open a new Excel Spreadsheet. 2. Create a bold-faced heading for your spreadsheet that contains the following: a. Excel Exercise 2 b. Qantas Accounts receivable c. Today's date Hint: Todays date function in Excel is =TODAY() 3. Two rows down from your heading, create a row containing the following column headings: a. Customer ID b. Customer name c. Beginning balance d. Sales e. Collections f. Ending balance 4. Enter the data from the scenario into the spreadsheet.... Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked... Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "" in column C such that formula could be copied and pasted into columns D, and E using Microsoft Excel without further editing, There is no need to explicitly write the Excel formula for cells marked with "Copy & paste". Label each formula clearly with cell reference position. In many country towns of China, there is no western coffee shop such as Starbucks... A Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of the 4-year 8%... A Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of the 4-year 8% semiannual coupon bond, YTM=10%. B. Verify your solution of part A) using spreadsheet 3.3. Hint: You can put any settlement date and maturity date as long as the maturity matches the question. C. Modify the spreadsheet 3.1 of "Duration Spreadsheet" to calculate the duration of the 4-year 8% annual coupon bond, YTM=10%. D. Verify your solution of part C) using spreadsheet 3.3. E. Assume... Create an excel worksheet and populate it, in columns, with values of X that are -2,... Create an excel worksheet and populate it, in columns, with values of X that are -2, -1, 0, 1, 2 and values of Y that are -1, 1,1,1,3. As an aside, note that the sample mean of X is 0. Create the columns shown below, and enter the proper formulas into excel. (X minus (X minus mean) Mean) times (Y Y Y-mean X X-mean squared minus mean) Y-hat u-hat -1 -2 1 -1 1 0 1 1 3 2 sum... This worksheet will compute the monthly value of an amortized loan for 36 months. This will... This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and the worksheet will automatically update. Within the worksheet there will be some absolute cell referencing that is needed and some relative cell referencing that is needed. You will need to determine which is appropriate. Title the worksheet "Amortization of Car Loan" in cell A1. Leave... 8. What are the adusn Due: November 4, 2019 1. EXCEL Spreadsheet: a. You must use... 8. What are the adusn Due: November 4, 2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to calculate your answers. b. All calculations must be done in Excel. Do not calculate anything on your calculator and just enter the number into Excel (if you do this, you will not receive credit for this assignment). Do the calculation within the cell. c You must reference cells from your base case. (Only input variables that change for... I just need the excel formula of C27 to C66 Question 1 (40 marks) Refer to... I just need the excel formula of C27 to C66 Question 1 (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with “?” in column C such that formula could be copied and pasted into columns D, and E using Microsoft Excel without further editing. There is no need to explicitly write the Excel formula for cells marked with “Copy & paste”. Label each formula clearly with cell reference position. In many country towns of... Problem #5: You will be making monthly deposits of increasing size into a bank account for... Problem #5: You will be making monthly deposits of increasing size into a bank account for 5 years. The account will earn continuously compounding interest each month. Every 3 months (i.e. every quarter) the interest rate will increase. The initial deposit will be $227. At the beginning of each month thereafter, another deposit will be made increasing by size $30. The continuously compounded interest rate will be 4.44% per annum for the first quarter, but will then increase by 0.4%... Part A: Create pro forma financial statements. This spreadsheet is set up so that green cells... Part A: Create pro forma financial statements. This spreadsheet is set up so that green cells contain numbers and white cells contain formulas. Follow the steps below to prepare proformas for 2015, assuming that New England Corp. will make up any funding shortfall with long-term debt, and will use any funding surplus to pay down long-term debt (i.e., let long-term debt be the plug figure). 1. As a starting point, assume that sales growth in 2015 will be equal to... ADVERTISEMENT Free Homework Help App Download From Google Play Scan Your Homework to Get Instant Free Answers Need Online Homework Help? Ask a Question Get Answers For Free Most questions answered within 3 hours. ADVERTISEMENT Share Your Knowledge Post an Article +5 Coins Post an Answer +5 Coins Post a Question with Answer +5 Coins ADVERTISEMENT Active Questions Hydrobromic acid dissolves solid iron according to the followiaung reaction: Fe(s)+2HBr(aq)→ FeBr2(aq)+ H2(g) Part A. What... asked 1 hour ago Verify the following vector identity in SPHERICAL COORDINATES. div(curl(A)) = 0 asked 2 hours ago The work function (Φ) for a metal is 7.50×10-19 J. What is the longest wavelength (nm)... asked 3 hours ago 1. Would the following procedural changes cause the calculated mass percent Ni2+ ion in Ni(NH3)nCl2 to... asked 5 hours ago 1. Why does the voltage of the capacitor vary with frequency? where does this missing voltage... asked 6 hours ago p p please write each step out clearly 3. A manager of a company is considering... asked 5 hours ago On October 1, Ebony Ernst organized Ernst Consulting; on October 3, the owner contributed $83,540 in... asked 6 hours ago A.)As an electron moves through a region of space, its speed decreases from 9.60 × 106... asked 6 hours ago In java with the netbeans program do: Through object programming Create a class "ContadorP", which is... asked 6 hours ago Pattern Corporation acquired all of Science Company's outstanding stock on January 1, 2016 for $600,000 cash.... asked 6 hours ago Here are all accounts Tyler Co. maintains. Tax expenses $4,750 Common stocks $48,840 SG&A expenses $2,500... asked 7 hours ago Lis out the types and equation of wind profile and the respective variables in the fds... asked 7 hours ago ADVERTISEMENT DMCA About Contact Terms of Use Privacy Policy Academic Honesty Policy Homework Answer Scanner App © 2013-2022 ZuoTi.Pro user contributions licensed under cc by-sa 4.0