DAA 2105 Lecture Notes - Lecture 17: Interest Rate
Document Summary
Pv: pmt [1 - ] 300 : 80 [ - cu tij51 (1+i)5x1 using excel function, = rate (nper, pot, pv. (fu], [type], (guess] ) praye160, we get, i : 26. 67. 1. Effective annual rate : (1+?/m)" - 1 (1 + 0. 2661) 17. 064 17305 - 1 16. 06417 305 12 -1 . B9 =rate(b2,-b3,b4,0,0,1) b d e f g rate =rate(nper, pmt, pv, [fv], [type], [guess]) a 1 present value of an asset 2 number of pmts (periods) 3. Payment amount 4 present value 5 future value 6 type (1 or 0) 7 guess 8 9 rate 60 80 300 $ $ $ 26. 67% 10 since ir annuity due. (b) answer: fv pmt : (1. 1 (1+i)" ] (+i) (1903)5] 3000 - emi (1 101. , m: 5 - 1 (1 + 0. 10) 5 $ (6) pv of 3 hotek py of choice 1 : pmt py : 1000 0. 10 pv: 10. 000 x [1 - 0. 6209213231) .
