math

posted by .

1. =SUM(A14,A8)
2. =C8+ 15
3. PMT function {PMT(D4D12,E4,-C4)}

What will each of the above formulas do
please see if I have the correct answer using excel or another spreadsheet document.

1. Is the sum between the two blocks listed the more blocks the more #'s to the equation, it helps when the #'s change and the total has to be adjusted, the program will do it automatically for you( The same reason for all equations)

2. This would be the block in question plus 15

3. Calculates the payment for a loan based on constant payments and a constant interest rate. PMT(rate,nper,pv,fv,type)

Rate is the interest rate for the loan.

Nper is the total number of payments for the loan.

Pv is the present value, or the total amount that a series of future payments is worth now; also known as the principal.

Fv is the future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.

Type is the number 0 (zero) or 1 and indicates when payments are due

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Math

    the sum of the first n terms of an arithmetic series is -51. the series has a constant difference of -1.5 and a first term of four. Find the number of terms in the sum I find using an EXCEL spreadsheet is very helpful for these types …
  2. Excel

    I have to create a payroll document for class using Excel and I am quite confused. Here is the parts that I am confused on. -I have to calculate the number of years the employees have been working for us, I believe the function I need …
  3. Corporation Finance

    If you put up $28,000 today in exchange for an 8.25%, 15-year annuity, what will the annual cash flow be?
  4. Math please check answer

    1. =SUM(A14,A8) 2. =C8+ 15 3. PMT function {PMT(D4D12,E4,-C4)} What will each of the above formulas do please see if I have the correct answer using excel or another spreadsheet document. 1. Is the sum between the two blocks listed …
  5. finance (saving for $1,000,000)

    At age 5, how much would you have to save per month to have $1 million in your account at age 65, if your investment rate was 10% per year?
  6. math 20 (finance)Please help

    At the end of each month, Jacob puts $400 into an account that pays 6%, compounded semi-annually. Use your graphing calculator to determine how much Jacob will have after 25 years?
  7. MAth

    Can you tell me if the fv function or the pmt functionn use to find the interest rate. I think it is the pmt. Am I right or wrong.
  8. microsoft excell 2007

    when working with predefined formulas in excel,what category contains the boolean functions?
  9. Earth Science

    I need help with the following Lab due tonight, 7/30/12, as I feel completely lost and would appreciate the help. The lab goes as follows: Design an experiment that illustrates the determination of the density of a cylindrical object …
  10. Math

    Use Excel’s PMT function to calculate the monthly mortgage payment

More Similar Questions