An operating lease is treated like a rental contract. Neither the leased asset nor the associated liability is reported on the lessee statement of financial position, but the rights may be very similar to the rights of an owner. The lessee only records the lease payments as a rental expense in income statement.

Present Value of Future Operating Lease Payments
Analyst Adjustments for Operating Leases
Adjusted Ratios for Operating Leases (Summary)
Adjusted Total Asset Turnover
Adjusted Debt to Equity
Adjusted Return on Assets (ROA)
Adjusted Interest Coverage
Estimation of Depreciation Expense, Operating Leased Assets
Estimation of Interest Expense, Operating Lease Obligations
Present Value of Operating Lease Payments, at Beginning of Year

Target Corp., future operating lease payments

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	Total undiscounted future operating lease payments (USD $ in millions)
	Discount rate¹

	Total present value of future operating lease payments (USD $ in millions)

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

¹ Internal rate of return on capital leases

Year	Future operating lease payments (as reported)	Year	Future operating lease payments (estimated)	Present value at
2019		2019
2020		2020
2021		2021
2022		2022
2023		2023
2024 and thereafter		2024
		2025
		2026
		2027
		2028
		2029
		2030
		2031
		2032
		2033
		2034
		2035
		2036
		2037
Total:

Based on: 10-K (filing date: 2018-03-14).

Year	Future operating lease payments (as reported)	Year	Future operating lease payments (estimated)	Present value at
2018		2018
2019		2019
2020		2020
2021		2021
2022		2022
2023 and thereafter		2023
		2024
		2025
		2026
		2027
		2028
		2029
		2030
		2031
		2032
		2033
		2034
		2035
		2036
		2037
		2038
		2039
Total:

Based on: 10-K (filing date: 2017-03-08).

Year	Future operating lease payments (as reported)	Year	Future operating lease payments (estimated)	Present value at
2017		2017
2018		2018
2019		2019
2020		2020
2021		2021
2022 and thereafter		2022
		2023
		2024
		2025
		2026
		2027
		2028
		2029
		2030
		2031
		2032
		2033
		2034
		2035
		2036
		2037
		2038
		2039
		2040
Total:

Based on: 10-K (filing date: 2016-03-11).

Year	Future operating lease payments (as reported)	Year	Future operating lease payments (estimated)	Present value at
2016		2016
2017		2017
2018		2018
2019		2019
2020		2020
2021 and thereafter		2021
		2022
		2023
		2024
		2025
		2026
		2027
		2028
		2029
		2030
		2031
		2032
		2033
		2034
		2035
		2036
		2037
		2038
		2039
		2040
Total:

Based on: 10-K (filing date: 2015-03-13).

Year	Future operating lease payments (as reported)	Year	Future operating lease payments (estimated)	Present value at
2015		2015
2016		2016
2017		2017
2018		2018
2019		2019
2020 and thereafter		2020
		2021
		2022
		2023
		2024
		2025
		2026
		2027
		2028
		2029
		2030
		2031
		2032
		2033
		2034
		2035
		2036
		2037
		2038
		2039
Total:

Based on: 10-K (filing date: 2014-03-14).

Year	Future operating lease payments (as reported)	Year	Future operating lease payments (estimated)	Present value at
2014		2014
2015		2015
2016		2016
2017		2017
2018		2018
2019 and thereafter		2019
		2020
		2021
		2022
		2023
		2024
		2025
		2026
		2027
		2028
		2029
		2030
		2031
		2032
		2033
		2034
		2035
		2036
		2037
		2038
		2039
Total:

Based on: 10-K (filing date: 2013-03-20).

Target Corp., adjustments to financial data

