<div>
<div class="content wysiwyg-content">
the IRR function makes sense when you take a calculation like:<br />
-1,200 - cash outlay for a new ice cream machine.<br />
+ 500 year one cash flow<br />
+300 Year two cash flow<br />
+400 Year three cash flow<br />
+400 Year four cash flow<br />
13%<br />
Okay. &nbsp;So why use the GUESS argument when I successfully figured out the IRR above without using GUESS?<br />
I'm trying to understand why you would use guess. &nbsp;Perhaps a couple examples of when to NOT use and when TO use GUESS?<br />
<br />
I googled this and came up with some fairly erudite math explanations but I'm not a math major . &nbsp;So, please
</div>
</div>


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

Excel IRR function - clueless and questions about the GUESS argument

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

The Math / Science topic primarily includes discussions of mathematics, physics, statistics and economic analysis, but also biology, chemistry and other sciences.