This preview shows page 1. Sign up to view the full content.
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
 Fall '10
 Wang
 Finance

Click to edit the document details