
×InformationFix Windows 10 Update Issues
Resolve Windows 10 related issues for your HP computers or printers by HP Windows 10 Support Center
InformationLearn how to upgrade to Windows 11

×InformationFix Windows 10 Update Issues
Resolve Windows 10 related issues for your HP computers or printers by HP Windows 10 Support Center
InformationLearn how to upgrade to Windows 11
 HP Community
 >
 Other Products
 >
 Calculators
 >
 IRR calculation with uneven cash flows
 Mark Topic as New
 Mark Topic as Read
 Float this Topic for Current User
 Bookmark
 Subscribe
 Mute
 Printer Friendly Page
Create an account on the HP Community to personalize your profile and ask a question
Solved!
IRR calculation with uneven cash flows
03062019 09:44 AM
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
Solved! Go to Solution.
Accepted Solutions
03062019 04:01 PM
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.
03062019 04:01 PM
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.
03072019 06:07 AM  edited 03072019 06:11 AM
Hi!, Ipost1:
Here you have the necessary help ... https://support.hp.com/usen/document/c01918635
Have a nice day !.
@Maké (Technical Advisor Premium  HP Program Top Contributor).
Provost in HP Spanish Public Forum ... https://h30467.www3.hp.com/

EnglishOpen Menu
Didn't find what you were looking for? Ask the community