Is my JIBAR loan ready?
Work through the checklist, then enter one loan to see its interest on compounded ZARONIA with the credit adjustment spread. Fields marked assumption are not facts: change them to match your agreement.
1. Checklist: what to ask and check 0 of 12 answered
Choose an answer for each question. Open items go on the printed summary.
2. The loan
3. The rate
Published figure: Bloomberg technical note of 22 Dec 2025 (S5). Your lender's amendment may use another one.
Off in the MPG loan convention. On, the whole observation period is shifted back by the lookback (S1 Appendix D).
Download the daily values from the SARB's ZARONIA page (about 10:00 each business day), then paste. Dates as 2026-12-24 or 24/12/2026; rates as 7.115 or 7,115.
4. Covenants (optional)
5. Results
6. Method
For each business day of an interest period the check finds the ZARONIA rate dated the lookback number of business days earlier (Johannesburg calendar), compounds those rates with the number of calendar days each applies, takes the growth as a simple Actual/365 annual rate rounded to six decimals, adds the margin and the credit adjustment spread, applies it to the amount for the days in the period and rounds the interest to the cent once at the end (MPG loan conventions, Appendix A). With the observation shift switched on, the observation period is moved back by the lookback instead (Appendix D). The code reproduces the Reserve Bank's own worked example (R1 million, 14 March to 14 April 2023, compounded rate 7.1595%, interest R7 779.30) and its workbook's rate for every end date of that example. Sources and dates: sources page.
Not modelled: floors, prepayments or trades during a period, lender splits, payment lags, hedge accounting. Not legal or financial advice, and not a certificate of anything.