Skip to content
Most people are used to a spreadsheet approach when it comes to interest related calculations. Such an approach has a line (row) for each year and or month. To fill out the table we use controllers and a button. contains a simpler approach with a few variables and results in the same row.
The spreadsheet alike approach
10000
4
10
Clear Table
Loan without Payback
Year
Loan
Rate
Multiplier
Due without pay-back
1
€10,000.00
4%
1.04
€10,400.00
2
€10,000.00
4%
1.08
€10,816.00
3
€10,000.00
4%
1.12
€11,248.64
4
€10,000.00
4%
1.17
€11,698.59
5
€10,000.00
4%
1.22
€12,166.53
6
€10,000.00
4%
1.27
€12,653.19
7
€10,000.00
4%
1.32
€13,159.32
8
€10,000.00
4%
1.37
€13,685.69
9
€10,000.00
4%
1.42
€14,233.12
10
€10,000.00
4%
1.48
€14,802.44
There are no rows in this table
The multiplier is not needed as separate column, but the number show (certainly when you test with a round number for amount like 1000 Euro) is a number that you see back in the last column.
The part below shows a bit how a spreadsheet approach in Coda makes it unnecessary difficult (in my opinion).
Loan with Payback
There are no rows in this table
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.