HUL.NS 3-STMT+DCF COST DCF+COMPS AMZN SEGMENT DCF BKW LBO BRK.A DCF TATACONSM.NS RATIO ANALYSIS ITC.NS

Self-Directed Research — Not Affiliated With Any Sell-Side Desk

Coverage Notes

A working set of financial models built independently: DCF valuations, an LBO, and ratio-driven company profiles. Built to practice the mechanics properly, not to hit a specific conclusion.

CFA Level I

Raghav Rawat  |  rawatraghav162003@gmail.com  |  LinkedIn

DCF Valuations

HUL.NS

Hindustan Unilever

Bottom-up 3-statement model across four reporting segments, DCF with WACC derivation and terminal value sensitivity.

±3%FCFF vs. Actual →
COST

Costco Wholesale

DCF and comparable company analysis against Walmart, Target, and Amazon, with a toggle-driven bear/base/bull sensitivity dashboard.

7.58%WACC →
AMZN

Amazon

3-segment operating model (North America, International, AWS) built from 10-K filings, DCF cross-checked against trading comps.

8.33%WACC →
BRK.A

Berkshire Hathaway

Segment-level DCF across Insurance, Railroads/Utilities/Energy, and investment income, with scenario switches by segment.

+4.8%Implied vs. Spot →

Transaction Modelling

QSR / BKW

Burger King — 3G Capital LBO

Leveraged buyout replicating 3G Capital's 2010 take-private: debt tranches, entry/exit multiples, and equity return waterfalls.

21.0%Base Case IRR →

Financial Statement & Ratio Analysis

TATACONSM.NS

Tata Consumer Products

Full ratio analysis across profitability, returns, working capital, and cash conversion, built from historical financial statements.

-36.7dCash Conv. Cycle →
ITC.NS

ITC Limited

One-page company profile plus a full 3-statement and ratio model: margins, valuation multiples, capital structure, and recent developments.

19.7xEV/EBITDA →