My corporation is Microsoft. Use excel spreadsheet.

Go to any financial website of your choosing (such as Yahoo Finance or the main website for your assigned corporation) and locate the financial statements for your assigned corporation. Note that certain websites, such as Morningstar , will allow you to export the data to Excel for free which might simplify your Excel calculations. Now refer to Table 3.8 in the text. 1) Using an Excel spreadsheet, you will create a three-year ratio trend analysis from the financial statements for your assigned corporation. The trend will consist of the following ratios: - Current Ratio and the Quick Ratio from the "I. Short term solvency, or liquidity, ratios" category - Return on Assets Ratio and the Return on Equity Ratio from the "IV. Profitability ratios" category - Price Earnings Ratio and the Price Sales Ratio from the "V. Market value ratios" category. Then provide a one-page (minimum) discussion about what each trend indicates for your assigned corporation. Is the trend good or bad, why? 2) Using the ready ratios dot com study guide , find the industry ratios for your corporation. Note that the ratios provided in investing.com for your assigned corporation may not match your part (1) calculations exactly. Compare your calculated ratios for your assigned corporation to the industry ratios. Then provide a one-page (minimum) discussion that details whether your assigned corporation is performing better or worse than the industry based on the definitions of the six ratios. Are your calculated trends from part (1) moving closer to or farther away from the industry averages? Is this good or bad? Chapter 3 Working with Financial Statements 67 TABLE 3.8 Common Financial Ratios I. Short-term solvency, or liquidity, ratios Current ratio =CurrentliabilitiesCurrentassets Quick ratio =CurrentiabiliesCurrentassetsInventory Cash ratio =CurrentliabilitiesCash Net working capital to total assets =TotalassetsNetworkingcapital Interval measure =AveragedailyoperatingcostsCurrentassets III. Asset management, or turnover, ratios Inventory turnover =InventoryCostofgoodssold Days' sales in inventory =Inventoryturnover365days Receivables turnover =AccountsreceivableSales Days' sales in receivables =Receivablesturnover365days NWC turnover =NWCSales Fixed asset turnover =NetfixedassetsSales Total asset turnover =TotalassetsSales II. Long-term solvency, or financial leverage, ratios Total debt ratio =TotalassetsTotalassetsTotalequity Debt-equity ratio = Total debt/Total equity Equity multiplier = Total assets/Total equity Long-term debt ratio =Long-termdebt+TotalequityLong-termdebt Times interest earned ratio =InterestEBIT Cash coverage ratio =InterestEBIT+Depreciation IV. Profitability ratios Profit margin =SalesNetincome Return on assets (ROA)=TotalassetsNetincome Return on equity (ROE) = TotalequityNetincome ROE=SalesNetincomeAssetsSalesEquityAssets V. Market value ratios Price earnings ratio =EarningspersharePricepershare PEG ratio =Earningsgrowthrate(%)Price-earningsratio Price-sales ratio =SalespersharePricepershare Market-to-book-ratio =BookvaluepershareMarketvaluepershare Tobin's Q ratio =ReplacementcostofassetsMarketvalueofassets Enterprise value-EBITDA ratio =EBITDAEnterprisevalue ready ratios dof fom study guide 1. Go to hetps://www.readvratios. com/sec/ and you will see the following. C Ready Ratios 2. Enter the stock symbol for your assigned corporation (TGT shown above) and then press enter to get this screen 3. SIMPLY SCROLL DOWN TO SEE THE COMPARISON TO INDUSTRY RATIOS Conextsescemstast Financial ratios benchmarking