Ratio Analysis Dashboard

How to use this app

Enter financial statement amounts below, then click Calculate Ratios. You may leave fields blank. The app will show “Need more data” when a ratio cannot be calculated.

You can also click Load Sample Company Data to quickly test the dashboard.

Income Statement Inputs

Net sales / revenue

Cost of goods sold

Gross profit optional

Operating income

Net income

Interest expense

Balance Sheet Inputs

Cash

Accounts receivable

Inventory

Current assets

Total assets

Current liabilities

Total liabilities

Total equity

Beginning and Ending Balance Inputs

These amounts are used for ratios that require averages, such as return on assets, return on equity, inventory turnover, receivables turnover, and asset turnover.

Beginning total assets

Beginning equity

Beginning inventory

Ending inventory

Beginning accounts receivable

Ending accounts receivable

Ratio Results

Results appear after you calculate ratios. Interpret ratios carefully because industry, company strategy, accounting policies, and economic conditions matter.