MODELLO DI SIMULAZIONE LEASING
Durata                    4.00 anni
Pagamento          mensile     mensile, trimestrale, semestrale
Tasso                    4.50% annuo
Capitalizzazione   semplice    semplice, composta
Spese incasso             5.00 euro
Spese pratica           300.00 euro
Finanziato           21,385.67               Costo totale         23,034.04
Maxicanone                 30% in %                                   7.71%
Valore riscatto            10% in %
   Scadenze         Rata         Q.Capitale   Deb.Residuo     Q.Interessi     Comm.    Spese
       0             6,415.70                    14,969.97                      5.00    300.00
       1               300.62        244.48      14,725.49            56.14     5.00
       2               300.62        245.40      14,480.09            55.22     5.00
       3               300.62        246.32      14,233.77            54.30     5.00
       4               300.62        247.24      13,986.52            53.38     5.00
       5               300.62        248.17      13,738.35            52.45     5.00
       6               300.62        249.10      13,489.25            51.52     5.00
       7               300.62        250.04      13,239.21            50.58     5.00
       8               300.62        250.97      12,988.24            49.65     5.00
       9               300.62        251.91      12,736.33            48.71     5.00
      10               300.62        252.86      12,483.47            47.76     5.00
      11               300.62        253.81      12,229.66            46.81     5.00
      12               300.62        254.76      11,974.90            45.86     5.00
      13               300.62        255.71      11,719.19            44.91     5.00
      14               300.62        256.67      11,462.51            43.95     5.00
      15               300.62        257.64      11,204.88            42.98     5.00
      16               300.62        258.60      10,946.28            42.02     5.00
      17               300.62        259.57      10,686.70            41.05     5.00
      18               300.62        260.55      10,426.16            40.08     5.00
      19               300.62        261.52      10,164.64            39.10     5.00
      20               300.62        262.50       9,902.13            38.12     5.00
      21               300.62        263.49       9,638.65            37.13     5.00
      22               300.62        264.48       9,374.17            36.14     5.00
      23               300.62        265.47       9,108.70            35.15     5.00
      24               300.62        266.46       8,842.24            34.16     5.00
      25               300.62        267.46       8,574.78            33.16     5.00
      26               300.62        268.46       8,306.31            32.16     5.00
      27               300.62        269.47       8,036.84            31.15     5.00
      28               300.62        270.48       7,766.36            30.14     5.00
      29               300.62        271.50       7,494.86            29.12     5.00
      30               300.62        272.51       7,222.35            28.11     5.00
      31               300.62        273.54       6,948.81            27.08     5.00
      32               300.62        274.56       6,674.25            26.06     5.00
      33               300.62        275.59       6,398.66            25.03     5.00
      34               300.62        276.63       6,122.03            23.99     5.00
      35               300.62        277.66       5,844.37            22.96     5.00
36     300.62     278.70   5,565.67   21.92   5.00
37     300.62     279.75   5,285.92   20.87   5.00
38     300.62     280.80   5,005.12   19.82   5.00
39     300.62     281.85   4,723.27   18.77   5.00
40     300.62     282.91   4,440.36   17.71   5.00
41     300.62     283.97   4,156.39   16.65   5.00
42     300.62     285.03   3,871.36   15.59   5.00
43     300.62     286.10   3,585.25   14.52   5.00
44     300.62     287.18   3,298.08   13.44   5.00
45     300.62     288.25   3,009.83   12.37   5.00
46     300.62     289.33   2,720.49   11.29   5.00
47     300.62     290.42   2,430.07   10.20   5.00
48   2,430.07   2,420.96       9.11    9.11   5.00
49       9.11       9.08         -     0.03   5.00
50         -          -          -     0.00     -
51         -          -          -     0.00     -
52         -          -          -     0.00     -
53         -          -          -     0.00     -
54         -          -          -     0.00     -
55         -          -          -     0.00     -
56         -          -          -     0.00     -
57         -          -          -     0.00     -
58         -          -          -     0.00     -
59         -          -          -     0.00     -
60         -          -          -     0.00     -
61         -          -          -     0.00     -
62         -          -          -     0.00     -
63         -          -          -     0.00     -
64         -          -          -     0.00     -
65         -          -          -     0.00     -
66         -          -          -     0.00     -
67         -          -          -     0.00     -
68         -          -          -     0.00     -
69         -          -          -     0.00     -
70         -          -          -     0.00     -
71         -          -          -     0.00     -
72         -          -          -     0.00     -
73         -          -          -     0.00     -
74         -          -          -     0.00     -
75         -          -          -     0.00     -
76         -          -          -     0.00     -
77         -          -          -     0.00     -
78         -          -          -     0.00     -
79         -          -          -     0.00     -
80         -          -          -     0.00     -
81         -          -          -     0.00     -
82         -          -          -     0.00     -
83         -          -          -     0.00     -
84         -          -          -     0.00     -
85         -          -          -     0.00     -
 86   -   -   -   0.00   -
 87   -   -   -   0.00   -
 88   -   -   -   0.00   -
 89   -   -   -   0.00   -
 90   -   -   -   0.00   -
 91   -   -   -   0.00   -
 92   -   -   -   0.00   -
 93   -   -   -   0.00   -
 94   -   -   -   0.00   -
 95   -   -   -   0.00   -
 96   -   -   -   0.00   -
 97   -   -   -   0.00   -
 98   -   -   -   0.00   -
 99   -   -   -   0.00   -
