PV-FV Worksheet

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

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

View Full Document Right Arrow Icon
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

Ask a homework question - tutors are online