excel case study and need the explanation and answer to help me learn. Requirements: 1000 – 1250 words plus as many exhibits as necessary to show results of analysis. Thiscasecomparestwosimilarbutverydifferentcompanies(allfinancialshavebeenplacedinGoogleSheetshere).P&Gisoftenthoughtofasoneofthegreatconsumerproductcompaniesintheworld.Colgate,relativelyspeaking,fliesundertheradarandisnotaswellknownorrespected.ThecasepresentsthehistoryofthetwocompaniesandtherecentissuesatP&G.Besuretoaddressthefollowingpointsinyourwrite-upofthecase:1.PerformaDuPontanalysisofP&GandColgatefrom2008through2012.Includesustainablegrowth(fortheretentionratio,youcanuse(1-payout-ratio),wherethepayout-ratiocanbecalculatedasdividends-per-share/basic-earnings-per-share).For2012only,calculateeachcompanies’P/EandM/B(forP&G,assumeayear-endstockpriceof$67.89).AssumethatNetIncomeequals’netearningsattributable’or’netincomeattributable.’2.Evaluatetheoverallfinancialperformanceofthetwocompanies.Whichcompanyisdoingbetter?Arethereinterestingtrendshappeningoverthistimeperiod?3.WhatcantheDuPontanalysisandotherfinancialinformationtellusaboutthecompany’smarketingandoperations?(theNoteontheDuPontAnalysisprovidessomeguidance;useofoutsideresourcesisunnecessary).WhatdoyouthinkaboutCook’sleadershipatColgateorLafley’sandMcDonald’satP&G?OPTIONAL(toincreaseyourchanceofreceiving4’s):DrawmeaningfulinsightsfromacommonsizeanalysisofthecompaniesandfromaDuPontanalysisofthecompanies’segments. NOTE:●Insomeinstances,financialfiguresorstockpricespresentedinthecasemaydifferfromwhatyoucanfindonlineorinannualreports(sincethecasewaswritten,financialsmayhavebeenrestatedandstock”splits”canaffectstockpriceunits).Ifso,pleaseusethefinancialsfromourcase.Thereisnoneedtouseoutsidedata.●Youarefreetohelpeachotherandrevieweachother’sworkaslongasnocopyingandpastingoccurandyousubmityourownwork. Besuretofollowtheseguidelines:●**Donotputyournameanywhere**ontheassignmentoronsharedexhibits(Forumwilltrackyoursubmission).Yourassignmentwillbegradedblindly. ●BesureyousubmitasinglePDFonForum(doNOTsubmitZipfiles).●Assumeyouraudienceisknowledgeableabouttheaccounting/financeconceptswe’vecoveredinclassandisfamiliarwiththecasefacts.Don’twastewordsexplainingwhatassetturnoverisorwhatP&Gsells.Jumprightintotheanalysis.Also,there’snoneedtoreplicatecaseexhibits(youmayreferencethemdirectly).●Godeep.Whenformulatingaresponse,askwhy.Thenaskwhyagainandjustifyyourexplanationbycitingcasefactsandmaterial.Backupyourexplanationswithevidence.Integratenumbersintoyourarguments.●**Usenomorethantwosignificantdigits**forallnumbersinthetextandexhibits****(12%,3.5%,or0.46%,not.12480294).Lessismore.Displayingtoomanydigitsmakesnumbershardtoreadandactuallyobscurestheirvalueandintuition.●Allexhibitsyoucreateyourselfandreferencedinyourwrite-upmustbeincludedinthewrite-upitselfandbeproperlyformatted.Youmustalsoincludealinktoallyourexhibitssothatyourcalculationscanbeseenandchecked(onlythoseexhibitsthatappearinthewrite-upandareexplicitlydiscussedwillbeassessed).Placeyourlinkattheverybeginningofthewrite-upandbesuretograntyourprofessorandpeertutorsviewingprivileges.Followtheseguidelines(e.g.avoidincludingnumbersinacalculationcellbutinstead,referenceinputs/assumptionscellsthatdocontainnumbers;useblacktextforcalculationsandbluetextforinputs).●Checkyourspellingandgrammar.Poorwritingconveyscarelessnessandunprofessionalism.●Thecourse-relatedLO’sthatare#financials(x2)and#bizfunctions(x1)willbegradedbasedonyouranswerstothe3questionsabove,witheachcorrespondingtoaspecificLOasdescribedbelow.YoushouldtagtheseLO’sandexplainindetailhowyouusedthem.●InadditiontotheLO’smentionedabove,useandtag#breakitdowninthetextwhereverappropriate.●Addawordcountattheendoftheassignment(excludeexhibits,footnotes,andthebibliography).●Forassignmentdeadlineextensionspleaserefertothepoliciessectionwrittenattheendofthecoursesyllabus.AssignmentInformationLength: 1000-1250wordsplusasmanyexhibitsasnecessarytoshowresultsofanalysis.Weight:15%LearningOutcomesAdded Financials:Evaluatebusinesssituationsbyidentifyingorcalculatingaccountingandfinancialinformation. BizFunctions:Analyzehowimprovedoperating,marketing,orotherbusinessfunctionscanenhancefinancialperformance.