Skip to content
CoEx - Interest Rates
Share
Explore
Easy interest calculations

Like a Coda Table

The power of a Coda Table
I a Coda table we work differently compared to a spreadsheet, the year as number in a column, the interest as a number in a column, the amount in a column and the outcome in a column. Since we execute the calculation per row, we simple add a new row to see the results coming on that same row. This logic alignes well with the remarks of
Also, Coda - as well as other relational oriented data tools - favorites a row-based approach rather that a column-oriented. Meaning that it is usually easier add a row than a column and if you follow this principle
Average per month you’ll take full advantage of the tool.
Simply add a row, fill out the blue columns and you see the results coming.
Accumulated Amount → no pay back
Accumulated Interests → all the interests to pay in case of no pay back
Average per Year → amount you pay back per year on average during the period you defined
Total Interests → the interest accumulated over the period and the loan while paying back
Average per month → amount you pay back per month
Delta Interests → delta between interest when paying back and not paying back the loan

Clear Table
Loans in Coda
0
Search
Archive
Years
Rate
Loan
Evolution over time (monthly) with pay back
Accumulated Amount
Accumulated Interests
Average per Year
Total Interests
Average per month
Delta Interests
1
Archive
10
3%
€297,000.00
€3,217.50 → €2,549.25 per month in 10 years with 3% over €297,000.00
€399,143.16
€102,143.16
€34,600.50
€49,005.00
€2,883.38
-€53,138.16
2
Archive
5
2%
€30,000.00
€550.00 → €510.00 per month in 5 years with 2% over €30,000.00
€33,122.42
€3,122.42
€6,360.00
€1,800.00
€530.00
-€1,322.42
There are no rows in this table
To understand this logic better, check-out
The archived data you find here:

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.