Excel Analysis of Amazon and Ebay - Assignment Example

Summary

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…

Download full paper File format: .doc, available for editing

GRAB THE BEST PAPER94% of users find it useful

Read Text Preview

Subject: Finance & Accounting
Type: Assignment
Level: Masters
Pages: 4 (1000 words)
Downloads: 2
Author: ezboncak

Extract of sample "Excel Analysis of Amazon and Ebay"

Download file to see previous pages

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. of Debt & NP #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! - - - - - - long-term debt-paying ability 2012 2011 2010 2009 2008 - - - - - - Times Interest Earned 4.39 11.75 51.20 35.15 13.69 Fixed Charge Coverage 3.52 11.75 51.20 35.15 13.69 Debt Ratio 74.84% 69.31% 63.48% 62.27% 68.53% Debt/Equity 297.40% 225.87% #DIV/0! 162.75% 211.15% Debt to Tangible Net Worth 431.97% 301.98% -884.58% 212.68% 252.55% Cash Flow/Total Debt 17.16% 22.28% 29.29% 38.48% 28.48% - - - - - - Profitability 2012 2011 2010 2009 2008 - - - - - - Net Profit Margin 0.19% 1.34% 3.35% 3.70% 3.

41% * Total Asset Turnover 1.88 1.90 1.82 1.78 2.33 * Return on Assets 0.36% 2.54% 6.09% 6.61% 7.94% Operating Income Margin 1.11% 1.79% 4.11% 4.61% 4.39% * Operating Asset Turnover 2.04 2.06 1.96 1.96 2.51 * Return on Operating Assets 2.26% 3.70% 8.07% 9.04% 11.01% * Sales to Fixed Assets 8.65 10.88 14.17 19.00 22.44 * Return on Investment 1.53% 6.82% 62.11% 11.23% 20.32% * Return on Total Equity #N/A 8.13% #DIV/0! 17.16% 24.14% * Return on Common Equity #N/A 8.13% #DIV/0! 17.16% 24.14% Gross Profit Margin 24.75% 22.44% 22.35% 22.57% 22.

28% - - - - - - Investor Analysis 2012 2011 2010 2009 2008 - - - - - - Degree of Financial Leverage 1.17 1.07 1.03 1.03 1.08 Earnings per Share - - - - - Price/Earnings Ratio #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Percentage of Earnings Retained #N/A 100.00% 100.00% 100.00% 100.00% Dividend Payout #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Dividend Yield #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Book Value per Share 18.04 17.05 #DIV/0! #DIV/0! #DIV/0! Materiality of Options #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Oper. Cash Flow per Share 9.22 8.47 7.66 7.45 3.72 Oper. Cash Flow/Cash Dividends #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Year-end Market Price 0.00 0.00 0.00 0.00 0.00 EBAY 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 87.26 80.54 63.27 14.71 15.75 * Accounts Receivable Turnover 4.18 4.53 5.77 24.81 23.18 * A/R Turnover in Days 87.26 80.54 63.27 14.71 15.

75 Days' Sales in Inventory 522.13 526.46 455.82 41.75 34.28 * Inventory Turnover 0.70 0.69 0.80

...Download file to see next pages Read More

Cite this document

APA
MLA
CHICAGO

(“Excel Analysis of Amazon and Ebay Assignment Example | Topics and Well Written Essays - 1000 words”, n.d.)
Excel Analysis of Amazon and Ebay Assignment Example | Topics and Well Written Essays - 1000 words. Retrieved from https://studentshare.org/finance-accounting/1484496-excel-analysis-of-amazon-and-ebay

(Excel Analysis of Amazon and Ebay Assignment Example | Topics and Well Written Essays - 1000 Words)
Excel Analysis of Amazon and Ebay Assignment Example | Topics and Well Written Essays - 1000 Words. https://studentshare.org/finance-accounting/1484496-excel-analysis-of-amazon-and-ebay.

“Excel Analysis of Amazon and Ebay Assignment Example | Topics and Well Written Essays - 1000 Words”, n.d. https://studentshare.org/finance-accounting/1484496-excel-analysis-of-amazon-and-ebay.

Cited: 0 times

CHECK THESE SAMPLES OF Excel Analysis of Amazon and Ebay

How does online shoppers' behaviour differ from traditional shoppers

Some fulfils their necessities from shopping while some get something more from shopping.... It is viewed as releasing the stress and a way for completing some desire in mind or a way for adding flavour to the mechanical way of life.... … How does online shoppers' behaviour differ from traditional shoppers?...

23 Pages (5750 words) Essay

Insider Trading by Directors

Contents Contents 2 Abstract 3 1.... Introduction 4 2.... Literature Review 8 3.... Methodology 15 Table2: Abnormal Gain on purchase transactions 24 Abstract Insider trading has always been in question among the regulatory bodies all across the globe.... Although anybody from inside the corporations can commit insider trading, however directors have always remained the pioneer of doing so....

53 Pages (13250 words) Dissertation

Vital Features of Digital Economy Driven by Digital Technologies

Organizations like e-Bay or amazon .... The assignment "Vital Features of Digital Economy Driven by Digital Technologies" explores the role of online banking, international and multiple-currency banking, a decision support system in organization's decision-making process, use of DSS and EIS in supply chain management, etc....

8 Pages (2000 words) Assignment

Internship Reflection paper

In 2012, two portals of Alibaba had generated sales, which were estimated to be $170 billion, surpassing both ebay and Amazon collectively (The Economist, 2013).... The firm operates in the e-commerce industry.... In China particularly, the government is increasing the focus on e-commerce so as to strengthen social and economic… The main business of the company is to function in online and mobile market places for both retail and wholesale trade....

10 Pages (2500 words) Admission/Application Essay

On-line Demand for Products and Services

This essay demonstrates that the aspect of online demand for services and pertinent goods regards the utility of online platform, for instance, ebay, Amazon, and Alibaba (China), in addition to other online avenues, for the sole purpose of shopping.... hellip; This essay analyzes that once a particular item has been identified on a website or in another online platform, an online retailer subsequently uses available shopping cart software....

6 Pages (1500 words) Assignment

Computer and Types of Computers

They are used in weather forecasting among many other places where supercomputers are needed such as nuclear energy research, geological data analysis, and electronic design.... It is able to respond to set of instructions that are specific in a manner that is well defined.... The machine is set to work in a way that it is able to execute instructions that are… In addition, it is able to store as well as retrieve huge amount of information in faster manner (Piccinini 2008, pp....

6 Pages (1500 words) Essay

The Bay of Pigs Invasion

The writer of this paper analyzes the Bay of Pigs Invasion, which was carried out Cuban exiles with the help of covert support of the United States to liberate Cuba from the communist dictator Fidel Castro.... But the operation was a failure and earned John F.... Kennedy administration public humiliation....

13 Pages (3250 words) Research Paper

Googles Search Engine Market Share

ebay, and Amazon.... This research will begin with the statement that Google is in the business of providing targeted ads culled from its search engine capabilities, and touts itself as the organizer of the information present in the world, and in particular on the Internet.... hellip; This paper tells that as a worldwide concern, Google's key business growth drivers revolve around advertising, funneled through its search engine, operating system, enterprise, and gaming and apps platforms....

11 Pages (2750 words) Research Paper