Financial Ratios Spreadsheet

Mona
Download Spreadsheet

What it is

A spreadsheet tool that automates core financial ratio calculations across liquidity, profitability, efficiency, and leverage.

Why it is useful

It standardizes analysis, reduces manual errors, and provides a repeatable framework for comparing performance over time or against peers.

How to use it

  1. Enter financial statement values in the input sheet.
  2. Review calculated ratios in the dashboard tab.
  3. Use the notes section to compare against industry benchmarks.

Download

Download the spreadsheet

  • CFA Institute - Financial Statement Analysis
  • Corporate Finance Institute - Ratio Analysis Guide