Another Example

Another Example - 5 Using Excel • If you invest $25,000...

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

View Full Document Right Arrow Icon
Another Example You invested $20,000, 15 years ago in an account that pays 8%, with interest compounded quarterly . What do you have in your account today? How much interest did you earn? Solve for FV 1
Background image of page 1

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

View Full Document Right Arrow Icon
Intra-year Example What is the effective rate for a period less than one year? You will inherit $10,000 in 6 months. What is the equivalent value 3 months and 1 year from today if interest is compounded monthly? 2 0 1 2 3 6 12 $10,000 $ $ monthly periods r = .12
Background image of page 2
Intra-year Example What kind of rate do we need? A periodic monthly rate. “12% compounded monthly,” so… rm = 0.12/12 = 0.01 or 1% What is the value of the $10,000 at t =12? FV = $10,000(1 + 0.01)6 = $10,615.20 3
Background image of page 3

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

View Full Document Right Arrow Icon
Be Careful… If a problem says… “6% compounded monthly …the effective monthly rate is 6% / 12 = .5% or . 005 4
Background image of page 4
Using Excel
Background image of page 5

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

View Full Document Right Arrow Icon
Background image of page 6
Background image of page 7

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

View Full Document Right Arrow Icon
Background image of page 8
Background image of page 9

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

View Full Document Right Arrow Icon
Background image of page 10
Background image of page 11

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

View Full Document Right Arrow Icon
Background image of page 12
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 5 Using Excel • If you invest $25,000 at 12%, how long will it take to have $50,000? – Unlike your calculator, 6 Using Excel • The missing variable is calculated. 7 Using Excel • Solve for the missing variable: 8 Final Thoughts • There is an inverse relationship between rates and the present value: – The higher the discount rate, the lower the present value. – The lower the discount rate, the higher the present value. – Basically, the more (less) interest you earn, the less (more) money you have to invest 9 Future Value Table - Appendix 10 Present Value Table – Appendix 11 To Do’s • Review Chapter 3 and Chapter 3 slides. • Do Prepping for Exams and Problems in book or MyFinance Lab. • Read Chapter 4 and Chapter 4 slides. 12...
View Full Document

{[ snackBarMessage ]}

Page1 / 12

Another Example - 5 Using Excel • If you invest $25,000...

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

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