Like a Coda Table

The power of a Coda Table

Functions 02

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

⁠

Clear Table

⁠

Loans in Coda

Loans in Coda

Archive

€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

my comments here.⁠

⁠

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.