Rent repayment (loan)
79 USD Formulas in Excel for PAYMENT of a deposit (e.g., 100 PLN) towards the OLDEST due rent installment (loan) and calculating interest on that installment. This is about recording the PAYMENT towards the oldest rent (installment or loan) and calculating interest from the due date of the rent until its full repayment, even if the repayment is in parts. The second and subsequent payments are first compared with the unpaid oldest rents (loan installments) and then recorded against the next due rent (loan installment). Interest cannot be calculated on the OVERDUE BALANCE. Interest is calculated over the period with variable interest rates (from the due date) until the full repayment of each rent installment (loan). The Excel sheet formulas are open for review. The sheet is intended for inputting any data. During the repayment period, e.g., of the first rent (installment), the interest rate could have changed multiple times. Here is my example. Before submitting, please consider whether you HAVE the skills at this level.
Applications 1
-
7 days79 USD
135 7 days79 USDI have the prepared file, you're welcome. The file is in Excel, it always refers to the remaining debt in subsequent months, I think the cost could be three times less than proposed.
Best regards, Marek
-
7 days79 USD
187 7 days79 USDHello, I have carefully reviewed your project requirements and can provide a robust Excel solution for your needs. I will create a dynamic, formula-based model that implements a "waterfall" logic to automatically apply incoming payments to the oldest outstanding debts first (FIFO method), correctly handling partial settlements. The key feature will be an advanced interest calculation that applies variable rates to each individual debt for the exact period it is outstanding—from its due date until the date it is fully paid off. This approach ensures all calculations are transparent, auditable, and precise, without relying on VBA macros, giving you a powerful and flexible tool to manage your receivables and accrued interest accurately. Regarding the price, I can do lower.
-
1 day79 USD
419 13 0 1 day79 USDHello!
I work with Excel and Google Sheets.
Ready to help with formulas or macros (scripts).
Telegram bot and e-mail connection with Google Sheets.
I would be glad to cooperate.
-
2 days79 USD
111 2 days79 USDGood morning!
I have experience in creating advanced Excel spreadsheets for financial settlements, including algorithms for debt repayment with variable interest calculations.
If the order is still current — I would be happy to take care of it!
-
2 days132 USD
1 1 2 days132 USDGood time of day, I will make formulas in Excel for you in a fairly short time
-
4 days79 USD
2621 27 1 4 days79 USDHello! I can do your task! Let's discuss in private
-
16 days79 USD
8773 60 0 1 16 days79 USDHello! We are SolidWay company, and we are ready to help with your project involving Excel formulas for managing loan repayments. Our team has extensive experience in creating complex Excel solutions, ensuring accurate calculations of interest and payment allocations based on your specified requirements.
We understand the importance of perfectly calculating how payments are applied to the oldest dues and the dynamic interest rates involved. We have successfully implemented similar projects that required meticulous attention to detail, so we are confident we can deliver a robust solution tailored to your needs.
To proceed, we’ll define the timeframe and budget after we discuss the task in more detail. We look forward to collaborating with you to develop a solution that meets your expectations!
-
Dzię dobry. mam to gotowe, ale chodzi mi o procenty:
ma być 0,070 %,
czy 7% odsetek?
Koszt myślę, że 50-90 zł.
-
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 2 days 8 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 3 days 1 hour back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 3 days 19 hours back ∙ 90 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 3 days 22 hours back ∙ 18 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 5 days 20 hours back ∙ 6 proposals |
Poland