Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingFinancial Ratio Analysis

SpreadsheetFinancial Statements & ReportingFree

Financial Ratio Analysis

Liquidity, profitability, efficiency and leverage ratios calculated from your figures and compared with targets.

Shown with sample data

Colour

Financial Ratio Analysis

Liquidity, profitability, efficiency and leverage ratios calculated from your figures and compared with targets.

Ratios healthy
9
To review
0
Ratio values
  • Current ratio2.5
  • Quick ratio2
  • Gross margin %53.7
  • Net margin %8.5
  • Return on equity %30.9
  • Receivable days28
  • Asset turnover2.1
  • Debt to equity0.7
  • Interest cover11.3

How to use it

  1. 1Enter your figures on the Inputs sheet.
  2. 2Edit the targets to suit your sector.
  3. 3Read the ratios marked Review first.
  4. 4Repeat each quarter to see the trend.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Turn the accounts into a health check. Type twelve figures from your statements; the sheet calculates the ratios lenders and investors look at, compares each with a target you can edit and marks which need attention.

Who it’s for

  • Annual business reviews
  • Preparing for a loan
  • Comparing against sector norms

What’s included

  • Inputs sheet: Figures from your statements.
  • Ratios sheet: Ratios against your targets.

How to use it

  1. 1Enter your figures on the Inputs sheet.
  2. 2Edit the targets to suit your sector.
  3. 3Read the ratios marked Review first.
  4. 4Repeat each quarter to see the trend.
Related searchesfinancial ratiosratio analysiscurrent ratiogross marginreturn on equitybusiness health

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetFinancial Statements & ReportingFree

Financial Ratio Analysis

Liquidity, profitability, efficiency and leverage ratios calculated from your figures and compared with targets.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Financial Statements & Reporting
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More financial statements & reporting templates

View all
Small Business Profit and Loss Statement3 sheets

Revenue

$54,650

Gross margin

64%

Net profit

$7,460

Net profit by month
$7,460
$6,365
$3,620
$3,080
$1,650
Nov 2026Oct 2026Sep 2026Jul 2026Jun 2026
SpreadsheetFinancial Statements & Reporting

Small Business Profit and Loss Statement

Monthly P&L against budget and last month, with gross and net margin and a six-month trend.

10 min setupPreview
Monthly Financial Dashboard2 sheets

Revenue this month

$655,000

Revenue, last 12 months

$7,013,000

EBITDA margin this month

16%

EBITDA by month
$57k
$38k
$62k
$79k
$78k
Dec 2025Jan 2026Feb 2026Mar 2026Apr 2026
SpreadsheetFinancial Statements & Reporting

Monthly Financial Dashboard

One page that answers how the business did this month: revenue, margins, EBITDA, cash, DSO and customers against target, with 12-month trends.

10 min setupPreview
Trial Balance2 sheets

Adjusted debits

$57,150

Adjusted credits

$57,150

Difference

$0

ABCD
1AccountTypeDebitCredit
2BankAsset$18,400$0.00
3Accounts receivableAsset$6,200$0.00
4Prepaid insuranceAsset$1,200$0.00
5EquipmentAsset$9,000$0.00
Trial balance
SpreadsheetGeneral Ledger & Trial Balance

Trial Balance

Closing balances by account in debit and credit columns with a balance check and totals by statement section.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