{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Copy of timevalue

# Copy of timevalue - Time Value on Excel(Using the...

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

Time Value on Excel (Using the Function (fx) Wizard) note: click on the cell next to the question mark to see the formula. If I deposit \$100 in an account earning 10% per year, how much will my deposit be worth after 5 years? PV \$(100.00) I 10.00% n 5 FV? \$161.05 What if we had the same problem but interest is compounded monthly? PV \$(100.00) I 0.83% n 60 FV? \$164.53 ***Note: Change the values of any variable other than that being solved for to view changes*** Future Value:

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

View Full Document
Time Value on Excel (Using the Function (fx) Wizard) note: click on the cell next to the question mark to see the formula. How much would I need to deposit today in an account earning 10% per year in order to accumulate \$10,000 after 5 years? FV ### I 6.00% n 40 PV? ### What if my interest was compounded monthly? FV \$(10,000.00) I 0.83% n 60 PV? \$6,077.89 ***Note: Change the values of any variable other than that being solved for to view changes*** Present Value:
Time Value on Excel (Using the Function (fx) Wizard) note: click on the cell next to the question mark to see the formula.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 7

Copy of timevalue - Time Value on Excel(Using the...

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

View Full Document
Ask a homework question - tutors are online