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

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

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

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

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