Choose A Publicly Traded

Choose a publicly traded company doing business in Puerto Rico: Select from one of the following three sectors: manufacturing, service, or retail sales. Compute the quick and current liquidity ratios, the DuPont ratio, profit margin, asset utilization for your chosen company. (fedex)Need formula in excel for referencCurrent ratioCurrent Assets / Current LiabilitiesQuick ratio(Current Assets - Inventory) / Current LiabilityOperating profit marginIncome from operations / SalesPre tax Profit marginIncome before income taxes / SalesNet profit marginNet Income / SalesProfit MarginAsset utilizationCash turnoverSales / Average cash and cash equivilentAccounts receivable turnoverSales / Average accounts recievablePPE turnover / Fixed Asset TurnoverSales / Avg. PPETotal assets turnoverSales / Avg. total assetsDopoint RatioEquity MultiplierTotal assets/shareholder's equityROENet Profit margin x Total asset turnover x equity multiplier(Fedex has no inventory thus, quick ratio and current ratio will be same)RatioFormulaThe ideal ratio for current assets is 2:1 i.e. the current assets should be double of tht of current liabilities. If the company's current ratio is less than it means that the company might face difficulty in meeting its short term obligations It indiactes the efficiency with which the company utilizes its operating income with respect to sale. Higher the ratio better is the efficiency.it estblishes the relation between