The terms in the formula are as follows: • P is the present value, or the amount that you need to deposit today. •Fis the future value that you want in the account. (In this case, F is $10,000.) r is the annual interest rate. •n is the number of years that you plan to let the money sit in the account. Write a method named presentValue that performs this calculation. The method should accept the future value, annual interest rate, and number of years as arguments. It should return the present value, which is the amount that you need to deposit today. Demonstrate the method in a program that lets the user experiment with different values for the formula's terms.

The terms in the formula are as follows: • P is the present value, or the amount that you need to deposit today. •Fis the future value that you want in the account. (In this case, F is $10,000.) r is the annual interest rate. •n is the number of years that you plan to let the money sit in the account. Write a method named presentValue that performs this calculation. The method should accept the future value, annual interest rate, and number of years as arguments. It should return the present value, which is the amount that you need to deposit today. Demonstrate the method in a program that lets the user experiment with different values for the formula's terms.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter4: Financial Functions, Data Tables, And Amortization Schedules

Section: Chapter Questions

Problem 4EYW

See similar textbooks

Similar questions

You need to choose a password for computer account. The rule is that the password must consist of two lowercase letter (a to z) followed by one capital letter (A to Z) followed by four digits (0, 1, …, 9). For example, the following is a valid password:Find the total number of possible passwords.
When you borrow money to buy a house, a car, or for some other purpose, you repay the loan by making periodic payments over a certain period of time. Of course, the lending company will charge interest on the loan. Every periodic payment consists of the interest on the loan and the payment toward the principal amount. To be specific, suppose that you borrow $1,000 at an interest rate of 7.2% per year and the payments are monthly. Suppose that your monthly payment is $25. Now, the interest is 7.2% per year and the payments are monthly, so the interest rate per month is 7.2/12 = 0.6%. The first months interest on $1,000 is 1000 0.006 = 6. Because the payment is $25 and the interest for the first month is $6, the payment toward the principal amount is 25 6 = 19. This means after making the first payment, the loan amount is 1,000 19 = 981. For the second payment, the interest is calculated on $981. So the interest for the second month is 981 0.006 = 5.886, that is, approximately $5.89. This implies that the payment toward the principal is 25 5.89 = 19.11 and the remaining balance after the second payment is 981 19.11 = 961.89. This process is repeated until the loan is paid. Write a program that accepts as input the loan amount, the interest rate per year, and the monthly payment. (Enter the interest rate as a percentage. For example, if the interest rate is 7.2% per year, then enter 7.2.) The program then outputs the number of months it would take to repay the loan. (Note that if the monthly payment is less than the first months interest, then after each payment, the loan amount will increase. In this case, the program must warn the borrower that the monthly payment is too low, and with this monthly payment, the loan amount could not be repaid.)
MOLLY esc ť Ť → ← C Another option in Club Keno is to play the "Kicker." This is an option that doubles your bet, but you can get a random multiplier to your winnings. About 2/3 of the time there is no multiplier, though. Let's consider what the expected value is when playing the kicker while only betting on only one number. Outcome Kicker Probability Net Value x1 x2 x3 x4 x5 x10 Any What is the expected value when using the Kicker option and choosing one number? $ (Round to the nearest cent.) beasley Xem/ZMAIHIL12 X M MyOpenMath https://www.myopenmath.com/assess2/?cid=166287&aid=11856365#/full f1 1 Correct 1 Correct 1 Correct 1 Correct 1 Correct 1 Correct 0 Correct If you had not played the kicker, the table would be: Probability Submit and End 1 ? Outcome 1 Correct 0 Correct Q Type here to search If you had not played the kicker, what would the expected value be? $ (Round to the nearest cent.) 12 2 0.25 0.75 f3 0.15625 0.046875 0.0234375 0.01171875 0.00585938 0.00585938 # 0.75 3…
Each box of Healthy Crunch breakfast cereal contains a coupon entitling you to a free package of garden seeds. At the Healthy Crunch home office, they use the weight of incoming mail to determine how many of their employees are to be assigned to collecting coupons and mailing out seed packages on a given day. (Healthy Crunch has a policy of answering all its mail on the day it is received.) If the answer is a whole number, write a whole number. If it has one decimal place, write one decimal place. Otherwise, round off to two decimal places. If the answer is greater than 999, put a comma. a. Solve for Σx = Blank 1 b. Solve for Σy = Blank 2 c. Solve for Σx2 = Blank 3 d. Solve for Σy2 = Blank 4 e. Solve for Σxy = Blank 5 f. Solve for Pearson's r = Blank 6 g. Solve for the variance = Blank 7 h. Solve for the slope of the simple linear regression line = Blank 8 i. Solve for the y-intercept of the simple linear regression line = Blank 9 j. If the weight of the incoming mail is 30 lb, what…
use visual basic Depreciation to a Salvage Value of 0 . For tax purposes an item may be depreciated over a period of several years, n . With the straight-line method of depreciation , each year the item dpreciates by 1/nth of it original value. with the double-declining-balance method of depreciation, each year the item depreciate by 2/nths of its value at the beginning of that year.(In the final year it is depreciated by its value at the beginning of the year. ) Write a program that performs the following tasks:(a) Request a description of the item, the year of purchase, the cost of the item, the number of years to be depreciated (estimated life), and the method of depreciation. The method of depreciation should be chosen by clicking on one of two buttons.(b) Display a year- by-year description of the depreciation. See Fig. 6.15 .
NEED HELP ASAP PLEASE! THANK YOU! Consider a game with three dice, namely, A, B and C. Each die, when rolled, generates a number between 1 and 6 (inclusive) independently and uniformly at random. In each play, the three dice are rolled, then a monetary return is computed according to the values for dice A, B and C, using the following algorithm. ThreeDice(A, B, C) { money = -9; if (A == B and B == C) { money = money + 81; } else if (A == B or B == C or C == A) { money = money + 21; } return money; } Analyze this game by answering the following questions: (a) What is the largest possible return value of ThreeDice? (b) What is the probability of ThreeDice returning the largest possible value? Choose one from below. A. 1/18 B. 1/3 C. 1/216 D. 1/2 E. 1/6 F. none of these is correct G. 1/36 H. 1/12 (c) What is the smallest possible return value of ThreeDice? (d) What is the probability of ThreeDice returning the smallest possible value? Choose one from below. A. 5/54 B. 1/18 C. 5/9 D. 4/9…
13.7 NVCC Lab: Maximize points There are N bags of marbles. The number of marbles in each bag may be different. When you take a marble out of a bag, you will earn certain amount of points, depending on the number of marbles in that bag. For example, if a bag contains K marbles, you will earn K point if you take a marble from that bag. You can take only one marble each time. Now, you are allowed to take upto M marbles in total, what is the maximum points you can earn? Input file: The first line consists of N and M. N denotes the number of marble bags and M denotes the maximum number of marbles you can take out from those bags. Next line consists of N space separated integers X1,X2,X4…. XN where Xi denotes the number of marbles initially in the ith bag. Please implement the following method: public long maxPoints(String input) For example, given the following data file, calling maxPoints(“input.data”) should return 13. Taking out a marble from the third bag earned 5 points, taking…
What value will z have if we execute the following assignment statement? Please elaborate on your answer. int z = 50 / 10.00;
How do I use a nested if statement to calculate an employee’s productivity bonus and print the employee’s name and bonus? Bonuses are calculated based on an employee’s productivity score as shown below. A productivity score is calculated by first dividing an employee’s transactions dollar value by the number of transactions and then dividing the result by the number of shifts worked. Productivity Score Bonus <=30 $50 31–69 $75 70–199 $100 >= 200 $200
A cashier distributes change using the maximum number of five dollar bills, followed by one dollar bills. For example, 19 yields 3 fives and 4 ones. Write a single statement that assigns the number of one dollar bills to variable numOnes, given amountToChange. Hint: Use the % operator. #include <stdio.h> int main(void) { int amountToChange; int numFives; int numOnes; scanf("%d", &amountToChange); numFives = amountToChange / 5; /* Your solution goes here */ printf("numFives: %d\n", numFives); printf("numOnes: %d\n", numOnes); return 0;
Suppose that you are an accountant managing several customers' accounts. you want to use R to store these account amounts into a variable A. Write ONLY the R code or R functions that answer each of the following Questions ( please put only the question number and your answer ) Create A (use any amounts only to justify your answer) : Add vat (5%) to each amount in A : How many accounts do you have in A : What is the total of all amounts : Calculate the frequency of each amount: Calculate Percentiles of A : Please solve it.
a. You have arranged a party to celebrate 31 December 2020 and you have invited all your friends. To make the party successful, you came up with an interesting game called “Happy New Year”. There are few rules in the game: i. All the members that will play the game must sit in a circular manner. ii. There will be two coins, which will determine the faith of the player. iii. If the both coins after flipping get ‘Heads’ or ‘Tails’ or viceversa, the player has to pass the coin to the next player (sitting to his/her right). iv. If one coin after flipping gets ‘Tails’ and the other gets ‘Heads’, the player gets eliminated and passes the coin to the next player (sitting to his/her right). v. The game continues until there is only one member left and he/she will get a surprise gift. Write a method that finds out the winner of the ‘Happy New Year’ game, you will be given as input the number of players playing and the coin sequences. [You must use recursion for solving this problem.]…