Buy-Side Investment Analysis

Build a source-linked Excel input sheet containing three years of key financial and operating data for a selected listed Indian healthcare company, using AI-assisted research only where each figure can be verified against primary filings.

Diagnose the healthcare company’s business quality using trends in growth, margins, return on capital, working capital, free-cash-flow conversion, and leverage.

Build a base, bull, and bear forecast for the healthcare company using explicit revenue, margin, and earnings assumptions.

Estimate the healthcare company’s equity value with a simplified FCFF discounted cash flow model and test its sensitivity to discount-rate and terminal-growth assumptions.

Cross-check the DCF conclusion using relevant peer trading multiples and explain material valuation differences.

Write a one-page investment committee memo stating the thesis, valuation range, catalysts, risks, monitoring triggers, and buy-or-avoid recommendation.

Build a source-linked Excel schedule of an Indian infrastructure or power issuer’s debt, interest obligations, maturity profile, liquidity, and cash-flow resources.

Assess the issuer’s debt-servicing capacity under base and downside cases using leverage, interest-coverage, and debt-service metrics.

Write a one-page credit note recommending lend or avoid, with proposed pricing logic, covenants, risk flags, and monitoring triggers.

Deliver a three-minute interview presentation connecting both projects to the role’s requirements and defend the recommendations using evidence-based answers to likely challenge questions.