MEVCUT DURUM by mq49C2d

VIEWS: 6 PAGES: 4

									* DİKKAT : TAKSİTLERİN BAŞLADIĞI TARİH TAHMİNİ OLARAK GİRİLMİŞTİR. DEĞİŞTİREBİLİRSİNİZ.
* VADE, YIL OLARAK GİRİLMELİDİR. ÖRNEK 144 AY = 12 YIL. ÖRNEK 120 AY = 10 YIL GİBİ. YIL / AY TABLOSUNDAN FAYD
* SADECE SARI RENK İLE BELİRTİLMİŞ ALANLARI DOLDURMANIZ YETERLİDİR.
* BU TABLO SİZLERE DURUM HAKKINDA FİKİR VERMEK AMACI İLE YAPILMIŞTIR. BANKAYA SÖZLEŞMEYİ İMZALAMAY
VADEYE BÖLMENİZ GEREKTİĞİ HAKKINDA DA FİKİR SAHİBİ OLABİLİRSİNİZ.
TAKSİTLERİN BAŞLADIĞI TARİH        5/31/2011                      YIL / AY TABLOSU
vade (yıl)                                  13                            6 YIL 72 AY
vade bitişi                          5/27/2024                            7 YIL 84 AY
SÖZLEŞME TARİHİNDEKİ BORÇ          36,000.00                              8 YIL 96 AY
ŞİMDİ AÇIKLANAN BORÇ               96,000.00                            9 YIL 108 AY
TAKSİT SAYISI (AY)                        156                          10 YIL 120 AY
                                                                       11 YIL 132 AY
ALTI AYDA BİR YAPILAN                                                  12 YIL 144 AY
ORTALAMA MEMUR MAAŞ ARTIŞI               4.22                          13 YIL 156 AY




                                   PERİYOD
                 ZAM TARİHLERİ      ( AY )    ALTI AYLIK ÖDEME AYLIK ÖDEME
                       6/30/2011            6 TAKSİT BAŞLANGICI
                      12/31/2011            6             3,848.12        641.35
                       6/30/2012            6             4,010.51        668.42
                      12/31/2012            6             4,179.76        696.63
                       6/30/2013            6             4,356.14        726.02
                      12/31/2013            6             4,539.97        756.66
                       6/30/2014            6             4,731.56        788.59
                      12/31/2014            6             4,931.23        821.87
                       6/30/2015            6             5,139.33        856.55
                      12/31/2015            6             5,356.21        892.70
                       6/30/2016            6             5,582.24        930.37
                      12/31/2016            6             5,817.81        969.64
                       6/30/2017            6             6,063.32      1,010.55
                      12/31/2017            6             6,319.20      1,053.20
                       6/30/2018            6             6,585.87      1,097.64
                      12/31/2018            6             6,863.79      1,143.96
                       6/30/2019            6             7,153.44      1,192.24
                      12/31/2019            6             7,455.32      1,242.55
                       6/30/2020            6             7,769.93      1,294.99
                      12/31/2020            6             8,097.82      1,349.64
                       6/30/2021            6             8,439.55      1,406.59
                      12/31/2021            6             8,795.70      1,465.95
                       6/30/2022            6             9,166.88      1,527.81
                      12/31/2022            6             9,553.72      1,592.29
                       6/30/2023            6             9,956.89      1,659.48
                      12/31/2023            6            10,377.07      1,729.51
                        1/0/1900            0            10,814.98      1,802.50
                        7/2/1900            0       #DIV/0!         #DIV/0!
                      12/30/1900            0       #DIV/0!         #DIV/0!
                        7/2/1901            0       #DIV/0!         #DIV/0!
                      12/30/1901            0       #DIV/0!         #DIV/0!
                        7/2/1902            0       #DIV/0!         #DIV/0!
                      12/30/1902            0       #DIV/0!         #DIV/0!
                        7/2/1903            0       #DIV/0!         #DIV/0!
                      12/30/1903            0       #DIV/0!         #DIV/0!
                                          156
İR. DEĞİŞTİREBİLİRSİNİZ.
AY = 10 YIL GİBİ. YIL / AY TABLOSUNDAN FAYDALANABİLİRSİNİZ.

LMIŞTIR. BANKAYA SÖZLEŞMEYİ İMZALAMAYA GİTTİĞİNİZDE BORCUNUZU KAÇ AYLIK




                                                             ŞİMDİKİ BORÇ ESKİ BORCA
                  ZAM SONRASI                       ZAM      TOPLAM           GÖRE TOPLAM
                    BAKİYE        KALAN BORÇ      SAĞLAMA ÖDENEN              ÖDENEN
                      100,051.20      100,051.20
                      100,262.85       96,203.08                     3,848.12        1,443.05
                      100,314.18       96,252.33        0.04         7,858.64        2,946.99
                      100,191.30       96,134.42        0.04       12,038.39         4,514.40
                       99,879.40       95,835.15        0.04       16,394.54         6,147.95
                       99,362.75       95,339.42        0.04       20,934.51         7,850.44
                       98,624.62       94,631.19        0.04       25,666.07         9,624.78
                       97,647.25       93,693.39        0.04       30,597.30        11,473.99
                       96,411.76       92,507.93        0.04       35,736.63        13,401.24
                       94,898.10       91,055.55        0.04       41,092.84        15,409.81
                       93,084.98       89,315.85        0.04       46,675.08        17,503.15
                       90,949.85       87,267.17        0.04       52,492.89        19,684.83
                       88,468.73       84,886.52        0.04       58,556.21        21,958.58
                       85,616.25       82,149.54        0.04       64,875.41        24,328.28
                       82,365.47       79,030.38        0.04       71,461.28        26,797.98
                       78,687.85       75,501.68        0.04       78,325.06        29,371.90
                       74,553.16       71,534.41        0.04       85,478.50        32,054.44
                       69,929.37       67,097.84        0.04       92,933.82        34,850.18
                       64,782.57       62,159.44        0.04      100,703.75        37,763.91
                       59,076.85       56,684.75        0.04      108,801.57        40,800.59
                       52,774.19       50,637.30        0.04      117,241.12        43,965.42
                       45,834.38       43,978.49        0.04      126,036.82        47,263.81
                       38,214.88       36,667.51        0.04      135,203.70        50,701.39
                       29,870.66       28,661.16        0.04      144,757.42        54,284.03
                       20,754.13       19,913.77        0.04      154,714.30        58,017.86
                       10,814.98       10,377.07        0.04      165,091.37        61,909.26
                             0.00            0.00       0.04      175,906.35        65,964.88
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
                     #DIV/0!         #DIV/0!       #DIV/0!       #DIV/0!         #DIV/0!
