Solution 5.11 - QUESTION 5.11: Annual Interest Rate Yearly...

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

View Full Document Right Arrow Icon
QUESTION 5.11: Annual Interest Rate 11.00% Yearly Amount $5,000.00 Year Future Values Discount Factor Present Value 0 -$14,000.00 1.000 -$14,000.00 1 $5,000.00 0.901 $4,504.50 2 $5,000.00 0.812 $4,058.11 3 $5,000.00 0.731 $3,655.96 4 $5,000.00 0.659 $3,293.65 5 $5,000.00 0.593 $2,967.26 6 $5,000.00 0.535 $2,673.20 NPV Cash Flow $7,152.69 EXCEL NPV Formula $7,152.69
Background image of page 1

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

View Full DocumentRight Arrow Icon
Annual Interest Rate 11.00% Yearly Amount $5,000.00 Year Future Values Discount Factor Present Value 0 -$14,000.00 1.000 -$14,000.00 1 $5,000.00 0.901 $4,504.50 2 $5,000.00 0.812 $4,058.11 3 $5,000.00 0.731 $3,655.96 4 $5,000.00 0.659 $3,293.65 5 $5,000.00 0.593 $2,967.26 6 $5,000.00 0.535 $2,673.20 NPV Cash Flow $7,152.69 EXCEL NPV Formula $7,152.69 LB $2,500.00 UB $7,000.00 Steps 10 Interval Width $450.00 Percent Change from Base $7,152.69 -50% 0 $2,500 -$3,424 -41% 1 $2,950 -$1,520 -32% 2 $3,400 $384 -23% 3 $3,850 $2,288 -14% 4 $4,300 $4,191 -5% 5 $4,750 $6,095 4% 6 $5,200 $7,999 13% 7 $5,650 $9,903 22% 8 $6,100 $11,806 31% 9
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Solution 5.11 - QUESTION 5.11: Annual Interest Rate Yearly...

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

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