Utilize the 2017 financial statements, annual reports, horizontal and vertical analysis for Target to calculate the following ratio. Calculate the profit margin for Target Corporation. Multiple Choice Single Response. O O O O Target Horizontal/Vertical Analysis Information Target Horizontal Analysis - Balance Sheet https://www.nasdaq.com/symbol/tgt/financials?query=balance sheet Values in (0005) 21312018 1/28/2017 $2.643.000 $2.512.000 SO Increase or (Decrease Amount Percent $131,000 5.0% 0.0% 0.0% $349,000 40% $95.000 7.5% $0 $0 $ 0 $3,657,000 $1.264.000 $8,309,000 $1.169 DDD $12,564,000 $11,990,000 $574,000 4.6% $0 so 0.0% $25,018,000 $0 $24,650,000 $0 $360,000 SO so $634,000 1.4% 0.0% 0.0% 44.7% $1,417,000 $783,000 so $38,999,000 $37,431,000 $1,568,000 4.0% Period Ending: Current Assets Cash and Cash Short-Term Net Receivables Inventory Other Current Assets Total Current Ar ats Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charges Total Assets Current Liabilities Accounts Payable Short-Term Debt Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Liability Charges Misc. Stocks Minority Interest Total Liabilities Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity Total Liabilities & Equity $ 12,93 1,000 $270.000 $0 $10 989,000 $1.718.00DI $1,942,000 ($1,448,000) $0 15.0% -536.3% $0 0.0% 3.7% $13,20 1,000 $11,317,000 $2,059,000 $713,000 $0 $12,707,000 $11,031,000 $1,879,00D $494,000 $286,000 $180,000 ($148,000) $0 2.5% 8.7% $861,00D -20.8% $0 10 $26,478,000 so 0.0% 0.0% 3.0% $27,290,000 $812,000 $46.000 $5,061,00D $5,884,0DD -2.2% 3.4% 10.296 $45,ODO $5,858,000 $6,553,000 $ 0 $747,000 $11.709,000 $38,999,000 ($1.000) $197.000 $669,000 so ($109,000 $756,000 $1,569,000 $638,000) $10.953,000 $37,431,000 14.696 6.5% 4.0% Target Vertical Analysis - Balance Sheet https://www.nasdaq.com/symbol/tgt/financials?query=balance-sheet 2/3/2018 1/28/2017 Values in (000s) Period Ending: Current Assets Cash and Cash Equivalents Short-Term Investments Net Receivables $2,643,000 68% $2,512,000 6.796 Inventory Other Current Assets $8,657,000 $1,264,000 $12,564,000 0.0% 22.2% 32% 32.2% 18,309,000 31,169.000 $11,990,000 0.0% 22.2% 3.1% Total Current Assets 32.0% 10 $25,018,000 $24,658,00D Long-Term Assets Long-Term Investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charges 0.0% 65.9% 0.0% 0.0% 2.1% 0.0% 00% 00% 36% 0 $1,417,000 $0 $783,000 Total Assets $38,999,000 100.0% $37,431,000 100.0% Current Liabilities Accounts Payable Short-Term Debt Current Other Current Liabilities Total Current Liabilities $ 12,93 1,00D $270,000 33.2% 0.7% $10,989, DOD $1,718,00D 29.4% 4.6% 0.0% 33.9% $13,20 1,000 33.8% $12,707,000 Long-Term Debt Other Liabilities Deferred Liability Charges Misc. Stocks Minority Interest $11,317,000 $2,059,000 $ 713,000 29.0% 53% 18% $11,031,000 $1,879,000 $861,000 29.5% 5.0% 2.3% 0.0% 0.0% 70.7% Total Liabilities $27,290,000 70.0% $26,478,000 Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity $45,000 $5,858,000 $6,553,000 0.1% 15.0% 16.8% 46,000 $5,661,DOD $5,884,000 0.1% 15.1% 15.7% 0.0% - 1.7% 29.3% ($ 747.000] $11.709,000 -1.9% 30.0% 100.0% ($638,000) $10.953.000 Total Liabilities & Equity $38,999,000 37,431,000 100.0% Target Horizontal Analysis - Income Statement https://www.nasdaq.com/symbol/tgt/financials?query=income-statement 2/3/2018 1/28/2017| Values in (000s) Period Ending: Current Assets Total Revenue Cost of Revenue $71,879,000 $69.495.000 $51.125 000 $49.145.000 Increase or (Decrease Amount Percent $2,384.000 1 3 .3% $1.980.000 3.9% $404,000 1.9% Gross Profit $20,754,000 $20,350,000 | Operating Expenses Research and Development Sales, General and Admin Non-Recurring Items Other Operating Items Operating Income Add'l incomelexpense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Minority Interest Equity Earnings/Loss Unconsolidated Subsidiary Net Inocome-Cont. Operations Net Income Net Income Applicable to Common Shareholders SO $14,248,000 $0 $2,194,000 $4,312,000 So $4,312,000 $666,000 $3,646,000 $718,000 $0 $0 $13,356,000 SO $2.025,000 $4,969,000 So $4,969,000 $1,004,000 $3.965,000 $1.296,000 $0 $0 $0 $892,000 $0 $169,000 -$657,000 $0 $657,000 $338,000 $319,000 $578,000 0.0% 6.3% 0.0% 7.7% -15.2% 0.0% -15.2% -50.8% -8.7% -80.5% 0.0% 0.0% $0 $2,928,000 $2,934,000 $2,669,000 $2,737,000 SO $259,000 $197,000 $197,000 8.8% 6.7% $2,934,000 $2,737,000 6.7% Target Vertical Analysis - Income Statement https://www.nasdaq.com/symbol/tgt/financials?query=income-statement Values in (000s) Period Ending: 2/3/2018 1/28/2017 Current Assets Total Revenue Cost or Revenue Gross Profit $71,879.000 $51.125.000 $20,754,000 100.00% 71.13% 28.87% $69,495,000 549.145.000 $20,350,000 100.00% 70.72% 29.28% Operating Expenses $0 $13,356,000 $0 $2,025,000 $4.969.000 Research and Development Sales. General and Admin Non-Recurring items Other Operating Items Operating Income Adan incomalexpense items Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Minority Interest Equity Eamings/Loss Unconsolidated Subsidiary sidiary Net Inocome-Cont, Operations Net Income Net Income Applicable to Common Shareholders $0 $14,248.000 $0 $2,194,000 $4,312,000 $0 $4.312,000 $666,000 $3,646,000 $718,000 $0 $0 $2.928,000 $2.934,000 $2.934,000 0.00% 19.82% 0.00% 3.05% 6.00% 0.00% 6.00% 0.93% 5.07% 1.00% 0.00% 0.00% 4.07% 4.08% 4.08% $4.969.000 $1,004,000 $3,965,000 $1.296,000 $0 $0 $2.669.000 $2.737.000 $2,737,000 0.00% 19.22% 0.00% 2.91% 7.15% 0.00% 7.15% 1.44% 5.71% 1.86% 0.00% 0.00% 3.84% 3.94%