This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: o FV: Just like PV, enter as a negative number • Solving for nper: o =NPER (rate, pmt, -pv, fv, type) o PV/ FV: Make one negative and one positive o “Double your money”: #s don’t matter Just make FV 2x PV • Solving for rate: o =RATE (nper, pmt, pv, fv, type, guess) o Guess: Ignore • Weird stuff: o What portion of a monthly payment (say, the payment to period 101) goes towards the principle, and what portion goes toward interest? IPMT PPMT...
View Full Document
- Spring '08
- Corporate Finance