Worksheet_ch6_2

Worksheet_ch6_2 - RATE = 7%(Same as .07) NPER = 15 Present...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
PMT = 50,000 RATE = 7%(Same as .07) NPER = 15 Present Value = $455,395.70 Formula: =-PV(B4,B5,B3) What is the present value of $50,000 per year for 15 years if the interest rate is 7%? Note: The negative sign in the formula makes the result positive. You could also put a negative sign before the PMT inside the parentheses.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
PMT = 50,000
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: RATE = 7%(Same as .07) NPER = 15 Present Value = $1,256,451.10 Formula: =-FV(B4,B5,B3) What is the future value of $50,000 per year for 15 years if the interest rate is 7%? Note: The negative sign in the formula makes the result positive. You could also put a negative sign before the PMT inside the parentheses....
View Full Document

Page1 / 2

Worksheet_ch6_2 - RATE = 7%(Same as .07) NPER = 15 Present...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online