MediumBusinessfinance

Company Annual Report Analysis

Added Jul 2026 3 design docs

An Indian listed company's annual report runs to three hundred pages, and almost nobody reads past the chairman's letter. The interesting material is further in: the auditor's key audit matters, the contingent liabilities note, the related-party schedule, the working-capital days that quietly doubled while the headline profit rose. Commerce students learn ratio formulas in class and then never once open a real report to see where the numbers actually come from, which is why a fresher who can navigate a balance sheet, tie a figure to its note number and spot when the management narrative and the cash flow statement disagree is immediately more employable than one who cannot.

The intern picks one listed Indian company, downloads its last three annual reports from the investor relations page, and produces a full analyst-style examination of it. Every figure is extracted by hand into a normalised input tab in excel, from which the intern builds common-size statements, 14 ratios across profitability, liquidity, solvency and efficiency, and a cash-flow-quality view comparing operating cash flow to reported profit. Alongside the numbers the intern reads the narrative sections and tests them: management's growth claims against segment revenue, the auditor's report against the risk register, the accounting policy notes against the working-capital trend. The output is a 12 to 16 page analyst note, a five-tab ratio workbook, a one-page tearsheet, a 10-slide review deck in powerpoint, and a page-referenced reading log kept in notion.

Completing the project builds the single most transferable skill in commerce and finance: reading a real financial statement and forming a defensible view from it. The intern practises data extraction discipline, ratio construction from first principles, cash-flow quality assessment, red-flag screening and evidence citation down to the page number. That is the working day of an analyst at an equity research desk, a credit team, an audit firm or a corporate finance function, and it makes for an interview conversation no coursework summary can match.

Related projects

Startup Financial Model and Break Even Analysis

A business plan that ends with the line 'we expect ₹15 lakh of revenue in year one' is a wish, not a plan. Thousands of small Indian ventures - cloud kitchens, tiffin services, print shops, two-chair salons - open every month on the strength of a rough feel for pricing and a hope that footfall will cover the rent, and a large share of them shut within eighteen months because nobody ever worked out how many units a day the business has to sell simply to survive. The one number that decides everything, the break-even point, is almost never on the founder's whiteboard. The intern builds a complete three-year financial model for exactly that kind of venture: Tiffin Tribe, a student tiffin subscription service planning to launch from a rented kitchen in Kothrud, Pune. Working in excel, they construct a bottom-up revenue engine driven by subscriber additions, churn and three plan tiers, a per-meal cost sheet, a fixed cost and headcount schedule, a capex and depreciation table, a monthly profit and loss statement and a separate cash flow, then layer on a scenario switch, a break-even calculation and a two-way sensitivity grid. Every driver is traced back to a dated real price - kitchen rent from public rental listings, cook wages from job postings, container costs from a wholesale market - recorded in an assumption register kept in notion, and the whole argument is compressed into a twelve-slide investor-style deck in powerpoint. Turning an idea into a defensible set of numbers, and knowing precisely which assumption breaks it, is the most transferable skill in commerce. The intern finishes able to speak fluently about contribution margin, fixed cost absorption, cash runway and sensitivity, which is the working vocabulary of FP&A, investment banking, consulting and startup finance interviews, and walks away with a live model and an evidence trail to open on a laptop rather than a claim on a page.

financeexcelnotionpowerpoint

PRD · HLD · LLD includedView

BusinessEasy

Budget Analysis of a College Event

Every Indian college runs events, and almost none of them are costed properly. The annual fest, the department seminar, the farewell dinner, the inter-college sports meet: the money side usually lives in a WhatsApp group, a diary page and a shoebox of bills. Committees over-order biryani, the printing bill arrives at double the quotation, one sponsor pays in kind instead of cash, and when the event is over nobody can answer the only question the next committee actually needs answered, which is what this thing really costs per head. The intern picks one real event and produces a complete budget analysis of it. They collect bills, quotations, the sanction letter, the registration sheet and the sponsorship summary from the organising committee, interview the people who spent the money, and build a line-item cost model in excel that reconciles what was planned against what was actually paid. From that model they compute cost per attendee, variance by cost head, sponsorship recovery and break-even registration price, compare quotations for the three biggest spends, and package everything into a 14 to 18 page budget dossier, a 12-slide briefing deck in powerpoint for the next committee, and a blank reusable budget template the college can fill in before sanctioning the next event. Completing the project teaches the intern the working core of management accounting: tracing evidence to numbers, building a variance table that explains itself, running scenarios instead of guessing, and turning a messy pile of receipts into a document a faculty coordinator will actually act on. For B.Com, BBA and BA students aiming at finance, audit, operations or consulting roles, a costed post-mortem of a real event with real reconciled rupees is far more convincing in an interview than any coursework case study.

financeexcelgoogle-docspowerpoint

PRD · HLD · LLD includedView

BusinessEasy

Mutual Funds versus Fixed Deposits Comparative Study

In most Indian families the savings conversation ends in the same place it has for forty years: a fixed deposit at the bank where the salary lands. Mutual funds have grown enormously, yet the household argument still runs on two slogans - deposits are safe, funds are risky - and both survive because almost nobody puts them on one page and does the arithmetic. Once tax at your own slab and a few years of inflation are subtracted, a deposit paying 7 percent can quietly return almost nothing in real terms, while a fund that beat it over ten years can still have lost money over any three of them. The intern settles the question with evidence rather than opinion. Working in excel, they assemble ten years of month-end NAV history for nine funds across equity, debt and hybrid categories, plus dated deposit rates from five institutions including a small finance bank and a post office scheme, then compute compounded returns, SIP returns using XIRR, rolling three-year returns across more than eighty start points, volatility, worst twelve-month outcome and drawdown. Every comparison is then rebuilt after tax at three income slabs and after official inflation, which is where most published comparisons quietly stop. The findings become a study report organised around five decision lenses, a working decision calculator, and an eight-slide carousel designed in canva and published on linkedin so the argument reaches people who will never open a spreadsheet. This is the analysis that separates a commerce graduate who has memorised product definitions from one who can actually compare instruments. The intern comes away fluent in CAGR versus XIRR, rolling returns, real returns and the tax treatment that decides most of these arguments, plus the discipline of writing about money without slipping into advice - exactly what wealth management, research and financial content roles test for in the first interview.

financecanvaexcellinkedin

PRD · HLD · LLD includedView