Apportioning loan interest between 2 investors

Discussion in 'Accounting & Tax' started by Maryanne__, 20th May, 2008.

Join Australia's most dynamic and respected property investment community
  1. Maryanne__

    Maryanne__ New Member

    Joined:
    1st Jul, 2015
    Posts:
    4
    I need some help with a spreadsheet that will apportion loan interest beween 2 investors, where there is one loan, and each investor has drawdowns and repayments. I have the loan statements, and therefore know what the interest is, but am having trouble working out how to apportion the interest.

    Any help would be appreciated please
     
    Maryanne__, 20th May, 2008
    #1
  2. Rob G

    Rob G Well-Known Member

    Joined:
    16th Oct, 2015
    Posts:
    966
    Location:
    Melbourne
    Is this for tax deduction purposes or merely financial ?

    Is it an IO or P&I loan ?

    Cheers,

    Rob
     
    Rob G, 20th May, 2008
    #2
  3. BillV

    BillV Well-Known Member

    Joined:
    19th Jun, 2015
    Posts:
    1,555
    Location:
    Sydney
    It's easy when you deal in percentages of the total borrowings
    eg total loan is $100K
    Borrower A loan is $60K therefore he pays 60% of the total interest + bills
    Borrower B loan is $40K therefore he pays 40% of the total interest + bills

    Cheers
     
    BillV, 21st May, 2008
    #3
  4. Maryanne__

    Maryanne__ New Member

    Joined:
    1st Jul, 2015
    Posts:
    4
    Hi Bill, the calculation is for tax purposes and it is an interest only loan. Each investor has been using some of the loan for private purposes, and then redepositing some of the funds back into the loan. It has become very messy.
     
    Maryanne__, 21st May, 2008
    #4
  5. Simon Hampel

    Simon Hampel Founder Staff Member

    Joined:
    3rd Jun, 2015
    Posts:
    12,414
    Location:
    Sydney
    The problem is when there are repayments as well - especially if there is a mixed (investment/personal) use of the funds, the ATO may decide that any repayment will be of the investment funds first!
     
    Simon Hampel, 21st May, 2008
    #5
  6. Maryanne__

    Maryanne__ New Member

    Joined:
    1st Jul, 2015
    Posts:
    4
    Hi Bob, the loan is interest only and is to claim a tax deduction
     
    Maryanne__, 21st May, 2008
    #6
  7. BillV

    BillV Well-Known Member

    Joined:
    19th Jun, 2015
    Posts:
    1,555
    Location:
    Sydney
    I suggest you use an accountant to work out what's deductible and what's not.

    You should be using a separate account to deposit your income and for all your private expenses.

    You should investigate the possibility of changing the type of loan and to add an 100% offset savings account for each borrower.

    I'd talk to an accountant immediately and then go straight to the bank.

    Cheers
     
    BillV, 21st May, 2008
    #7
  8. Rob G

    Rob G Well-Known Member

    Joined:
    16th Oct, 2015
    Posts:
    966
    Location:
    Melbourne
    Read TR 2000/2.

    If this seems unclear then an Accountant is recommended.

    With a spreadsheet, it might be easier to track your respective borrowings separately to apportion interest expense.

    However, joint borrowings have had unfortunate tax side-effects when your Associate makes a repayment it may be deemed to be a partial repayment of YOUR investment loan if you have joint investments. One pays down their borrowing may be deemed to only pay down HALF of theirs and HALF of yours. AND they get to claim your half of the interest deductions that you lost.

    I have even met Accountants who are unsure on this one.

    Please don't say you have mixed any drawings for private use as well .....

    Maybe just go to an Accountant to be sure. There are many pitfalls with interest deductions in anything but the most simple scenario.

    Cheers,

    Rob
     
    Rob G, 21st May, 2008
    #8