- Joined
- Nov 29, 2022
- Messages
- 3
- Reaction score
- 0
- Country
Hi,
I am doing financial ratio analysis.
I've got a set of financial ratios resulted in negative values.
When I submitted it to my manager, he said that I should show it in positive values and remove the negative sign.
For example:
Cash flows from operating activities to current liabilities ratio
= Net Cash Flows From Operating Activities / Current Liabilities
= (23,670,081) / 137,863,745
= (17.17%)
So what is the right result? to be shown as resulted or to remove the sign?
If I removed the negative sign, then Excel formula will be =IFERROR((-L124/L110),"")
Please advice for right action.
Thanks
I am doing financial ratio analysis.
I've got a set of financial ratios resulted in negative values.
When I submitted it to my manager, he said that I should show it in positive values and remove the negative sign.
For example:
Cash flows from operating activities to current liabilities ratio
= Net Cash Flows From Operating Activities / Current Liabilities
= (23,670,081) / 137,863,745
= (17.17%)
Net Cash Flows From Operating Activities | (23,670,081) | |
Current Liabilities | 137,863,745 | |
Cash flows from operating activities to current liabilities ratio | = (23,670,081) / 137,863,745 = (17.17%) | |
Equation used in Excel | =IFERROR((L124/L110),"") |
So what is the right result? to be shown as resulted or to remove the sign?
If I removed the negative sign, then Excel formula will be =IFERROR((-L124/L110),"")
Please advice for right action.
Thanks