100   -   -   -   0.00   -
101   -   -   -   0.00   -
102   -   -   -   0.00   -
103   -   -   -   0.00   -
104   -   -   -   0.00   -
105   -   -   -   0.00   -
106   -   -   -   0.00   -
107   -   -   -   0.00   -
108   -   -   -   0.00   -
109   -   -   -   0.00   -
110   -   -   -   0.00   -
111   -   -   -   0.00   -
112   -   -   -   0.00   -
113   -   -   -   0.00   -
114   -   -   -   0.00   -
115   -   -   -   0.00   -
116   -   -   -   0.00   -
117   -   -   -   0.00   -
118   -   -   -   0.00   -
119   -   -   -   0.00   -
120   -   -   -   0.00   -
121   -   -   -   0.00   -
122   -   -   -   0.00   -
123   -   -   -   0.00   -
124   -   -   -   0.00   -
125   -   -   -   0.00   -
126   -   -   -   0.00   -
127   -   -   -   0.00   -
128   -   -   -   0.00   -
129   -   -   -   0.00   -
130   -   -   -   0.00   -
131   -   -   -   0.00   -
132   -   -   -   0.00   -
133   -   -   -   0.00   -
134   -   -   -   0.00   -
135   -   -   -   0.00   -
136   -   -   -   0.00   -
137   -   -   -   0.00   -
138   -   -   -   0.00   -
139   -   -   -   0.00   -
140   -   -   -   0.00   -
141   -   -   -   0.00   -
142   -   -   -   0.00   -
143   -   -   -   0.00   -
144   -   -   -   0.00   -
145   -   -   -   0.00   -
146   -   -   -   0.00   -
147   -   -   -   0.00   -
148   -   -   -   0.00   -
149   -   -   -   0.00   -
150   -   -   -   0.00   -
151   -   -   -   0.00   -
152   -   -   -   0.00   -
153   -   -   -   0.00   -
154   -   -   -   0.00   -
155   -   -   -   0.00   -
156   -   -   -   0.00   -
157   -   -   -   0.00   -
158   -   -   -   0.00   -
159   -   -   -   0.00   -
160   -   -   -   0.00   -
161   -   -   -   0.00   -
162   -   -   -   0.00   -
163   -   -   -   0.00   -
164   -   -   -   0.00   -
165   -   -   -   0.00   -
166   -   -   -   0.00   -
167   -   -   -   0.00   -
168   -   -   -   0.00   -
169   -   -   -   0.00   -
170   -   -   -   0.00   -
171   -   -   -   0.00   -
172   -   -   -   0.00   -
173   -   -   -   0.00   -
174   -   -   -   0.00   -
175   -   -   -   0.00   -
176   -   -   -   0.00   -
177   -   -   -   0.00   -
178   -   -   -   0.00   -
179   -   -   -   0.00   -
180   -   -   -   0.00   -
181   -   -   -   0.00   -
182   -   -   -   0.00   -
183   -   -   -   0.00   -
184   -   -   -   0.00   -
185   -   -   -   0.00   -
186   -   -   -   0.00   -
187   -   -   -   0.00   -
188   -   -   -   0.00   -
189   -   -   -   0.00   -
190   -   -   -   0.00   -
191   -   -   -   0.00   -
192   -   -   -   0.00   -
193   -   -   -   0.00   -
194   -   -   -   0.00   -
195   -   -   -   0.00   -
196   -   -   -   0.00   -
197   -   -   -   0.00   -
198   -   -   -   0.00   -
199   -   -   -   0.00   -
200   -   -   -   0.00   -
201   -   -   -   0.00   -
202   -   -   -   0.00   -
203   -   -   -   0.00   -
204   -   -   -   0.00   -
205   -   -   -   0.00   -
206   -   -   -   0.00   -
207   -   -   -   0.00   -
208   -   -   -   0.00   -
209   -   -   -   0.00   -
210   -   -   -   0.00   -
211   -   -   -   0.00   -
212   -   -   -   0.00   -
213   -   -   -   0.00   -
214   -   -   -   0.00   -
215   -   -   -   0.00   -
216   -   -   -   0.00   -
217   -   -   -   0.00   -
218   -   -   -   0.00   -
219   -   -   -   0.00   -
220   -   -   -   0.00   -
221   -   -   -   0.00   -
222   -   -   -   0.00   -
223   -   -   -   0.00   -
224   -   -   -   0.00   -
225   -   -   -   0.00   -
226   -   -   -   0.00   -
227   -   -   -   0.00   -
228   -   -   -   0.00   -
229   -   -   -   0.00   -
230   -   -   -   0.00   -
231   -   -   -   0.00   -
232   -   -   -   0.00   -
233   -   -   -   0.00   -
234   -   -   -   0.00   -
235   -   -   -   0.00   -
236   -   -   -   0.00   -
237   -   -   -   0.00   -
238   -   -   -   0.00   -
239   -   -   -   0.00   -
240   -   -   -   0.00   -
                            Moltiplicatore                    12
                            Numero pagamenti              48.00
                            Tasso di periodo             0.375%
                            Valore attuale riscatto    1,786.88
                            Importo finanziato        13,183.09
                            Monte rate                22,984.04    7.47%
