Compound interest is given as A = P (1 + i)" where A is the amount (future value) at the end of n periods, P is the principal (present value), i is the interest rate per compounding period, and n is the number of compounding periods. A newborn child receives a $15,550 gift toward college from her grandparents. If the money is invested at 8% compounded monthly, create a macro to find the future value in 15 years by using the equation given above. Name the macro NCFV (Keyboard shortcut: Ctrl + r). Create a second macro to find the total interest that will be paid over 15 years. Name the macro NCNT (Keyboard shortcut: Ctrl + t). Use NCFV and NCNT to find the future value and the total interest for 17 years, 19 years, 21 years, and 23 years. Your solution should clearly show the macros.

Compound interest is given as A = P (1 + i)" where A is the amount (future value) at the end of n periods, P is the principal (present value), i is the interest rate per compounding period, and n is the number of compounding periods. A newborn child receives a $15,550 gift toward college from her grandparents. If the money is invested at 8% compounded monthly, create a macro to find the future value in 15 years by using the equation given above. Name the macro NCFV (Keyboard shortcut: Ctrl + r). Create a second macro to find the total interest that will be paid over 15 years. Name the macro NCNT (Keyboard shortcut: Ctrl + t). Use NCFV and NCNT to find the future value and the total interest for 17 years, 19 years, 21 years, and 23 years. Your solution should clearly show the macros.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 8RA

See similar textbooks

Similar questions

4. Suppose a company has employee annual salary data as follows. - For the interval $\$ 1$ to $\$ 25,000,5$ employees; for the interval $\$ 25,001$ to $\$ 50,000,15$ employecs; for the interval $\$ 50,001$ to $\$ 75,000, 25$ cmployees; - for the interval $\$ 75,001s to $\$ 100,000,25$ employecs; - for the interval $\$ 100, 001$ to $\$ 125,000, 35$ employees; - and for the interval $\$ 125,001$ to $\$ 150,000,30$ employees. (a) Which direction, if any, is this data skcwed? [Hint: Draw a graph of the distribution. Sec if that gives you an insight.] (b) Which is likely larger for this dataset, the mean or the median? S.P.PB. 251
A matrix for rugby results shows the number of conversions, drop goals and penalties for three teams A, B and C over a period of one rugby season. C DG P A (11 5 8 в 13 с \10 3 2 7. The points awarded were: 3 for a conversion, 5 for a drop goal and 2 for a penalty. Calculate, in matrix form, the points scored by each team and hence place the teams in 1st, 2nd, 3rd places for the season.
4. Read the marks of a student for 3 courses. Calculate the average marks for the student. Check the average with the below table and calculate the CGPA according to the formula and display the CGPA of the student. [CGPA=(Average * Grade point)]. Average Grade point 8-10 6-7.9 4.5-5.9 <4 Activate W Go to Setino rch 432 立
Using the “Quarterly Revenue – 2018” worksheet provides the relevant formulas to complete the worksheet. Apply appropriate formatting. In the same worksheet in part (c) dynamically apply the following formats for Qtr1and Qtr4 for all related revenue types:i. Values over $140,000 should be yellow. [2]ii. Values under or equals to $80,000 should be read and bolded Thom-Pierre Consultants (TPC) Quarterly Schedule of Revenue For the year December 31, 2018 QTR1 QTR2 QTR3 QTR4 2018 Sales 290000 320000 320000 490000 Interest 102500 175000 180000 54000 Investment Income 13000 9500 10000 20000 Other 16000 25000 19500 29000 Total
4) You are asked to calculate the weekly take home pay for a group of employees at your company (for each Employee ID). The employees in this group have a wage rate of 35 ÚSD per hour and 65 USD per hour when they work overtime. The following table list the hours work by the employees. Employee ID Regular hours Overtime hours 87 40 3 43 40 8. 99 32 40 15
c) Consider the following schedule S: S = R1(A); R2(A); R3(B); W3(B); W1(A); R2(C); R2(B); W2(B); W1(C) i) Transform the schedule S into a table form/tabular form.
Show the expanded code produced by the following statement that invokes the mReadString macro from Section 10.2.5:mReadStr customerName
1) Holiday Inn hires you to examine three hotel locations that can each use some updating. They have $4 million available for the updates. The future revenue projected for each hotel is tied to how much renovation is done, according to the following table: Renovation Amount Future Revenue (in millions) (in millions) $0 $1 $2 $3 Hotel A Hotel B Hotel C $4 $7 $8 $9 $3 $6 $10 $12 $14 $3 $7 $8 $13 $4 $11 $15 Use dynamic programming to determine how to best allocate the $4 million in renovations between the three hotels (assume you can only use $1 million increments).
The Claremont School course catalogue reads as follows: “To enrol in CIS 288, which is an advanced course, a student must complete with two prerequisites – CIS 110 and CIS 286. A student who completes either one of these prerequisites and obtains the instructor’s permission, however, will be allowed to take CIS 288”-Create a decision table that describes the Claremont School course catalogue regarding eligibility for CIS 288. Show all possible rules.-Draw a simplified decision tree to represent the Claremont School catalogue. Describe the results.
Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel Street City- Country: Durban, South Africa ProductNo A 123 B 234 C 345 Description A4 Paper Order Form Toner Staples Normal Form Quantity 100 200 1000 Date: 25/12/2020 Unit Price R1.00 R150.00 R5.00 1.1 Using normalization principles, depict the ONF, 1NF, 2nd NF and 3rd NF of the data above. Example: Below is an example of the table information converted to zero normal form, read chapter five in your module guide and convert the table to first, second and third normal form. The format of your answer must be as depicted below: • ORDER( order number, customer number, name, address, order date(product number, description, quantity, unit price))
I need help creating a function that creates an amoritization schedule for a loan.
You are given a list of courses that are currently available in Oxford College that looks like the following: courses = ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510']. All courses till 400 level (499) are for the undergraduate students whereas any courses above 500 are for the graduate or masters students. Write a python program that creates a dictionary from the above list where the keys will be each department name (CSE,EEE,MAT for the above example) and their values will be a dictionary of two keys - Undergraduate Courses and Graduate Courses. Each key will have courses that fall in Undergraduate and Graduate level respectively. Sample Input - No need to take input ['CSE110','CSE111','MAT620','CSE520','EEE361','CSE650','MAT510'] Sample Output: (You just have to print the resultant dictionary. No need to follow the pattern below) { 'CSE':{ 'Undergraduate':['CSE110','CSE111'], 'Graduate':['CSE520','CSE650'] },…