02 For credit teams and for businesses raising a loan
Underwriting
In LitFin Intelligence you set the facility once: amount, rate, tenor, grace period, security, conditions precedent and covenants. The credit memorandum, the facility letter, the working Excel model and the business plan all carry those terms, so the letter your borrower signs says what your committee read. When the committee changes the tenor, the repayments and the cover in the model recompute from the new term.
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.
| 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.
What you receive
The facility terms, stated once
Amount, rate, tenor, grace period, repayment profile and security are read from the file and set down in one place. A term the file does not give, most often the rate, is marked as an assumption until your officer puts in the institution's own figure.The credit memorandum and the committee pack
The memorandum carries the terms, the sources of repayment, the security and the risks in the order your committee reads them, with the appraisal and the model behind it. Your officer writes the recommendation and signs.The facility letter, with its conditions and covenants
The letter states the same terms, the conditions to be met before drawdown (security perfected, insurance in the lender's favour, a document the file still lacks) and the covenants the loan will be tested against. Each condition and covenant shows which line of the file it comes from, and your legal team settles the wording.A financial model that recomputes
A working Excel workbook: the loan schedule, the income statement, the balance sheet and the cash flow on live formulas, with DSCR, NPV and IRR worked out. Change the rate, the tenor or the grace period and every figure that depends on it follows.A business plan written from the file
The plan is written from what the file shows about this business: its sales, its costs, its customers and its own tables. A section the file cannot support is marked as a gap with what would fill it, so the plan never reads stronger than its evidence.
Part of a facility, stated once
Example: an invented business
A block maker in Dodoma: term loan
Facility terms
| AmountLoan application form, p. 1 | Loan application form, p. 1 | |
|---|---|---|
| Tenor and grace periodLoan application form, p. 1; the first 3 months interest only | Loan application form, p. 1; the first 3 months interest only | |
| Interest rateAssumption: the file gives no rate | Assumption: the file gives no rate | |
| RepaymentWorked out: 33 level monthly instalments after the interest-only months; TZS 69,447,000 paid in year 1 | Worked out: 33 level monthly instalments after the interest-only months; TZS 69,447,000 paid in year 1 | |
| SecurityOver the plot valued at TZS 210,000,000, forced-sale value TZS 147,000,000 (valuation report, March 2025, p. 3) | Over the plot valued at TZS 210,000,000, forced-sale value TZS 147,000,000 (valuation report, March 2025, p. 3) |
Press a figure to see the page and line it was read from.
Conditions precedent to drawdown
| Mortgage registered over the plotTitle deed and valuation report, p. 3 | Title deed and valuation report, p. 3 | |
|---|---|---|
| Machine insured, lender named as loss payeeNo insurance policy in the file | No insurance policy in the file | |
| Supplier's quotation for the machineNot in the file; cost taken from the application letter | Not in the file; cost taken from the application letter | |
| Board resolution to borrowNot in the file | Not in the file |
Press a figure to see the page and line it was read from.
Covenants
| DSCR not below 1.25, measured on each year's audited accountsYear 1 in the model; 1.53 in year 2, 1.72 in year 3 | Year 1 in the model; 1.53 in year 2, 1.72 in year 3 | |
|---|---|---|
| Debt to equity not above 1.00After the loan; audited statements 2024, p. 6 | After the loan; audited statements 2024, p. 6 | |
| No further borrowing without the lender's consentFacility letter | Facility letter |
Press a figure to see the page and line it was read from.
Cover is thinnest in year 1, while the new machine works up to full output. The covenant has room in every year of the loan.
What the file does not say
The file gives no rate. The memorandum, the letter, the model and the plan all carry 17% as a marked assumption until your institution sets its own.
How the terms stay the same in every document
- 01
One set of terms behind every document
The memorandum, the letter, the model and the plan are written from the same terms and the same reading of the file, so a committee member never finds one rate in the memorandum and another in the model. - 02
Assumptions you can see
Every assumption is marked where it is used, in the model, the plan and the letter. Your officer can put the institution's own figure in its place. - 03
Covenants the model can test
Each financial covenant is written with the figure that measures it, and the model shows that figure for every year of the loan, so your committee sees how much room the borrower has before a breach. - 04
When the file is too thin for a model
The model is built from the accounts, bank statements and sales records in the file. If the file gives neither a loan amount nor any sales, no model is built, and you are told what it needs.
How you can have it
- As software
- As software, your credit team works the file in LitFin Intelligence and asks Mwikila, our AI Senior Banking & Finance Manager, for the memorandum, the letter, the model or the plan, then edits each one before it leaves the office.
- As a service
- As a service, you send us the file, or your own records if you are the business raising the loan, and the LitFin team writes the documents and returns them for you to check and sign.
Where the work stops
- LitFin Intelligence does not price the loan. The rate, and any term the file does not give, is your institution's to set; until then every document carries it as a marked assumption.
- The memorandum, the letter and the model are for your committee to test. Whether to lend is your committee's decision.
- A plan written for a business raising a loan sets out its case clearly. Whether a lender makes the loan is for that lender to decide.
Also in LitFin Intelligence
- 01LitFin Intelligence puts the appraisal for committee on your desk, written from the file as it reached you. It sets out the sources of repayment, the security and the risks, ties every figure to the page it came from, and lists every missing document with the question to put to the applicant. You edit it, file it and table it at the next sitting.
- 03LitFin Intelligence returns each risk in the file with the page it rests on and the document that would settle it. Your credit officer can ask the borrower for that document before committee. An insurer covering the business sees what it is being asked to cover, and a guarantee fund sees, before any claim, what it would be standing behind.
- 04From LitFin Intelligence you get the project's environmental and social category with the Performance Standards that decided it, and a Green Climate Fund funding proposal drafted in the fund's own form, with its grant element worked out and its missing annexes listed. The carbon side is read against Tanzania's carbon trading regulations. All of it sits on the credit appraisal of the same project, so the climate case and the repayment case come from one file.