Unformatted text preview: What is the present value of $50,000 per year for 15 is 7%? PMT = RATE = NPER = 2,300 1% 16 Present Value = $34,843.71 Formula: =PV(B4,B5,B3) Note: The negative sign in the formula makes the res also put a negative sign before the PMT inside the pa $50,000 per year for 15 years if the interest rate (Same as .07) 5,B3) e formula makes the result positive. You could re the PMT inside the parentheses. What is the future value of $50,000 per year for 15 ye 7%? PMT = RATE = NPER = 50,000 7% 15 Present Value = $1,256,451.10 Formula: =FV(B4,B5,B3) Note: The negative sign in the formula makes the res put a negative sign before the PMT inside the parenth 00 per year for 15 years if the interest rate is (Same as .07) rmula makes the result positive. You could also MT inside the parentheses. ...
View
Full
Document
This note was uploaded on 09/20/2010 for the course FIN 3 00 taught by Professor Wang during the Fall '10 term at UC Davis.
 Fall '10
 Wang
 Finance

Click to edit the document details