Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

company: revlon https://www.sec.gov/Archives/edgar/data/887921/000088792118000003/rev201710-k.htm Page 27-28 has the info Using Excel: 1. On Worksheet one, from left to right, type in the company's 2017 Income Statement,

company: revlon

https://www.sec.gov/Archives/edgar/data/887921/000088792118000003/rev201710-k.htm

Page 27-28 has the info

Using Excel:

1. On Worksheet one, from left to right, type in the company's 2017 Income Statement, Balance Sheet, Statement of Retained Earnings and Statement of Cash Flows. All subtotals and totals must use Excel calculations. This prepares you for the calculation work you will be doing through the rest of your research. (You will be using some numbers from 2016 and 2015, but you don't need to type in those year's data, just the numbers when needed in a ratio analysis) The easiest way to get your data into Excel is to cut and paste it from the Edgar site and then modify the format to look good. If you would prefer, put each statement on its own worksheet within the Excel workbook.

2. At the bottom of Worksheet 1, calculate these ratios using the numbers in the statements you have created. You must use cell references (=A1+A2 says to add the number in cell A1 to the number in cell A2)

Current Ratio

Gross Margin

Return on Assets

Return on Equity

Accounts Receivable Turnover ratio

3. In your opinion, how are they doing? Justify your response. You may include the answer in the Excel file or a separate Word file, which ever is easiest for you.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions