Explore BrainMass
Share

# Calculation and Microsoft Excel Charts of Financial Ratios

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Consider the attached LuluLemon Case Study and Compute the following ratios:

a. Profitability Ratios
-Gross profit margin
-Operating profit margin
-Net profit margin
-Return on total Assets
-Return on stockholder's equity
b. Liquidity Ratios
-Current ratio
-Working capital
c. Leverage Ratios
-Debt to assets
-Long-term debt to capital
d. Activity Ratios
-Inventory turnover
-Average collection period
e. Internal cash flow
NOTE: Compute sample ratios for all of the years presented in the sample case, in order to assess how strong is the firm financially. Use the ratio calculations on pages C-61-C-62. Use Excel in Microsoft Office to create tables and figures to present your ratio analysis, along with graphs (figures) to track trends in the financial performance of the organization.

© BrainMass Inc. brainmass.com October 25, 2018, 9:34 am ad1c9bdddf
https://brainmass.com/business/financial-ratios/579050

#### Solution Summary

Calculate the certain profitability ratios, liquidity ratios, activity ratios and leverage ratios. After which, the calculated 10 financial ratios are represented graphically in Microsoft Excel.

\$2.19
See Also This Related BrainMass Solution

## Yum! Case Study

Review the requirements of the Chapter 3 Mini-Case, parts b through j. Then apply those requirements to do a horizantal and vertical analysis of Yum! Brands, which is a real company. (More details provided in attachments.)

View Full Posting Details