Got a tricky question? Receive an answer from students like you! Try us!

Excel Analysis of Amazon and Ebay - Assignment Example

Only on StudentShare
Finance & Accounting
Pages 4 (1004 words)


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…

Extract of sample
Excel Analysis of Amazon and Ebay

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: 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 Essays

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 filtering (Ghemawat 13). The difference in one organization’s choice to use a pure play system while the other uses a brick-and-click system is too simplistic to explain the relative success of…
4 pages (1004 words)
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 as France, Germany and China. Strategy Amazon usually delivers products to the customers after transactions are complete. This usually takes a couple of days depending on diverse logistical factors…
5 pages (1255 words)
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 technique. Net Present Value The Net present value of the project is $71,467,984. The value shows the difference between the initial outflow and present value of future cash inflow (Shapiro, 1978). Therefore,…
8 pages (2008 words)
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 any 3 liability accounts from the Balance Sheet. Three liabilities accounts reflected in the balance sheet of the company are short term debt, accounts payables, and long-term debt. 7. List the names of…
6 pages (1506 words)
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 Attorney. Valley National Bank presently employs over 56 staff members in a variety of positions. The bank also provides salaries and package benefits to permanent employees. It can also be observed that…
8 pages (2008 words)
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, 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 buyers. In 1997, Amazon had achieved significant consumer interest in online shopping for over 1.5 million books that revolutionized the process of ordering products online. This led to an initial public…
10 pages (2510 words)
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 LoveFilm International Limited Etc (Amazon, 2013). The change in sales and net income from acquisition was as follows: Set Of Companies in 2011 2011 2010 Sales 48,077 34,204 Change In Sales 40.56%  …
4 pages (1004 words)