Utilize the 2017 financial statements, annual reports, horizontal and vertical analysis for Target to calculate the following ratio. Calculate the operating margin for Target Corporation.

5.9% 7% 3% 10%

Target Horizontal/Vertical Analysis Information Target Horizontal Analysis. Balance Sheet https://www.Desdeq.com/symbol/s5t/encials?query-balance sheet Values Jn (000) 2/3/2018 1/28/2017 $2,642000 12.532.000 Increas or IDeere 838) Amount Parcent $131,000 5.GA $0 . 0.0% 3. Period Ending: Current Assets Cash and cash Short-Term Net Receivables Inventory Other Current Assets 3 Total Current 50 So $348,000 4.0% 38.657 000 $1.284.000 $12,564,000 18.309,000 41.109.000 $95.000 75% $11.990,000 $574,000 25.018000 $24.659.000 $0 $350,000 $0 1.49 $1,417,000 $763,000 $634,000 $0 $30,999,000 $37,431,000 $1,568,000 $ 12,031,000 $270.000 $10.999,000 $1.718.000 15.09 -526.3% $1,942.000 $1.449.000) SO $0 13.7% Long-Term Assats Long-Torm Investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charges Total Assets Current Liabilities Accounte Payable Short-Term Debt Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Daforred Liability Charges Misc. Stocks Minority Interest Total Liabilities Stock Holders Equity Comman Stocks Capital Surplus Retained Earnings Treasury Stock citar Equity Total Equity Total Liabilities & ---Equity. $13,20 1,000 $ 11317,000 $2,059,000 $713,000 $12.707,000 $11.031.000 $1879000 $801.000 $494,000 $296,000 $180.000 $148.000) 30 8.0 SO $27,290,000 $26,478,000 $412,000 45,000 $5.858.000 $6.553,000 $46,000 $5,681,000 $5884000 $0 ASS.000) $10.963.000 $37,431,000 (1147_600 111.709.000 $38.999,000 $197,000 $569.00 $0 ASTRO S756.00 $1,568.000 3.4% 10.7 0.00 14. 5.5% 4.0% Target Vertical Analysis - Balance Sheet intes://www.rasulay.com/symbol/tgt/financials?query balance sheet Values in (000s) Period Ending Current Assets 2.3.2018 122/2017 $20-13.30 $2,592,000 Short-Term investments Net Receivables 0 0 $0 .33 53 00% 222% 32 32.2% Inventory Oder Current Ass 131 264.000 $12.634.000 12,305,000 9.22.03. $21.990,000 31% 32.0% Total Current Assets Long-Term Assets Long Term Investments Pred Assets Good Intangible Assets Other Ansato Deferred Asset Charges 1 $3 $20 Dis 0cl 1.2% 324658 000 59 0.0% 64.9% 0.1% 0.0% 2.18 0.0% $1415.000 0.3% 3.6% 00 $763.000 138,900,000 100.0% $37.431,000 10X1.0% Total neste Current Liabities Accounts Payable Short-Term Dust Current Other Current Liabilities Total Current Liabilities 1 842.837000 3 1210000 7 110.999.000 155,118,000 29.4% 4.6% in $0 193 2010 39 12 75170 33.9% 41.317003 29.5% Long-Term Debt Oltar Liabilities Deferred by Daarges Mise, Stocks Minority interest #2059.000 $13.000 5.3% 1.8% 51,870,000 $861.000 2.3% 0.0% Total liabilities $27 290,000 70.0% $28,478,000 70.7% Stock Holders Equty Commor Sleeky Capital Gurplus Rarained Earnings Traxury Stock Other Equity ang Y $5 858,000 $8.553.600 $0 14100 15.% 169 55,62 1,000 4 .00 0.15 15.1% 15.7% 0.0 1 $11.709.999 $38,999.000 22.3% 150.- 19253,000 $97,431,000 29.3% 100.0% Total Wablitas & Equity Target Horizontal Analysis - Income Statement https://www.nasdaq.com/symbol/tt/financials?query=income-statement 2122013 /2017 T Values in (000s) Period od Current Assets Total Revenue Cost of Raw 571.070.000 S60 AO5.000 $31.121.0AL 43.145.000 520,754,000 520.350,000 EASER OR DESIS Armour 1 Percent 9.384.000 3.2% $2.980.000 cena 30 $404.000 Dress Pront 1.5% QUE $14.245.000 3.335.000 S9S2.000 32.184.000 54,312,000 82.625.000 $4.999.00 $250,000 $57.000 -152% 0.096 -15.2% $250.000 Operating Expenses Research and Developenent Sales, General and Admin Non-Recurring Items Ocher Operating terms Operating Income Add income persone Garring Doforo interested Tax erest Bepers Parings Before Tax Meme Tax Menery interest Equity Earringelees Unconsoldated Subsidiary Not Inoc one-Cont. Operations Net Income Net home Applicable to Comune Shareholders $4.312,000 S666.000 59.646.000 5718,000 $4.369.500 $1,004,00D 33.965.000 $1296.900 -2.7% -$319,000 $578,000 SD $ 896 899.00 $2.934.000 52,934,000 2,569,000 $2.737,000 32.787,000 $250.000 $197.000 $197,000 6.7% Target Vertical Analysis - Income Statement https://www.sumy.com/symbol/tet/tinarcals?query=income-statement Values in (000) Parlod Ending 2/3/2013 128/2017 Gurant Avonta Total Revenue Contofranus Gross Pratt S71.879.DCO $51.175.DAD $20.75-4,000 190 0% 21.12% 28.07% 969495.000 145.00 $20,350.000 100.00% 70.72% 29.28 0 .00% 1 9.82% 0.00% 3.05% 0 0.com 513 356,000 10.22% Soo .com $2.038.500 2.91% 34989.2007.15 2. Operating penses Rosearch and Ovalament 30 Sea General and Adre in 514.248 OCO Non-Becuring terus other Operating nens $2.194,000 adering income S431200 Mer incontra Earnings Before Ferest and loc $4,312.000 Interest pense 3908.3CO $3.846.000 ancome T 5718 CO interest $ TuryEarningscosa Unconsoleled Subsidiary 30 Nationscent Operations 52 99 000 Intal Incom 82.594.002 rerinceme a t to come on Shareholders 33.834.000 5.00% e 50 100% 209 0.29% M 54.969.000 7.23% S1004.coo 1.449 53 965 500 5.71% $1.295.000 1.965 10.COM $0 0.0016 52299.cog! 2.845 5 2.7327.000 24% $2,737.2003.94% 4792 4.08%