Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

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

Calculate the current ratio for Target Corporation.

94%

91%

85%

83%

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Target Vertical Analysis - Balance Sheet https://www.nasdaq.com/symbol/tgt/financials query=balance sheet Values in (000s) Period Ending: 2/3/2018 1/28/2017 Current Assets Cash and Cash Equivalents $2.643.000 6.8% $2,512,000 6.7% Short-Term Investments $0 $0 Net Receivables $0 0.0% $0 Inventory 18 657 000 22.2% 18,309,000 22 2% Other Current Assets $1284 000 32% $1,169,000 3.1% Total Current Assets $12,564.000 32.2% $11.990,000 32.0% Long-Term Assets Long-Term Investments $0 00% $0 0.0% Fixed Assets $25,016 000 64 2% 124,658,000 65.9% Goodwill 0 0% $0 0.0% Intangible Assets $0 0.0% Other Assets $1.417,000 3.6% $783,000 2.1% Deferred Asset Charges 10 0.0% 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,931.000 $270,000 33 2% 0.7% D0% 33.8% $10.989,000 $1,718,000 10 112,707,000 29.4% 4.6% 0.01% 33.9% $13,201.000 Long-Term Debt Other Liabilities Deferred Liability Charges Misc. Stocks Minority Interest $11,317,000 $2,059,000 $713,000 10 10 29.0% 53% 1.8% 0.0% 0.0% $11,031,000 $1,879,000 $361,000 $0 29.5% 5.0% 2.3% 0.0% 0.0% Total Liabilities $27,290,000 70.0% $26.478,000 70.7% Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity $45,000 $5 850 000 16 553 000 $0 $747,000) $11.709.000 0.1% 15.0% 16.8% 0.0% -1.9% $46,000 $5,661,000 35,884,000 $0 ($638,000) $10.953.000 0.1% 15.1% 15.7% 0.0% 1.7% 29.3% Total Liabilities & Equity $38,999,000 100 0% $37,431,000 100.0% 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 of Revenue Gross Profit $71,879.000 $51.125.000 S20,754.000 100.00% $69.495,000 71.13% $49.145.000 28.87% $20,350,000 100.00% 70.72% 29.28% 0.00% 0.00% 19.22% 19.82% $0 $14,248,000 $0 S2.194,000 S4,312.000 $0 0.00% 3.05% 6.00% 0.00% 6.00% Operating Expenses Research and Development Sales, General and Admin. Non-Recurring items Other Operating Items Operating Income Add'l income/expense items Eamings Before Interest and Tax Interest Expense Eamings Before Tax Income Tax Minority Interest Equity Eamings/Loss Unconsolidated Subsidiary Net Inocome-Cont. Operations Net Income Net Income Applicable to Common Shareholders 54,312,000 $666.000 $3,646,000 $718.000 $0 $0 S2.928,000 S2.934,000 $2.934,000 0.93% 5.07% 1.00% 0.00% 0.00% $0 $13,356,000 $0 $2,025,000 $4.969,000 $0 $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% 2.91% 7.15% 0.00% 7.15% 1.44% 5.71% 1.86% 0.00% 0.00% 3.84% 3.94% 3.94% 4.07% 4.08% 4.08% Target Horizontal Analysis. Balance Sheet https://www.nasdaq.com/symbol/tet/financials?query=balance sheet Values in (000s) 2/3/2018 1/28/2017 $2.643.000 Increase or (Decrease) Amount Percent $131,000 5.0% $0 0.0% $0 0.0% $348,000 4.0% $2.512.000 $0 $0 $8,309 000 $1,169 000 $0 $8 657 000 $1 264.000 $95.000 7.5% $12,564,000 $11,990,000 $574,000 4.6% $0 $0 0.0% $25,018,000 $24.658,000 $360,000 $0 $0 $634,000 $0 1.496 0.0% 0.0% 44.7% $0 $1,417 000 $783,000 0.096 $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 Assets 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.931,000 $270.000 $10.989,000 $1.718.000 $1,942,000 ($1,448,000) $0 15.0% -536.3% 30 $0 0.0% 3.7% $13,20 1,000 $11,317,000 $2059.000 $713,000 $494,000 $286,000 $180,000 2.5% 8.796 $12,707,000 $11,031,000 $1,879.000 $861,000 $0 $0 $26,478,000 -20.8% ($148,000) $0 so $812,000 $0 0.096 0.0% $27,290,000 3.096 $46,000 $5,661 000 $5,884,000 $45.000 $5.858.000 $6,553,000 $0 1747.000 $11.709.000 $38,999,000 ($1.000) $197,000 $669,000 $0 ($109.000) $756.000 $1,568,000 -2.296 3.4% 10.296 0.09 14.6% 6.596 4638.000 $10.953.000 $37,431,000 4.096 Target Horizontal Analysis - Income Statement https://www.nasdaq.com/symbol/tgt/financials?query=income-statement Values in (000s) Period Ending: 2/3/2018 1/28/2017 Increase or (Decrease Current Assets Amount Percent Total Revenue $71,879,000 $69.495,000 $2,384,000 3.3% Cost of Revenue S51.125.000 $49.145.000 $1.990.000 3.9% Gross Profit $20,754,000 $20,350,000 $404,000 1.9% Operating Expenses Research and Development Sales, General and Admin. Non-Recurring Items Other Operating Items Operating Income Add'l income/expense 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 $0 $0 $14,248,000 $13,356,000 $0 $0 $2,194.000 $2,025,000 $4,312,000 $4,969,000 $0 $0 $4,312.000 $4.969,000 $666,000 $1,004,000 $3,646,000 $3.965,000 $718.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 $259,000 $197,000 $197,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.0% 8.8% 6.7% $2,928,000 $2,669,000 $2,934,000 $2,737,000 $2,934,000 $2,737,000 6.7% Amazon (in thousands) 12/31/2018 % change 12/31/2017 % change 12/31/2016 232,887,000 30.93 177,866,000 30.80 135,987,000 139, 156,000 24.32 111,934,000 26.82 88,265,000 93,731,000 42.16 65,932,000 38.16 47,722,000 Revenue Total Revenue Cost of Revenue Gross Profit Operating Expenses Research Development Selling General and Non Recurring Others Total Operating Expenses Operating Income or Loss 28,837,000 27.48 52,177,000 33.81 22,620,000 40.63 38,992,000 42.91 16,085,000 27,284,000 296,000 38.32 220,466,000 26.88 12,421,000 202.51 214,000 28.14 173,760,000 31.84 4,106,000 -1.91 167,000 131,801,000 4,186,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby

5th edition

978-0078025914

Students also viewed these Accounting questions