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
The archived data you find here: