Financial spreading software

Financial spreading, with every figure cited to its page.

LenderBox's financial spreading software reads the financial statements, rent rolls, tax returns and K-1s in a loan package and spreads them into one consistent view. Every figure is cited to the document and page it came from, and every ratio shows its formula. Your analyst confirms any figure LenderBox is unsure of and makes every judgment call.

SPREAD · ILLUSTRATIVECITED TO SOURCE
Trailing twelve months, one consistent view
Gross potential rent$1,486,000
Net operating income$871,000
Debt service$665,000
Guarantor liquidityDoes not reconcile, flagged
One apartment refinance · illustrative

A 96-unit refinance, spread the day it arrives.

A borrower asks to refinance a 96-unit apartment community with a $9.0 million loan. This is the spread your analyst opens the same day. The deal and the figures are invented for illustration.

REFINANCE · 96-UNIT APARTMENT COMMUNITY · $9.0M LOAN REQUESTEDAPPRAISED VALUE $12.5M · NET OPERATING INCOME $871,000
01 · THE PACKAGE

The whole package in one upload, sorted to each party.

Drop the whole loan package at once, as PDFs, spreadsheets, Word files or scans. An agent sorts each document to the borrower, the guarantor or the property, and you are asked only about the ones that do not fit. Borrowers upload to a request list you set, and a document past its window is flagged before the file goes to committee.

YOUR ANALYST DECIDESWhat to request, and when a document is too old to rely on.
INTAKE · ILLUSTRATIVEONE UPLOAD
The whole package, sorted to each party
THE PROPERTY
Rent rollFresh
Operating statements, T-12Fresh
AppraisalFresh
THE GUARANTOR
Personal financial statementAging, flagged
Account statementsFresh
THE BORROWER
Entity tax returnsRequested from the borrower
SORTED
By party
FORMATS
PDF, Excel, Word, scans
STILL MISSING
1, requested
02 · THE SPREAD

Rent roll, T-12 and borrower file in one view.

The rent roll, the operating statements and the borrower file are read against one another and spread into one consistent view. Each figure carries the document and page it came from, every ratio shows its formula, and the figures fill your own Excel workbook. The glossary works through financial spreading on a sample borrower.

SPREAD · ILLUSTRATIVECITED TO SOURCE
Trailing twelve months, one consistent view
Gross potential rent$1,486,000Rent roll, p. 2
Vacancy and credit loss($89,000)T-12, p. 3
Other income$58,000T-12, p. 3
Operating expenses($584,000)T-12, p. 3
Net operating income$871,000T-12, p. 3
Annual debt service$665,000Term sheet, p. 2
Debt service coverage1.31xFormula: $871,000 ÷ $665,000
03 · THE GAP

A $330,000 gap in guarantor liquidity, flagged before the memo.

Figures that disagree across the file surface on day one, with both figures and the pages they came from. Any figure LenderBox is unsure of waits for your analyst, and the review cannot close until every one is confirmed.

YOUR ANALYST DECIDESWhich figure to rely on, and what to ask the borrower.
RECONCILIATION · ILLUSTRATIVE1 ITEM FLAGGED
Guarantor liquidity does not reconcile
Stated$1,050,000Personal financial statement, p. 1
Supported$720,000Account statements, p. 4
Difference$330,000
Flagged for your analyst, with both pages.
04 · THE SOURCE

Net operating income opens to page 3 of the T-12.

Each figure links to the page it came from, so your analyst, your committee or an examiner can check a number in seconds.

See global cash flow built from the same spreads →
SOURCE VIEW · ILLUSTRATIVET-12, P. 3
From the spread to the page
Net operating income$871,000T-12, p. 3
OPERATING STATEMENT · TRAILING TWELVE MONTHS · PAGE 3
Effective gross income1,455,000
Operating expenses(584,000)
Net operating income871,000

Every document in the file, read and cited to its page.

DOCUMENTWHAT IS READCITED LIKE THIS · ILLUSTRATIVE
Rent rolls
Rent due, read against collections and the leases.
Rent roll, p. 2
Operating statements
Income and collections, including the trailing twelve months.
T-12, p. 3
Leases
Expirations by tenant and by year, and tenant concentration.
Leases, pp. 12 and 47
Appraisals
Appraised value and capitalization rate.
Appraisal, p. 41
Tax returns and K-1s
Read against the financial statements, with K-1s traced to the owners' related entities.
Tax returns, K-1s
Financial statements
Margins, working capital and interim results, period by period.
Financial statements, p. 4
Personal financial statements
Guarantor liquidity and other obligations.
Personal financial statement, p. 1
Borrowing base certificates
Recalculated from the agings and inventory reports behind them.
Borrowing base certificate, p. 1
Construction budgets
The budget, the contract and the bids, reconciled line by line.
Budget, line 41
Bank statements
Read with the returns into one view of cash flow.
Bank statements, pp. 3 to 9

Your analysts, back on analysis.

The package
TODAYSorted by hand, document by document.
WITH LENDERBOXDropped at once and sorted to each party.
Missing documents
TODAYChased by email.
WITH LENDERBOXRequested from a list the borrower uploads to.
Figures into the spread
TODAYRetyped by hand.
WITH LENDERBOXRead from the documents, each cited to its document and page.
Documents that disagree
TODAYFound in week two.
WITH LENDERBOXSurfaced on day one, with the pages on both sides.
Stale statements
TODAYCaught at committee.
WITH LENDERBOXFlagged when a document passes its window.
Your analysts' hours
TODAYSpent keying.
WITH LENDERBOXSpent on the credit itself.
"When it does give you information, it gives you the document. It shows you exactly where it's citing that and sourcing that from."
CEO, private credit lender and CRE capital advisory firm
Also built for

Spreading questions, from documents to ratios

Which documents does LenderBox read?

Rent rolls, operating statements, leases, appraisals, tax returns and K-1s, financial statements, personal financial statements, borrowing base certificates, construction budgets and bank statements, as PDFs, spreadsheets, Word files or scans. Each figure is cited to the document and page it came from. See every document type we read.

How do we check its work?

Every figure is cited to its document and page, and every ratio shows its formula, so anyone on your team can rerun it by hand.

What happens when two documents disagree?

Both figures are shown on day one, with the pages they came from. Your analyst decides which one to rely on.

How accurate is the spreading?

We design for near-perfect accuracy, and a machine can still make mistakes, so a person stays in the loop for every judgment call. Any figure LenderBox is unsure of waits for your analyst, and the review cannot close until every one is confirmed.

Can we keep our own spreading workbook?

Yes. Figures from the file fill your own Excel workbook, and changes made there come back.

Does LenderBox spread tax returns and build global cash flow?

Yes. Cash flow is built across the business, its owners and their related entities, with each figure cited to the return or statement it came from.

What is financial spreading software?

LenderBox spreads the whole package into one consistent view, every figure cited to its source page and every ratio's formula shown.

How soon are we live, and what if it is not right for us?

Teams go live in as little as a few weeks, with no long-term contracts. If LenderBox has not earned its place, you get a full refund of subscription fees within 90 days of go-live, on one written request.

Send the scans, the spreadsheets and the PDFs. The demo can run on all of them.

Thirty minutes on your own deal documents, scans and all, with no commitment.

Bring a deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.
Not ready to talk? See pricing