Enter Loans
Balance‑weighted calculations
| Loan Name | Balance (principal) | APR (%) | Term (months) | Remove |
|---|
Results
Total Balance—
Weighted Average APR—
Weighted Average Term—
Estimated Consolidated Monthly Payment—
Payment uses the balance‑weighted APR and term as an approximation.
Actual consolidation terms depend on lender policies and choices.
Quick Checks
- All balances must be numbers; negative values are ignored.
- APRs are annual; decimals allowed; e.g., 5.75 means 5.75%.
- Terms are in months; 120 months equals 10 years.
- Weighted term reports months plus the equivalent in years.
Example Data Table
Use “Load Example” to fill the input grid with these values.
| Loan | Balance | APR (%) | Term (months) |
|---|---|---|---|
| Loan A | 12,000 | 6.8 | 120 |
| Loan B | 8,500 | 4.5 | 60 |
| Loan C | 15,000 | 5.2 | 96 |
For this example, the weighted average APR ≈ 5.573%,
weighted average term ≈ 95.49 months (≈ 7.96 years),
estimated consolidated payment ≈ PKR 461.11 per month for total balance PKR 35,500.
Formula Used
Let Bᵢ = balance of loan i, rᵢ = APR (decimal), Tᵢ = term in months.
- Weighted average APR: r_w = (Σ Bᵢ rᵢ) / (Σ Bᵢ), report as percent.
- Weighted average term: T_w = (Σ Bᵢ Tᵢ) / (Σ Bᵢ).
- Estimated consolidated payment (approx.): with P = Σ Bᵢ, monthly rate i = r_w/12, months n = T_w, payment M = P·i / (1 - (1+i)^{-n}). If i=0, then M=P/n.
These are balance‑weighted aggregates. They are useful for planning but do not replace lender disclosures.
How to Use This Calculator
- Enter one row per loan: name, balance, APR, and term.
- Click “Add Row” for more loans; “Remove” deletes a row.
- Press “Recalculate” or edit values to update results instantly.
- Use “Download CSV” for spreadsheets and “Download PDF” for sharing.
- “Load Example” fills the grid with sample numbers for practice.
Note: Consolidation offers may use different rates or terms.
Always confirm actual payments with your lender before making decisions.
Weighted Average vs Simple Average (Live Comparison)
Simple averages ignore balances. Weighted averages use balances as weights. This section compares both using the rows you entered.
- Simple average APR: —
- Balance‑weighted APR: —
- Simple average term: —
- Balance‑weighted term: —
Rounding and Reporting Practices
Some lenders report a weighted rate to three decimals. Others round up to the next eighth of a percent (0.125%). Always check specific lender rules.
Weighted APR rounded up to next 0.125%:
—
Weighted APR rounded to three decimals:
—
Balance Weights and Rate Contributions
Each loan’s weight equals its balance divided by the total balance. Multiplying a loan’s APR by its weight gives its contribution to the overall rate.
| Loan | Balance Weight (%) | Rate Contribution (pp) |
|---|