Calculate Merchant Cash Advance Loan in Excel

In this Microsoft Excel tutorial, I'm going to teach you how to calculate the completion date of a Merchant Cash Advance (MCA) loan.

Zane from Denver, Colorado (a Platinum Member) asks: I recently took out a merchant cash advance loan where the lender takes 30% of my daily sales until the loan is paid off. Can you show me how to calculate what the end payment date would be?

Prerequisites

• Free Excel Beginner 1: https://599cd.com/LB1L

Links

• ISO Date Format: https://599cd.com/ISODatesX
• Conditional Formatting: https://599cd.com/ExcelCF
• MCA Loans in Access: https://599cd.com/MCALoans

Members

There is no extended cut, but here's my workbook file:

•  Workbook Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Recommended Courses

• Excel Beginner, Expert Courses: https://599cd.com/Excel
• PMT Function in Excel Expert Level 6: https://599cd.com/LX6

Want More Excel?

Most of what I do is Microsoft Access, so if if you want to see me post more Excel videos, make sure to comment below: "I want more Excel!"

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

excel 2021, excel 2016, excel 2019, excel 365, microsoft excel, ms excel, ms excel tutorial, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #techhelp, excel mca loan calculator, Merchant Cash Advance (MCA) Calculator