Automated Financial Evaluation System

This file evaluates companies extracted from the database.
Read a company's numbers in one lookup.

This guide explains by this file — a tool that takes a company's telephone number and a fiscal year, pulls its sales, costs and assets from the economic database, and turns that raw ledger into a plain-language financial rating.

01 · What it is

A single-record financial reader

The tool is a lookup-and-score page. A user enters a company's phone number and a year; the system finds that company's matching financial record in the company database table, displays its profile and raw figures, and then runs those figures through a set of ratio tests that classify the company's performance for that year — without the user ever touching a spreadsheet.

What goes in

A telephone number (the company's record key) and an evaluation year, picked from a short dropdown of recent years.

What comes out

The company's profile, its raw sales/cost/asset figures, and a set of qualitative ratings — from Excellent down to Loss — describing its margin, cost, and asset-coverage health.

02 · Why it exists

Turn raw figures into a decision-ready read

Six numbers on a balance sheet — sales, purchases, expenses, debit interest, other revenue, assets — don't mean much on their own. The goal of this tool is to remove that translation step: instead of asking a reader to calculate margins and coverage ratios by hand, it does the arithmetic, checks where each ratio falls on a fixed scale, and states the outcome in plain words a non-accountant can act on.

For analysts

Skips manual ratio calculation across a large set of companies.

For decision-makers

Gives a standard, repeatable rating instead of a subjective read of a statement.

For the database

Makes every company record instantly queryable by phone number and year.

03 · How it works

From a phone number to a rating

The page runs the same five-stage process for every request:

Validate and look up

The submitted phone number is checked for a valid numeric format, then used with the chosen year to query the company table over a PDO/MySQL connection.

Display the raw record

If a match exists, the company's profile (name, email, site, legal form, products, sector, country) and its raw financial fields are printed as a reference table.

Derive the working figures

From six raw inputs, the system computes gross profit and three versions of net profit (before interest, before other revenue, and final) that feed every ratio downstream.

Compute the ratios

Four ratios are calculated: a product/margin ratio, an expense-adjusted ratio, and two asset-coverage ratios (one before and one after other revenue is added in).

Classify and report

Each ratio (and each meaningful pair of ratios) is checked against fixed numeric bands and mapped to one of seven tiers, from Excellent to Loss, which the page reports back as the company's evaluation.

04 · Required data

What the tool needs, and what it reads

Two inputs come from the person running the evaluation. Everything else is read from the matching row in the economic database.

FieldSourceExampleRole
TelephoneTyped by user33026232Record key used to find the company
YearChosen by user2015Selects which fiscal year to evaluate
SalesDatabasen1Total revenue from core activity
PurchasesDatabasen2Cost of goods/inputs bought
ExpensesDatabasen3Operating expenses
Debit interestDatabasen4Interest paid on borrowing
Other revenuesDatabasen5Income outside core sales
AssetsDatabasen6Total value of company assets

The company's profile fields (name, email, website, legal form, sector, country, products, paid capital) are also stored alongside these figures and are shown for reference, though they don't affect the rating itself.

05 · Reading the results

Seven tiers, one spectrum

Every ratio the tool computes lands on the same scale — a company either sits close to a healthy balance (Excellent) or drifts toward one figure overwhelming another (Loss). Lower ratio values read as stronger; higher values, and negative profit, read as weaker.

E
Excellent
Vg
Very Good
G
Good
A
Acceptable
P
Poor
Vp
Very Poor
L
Loss
ratio ≈ 1 (balanced)ratio grows large, or profit turns negative
Product rating

Rates margin efficiency alone: how sales compare to purchases relative to gross profit.

Expense rating

Cross-checks the margin ratio against an expense-adjusted ratio, so a good margin backed by controlled costs rates higher than one undermined by them.

Revenue / debit rating

Cross-checks two asset-coverage ratios — one excluding, one including other revenue — to see how much of the company's asset base its profit realistically covers.

06 · Worked example

One company, one year, one verdict

Suppose a company reports the following figures for a given year:

Sales620,000
Purchases340,000
Expenses95,000
Debit interest18,000
Other revenues27,000
Assets980,000

What the tool derives

Gross profit280,000
Net profit before interest185,000
Net profit before other revenue167,000
Final net profit194,000
Product ratio → ratingExcellent
Expense-adjusted ratio → ratingVery Good
Asset coverage (pre-revenue)Very Good
Asset coverage (post-revenue)Very Good

Reading it: sales comfortably outpace purchases (an excellent margin), and once expenses, interest and assets are folded in, the company's profit still covers its cost base very well in every check — a picture of a financially healthy year, not a marginal one.

07 · Try it yourself

Live company lookup

Enter a company's telephone number and year — exactly like the live tool — and this page will query the same economic database and compute the same ratios and ratings, using the company's real figures instead of typed-in numbers.

In this file, This section reads company records over a live database connection using the same credentials and query pattern as . It only reads data — it never writes, updates, or deletes records.

08 · Where it's used

Applications

01

Credit & lending checks

Banks and lenders can get a quick, standardized read on a borrower's financial health before a deeper review.

02

Investor screening

Investors scanning many companies can filter out weak or loss-making years before reading full statements.

03

Partner due diligence

Businesses evaluating a potential supplier or partner can pull an instant financial snapshot.

04

Economic database upkeep

Keeps a national or sector-wide company registry queryable and self-explanatory year over year.

05

Sector benchmarking

Analysts can compare how companies within the same sector rate against the same fixed scale.

06

Teaching ratio analysis

The fixed bands make it a working example of how margin and coverage ratios turn into a verdict.

09 · Trade-offs

Advantages and limitations

Advantages
  • Instant result from just two inputs — no manual ratio math required.
  • Same fixed scale applied to every company, so ratings are directly comparable.
  • Combines margin, expense and asset-coverage checks rather than a single ratio.
  • Plain-language tiers (Excellent → Loss) are readable by non-accountants.
  • Works directly off records already stored in the economic database.
Limitations
  • Only as accurate as the underlying database entry for that company and year.
  • Fixed ratio bands are not adjusted for industry, size, or currency scale.
  • Evaluates a single year in isolation — no trend or multi-year comparison.
  • A phone number as the lookup key can be reused, changed, or mistyped.
  • Ratios near zero are nudged by a small constant to avoid division errors, which can shift borderline cases.
  • Says nothing about qualitative factors — management, market conditions, competition.
← Back to main page  |   ← Previous page