Skip to content

Stage 2 of 5 · Analyse the file

The spreading done. What credit will find, found first.

No more keying financials into a spreadsheet. Revenue is reconciled to the sales tax returns and bank deposits, returns lodged checked on the tax office account and add-backs put on a lender's basis. Red flags are listed with their sources and serviceability is worked out at a buffered rate.

Serviceability for Clarke Hospitality's proposed $300,000 loan over five years at 7.45%, alongside an existing $42,000 equipment loan with Lender C. Debt service cover is worked out for each year at the actual rate and at a rate buffered by two points: FY24 1.33x and 1.26x, FY25 1.40x and 1.33x, FY26 1.48x and 1.41x. A 1.25x reference line is shown for the broker to judge. The sensitivity shows FY26 from 1.48x at the actual rate to 1.38x three points higher. Down the right the checks run: revenue matches the sales tax returns and bank deposits, all four returns are on the tax office account and nothing is owed to the tax office, each with its source. Two are left to address: the lease ends before the loan, from the lease at clause 3.1 and 24% of debtors are over 90 days, from the aged debtors report.

The usual way

Spreading the financials by hand, ticking the tax returns against the P&L and building the serviceability sheet again.

With Lende

Reconciles revenue to the sales tax returns and bank deposits, reads the tax office account, checks PDFs for signs of editing, lists the red flags and works out serviceability at a buffered rate.

Left for you

Judging the deal and how to structure it.

Revenue check · FY26

Clarke Hospitality

Matches
P&L revenue$1,212,400 · p.1
Sales tax returns, 4 quarters$1,211,900 · Q1 to Q4
Bank deposits$1,209,700 · 12 months
Largest gap0.2%

Revenue checked, returns accounted for

P&L revenue against the sales tax returns (BAS, VAT or GST), the bank deposits and the ledger for each financial period. The tax office account shows which returns were lodged and what's owed. A gap is flagged with the documents behind it, while there's still time to explain it.

  • P&L revenue against the returns' sales, bank deposits and the ledger, by period
  • Each return checked as lodged on the tax office account
  • Missing returns over the last year, by the market's return periods
  • Figures in one document that disagree with another
An engineer working on a laptop in a manufacturing lab

2 flags to address

Lease term · aged debtors

Red flags, before the lender

The checks a credit analyst runs, run on every deal and recomputed as documents arrive. Dismiss what doesn't apply and it stays dismissed.

  • Tax debt and payment plans, losses, falling revenue or margins
  • Drawings, dividends or distributions above profit
  • Trading under 12 months, a lease shorter than the loan, arrears on existing loans
  • Debtors over 90 days and customer concentration

Add-backs · FY26

Lender's basis

3 accepted
Reported profit$86,600 · P&L p.1
Depreciation+ $8,100 · P&L p.2
Owner's vehicle+ $9,800 · GL 6-1420
One-off fit-out repair+ $1,900 · Inv 2291

Normalised EBITDA FY26 $106,400. Owner's wages stay in.

Add-backs on a lender's basis

Lende reads the general ledger and proposes add-backs with their ledger lines: depreciation, interest, one-off repairs and personal spending. The owner's wages stay in, as a lender reads them. You accept each one.

  • Proposed by rule and by AI, each linked to the lines behind it
  • Accept, reduce or reject. Nothing counts until you accept it
  • Normalised EBITDA by period, side by side
  • Each document checked for signs it was edited after it was issued

Serviceability · FY26

Proposed $300,000 · 5 years P&I

Buffer +2.00%
DSCR at 7.45%1.48x
DSCR at 9.45% buffered1.41x
Interest cover4.9x
Debt to EBITDA2.8x

Reference line 1.25x shown for you to judge

Serviceability, worked out

The debt schedule against each period's earnings: existing facilities, those being refinanced and the proposed loan, at the actual rate and a buffered one. The ratios are shown with reference lines. The judgement is yours.

  • Debt service cover on EBITDA less tax and drawings
  • Interest cover, debt to EBITDA and loan to value (LVR or LTV)
  • A buffered rate you set and a sensitivity from 0 to 3 points
  • Existing loan statements read onto the debt schedule

Also in Financial analysis

The analysis behind every paper.

Revenue checks

P&L against the sales tax returns, bank deposits and the ledger, with returns lodged from the tax office account.

Red flags

Tax debt, losses, drawings, lease term, arrears and debtors.

Ledger add-backs

Found at transaction level, on a lender's basis.

Serviceability

DSCR, interest cover, debt to EBITDA, loan to value and sensitivity.

Integrity check

Signs a PDF was edited after it was issued.

Debt schedule

Existing, refinanced and proposed facilities in one place.

Before you ask

Questions about the analysis.

Does it say whether the deal will be approved?
No. It shows the ratios with reference lines and lists what a lender may question. Whether the deal suits a lender is your judgement.
Can I change the buffer?
Yes. The assessment buffer is set per deal and the sensitivity shows each ratio up to three points higher.
What if a check doesn't apply?
Dismiss it with a reason. It stays dismissed. Checks that stop applying resolve themselves.

Try it on a live deal.

14 days free for your whole team. No card needed.