What happens to a file, from the day it arrives to the day your committee decides
A file is read whole, written up with its reasons and its gaps, and questioned by your people before anyone signs. Your own officers can do that work in the software, or our team can do it and return the documents. Both are open today.
Example: an invented business
Intake note: block maker, Dodoma
| Audited statements 202414 pages, all legible | 14 pages, all legible | |
|---|---|---|
| Bank statements, Jan to Dec 202412 statements, one photographed at an angle and read | 12 statements, one photographed at an angle and read | |
| Valuation report, March 20256 pages, plot and buildings | 6 pages, plot and buildings | |
| Loan application form and letterTZS 180,000,000, 36 months, 3 interest only | TZS 180,000,000, 36 months, 3 interest only | |
| Contract for the school building orderNamed in the letter as the main new customer. Ask the borrower for it. | Not in the file | Named in the letter as the main new customer. Ask the borrower for it. |
| Supplier quotation for the second pressCost taken from the letter until a quotation arrives. Ask for one. | Not in the file | Cost taken from the letter until a quotation arrives. Ask for one. |
Press a figure to see the page and line it was read from.
Step by step
- 01
The file arrives as it is
An officer uploads it, or you send it to us. Audited accounts, bank statements, valuation reports, contracts, spreadsheets, emails with their attachments and photographs of paper records all come in as they are, in English or Swahili. Before any analysis, the officer sees what arrived and what is missing. - 02
Every page is read, and every figure keeps its address
Scans and photographs are read like any other page, and each figure is taken from the page and line it sits on. Turnover in the accounts is set beside the money banked in the statements, so a difference between them is seen before committee asks about it. A page that cannot be read is named with the reason.LitFin IntelligenceCredit memorandum: block maker, Dodoma
Credit memorandum: block maker, Dodoma
4Repayment capacity and security
Turnover, 2024 Net profit after tax, 2024 Paid into the business account, 2024 Cash available for debt service, year one Repayments due, year one Debt service cover, year one Debt to equity after the loan Plot offered as security The file states no interest rate. The appraisal assumes 17% a year and marks every figure that depends on it.
Not in the file
The application names a school building order as the main new customer. No contract for it is in the file, so the cash flow leaves its sales out.
Not in the file
There is no supplier quotation for the press. Its cost is taken from the application letter and marked unconfirmed until one arrives.
Press a figure to see where it came from.
Read from
Audited statements 2024, page 7
RevenueTZS 642,300,000
Example: an invented businessA page of the credit memorandum. Press any figure to open the page and line it was read from; a figure that was computed shows its working instead. - 03
The credit paper is written with its reasons and its gaps
Purpose of the loan, sources of repayment, the borrower and the people behind it, the financial analysis and the cover year by year, the security and what it would fetch in a forced sale, the risks with what would settle each, and the proposed terms and conditions precedent. Where the file is silent, the gap is written down and kept out of the figures. The business plan, the model, the risk register and the ESG screening come from the same reading.LitFin IntelligenceRisk register: block maker, Dodoma
5 risks, each with the evidence that raised it
- Evidence in the file
- The application letter names a school building order as the main new customer, and no contract for it is in the file.
- What would settle it
- The signed contract or the purchase order. Until then its sales stay out of the cash flow.
- Evidence in the file
- The cover is 1.41 in year one, with only 3 months of interest only while the second press finds buyers.
- What would settle it
- A longer interest-only period, set in the model, or a smaller loan.
- Evidence in the file
- The audited statements report turnover of TZS 642,300,000. The bank statements show TZS 614,800,000 paid in over the same year, TZS 27,500,000 less.
- What would settle it
- The cash sales book and the accountant's reconciliation of sales to deposits.
- Evidence in the file
- There is no supplier quotation. The cost is taken from the application letter.
- What would settle it
- A supplier's quotation or pro forma invoice for the press.
- Evidence in the file
- The file states no rate, so 17% a year is assumed and every figure that depends on it is marked.
- What would settle it
- Your institution's pricing for this facility.
Example: an invented businessThe risk register from the same reading of the file. Each risk carries the evidence that raised it and what would settle it. - 04
Your officers question it before anyone signs
They ask Mwikila, our AI Senior Banking & Finance Manager, why the cover falls in a given year or where a figure came from, in English or Swahili. In the model they change the rate, the tenor or the grace period, and every figure that depends on it follows, in the memorandum as well as the workbook.LitFin IntelligenceFinancial model: block maker, Dodoma
B10Formula=B6/B9
Cash available over repayments due
Figures in TZSPress a cell to see what it is computed from.
The debt service sheet Line Year 1 Year 2 Year 3 Loan amount Interest rate a year, assumed Tenor, in months Interest-only months Cash available for debt service Interest-only payments Instalments Repayments due Debt service cover Change an assumption
The file states no rate, so this one is assumed and marked.
Example: an invented businessThe financial model under the appraisal. Change the rate, the tenor or the interest-only months and every repayment and cover recomputes, as it does in the working Excel file an officer downloads. - 05
Your committee decides
The recommendation, the terms and the signature belong to your institution. LitFin Intelligence approves nothing, sends nothing to a credit bureau and holds no one's money.LitFin IntelligenceBlock maker, Dodoma: credit appraisal
MwikilaAI Senior Banking & Finance ManagerBlock maker, Dodoma: credit appraisal Officer
Why is the cover thinner in year one, and where does the turnover figure come from?
Mwikila
Year one carries 9 full instalments after 3 months of interest only, while the second press is still finding buyers. Cash available for debt service is TZS 97,600,000 and the repayments due are TZS 69,447,000, so the cover is 1.41. It rises to 1.53 in year two and 1.72 in year three.
The turnover of is read from the audited statements for 2024, page 7. Over the same year TZS 614,800,000 was paid into the business account, and the two are set side by side before your committee asks.
Press the turnover figure to open the page it was read from.
Not in the file
The application names a school building order as the main new customer. No contract for it is in the file, so the cash flow leaves its sales out.
Credit memorandum: block maker, Dodoma
Written from every page of the file.
- 1Purpose of the loan and how it is repaid
- 2The borrower and the people behind it
- 3Financial analysis, year by year
- 4Repayment capacity and security
- 5Risks, each with what would settle it
- 6Recommended terms and conditions precedent
It downloads as Word, as PDF and as a working Excel model.Example: an invented businessAn officer asks Mwikila why the cover is thinner in year one. The answer sets out the figures, opens the page the turnover was read from and names what the file does not hold.
LitFin IntelligenceCredit memorandum: block maker, Dodoma
Credit memorandum: block maker, Dodoma
4Repayment capacity and security
| Turnover, 2024 | |
|---|---|
| Net profit after tax, 2024 | |
| Paid into the business account, 2024 | |
| Cash available for debt service, year one | |
| Repayments due, year one | |
| Debt service cover, year one | |
| Debt to equity after the loan | |
| Plot offered as security |
The file states no interest rate. The appraisal assumes 17% a year and marks every figure that depends on it.
Not in the file
The application names a school building order as the main new customer. No contract for it is in the file, so the cash flow leaves its sales out.
Not in the file
There is no supplier quotation for the press. Its cost is taken from the application letter and marked unconfirmed until one arrives.
Press a figure to see where it came from.
Read from
Audited statements 2024, page 7
RevenueTZS 642,300,000
Two ways to use it
As software, used by your own officers
Your officers sign in and do the work themselves, on the files they carry each week. Institutions with their own credit team usually choose this.
- They can ask about any line of the paper, at any hour, and the answer points back to the page in the file.
- They download the appraisal and the business plan in Word or PDF, and the financial model as an Excel workbook whose formulas still work.
- Each officer has their own sign-in, and the files stay within your institution's account.
As a service, prepared by our team
You send us the file, our team works it with the same software, and the documents come back to you. A lender that wants a second reading of a hard file usually chooses this. So does an organisation preparing its own case for a lender or a fund, or one reading the applicants to a loan programme it runs for its own members or staff.
- Before we start, we send you the intake note: what arrived, what could not be read and what is missing.
- You receive what your own officers would have produced: the credit paper, the business plan, the model or the risk register, as the case needs.
- Your people can still question every line, and we answer from the file.
How a file you send is held
Before you send anything, read where a file is stored, who can open it, how long it is kept and the law it is handled under.
Start with files you have already decided
Send us a few files your committee decided in the past, including one that went wrong if you have it. We work them, and you compare our reading with the decision already made, so nothing live is at stake. It needs one officer's time and nothing from your technology team. Copies with names removed are fine.