Explore BrainMass

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


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.

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