Rata con iva
     8,058.84   27,640.85
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
       360.74
  360.74
  360.74
  360.74
  360.74
  360.74
  360.74
  360.74
  360.74
  360.74
  360.74
  360.74
  360.74
2,916.09
   10.94
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
      -
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Valore bene                     130,000.00
Comprensivo di iva?                no
Durata                               15.00
Pagamento                        mensile
Tasso                               6.000% annuo
Capitalizzazione                composta
Spese incasso                          5.00
Spese registrazioni/contabili            -
Spese pratica                       350.00
Maxicanone                             10%
Valore riscatto                        30%
Polizza assicurativa                500.00 stima per tutta durata leasing
Manutenzione programmata                 - stima per tutta durata leasing
Quota esente                             - stima studiare dove metterla
          Scadenze              Q.Capitale   Q.Interessi Deb.Residuo         Rata     Rata altre
              0                                           117,000.00        13,000.00
              1                  271.16        585.00     116,728.84        856.16         2.81
              2                  272.52        583.64     116,456.32        856.16         2.81
              3                  273.88        582.28     116,182.45        856.16         2.81
              4                  275.25        580.91     115,907.20        856.16         2.81
              5                  276.62        579.54     115,630.57        856.16         2.81
              6                  278.01        578.15     115,352.57        856.16         2.81
              7                  279.40        576.76     115,073.17        856.16         2.81
              8                  280.79        575.37     114,792.38        856.16         2.81
              9                  282.20        573.96     114,510.18        856.16         2.81
             10                  283.61        572.55     114,226.57        856.16         2.81
             11                  285.03        571.13     113,941.54        856.16         2.81
             12                  286.45        569.71     113,655.09        856.16         2.81
             13                  287.88        568.28     113,367.20        856.16         2.81
             14                  289.32        566.84     113,077.88        856.16         2.81
             15                  290.77        565.39     112,787.11        856.16         2.81
             16                  292.22        563.94     112,494.89        856.16         2.81
             17                  293.69        562.47     112,201.20        856.16         2.81
             18                  295.15        561.01     111,906.05        856.16         2.81
             19                  296.63        559.53     111,609.42        856.16         2.81
             20                  298.11        558.05     111,311.30        856.16         2.81
             21                  299.60        556.56     111,011.70        856.16         2.81
             22                  301.10        555.06     110,710.60        856.16         2.81
             23                  302.61        553.55     110,407.99        856.16         2.81
             24                  304.12        552.04     110,103.87        856.16         2.81
             25                  305.64        550.52     109,798.23        856.16         2.81
             26                  307.17        548.99     109,491.06        856.16         2.81
             27                  308.70        547.46     109,182.36        856.16         2.81
             28                  310.25        545.91     108,872.11        856.16         2.81
             29                  311.80        544.36     108,560.31        856.16         2.81
             30                  313.36        542.80     108,246.95        856.16         2.81
             31                  314.93        541.23     107,932.03        856.16         2.81
             32                  316.50        539.66     107,615.53        856.16         2.81
             33                  318.08        538.08     107,297.44        856.16         2.81
             34                  319.67        536.49     106,977.77        856.16         2.81
             35                  321.27        534.89     106,656.50        856.16         2.81
