Payment=Principal [rate ((1 + rate)months)][(rate + 1)months - 1]For the formula to compute monthly payment, see Listing 2.9, ComputeLoan.java.(Financial application: loan amortization schedule) The monthly payment for agiven loan pays the principal and the interest. The monthly interest is computedby multiplying the monthly interest rate and the balance (the remaining princi-pal). The principal paid for the month is therefore the monthly payment minusthe monthly interest. Write a program that lets the user enter the loan amount Programnumber of years, and interest rate and displays the amortization schedule for theloan. Here is a sample run:Loan Amount: 10000 EnterNumber of Years: 1 EnterAnnual Interest Rate: 7Monthly Payment: 865.26Total Payment: 10383.21Payment# Interest58.3353.62121112}10.05.01EnterPrincipal806.93811.64855.26860.25Balance9193.078381.43860.270.01NoteThe balance after the last payment may not be zero. If so, the last payment should bethe normal monthly payment plus the final balance.Hint: Write a loop to display the table. Since the monthly payment is thesame for each month, it should be computed before the loop. The balanceis initially the loan amount. For each iteration in the loop, compute theinterest and principal, and update the balance. The loop may look like this:for (i = 1; i <= numberOfYears * 12; i++) {interest = monthlyInterestRate * balance;principal = monthly Payment - interest;balance = balance - principal;System.out.println(i + "\t\t" + interest+ "\t\t" + principal + "\t\t" + balance);

Payment = months Principal [rate ((1 + rate)mo [(rate + 1)months – 1] - For the formula to compute monthly payment, see Listing 2.9, ComputeLoan.java. (Financial application: loan amortization schedule) The monthly payment for a given loan pays the principal and the interest. The monthly interest is computed by multiplying the monthly interest rate and the balance (the remaining princi- pal). The principal paid for the month is therefore the monthly payment m the monthly interest. Write a program that lets the user enter the loan amount. minus

Payment = months Principal [rate ((1 + rate)mo [(rate + 1)months – 1] - For the formula to compute monthly payment, see Listing 2.9, ComputeLoan.java. (Financial application: loan amortization schedule) The monthly payment for a given loan pays the principal and the interest. The monthly interest is computed by multiplying the monthly interest rate and the balance (the remaining princi- pal). The principal paid for the month is therefore the monthly payment m the monthly interest. Write a program that lets the user enter the loan amount. minus

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

in javas, use basic language construct please
ANSWER MUST BE IN PYTHON3. This is the method header: #!/bin/python3 import math import os import random import re import sys # # Complete the 'linear_interpolate' function below. # # The function is expected to return a float. # The function accepts following parameters: # 1. int n # 2. List[float] x_knots # 3. List[float] y_knots # 4. float x_input # def linear_interpolate(n, x_knots, y_knots, x_input):
The interest paid on a savings account is compounded daily. This means that if you start with startbal dollars in the bank, at the end of the first day you’ll have a balance ofstartbal * (1 + rate/365)dollars, where rate is the annual interest rate (0.10 if the annual rate is 10 percent). At the end of the second day, you’ll havestartbal * (1 + rate/365) * (1 + rate/365)dollars, and at the end of n days you’ll havestartbal * (1 + rate/365)ndollars. Write a program that processes a set of data records, each of which contains values for rate, startbal, and n and computes the final account balance.
Write a program that generates a two-column table showing Fahrenheit temperatures from -40F to 120F and their equivalent Celsius temperatures. Each line in the table should be 5 degrees F more than the previous one. Both the Fahrenheit and Celsius temperatures should be accurate to 1 decimal place. Note......BOOK: Introduction to Java Programming and Data Structures, Comprehensive Version, Edition: 11th Author: Y. Daniel Liang Publisher: Pearson ISBN: 9780134670942
The function below does not work as expected: If sales is a negative number is returns 3 instead of returning 0. Please help me correct it. /*This function determines the commision percent based on the following table:Sales Commission$0 - 1000 3%1001 - 5000 4.5%5001 - 10,000 5.25%over 10,000 6%*/double Sales::detCommissionPercent() const{double commission = 0;if ( amountSold > 0){if(amountSold<= 1000) // if amountSold is between [0, 1000] commission = 3;else if(amountSold<=5000)// if amountSold is between [1001, 5000] commission = 4.5;else if(amountSold<=10000) // if amountSold is between [5001, 10000] commission = 5.25;else commission = 6;}return commission;}
Summary Interest on a credit card's unpaid balance is calculated using the average daily balance. Suppose that netBalance is the balance shown in the bill, payment is the payment made, d1 is the number of days in the billing cycle, and d2 is the number of days payment is made before billing cycle. Then, the average daily balance is: averageDailyBalance = (netBalance * d1 payme If the interest rate per month is, say, 0.0152, then the interest on the unpaid balance is: interest averageDailyBalance * 0.0152 Instructions Write a program that accepts as input netBalance, d1, payment, d2, and interest rate per month ( interestRate).
Write a program that calculates the balance of a checking account at the end of a three- month period. It should ask the user for the starting balance. Then a loop (for loop is recommended) should iterate once for every month in the period, performing the followi 1. Ask the user for the total amount deposited into the account during that month. Do n accept negative number. This deposit should be added to the current balance to make current balance is up to date. 2. Ask the user for the total amount withdrawn from the account during that month. Do accept negative amount or amount greater than the current balance. The withdrawal amount should be subtracted from current balance, so current balance is up to date. 3. Update the total deposit. 4. Update the total withdrawal After the last iteration, the program should display the following information: 1. starting balance at the beginning of the three-month 2. total deposits/withdrawals made during the three-month period 3. final balance…
Use Java. Please see the requirements (good indentation, matching the code EXACTLY how it is below, etc.)
Write VBA CODE FOR THE FOLLOWING PROBLEM Problem: The Worksheet named Grades contains a place for students to record the grades they have received in their classes. Students put the number of each letter grade received in the B column. (For example, the worksheet currently shows that the student has taken 9 classes and made five As, one B, one C, one D, and one F as grades. You need to write a program that reads the grades from the worksheet and uses a function to calculate the student’s GPA. For this problem you can assume that all classes are worth the same number of credit hours. The function should send back the GPA to the calling procedure. The procedure will then put up a message box that gives the student their GPA and a message about their GPA, all in one message box. The message should be “You qualify for an internship” if the student has a GPA of at least 3.0. It should be “You’re in the danger zone” if the GPA is between 2.0 and 3.0. And it should be “You are on…
Note: Please answer in C++ Programming language. During Eid, it is a tradition for every father to give his children money to spend on entertainment. Chef has N coins; denote the value of the coin i by vi. Since today is Eid, Chef gives one coin to each of his two children. He wants the absolute value of the difference between the values of the coins given to the two children to be as small as possible to be as fair as possible. Help the chef by telling him the minimum possible difference between the values of the coins given to the two children. Of course, the chef cannot give the same coin to both children. Possible input 1 3 142 Required Output 1
Months Given the current month X, find out what month it will be after Y months have passed. You may not use the following keywords: if, while, for. $ python month.py 13 It's currently January, in 3 months it will be April. $ python month.py 5 20 It's currently May, in 20 months it will be January. $ python month.py 12 12 It's currently December, in 12 months it will be December.
Python