Interest Only Loan-Mac

System
System Member admin
This discussion was created from comments split from: Interest Only Setup.

Comments

  • David75019
    David75019 Quicken Mac Subscription Member
    Hello,
    I am looking for a similar solution but for Mac... The instructions above do not work for Mac as it is impossible to enter only the interest amount :-(
    Has anyone found a solution?
    Many thanks!
    David
  • jacobs
    jacobs Quicken Mac Subscription SuperUser, Mac Beta Beta
    I don't believe you can use the loan feature in Quicken Mac to create an interest-only loan. However, with one manual step, you can easily accomplish what you want.

    First, create a Liability account as a manual account not tied to a financial institution. (Click "My bank is not in the list" at the bottom of the Add Liability Account screen, and then click "Add Manual Account".)

    Next, you need to create the amount of the loan. Typically, if you are just receiving the money, you would enter an opening balance of zero when you create the account. Then, you'd enter a transaction to establish the loan and the receipt of cash:
        Payee: "Received from XYZ"
        Increase: Amount received
        Category: "Transfer:[your checking/savings account]"
    This will create the liability amount, and put the cash in whatever account you put it in.

    Alternatively, if this is an existing loan and you don't want to go back in time to deal with the money you received, you can just enter the amount of the loan as the opening balance of the liability account -- establishing the loan but not the receipt of the funds.

    Now here's the one manual part: you need to calculate the amount of the payments. Since there loan is interest-only, you won't have an amortization amount which changes monthly, use a simple calculation base don the interest amount and frequency of payment. (For instance, if your loan is 4% annually, and you're paying monthly, your monthly interest payment is .04 ÷ 12 = .003333 times the amount of the loan.)

    Finally, you create a scheduled transaction in Quicken for this monthly payment. Since the loan amount is not changing, the loan account isn't even involved; the payment is a simple transaction in your checking account to pay your lender the calculated amount, with the category being interest expense. Set the schedule of the transaction for the frequency and duration of your loan, and it will pop up every month (or quarter or year).

    Essentially, you're only recording a monthly interest payment from your checking account. The loan (liability) account never changes until you pay it off or pay it down. 
    Quicken Mac Subscription • Quicken user since 1993
This discussion has been closed.