Module 7 Book: Financial Reporting & Analysis 13 Edition Final Statement Analysis Choose a publicly traded...

Module 7 Book: Financial Reporting & Analysis 13 Edition Final Statement Analysis

Choose a publicly traded company and perform an expanded analysis on the financial statements. Use the most current 10K statements available on SEC or annual statements in Yahoo Finance.

Complete the following for your chosen firm in an Excel spreadsheet:

Company Chosen: Amazon

***https://www.sec.gov/Archives/edgar/data/1018724/000101872416000172/amzn-20151231x10k.htm#sDE44A2B31082AE97A401ABB24E2245F0***

***https://finance.yahoo.com/quote/AMZN/financials?p=AMZN***

Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues for that year). Horizontal and vertical analysis of the balance sheets for the past three years (all yearly balances set as a percentage of total assets for that year). Ratio analysis (eight ratios of your choosing) for the past three years PLUS a measurement for the creditworthiness of your firm as measured by Altman’s Z-score. Note that if you used your chosen firm for our ratio-related discussion posts, then you MUST also present industry-average ratios or current year competitor ratios for your ratio analysis. Comparing your firm’s ratios to a close competitor or an industry-average ratio makes your analysis much more meaningful.

I need this to be done in excel sheet to show the analysis of Amazon thanks

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Module 7 Book: Financial Reporting & Analysis 13 Edition Final Statement Analysis Choose a publicly traded...

Module 7 Book: Financial Reporting & Analysis 13 Edition Final Statement Analysis Choose a publicly traded company and perform an expanded analysis on the financial statements. Use the most current 10K statements available on SEC or annual statements in Yahoo Finance. Complete the following for your chosen firm in an Excel spreadsheet: Company Chosen: Amazon ***https://finance.yahoo.com/quote/AMZN/financials?p=AMZN*** Horizontal and vertical analysis of the income statements for the past three years (all yearly balances set as a percentage of total revenues for...

Directions: Choose a publicly traded company and perform an expanded analysis on the financial statements. Use...

Directions: Choose a publicly traded company and perform an expanded analysis on the financial statements. Use the most current 10K statements available on SEC or annual statements in Yahoo Finance. Complete the following for your chosen firm in an Excel spreadsheet: The Company is TJ MAXX below is a link to the sec.com 10K statement. https://www.sec.gov/Archives/edgar/data/109198/000119312517099642/d269088d10k.htm https://www.sec.gov https://finance.yahoo.com/quote/TJX/financials?p=TJX If the first link does not work there is a second one and search for the company TJ MAXX Along with a...

Choose a publicly traded company, and identify the resources that you would use (besides the financial...

Choose a publicly traded company, and identify the resources that you would use (besides the financial statements) to analyze the financial position of this corporation for 2016-2017. Find at least two resources, other than the financial statements, that provide information regarding your chosen company. Prepare an overview (approximately 300 words) of what is revealed about the company by these resources, including any items that you find to be unusual about the company. Provide a link to each resource examined with...

Choose a publicly traded company and analyze the financial statements based on the various ratios discussed...

Choose a publicly traded company and analyze the financial statements based on the various ratios discussed in concept 5 (leverage, debt to equity, liquidity ratios, etc.). Provide an overview of how financially healthy the company is and predictions for the future of the company.

Module 8: Financial Statement Analysis explain the purpose of financial statement analysis, describe the primary techniques...

Module 8: Financial Statement Analysis explain the purpose of financial statement analysis, describe the primary techniques used in financial statement analysis, and finally, discuss the problems associated with financial statement analysis. Write a minimum of 300 and a maximum of 350 words.

Identify a publicly traded firm. Provide a brief financial analysis, and identify the major stakeholders.

Find the financial statements for a publicly traded company, and examine its statement of cash flows....

Find the financial statements for a publicly traded company, and examine its statement of cash flows. Prepare the cash ratios presented in the Module 7 Readings, and prepare an overview (300 words) of what is revealed about the company by its statement of cash flows and cash ratios.

Select the financial statement of a publicly traded company. Analyze the various financing options the company...

Select the financial statement of a publicly traded company. Analyze the various financing options the company employed. What other options might you recommend? Why would you recommend them?

This week's assignment is to do a thorough financial statement review of the publicly-traded company Facebook....

This week's assignment is to do a thorough financial statement review of the publicly-traded company Facebook. To complete the analysis, you will need to run the five most applicable liquidity ratios, the two most appropriate solvency measures, and the five most appropriate profitability measures. Include these in an excel document. I was not given any financial information for facebook.

Ratio Analysis Review and compare the following ratios for both companies: Choose two publicly traded companies...

Ratio Analysis Review and compare the following ratios for both companies: Choose two publicly traded companies in the same industry. Working capital Current ratio Debt ratio Net Profit Margin Review the most recent ear Review the Earning's call for both companies and report your findings to include, but not limited to, results and projections.

Subjects