You want to calculate the maximum loan that can be paid off with an interest rate of 2.5% over 12 payments of $1000.00 each. Use Goal Seek and the PMT function to solve for the maximum loan amount "x". Provide two decimal places: =PMT(0.025, 12, -x, 0) For your answer, make sure to use a $ symbol and do not use extra spaces.

You want to calculate the maximum loan that can be paid off with an interest rate of 2.5% over 12 payments of $1000.00 each. Use Goal Seek and the PMT function to solve for the maximum loan amount "x". Provide two decimal places: =PMT(0.025, 12, -x, 0) For your answer, make sure to use a $ symbol and do not use extra spaces.

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 2.7CP

See similar textbooks

Similar questions

Q2. Consider the following options for characters in setting a password: Digits = { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 } Letters = { a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t, u, v, w, x, y, z } Special characters = { *, &, $, # } Compute the number of passwords possible that satisfy these conditions: Password must be of length 8. Characters can be special characters, digits, or letters. The first character must be a letter. Characters may be repeated.
Lael is always on the lookout for students who might be interested in running for office in student groups.In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future:a. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text.
You have two columns, say Age group in column A and purchase in column B. If either Age group is kid or senior citizen and purchase is more that INR 15000 the purchaser gets 10% discount otherwise only 2% discount shall be given. Which of the following formula is correct? a. if(AND((A1="Kid" OR A1="Senior Citizen"),B1>15000), "12%", "2%") b. if((A1="Kid" AND A1="Senior Citizen") OR B1>15000, 12%, 2%) c. if(AND(OR(A1="Kid",A1="Senior Citizen"),B1>15000), "12%", "2%") d. None of these
In G2:G11, the values should evaluate to the surname and the first character of the first name, with some punctuation. For example G2 should evaluate to Johnson R. What function should be used to achieve this? Choices: A. CONCATENATE B. MIN,MAX C. SEARCH D. RANK E. No choice given
Question Description 1. In this example of a nested IF Statement, breakout and explain each part of formula to determine how the commission rates will be calculated: IF(B2>=150, 10%, IF(B2>=101, 7%, IF(B2>=51, 5%, IF(B2>=1, 3%,"")))). 2.Why would you use a Vlookup function as oppose to a Nested If statement? 3.Give a real-life scenario in which you may have used or can implement the Nested If or Vlookup functions in your daily or weekly tasks.
A university assigns student IDs of the form 1, 2, 3, ... such that if n students are currently enrolled, then the next student to enroll will receive and ID of n + 1. Consider the following algorithm that accomplishes this. // Global variable storing number of students currently enrolled current_student_count = 0 // Function that reads the above global variable, calculates new ID, and increments the global count assign_new_id(): count = current_student_count new_id = count + 1 current_student_count = count + 1 return new_id (a) If two different threads run the above code in parallel to enroll two different students, it is possible for the two students to receive the same ID, and for the current_student_count to have a wrong value. Explain how this is possible. (b) Modify the code above so that the problem in (a) does not happen.
1. Dean wants a quick way to look up staff members by their Staff ID. In cell Q3, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, the text “Invalid Staff ID” should be displayed by the formula. (Hint: You can test that this formula is working by changing the value in cell Q2 to 0, but remember to set the value of cell Q2 back to 1036 when the testing is complete.) Current cell function is =VLOOKUP(Q2,CBFStaff[[Staff ID]:[Name]],2,FALSE) 2. In cell Q4, enter a formula using the VLOOKUP function to display a staff member’s years of service. Look up the staff ID listed in cell Q2. Use a structured reference to retrieve the value in the 4th column of the CBFStaff table. Since the formula is looking for a specific staff member’s data, find an exact match.
Suppose we have a nice young couple who borrow $700000 from the bank, at an annual interest rate of3.124%. The mortgage is a 30 year loan, so they need to pay it off within 360 months total. Our happycouple decide to set their monthly mortgage payment at $2000 per month. Will they pay off the loan intime or not?Note that the monthly balance will be calculated asbalance = (im × previous balance) - monthly paymentwhere the convert annual interest to a monthly multiplier im is calculated as im = (1 +i)1/12 and i = annualinterest rate.Write a loop for track the total payment in 360 months so that we can evaluate if the couple can pay off theloan. Write in R Please and thank you.
Lael is always on the lookout for students who might be interested in running for office in student groups.In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text "Yes" and return the text Yes if true And No if false. what is the formula to enter into excel?
To help you better understand why the definition of Big-O is concerned only with the behavior of functions for large values of n, choose two functions with different growth rates in which the faster growing function is lower at small values of n, but eventually becomes larger. Write a short program that periodically compares the values of the two functions and illustrates the point at which the faster growing function overtakes the slower growing one. s an example, consider the following two functions: f(n) = 500n2 + 15n + 1000 g(n) = 2n3 Shown below is a table of the values of both functions for small values of n. n f(n) g(n) 10 51150 2000 20 201300 16000 30 451450 54000 40 801600 128000 50 1251750 250000 60 1801900 432000 70 2452050 686000 80 3202200 1024000 90 4052350 1458000 100 5002500 2000000 110 6052650 2662000 120 7202800 3456000 130 8452950 4394000 140 9803100 5488000 150 11253250 6750000 160 12803400 8192000 170 14453550 9826000 180 16203700 11664000 190 18053850 13718000…
4) see picture to solve. Just need to know which formula to use. 6 ticket revenue. B. = B1*B2, =B1*B3, =B2*B4, or =B1*B4 7 concession revenue. B. =B1*B4, =B1*B3, =B2*B4, or =B1*B2 8 profit B. =B1*B4, =B1*B3, =B2*B4, or =B1*B2
I need help with an Excel Function Formula. Here's the question. In cell F6 enter a formula that will multiply the number of children by the Income Per (Column E). If the number of children is zero (the income isn’t based on a per-child cost), then the formula should return the figure in the Income Per column. D6=Children, E6=Income Per As per the question, I'm assuming that if D6=0 then the answer would be the content in E6 so if D6=0 and E6=110 then the answer would be 110. In the other hand, if D6=9 and E6=220 then the answer is 1980. Am I right? If so, I came up with this formula =IF(D6="0", E6, D6*E6) This works good if the content in D6 is greater than 0 but for some reason if the content is 0 my answer keeps coming up as 0 instead of giving me the content from E6. Help. What am I doing wrong?