Forward, Reverse and Affordability Loan Calculators Explained
The three calculators every workplace-banking lender needs — forward (amount to instalment), reverse (instalment to maximum amount), and the payslip affordability check — and how they guide the pre-sale conversation.
Most check-off lending conversations begin with a question, and it is almost always one of three. The customer wants to know what a given loan will cost them each month, or how much they can borrow for a repayment they can comfortably manage, or simply how far their payslip will stretch once every deduction has been accounted for. The LoanCalculator service in Creodata's Workplace Banking platform answers each of these with a dedicated mode — forward, reverse and affordability — so that a Direct Sales Executive (DSE) can have a grounded, numerate discussion at the very first stage of the workflow rather than promising figures the credit team will later have to walk back. This article explains what each calculator answers, how scheme parameters feed the arithmetic, and where the moratorium and break-period interest quietly shift the numbers.
Three questions, three calculators
The three modes exist because borrowers and salespeople do not all start from the same known quantity. Sometimes the loan amount is fixed in the customer's mind — they need KES 800,000 for a specific purpose. Sometimes the constraint is the monthly instalment they can bear. And sometimes the only honest starting point is the payslip itself, before any figure has been mentioned at all.
- The forward calculator takes a loan amount and the scheme's parameters and returns the equated monthly instalment (EMI) and repayment profile. It answers: "If I borrow this, what will I pay each month?"
- The reverse calculator takes a desired or affordable monthly repayment and works back to the maximum loan amount that repayment can service. It answers: "If I can pay this much a month, how much can I borrow?"
- The affordability check takes the customer's payslip items — allowances and deductions — and computes their maximum borrowing capacity, factoring in the minimum take-home policy. It answers: "Given everything coming in and out of my pay, what can I actually afford?"
All three live in the same service and draw on the same scheme configuration, so the figures stay consistent whichever way the conversation opens. Because the affordability check has its own depth — payslip line items, the buy-off treatment, the bank-maintained variable list — we cover it in detail in the payslip affordability guide and keep this article focused on how the three modes relate.
How scheme parameters drive the maths
None of the calculators work in the abstract. Each loan belongs to an employer scheme, and once the DSE selects that scheme the platform loads its parameters and applies them to every computation. These are maintained per employer in the EmployerScheme service, so two customers at different employers running different schemes will see different results for an otherwise identical request — which is exactly the behaviour a workplace lender needs.
The parameters that feed the arithmetic are:
| Scheme parameter | Role in the calculation |
|---|---|
| Interest rate | The per-annum rate applied to the outstanding balance to derive the interest portion of each instalment |
| Minimum and maximum loan amount | Bounds the loan amount the forward calculator accepts and the reverse calculator can return |
| Minimum and maximum tenure | Bounds the repayment period over which instalments are equated |
| Processing fees | A scheme charge factored into the cost of the facility |
| Insurance amount payable | The premium attached to the facility, recovered as part of the loan economics |
The EMI concept sits at the centre of the forward and reverse modes. An equated monthly instalment is a single, level repayment amount that stays constant across the tenure, with each instalment splitting into an interest portion and a principal portion. The platform equates these so that the borrower pays the same amount every month, and — importantly for check-off — so that the deduction booked against the payslip matches the repayment schedule rather than drifting from it. The maths is the same in both directions; the forward calculator solves for the instalment given the amount, and the reverse calculator solves for the amount given the instalment.
The forward calculator at work
The forward calculator is the most familiar of the three. The DSE enters a loan amount and a tenure within the scheme's permitted range, the calculator applies the scheme interest rate, processing fees and insurance, and returns the EMI alongside the repayment profile. It is the right tool when the customer already knows what they want to borrow — a new loan for a known purpose, or a top-up of an existing facility — and needs to understand the monthly commitment before committing.
Consider an illustrative case: a customer earning, say, KES 120,000 a month asks what an KES 800,000 loan over 48 months would cost under their employer's scheme. The DSE enters the amount and tenure, the calculator pulls that scheme's rate, fees and insurance figure, and returns a level monthly instalment. If the resulting EMI looks too high against the customer's take-home, the natural next move is to switch to the reverse calculator or run a full affordability check rather than guess at a different amount.
The reverse calculator at work
The reverse calculator inverts the question. Here the known quantity is a monthly repayment — perhaps the amount the customer says they can comfortably set aside, or the headroom that an affordability check has already revealed — and the calculator returns the maximum loan amount that repayment can support over a given tenure at the scheme rate, within the scheme's minimum and maximum bounds.
This mode is particularly useful in scheme banking because affordability so often leads the conversation. A salaried borrower frequently knows their net pay and their existing commitments far better than they know what loan size those numbers imply. Running the reverse calculator turns a comfortable repayment figure into a realistic loan ceiling, which keeps the pre-sale discussion honest and reduces the chance of an application being sized beyond what the credit team and the business-rules checks will ultimately allow.
Where the moratorium and break-period interest change the figures
A repayment schedule for a check-off loan is rarely a clean monthly series starting the month after disbursement, and the calculators reflect that. Two platform rules shape the timing of repayments and therefore the figures the customer sees.
First, a one-month moratorium applies, and the first instalment falls due on the 10th of the month after the moratorium expires. This deliberately delays the first deduction so it aligns with the payroll cycle rather than landing awkwardly mid-month.
Second, where the first repayment date is more than one month after the booking date, break-period interest applies: interest for the gap is calculated daily and paid monthly until the regular schedule begins. The EMI calculation factors in both the booking date and the first-repayment date so that all instalments remain equated and — critically — the check-off booking is never less than the repayment schedule. In practice this means the figure the customer agrees to at pre-sale holds together once the loan is booked in the core banking system, rather than needing a correction at disbursement. The mechanics of booking, value dates and schedule amendment are covered in loan booking and disbursement.
Where the calculators sit in the workflow
The calculators are not a standalone utility; they are stage one of a defined process. In the platform's 13-stage loan workflow, Pre-Sale Calculation is the first stage and it belongs to the DSE. Before any application is captured, before a single document is collected, the DSE uses the LoanCalculator to set realistic expectations with the customer. Only once the figures make sense does the file move forward to Customer Application and Document Collection.
This sequencing matters. A grounded pre-sale calculation reduces the volume of applications that fail later at Credit Analysis or Credit Approval for affordability reasons, which in turn protects turnaround times across the whole pipeline. The calculator modes, the workflow stages and the compliance gates all form one connected origination journey — the broader picture is set out in the complete guide to workplace banking.
A quick comparison of the three modes:
| Mode | Input | Output | When the DSE uses it |
|---|---|---|---|
| Forward | Loan amount + scheme parameters (rate, tenure, fees, insurance) | EMI / repayment profile | Customer knows the amount they want to borrow |
| Reverse | Desired or affordable monthly repayment + tenure | Maximum loan amount (within scheme bounds) | Customer knows the repayment they can manage |
| Affordability | Payslip items — allowances and deductions, plus any buy-offs | Maximum borrowing capacity (net of the minimum take-home policy) | No figure is fixed yet; sizing from the payslip up |
Used together, the three modes let a DSE move fluidly between "what will it cost", "what can I borrow" and "what can I afford" without ever leaving the platform or inventing numbers — and every figure carries through to the application that follows.
Frequently asked questions
What is the difference between the forward and reverse calculators?
The two are the same EMI calculation solved in opposite directions. The forward calculator starts from a known loan amount and returns the equated monthly instalment and repayment profile, so it answers "if I borrow this, what will I pay each month?". The reverse calculator starts from a known or affordable monthly repayment and returns the maximum loan amount that repayment can service, so it answers "if I can pay this much, how much can I borrow?". A DSE typically uses the forward mode when the customer has a fixed amount in mind, and the reverse mode when the constraint is the monthly instalment the customer can comfortably bear.
Do the calculators include fees and insurance?
Yes. Each calculation is anchored to the selected employer scheme, and the scheme parameters include the processing fees and the insurance amount payable alongside the interest rate and the minimum and maximum tenure and loan amount. These figures feed the cost of the facility so the repayment the customer sees at pre-sale reflects the scheme's actual charges rather than interest alone. The moratorium and any break-period interest are also factored into the schedule, with break-period interest calculated daily and paid monthly where the first repayment date falls more than a month after booking, so the instalments remain equated and the check-off booking matches the repayment schedule.
Can a customer get a binding offer from the calculator?
No. The calculators are a pre-sale tool that produces indicative figures to guide the conversation at stage one of the workflow; they do not constitute an approval or a binding offer. A formal loan offer is generated later, after the customer's application has progressed through document collection, and it is the offer the customer executes and uploads — with an OTP sent by SMS — that carries weight. The credit analysis and approval stages, together with the deterministic business-rules and external compliance checks, determine the final terms. The calculator's job is to make sure the application that reaches those stages is realistic, not to pre-empt their decision.
To see how the three calculator modes fit into the wider origination journey, explore the Workplace Banking product page or book a demo to walk through a pre-sale calculation, application and disbursement end to end.