Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Utilize the 2017 financial statements, annual reports, horizontal and vertical analysis for Target to calculate the following ratio. Calculate the return on assets for the
Utilize the 2017 financial statements, annual reports, horizontal and vertical analysis for Target to calculate the following ratio. Calculate the return on assets for the Target Corporation. Average assets are $38,999,000. Multiple Choice Single Response.
6% 7% 8% 9%
Target Horizontal/Vertical Analysis Information Target Horizontal Analysis. Balance Sheet https://www.nasdaq.com/symbol/tet/financials?query-balance sheet Values in (0005) 213/2018 1/28/2017 $2,643,000 $0 ID 18.057.000 $1,264,000 $12,564,000 $2.512.000 30 30 $9,309,000 $1,169,000 Increasor (Decreaga Amount Percent $131.000 5.0% So 0.0% SO 0.0% $348,000 4.0% $95.000 7.5% $11.990,000 $574,000 4.6% 10 0.0% $360,000 $25,018,000 to $24,558,000 30 30T $783.000 1.4% 0.0% 0.0% 44.7% 0.0% $1,417,000 1 $634,000 so $1,568,000 $38,999,000 $37,431,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 ShortTe Debt Other Current Liabilities Total Current Liabilities Long-Term Debt Other Liabilities Deferred Liability Charles 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 1270.000 $10.999,000 1.718.000 $1.942,000 1$ 2,448,000) $0 15.09 596.3% 0.0% $13,201,000 $11,317,000 $2,059,000 $12,707.000 $11,031,000 $1,879,000 1881,000 $494,000 $286,000 $180.000 ($ 148,000) SO 3.7% 2.5% 8.7% $713,000 D -20.8% 0.0% 0.0% 3.0% $0 $27,290,000 $26,478,000 $812,000 $5,858,000 16553000 $45,000 $5,661,000 $5,884,000 ($1,000) $197,000 $669,000 0 3.4% 10.2% 0.0% 24.69 E. 4747.000 $11.709.000 $38.999,000 638,000) $10.963.000 $37,431,000 $ 109,000) $756.000 $1,568,000 4.0% Target Vertical Analysis - Balance Sheet https://www.rad.com/symbol/lg/financials?query balance sheet 2/3/2018 128.2017 Values in (000s) Period Ending Current Assets Cash and Cash Equivalents Short-Term Investments Not Receivables 52,512.000 6.75 $2.843,000 300 0.8% .0% 222 Invertory Other Grant Assets $8,657,000 $1.261.000 22 29. 322 18,309,000 $1,150,000 $11,990,000 Total Current Assets $12.564000 32.2% 32.0% 0.0% $25 01 8 000 Long-Term Assets Long-Term investments Fixed Assets Goodwill Intangible Assets Other Assets Deferred Asset Charge 30 $24.658.000 30 00% 00% 36% 102 0.0% 65.9% 0.0% 0.0% 2.1% $ 753 000 $1417,000 30 Total Abbate $38.999.000 100.0% $37,431,000 100.0% Current Liabilities Accounts Payable Short-Term Debt Current Other Current Liabilties Total Current Liabilitiee $12,90 1,000 $270000 32% 0% 110,909,000 11,718,000 29.1% 4.6% $13,201,000 33.89 112,707,000 33.9% Long-Term Dobx Other Liabliliey Deferred Liability Charges Misc, Stock Minority Interact $112700 $2,059,000 1713 000 O 20% 5.3% 1.8% 0 0% 111,331,000 1,079,000 $981,000 100 29 % 5.0% 2.3% 100% $26,478,000 70.7% Total Liabilities $27 290 000 70.0% Stock Holders Equity Common Stocks Capital Surplus Retained Earnings Treasury Stock Other Equity Total Equity 0.1% 1509 18.8% 148.000 15.661.000 $5,884.000 0.1% 15.15 15.7% $45 000 $5,058,000 $8,553,000 DO (5747000) $11.709.000 30 .19% 30.08 100.05: ($638 000) $10.263.000 $37,431,000 1.7% 29.3% Total Liabilities & Equity $38.999.000 100.0% Target Horizontal Analysis - Income Statement https://www.nasdaq.com/symbol/tat/financials?query=income statement Values in (000s) Period Ending: 2/3/2018 1/28/2017 Current Assets Total Revenue $71.879.000 $69.495.000 Cost of Reverne $51.125.ccal $49.145.000 Gross Pront $20,754,000 $20,350,000 Increase Oncrease Armount Percent $2,284,000 2013 ,3% $1,980,000 3.9% $404,000 1.9% Operating Expenses Research and Development Sales, General and Admin So 0.00% $0 $0 $14.248.CCO $13.350,000 $892.000 S2,134,000 $4.312.000 $0 54 312 000 Non-Recurring Items Other Operating Items Operating Income Add incorrerexpense tems Earnings Before Interest and Tax Interest Expense Earnings Before Tax Income Tax Minority interest Equity Earningslose Unconsolidated Subsidiary Net Income-Cont. Operations Net Income Net Income Applicable to Common Shareholders $2,025,000 $4.969.000 $0 54 969 000 51.004.DDD 83,965,000 51296.000 $0 $169,000 $657.0CC $0 $657,000 $888.0CC -$319,000 -$578,0CC $666.000 $3,646,000 $718 000 $0 6.3% 0.0% 7.7% -15,2% 0.0% 15.2% -50.8% -3.7% -80.5% 0.0% 0.0% 3.8% $0 $0 so $2.928,000 $2,934,000 $2,934,000 $2.669,000 $2,737,000 $2,737.000 $259,000 $197,000 $197,000 6.7% Target Vertical Analysis - Income Statement https://www.nasdaq.com/symbol/tet/financials?query=income-statement Values in (000s) Period Ending Ending 29/2018 282017 Current Assets Total Revenue Castor Revenue S71.879.000 $51.125.000 $20.754 000 100.00% 71.13% 20.07 $59.495.000 349.145.000 $20 350,000 100.00% 20.72% 29.28% Gross Profit Operating Expenses Resoarch and Development I S O Sales, General and Admin S14 248,000 Non-Recurring liems 50 Other Operating items $2.194,000 Operating income $4,312,000 Add incomalamarsa ham 50 Eanings Before Interest and Tax 94.312.000 Interes: pense S565.000 Earnings Before Tex $3.646.000 Income Tax 9718000 Minority interest 50 Equily Eamings Loss Unconsolidated Subsidiary SO Net Ingoma-cant, Operations $2.920.000 Nat Income | $2.934.000 Net Income Applicable to Common Shareholders $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.03% 4.00% 0 $13,356,000 SO $2025,000 $4.969.000 0 $4,969.000 $1,004,000 $3.965,000 $1.296,000 0.00% 19.22% 0.00% 2.91% 7.15% 0.00% 7.15% 1.449 5.71% 1.85% 0.00% 0.00% 3.84% 3.94% 3.24% 52.669.000 $12.737.000 52.737.000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started