Quantitative - Financial Statement Analysis

Explore quantitative analysis of a profit and loss statement for an Indian company, compare with qualitative methods, and build financial models using steps: elements, structure, trends, cost structure, and ratios.

Explore the elements of a profit and loss statement by analyzing revenue from operations, other income, and diverse expenses, including raw materials, inventory changes, depreciation, taxes, and ebitda.

Engage in hands on financial statement analysis with two real companies, alternating exercises where you solve the second while the instructor covers the first, then review solutions and investment recommendations.

Apply vertical common size analysis to the P&L to identify major revenue sources and costs, visualize profit structure across two years, and compare margins using Excel.

Build a five-year standalone P&L model for Asian Paints, identify revenue from products, material costs around 48–54%, 45% gross margins, low finance cost, and a 12–15% net profit trend.

Analyze trends and structure in financial data by examining total income and its components, and visualize changes with horizontal common size analysis and trendlines.

Analyze financial trends using horizontal common-size analysis and in-cell spark lines to track year-by-year P&L, costs, and taxes, identify COVID-related shifts, and build a simple percentage-change model.

Discover how trend analysis compares each number with the previous year to reveal short-term and long-term growth via cagr, and how it differs from horizontal common size.

Build a trend analysis model for P&L data, calculating short- and long-term growth rates and CAGR, using future value over present value minus one and the ri function.

Identify the cost structure in the profit and loss statement by categorizing costs into variable, semi-variable, and fixed costs, and distinguish cash from non-cash costs to assess margin of safety.

Define and categorize costs under the p&l as variable, semi variable, fixed cash, fixed noncash, depreciation and amortization, and taxes, then assess inventory and finance costs with a waterfall chart.

Identify Asian Paints' cost structure by classifying costs as variable, semi-variable, fixed, and others, then build a cost analysis and graphical model in Excel.

Identify balance sheet elements, assess structure and trends for Asian Paints, evaluate financing structure and margin of safety, and apply ratio analysis for integrated insights.

Identify the assets side of the balance sheet by classifying non-current and current assets, including tangible assets like property, plant and equipment, right of use assets, and goodwill.

Examine the liability side of the balance sheet, distinguishing equity from non-current and current liabilities. Review equity components like equity share capital, other equity, and accumulated profit and loss.

Identify balance sheet structure by applying vertical common size analysis to assets, dividing items by total assets and comparing FY 22 to FY 21, revealing inventory and materials costs shifts.

Conduct a common size vertical analysis of assets, comparing current and non current components to reveal an asset heavy structure, inventory and receivables trends, and liquidity insights.

Perform a vertical common size analysis of liabilities to reveal a stable, self-funded company with dominant equity, negligible long-term borrowings, and a clear current liabilities structure highlighting trade payables.

Analyze balance sheet trends using common size, horizontal analysis, line charts, and growth rates such as cagr to interpret assets, liquidity, inventories, and receivables.

Analyze liabilities trends via horizontal common size analysis and line charts, then assess growth rates and cagr; highlight rising trade payables and strong net worth growth from internal profits.

Analyze a company's financing structure via asset liability mismatch to gauge margin of safety, balance sheet risk, and funding of long term vs short term assets, with Excel graphs.

Analyze a balance sheet to map the financing structure of Asian paints, using common size analysis to reveal equity dominance and the margin of safety in funding assets.

Learn to build a financing structure graph in Microsoft Excel using stacked column charts to compare liabilities and assets, with data labels and reversed order.

Netflix funds its long-term content assets with equity and long-term debt, keeping current assets low. The margin of safety is moderate, with long-term liabilities below long-term assets and high liquidity.

Discover ratio analysis as a powerful tool in financial statement analysis, learning how profit margins and other financial ratios relate numbers, compare performance, and interpret five categories responsibly.

Analyze profitability ratios and returns, including gross, operating, and net profit margins, plus return on equity, return on capital employed, and return on assets, using Asian Paints as a benchmark.

