Using Netflix Inc. obtain the financials for the most recent year period. Based on the company financials:1. Prepare a Horizontal Analysis for all 3 financial statements.2. Prepare a Vertical Analysis for the Balance Sheet and Income Statement.3. Prepare a Ratio Analysis for each of the following:a. Current Ratiob. Acid – test ratioc. Receivable turnoverd. Profit Margine. Inventory Turnoverf. Asset turnover g. Return on Assetsh. Return on Common Stockholders Equityi. EPSj. Debt to Total Assets ratiok. Times Interest EarnedSHOULD BE DONE VIA EXCEL1. Do all your calculations within Excel [not your hand held calculator]. I should be able to see your formula once I click on a calculated number.2. Include all the financial statements (balance sheet, income statements, cashflows, changes in owners equity) you have used. This will enable me to recalculate your numbers if need be.
Using Netflix Inc. obtain the financials for the most recent
Tags:Homework Help