TAKSİTLERİN BAŞLADIĞI TARİH   5/31/2011
vade (yıl)                           13
vade bitişi                   5/27/2024
SÖZLEŞME TARİHİNDEKİ BORÇ     36,000.00
ESKİŞ BORÇ ESAS ALINDIĞINDA   36,000.00
TAKSİT SAYISI (AY)                  156

ALTI AYDA BİR YAPILAN
ORTALAMA MEMUR MAAŞ ARTIŞI         4.22


                              PERİYOT
               ZAM TARİHLERİ (AY)       ALTI AYLIK ÖDEME AYLIK ÖDEME
                    6/30/2011         6 TAKSİT BAŞLANGICI
                   12/31/2011         6              1,443.05      240.51
                    6/30/2012         6              1,503.94      250.66
                   12/31/2012         6              1,567.41      261.23
                    6/30/2013         6              1,633.55      272.26
                   12/31/2013         6              1,702.49      283.75
                    6/30/2014         6              1,774.33      295.72
                   12/31/2014         6              1,849.21      308.20
                    6/30/2015         6              1,927.25      321.21
                   12/31/2015         6              2,008.58      334.76
                    6/30/2016         6              2,093.34      348.89
                   12/31/2016         6              2,181.68      363.61
                    6/30/2017         6              2,273.75      378.96
                   12/31/2017         6              2,369.70      394.95
                    6/30/2018         6              2,469.70      411.62
                   12/31/2018         6              2,573.92      428.99
                    6/30/2019         6              2,682.54      447.09
                   12/31/2019         6              2,795.74      465.96
                    6/30/2020         6              2,913.72      485.62
                   12/31/2020         6              3,036.68      506.11
                    6/30/2021         6              3,164.83      527.47
                   12/31/2021         6              3,298.39      549.73
                    6/30/2022         6              3,437.58      572.93
                   12/31/2022         6              3,582.64      597.11
                    6/30/2023         6              3,733.83      622.31
                   12/31/2023         6              3,891.40      648.57
                     1/0/1900         0              4,055.62      675.94
                     7/2/1900         0        #DIV/0!        #DIV/0!
                   12/30/1900         0        #DIV/0!        #DIV/0!
                     7/2/1901         0        #DIV/0!        #DIV/0!
                   12/30/1901         0        #DIV/0!        #DIV/0!
                     7/2/1902         0        #DIV/0!        #DIV/0!
                   12/30/1902         0        #DIV/0!        #DIV/0!
                     7/2/1903         0        #DIV/0!        #DIV/0!
                   12/30/1903         0        #DIV/0!        #DIV/0!
                                    156
ZAM SONRASI                                TOPLAM
  BAKİYE        KALAN BORÇ                 ÖDENEN
     37,519.20      37,519.20
     37,598.57      36,076.15                  1,443.05
     37,617.82      36,094.62       0.04       2,946.99
     37,571.74      36,050.41       0.04       4,514.40
     37,454.77      35,938.18       0.04       6,147.95
     37,261.03      35,752.28       0.04       7,850.44
     36,984.23      35,486.70       0.04       9,624.78
     36,617.72      35,135.02       0.04      11,473.99
     36,154.41      34,690.47       0.04      13,401.24
     35,586.79      34,145.83       0.04      15,409.81
     34,906.87      33,493.45       0.04      17,503.15
     34,106.19      32,725.19       0.04      19,684.83
     33,175.78      31,832.45       0.04      21,958.58
     32,106.09      30,806.08       0.04      24,328.28
     30,887.05      29,636.39       0.04      26,797.98
     29,507.94      28,313.13       0.04      29,371.90
     27,957.43      26,825.40       0.04      32,054.44
     26,223.51      25,161.69       0.04      34,850.18
     24,293.46      23,309.79       0.04      37,763.91
     22,153.82      21,256.78       0.04      40,800.59
     19,790.32      18,988.99       0.04      43,965.42
     17,187.89      16,491.93       0.04      47,263.81
     14,330.58      13,750.32       0.04      50,701.39
     11,201.50      10,747.93       0.04      54,284.03
      7,782.80       7,467.66       0.04      58,017.86
      4,055.62       3,891.40       0.04      61,909.26
           0.00          0.00       0.04      65,964.88
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!
   #DIV/0!         #DIV/0!      #DIV/0!      #DIV/0!

								
To top