Jay_very_cool wrote:
Thanks for the help. Do I use the same functions to calculate Return on
assets and return on equity? And please explain the difference between the
three.

No. And as I suspected, do not use any of the functions I mentioned to
compute ROI either. When you said ROI, I thought you might have
misused the term and intended to ask about IRR. ROI is so simple to
compute. But you follow-up question leads to suspect that you do
indeed mean ROI. The difference is whether or not "time value of
money" is taken into account. For "fundamental analysis" of a
company's financial reports, typically it is not.

I suggest that you google ROI and look at the Investopedia definition.
As an example, if you invest $1000 and it generates $500 profit over 2
years, the ROI is 50% computed as:

=50/1000

In this case, the annual ROI is 25% computed as:

=50/1000/2

Return on Assets and Return on Equity are ratios of Net Income divided
by Total Assets or Total Equity. The ratios are computed by simple
division, just like ROI above. The numerator and denominator values
come from the financial reports.

HTH.