StudentShare solutions
Triangle menu

Excel Analysis of Amazon and Ebay - Assignment Example

Not dowloaded yet

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: 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 ...Show more

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…
Author : ezboncak
Excel Analysis of Amazon and Ebay essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Excel Analysis of Amazon and Ebay"
with a personal 20% discount.
Grab the best paper

Related Essays

Investigate a social or business issue using statistical techniques (including Excel graphs), analysis and interpretation
..3 Statistical analysis………………………………………………………………………..5 Criticism on the data……………………………………………………………………..7 Conclusion and recommendation…………………………………………………………7 Improvement on data collection……………………………………………….………….7 Designed sheet for primary data collection………………….…………….……………..7 Why the method would improve quality…………………………………………………8 Bibliography……………………………………………………………….…………?
4 pages (1000 words) Assignment
Ebay Case Analysis
To succeed in the market place where there are many competitors, a company must keep on monitoring its performance and analyze the changes in both the internal and external environment. Various tools can be used to determine the company strategic position and future performance.
3 pages (750 words) Assignment
SEC project EBAY Inc
eBay is an online auction house. The website sells a variety of consumer products that are sold by individual sellers from around the world. The company makes money by charging the sellers a commission on every item posted and sold on the website. 4. What is the name of their auditors?
6 pages (1500 words) Assignment
Excel and word
Section A The average values of the variables across the two years identified systematic increments as shown in the following tables. Table 1: Measures of averages and dispersion for the year 2011 overhead cost statistics labour hours statistics machine hours statistics number of set ups statistics Mean 181.42 Mean 1162.8 Mean 1517.1 Mean 203.42 Standard Deviation 15.3 Standard Deviation 54.725 Standard Deviation 151.95 Standard Deviation 12.31 Sample Variance 234.08 Sample Variance 2994.9 Sample Variance 23090 Sample Variance 151.54 There was also increase in measures of variations as standard deviation of each of the measures indicates.
4 pages (1000 words) Assignment
Econ Excel hw
Let u be demand which is equal to Y therefore own price elasticity of product Y is eY=δu/δpy x δdy/δu, where δu/δpy = -1.9p-2.9 but u=Y= PY-1.9PZ-1.4m1.2 therefore eY=,
4 pages (1000 words) Assignment
MIS {excel project }
The business loan and the Government grants will be repaid in a period of two years at an interest rate of 8 and 1.4 % respectively. It allows one to add new items and the quantity together with the buying price. The selling price is then calculated
2 pages (500 words) Assignment
Excel Assignment
This was a good move as it motivated them to work harder, loyally and even be determined on operations of the business. In this context therefore, It is important to highlight that better
2 pages (500 words) Assignment
Excel
Again, calculate this using the correct formula to reflect this in the “Units Sold” for months Feb-June. (Use absolute cell references when needed.) 14. Under “Result-(IF-Statement)” calculate using an IF statement
1 pages (250 words) Assignment
Excel 1 Assignment--
It is from this understanding that I devised a method to address the issue. My approach involved reducing the amount of general funds by 10% and subtracting the amount gotten (reduced amount) from the Arapahoe County 2014
3 pages (750 words) Assignment
EXCEL 5
Additionally, any available patterns such as quarterly, annually or biannual, with respect to spikes and dips are identified. A comparison of the de-seasonalized and raw
3 pages (750 words) Assignment
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation