Debt

Joint loan: attributing interest and principal between two people

How to attribute a joint loan's yearly interest and principal between two people using what each actually paid, with 50:50 and 60:40 invented examples.

Editorial illustration for Joint loan: attributing interest and principal between two people

To attribute a joint loan's yearly interest and principal to two people, take the interest and principal totals from the lender's statement, then split each in proportion to what each person actually paid. If you paid 60 per cent of the EMIs, your record shows 60 per cent of the interest and 60 per cent of the principal. This is a record for the two of you, not a statement about any claim, deduction or tax treatment.

What do you need?

  • The lender's statement for the year, showing total interest and total principal repaid.
  • The total of EMIs paid in the year.
  • A record of who actually paid each EMI, or how much each person put in.
  • The agreed split, if any, so you can compare it with what happened.

What does the example loan look like?

Say the EMI is ₹15,000 a month. Over twelve months, that is ₹1,80,000. The statement shows ₹1,20,000 of this as interest and ₹60,000 as principal, so 1,20,000 plus 60,000 equals 1,80,000. The numbers are invented, to show the method.

What if the two of you pay 50:50?

Each person paid ₹90,000. Half of the interest is ₹60,000 and half of the principal is ₹30,000, so each person's share of the year is ₹60,000 interest and ₹30,000 principal, adding up to ₹90,000.

What if the payments are 60:40?

Say Person A paid 60 per cent of the EMIs and Person B paid 40 per cent. A paid ₹1,08,000 and B paid ₹72,000. Sixty per cent of the interest of ₹1,20,000 is ₹72,000, and 40 per cent is ₹48,000. Sixty per cent of the principal of ₹60,000 is ₹36,000, and 40 per cent is ₹24,000.

ScenarioPersonPaid in the yearInterest attributedPrincipal attributed
50:50A₹90,000₹60,000₹30,000
50:50B₹90,000₹60,000₹30,000
60:40A₹1,08,000₹72,000₹36,000
60:40B₹72,000₹48,000₹24,000

Check each row: in the 60:40 case, 72,000 plus 36,000 is 1,08,000 for A, and 48,000 plus 24,000 is 72,000 for B. The totals across both people are the lender's totals.

Which formulas make this quick in a sheet?

Put the interest total in B1, the principal total in B2, Person A's payments in B3 and Person B's payments in B4. Then:

  • A's share of payments: =B3/(B3+B4).
  • A's interest: =B1*B3/(B3+B4), and A's principal: =B2*B3/(B3+B4).
  • B's interest: =B1*B4/(B3+B4), and B's principal: =B2*B4/(B3+B4).
  • Check: =(B1*B3/(B3+B4))+(B1*B4/(B3+B4))-B1 should be zero.

What if payments were uneven during the year?

Use totals for the whole year, not the agreed split, because the record should reflect what really happened. If one person paid ₹1,00,000 and the other ₹80,000, the shares are 100,000 divided by 180,000 and 80,000 divided by 180,000, which is about 55.6 per cent and 44.4 per cent.

If you import the account that pays the EMI into SpendixAI, the year's EMI debits can be totalled from reports, but the interest and principal numbers must come from the lender's statement.

A note on interest versus principal: in the early years of most loans the interest part of each EMI is larger, so the person who pays more in those years is attributed more interest. That is simply arithmetic, and it is one more reason to record who paid what in each month and not just a yearly total.

Do the working again at the end of every financial year, and keep the sheets in one folder. A series of yearly pages shows how the interest share shrinks and the principal share grows as the loan ages, and it saves you from rebuilding the numbers when a loan is closed or one of you moves.

A year-end checklist

  1. Get the lender's yearly statement and note the interest and principal totals.
  2. Add up what each person paid, using bank statements.
  3. Run the proportion formulas and write the result for each person.
  4. Keep your own copy of the statement and the working.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports