Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How can I calculate ROA for a massive amount of data set in excel ? I know that to find ROA you divide Net Income/Total
How can I calculate ROA for a massive amount of data set in excel ? I know that to find ROA you divide Net Income/Total Assets but how can I do it for 15000 companies in the same time using excel?
Nm A B Total Net 1 Companies Assets Income 1 1501.042 44.628 2 1343.6 -474.3 4 3 77.515 -15.032 5 4 2051.492 142.858 6 5 11808.155 68.33 7 6 1321.456 112.601 8 7 52416.623 5745.838 9 8 40.952 -1.885 10 9 205.464 8.629 11 10 2051.721 30.291 12 13 14 8Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started