Microsoft Excel LibreOffice Calc

salesforce.com inc. (NYSE:CRM)

Adjustments to Financial Statements

Advanced level

Adjustments to Current Assets

salesforce.com inc., adjusted current assets

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Current assets 15,963  10,683  9,290  5,997  4,347  3,550 
Adjustments
Add: Allowance for doubtful accounts 23  22  21  12  10  8 
Less: Current deferred tax assets1 —  —  —  —  —  36 
After Adjustment
Adjusted current assets 15,986  10,705  9,311  6,009  4,358  3,523 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

1 Current deferred tax assets. See details »

Adjustments to Total Assets

salesforce.com inc., adjusted total assets

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Total assets 55,126  30,737  21,010  17,585  12,771  10,693 
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 —  3,418  2,724  2,382  1,889  1,811 
Add: Allowance for doubtful accounts 23  22  21  12  10  8 
Less: Current deferred tax assets2 —  —  —  —  —  36 
Less: Noncurrent deferred tax assets3 —  104  37  29  16  9 
After Adjustment
Adjusted total assets 55,149  34,073  23,718  19,950  14,654  12,468 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Current deferred tax assets. See details »

3 Noncurrent deferred tax assets. See details »

Adjustments to Current Liabilities

salesforce.com inc., adjusted current liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Current liabilities 14,845  11,255  10,130  7,258  5,617  4,390 
Adjustments
Less: Current unearned revenue 10,662  8,564  7,095  5,506  4,268  3,287 
After Adjustment
Adjusted current liabilities 4,183  2,691  3,035  1,753  1,349  1,103 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

Adjustments to Total Liabilities

salesforce.com inc., adjusted total liabilities

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Total liabilities 21,241  15,132  11,617  10,085  7,768  6,718 
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 —  3,418  2,724  2,382  1,889  1,811 
Less: Noncurrent deferred tax liabilities2 152  —  25  24  12  38 
Less: Unearned revenue 10,662  8,564  7,095  5,543  4,292  3,321 
After Adjustment
Adjusted total liabilities 10,427  9,986  7,222  6,899  5,354  5,170 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Noncurrent deferred tax liabilities. See details »

Adjustments to Stockholders’ Equity

salesforce.com inc., adjusted stockholders’ equity

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Stockholders’ equity 33,885  15,605  9,388  7,500  5,003  3,975 
Adjustments
Less: Net deferred tax assets (liabilities)1 (152) 104  12  5  4  7 
Add: Allowance for doubtful accounts 23  22  21  12  10  8 
Add: Unearned revenue 10,662  8,564  7,095  5,543  4,292  3,321 
After Adjustment
Adjusted stockholders’ equity 44,722  24,087  16,493  13,050  9,301  7,298 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

1 Net deferred tax assets (liabilities). See details »

Adjustments to Capitalization Table

salesforce.com inc., adjusted capitalization table

US$ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Current portion of debt 4  3  1,025  —  —  — 
Noncurrent debt, excluding current portion 2,673  3,173  695  2,008  1,294  1,371 
Total reported debt 2,677  3,176  1,719  2,008  1,294  1,371 
Stockholders’ equity 33,885  15,605  9,388  7,500  5,003  3,975 
Total reported capital 36,562  18,781  11,108  9,509  6,297  5,346 
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 —  3,418  2,724  2,382  1,889  1,811 
Add: Operating lease liabilities, current2 750  —  —  —  —  — 
Add: Noncurrent operating lease liabilities3 2,445  —  —  —  —  — 
Adjusted total debt 5,872  6,594  4,444  4,390  3,183  3,182 
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 (152) 104  12  5  4  7 
Add: Allowance for doubtful accounts 23  22  21  12  10  8 
Add: Unearned revenue 10,662  8,564  7,095  5,543  4,292  3,321 
Adjusted stockholders’ equity 44,722  24,087  16,493  13,050  9,301  7,298 
After Adjustment
Adjusted total capital 50,594  30,681  20,936  17,440  12,483  10,480 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Operating lease liabilities, current. See details »

3 Noncurrent operating lease liabilities. See details »

4 Net deferred tax assets (liabilities). See details »

Adjustments to Revenues

salesforce.com inc., adjusted revenues

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Revenues 17,098  13,282  10,480  8,392  6,667  5,374 
Adjustment
Add: Increase (decrease) in unearned revenue 2,098  1,569  1,552  1,251  970  799 
After Adjustment
Adjusted revenues 19,196  14,851  12,032  9,643  7,637  6,173 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

Adjustments to Reported Income

salesforce.com inc., adjusted net income (loss)

US$ in millions

Microsoft Excel LibreOffice Calc
12 months ended Jan 31, 2020 Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015
As Reported
Net income (loss) 126  1,110  127  180  (47) (263)
Adjustments
Add: Deferred income tax expense (benefit)1 27  (283) (6) (231) 1  (3)
Add: Increase (decrease) in allowance for doubtful accounts 1  1  9  2  2  3 
Add: Increase (decrease) in unearned revenue 2,098  1,569  1,552  1,251  970  799 
Add: Other comprehensive income (loss), net (35) (39) 49  (26) (26) (42)
After Adjustment
Adjusted net income (loss) 2,217  2,358  1,731  1,176  900  495 

Based on: 10-K (filing date: 2020-03-05), 10-K (filing date: 2019-03-08), 10-K (filing date: 2018-03-09), 10-K (filing date: 2017-03-06), 10-K (filing date: 2016-03-07), 10-K (filing date: 2015-03-06).

1 Deferred income tax expense (benefit). See details »