Skip to content
Gallery
CoEx - Interest Rates
Share
Explore

icon picker
Payback varations

Interest Only, Fixed Amounts or Variable Amounts

On this page I integrate learnings from previous pages:

How to Coda an outcome by focusing on the row as main element
Implementing previous developed coded parts
Interests Only
Amount
Interest Percentage
Yearly Pay
Period
Total Interests
Total Due
1
€10,000.00
3%
€300.00
5
€1,500.00
€11,500.00
2
€10,000.00
5%
€500.00
5
€2,500.00
€12,500.00
3
€10,000.00
7%
€700.00
5
€3,500.00
€13,500.00
4
€425,000.00
3.5%
€14,875.00
7
€104,125.00
€529,125.00
There are no rows in this table


Fixed Amount
Amount
Interest Percentage
Period
Total Due
Due per year
Due per month
Total Interests
1
€10,000.00
3%
5
€11,592.74
€2,318.55
€193.21
€1,592.74
2
€10,000.00
5%
5
€12,762.82
€2,552.56
€212.71
€2,762.82
3
€10,000.00
7%
5
€14,025.52
€2,805.10
€233.76
€4,025.52
4
€395,000.00
3.5%
7
€502,550.31
€71,792.90
€5,982.74
€107,550.31
There are no rows in this table

Variable Amount
Evolution Monthly Paiment
Amount
Interest Percentage
Period
Average per year
Total Due
Total Interests
monthly average
1
€191.67 → €171.67 per month during 5 years
€10,000.00
3%
5
€2,180.00
€10,900.00
€900.00
€181.67
2
€208.33 → €175.00 per month during 5 years
€10,000.00
5%
5
€2,300.00
€11,500.00
€1,500.00
€191.67
3
€225.00 → €178.33 per month during 5 years
€10,000.00
7%
5
€2,420.00
€12,100.00
€2,100.00
€201.67
4
€6,299.11 → €5,236.61 per month during 7 years
€425,000.00
3.5%
7
€69,214.29
€484,500.00
€59,500.00
€5,767.86
5
€9,987.50 → €8,797.50 per month during 5 years
€510,000.00
3.5%
5
€112,710.00
€563,550.00
€53,550.00
€9,392.50
6
€12,239.58 → €10,781.25 per month during 5 years
€625,000.00
3.5%
5
€138,125.00
€690,625.00
€65,625.00
€11,510.42
There are no rows in this table

I wrote about how to deal with parts of the above applied Code in the blog post you find below (for free) →



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.