Calculating Return on Assets (ROA) in Excel

Return on assets shows the percentage of profit that a company earns in relation to its resources. To calculate return on assets open your income statement and balance sheet. Divide net profit after tax from the income statement with total assets from the balance sheet