Problem 1: The monthly payment M of a loan amount P for y years and with interest rate r can be calculated by the formula: P(r/12) M = 1-(1+r/12)-12y Calculate the monthly payment and the total payment for a $100,000 loan for 10, 11, 12, ..., 29, 30 years with an interest rate of 4.85%. Display the results in a three-column table where the first column is the number of years, the sec- ond is the monthly payment, and the third is the total payment.

Problem 1: The monthly payment M of a loan amount P for y years and with interest rate r can be calculated by the formula: P(r/12) M = 1-(1+r/12)-12y Calculate the monthly payment and the total payment for a $100,000 loan for 10, 11, 12, ..., 29, 30 years with an interest rate of 4.85%. Display the results in a three-column table where the first column is the number of years, the sec- ond is the monthly payment, and the third is the total payment.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter6: Updating Data

Section: Chapter Questions

Problem 4SCG

See similar textbooks

Similar questions

The monthly payment M of a loan amount P for y years and with interest rate r can be calculated by the formula: P(r/12) M = 1-(1+r/12)-12y Calculate the monthly payment and the total payment for a $100,000 loan for 10, 11, 12, ..., 29, 30 years with an interest rate of 4.85%. Display the results in a three-column table where the first column is the number of years, the sec- ond is the monthly payment, and the third is the total payment.
Assignment 2. ELECTRICITY BILL CALCULATOR FOR DOMESTIC DWELLING Electrical Unit Tariff blocks Unit RM Fixed Charge First Unit Slab Next Unit 200 0.218 200 RM Slab 100 0.334 Surcharge 0.00 RM/Unit Next Unit Slab 300 0.516 Tax.Charge 6 % Next Unit Slab 300 0.546 Meter Charge 200 RM Last Unit Slab 100 0.571 ITEM RATINGS NUMBER no. hours/day unit consumed in kwh LED 8 16 CFL 20W 5 16 REF 200W 1 24 FAN 80W 6 24 total meter reading for a month 190 Monthly Bill 540 final bill 1 Calculate the electricity bill as per the table given 2 nested if formula has to be used to apply various conditions for all tariff blocks 3 for two tariff blocks formula is already applied so you have to do for the remaining tariff block IF(F18<=100,F18*2.7,(100*2.7)+(F18-100)*3)
Table (A): Income tax rates assessment year 2020 Chargeable Income (101) Calculation (RM) Rate % 'lax (101) 0 — 5,000 On the First 5,000 0 0 5,001 — 20,000 On the First 5,000Next 15,000 0150 20,001 — 35,000 On the First 20,000Next 15,000 150450 35,001 — 50,000 On the First 35,000Next 15,000 8 6001,200 Write a complete C program to prompt the user to enter the total chargeable income (RM), and then calculate the tax based on the calculation given in Table (A). Requirements: - Apply one return value function, include parameter list if necessary - Apply one non-return value function, include parameter list if necessary - If user enter chargeable income that is out of range (refer to Table (A)), display an error message and ask user to re-enter the chargeable income. - Repeat the program for 3 times.
It is possible to differentiate scalar functions, aggregate functions, and table-valued functions.
A real estate agency pays a sales representative monthly minimum income of 1000, 54 TL, additional allowance according to his/her title, plus 200 TL for each property sold by the sales representative in that month and a certain amount of the sales amount. Additional allowance amounts by title and bonus rates are given in the tables below: Title Additional Allowance (TL) Trainee (1) Beginner (2) 250 350 Expert (3) 500 Senior (4) 750 Sales Amount (TL) Bonus Rate (%) 0- 499.999,99 0.25 500.000- 999.999,99 0.5 1.000.000- 1.999.999,99 0.75 2.000.000-... 1 By adhering the rules stated above, find the total salary amount of a sales representative for a particular month, by obtaining the title of a sales representative from the user (1 for the trainee, 2 for the novice, 3 for the specialist, 4 for the senior), the number of real estate sold this month and the total sales amount made by the sales representative. Write a MATLAB code that prints the total salary on the screen using the…
A real estate agency pays a sales representative monthly minimum income of 1000, 54 TL, additional allowance according to his/her title, plus 200 TL for each property sold by the sales representative in that month and a certain amount of the sales amount. Additional allowance amounts by title and bonus rates are given in the tables below: Title Additional Allowance (TL) Trainee (1) 250 Beginner (2) 350 Expert (3) Senior (4) 500 750 Sales Amount (TL) Bonus Rate (%) 0- 499.999,99 0.25 500.000- 999.999,99 0.5 1.000.000- 1.999.999,99 0.75 2.000.000-.. 1 By adhering the rules stated above, find the total salary amount of a sales representative for a particular month, by obtaining the title of a sales representative from the user (1 for the trainee, 2 for the novice, 3 for the specialist, 4 for the senior), the number of real estate sold this month and the total sales amount made by the sales representative. Write a C code that prints the total salary on the screen using the switch-case…
Write aigorithm to accept salary of a person for 4 months and calculate average.
Table (A) shows the individual income tax rates for assessment year 2020. Table (A): Income tax rates assessment year 2020 Chargeable Income (RM) 0- 5,000 Calculation (RM) On the First 5,000 On the First 5,000 Next 15,000 On the First 20,000 Rate % Таx (RM) 5,001 – 20,000 1 150 150 20,001 – 35,000 3 Next 15,000 450 On the First 35,000 Next 15,000 600 35,001 – 50,000 8 1,200 Write a complete C program to prompt the user to enter the total chargeable income (RM), and then calculate the tax based on the calculation given in Table (A). For example: Prem's chargeable income = RM30,000 (RM20,000 + RM10,000) Total tax = RM150 (for first RM20,000) + RM300 (3% x RM10,000) = RM450 The program will then display the result which is the total amount tax needed to be paid in Ringgit Malaysia (RM), up to three significant digits after the decimal point. Requirements: Apply one return value function, include parameter list if necessary - Apply one non-return value function, include parameter list if…
Each publication of an academic can be cited from other publications. To this academic The h-index value is calculated as follows. The total number of articles of that academic It has an index of h if each of them is cited at least. For example, a If there are 28 articles cited at least 28 times among the author's research articles, the author's h-index is 28. In order for the H-index to be 29, 29 or more of 29 articles must be cited. must have received. Accordingly, the number of citations for each of the N articles of an author varies from large to small. C code the program that calculates the researcher's h-index when given sequentially. Write in "C"language. The examples below show the number of citations received for each publication.
Al Watan supermarket has hire-purchases scheme for locals and expats. The customers will get the credit facility if they satisfy any of the following conditions: 1- The customer must hold the present job for more than 5 years and reside in the same place at least for 3 years. In this case, the customer will get credit upto rupees 300 omr. 2- The monthly salary of the customer must exceed 1000 omr and must hold the present job for more than 5 years. In this case credit will be given upto rupees 500 omr. 3- The monthly salary must exceed 1000 omr and reside at the same place at least for 3 years. In this case credit will be given upto 500 omr. 4- In the case, the customer?s monthly salary exceeds 1000 omr, holds the present job for more than 5 years and also reside in the same place at least for the 3 years, the credit facility will be upto 1000 omr 5- The credit facility is rejected for all other customers. Prepare a Decision Table for this hire- purchase scheme.
Consider the following list of Xi , Yi values: Xi , Yi 1 2 2 4 3 6 Using the above data, determine if the following equations are true or false. e.) (summation Yi)2 = summation Yi2
A student may apply for an arts college or an engineering college after his school. Admission to arts college or engineering college, is based on the marks obtained in the six subjects: English, Second language, Maths, Physics, Chemistry and Computer Science. Both the applications have the following details: application number, name, age, marks in all six subjects and cut-off for the eligibility. For Arts college, cut-off is the average of marks in all the subjects and whereas for engineering colleges cut-off is the average of marks in maths, physics, chemistry plus the marks scored in the entrance exam. Given all the required details, Design an OOP model to compute the cut-off marks and implement it using Java.