36   322.88   533.28   106,333.62   856.16    2.81
37   324.49   531.67   106,009.13   856.16    2.81
38   326.11   530.05   105,683.02   856.16    2.81
39   327.74   528.42   105,355.27   856.16    2.81
40   329.38   526.78   105,025.89   856.16    2.81
41   331.03   525.13   104,694.86   856.16    2.81
42   332.69   523.47   104,362.17   856.16    2.81
43   334.35   521.81   104,027.82   856.16    2.81
44   336.02   520.14   103,691.80   856.16    2.81
45   337.70   518.46   103,354.10   856.16    2.81
46   339.39   516.77   103,014.71   856.16    2.81
47   341.09   515.07   102,673.62   856.16    2.81
48   342.79   513.37   102,330.83   856.16    2.81
49   344.51   511.65   101,986.33   856.16    2.81
50   346.23   509.93   101,640.10   856.16    2.81
51   347.96   508.20   101,292.14   856.16    2.81
52   349.70   506.46   100,942.44   856.16    2.81
53   351.45   504.71   100,590.99   856.16    2.81
54   353.21   502.95   100,237.79   856.16    2.81
55   354.97   501.19    99,882.81   856.16    2.81
56   356.75   499.41    99,526.07   856.16    2.81
57   358.53   497.63    99,167.54   856.16    2.81
58   360.32   495.84    98,807.22   856.16    2.81
59   362.12   494.04    98,445.09   856.16    2.81
60   363.93   492.23    98,081.16   856.16    2.81
61   365.75   490.41    97,715.40   856.16    2.81
62   367.58   488.58    97,347.82   856.16    2.81
63   369.42   486.74    96,978.40   856.16    2.81
64   371.27   484.89    96,607.13   856.16    2.81
65   373.12   483.04    96,234.01   856.16    2.81
66   374.99   481.17    95,859.02   856.16    2.81
67   376.86   479.30    95,482.15   856.16    2.81
68   378.75   477.41    95,103.40   856.16    2.81
69   380.64   475.52    94,722.76   856.16    2.81
70   382.55   473.61    94,340.21   856.16    2.81
71   384.46   471.70    93,955.76   856.16    2.81
72   386.38   469.78    93,569.37   856.16    2.81
73   388.31   467.85    93,181.06   856.16    2.81
74   390.25   465.91    92,790.81   856.16    2.81
75   392.21   463.95    92,398.60   856.16    2.81
76   394.17   461.99    92,004.43   856.16    2.81
77   396.14   460.02    91,608.30   856.16    2.81
78   398.12   458.04    91,210.18   856.16    2.81
79   400.11   456.05    90,810.07   856.16    2.81
80   402.11   454.05    90,407.96   856.16    2.81
81   404.12   452.04    90,003.84   856.16    2.81
82   406.14   450.02    89,597.70   856.16    2.81
83   408.17   447.99    89,189.53   856.16    2.81
84   410.21   445.95    88,779.31   856.16    2.81
85   412.26   443.90    88,367.05   856.16    2.81
86   414.32   441.84    87,952.73   856.16    2.81
87   416.40   439.76    87,536.33   856.16    2.81
88   418.48   437.68    87,117.85   856.16    2.81
89   420.57   435.59    86,697.28   856.16    2.81
90   422.67   433.49    86,274.61   856.16    2.81
91   424.79   431.37    85,849.82   856.16    2.81
92   426.91   429.25    85,422.91   856.16    2.81
 93   429.05   427.11   84,993.86   856.16    2.81
 94   431.19   424.97   84,562.67   856.16    2.81
 95   433.35   422.81   84,129.33   856.16    2.81
 96   435.51   420.65   83,693.81   856.16    2.81
 97   437.69   418.47   83,256.12   856.16    2.81
 98   439.88   416.28   82,816.24   856.16    2.81
 99   442.08   414.08   82,374.16   856.16    2.81
