BL
Finance
Karatasi Bond Laddering Template
A step-by-step Excel template that turns a lump sum into monthly income via a six-rung Kenyan T-bond ladder. Set goals, build the ladder, track purchases — with auto-tax, cash-flow calendar, and plan-
KES
1,500
one-time · instant download
- Features (one per line)22:10Claude responded: Six-rung Treasury bond ladder for monthly incomeSix-rung Treasury bond ladder for monthly income
- Feasibility check on your target income
- FXD vs IFB comparison guide
- Automatic withholding tax (15% / 10% / 0% IFB)
- Face values floor to KES 50,000 increments
- Actual purchases tracker with auto-calculated fields
- Monthly cash-flow calendar
- Plan vs actual variance analysis
- Maturity timeline chart
- Summary dashboard with seven KPIs
- Built for Kenyan T-bond auctions
Get this template
Pay with M-Pesa, card, or bank. Files sent to your email immediately after payment.
Karatasi Bond Ladder — Monthly Income Planner
A guided Excel template that turns a lump sum into monthly income using a six-rung Kenyan Treasury bond ladder.
What it does
- Distributes capital across six bonds with staggered coupon months
- Calculates expected monthly income, net of withholding tax
- Tracks actual purchases against the plan
- Visualises cash-flow calendar and maturity timeline
Inside
- Start Here — four-step journey
- Step 1 — Goals & feasibility check
- Step 2 — FXD vs IFB guide
- Step 3 — Build the ladder
- Step 4 — Track purchases
- Income & Charts
- Summary dashboard
Built for Kenya
KES 50,000 minimums, semi-annual coupons, automatic 15% / 10% withholding tax, IFB tax exemption.
Projections are estimates, not guarantees.