Ratio Analysis Calculator — Schedule III (Notes to Accounts)
Compute the 11 financial ratios mandated under Schedule III to the Companies Act, 2013 for the notes to accounts. Enter your current and previous year figures to get each ratio for both years, the percentage variance, and an automatic flag wherever the variance exceeds 25% (which requires an explanation). Enter amounts in any rounding unit, fill via an Excel template, and export the result to Excel. Works for both AS and Ind AS companies.
Financial Figures
Statement of Profit & Loss
ParticularsCurrent YearPrevious Year
Balance Sheet — as at year end
ParticularsCurrent YearPrevious Year
Opening Balances — at start of previous year (for averages)
ParticularsOpening (PY start)
Debt Service — during the year (for DSCR)
ParticularsCurrent YearPrevious Year