100   444.29   411.87   81,929.87   856.16    2.81
101   446.51   409.65   81,483.36   856.16    2.81
102   448.74   407.42   81,034.62   856.16    2.81
103   450.99   405.17   80,583.63   856.16    2.81
104   453.24   402.92   80,130.39   856.16    2.81
105   455.51   400.65   79,674.88   856.16    2.81
106   457.79   398.37   79,217.10   856.16    2.81
107   460.07   396.09   78,757.02   856.16    2.81
108   462.37   393.79   78,294.65   856.16    2.81
109   464.69   391.47   77,829.96   856.16    2.81
110   467.01   389.15   77,362.95   856.16    2.81
111   469.35   386.81   76,893.61   856.16    2.81
112   471.69   384.47   76,421.91   856.16    2.81
113   474.05   382.11   75,947.86   856.16    2.81
114   476.42   379.74   75,471.44   856.16    2.81
115   478.80   377.36   74,992.64   856.16    2.81
116   481.20   374.96   74,511.44   856.16    2.81
117   483.60   372.56   74,027.84   856.16    2.81
118   486.02   370.14   73,541.82   856.16    2.81
119   488.45   367.71   73,053.37   856.16    2.81
120   490.89   365.27   72,562.48   856.16    2.81
121   493.35   362.81   72,069.13   856.16    2.81
122   495.81   360.35   71,573.31   856.16    2.81
123   498.29   357.87   71,075.02   856.16    2.81
124   500.78   355.38   70,574.24   856.16    2.81
125   503.29   352.87   70,070.95   856.16    2.81
126   505.81   350.35   69,565.14   856.16    2.81
127   508.33   347.83   69,056.81   856.16    2.81
128   510.88   345.28   68,545.93   856.16    2.81
129   513.43   342.73   68,032.50   856.16    2.81
130   516.00   340.16   67,516.50   856.16    2.81
131   518.58   337.58   66,997.93   856.16    2.81
132   521.17   334.99   66,476.76   856.16    2.81
133   523.78   332.38   65,952.98   856.16    2.81
134   526.40   329.76   65,426.58   856.16    2.81
135   529.03   327.13   64,897.56   856.16    2.81
136   531.67   324.49   64,365.89   856.16    2.81
137   534.33   321.83   63,831.55   856.16    2.81
138   537.00   319.16   63,294.55   856.16    2.81
139   539.69   316.47   62,754.87   856.16    2.81
140   542.39   313.77   62,212.48   856.16    2.81
141   545.10   311.06   61,667.38   856.16    2.81
142   547.82   308.34   61,119.56   856.16    2.81
143   550.56   305.60   60,569.00   856.16    2.81
144   553.32   302.84   60,015.68   856.16    2.81
145   556.08   300.08   59,459.60   856.16    2.81
146   558.86   297.30   58,900.74   856.16    2.81
147   561.66   294.50   58,339.08   856.16    2.81
148   564.46   291.70   57,774.62   856.16    2.81
149   567.29   288.87   57,207.33   856.16    2.81
150    570.12     286.04     56,637.21    856.16      2.81
151    572.97     283.19     56,064.23    856.16      2.81
152    575.84     280.32     55,488.39    856.16      2.81
153    578.72     277.44     54,909.68    856.16      2.81
154    581.61     274.55     54,328.06    856.16      2.81
155    584.52     271.64     53,743.54    856.16      2.81
156    587.44     268.72     53,156.10    856.16      2.81
157    590.38     265.78     52,565.72    856.16      2.81
158    593.33     262.83     51,972.39    856.16      2.81
159    596.30     259.86     51,376.09    856.16      2.81
160    599.28     256.88     50,776.81    856.16      2.81
161    602.28     253.88     50,174.54    856.16      2.81
162    605.29     250.87     49,569.25    856.16      2.81
163    608.31     247.85     48,960.94    856.16      2.81
164    611.36     244.80     48,349.58    856.16      2.81
165    614.41     241.75     47,735.17    856.16      2.81
166    617.48     238.68     47,117.69    856.16      2.81
167    620.57     235.59     46,497.11    856.16      2.81
168    623.67     232.49     45,873.44    856.16      2.81
169    626.79     229.37     45,246.65    856.16      2.81
170    629.93     226.23     44,616.72    856.16      2.81
171    633.08     223.08     43,983.64    856.16      2.81
172    636.24     219.92     43,347.40    856.16      2.81
173    639.42     216.74     42,707.98    856.16      2.81
174    642.62     213.54     42,065.36    856.16      2.81
175    645.83     210.33     41,419.53    856.16      2.81
176    649.06     207.10     40,770.46    856.16      2.81
177    652.31     203.85     40,118.16    856.16      2.81
178    655.57     200.59     39,462.59    856.16      2.81
179    658.85     197.31     38,803.74    856.16      2.81
180   38,805.98   194.02   -      2.24   39,000.00    2.81
181                -0.01            -
182                 0.00            -
183                 0.00            -
184                 0.00            -
185                 0.00            -
186                 0.00            -
187                 0.00            -
188                 0.00            -
189                 0.00            -
190                 0.00            -
191                 0.00            -
192                 0.00            -
193                 0.00            -
194                 0.00            -
195                 0.00            -
196                 0.00            -
197                 0.00            -
198                 0.00            -
199                 0.00            -
200                 0.00            -
201                 0.00            -
202                 0.00            -
203                 0.00            -
204                 0.00            -
205                 0.00            -
206                 0.00            -
207                0.00              -
208                0.00              -
209                0.00              -
210                0.00              -
211                0.00              -
212                0.00              -
213                0.00              -
214                0.00              -
215                0.00              -
216                0.00              -
217                0.00              -
218                0.00              -
219                0.00              -
220                0.00              -
221                0.00              -
222                0.00              -
223                0.00              -
224                0.00              -
225                0.00              -
226                0.00              -
227                0.00              -
228                0.00              -
229                0.00              -
230                0.00              -
231                0.00              -
232                0.00              -
233                0.00              -
234                0.00              -
235                0.00              -
236                0.00              -
237                0.00              -
238                0.00              -
239                0.00              -
240                0.00              -
241                0.00              -
242                0.00              -
243                0.00              -
244                0.00              -
245                0.00              -
246                0.00              -
247                0.00              -
248                0.00              -
249                0.00              -
250                0.00              -
       117,002      75,250                192,253   506
      Golf 1      Golf 2      Golf 3
      26,340.00   27,557.00   28,369.81
       1,843.80    1,928.99    1,985.89
  0.07000     0.07000     0.07000
