troubleshooting Question

Excel IRR function - clueless and questions about the GUESS argument

Avatar of brothertruffle880
brothertruffle880Flag for United States of America asked on
Microsoft ExcelMath / Science
1 Comment1 Solution167 ViewsLast Modified:
the IRR function makes sense when you take a calculation like:
-1,200 - cash outlay for a new ice cream machine.
+ 500 year one cash flow
+300 Year two cash flow
+400 Year three cash flow
+400 Year four cash flow
13%
Okay.  So why use the GUESS argument when I successfully figured out the IRR above without using GUESS?
I'm trying to understand why you would use guess.  Perhaps a couple examples of when to NOT use and when TO use GUESS?

I googled this and came up with some fairly erudite math explanations but I'm not a math major .  So, please
ASKER CERTIFIED SOLUTION
wsh2

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros