In the first sheet is the French amortization dashboard. You will have 6 columns in which you will be able to compare capital additions and reductions in payment time. All the cells in gray can be changed manually and the rest of the cells are automatic.
The second sheet shows the detail of the amortization tables according to the changes made in sheet 1.
The third sheet allows you to compare subscriptions and changes in the payment period in UVR. The same logic holds where you can manually change the gray cells and the rest of the cells change automatically.
The fourth sheet shows the detail of the amortization tables according to the changes made in sheet 3 in UVR. It should be noted that in this sheet you must change the date and the expected UVR in order to have the exact result you expect.
top of page
bottom of page