1 Excel Case #1-Analysis of Intel Corporation (INTC) and Taiwan Semiconductor Manufacturing Company (TSM) 2 all answers should be denoted on the appropriate Financial Stmts tab of this worksheet below the income statements 4 Calculate the following for each of the five years: Net Working Capital format: currency, O decimal places Capital Structure (debt %) Capital structure (equity %) format: percentage, 2 decimal places format: percentage, 2 decimal places format: currency, 0 decimal places format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: number, 2 decimal places format: percentage, 2 decimal places format: percentage, 2 decimal places format: percentage, 2 decimal places format: number, 2 decimal places format: percentage, 2 decimal places 10 Operating Cash Flow 12 13 14 15 16 17 18 19 20 21 Current Ratio Times Interest Earned Inventory Turnover Days' Sales in Inventory Receivables Turnover 23 24 25 26 27 28 29 30 31 32 Days'Sales in Receivables 10 Total Asset Turnover 11Profit Margin 12 Return on Assets 13 Return on Equity 14Price-earnings ratio 34 35 36 15 Gross Margin% Gross Profit / Revenue