USD $ in millions

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	Adjustment to Total Assets
	Total assets (as reported)
	Add: Operating leased assets¹
	Total assets (adjusted)
	Adjustment to Total Debt
	Total debt (as reported)
	Add: Operating lease obligations²
	Total debt (adjusted)
	Adjustment to Earnings before Interest and Tax (EBIT)
	EBIT³ (as reported)
	Add-back: Rent expense
	Less: Depreciation expense, operating leased assets⁴
	EBIT (adjusted)
	Adjustment to Net Interest Expense
	Net interest expense (as reported)
	Add: Interest expense, operating lease obligations⁵
	Net interest expense (adjusted)

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

^{1, 2} Equal to total present value of future operating lease payments. See Details »

³ See Details »

⁴ See Details »

⁵ See Details »

Target Corp., Financial Data: Reported vs. Adjusted

Target Corp., adjusted ratios

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	Total Asset Turnover¹
	Reported total asset turnover
	Adjusted total asset turnover
	Debt to Equity²
	Reported debt to equity
	Adjusted debt to equity
	Return on Assets³ (ROA)
	Reported ROA
	Adjusted ROA
	Interest Coverage⁴
	Reported interest coverage
	Adjusted interest coverage

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

¹ See Details »

² See Details »

³ See Details »

⁴ See Details »

Ratio	Description	The company
Adjusted total asset turnover	An activity ratio calculated as total revenue divided by adjusted total assets.	Target Corp.’s adjusted total asset turnover improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.
Adjusted debt-to-equity	A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity.	Target Corp.’s adjusted debt-to-equity deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.
Adjusted ROA	A profitability ratio calculated as net income divided by adjusted total assets.	Target Corp.’s adjusted ROA deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.
Adjusted interest coverage	A solvency ratio calculated as adjusted EBIT divided by adjusted interest payments.	Target Corp.’s adjusted interest coverage deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

Target Corp., Ratios: Reported vs. Adjusted

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Sales
	Total assets
	Ratio
	Total asset turnover¹
	Adjusted for Operating Leases
	Selected Financial Data (USD $ in millions)
	Sales
	Adjusted total assets
	Ratio
	Adjusted total asset turnover²

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

2018 Calculations

¹ Total asset turnover = Sales ÷ Total assets
= hidden ÷ hidden = hidden

² Adjusted total asset turnover = Sales ÷ Adjusted total assets
= hidden ÷ hidden = hidden

Ratio	Description	The company
Adjusted total asset turnover	An activity ratio calculated as total revenue divided by adjusted total assets.	Target Corp.’s adjusted total asset turnover improved from 2016 to 2017 but then deteriorated significantly from 2017 to 2018.

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Total debt
	Shareholders’ investment
	Ratio
	Debt to equity¹
	Adjusted for Operating Leases
	Selected Financial Data (USD $ in millions)
	Adjusted total debt
	Shareholders’ investment
	Ratio
	Adjusted debt to equity²

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

2018 Calculations

¹ Debt to equity = Total debt ÷ Shareholders’ investment
= hidden ÷ hidden = hidden

² Adjusted debt to equity = Adjusted total debt ÷ Shareholders’ investment
= hidden ÷ hidden = hidden

Ratio	Description	The company
Adjusted debt-to-equity	A solvency ratio calculated as adjusted total debt divided by total shareholders’ equity.	Target Corp.’s adjusted debt-to-equity deteriorated from 2016 to 2017 but then improved from 2017 to 2018 not reaching 2016 level.

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Net earnings (loss)
	Total assets
	Ratio
	ROA¹
	Adjusted for Operating Leases
	Selected Financial Data (USD $ in millions)
	Net earnings (loss)
	Adjusted total assets
	Ratio
	Adjusted ROA²

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

2018 Calculations

¹ ROA = 100 × Net earnings (loss) ÷ Total assets
= 100 × hidden ÷ hidden = hidden

² Adjusted ROA = 100 × Net earnings (loss) ÷ Adjusted total assets
= 100 × hidden ÷ hidden = hidden

