Premium Lending Business

Key Features:

✅ Automatic Loan Amortization Schedule Generation: This tool streamlines the process of generating a loan amortization schedule for each client, based on their loan details.

✅ Individual Loan Books: Each client is assigned their own loan book, making it convenient to track their monthly, daily, weekly or bi-weekly payment obligations and maintain a record of all transactions. There’s a total of 100 loan books.

✅ Client Dashboard: The spreadsheet includes a dedicated dasboard listing all your clients. Here, you can easily assess your portfolio, including the total amount paid/unpaid, total loan amount, net income and rate of return.

✅ Effortless Navigation: Navigating to each client’s loan book is a breeze with a simple click on the Client Dashboard. Every loan book also has a button to quickly jump back to your dashboard.

✅ Google Sheets Compatibility: This tool is designed to work seamlessly with Google Sheets, ensuring easy access and usability for both desktop and mobile users. Please note this spreadsheet is not compatible with MS Excel.

IMPORTANT NOTE: This lending spreadsheet was designed to calculate loan amortizations using fixed  interest every month only. The spreadsheet is unable to calculate other interest rates.