Homework Answers
(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<
Know the answer?
Add Answer to:
|
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 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 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% 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...
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 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 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 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...