(Free42,DM42) NPV and IRR
|
06-12-2020, 08:58 AM
(This post was last modified: 06-18-2020 07:02 PM by Werner.)
Post: #1
|
|||
|
|||
(Free42,DM42) NPV and IRR
Update: replaced by this newer version that also includes MIRR
Solver program. CF0 is separate CFj is an nx2 matrix with the Cash flows (j=1..n) in column 1 and their frequency in column 2 CFj may also be a nx1 matrix, implying all Nj=1 uses subroutine Ni to calculate ((1+i)^N - 1)/i: Code: @ X Y Code: 00 { 140-Byte Prgm } example: create the 7x2 matrix [[1000 1] [2000 2] [3000 3] [4000 4] [5000 5] [6000 6] [7000 7]] Start the solver: Shift-SOLVER, NPV store the matrix in CFj store -100000 in CF0 store 0 in NPV press IRR% -> 2.0417694... hope you like it Werner 41CV†,42S,48GX,49G,DM42,DM41X,17BII,15CE,DM15L,12C,16CE |
|||
« Next Oldest | Next Newest »
|
Messages In This Thread |
(Free42,DM42) NPV and IRR - Werner - 06-12-2020 08:58 AM
RE: (Free42,DM42) NPV and IRR - Werner - 06-12-2020, 04:04 PM
RE: (Free42,DM42) NPV and IRR - Pekis - 06-12-2020, 07:14 PM
RE: (Free42,DM42) NPV and IRR - Werner - 06-15-2020, 01:16 PM
RE: (Free42,DM42) NPV and IRR - Pekis - 06-15-2020, 02:49 PM
|
User(s) browsing this thread: 1 Guest(s)