Skip to content
Gallery
Coda template previous rows and interest rates
Preceding values
previous row alternative
Rolling Total
Moving Average
Nett Present Value (NPV)
Interest rates
More
Share
Explore
Interest rates

icon picker
Like a Coda Table

The power of a Coda Table
Archived Loans in Coda
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
Federico.
⁠
⁠
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.
Source
⁠
⁠
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

Add Loan
⁠
⁠
⁠
Clear Table
⁠
⁠
Loans in Coda
Archive
Evolution over time (monthly) with pay back
Years
Rate
Loan
Accumulated Amount
Accumulated Interests
Average per Year
Average per month
Total Interests
Delta Interests
1
Archive
€3,217.50 → €2,549.25 per month in 10 years with 3% over €297,000.00
10
3%
€297,000.00
€399,143.16
€102,143.16
€34,600.50
€2,883.38
€49,005.00
-€53,138.16
2
Archive
€550.00 → €510.00 per month in 5 years with 2% over €30,000.00
5
2%
€30,000.00
€33,122.42
€3,122.42
€6,360.00
€530.00
€1,800.00
-€1,322.42
3
Archive
€383.33 → €350.00 per month in 3 years with 5% over €12,000.00
3
5%
€12,000.00
€13,891.50
€1,891.50
€4,400.00
€366.67
€1,200.00
-€691.50
There are no rows in this table
⁠

⁠
The archived data you find here:
⁠
Archived Loans in Coda
To keep an eye on calculations you might need one day
⁠
⁠

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.