Question

In: Accounting

Considering all your findings using the different methods of analysis ( 2017 through 2018 financial statements,...

Considering all your findings using the different methods of analysis ( 2017 through 2018 financial statements, annual reports, horizontal and vertical 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

    Edit:

    Target Horizontal/Vertical Analysis Information

Solutions

Expert Solution

Horizontal analysis is a procedure in which the amounts in financial statements of 2017 will be compared with 2018 line by line in order to make related decision.

Vertical analysis is a method of analysis of financial statement where each line item is listed asa a percentage of another item ( one year i.e. 2017)

ANALYSIS ::

TARGET
HORIZONTAL ANALYSIS
DESCRIPTION 2018 2017 Difference % Change
TOTAL REVENUE     7,18,79,000.00        6,94,95,000.00      23,84,000.00 3.43
OPERATING INCOME         43,12,000.00            49,69,000.00       -6,57,000.00 -13.22
BASIC EPS 0.0053 0.0047                  0.0006 12.77
EBIT         43,12,000.00            49,69,000.00       -6,57,000.00 -13.22
VERTICAL ANALYSIS
NET INCOME            27,37,000.00 3.94
TOTAL REVENUE        6,94,95,000.00 100
KEY POINTS Operating Income and EBIT both are negative.
AMAZON
HORIZONTAL ANALYSIS
DESCRIPTION 2018 2017 Difference % Change
TOTAL REVENUE 23,28,87,000.00      17,78,66,000.00 5,50,21,000.00 30.93
OPERATING INCOME     1,24,21,000.00            41,06,000.00      83,15,000.00 202.51
BASIC EPS 20.68 6.32                14.3600 227.22
EBITDA     2,80,19,000.00        1,61,32,000.00 1,18,87,000.00 73.69
VERTICAL ANALYSIS
NET INCOME            30,33,000.00 1.71
TOTAL REVENUE      17,78,66,000.00 100
KEY POINTS Sales revenue grew by 31%
Operating Income grew by 202.5%
EBITDA grew by 74%
INVESTMENT DECISION
AMAZON is a better investment option because sales revenue growth is more than TARGET
Operating income is negative for TARGET, whereas it grew by whopping 203% for AMAZON
EBIT is negative in case of TARGET, whereas in case of AMAZON it grew by 74%.
Net income as a percentage of total revenue of AMAZON is less than TARGET, mainly due to
depreciation and interest expenses. But looking at sales growth and operating income, net income
of AMAZON will improve in coming years when depreciation and interest expenses will fall due
lower depreciation and reduced interest owing to repayment of debt.

Related Solutions

Considering all your findings using the different methods of analysis on the financial statements for Target...
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
Using the 2017 and 2018 financial statements for Apple and Bank of America, prepare two financial...
Using the 2017 and 2018 financial statements for Apple and Bank of America, prepare two financial ratios for each of the following categories: liquidity ratios, asset management ratios, and profitability ratios.
evaluate financial statements using ratio analysis
evaluate financial statements using ratio analysis
Through your analysis of the company's financial statements you have determined that during the year DRJ...
Through your analysis of the company's financial statements you have determined that during the year DRJ Enterprises issued new long-term debt of $690 million and repaid $874 million of short-term debt. It also issued new common stock of $482 million and paid cash dividends of $100 million. What was the company's total cash flow from financing activities (in $ millions)? If a net cash outflow, be certain to place a negative sign in front of your answer.
Excerpts from Hulkster Company's December 31, 2018 and 2017, financial statements are presented below: 2018 2017...
Excerpts from Hulkster Company's December 31, 2018 and 2017, financial statements are presented below: 2018 2017 Accounts receivable $ 40,000 $ 36,000 Merchandise inventory    28,000 35,000 Net sales 190,000 186,000 Cost of goods sold 114,000 108,000 Total assets 425,000 405,000 Total shareholders' equity 240,000 225,000 Net income 32,500 28,000 1. Hulkster's 2018 average collection period is____________________ 2. Hulkster's 2018 average days in inventory is (rounded)______________________ 3. Hulkster's 2018 return on assets is (rounded):___________________________ 4. What does the average collection...
The condensed financial statements of Underwood Company for the years 2017 and 2018 are presented as...
The condensed financial statements of Underwood Company for the years 2017 and 2018 are presented as follows. (Amounts in thousands.) UNDERWOOD COMPANY Balance Sheets December 31 2018 2017 Current assets Cash and cash equivalents $330 $360 Accounts receivable (net) 470 400 Inventory 460 390 Prepaid expenses 120 160 Total current assets 1,380 1,310 Investments 10 10 Property, plant, and equipment 420 380 Intangibles and other assets 530 510 Total assets $2,340 $2,210 Current liabilities $900 $790 Long-term liabilities 410 380...
Analysis: 1. The transformation of Walmart from 2017 to 2018, and the financial risks in the...
Analysis: 1. The transformation of Walmart from 2017 to 2018, and the financial risks in the future year. 2. How to deal with the problem that Walmart's transformation of e-commerce could not be noticed by all customers.
As a team, analyze consolidated financial statements and make recommendations to leadership based on your findings....
As a team, analyze consolidated financial statements and make recommendations to leadership based on your findings. accounting
FINANCIAL ANALYSIS The extracts of the financial statements of Micanfin Auto Spares (Pvt) Limited for 2017...
FINANCIAL ANALYSIS The extracts of the financial statements of Micanfin Auto Spares (Pvt) Limited for 2017 are provided below: Extract of the Statement of Comprehensive Income for the year ended 31 December 2017. Sales (credit) 1 288 000 Less cost of sales 650 000 Gross profit 638 000 Less Operating expenses 360 000 Operating profit 278 000 Less interest expense 70 000 Profit before tax 208 000 Profit after tax 180 000 Extract of Statement of Financial Position as at...
Using your Starbucks' latest financial data (2017 or the latest quarter for 2018 that’s available), present...
Using your Starbucks' latest financial data (2017 or the latest quarter for 2018 that’s available), present the data and identify the company’s cost structure: 1. What percentage is variable cost (to sales?) 2. What percentage is fixed cost (to sales?) 3. What is the gross margin? 4. Is breakeven point predictive from the info you see in the financial statements? If yes, show computations and provide a short form (2 or 3 statements) analysis. 5. Is degree of operating leverage...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT