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 17, 2018, 12:29 pm ad1c9bdddf
https://brainmass.com/business/financial-ratios/579050

Attachments

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
Similar Posting

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