Microsoft Excel LibreOffice Calc

Adjustments to Financial Statements

Difficulty: Advanced


Adjustments to Current Assets

salesforce.com inc., adjusted current assets

USD $ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
As Reported
Current assets 10,683  9,290  5,997  4,347  3,550  2,680 
Adjustments
Add: Allowance for doubtful accounts 22  21  12  10 
Less: Current deferred tax assets1 –  –  –  –  36  49 
After Adjustment
Adjusted current assets 10,705  9,311  6,009  4,358  3,523  2,636 

Based on: 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), 10-K (filing date: 2014-03-05).

1 Current deferred tax assets. See Details »


Adjustments to Total Assets

salesforce.com inc., adjusted total assets

USD $ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
As Reported
Total assets 30,737  21,010  17,585  12,771  10,693  9,153 
Adjustments
Add: Operating leased assets1 3,418  2,724  2,382  1,889  1,811  1,154 
Add: Allowance for doubtful accounts 22  21  12  10 
Less: Current deferred tax assets2 –  –  –  –  36  49 
Less: Noncurrent deferred tax assets3 104  37  29  16  10 
After Adjustment
Adjusted total assets 34,073  23,718  19,950  14,654  12,468  10,253 

Based on: 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), 10-K (filing date: 2014-03-05).

1 Operating leased assets. 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

USD $ in millions

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

Based on: 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), 10-K (filing date: 2014-03-05).


Adjustments to Total Liabilities

salesforce.com inc., adjusted total liabilities

USD $ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
As Reported
Total liabilities 15,132  11,617  10,085  7,768  6,718  6,088 
Adjustments
Add: Operating lease obligations1 3,418  2,724  2,382  1,889  1,811  1,154 
Less: Noncurrent deferred tax liabilities2 –  25  24  12  38  62 
Less: Unearned revenue 8,564  7,095  5,543  4,292  3,321  2,522 
After Adjustment
Adjusted total liabilities 9,986  7,222  6,899  5,354  5,170  4,658 

Based on: 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), 10-K (filing date: 2014-03-05).

1 Operating lease obligations. See Details »

2 Noncurrent deferred tax liabilities. See Details »


Adjustments to Stockholders’ Equity

salesforce.com inc., adjusted stockholders’ equity

USD $ in millions

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

Based on: 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), 10-K (filing date: 2014-03-05).

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


Adjustments to Capitalization Table

salesforce.com inc., adjusted capitalization table

USD $ in millions

Microsoft Excel LibreOffice Calc
Jan 31, 2019 Jan 31, 2018 Jan 31, 2017 Jan 31, 2016 Jan 31, 2015 Jan 31, 2014
As Reported
Current portion of debt 1,025  –  –  –  572 
Noncurrent debt, excluding current portion 3,173  695  2,008  1,294  1,371  1,302 
Total reported debt 3,176  1,719  2,008  1,294  1,371  1,874 
Stockholders’ equity 15,605  9,388  7,500  5,003  3,975  3,039 
Total reported capital 18,781  11,108  9,509  6,297  5,346  4,913 
Adjustments to Debt
Add: Operating lease obligations1 3,418  2,724  2,382  1,889  1,811  1,154 
Adjusted total debt 6,594  4,444  4,390  3,183  3,182  3,029 
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2 104  12  (3)
Add: Allowance for doubtful accounts 22  21  12  10 
Add: Unearned revenue 8,564  7,095  5,543  4,292  3,321  2,522 
Adjusted stockholders’ equity 24,087  16,493  13,050  9,301  7,298  5,568 
After Adjustment
Adjusted total capital 30,681  20,936  17,440  12,483  10,480  8,597 

Based on: 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), 10-K (filing date: 2014-03-05).

1 Operating lease obligations. See Details »

2 Net deferred tax assets (liabilities). See Details »


Adjustments to Revenues

salesforce.com inc., adjusted revenues

USD $ in millions

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

Based on: 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), 10-K (filing date: 2014-03-05).


Adjustments to Reported Income

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

USD $ in millions

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

Based on: 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), 10-K (filing date: 2014-03-05).

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