Work the Web Part-3, Instruction You will use some of the cd in Chapter 3 to do ban fall of the firm your You will need to submit two for this site Word She and one Excel is The XL will include the data needed for the Work the Wib parts. The WW2 report (Word ) will include the flowing Basic copy information collected in WW] Thead analysis of prefability Ratio salysis va competitors DuPont Analy Please find the attached XL le (SampleWW2.xlsx) Parte en understand what you out de for your o Data collection To start WW2 you will need to obtais historical data that will be used in WW2, WW3 and WW4 Eif don't see all the tens in this report, make sure you use them in an ed ie that can be used later. For the exercises use one of the freely wailable Financial Webelten CSTMARKET bp://.com/ MACROTRENER Map://www.crstrand.net/ Zacks beverT RESEARCH Ap://www.acks.com/ .com Mtp://www.reuters.com/tic MSN Money ape://www.xas.com/es- YAHOO! FINANCE https://finance.yab.com/ or any other financial website you prefer or can locate your company's dada, egy and pate balance about and income statements for the last 3 to 5 yean ladude IS and IS in the same sheet is Excel Make me the colm algs. Check how many years are provided in each elite and then decide your re Trend analysis ROA and ROE are two of the most important variables that are the performance of a compass. For m may go to the MSN welalte and get the 10 your chart of ROA and ROE for your company. You can the link below and then click on the Managment Effective tab http://www.sn.com/s/y/stockdetalle alyssa/fi-136.1.3. Once you include the information on your report, add your comments describing the trend le there a tread that you can se? lait improving or detericesting? Is there an especially had year? If there is try to explain it Another performance measure that investors care about in the stock price. Ge so your favorite financial website and copy/parte a chart of the stock prices over the last 5 years (or 10 years if available). Compare to the previous chart Do you see a relationship between profitability and stock prices? Describe the trend la it iscing or demaning? Is there an especially bad year? If there is try to exp Work the Web project: Part 2 Ratio analysis Vis one of the financial websites provided in Data Calection section that provides fancial ration for your company, industry, and storm: you may go to this page http://www.reuters.com/finance/stocks/ fightsymbol (put the ticker for your ows company) and copy the 7 categories of Councial ratice that Reuters reports for Company, Industry and Secter. Start with valuation ration Peg the data shown in "Revenue & Karnings per share. Repost the process for the two competitors that you identified in WW1. Copy the ratios into a new tab in Excel as the rows for your company and the 2 competitors match The reg the columns so you can we rest to ouch other the value for your company, your competitor 1, your compter 3 industry and sector. Once you have them next to each other, you'll start comparing the numbers trying to find when your company perform better and when your compay show wore performace than competiton As You in, you find one overal weak and one overall strength as mucpted by this moparisce. It not necessary le comment each of the financial ration, only those that are perceived as stage or weak can report strength or weakoms in each financial ratio category but it is Du Pont analysi cry You will copy ley data you get in Excel into a new sheet. The specific nows you seed a Ne D igsty Dend on the Eve rows of data you will calculate the 5 ratice involved for which you have information: sping Prodi Marge Trial sa turver Betore on Anet Equity Mu Beturn pity all Ce have all the ratis for all the years with data, compare the components of ROA and ROI agit industry Jl and sake as of the performance of the company he the company doing well or not so well? Noul PM TAT ar EM? ledude any recommendations that you believe are d