24,496.20   25,628.01   26,383.92
24,200.00   25,200.00   25,500.00
   -8.12%      -8.55%     -10.12%
                              700
                        21,500.00
Maxicanone            13,000.00               Valore bene netto iva     130,000.00 Maxicanone
Riscatto              39,000.00               Moltiplicatore                12       Riscatto
                                              Numero pagamenti                  180 VA Riscatto
                                              Numero rate                       179
Tasso effettivo       6.16778%                Tasso effettivo annuale    6.16778%
                                              Tasso di periodo           0.50000%
Rata da excel           856.16   Differenza Valore attuale riscatto     15,891.81
Rata compl              858.97               Importo finanziato        101,108.19
Rata proposta                         #DIV/0! Rata netto iva                856.16       #DIV/0!
Sovratasso                                    Rata altre spese                 2.81
Costo finanz.          59.237%                Rata proposta                       - tasso assic.
                                              Sovratasso                 0.00000%         0.000%
IVA a credito         27,300.00         100% Monte canoni               207,008.26       59.237%
Scudo fiscale        130,000.00         100% Tasso effettivo ricar.      6.16778%
                  3143.82649888              Richiesta 0                    3.038% 167,159.34
                                             Richiesta 1                    5.350% 138,651.76
                                             Richiesta 2                    5.514% 132,822.82
    Spese         Rata con iva     Iva mat
      350.00         16,020.00      2,670.00              16,020.00     6,408.00
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23                                             2583.48
        5.00          1,035.20        171.23                                             3.5040
        5.00          1,035.20        171.23                    8520
        5.00          1,035.20        171.23                     360
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23 Quota interessi non deducibile irap
        5.00          1,035.20        171.23                6,368.82
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23              12,422.41     4,968.96
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23              12,422.41     4,968.96
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
        5.00          1,035.20        171.23
