Using this link: https://sec.report/Document/0000950123-09-009558/ I have to answer the questions using it. I am having a lot of problems with this. This was not in any of our assignments. We have to do it in excel form. Can someone help me. My company is Ralph Lauren.

1.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).

2.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).

3.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.).

Here is the assignment as given to us:

This project will allow you the opportunity to explore a company's annual report and become familiar with the items it contains. Choose a company from the list below for the subterm in which you are enrolled. Locate the most recent annual report, either from the Liberty University library's access to Capital IQ NetAdvantage (S&P) database, the EDGAR database (http://www.sec.gov/), or the company's website. Once located, open Individual Learning Project Questions document and add your answers underneath each question. Do not delete the questions. Questions 1-49 must be answered with Microsoft Word. Your answers for these do not need to be in complete sentences. Questions 50-52 must be answered in Microsoft Excel and your answers must include formulas. Questions 53-55 must be answered with complete sentences and justification within the Word document. Both documents (Word and Excel) must be uploaded into the Assignment link.

I hope this helps Now you can see why it is so hard for me to do without any background given in accounting and no work done in reports.