timevalue - Time Value on Excel (Using the Function (fx)...

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

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

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

View Full DocumentRight Arrow Icon
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 $(10,000.00) I 10.00% n 5 PV? $6,209.21 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:
Background image of page 2
Time Value on Excel (Using the Function (fx) Wizard) note: click on the cell next to the question mark to see the formula. Future Value of an Annuity:
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

timevalue - Time Value on Excel (Using the Function (fx)...

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

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