Question 2.12 - 9 $55.00 0.928 $51.04 10 $55.00 0.920...

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

View Full Document Right Arrow Icon
QUESTION 2.12: PAGE 38 Annual Interest Rate 10.00% Monthly Interest Rate 0.83% Month Future Values Discount Factor Present Value 0 $600.00 1.000 $600.00 1 -$55.00 0.992 -$54.55 2 -$55.00 0.984 -$54.09 3 -$55.00 0.975 -$53.65 4 -$55.00 0.967 -$53.20 5 -$55.00 0.959 -$52.76 6 -$55.00 0.951 -$52.33 7 -$55.00 0.944 -$51.90 8 -$55.00 0.936 -$51.47 9 -$55.00 0.928 -$51.04 10 -$55.00 0.920 -$50.62 11 -$55.00 0.913 -$50.20 12 -$55.00 0.905 -$49.79 NPV Cash Flow -$25.60 EXCEL NPV Formula ($25.39)
Background image of page 1

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

View Full DocumentRight Arrow Icon
QUESTION 2.12: PAGE 38 Annual Interest Rate 10.00% Monthly Interest Rate 0.83% Month Future Values Discount Factor Present Value 0 -$600.00 1.000 -$600.00 1 $55.00 0.992 $54.55 2 $55.00 0.984 $54.09 3 $55.00 0.975 $53.65 4 $55.00 0.967 $53.20 5 $55.00 0.959 $52.76 6 $55.00 0.951 $52.33 7 $55.00 0.944 $51.90 8 $55.00 0.936 $51.47
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 9 $55.00 0.928 $51.04 10 $55.00 0.920 $50.62 11 $55.00 0.913 $50.20 12 $55.00 0.905 $49.79 NPV Cash Flow $25.60 EXCEL NPV Formula $25.39 QUESTION 2.12: PAGE 38 Annual Interest Rate 10.00% Monthly Interest Rate 0.83333% Month Future Values Discount Factor Present Value $600.00 1.000 $600.00 1-$55.00 0.992-$54.55 2-$55.00 0.984-$54.09 3-$55.00 0.975-$53.65 4-$55.00 0.967-$53.20 5-$55.00 0.959-$52.76 6-$55.00 0.951-$52.33 7-$55.00 0.944-$51.90 8-$55.00 0.936-$51.47 9-$55.00 0.928-$51.04 10-$55.00 0.920-$50.62 11-$55.00 0.913-$50.20 12-$55.00 0.905-$49.79 NPV Cash Flow-$25.60 EXCEL NPV Formula (25.3864100) IRR 1.4977%...
View Full Document

This note was uploaded on 04/04/2012 for the course CIVIL ENG CIV 125 taught by Professor Prof.chang during the Summer '11 term at International School of Management, New York.

Page1 / 3

Question 2.12 - 9 $55.00 0.928 $51.04 10 $55.00 0.920...

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