Worksheet_ch6_1

Worksheet_ch6_1 - Rate 15%(Same as .15) Year Cash Flow...

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Consider the cash flows presented in the table below. What is the present value?
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 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

Page1 / 2

Worksheet_ch6_1 - Rate 15%(Same as .15) Year Cash Flow...

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