Loan Repayment Simulator (Monthly Payment, Total Cost & Prepayment)
Enter the loan amount, interest rate and term to calculate the monthly payment, total repayment, total interest and payoff date. Works for mortgages, car loans and education loans, with switching between equal-payment (annuity) and equal-principal repayment, bonus payments, and export of the repayment schedule (yearly and monthly). On this single page you can also work backwards to see how much you can borrow if you pay a set amount per month, and compare the term-shortening and payment-reducing types of prepayment.
Loading...
ABOUT
About Loan Repayment Simulator (Monthly Payment, Total Cost & Prepayment)
The Loan Repayment Simulator calculates your monthly payment, total repayment, total interest and payoff date from just three inputs: loan amount, interest rate and term. It works for mortgages as well as car loans, education loans and personal loans. You can switch between equal-payment (annuity) and equal-principal repayment, set bonus payments, and export a yearly or monthly repayment schedule. On the same page you can work backwards to see how much you can borrow if you pay a set amount per month, and compare prepayment in the term-shortening and payment-reducing types.
How to use Loan Repayment Simulator (Monthly Payment, Total Cost & Prepayment)
- 1Enter the "Loan amount", "Interest rate (annual)" and "Term" (you can also pick a preset and adjust it)
- 2If needed, set the repayment method (equal payment / equal principal) and the amount to repay with bonus payments
- 3Check the monthly payment, total repayment, interest and payoff date, plus the yearly breakdown chart
- 4Switch the repayment schedule between yearly and monthly, and copy it for a spreadsheet if needed
- 5On the "Borrowing capacity" tab, work backwards from the amount you can pay each month or from your annual income
- 6On the "Prepayment effect" tab, enter the amount and timing to compare the term-shortening and payment-reducing types
Great for
- Check the monthly payment and 35-year total repayment before taking out a mortgage
- Compare how much the total repayment changes when the rate differs by 0.1%
- Estimate how far your payment could rise if a variable rate goes up
- Work backwards from the amount you can pay monthly or your debt-to-income ratio to a comfortable borrowing amount
- See how much interest you save and how many years sooner you finish if you prepay with spare funds
- Compare the monthly burden and total interest of equal-payment and equal-principal repayment
- Cross-check the repayment plan for a car loan or education loan against the dealer's or bank's estimate
- Export the repayment schedule and paste it into a household budget or financial plan
Good to know
- Monthly interest is calculated as "balance before payment × monthly rate (annual rate ÷ 12)" and rounded down to the yen. Each payment is also rounded down to the yen, and the remainder is adjusted in the final payment.
- Rounding and daily-interest methods differ between lenders, so the actual payment may differ by tens to hundreds of yen. Check your lender's own estimate for exact figures before signing.
- Only principal and interest are included. Fees such as processing fees, guarantee fees, group credit life insurance, registration costs and fire insurance are not included.
- Even for variable-rate loans, this calculation assumes the rate you enter stays the same throughout. Future rate changes are not reflected, so we recommend trying several rates.
- Bonus payments are calculated in the common way: the specified part of the loan is repaid twice a year, in June and December. Interest on the bonus portion is calculated every six months at half the annual rate.
- The borrowing capacity is only a rough guide worked backwards from the payment. Actual loan amounts are decided by the lender based on annual income, years of employment, other debts, the appraised value of the property and so on.
- Prepayment fees are not included in the calculation. Some lenders charge a fee for each prepayment.
- Everything you enter is processed in your browser and is not sent to any server.
Questions this tool answers
Use Loan Repayment Simulator (Monthly Payment, Total Cost & Prepayment) for searches like these:
- I want to know how much I'll pay each month after taking out a mortgage
- I want to know the total repayment and interest for 30 million yen over 35 years
- I want to check how much the total repayment changes if the rate differs by 0.1%
- I want to work backwards to see how much I can borrow with 100,000 yen a month
- I want a guide to a comfortable borrowing amount based on my annual income
- I want to calculate how much interest a prepayment saves
- I want to compare which is better, term-shortening or payment-reducing prepayment
- I want to check whether earlier prepayment is better
- I want to see the difference between equal-payment and equal-principal repayment in yen
- I want to know how much bonus payments lower the monthly payment
- I want to calculate monthly payments for a car loan or education loan
- I want to create a repayment schedule (amortization table) and paste it into a spreadsheet
- I want to estimate how much the payment rises if a variable rate goes up
- I want to compare how much refinancing would reduce the total repayment
FAQ
- What is the monthly payment for a 30 million yen loan over 35 years at 1.0%?
- With equal-payment repayment and no bonus payments, the monthly payment is about 84,685 yen. The total repayment is about 35.56 million yen, of which about 5.57 million yen is interest. These figures change a lot with the rate and term, so enter your own conditions to check.
- Which is better, equal-payment or equal-principal repayment?
- In terms of total repayment (total interest) alone, equal-principal repayment is lower, because the principal falls faster and so less interest accrues. However, the burden is heaviest right after repayment starts, and the borrowing capacity also tends to be smaller. Many people choose equal-payment repayment because the monthly amount is constant and easy to plan around, and equal-payment is the mainstream in actual products. In this tool you can switch between the two and compare the monthly burden and the total in numbers.
- Which is better for prepayment, the term-shortening or the payment-reducing type?
- Looking only at interest savings, the term-shortening type is better: for the same amount, fewer remaining payments means more interest saved. The payment-reducing type, on the other hand, lowers your monthly payment, which suits cases where you want breathing room in your household budget, such as when education costs overlap. This tool calculates both under the same conditions and shows the interest saved and the monthly payment side by side.
- Is an earlier prepayment more effective?
- For the same amount, the earlier the better. The balance is largest in the early years, and all the interest that would have accrued on it disappears. This tool has a comparison table for "prepaying after 1, 3, 5... years" so you can see the difference by timing in yen. However, avoid using up all your cash on hand and consider an amount that leaves an emergency fund.
- How much can I borrow if I pay 100,000 yen a month?
- It depends on the rate and term. As a guide, about 35.43 million yen at 1.0% for 35 years, about 32.66 million yen at 1.5% for 35 years, and about 26.53 million yen at 1.0% for 25 years (equal-payment, no bonus payments). The "Borrowing capacity" tab also shows a quick-reference table combining terms and rates.
- Can I work out how much I can borrow from my annual income?
- On the "Borrowing capacity" tab, choose your annual income and debt-to-income ratio (the share of annual income spent on annual repayments) to get a guide for the amount you can pay each month. Lenders often use a ratio of 25 to 35% as a benchmark, but the level you can comfortably repay depends on your take-home pay and other expenses. Also note that the screening rate is often set higher than the rate actually applied.
- How much does the total repayment change if the rate differs by 0.1%?
- For a 30 million yen loan over 35 years, a 0.1% difference in the rate changes the total repayment by about 590,000 yen. The larger the loan and the longer the term, the bigger the gap. This tool shows a comparison table with rates around the one you entered, which you can use when negotiating a rate or considering refinancing.
- Does using bonus payments reduce the total repayment?
- Basically no. Bonus payments lower the monthly payment by paying that part in a lump in the bonus months, and the total repayment usually rises slightly (because interest on the bonus portion is calculated every six months). There is also a risk of struggling to repay if your bonus shrinks or stops, so decide the share carefully.
- What happens if a variable rate goes up?
- This tool assumes the rate you enter continues until the loan is paid off. If you expect future increases, also calculate with a higher rate and see how far the monthly payment rises. The rate comparison table also shows at a glance the difference in total repayment if the rate rises by 0.5% or 1.0%. Note that many actual variable-rate products have the "5-year rule and 125% rule" (the payment is reviewed only every five years, and can rise by at most 1.25 times), in which case the payment increases differently.
- Can I create a repayment schedule (amortization table)?
- Yes. You can switch between yearly and monthly views, and each payment, principal, interest and balance is listed. The table can be copied as tab-separated text, so you can paste it straight into Excel or Google Sheets.
- Are fees and guarantee charges included in the calculation?
- No. This tool calculates only principal and interest. Mortgages involve separate costs such as processing fees (around 2.2% of the loan amount), guarantee fees, registration costs and fire insurance, which together can reach hundreds of thousands to over a million yen. Estimate them separately when considering your total budget.
- Why is the amount slightly different from my bank's simulation?
- The main reason is differences in rounding. Whether the payment is rounded up or down to the yen, and whether interest is calculated daily or monthly, differs between lenders. This tool uses monthly calculation with rounding down to the yen and puts the remainder in the final payment, so differences of tens to hundreds of yen can occur. It is sufficient for grasping the scale and trend of the amounts, but always confirm the contract amount in your lender's documents.
Special Thanks