Question Description

Company Team:Team Name
Using 10K’s from SEC.gov, calculate the following financial ratios for your company selection, and include an
explanation of what the formula measures, interpretations of the results and trends in the boxes provided below.
Amounts are in:Use Dropdown:State if amounts are in Dollars, Thousands, Millions:
Note: at the top of each ratio calculation column, include the date, or the period of time used in
the calculation. For instance, Balance Sheet analysis is at a date [Dec 31, 2018] while Income Statement
analysis is for a period of time ended at a certain date [12 months ended Dec 31, 2018]. 
Replace “Formula” with the Excel formula needed to calculate ratio. Do not hard code results of calculations.
Select Date Range or Date Select Date Range or Date Select Date Range or Date: “For the Year Ended” OR “At This Date”
1Current Ratio   Fill in Date with most recent data presented first.
Current assets $                                   –   $                                   –  
Current liabilities  $                                   –   $                                   –  
Current Ratio FormulaFormula
 For each: Explain what the ratio measures. Include interpretation of the ratio and comment on trend as favorable or unfavorable.
Select Date Range or Date Select Date Range or Date Select Date Range or Date: “For the Year Ended” OR “At This Date”
2Debt-to-Equity Ratio  Fill in Date with most recent data presented first.
Total liabilities $                                   –   $                                   –  
Total equity $                                   –   $                                   –  
Debt-to-Equity RatioFormulaFormula
 
Select Date Range or Date Select Date Range or Date Select Date Range or Date: “For the Year Ended” OR “At This Date”
3Profit Margin Ratio  Fill in Date with most recent data presented first.
Net income $                                   –   $                                   –  
Net sales $                                   –   $                                   –  
Profit Margin RatioFormulaFormula
 
Select Date Range or Date Select Date Range or Date Select Date Range or Date: “For the Year Ended” OR “At This Date”
4Return on Total Assets  Fill in Date with most recent data presented first.
Net income $                                   –   $                                   –  Use cells in this area for calculations of Average Total
Average Total Assets (show calculation) $                                   –   $                                   –  Assets & other notes as needed. (not set in Print Area)
Return on Total AssetsFormulaFormula
 

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at essayloop.com. We assure you of a well written and plagiarism free papers delivered within your specified deadline.