Folositi programul de calcula tabelar MS Excel pentru gestionarea depozitelor bancare.

Date de intrare: - D - valoarea depozitului - R - rata anuala a dobanzii (%) - raportata la D - N - numarul de ani de depozit (intreg).

Obs. La sfarsitul fiecarui an dobanda (ca valoare calculata) se capitalizeaza.

Pentru usurinta se considera numarul de ani ca fiind intreg (exceptie foaia de calcul Depuneri (real)).

Pentru usurinta se considera numarul de ani ca fiind intreg (exceptie foaia de calcul Depuneri (real)).

Situatie depuneri C.E.C.

AnulNume deponent Suma depusa depunerii ridicarii Suma ridicata

Popescu Ion 1000 1996 2008 3138.428376721Ionica Marian 2000 1997 2008 5706.23341222Georgescu Petre 3000 1995 2008 10356.813643179Zaharia Marian 500 2000 2008 1071.794405Alexandrescu Alin 1200 1995 2008 4142.7254572717Ionescu Petre 1100 1998 2008 2853.11670611Sica Ionut 2100 1997 2008 5991.545082831State Flavius 700 1999 2008 1650.5633837Stratulat Costinel 1400 1995 2008 4833.1797001503

Rata anuala a dobanzii(%)= 10 Total de plata= 39744.400167183

Obs: Tabelul are caracter didactic

Situatie depuneri C.E.C.

Nume deponent Suma depusa Anul depunerii Suma ridicata

Popescu Ion 1000 2001 4768.37158203125Ionica Marian 2000 1997 23283.064365387Georgescu Petre 3000 1995 54569.6821063757Zaharia Marian 500 2000 2980.23223876953Alexandrescu Alin 1200 1995 21827.8728425503Ionescu Petre 1100 1998 10244.5483207703Sica Ionut 2100 1997 24447.2175836563State Flavius 700 1999 5215.40641784668Stratulat Costinel 1400 1996 20372.6813197136

Suma totala de plata = 167709.076777101

Anul de lucru= 2008

Rata anuala a dobanzii(%)= 25

Obs: Tabelul are caracter didactic

3%

14%

33%

2%

13%6%

15%

3%12%

Procent din suma totala ridicata Popescu Ion

Ionica Marian

Georgescu Petre

Zaharia Marian

Alexandrescu Alin

Ionescu Petre

Sica Ionut

State Flavius

Stratulat Costinel

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Situatie depuneri C.E.C.

Nume deponent Suma depusa Anul depunerii Suma ridicata

Popescu Ion 1000000 2001 135525271.560688Ionica Marian 2000000 1997 661744490.042422Georgescu Petre 5600000 1995 2895132143.9356Zaharia Marian 4500000 2000 762329652.52887Alexandrescu Alin 4580000 1995 2367804503.43304Ionescu Petre 4512500 1998 1194448804.52657Sica Ionut 2569222 1997 850084251.097886State Flavius 4100000 1999 868208770.935658Stratulat Costinel 1000000 1996 413590306.276514

Suma totala de plata = 10148868194.34

Anul de lucru= 2023

Rata anuala a dobanzii(%)= 25

Obs: Tabelul are caracter didactic

3%

14%

33%

2%

13%6%

15%

3%12%

Procent din suma totala ridicata Popescu Ion

Ionica Marian

Georgescu Petre

Zaharia Marian

Alexandrescu Alin

Ionescu Petre

Sica Ionut

State Flavius

Stratulat Costinel

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Situatie depuneri C.E.C.

Nume deponent Suma depusa Dat depunerii Suma ridicata

Popescu Ion 1000 11/01/07 4583.8Ionica Marian 2000 01/02/07 9950.1Georgescu Petre 3000 11/03/07 13743.9Zaharia Marian 500 01/04/07 2486.2Alexandrescu Alin 1200 01/05/07 5965.2Ionescu Petre 1100 12/16/07 4980.4Sica Ionut 2100 01/07/07 10433.3State Flavius 700 01/08/07 3476.8Stratulat Costinel 1400 01/09/07 6951.7

0.00.00.0

Suma totala de plata = 62571.50

Data curenta 4/9/2023

Rata anuala a dobanzii(%)= 10

Obs: Tabelul are caracter didactic

3%

14%

33%

2%

13%6%

15%

3%12%

Procent din suma totala ridicata Popescu Ion

Ionica Marian

Georgescu Petre

Zaharia Marian

Alexandrescu Alin

Ionescu Petre

Sica Ionut

State Flavius

Stratulat Costinel

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

3%

14%

33%

2%

13%6%

15%

3%12%

Procent din suma totala ridicata Popescu Ion

Ionica Marian

Georgescu Petre

Zaharia Marian

Alexandrescu Alin

Ionescu Petre

Sica Ionut

State Flavius

Stratulat Costinel

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata

Popescu Ion3%

Ionica Marian14%

Georgescu Petre33%

Zaharia Marian2%

Alexandrescu Alin13%

Ionescu Petre6%

Sica Ionut15%

State Flavius3%

Stratulat Costinel12%

Procent din suma totala ridicata