Ratio	Description	The company
Adjusted ROA	A profitability ratio calculated as net income divided by adjusted total assets.	Target Corp.’s adjusted ROA deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	As Reported
	Selected Financial Data (USD $ in millions)
	Earnings before interest and tax¹ (EBIT)
	Net interest expense
	Ratio
	Interest coverage²
	Adjusted for Operating Leases
	Selected Financial Data (USD $ in millions)
	Adjusted EBIT
	Adjusted net interest expense
	Ratio
	Adjusted interest coverage³

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

¹ See Details »

2018 Calculations

² Interest coverage = EBIT ÷ Net interest expense
= hidden ÷ hidden = hidden

³ Adjusted interest coverage = Adjusted EBIT ÷ Adjusted net interest expense
= hidden ÷ hidden = hidden

Ratio	Description	The company
Adjusted interest coverage ratio	A solvency ratio calculated as adjusted EBIT divided by adjusted interest payments.	Target Corp.’s adjusted interest coverage ratio deteriorated from 2016 to 2017 but then slightly improved from 2017 to 2018.

USD $ in millions

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	Rent expense
	Less: Estimated interest expense, operating lease obligations¹
	Estimated depreciation expense, operating leased assets

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

¹ See Details »

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	Operating leased assets, at beginning of year¹ (USD $ in millions)
	Discount rate²

	Estimated interest expense, operating lease obligations³ (USD $ in millions)

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

¹ See Details »

² Internal rate of return on capital leases

2018 Calculations

³ Estimated interest expense, operating lease obligations = Operating leased assets, at beginning of year × Discount rate
= hidden × hidden = hidden

		Feb 3, 2018	Jan 28, 2017	Jan 30, 2016	Jan 31, 2015	Feb 1, 2014	Feb 2, 2013
	Total present value of future operating lease payments¹ (USD $ in millions)
	Rent expense (USD $ in millions)
	Discount rate²

	Total present value of operating lease payments, at beginning of year³ (USD $ in millions)

Based on: 10-K (filing date: 2018-03-14), 10-K (filing date: 2017-03-08), 10-K (filing date: 2016-03-11), 10-K (filing date: 2015-03-13), 10-K (filing date: 2014-03-14), 10-K (filing date: 2013-03-20).

¹ Equal to total present value of future operating lease payments. See Details »

² Internal rate of return on capital leases

2018 Calculations

³ Total present value of operating lease payments, at beginning of year = (Total present value of future operating lease payments + Rent expense) ÷ (1 + Discount rate)
= ( hidden + hidden ) ÷ (1 + hidden ) = hidden

	Target Corp.	Other companies (not purchased previously)
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Long-term Trends
Analysis
Financial Reporting Quality

	All companies
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Long-term Trends
Analysis
Financial Reporting Quality

Target Corp. (TGT)

Analysis of Operating Leases

Present Value of Future Operating Lease Payments

Analyst Adjustments for Operating Leases

Target Corp., Financial Data: Reported vs. Adjusted

Adjusted Ratios for Operating Leases (Summary)

Target Corp., Ratios: Reported vs. Adjusted

Adjusted Total Asset Turnover

Adjusted Debt to Equity

Adjusted Return on Assets (ROA)

Adjusted Interest Coverage

Estimation of Depreciation Expense, Operating Leased Assets

Estimation of Interest Expense, Operating Lease Obligations

Present Value of Operating Lease Payments, at Beginning of Year

Target Corp. (TGT)

Analysis of Operating Leases

Present Value of Future Operating Lease Payments

2018 Calculations

2017 Calculations

2016 Calculations

2015 Calculations

2014 Calculations

2013 Calculations

Analyst Adjustments for Operating Leases

Target Corp., Financial Data: Reported vs. Adjusted

Adjusted Ratios for Operating Leases (Summary)

Target Corp., Ratios: Reported vs. Adjusted

Adjusted Total Asset Turnover

Adjusted Debt to Equity

Adjusted Return on Assets (ROA)

Adjusted Interest Coverage

Estimation of Depreciation Expense, Operating Leased Assets

Estimation of Interest Expense, Operating Lease Obligations

Present Value of Operating Lease Payments, at Beginning of Year