5.00   1,035.20   171.23   12,422.41   4,968.96
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23   12,422.41   4,968.96
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00   1,035.20   171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00    1,035.20     171.23
5.00   46,807.81   7,800.00
1,250   232,109   38,451
 13,000.00 Rimborso        Pag. anno     TAN      TEFF    Differenza
 39,000.00 semestrale                2   6.000%    6.090%    0.090%
 15,891.81 quadrimestrale           3   6.000%    6.121%    0.121%
            trimestrale              4   6.000%    6.136%    0.136%
            bimestrale               6   6.000%    6.152%    0.152%
            mensile                12    6.000%    6.168%    0.168%
           mensile                  1         1   mensile
           bimestrale                         2
           trimestrale                        3
           quadrimestrale                     4
           semestrale                         6
           Maxicanone          1000%     10.00%
           Riscatto            3000%     30.00%
           Tasso                   4
Valore bene                 135,000.00
Comprensivo di iva?           no
Durata                              -
Pagamento                   mensile
Tasso                            6.50% annuo
Capitalizzazione           composta
Spese incasso                     3.00
Spese pratica                   300.00
Maxicanone                          0%
Valore riscatto                     0%
Polizza assicurativa                - stima per tutta durata leasing
Manutenzione programmata            - stima per tutta durata leasing
Quota esente                        - stima studiare dove metterla
        Scadenze           Q.Capitale    Q.Interessi   Deb.Residuo     Rata
            0                                             135,000.00          -
            1                              731.25                 -
            2                               0.00                  -
            3                               0.00                  -
            4                               0.00                  -
            5                               0.00                  -
            6                               0.00                  -
            7                               0.00                  -
            8                               0.00                  -
            9                               0.00                  -
           10                               0.00                  -
           11                               0.00                  -
           12                               0.00                  -
           13                               0.00                  -
           14                               0.00                  -
           15                               0.00                  -
           16                               0.00                  -
           17                               0.00                  -
           18                               0.00                  -
           19                               0.00                  -
           20                               0.00                  -
           21                               0.00                  -
           22                               0.00                  -
           23                               0.00                  -
           24                               0.00                  -
           25                               0.00                  -
           26                               0.00                  -
           27                               0.00                  -
           28                               0.00                  -
           29                               0.00                  -
           30                               0.00                  -
           31                               0.00                  -
           32                               0.00                  -
           33                               0.00                  -
           34                               0.00                  -
           35                               0.00                  -
           36                               0.00                  -
