The Math Behind Nav’s Business Loan Calculator

The Math Behind Nav’s Business Loan Calculator

0 Comment

This is the second post about Nav’s loan calculators. Previously, we talked about the math behind our merchant cash advance APR calculator where the APR can only be approximated before the actual payments since the contract is card revenue-based. In this post, we will be talking about the math behind the business term loan calculator where the APR is deterministic and pretty much works like a mortgage.

Powered by nav


The APR for a business term loan is very straight forward to figure out. In fact, if there’s no origination, application and monthly servicing charges, the APR will be the SAME as the interest rate the lender quoted. APR, by definition, is the effective interest rate a lender charges. If a lender doesn’t charge any extra fees, then the effective interest rate (APR) will be the same as the quoted interest rate. But most business lenders charge an origination fee, making the APR higher than the quoted interest rate.

We use monthly compounding for our term loan calculator as most business term loans asked for monthly payments. Here are exactly how Nav’s term loan calculator calculate APR:

  1. Calculate monthly payment using the Excel formula: Monthly Payment =PMT((Interest Rate/12), Loan Term, Loan Amount)
  2. It’s not super common, but some lenders will charge an extra servicing fee in addition to the monthly payment calculated from one. Therefore, your Actual Monthly Payment is equal to (Monthly Payment + Monthly Servicing Charge).
  3. Your actual proceeds will be different from the loan amount if there’s origination & application fee. Your Actual Proceeds is equal to (Loan Amount) – (Origination + Application Fees).
  4. Now. We can calculate the Monthly Rate using the Excel formula: Monthly Rate = RATE(Loan Term, Actual Monthly Payment, -(Actual Proceeds))
  5. APR = (Monthly Rate) * 12
Financing - Signup Free - MatchFactor

Instantly see your top options for business loans and credit cards based your business's needs using Nav's MatchFactor technology. See my match scores for free.

Merchant Cash Advance vs. Credit Card Cash Advance

 

The following are the parameters from an MCA term sheet:

  • $85,000 paid to the merchant
  • $112,625 of the future card receivables will be paid to the purchaser (the MCA provider)
  • 12% of the debit/credit card payments will be paid through ACH to the purchaser (until $112,625 is fully paid)
  • $250 administrative cost paid by the merchant.
  • $150,000 monthly card sales

Because of the $250 administrative cost, the actual amount deposited to his bank account is ($85,000 – $250) = $84,750. The cost of the advance is therefore ($112,625 – $84,750) = $27,875 or 32.89% of the advance amount.

mca_screenshot
Bottom line: APR = 115.84% , Total Cost = 32.89% of the advanced amount , Paid back in about 6 months.

Now, if instead we get a credit card cash advance of $100,000 with 3% origination fee ($3,000) and 21.24% interest rate, 0% monthly servicing charge as described by the term sheet here and we will also pay back in 6 months. As shown below, the total cost is $9285.56 or ($9285.56/($100,000-$3000)) = 9.57% of the advance amount.

  cashadvance_screenshot

Bottom line: APR = 32.11% , Total Cost = 9.57% of the advanced amount , Paid back in about 6 months.

Although the two advances have different compounding methods when calculating APR, you can obviously see the credit card cash advance is a much better deal as you are paying 1/3 of the financing cost with the similar repayment period. If you have a choice between the two, there’s no reason to pick the more expensive option. These two products have almost no common parameters (except for the advanced amount) but using Nav’s loan calculators, you can compare them on an Apple-to-Apple basis— and that was exactly the motivation for creating these calculators.

We will be talking about the math behind Daily ACH Debit Calculator (aka OnDeck APR Calculator) next week and we will introduce more examples. Stay tuned.

Resources Page

Can't get enough? We've got tons of business tools and resources right here.

Rate This Article

This article currently has 1 rating with an average of 5 stars.

About the Author — Yun-Fang is a small business advisor who has lived in the SF bay area for 15 years. She is a software engineer and has worked at Yahoo!, Facebook and Soldsie prior to becoming an advisor for Nav. She is passionate about using technology to connect people and to make the world a level playing field.

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 *