Sheet1 (2)anuitati descrescatoareanuitati egaleredit40,000redit30,000dobanda3.00%dobanda5.90%perioada10perioada180ratadobandaanuitateratadobandaanuitate4,000.004,000.001,080.005,080.00423.33333333334,000.008,000.00960.004,960.00413.33333333334,000.0012,000.00840.004,840.00403.33333333334,000.0016,000.00720.004,720.00393.33333333334,000.0020,000.00600.004,600.00383.33333333334,000.0024,000.00480.004,480.00373.33333333334,000.0028,000.00360.004,360.00363.33333333334,000.0032,000.00240.004,240.00353.33333333334,000.0036,000.00120.004,120.00343.33333333334,000.0040,000.000.004,000.00333.33333333334,000.0044,000.00-10.003,990.004,000.0048,000.00-20.003,980.004,000.0052,000.00-30.003,970.004,000.0056,000.00-40.003,960.004,000.0060,000.00-50.003,950.004,000.0064,000.00-60.003,940.004,000.0068,000.00-70.003,930.004,000.0072,000.00-80.003,920.00a=r+d4,000.0076,000.00-90.003,910.00d=(30.000-r1)*5.9%4,000.0080,000.00-100.003,900.00a1=ai4,000.0084,000.00-110.003,890.004,000.0088,000.00-120.003,880.004,000.0092,000.00-130.003,870.004,000.0096,000.00-140.003,860.004,000.00100,000.00-150.003,850.004,000.00104,000.00-160.003,840.00

Sheet1anuitati descrescatoareanuitati egaleredit30,000redit30,000dobanda5.90%dobanda5.90%perioada180perioada180ratadobandaanuitateratadobandaanuitate166.67166.67146.68313.35166.67333.33145.86312.53166.67500.00145.04311.71166.67666.67144.22310.89166.67833.33143.40310.07166.671,000.00142.58309.25166.671,166.67141.76308.43166.671,333.33140.94307.61166.671,500.00140.13306.79166.671,666.67139.31305.97166.671,833.33138.49305.15166.672,000.00137.67304.33166.672,166.67136.85303.51166.672,333.33136.03302.69166.672,500.00135.21301.88166.672,666.67134.39301.06166.672,833.33133.57300.24166.673,000.00132.75299.42a=r+d166.673,166.67131.93298.60d=(30.000-r1)*5.9%166.673,333.33131.11297.78a1=ai166.673,500.00130.29296.96166.673,666.67129.47296.14166.673,833.33128.65295.32166.674,000.00127.83294.50166.674,166.67127.01293.68166.674,333.33126.19292.86