Finance
XIRR calculator
Calculate annualized internal rate of return for irregular, dated investments and cash flows.
Calculate equated monthly installments (EMI), total interest payable, and repayment schedules for home loans, auto loans, and personal financing directly in your browser. All financial calculations occur locally in your tab with zero data uploaded. Toggle between yearly summaries and month-by-month amortization schedules, inspect principal versus interest ratios, download CSV schedules, and explore illustrative home, car, and personal loan presets.
Client-only calculation. Loan numbers and amortization tables are computed entirely in your browser and never uploaded. Presets and rates are illustrative.
Illustrative Loan Presets
Total amount borrowed
Annual percentage rate (APR)
Repayment duration
$1,896.20
Per month for 360 months (30 yrs)
$382,636.71
56.1% of total loan payment
$682,636.71
Principal $300,000.00 + Interest
Detailed breakdown of principal reduction and interest amortized over time
| Year | Principal Paid | Interest Paid | Total Payment | Ending Balance |
|---|---|---|---|---|
| Year 1 | $3,353.12 | $19,401.28 | $22,754.40 | $296,646.88 |
| Year 2 | $3,577.68 | $19,176.72 | $22,754.40 | $293,069.20 |
| Year 3 | $3,817.29 | $18,937.11 | $22,754.40 | $289,251.91 |
| Year 4 | $4,072.94 | $18,681.46 | $22,754.40 | $285,178.97 |
| Year 5 | $4,345.71 | $18,408.69 | $22,754.40 | $280,833.26 |
| Year 6 | $4,636.75 | $18,117.65 | $22,754.40 | $276,196.51 |
| Year 7 | $4,947.30 | $17,807.10 | $22,754.40 | $271,249.21 |
| Year 8 | $5,278.62 | $17,475.78 | $22,754.40 | $265,970.59 |
| Year 9 | $5,632.13 | $17,122.27 | $22,754.40 | $260,338.46 |
| Year 10 | $6,009.32 | $16,745.08 | $22,754.40 | $254,329.14 |
| Year 11 | $6,411.79 | $16,342.61 | $22,754.40 | $247,917.35 |
| Year 12 | $6,841.18 | $15,913.22 | $22,754.40 | $241,076.17 |
| Year 13 | $7,299.36 | $15,455.04 | $22,754.40 | $233,776.81 |
| Year 14 | $7,788.20 | $14,966.20 | $22,754.40 | $225,988.61 |
| Year 15 | $8,309.84 | $14,444.56 | $22,754.40 | $217,678.77 |
| Year 16 | $8,866.33 | $13,888.07 | $22,754.40 | $208,812.44 |
| Year 17 | $9,460.12 | $13,294.28 | $22,754.40 | $199,352.32 |
| Year 18 | $10,093.70 | $12,660.70 | $22,754.40 | $189,258.62 |
| Year 19 | $10,769.69 | $11,984.71 | $22,754.40 | $178,488.93 |
| Year 20 | $11,490.95 | $11,263.45 | $22,754.40 | $166,997.98 |
| Year 21 | $12,260.53 | $10,493.87 | $22,754.40 | $154,737.45 |
| Year 22 | $13,081.64 | $9,672.76 | $22,754.40 | $141,655.81 |
| Year 23 | $13,957.73 | $8,796.67 | $22,754.40 | $127,698.08 |
| Year 24 | $14,892.51 | $7,861.89 | $22,754.40 | $112,805.57 |
| Year 25 | $15,889.89 | $6,864.51 | $22,754.40 | $96,915.68 |
| Year 26 | $16,954.05 | $5,800.35 | $22,754.40 | $79,961.63 |
| Year 27 | $18,089.49 | $4,664.91 | $22,754.40 | $61,872.14 |
| Year 28 | $19,300.99 | $3,453.41 | $22,754.40 | $42,571.15 |
| Year 29 | $20,593.64 | $2,160.76 | $22,754.40 | $21,977.51 |
| Year 30 | $21,977.51 | $781.60 | $22,759.11 | $0.00 |
30-year home mortgage for $300,000 at 6.5%
Monthly EMI is $1,896.20. Over 360 months, total interest paid is $382,633.47 and total loan repayment is $682,633.47. Download the complete 30-year amortization schedule as loan-amortization-schedule.csv.
EMI is the fixed monthly payment that clears a reducing-balance loan. Comparing two offers on EMI alone hides total interest; the schedule shows how much of an early payment is interest.
This is the standard equated-installment formula, not a UK mortgage illustration with fees, or an Indian floating-rate reset.
Monthly rate r = APR / 12 / 100. For r > 0: EMI = P × r × (1+r)^n / ((1+r)^n − 1), with n = tenure in months. For r = 0: EMI = P / n. Each month, interest = balance × r, principal = EMI − interest, balance falls by principal.
Fixed rate, no fees, no tax relief, not advice. Lenders round differently.
Same arithmetic as VAT. India then splits the tax for intra-state invoices.
Finance
Calculate annualized internal rate of return for irregular, dated investments and cash flows.
Finance
Calculate how many units you need to sell to cover fixed overhead and reach profit goals.
Finance
Calculate the required retirement corpus, future monthly living expenses adjusted for inflation, and required monthly savings.
Finance
Calculate Indian Goods and Services Tax (GST), CGST, SGST, IGST, and net/gross invoice values client-side.
Finance
Add or extract UK VAT at 20%, 5%, or 0% from a net or gross amount.
Finance
Estimate monthly payment, interest, and an optional balloon on a seller note.
Finance
Calculate monthly payments, total interest, and balloon payoff from the buyer's perspective.
Finance
Calculate swimming pool loan monthly payments, total interest, down payment, and payoff schedule.
Finance
Calculate Net Present Value (NPV), Profitability Index, IRR, and discounted payback periods for capital investment projects. Free browser DCF solver.