Calculate Loan Repayments: 2026 Formula Guide

By The Chipkie Team, Personal Finance Editorial Team  ·  Last updated 5 November 2026

Whether you are lending your nephew $8,000 for a transmission rebuild or borrowing $40,000 from your parents to start a business, the first thing both sides want to know is the same: what does this cost per month? Learning to calculate loan repayments properly — with real amortization math, not a guess scribbled on a napkin — is what turns a vague family favor into an agreement that survives job changes, moves, and the occasional awkward Thanksgiving.

The math itself is older than the IRS and takes about thirty seconds. The parts people get wrong are the rate, the schedule, and what happens when the borrowed money touches a mortgage application.

Key Takeaways

  • The standard amortizing payment formula is M = P × [r(1+r)^n] ÷ [(1+r)^n − 1], where r is the monthly rate and n is the number of monthly payments.
  • A private loan between family members should charge at least the applicable federal rate (AFR) published monthly by the IRS, or the IRS may impute interest to the lender.
  • The gift tax annual exclusion is $19,000 per recipient per year, and the lifetime gift and estate tax exemption is $15,000,000 per individual following the One Big Beautiful Bill Act.
  • Fannie Mae excludes personal unsecured loans from down-payment funds. Secured borrowing and subordinate financing need separate underwriting; check the actual mortgage program rather than assuming every family loan is eligible.
  • A gift letter must accurately state that no repayment is expected. Disclose a genuine loan instead of signing a false gift declaration.

What is the formula used to calculate loan repayments?

The fixed monthly payment on an amortizing loan is M = P × [r(1+r)^n] ÷ [(1+r)^n − 1]. P is the principal borrowed, r is the periodic interest rate (annual rate divided by 12), and n is the total number of monthly payments. Every payment covers accrued interest first, with the remainder reducing principal.

Here is a worked example. Say a parent lends $30,000 at 5% annual interest over five years:

  • P = $30,000
  • r = 0.05 ÷ 12 = 0.0041667
  • n = 5 × 12 = 60
  • Monthly payment = approximately $566.14
  • Total repaid = about $33,968, of which roughly $3,968 is interest

In a spreadsheet, skip the algebra: =PMT(0.05/12, 60, -30000) returns the same figure. Any decent personal loan repayment calculator does the identical arithmetic, but doing it yourself once means you understand why the number moves when you change the term.

How do you build a family loan repayment schedule?

An amortization schedule lists every payment, splitting it into interest and principal and showing the remaining balance. Build it by multiplying the current balance by the monthly rate to get that month’s interest, subtracting that from the fixed payment to get principal, then reducing the balance. Repeat until the balance reaches zero.

Using the hypothetical $30,000 example, the table below rounds each month’s interest to cents and makes 59 payments of $566.14. The final payment is adjusted to $565.96 to clear the remaining balance:

Payment Payment amount Interest Principal Balance
1 $566.14 $125.00 $441.14 $29,558.86
2 $566.14 $123.16 $442.98 $29,115.88
3 $566.14 $121.32 $444.82 $28,671.06
60 $565.96 $2.35 $563.61 $0.00

A schedule shows how payments divide between interest and principal. Keep the chosen rounding convention visible and reconcile the final payment. Our family loan repayment schedule guide explains the records to retain.

Structures worth considering:

  1. Fully amortizing — equal payments, balance hits zero on the final date. Cleanest and most common.
  2. Interest-only with balloon — low monthly cost, full principal due at the end. Risky unless the borrower has a defined payoff event.
  3. Straight-line principal — fixed principal plus declining interest, so payments shrink over time. Less interest paid overall.
  4. Zero-interest with documented terms — permitted between family, but read the AFR section below before assuming it is tax-free.

What interest rate should you charge on a private loan?

Check state interest limits and federal below-market tax rules separately. The AFR is a tax benchmark, not a universal minimum legal lending rate. Exceptions and special limits can affect imputed interest; IRS Publication 550 explains the framework.

