Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 8

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Law And Economics Of Patent Damages, Antitrust, And Legal Process

Authors: James Langenfeld, Frank Fagan, Samuel Clark

2nd Edition

1800710259, 9781800710252

More Books

Students also viewed these Accounting questions