|
Overview
The statistics in the IRS Corporate Ratios database are calculated from data in the Internal Revenue Service Corporation Source Book of Statistics of Income, which draws its data from IRS Form 1120. For more information about the data, contact the Internal Revenue Service or visit their web site (www.irs.gov). The tables below explain each field in the IRS Corporate Ratios database, showing the relevant row numbers and titles in the Corporation Source Book, the corresponding schedules and line numbers on Form 1120, and providing a description where relevant.
Summary
| Field Name |
Source Book
Row # & Title |
Form 1120
Schedule, Line # & Title |
Description |
| Number of Returns |
NA |
NA |
Total number of tax returns included in the statistics. |
| Net Sales (000s) |
35 Business receipts |
Main form, 1c Bal |
Gross receipts or sales less returns and allowances |
| Total Assets (000s) |
2 Total assets |
Schedule L, 15 Total assets |
|
Assets
| Field Name |
Source Book
Row # & Title |
Form 1120
Schedule, Line # & Title |
Description |
| Cash & Equivalents |
3 Cash
7 U.S. govt. obligations, total
8 Tax-exempt securities |
Schedule L, 1 Cash
Schedule L, 4 U.S. government obligations
Schedule L, 5 Tax-exempt securities |
Sum of listed items |
| Net Trade Receivables |
4 Notes and accounts receivable
5 Less: Allowance for bad debts |
Schedule L, 2a Trade notes and accounts receivable
Schedule L, 2b Less allowance for bad debts |
Trade notes and accounts receivable less allowance for bad debts |
| Inventories |
6 Inventories |
Schedule L, 3 Inventories |
|
| Other Current Assets |
9 Other current assets |
Schedule L, 6 Other current assets |
|
| Total Current Assets |
|
|
= Cash & Equivalents + Net Trade Receivables + Inventories + Other Current Assets |
| Net Fixed Assets |
13 Depreciable assets
14 Less: Accumulated depreciation
15 Depletable assets
16 Less: Accumulated depletion
17 Land |
Schedule L, 10a Buildings and other depreciable assets
Schedule L, 10b Less accumulated depreciation
Schedule L, 11a Depletable assets
Schedule L, 11b Less accumulated depletion
Schedule L, 12 Land (net of any amortization) |
Depreciation and depletion are subtracted from the sum of the other items |
| Net Intangibles |
18 Intangible assets (Amortizable)
19 Less: Accumulated amortization |
Schedule L, 13a Intangible assets (amortizable only)
Schedule L, 13b Less accumulated amortization |
Intangible assets less accumulated amortization |
| Other Non-Current Assets |
10 Loans to shareholders
11 Mortgage and real estate loans
12 Other investments
20 Other assets |
Schedule L, 7 Loans to shareholders
Schedule L, 8 Mortgage and real estate loans
Schedule L, 9 Other investments
Schedule L, 14 Other assets |
Sum of listed items |
| Total Assets |
2 Total assets |
Schedule L, 15 Total assets |
|
Liabilities
| Field Name |
Source Book
Row # & Title |
Form 1120
Schedule, Line # & Title |
Description |
| Short Term Notes Payable |
23 Mort., notes, and bonds under 1 yr |
Schedule L, 17 Mortgages, notes, bonds payable in less than 1 year |
|
| Trade Payables |
22 Accounts payable |
Schedule L, 16 Accounts payable |
|
| Other Current Liabilities |
24 Other current liabilities |
Schedule L, 18 Other current liabilities |
|
| Total Current Liabilities |
|
|
= Short Term Notes Payable + Trade Payables + Other Current Liabilities |
| Long Term Debt |
25 Loans from shareholders
26 Mort., notes, bonds, 1 yr or more |
Schedule L, 19 Loans from shareholders
Schedule L, 20 Mortgages, notes, bonds payable in 1 year or more |
Sum of listed items |
| Other Non-Current Liabilities |
27 Other liabilities |
Schedule L, 21 Other liabilities |
|
| Net Worth |
28 Net worth |
|
|
| Total Liabilities & Net Worth |
21 Total liabilities |
Schedule L, 28 Total liabilities and shareholders’ equity |
|
Income
| Field Name |
Source Book
Row # & Title |
Form 1120
Schedule, Line # & Title |
Description |
| Net Sales |
35 Business receipts |
Main form, 1c Bal |
Gross receipts or sales less returns and allowances |
| Cost of Goods Sold |
47 Cost of goods sold |
Main form, 2 Cost of goods sold |
|
| Gross Profit |
|
|
= Net Sales – Cost of Goods Sold |
| Compensation of Officers |
48 Compensation of officers |
Main form, 12 Compensation of officers |
|
| Repairs & Maintenance |
50 Repairs |
Main form, 14 Repairs and maintenance |
|
| Bad Debts |
51 Bad debts |
Main form, 15 Bad debts |
|
| Rent Paid on Business Property |
52 Rent paid on business property |
Main form, 16 Rents |
|
| Charitable Contributions |
55 Charitable contributions |
Main form, 19 Charitable contributions |
|
| Amortization |
56 Amortization |
Main form, 26 Other deductions |
|
| Depreciation |
57 Depreciation |
Main form, 20 Depreciation |
|
| Depletion |
58 Depletion |
Main form, 21 Depletion |
|
| Advertising |
59 Advertising |
Main form, 22 Advertising |
|
| Def'd Comp (Pension, Prof Shr, etc.) |
60 Pension, profit-sharing, etc., plans |
Main form, 23 Pension, profit-sharing, etc., plans |
Deferred compensation plans |
| Employee Benefit Programs |
61 Employee benefit programs |
Main form, 24 Employee benefit programs |
|
| Other Expenses |
|
|
= Total Operating Expenses – (sum of all operating expenses detailed above) |
| Total Operating Expenses |
48 Compensation of officers
49 Salaries and wages
50 Repairs
51 Bad debts
52 Rent paid on business property
53 Taxes paid
55 Charitable contributions
56 Amortization
57 Depreciation
58 Depletion
59 Advertising
60 Pension, profit-sharing, etc., plans
61 Employee benefit programs
62 Domestic production activities.
64 Other deductions |
Main form, 12 Compensation of officers
Main form, 13 Salaries and wages
Main form, 14 Repairs and maintenance
Main form, 15 Bad debts
Main form, 16 Rents
Main form, 17 Taxes and licenses
Main form, 19 Charitable contributions
Main form, 26 Other deductions
Main form, 20 Depreciation
Main form, 21 Depletion
Main form, 22 Advertising
Main form, 23 Pension, profit-sharing, etc., plans
Main form, 24 Employee benefit programs
Main form, 25 Domestic production activities
Main form, 26 Other deductions |
Sum of listed items |
| Operating Profit |
|
|
= Gross Profit – Total Operating Expenses |
| Other Revenue |
34 Total receipts
35 Business receipts |
|
= 34 Total receipts – 35 Business receipts |
| Interest Paid |
54 Interest paid |
Main form, 18 Interest |
|
| Net Loss on Non-Capital Assets |
63 Net loss, noncapital assets |
|
|
| Net Other Items as Expense |
|
|
= – (Other Revenue – Interest Paid – Net Loss on Non-Capital Assets) |
| Earnings Before Taxes (EBT) |
|
|
= Operating Profit + Net Other Items as Expense |
| Income Tax |
76 Income tax |
Schedule J, 2 Income tax |
|
| Net Income |
|
|
= EBT – Income Tax |
Analysis
| Field Name |
Formula |
| Current Ratio |
= Total Current Assets / (Short Term Notes Payable + Trade Payables + Other Current Liabilities) |
| Quick Ratio |
= (Cash & Equivalents + Net Trade Receivables) / (Short Term Notes Payable + Trade Payables + Other Current Liabilities) |
| Net Sales / Net Trade Receivables |
= Net Sales / Net Trade Receivables |
| Cost of Goods Sold / Inventories |
= Cost of Goods Sold / Inventories |
| Cost of Goods Sold / Payables |
= Cost of Goods Sold / Trade Payables |
| Net Sales / Working Capital |
= Net Sales / Working Capital |
| EBIT / Interest Paid |
= EBIT / Interest Paid |
| Net Fixed Assets / Tangible Net Worth |
= Net Fixed Assets / (Net Worth – Net Intangibles) |
| Total Liabilities / Tangible Net Worth |
= (Total Liabilities & Net Worth – Net Worth) / (Net Worth – Net Intangibles) |
| % EBT / Tangible Net Worth |
= EBT / (Net Worth – Net Intangibles) |
| % EBT / Total Assets |
= EBT / Total Assets |
| Net Sales / Net Fixed Assets |
= Net Sales / Net Fixed Assets |
| Net Sales / Total Assets |
= Net Sales / Total Assets |
| % Non-Cash Expenses / Net Sales |
= (Amortization + Depreciation + Depletion) / Net Sales |
| % Compensation / Net Sales |
= Compensation of Officers / Net Sales |
|