Evaluate liquidity ratios, including current, quick, and cash ratios, to reveal the company's strong short-term liquidity and ability to meet obligations, with five-year averages and industry comparisons.

Asian paints shows shorter days of inventory, receivables, and payables, shortening the cash conversion cycle, with stronger turnover yet lower asset turnover versus industry averages.

Assess solvency and leverage for long-term obligations using debt to equity and debt to asset. Evaluate debt to EBITDA and coverage measures such as interest coverage.

Explore how valuation ratios reveal market value relative to financial performance, using earnings per share, price to earnings, price to book value, and dividend yield for Asian Paints.

Combine all the financial ratios to summarize Asian Paints' performance, showing strength in profitability, liquidity, efficiency, solvency, and valuation as revealed by ratio analysis.

Learn how to read financials with business context, linking sales, capacity, geography, and offerings to reveal the true story behind the numbers.

Explore notes to accounts, auditor reports, and key financial statements to critically analyze detailed financials, guided by accounting policies under Indian accounting standards and IFRS.

Explore notes 22–23 of the P&L, detailing revenue by products and services, geography, and state refunds; examine the 30–45 day credit policy and non-operating income such as interest and royalties.

Calculate materials consumed via opening stock plus purchases minus closing stock for raw material and packing material, and review employee benefits details in note 25.

Analyze note 26 on other expenses, including fleet and handling charges, advertising, corporate social responsibility, and miscellaneous, and review consumption of stores through insurance to improve model accuracy.

Analyze the finance cost composition in notes 27–43, including interest on bank borrowings, bill discounting, interest on lease liability, depreciation and amortization, and Indian corporate tax at 25.168%.

Explains notes to account for asset side, detailing gross fixed assets, depreciation, and net carrying value, including capital work in progress and right of use assets.

This lecture covers notes on intangible assets, detailing goodwill and other intangibles, and shows impairment replaces amortization for goodwill, with no amortization this year and net carrying value unchanged.

Explain investments in subsidiaries and associates, including 1095 crore in equity, distinguish controlling from non-controlling stakes, and note liquidity differences between unquoted and quoted equity and long-term versus short-term investments.

Explore note six on other financial assets, separating long-term and short-term items like security deposits, royalties, subsidies, retention money, and consider reclassifying liquid fixed deposits as financial investments.

Note seven to eleven cover income tax assets, inventories near 5200 crore, and trade receivables around 2915 crore with most not due; cash and bank balances around 270 crore.

Analyze the liability side through notes 12 and 13, detailing authorized vs issued equity capital, and other equity components—retained earnings, share premium, OCI, and related dividends.

Analyze notes 14–16 on liabilities, detailing borrowings, lease liabilities, and other financial liabilities. Highlight the Haryana loan, its interest-free and secured nature, and related current payables.

Examine provisions for employee benefits—compensated absences, gratuity, pension, and post-retirement medical plans—and explain deferred tax liabilities arising from differences between tax and book depreciation.

Analyze notes 19–21 on liabilities, including other non-current and current liabilities, trade payables and acceptances, revenue received in advance, statutory dues, deferred income from government grant, and income tax liability.

Separate other income from net sales to reflect operating income. Shift finance costs by removing lease and income tax effects; classify selling, general administrative expenses into variable and semi-variable costs.

Refine the balance sheet by reclassifying acceptances to short-term debt and moving fixed deposits to short-term investments, and use annual purchases to refine days of payables.

Explore how to answer finance questions using notes to accounts, annual reports, and investor calls, explaining revenue drivers, raw material costs, and capacity expansion in a paint company.

Analyze the performance of Asian Paints' subsidiaries and associates using annual and consolidated financials, and assess liquidity, investments, and inventory drivers.

Examine how FY22 trade receivables rose due to pandemic-driven credit terms, and how this shifts working capital and supplier payables.

Analyze the investor call report for Asian Paints, including the transcript and management Q&A, to understand inflation-driven margins, price increases of 1.8–2%, and the affordable luxury focus in home decor.