📁 Finance

Financial Statement Ratio Pack from Pasted Numbers

Paste income statement and balance sheet lines for ratios with formulas, trend notes, and advisor questions. Not investment advice; use only numbers you paste.

0.0
0Reviews
P
October 15, 2026

Prompt

Act as a financial analysis coach who computes ratios only from the user's pasted statement lines, shows every formula, and never gives buy/sell advice or invents missing numbers.

Inputs:
- Company or project label (can be fictional for practice): [Entity]
- Period labels (e.g. FY2024, FY2025): [Periods]
- Income statement lines you pasted (revenue, COGS, operating expenses, interest, tax, net income, etc.): [IncomeStatement]
- Balance sheet lines you pasted (cash, AR, inventory, total assets, debt, equity, etc.): [BalanceSheet]
- Units and currency: [Units]
- Which ratios you care about, or say "core set": [RatioFocus]
- Audience for the write-up (student, manager, lender packet): [Audience]

Generate:
1. Normalized table of the lines you can use; mark any needed line that is missing as MISSING (do not invent).
2. Ratio pack for RatioFocus or a core set (gross margin, operating margin, net margin, current ratio, quick ratio if inventory present, debt-to-equity, ROE if equity and NI present). For each: formula in words, substitution with pasted numbers, result rounded sensibly.
3. Period comparison: which ratios improved or worsened when two periods exist; if one period only, say so.
4. Driver notes: 3 observations tied to the arithmetic (e.g. margin down because COGS grew faster than revenue), no speculation beyond the numbers.
5. Question list for a CPA, CFA, or lender: items that need context the statements do not provide.
6. Redo check: restate the three most important results with formulas so the user can recompute.
7. Disclaimer block: not investment, tax, or credit advice.

Rules:
- Use only pasted numbers. Never fill gaps with estimates.
- Show formulas. If a denominator is zero or MISSING, skip that ratio.
- No buy/sell/hold language. No invented peers or industry averages.

Instructions

Paste your own statement lines (or a practice case) into ChatGPT, Claude, or Gemini. Recompute every ratio. This is not investment, tax, or credit advice. Do not paste confidential client data into public tools without permission.

Generated Output

This image was generated using the prompt above.

Financial Statement Ratio Pack from Pasted Numbers - Result

Examples

Example Input

Entity: Northbridge Bakery LLC (practice case).
Periods: FY2024 and FY2025.
IncomeStatement:
FY2024: Revenue 420000; COGS 210000; Operating expenses 140000; Interest 8000; Tax 12000; Net income 50000.
FY2025: Revenue 480000; COGS 250000; Operating expenses 155000; Interest 9000; Tax 14000; Net income 52000.
BalanceSheet (year-end):
FY2024: Cash 40000; AR 25000; Inventory 30000; Total assets 200000; Total debt 60000; Equity 140000.
FY2025: Cash 35000; AR 40000; Inventory 45000; Total assets 230000; Total debt 70000; Equity 160000.
Units: USD.
RatioFocus: core set.
Audience: manager reviewing year-end with an accountant.

Example Output

1. NORMALIZED LINES (USD)
Revenue 420k/480k; COGS 210k/250k; OpEx 140k/155k; Interest 8k/9k; Tax 12k/14k; NI 50k/52k.
Cash 40k/35k; AR 25k/40k; Inv 30k/45k; Assets 200k/230k; Debt 60k/70k; Equity 140k/160k.
All requested core lines present.

2. RATIO PACK (FY2025 shown; FY2024 in parentheses)
Gross margin = (Revenue - COGS) / Revenue = (480000-250000)/480000 = 47.9% (FY24: 50.0%).
Operating margin = (Revenue - COGS - OpEx) / Revenue = (480000-250000-155000)/480000 = 15.6% (FY24: 16.7%).
Net margin = NI / Revenue = 52000/480000 = 10.8% (FY24: 11.9%).
Current ratio = (Cash+AR+Inv) / (not fully given current liabilities). MISSING current liabilities detail: cannot compute current or quick ratio safely from Total debt alone.
Debt-to-equity = Debt / Equity = 70000/160000 = 0.44 (FY24: 60000/140000 = 0.43).
ROE = NI / Equity = 52000/160000 = 32.5% (FY24: 50000/140000 = 35.7%).

3. PERIOD COMPARISON
Gross, operating, and net margins declined; debt-to-equity nearly flat; ROE declined. Revenue grew 60000 (+14.3%) while COGS grew 40000 (+19.0%).

4. DRIVER NOTES
- Gross margin fell because COGS grew faster than revenue (19.0% vs 14.3%).
- Operating profit dollars: FY24 70000 vs FY25 75000; margin % still down on higher revenue base.
- AR and inventory rose (25k->40k, 30k->45k) while cash fell 5k: working capital mix shifted into receivables and stock.

5. QUESTIONS FOR ADVISOR
- What are year-end current liabilities so current/quick ratios can be computed?
- Was the COGS increase volume, mix, or commodity cost?
- Is the AR increase concentration in a few customers?

6. REDO CHECK
GM25 = (480k-250k)/480k = 47.9%.
OM25 = (480k-250k-155k)/480k = 15.6%.
D/E25 = 70k/160k = 0.44.

7. DISCLAIMER
Not investment, tax, or credit advice. Arithmetic coaching from pasted lines only; a licensed professional should interpret for decisions.

Reviews (0)

Please login to leave a review.
Loading reviews...