A savings account is opened with £100000 at the beginning of January. A deposit is then made of £1000 at the end of every month for the next 12 months. Interest is calculated and added to his account at the end of the month (before the £1000 deposit is made). Interest is calculated based on the amount in the account when the interest is calculated based on the following; Account amount Interest rate 0.5% < 110 000 110 000 ≤ A ≤ 125000 1.0% > 125000 1.5% Write a program that will display for each of the 12 months, under suitable headings, the month, the interest rate, the amount of interest earned, and the new balance.

A savings account is opened with £100000 at the beginning of January. A deposit is then made of £1000 at the end of every month for the next 12 months. Interest is calculated and added to his account at the end of the month (before the £1000 deposit is made). Interest is calculated based on the amount in the account when the interest is calculated based on the following; Account amount Interest rate 0.5% < 110 000 110 000 ≤ A ≤ 125000 1.0% > 125000 1.5% Write a program that will display for each of the 12 months, under suitable headings, the month, the interest rate, the amount of interest earned, and the new balance.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter9: Working With Text Functions And Creating Custom Formats

Section: Chapter Questions

Problem 1.7CP

See similar textbooks

Similar questions

The company discounted used cars pays their employees according to this chart: 250$ per months plus 50$ per car sold. If the salesman sells more than 10 cars, the employee receives a bonus of 5% of the total of his sales, in addition to his regular salary.Each month, the owner sits in front of the computer, and enters the following information: The name of the employee, the number of cars sold, as well as the total of all the sales for the month. algorithm that will calculate the salary of an employee for the month, and then display on the screen, his name, total cars sold, base salary, bonus if applicable and entire salary
P1 - Loan Payment Schedule Main Street Bank is offering an annual interest rate discount based on the client’s credit score. The discount for each credit score level is provided in the table below. The lowest credit score is 300 while the highest credit score is 850. For example, the new interest rate for a client with a credit score of 755 and a current interest rate of 4.25% would be 4.25 – 0.75 = 3.50% interest rate Credit Score Rating Interest Rate Discount 300 - 579 Very Poor 0.00 580 – 669 Fair 0.25 670 - 739 Good 0.50 740 - 799 Very Good 0.75 800 - 850 Exceptional 1.00 Use modular programming concepts Create a program that includes a WHILE loop to generate a payment schedule for loans that are paid in equal monthly payments Input the loan number and retrieve required loan account from MS_LOANS table Output is shown below Monthly interest is calculated by dividing the yearly interest rate by 12 to get a monthly interest…
The company « Super discounted used cars inc.» pays their employees according to this chart: 250$ per months plus 50$ per car sold. If the salesman sells more than 10 cars, the employee receives a bonus of 5% of the total of his sales, in addition to his regular salary. Each month, the owner sits in front of the computer, and enters the following information: The name of the employee, the number of cars sold, as well as the total of all the sales for the month. Write an algorithm that will calculate the salary of an employee for the month, and then display on the screen, his name, total cars sold, base salary, bonus if applicable and entire salary.
Q7:The electricity accounts of residents in a very small town are calculated as follows: if 500 units or less are used the cost is 2 cents per unit; > if more than 500, but not more than 1000 units are used, the cost is $10 for the first 500 units, and then 5 cents for every unit in excess of 500; > if more than 1000 units are used, the cost is $35 for the first 1000 units plus 10 cents for every unit in excess of 1000; in addition, a basic service fee of $5 is charged, no matter how much electricity is used. Q8:Write a program which enters the following five consumptions into a vector, and uses a for loop to calculate and display the total charge for each one: 200, 500, 700, 1000, 1500. (Answers: $9 $15, $25, $40, $90)
The company « Super discounted used cars inc.» pays their employees according to this chart: 250$ per months plus 50$ per car sold. If the salesman sells more than 10 cars, the employee receives a bonus of 5% of the total of his sales, in addition to his regular salary. Each month, the owner sits in front of the computer, and enters the following information: The name of the employee, the number of cars sold, as well as the total of all the sales for the month. algorithm that will calculate the salary of an employee for the month, and then display on the screen, his name, total cars sold, base salary, bonus if applicable and entire salary. Each input must be validated.and make trace memory screen
1. Calculate the Overtime Pay for 5 Service men Enter the Service man Name, Enter the Type of Service, Enter Monthly Basic Salary, Enter Number of Days of Overtime. The options of Type of Service men will be "Army", “Navy" and “Airforce". If the type of Service is "Airforce'", the Overtime Rate is 30%. If the type of Service is “Army", the Overtime Rate is 28%. If the type of Service is “Navy", the Overtime Rate is 26%. Overtime pay = Daily rate * Numbers of Days Overtime * Overtime Rate. Daily rate = Monthly Basic Salary / 22. Display Service man Name / Service Type / Daily Rate / Overtime Pay for all the 5 Service men Save your shell script as servicemen.sh
Mary and Jane have a joint authorship for their book "Cooking 101". Mary passed away before Jane. The term for their copyright will end when? * Lifetime of Mary + 50 years Lifetime of Jane + 50 years Lifetime of Jane + 25 years 50 years from the date of the publication of their book
Problem 2 Concert Tickets 8 points There are three tickets for a concert. The VIP tickets cost $120, premium tickets cost $80, and regular tickets cost $40. Prompt the user how many tickets of each category he would like. Then print an invoice with overview of the order and total price. Include a sales tax of 9.25%. How many tic kets would you like to order? VIP Tickets ($120): 0 Premium Tickets ($80) : 4 Regular Tickets ($40): 2 Invoice: $120 x 0= $ 0.00 $ 80 X 4 = $320.00 $ 40 x 2 = $ 80.00 9.25% $ 37.00 VIP: Premium: Regular: Sales Tax: Total Price: $437.00
What is the opposite of greater than?
9 = ; Y= 5 50 18 100 81 Cul culate, Loss,L= mse (7,9) Note: mse = mean squane ennoto 对5 经

Serendipity Booksellers has a book club that awards points to its customers based on the number of books purchased each month. The points are awareded as follows: If a customer purchases 0 books, he or she earns 0 points. If a customer purchases 1 book, he or she earns 5 points. If a customer purchases 2 books, he or she earns 15 points. If a customer purchases 3 books, he or she earns 30 points. If a customer purchases 4 or more books, he or she earns 60 points. Creat an application in C# that lets the user enter the number of books that he or she has purchased this month and displays the number of points awarded.
A retail store has a preferred customer plan where customers can earn discounts on all their purchases. The amount of a customer’s discount is determined by the amount of the customer’s cumulative purchases in the store as follows: • When a preferred customer spends $500, he or she gets a 5 percent discount on all future purchases. • When a preferred customer spends $1,000, he or she gets a 6 percent discount on all future purchases. • When a preferred customer spends $1,500, he or she gets a 7 percent discount on all future purchases. • When a preferred customer spends $2,000 or more, he or she gets a 10 percent discount on all future purchases. Design a class named PreferredCustomer, which is derived from the Customer class you created in Programming Problem 4. The PreferredCustomer class should have properties for the amount of the customer’s purchases and the customer’s discount level. Demonstrate the class in a simple application.