Worksheet_ch6_2

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

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

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.

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

View Full Document
PMT = 50,000
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

{[ snackBarMessage ]}

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
Ask a homework question - tutors are online