Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Considering all your findings using the different methods of analysis on the financial statements for Target and Amazon, which company would you more likely invest

Considering all your findings using the different methods of analysis on the financial statements for Target and Amazon, which company would you more likely invest in? Your response to this question should be 3 paragraphs:

One paragraph summarizing key points of analysis on Target

One paragraph summarizing key points of analysis on Amazon

One paragraph using these results to support and rationalize your investment decision

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

Amazon Horizontal/Vertical Analysis Information Amazon 12/31/2018 % change 12/31/2017 % change 12/31/2016 31,750,000 55 20,522,000 19,334,000 57 6,647,000 9,500,000 -9 16,677,000 41 17,174,000 7 75,101,000 25 440,0000 10,464,000 11,835,000 16,047,000 60,197,000 441,000 8,339,000 11,461,000 45,781,000 98 223,000 48,866,000 29,114,000 61,797,000 14,548,000 4,110,000 11,202,000 162,648,000 25 9 22 120 24 13,350,000 3,371,000 5,085,000 131,310,000 3,784,000 854,000 3,646,000 83,402,000 57 All numbers in thousands Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Total Current Assets Long Term Investments Property Plant and Equipment Goodwill Intangible Assets Other Assets Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities Stockholders' Equity Preferred Stock Common Stock Retained Earnings Treasury Stock Capital Surplus Other Stockholder Equity Total Stockholder Equity 38,192,000 10 1,371,000 1,271 34,616,000 100,000 37 -91 25,309,000 1,056,000 6,536,000 - -24 8,565,000 7,168,000 43,816,000 68,391,000 23,495,000 27,213,000 119,099,000 13 - 5 249 15 57,883,000 24,743,000 7,792,000 103,601,000 222 53 52 7,694,000 5,099,000 64,117,000 5,000 19,625,000 -2,872,000 26,791,000 -1,035,000 43,549,000 0 127 24 25 114 57 5,0000 8,636,000 76 -2,321,000 -18 21,399,000 24 -484,000 -51 27,709,000 5,000 4,916,000 -2,822,000 17,186,000 -985,000 19,285,000 44 Amazon Balance Sheet All numbers in thousands 12/31/2018 e t 12/31/2017 of 12/31/2016 31,750,000 20 20,522,000 16 19,334,000 6 Period Ending Current Assets Cash And Cash Equivalents Short Term Investments Net Receivables Inventory Other Current Assets Total Current Assets Long Term Investments 9,500,000 16,677,000 17,174,000 6 10 11 10,464,000 11,835.000 9 16,047,000 8 6,647,000 ,339,000 11,461,000 12 en 0 418,000 75,101,000 46 440,0000 1,329.000 60,197,000 441,000 1 45 0 45,781,000 223,000 48,866,000 37 29,114,000 61,797.000 14,548,000 4,110,000 11,202,000 162,648,000 38 9 3 7 100 13,350,000 3,371,000 5,085.000 131,310,000 10 3,784,000 3 854,000 4 3,646,000 100 83,402,000 34,616,000 26 25,309,000 Property Plant and Equipment Goodwill Intangible Assets Other Assets Total Assets Current Liabilities Accounts Payable Short/Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities 38,192,000 1,371,000 23 1 100,0000 1,056,000 6,536,000 4 8,565,000 7 7,168,000 68,391.000 23,495,000 27,213,000 119,099,000 42 57,883,000 44 43,816,000 14 24,743,000 19 7 ,694,000 17 7,792,000 5 5,088,000 73103,601,000 7964,117,000 Amazon (in thousands) 12/31/2018 % change 12/31/2017 % change 232,887,000 30.93 177,866,000 30.80 139, 156,000 24.32 111,934,000 26.82 93,731,000 42.16 65,932,000 38.16 12/31/2016 135,987,000 88,265,000 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 52,177,000 27.48 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 Amazon.com Inc., Common-Size Consolidated Income Statement Dec 31, 2016 69.61% 30.39% 100.00% -64.91% 35.09% -12.96% -5.32% 12 months ended Dec 31, 2018 Dec 31, 2017 Net product sales 60.94% 66.66% Net services sales 39.06% 33.34% Net sales 100.00% 100.00% Cost of sales -59.75% -62.93% Gross profit 40.25% 37.07% Fulfillment - 14.61% - 14.20% Marketing -5.93% -5.66% Technology and content -12.38% -12.72% General and administrative -1.86% -2.07% Other operating expense, net -0.13% -0.12% Operating income 5.33% 2.31% Interest income 0.19% 0.11% Interest expense -0.61% -0.48% Other income (expense), net -0.08% 0.19% Non-operating income (expense) -0.50% -0.17% Income (loss) before income taxes 4.84% 2.14% Provision for income taxes -0.51% -0.43% Equity-method investment activity, net of tax 0.00% 0.00% Net income (loss) 4.33% 1.71% -11.83% -1.79% -0.12% 3.08% 0.07% -0.36% 0.07% -0.22% 2.86% -1.05% -0.07% 1.74% 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.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

Managerial Accounting A Focus on Ethical Decision Making

Authors: Steve Jackson, Roby Sawyers, Greg Jenkins

5th edition

324663854, 978-0324663853

Students also viewed these Accounting questions