Skip to content
Accumulated Amount → no pay backAccumulated Interests → all the interests to pay in case of no pay backAverage per Year → amount you pay back per year on average during the period you definedTotal Interests → the interest accumulated over the period and the loan while paying backAverage per month → amount you pay back per monthDelta Interests → delta between interest when paying back and not paying back the loan
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.
Add Loan
Loans in Coda
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
There are no rows in this table
The archived data you find here:
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.