Excel Analysis of Amazon and Ebay

Excel Analysis of Amazon and Ebay Assignment example
Masters
Assignment
Finance & Accounting
Pages 4 (1004 words)
Download 0
Excel Analysis of Amazon and EBay Name: Institution: Course: Tutor: Date: Summary regarding the ratios of the two companies Amazon is one of the world largest public multinational companies situated in the United States at Washington. The company was established in 1994, under interment retail industry…

Introduction

Therefore, the study has provided computation ratios for the two companies as indicated in the two attached spread sheet files attached as well as a summary of ratios. AMAZON FINANCIAL RATIOS Fins AS Version 2008010211 Ratios - ending Company: Amazon.com Analyst: Nanyail Smoke Most Recent Year Available: 2012 Years Available for: Income Statement (1-5) 5 Balance Sheet (1-5) 5 * EOY values instead of averages - - - - - - Liquidity 2012 2011 2010 2009 2008 - - - - - - Days' Sales in Receivables 20.10 19.52 16.94 14.71 15.75 * Accounts Receivable Turnover 18.16 18.70 21.55 24.81 23.18 * A/R Turnover in Days 20.10 19.52 16.94 14.71 15.75 Days' Sales in Inventory 47.88 48.87 44.00 41.75 34.28 * Inventory Turnover 7.62 7.47 8.30 8.74 10.65 * Inventory Turnover in Days 47.88 48.87 44.00 41.75 34.28 * Operating Cycle 67.98 68.38 60.94 56.47 50.03 Working Capital 2,294 2,594 3,375 2,361 1,330 Current Ratio 1.12 1.17 1.33 1.32 1.28 Acid Test 0.78 0.82 1.00 0.99 0.94 Cash Ratio 0.60 0.64 0.84 0.86 0.79 * Sales to Working Capital 26.63 18.53 10.13 10.38 14.41 Cash Flow/Cur. Mat. ...
Download paper
Not exactly what you need?

Related papers

Amazon case study
However, when we evaluate Amazon’s business model and the operational strategies that underlie it they greatly resemble those of its key competitor Barnes & Noble. Barnes & Noble also used its economies of scale to support low-cost leadership, it broke new ground by developing software that would enable its customers personalize their web pages and also enjoy the results of collaborative…
Reseach Paper on Amazon
However, when it was founded in 1994, it was a bookseller. In addition, it manufactures electronics, such as the Amazon Kindle, for clients and provides cloud-computing services. Additional revenue for the company is from marketing services. This is mainly by online advertisement and co-branding of credit cards (Schneider, 46). The company operates in the United States and in other countries such…
Finance (Analysis)
However using discounted payback period, the company would be able to recover its initial outflow of the project in 3.47 years. The discounted payback period gives more accurate picture of the project feasibility because it takes present value of the future cash inflows (Trahan, and Gitman, 1995). Considering the investment required, the project should be accepted using the payback period…
SEC project EBAY Inc.
The Independent Auditors Report contained in the annual report of the company in 2012 was prepared by PricewaterhouseCoopers. PricewaterhouseCoopers is the auditor of the company. 5. Is the company on a calendar or fiscal year? The company’s accounting cycle is based on the calendar year which means they reflect economic activity from January 1, 2012 to December 31, 2012. 6. List the names of…
SWOT Analysis
Valley National Bank (VNB), as one of the leading regional banks, offers better opportunities for professionals in banking for building their career. In the context of opportunities available in Valley National Bank, there are diverse job opportunities such as Benefit Specialists, Branch Sales Manager, Consumer Loans Quality Analyst, Loan Review Manager, Secondary Marketing Manager and Senior…
Investment Analysis Report: Amazon versus eBay
This report analyzes the micro- and macro-level factors that will determine which firm is the most viable for investment opportunity. Company Backgrounds Since the time of its initial public offering, Amazon.com has evolved from primarily an online book and music seller to an extremely diversified business that now offers a broad range of products and services to business and consumer segment…
Amazon Acquisition and Equity Investment
2- SET OF COMPANIES ACQUIRED BY AMAZON IN 2011 In 2011, set of companies were acquired with price of US $771 million by Amazon (Amazon, 2011). None of the companies are defined specifically but all are aimed at market development for Amazon for increasing customer base as well as sales channel increase in portfolio. Two of the companies included Marshall Cavendish US Children’s Books Titles and…