The Math Behind Nav’s OnDeck APR Calculator (Daily Debit Loan Calculator)

The Math Behind Nav’s OnDeck APR Calculator (Daily Debit Loan Calculator)

The Math Behind Nav’s OnDeck APR Calculator (Daily Debit Loan Calculator)

OnDeck Capital is one of the most popular daily debit business loan products. The OnDeck APR Calculator not only works for OnDeck but also most of the daily debit, cashflow based loan products. It’s a good tool to figure out the APR and make an apple-to-apple comparison with a merchant cash advance or a term loan.

 

Powered by nav


First, I would like to mention that the APR we calculate here is not 100% precise. But it’s very close. The reason is that most of the daily debit loans only debit on business days, not weekend days. If you get funded on a Friday, you don’t start paying until two days later (Monday). But if you get funded on a Monday, you have to start paying the next day. This will result in slightly different APRs with the former scenario having a higher APR. We think the APR difference is small enough to NOT take into account the day of the week a loan is funded. Instead, we calculate the APR the following way:

Instead of asking you on which day of the week you are being funded, we assume you are making 7 equal payments per week on each day (vs. paying $X on Mondays to Fridays and $0 on Saturdays and Sundays).

  • New Number of Payments is equal to (Number of Payments)/57
  • New Daily Payment is equal to (Payback Amount)/(New Number of Payments)
  • Daily Rate is equal to the result of the excel formula of =RATE(New Number of Payments, New Daily Payment, -(Loan Amount – Origination Fee))
  • APR is equal to (Daily Rate) 365. We are using daily compounding and assume there’re 365 days in a year.

 

Averaging out 5 weekday payments to 7 days gives a pretty accurate estimate of the loan APR. In most cases, you wouldn’t know which day you are going to get funded when you apply, this estimate gives you a very precise average and helps you compare across different products like a term loan or a merchant cash advance.

A 30% Term Loan vs. A 20% OnDeck Loan

When you get a loan offer from OnDeck, on the term sheet it will tell you the interest rate is 20%. But that’s not the annualized interest rate. It’s 20% of the principal. On the other hand, a bank loan or a loan from LendingClub or FundingCircle, the quoted interest rates are the annualized interest rate, which is the same type of interest rate quote you get from a mortgage loan. It’s quite confusing to compare between the two different types of interest rates. That’s why it’s important to bring everything into the same APR basis so apple-to-apple comparisons can be made.

Let’s compare two $20,000 loans A and B, both with a 2.5% origination fee. Loan A has an annualized interest rate of 30% with 12-month amortization while Loan B has a 20% interest rate based on loan principal with 125 equal weekday payments (25 weeks). Pictures are worth 1000 words. You can see the APR and Total Cost comparison below.

A B
 dailydebit_better ondeck_better

 

As you can see, the 30% term loan has a lower total cost ($3,897), longer payback period (12 months) while the 20% OnDeck/Daily Debit loan has a higher total cost ($4,500), shorter payback period (~6 months). If you are qualified for both, there’s no reason to take the latter option because the 30% term loan is cheaper and has a lower monthly payment.

The above example is the main motivation why we create the Nav calculators. Before you commit to a loan, shop around and compare offers with our calculators. Find the best option and use the saved cash to grow your business.

This article was originally written on January 7, 2015 and updated on November 1, 2016.

Rate This Article

This article currently has 7 ratings with an average of 4.5 stars.

Have at it! We'd love to hear from you and encourage a lively discussion among our users. Please help us keep our site clean and protect yourself. Refrain from posting overtly promotional content, and avoid disclosing personal information such as bank account or phone numbers.

Reviews Disclosure: The responses below are not provided or commissioned by the credit card, financing and service companies that appear on this site. Responses have not been reviewed, approved or otherwise endorsed by the credit card, financing and service companies and it is not their responsibility to ensure all posts and/or questions are answered.

Leave a Reply

Your email address will not be published. Required fields are marked *

2 responses to “The Math Behind Nav’s OnDeck APR Calculator (Daily Debit Loan Calculator)

  1. I am wanting to find out how to calculate the exact APR that is on a contract. So the amount is 100,000. the origination fee is 1250. It is 19% interest. They have the total payback as 118,999.44. There is 252 payments. The funding was on the 3rd of Jan 2017 and the first payment was on the 4th of Jan 2017. The calculated APR is 38.41%. What is the procedure to calculate it so that I get the exact APR also do you know why the payback is not the full 19%? I am trying to get a better understanding of finances.

    1. with 19% interest = 19000 total payback = 119000
      So Installment = 119000/252 = 472.22
      Considering only 98750 is actual loan amount remaining being fee
      APR = 38.41