The IRS publishes AFRs monthly. For term classification, short-term means not over three years, mid-term means over three but not over nine, and long-term means over nine. Select the relevant tax treatment and compounding convention rather than applying a remembered rate to every loan.

A few related points lenders consistently miss:

  • Report taxable interest. Schedule B is required in specified circumstances, not for every dollar of interest. Follow the applicable Form 1040 and Schedule B instructions; our family loan interest reporting guide explains the records.
  • Gift reporting is separate. The 2026 annual exclusion is $19,000 per donor per recipient for qualifying gifts. Determine each spouse’s gift and any gift-splitting filing requirements rather than assuming automatic doubling.
  • Form 709 is required when gifts to one person exceed the annual exclusion. Filing it rarely means tax is due — it simply draws against the $15,000,000 lifetime exemption set by the One Big Beautiful Bill Act.
  • De minimis exceptions exist for small loans, but they are fact-specific. Confirm with a CPA rather than assuming.

Can you use a family loan for a home down payment?

For a Fannie Mae loan, B3-4.3-17 excludes personal unsecured loans from down-payment, closing-cost and reserve funds. B3-4.3-15 addresses eligible asset-secured borrowing. Other programs and family secondary financing require their own underwriting decision; a lien alone does not guarantee acceptance.

Ask the mortgage lender to confirm the proposed funding source before money moves. Source eligibility, collateral, repayment obligations and debt ratios are related but separate checks; passing one does not settle the others.

The workable paths:

  • A true gift — the family signs a gift letter, the money is never repaid, and the lender documents the transfer.
  • Approved secured borrowing — provide the actual collateral and repayment documents. Debt-ratio treatment and subordinate-financing requirements depend on the source and program; some financial-asset-secured loans have special treatment.
  • Documented savings — retain source records and disclose any borrowing. Keeping a family advance in an account does not change its nature or erase the repayment obligation.

On gift letters: if repayment is expected, do not sign a statement saying otherwise. A knowingly false statement to influence a mortgage lender can create serious legal consequences. Give the lender the actual agreement and obtain advice if its treatment is unclear.

Frequently asked questions about private loan repayments?

How do I calculate loan repayments with no interest?

Divide the principal by the number of payments. A $12,000 interest-free loan over 24 months is exactly $500 per month. Document it anyway — and check whether the forgone interest creates a gift under IRS rules, since the AFR applies to related-party loans even at zero stated interest.

Does a family loan show up on my credit report?

Generally no. Private lenders do not report to Equifax, Experian, or TransUnion, so the loan is invisible to scoring models. It still must be disclosed on a mortgage application. Our breakdown of how family loans interact with credit scores covers the exceptions.

What happens if the borrower stops paying?

A genuine written agreement can provide evidence, but validity, enforceability and filing deadlines depend on state law and the instrument. Oral agreements can sometimes be enforceable too. Keep records and obtain local advice promptly; do not assume a universal deadline or that an acknowledgment restarts it.

Can I change the schedule if the borrower hits hardship?

If both parties agree and the change is legally effective, record the revised payment dates, amounts and interest treatment clearly. Confirm what is paused, waived or still owed. Obtain advice if the change affects security, tax treatment or enforcement deadlines.

What is the right next step?

Run the numbers first, then put them in writing. Calculate the payment, print the full amortization table, pick a rate at or above the current AFR, and make sure both sides see the same balance every month. If the money is heading toward a home purchase, call the lender before a dollar moves — the structure matters more than the amount.

When you are ready to formalize it, you can create a written loan agreement with a built-in repayment schedule in minutes — clear terms, tracked balances, and no guesswork about who owes what.

Disclaimer: The information provided in this article is for informational purposes only and should not be considered financial or legal advice. Laws and lending criteria vary significantly between states. We always recommend consulting with a qualified real estate attorney and financial advisor before entering into a property purchase or financial arrangement with another party.

Share this post!

More from the Chipkie Blog