Financial Final Project


Question Description:

25

See attached file for details Document Preview: Requested Project Completion Date: April 16, 2013. This Project has two parts: calculations and a 4-to 6-page essay. While the calculation requirements of this assignment are important, equally important are your discussion and analysis of the quantitative results. You will submit two documents: 1) an Excel spreadsheet (.xls), containing your horizontal and vertical analysis (and perhaps your ratios) and 2) a Word document (.doc) containing your essay. Perform an expanded analysis on the financial statements of the company: Netflix, Inc. Please use the most current 10K statements available on www.sec.gov http://www.sec.gov or annual statements in finance.yahoo.com http://finance.yahoo.com. STUDENT NOTE: I have included Netflix’s Balance Sheet and Income Statement from finance.yahoo.com below. If you need specific project rubrics for this assignment, I can upload them for your review in guidance for completing this assignment. Part 1: Please complete the following for your chosen firm in an Excel spreadsheet. NOTE: I have included a screenshot of the instructor’s preferred format for the Income Statement and the Balance Sheet below to use as a reference: 1. 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). 2. 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). 3. 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. Part 2: The Paper in Word document… Attachments: Project-Synop….pdf

Answer

25