PV-FV Worksheet

# PV-FV Worksheet - What is the present value of \$50,000 per...

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online