Reference no: EM132719496
Question: My company is Ralph Lauren and it is year ending 2020 March 28 to be exact. They have not provided any information on how this is done at all.
- Provide common-size analysis of your company's income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas).
- Provide horizontal analysis of your company's income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas).
- Perform ratio analysis on your company using the ratios listed in Exhibit 13.16 on page 505 of your text (these must be in an Excel spreadsheet, using formulas to calculate the ratios). You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about your company after each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.).
My company is Ralph Lauren and it is year ending 2020 March 28 to be exact. They have not provided any information on how this is done at all. i just need help!!!!
- Provide common-size analysis of your company's income statement and balance sheet for the 2 most recent years (must be done using Excel with formulas).
- Provide horizontal analysis of your company's income statement and balance sheet, showing the dollar amount and percent of change using the 2 most recent years (you must use an Excel spreadsheet with formulas).
- Perform ratio analysis on your company using the ratios listed in Exhibit 13.16 on page 505 of your text (these must be in an Excel spreadsheet, using formulas to calculate the ratios). You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about your company after each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.).
|
Compute the current ratio for year 2 and year 1
: Dividends of $16,000 were declared and paid in year 2. Compute the current ratio for year 2 and year 1. (Round your answers to 1 decimal place.)
|
|
Determine the times interest earned
: A company reports the following: Income before income tax expense $9,100,000. Determine the times interest earned. Round to one decimal place
|
|
How to calculate the effect of the lifo on the income
: Calculate the effect of the LIFO on the income. During 2018, 50,000 units were purchased for $8.50 each. Sales for the year totaled 54,000 units leaving 6,000
|
|
What is the pv of the financing option
: 1. How much do they h ave to pay monthly if they choose to finance? 2. What is the PV of the financing option? (Please show your calculation on excel)
|
|
Perform ratio analysis on your company using the ratios
: Perform ratio analysis on your company using the ratios listed in Exhibit 13.16 on page 505 of your text (these must be in an Excel spreadsheet).
|
|
Determine the company ratio of fixed assets to long-term
: Total stockholders' equity 320,000. Determine the company ratio of fixed assets to long-term liabilities and Round to one decimal place
|
|
Executive compensation
: The market trend towards escalating executive compensation reflects the critical importance of an executive to an organization's long-term viability.
|
|
Investments affect the variance of portfolio return
: How will the volatilities and correlations of the component investments affect the variance of the portfolio return?
|
|
Calculate the balance in the investment account at september
: Calculate the balance in the Investment Account at September 30th.,2019, if X was reporting the investment using the equity method
|