JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
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
Like a Coda Table
Archived Loans in Coda
To keep an eye on calculations you might need one day
Christiaan Huizer
In the column feedback you can take notes (about the client, the project).
Archived Loans in Coda
Archived Loans in Coda
Evolution over time (monthly)
feedback
years
rate
loan
accumulatedAmount
accumulatedInterests
averagePerYear
Total Interests
Average per month
Delta Interests
Evolution over time (monthly)
feedback
years
rate
loan
accumulatedAmount
accumulatedInterests
averagePerYear
Total Interests
Average per month
Delta Interests
1
€1,565.28
→
€1,374.72
per month in
15
years with
1%
over
€245,000.00
Open
15
1%
€245,000.00
€284,437.39
€39,437.39
€17,640.00
€19,600.00
€1,470.00
-€19,837.39
2
€1,769.44
→
€1,388.33
per month in
15
years with
2%
over
€245,000.00
Open
15
2%
€245,000.00
€329,737.74
€84,737.74
€18,946.67
€39,200.00
€1,578.89
-€45,537.74
3
€1,973.61
→
€1,401.94
per month in
15
years with
3%
over
€245,000.00
Open
15
3%
€245,000.00
€381,702.02
€136,702.02
€20,253.33
€58,800.00
€1,687.78
-€77,902.02
4
€2,177.78
→
€1,415.56
per month in
15
years with
4%
over
€245,000.00
Open
15
4%
€245,000.00
€441,231.16
€196,231.16
€21,560.00
€78,400.00
€1,796.67
-€117,831.16
5
€2,381.94
→
€1,429.17
per month in
15
years with
5%
over
€245,000.00
Open
15
5%
€245,000.00
€509,337.40
€264,337.40
€22,866.67
€98,000.00
€1,905.56
-€166,337.40
6
€2,586.11
→
€1,442.78
per month in
15
years with
6%
over
€245,000.00
Open
15
6%
€245,000.00
€587,156.76
€342,156.76
€24,173.33
€117,600.00
€2,014.44
-€224,556.76
7
€2,790.28
→
€1,456.39
per month in
15
years with
7%
over
€245,000.00
Open
15
7%
€245,000.00
€675,962.73
€430,962.73
€25,480.00
€137,200.00
€2,123.33
-€293,762.73
8
€2,994.44
→
€1,470.00
per month in
15
years with
8%
over
€245,000.00
Open
15
8%
€245,000.00
€777,181.43
€532,181.43
€26,786.67
€156,800.00
€2,232.22
-€375,381.43
9
€3,198.61
→
€1,483.61
per month in
15
years with
9%
over
€245,000.00
Open
15
9%
€245,000.00
€892,408.20
€647,408.20
€28,093.33
€176,400.00
€2,341.11
-€471,008.20
There are no rows in this table
Archived Loans in Coda
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.