Excel Spreadsheet - Interest calculator over time
Budget: €30 – €250 EUR
Instructions:
Goal of functionality: Company A knows how much debt and interest that should be paid to Company B at specific times in history and in future. Company A knows how much the actual debt is.
The function of the Excel spreadsheet should be:
Company A borrows money from Company B .
Transfers are made on irregular dates.
Not at reoccuring specific times.
Company A wants to know how much to pay to Company B at the end of every - Month
- Quarter
- Year
- At a specific date (date should be entered manually by the User in a field).
Feel free to make a creative and smart function of this solution.
I started to make a simple explanation in Excel just to clarify some details in formatting.Feel free to make your own design of the table. It is just a guide and instruction sheet for informational purposes.
Feel free to question the solution if you have any better idea how to make the function. :)
Format of the file should be in *.xlsx
Goal of functionality: Company A knows how much debt and interest that should be paid to Company B at specific times in history and in future. Company A knows how much the actual debt is.
The function of the Excel spreadsheet should be:
Company A borrows money from Company B .
Transfers are made on irregular dates.
Not at reoccuring specific times.
Company A wants to know how much to pay to Company B at the end of every - Month
- Quarter
- Year
- At a specific date (date should be entered manually by the User in a field).
Feel free to make a creative and smart function of this solution.
I started to make a simple explanation in Excel just to clarify some details in formatting.Feel free to make your own design of the table. It is just a guide and instruction sheet for informational purposes.
Feel free to question the solution if you have any better idea how to make the function. :)
Format of the file should be in *.xlsx