HUL Financial Ratio Analysis

I need a concise yet insightful Excel workbook that digs into Hindustan Unilever Limited’s recent numbers and highlights two key areas: its Operating Profit Margin and its Current Ratio. Your task is to pull the latest published statements, clean or reconcile anything that looks inconsistent, then calculate and trend those two metrics over at least the past five fiscal years (quarterly data is a plus if you can source it reliably).

Alongside the calculations, include clear charts, brief commentary explaining what moved each ratio year-to-year, and a short conclusion on how the company’s profitability and liquidity position stack up against its own history and, if data is handy, a close peer.

Deliverables
• Excel file with source sheets, clean working tabs, and final dashboards
• A one-page PDF or Word summary pulling out the headline insights and any red-flag observations

Acceptance Criteria
• Operating Profit Margin and Current Ratio both calculated with formulas that reference raw data (no hard-keyed numbers)
• Five-year history minimum, with sources cited in a notes tab
• Charts labeled clearly, units consistent, no broken links or #REF errors

I work almost exclusively in Microsoft Excel, so keep all analysis there; no additional BI tools required. Turnaround within a week would be ideal, but let me know if you need a little breathing room.