cancel
Showing results for 
Search instead for 
Did you mean: 
ipost1
New member
2 1 0 1
Message 1 of 4
942
Flag Post

Solved!

IRR calculation with uneven cash flows

HP Recommended
HP12C

I can seem to get the entries correct to calculate the IRR for the following cash flow series.  Any help would be greatly appreciated...

 

0     (748,000.00) 1        (16,845.00) 2        (16,845.00) 3        (16,845.00) 4        (16,845.00) 5        (16,845.00) 6        (16,845.00) 7        (16,845.00) 8        (16,845.00) 9        (16,845.00) 10        (16,845.00) 11        (16,845.00) 12        (16,845.00) 13        (16,845.00) 14        (16,845.00) 15        (16,845.00) 16    3,000,000.00

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions
David_M
Level 6
143 142 29 62
Message 2 of 4
Flag Post
HP Recommended

Assuming that the cash flows are evenly spaced, you essentially have the following:

1) an initial cash flow of -748000

2) a count of 15 cash flows of -16845

3) a final cash flow of 3000000 (note the sign difference from the other entries)

 

Entering the above requires 3 corresponding "steps".

 

Step 1: Enter CF(0)

748000 [CHS] g [CF0]

 

Step 2: Enter the series of 15 flows

16845 [CHS] g [CFi]

15 g [Ni]

 

Step 3: Enter the final cash flow

3000000 g [CFi]

 

Finally, compute the IRR:

f [IRR]

 

Result:

7.864933029

(displayed to 9 digits)

 

Note that negative numbers are entered by pressing the digit keys first, then [CHS] to set the sign appropriately.  I'm also assuming that the standard practice of notating negative values with parentheses applies in this situation.

View solution in original post

Tags (1)
Was this reply helpful? Yes No
3 REPLIES 3
David_M
Level 6
143 142 29 62
Message 2 of 4
Flag Post
HP Recommended

Assuming that the cash flows are evenly spaced, you essentially have the following:

1) an initial cash flow of -748000

2) a count of 15 cash flows of -16845

3) a final cash flow of 3000000 (note the sign difference from the other entries)

 

Entering the above requires 3 corresponding "steps".

 

Step 1: Enter CF(0)

748000 [CHS] g [CF0]

 

Step 2: Enter the series of 15 flows

16845 [CHS] g [CFi]

15 g [Ni]

 

Step 3: Enter the final cash flow

3000000 g [CFi]

 

Finally, compute the IRR:

f [IRR]

 

Result:

7.864933029

(displayed to 9 digits)

 

Note that negative numbers are entered by pressing the digit keys first, then [CHS] to set the sign appropriately.  I'm also assuming that the standard practice of notating negative values with parentheses applies in this situation.

View solution in original post

Tags (1)
Was this reply helpful? Yes No
Maké
Level 9
3,551 3,458 180 540
Message 3 of 4
Flag Post
HP Recommended

Hi!, Ipost1:

Here you have the necessary help ... https://support.hp.com/us-en/document/c01918635

Kind Regards !.
Have a nice day !.
@Maké (Technical Advisor Premium - HP Program Top Contributor).
Provost in HP Spanish Public Forum ... https://h30467.www3.hp.com/
Was this reply helpful? Yes No
ipost1
Author
New member
2 1 0 1
Message 4 of 4
Flag Post
HP Recommended

Perfect!  thanks...

Was this reply helpful? Yes No
† The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation