Worksheet_ch6_1

# Worksheet_ch6_1 - Rate 15(Same as.15 Year Cash Flow Present...

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

Rate 15%(Same as .15) Year NPER Cash Flow Future Value Formula 1 4 1000 \$1,749.01 =-FV(\$B\$3,B6,0,C6) 2 3 3000 \$4,562.63 =-FV(\$B\$3,B7,0,C7) 3 2 5000 \$6,612.50 =-FV(\$B\$3,B8,0,C8) 4 1 7000 \$8,050.00 =-FV(\$B\$3,B9,0,C9) 5 0 9000 \$9,000.00 =-FV(\$B\$3,B10,0,C10) Total PV \$29,974.13 =SUM(D6:D10) Comments: The negative sign before the FV formula makes the result positive. Consider the cash flows presented in the table below. What is the value of the cash flows in year 5? The dollar signs around B3 make the rate an absolute reference so that the formula may be entered once and then copied down. The formua asks for a payment between number of periods and present value, hence the 0.

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

View Full Document
Consider the cash flows presented in the table below. What is the present value?
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Rate 15%(Same as .15) Year Cash Flow Present Value Formula 1 1000 \$869.57 =-PV(\$B\$3,A6,0,B6) 2 3000 \$2,268.43 =-PV(\$B\$3,A7,0,B7) 3 5000 \$3,287.58 =-PV(\$B\$3,A8,0,B8) 4 7000 \$4,002.27 =-PV(\$B\$3,A9,0,B9) 5 9000 \$4,474.59 =-PV(\$B\$3,A10,0,B10) Total PV \$14,902.44 =SUM(C6:C10) Comments: The negative sign before the PV formula makes the result positive. The formua asks for a payment between number of periods and future value, hence the 0. The dollar signs around B3 make the rate an absolute reference so that the formula may be entered once and then copied down....
View Full Document

{[ snackBarMessage ]}

### Page1 / 2

Worksheet_ch6_1 - Rate 15(Same as.15 Year Cash Flow 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