37   0.00   -
38   0.00   -
39   0.00   -
40   0.00   -
41   0.00   -
42   0.00   -
43   0.00   -
44   0.00   -
45   0.00   -
46   0.00   -
47   0.00   -
48   0.00   -
49   0.00   -
50   0.00   -
51   0.00   -
52   0.00   -
53   0.00   -
54   0.00   -
55   0.00   -
56   0.00   -
57   0.00   -
58   0.00   -
59   0.00   -
60   0.00   -
61   0.00   -
62   0.00   -
63   0.00   -
64   0.00   -
65   0.00   -
66   0.00   -
67   0.00   -
68   0.00   -
69   0.00   -
70   0.00   -
71   0.00   -
72   0.00   -
73   0.00   -
74   0.00   -
75   0.00   -
76   0.00   -
77   0.00   -
78   0.00   -
79   0.00   -
80   0.00   -
81   0.00   -
82   0.00   -
83   0.00   -
84   0.00   -
85   0.00   -
86   0.00   -
87   0.00   -
88   0.00   -
89   0.00   -
90   0.00   -
91   0.00   -
92   0.00   -
93   0.00   -
 94   0.00   -
 95   0.00   -
 96   0.00   -
 97   0.00   -
 98   0.00   -
 99   0.00   -
100   0.00   -
101   0.00   -
102   0.00   -
103   0.00   -
104   0.00   -
105   0.00   -
106   0.00   -
107   0.00   -
108   0.00   -
109   0.00   -
110   0.00   -
111   0.00   -
112   0.00   -
113   0.00   -
114   0.00   -
115   0.00   -
116   0.00   -
117   0.00   -
118   0.00   -
119   0.00   -
120   0.00   -
121   0.00   -
122   0.00   -
123   0.00   -
124   0.00   -
125   0.00   -
126   0.00   -
127   0.00   -
128   0.00   -
129   0.00   -
130   0.00   -
131   0.00   -
132   0.00   -
133   0.00   -
134   0.00   -
135   0.00   -
136   0.00   -
137   0.00   -
138   0.00   -
139   0.00   -
140   0.00   -
141   0.00   -
142   0.00   -
143   0.00   -
144   0.00   -
145   0.00   -
146   0.00   -
147   0.00   -
148   0.00   -
149   0.00   -
150   0.00   -
151   0.00   -
152   0.00   -
153   0.00   -
154   0.00   -
155   0.00   -
156   0.00   -
157   0.00   -
158   0.00   -
159   0.00   -
160   0.00   -
161   0.00   -
162   0.00   -
163   0.00   -
164   0.00   -
165   0.00   -
166   0.00   -
167   0.00   -
168   0.00   -
169   0.00   -
170   0.00   -
171   0.00   -
172   0.00   -
173   0.00   -
174   0.00   -
175   0.00   -
176   0.00   -
177   0.00   -
178   0.00   -
179   0.00   -
180   0.00   -
181   0.00   -
182   0.00   -
183   0.00   -
184   0.00   -
185   0.00   -
186   0.00   -
187   0.00   -
188   0.00   -
189   0.00   -
190   0.00   -
191   0.00   -
192   0.00   -
193   0.00   -
194   0.00   -
195   0.00   -
196   0.00   -
197   0.00   -
198   0.00   -
199   0.00   -
200   0.00   -
201   0.00   -
202   0.00   -
203   0.00   -
204   0.00   -
205   0.00   -
206   0.00   -
207   0.00   -
208       0.00         -
209       0.00         -
210       0.00         -
211       0.00         -
212       0.00         -
213       0.00         -
214       0.00         -
215       0.00         -
216       0.00         -
217       0.00         -
218       0.00         -
219       0.00         -
220       0.00         -
221       0.00         -
222       0.00         -
223       0.00         -
224       0.00         -
225       0.00         -
226       0.00         -
227       0.00         -
228       0.00         -
229       0.00         -
230       0.00         -
231       0.00         -
232       0.00         -
233       0.00         -
234       0.00         -
235       0.00         -
236       0.00         -
237       0.00         -
238       0.00         -
239       0.00         -
240       0.00         -
241       0.00         -
242       0.00         -
243       0.00         -
244       0.00         -
245       0.00         -
246       0.00         -
247       0.00         -
248       0.00         -
249       0.00         -
250       0.00         -
      -          731       -
             Maxicanone                  -
             Riscatto                    -
             Tasso effettivo      6.69719%
             Rata da excel           Err:502 Differenza
             Rata proposta                       Err:502
             Sovratasso
             Costo finanz.         -99.778%
Rata altre       Spese         Rata con iva   Iva mat
                   300.00            360.00       60.00
-   300   -   -