Question: Horizontal Analysis The company is Amazon (create a horizontal analysis in excel, evaluation of the results, & please upload the annual report as well) *DETAILED

Horizontal Analysis

The company is Amazon

(create a horizontal analysis in excel, evaluation of the results, & please upload the annual report as well) *DETAILED INSTRUCTIONS BELOW*

General Instructions: For this case, you will be responsible for setting up an excel document, performing horizontal analysis, and evaluating the results of the Fortune 500 company you selected in module 1 discussion forum. You will have 3 documents to upload (excel for your analysis, word for your evaluation of the results, and the company annual report.) Complete and submit the assignment by 23:59 EST Thursday. Detailed Instructions: In excel, perform horizontal analysis of the balance sheet. Be sure to include the name of the company, your name, and the assignment name as a header. Also, name the document Module 7: Assignment 1 -- Written Case Your Name. In a word document, summarize the balance sheet results of the horizontal analysis. Simply select some of the higher or lower %s to discuss. Focus on items you feel are more relevant and telling of the company operations. For example, you could write one paragraph on each section of the balance sheet i.e. assets, liabilities, equity.

Step by Step Solution

★★★★★

3.43 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 2 3 Particulars A B Amazoncom Inc Consolidated balance sheet Horizontal analysis 4 5 ASSETS 6 Current assets 7 Cash and cash equivalents 8 Marketabl... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

The company is Amazon Create a presentation, with 15 to 20 slides. Include the following: Initial Risk Assessment Analytical Procedures State the company you selected, and explain the reasons for...

THE COMPANY IS AMAZON NOT GOOGLE!!! THE FOLLOWING LINK CONTAINS ALL RECENT FINANCIALS http://www.nasdaq.com/symbol/amzn/financials?query=income-statement At the most recent strategic planning...

The company is Amazon 4. Describe at least one functional business processes and process used in the organization. (1 one cross-functional Marks)

The following selected transactions were taken from the books of Caledonia Company for 2012. 1. On March 1, 2012, borrowed $50,000 cash from the local bank. The note had a 6 percent interest rate and...

General Mills is a multibillion-dollar company that makes and sells products used in the kitchens of most American homes. The Companys annual report included the following note: We have a revolving...

Enter the following column headings across the top of a sheet of paper: Enter the transaction letter in the first column and show the effect (if any) of each of the following transactions on each...

The following table shows the effects of five transactions (a through e) on the assets, liabilities, and equity of Veras Boutique. Write short descriptions of the probable nature of eachtransaction....

Profitability analysis for two companies The following data show five items from the financial statements of two companies for a recent year (amounts in millions): aNet Income + [Interest Expense x...

Assume you work as a staff member in a large accounting department for a multinational public company. Your job requires you to review documents relating to the company's equipment purchases. Upon...

For a rectangular weld-bead track resisting bending, develop the necessary equations to treat cases of vertical welds, horizontal welds, and weld-all-around patterns with depth d and width b and...

Pearltech Inc., an information technology company, decides to establish a business alliance in order to differentiate its products. The manager of research and development, Sanah, is willing to form...

What is the recommended way of importing multiple secrets into the HashiCorp Vault? Inline, with the '-' at the end of the put Importing a JSON file with the @ operator Redirecting a JSON file as...

Multi Enterprises Ltd. is a Canadian-controlled private corporation whose fiscal period coincides with the calendar year. For the year 2021, the company's taxable income was calculated as follows:...

statements. The adjusted trial balance amounts at June 30 are shown below. Cash Accounts Receivable Prepaid Rent Supplies Equipment Dividends Debit Credit $ 6,700 Accumulated Depreciation-Equipment $...

3. Suppose each person in a large statistics class (enrollment 1000 students) rolls a die 60 times and counts the number of times they roll an ace (one dot). (a) For each person, the total number of...

Grand Corporation reported pretax book income of $805,000. Tax depreciation exceeded book depreciation by $535,000. In addition, the company received $330,000 of tax-exempt municipal bond interest....

Johnson Co. makes organic non-GMO vegetable seed packets for the chef/gardener market. The standard material is 0.92 ounces per seed packet at a cost of $0.70 per ounce. Johnson Co. budgeted to make...

A firm has the following balance sheet: Assets Cash Accounts receivable Inventory Plant and equipment $ 15,000 150,000 92,000 170,000 $427,000 Liabilities and Equity Accounts payable Long-term debt...

( TRUE or FALSE? ) The use of multiples in valuation is sometimes viewed solely as a type of relative - valuation approach. True fatse

The Offshore Investment Fund (OIF) was incorporated in Fairfield, Connecticut, for the sole purpose of allowing U.S. shareholders to invest in Spanish securities. The fund is listed on the New York...

Exhibit 10-4, "Framework for Systems Design," provides a way of thinking about the financial control process in a multinational setting. Assume that a parent company domiciled in your country is...

Do a WOTS-UP analysis for your school or firm relative to its major competitor. Based on your analysis, suggest several countermeasures your dean or CEO might consider to maintain or improve your...

Give some examples of services where waiting lines are used.

What is the probability that a project with the following precedence network will take more than 10 weeks to complete if the activity means and standard deviations (both in weeks) are as follows?

Explain Littles formula: L = W.