Toplam 5 adet sonuctan sayfa basi 1 ile 5 arasi kadar sonuc gösteriliyor

Konu: KAR DAĞITIMI

  1. #1
    Yeni Üye
    Üyelik tarihi
    20.Haziran.2005
    Nereden
    Turkey
    Mesajlar
    14


    MERHABALAR


    GEÇMİŞ YILLAR DAĞITILACAK KARIN STOPAJVE GELİR VERGİSİ HESAPLAMALARINA BİR ÖRNEK VEREREK AÇIKLAYA BİLİRMİSİNİZ. VERECEĞİNİZ BİLGİLER İÇİN ŞİMDİDEN TEŞEKKÜR EDERİM.
    murat

  2. #2
    Yönetici
    Üyelik tarihi
    03.Şubat.2004
    Nereden
    Antalya, Turkey
    Mesajlar
    4,608


    Sayın Kaplan,


    https://www.mustafagulsen.com.tr/dow...ndir.asp?id=24


    Bu dosyaya bir bakınız.
    ------------------
    Uyarı: Kişi veya kurumları eleştiri taşıyan mesajların altında eğer imza yok ise, gerekli görüldüğü zaman mesajlara forum yetkililerince uyarısız müdehale yapılacaktır.

  3. #3
    Yeni Üye
    Üyelik tarihi
    20.Haziran.2005
    Nereden
    Turkey
    Mesajlar
    14


    2003 YILI KARI= 697.047,79


    2004YILI KARI= 814.981,97


    TOPLAM= 1.512.029,76


    %10 STOPAJ= 151.202,98


    ORTAKLARA DAĞITILACAK=1.360.826,78


    İSTİSNA %050= 680.413,39


    VERGİ MATRAHI=680.413,39


    (2 ORTAK %50) 1. ORTAK= 340.206,70


    YILLIK GELİR VERGİSİ=129.602,68


    ÖDENEN STOPAJ(151202,98X%50) = 75.601,49


    ÖDENECEK Y.G.V.1. ORTAK =54.001,19


    BU HESAPLAMA DOĞRUMUDUR. YARDIMCI OLURSANIZ SEVİNİRİM. Edited by: ceykaplan
    murat

  4. #4
    Ziyaretci


    Sayın Murat


    Soruna cevap verebilmek için öncelikle karı dağıtan şirketin türüde önemlidir.


    Firmanın türü, toplam sermaye, ödenmiş sermaye, 1. ve 2. tertip yedek akçe tutarlarınıda bildirmen soruna cevap açısından gerekmektedir.


    İyi Çalışmalar

  5. #5
    Üye
    Üyelik tarihi
    05.Şubat.2005
    Nereden
    Turkey
    Mesajlar
    43



    <TABLE style="WIDTH: 654pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=871 border=0 x:str>
    <COLGROUP>
    <COL style="WIDTH: 353pt; mso-width-source: userset; mso-width-alt: 17188" width=470>
    <COL style="WIDTH: 108pt; mso-width-source: userset; mso-width-alt: 5266" width=144>
    <COL style="WIDTH: 193pt; mso-width-source: userset; mso-width-alt: 9398" width=257>
    <T>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl62 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 461pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; : transparent" width=614 colSpan=2 height=20>AK KALIP SAN.VE TİC. LTD.ŞTİ.</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 193pt; BORDER-BOTTOM: #e0dfe3; : transparent" width=257></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl64 style="BORDER-RIGHT: black 1pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 461pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; : transparent" width=614 colSpan=2 height=20><A name=RANGE!A2:B54>KAR DAĞITIM TABLOSU</A></TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl28 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20>2000 Dağıtılan Karı</TD>
    <TD =xl29 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff" align=right x:fmla="=ROUND(40744425179/1000000,2)" x:num="40744.43">40.744,43</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=YUVARLA(40744425179/1000000;2)">=YUVARLA(40744425179/1000000;2)</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl30 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20>2001 Dağıtılan Karı</TD>
    <TD =xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff" align=right x:fmla="=ROUND(28330900000/1000000,2)" x:num="28330.9">28.330,90</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=YUVARLA(28330900000/1000000;2)">=YUVARLA(28330900000/1000000;2)</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl30 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20>2002 Dağıtılan Karı</TD>
    <TD =xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff" align=right x:fmla="=ROUND(283267739151/1000000,2)" x:num="283267.74">283.267,74</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=YUVARLA(283267739151/1000000;2)">=YUVARLA(283267739151/1000000;2)</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl32 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20>Vergi Sonrası Toplam Kar</TD>
    <TD =xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff" align=right x:fmla="=SUM(B3:B5)" x:num="352343.07">352.343,07</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=TOPLA(B3:B5)">=TOPLA(B3:B5)</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl32 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20>Geçmiş Yıl Ticari Zararları</TD>
    <TD =xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff"></TD>
    <TD =xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl33 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; : #ccffff" height=20>Vergi Sonrası Dağıtımına Karar Verilen Kar (-) G. Yıl Ticari Zararları</TD>
    <TD =xl34 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 1pt solid; : #ccffff" align=right x:fmla="=B6-B7" x:num="352343.07">352.343,07</TD>
    <TD =xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B6-B7">=B6-B7</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl35 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Ödenmiş Sermaye</TD>
    <TD =xl36 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:num="350000">350.000,00</TD>
    <TD =xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Birinci Tertip Yedek Akçe Ayırma Sınırı</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B9*0.2" x:num="70000">70.000,00</TD>
    <TD =xl66 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B9*0,2">=B9*0,2</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Daha Önce Ayrılmış Birinci Tertip Yedek Akçeler</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:num="2332.7">2.332,70</TD>
    <TD =xl25 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Cari Yıl İçin Ayrılabilecek Azami Birinci Tertip Yedek Akçe</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B10-B11" x:num="67667.3">67.667,30</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B10-B11">=B10-B11</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl39 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Birinci Tertip Yedek Akçe</TD>
    <TD =xl40 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=IF(B8*0.05>B12,B12,B8*0.05)" x:num="17617.1535">17.617,15</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=EĞER(B8*0,05>B12;B12;B8*0,05)">=EĞER(B8*0 ,05&gt;B12;B12;B8*0,05)</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl41 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Toplam Birinci Tertip Yedek Akçe</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B11+B13" x:num="19949.853500000001">19.949,85</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B11+B13">=B11+B13</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl41 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Birinci Tertip Yedek Akçeden sonra kalan</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B8-B13" x:num="334725.91649999999">334.725,92</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B8-B13">=B8-B13</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl39 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Birinci Temettü</TD>
    <TD =xl40 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B9*0.05" x:num="17500">17.500,00</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B8-B13">=B8-B13</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl42 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; WIDTH: 353pt; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" width=470 height=20>Yönetim Kurulu Payı</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:num="0">0,00</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl41 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Ortaklar Dışında Kalan Kardan Pay Alma Hakkı Olanlara Verilecek Paralar</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:num="0">0,00</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl41 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>İkinci Temettü</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:num="0">0,00</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl43 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; : #ffff99" height=20>İkinci Tertip Yedek Akçe</TD>
    <TD =xl44 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 1pt solid; : #ffff99" align=right x:fmla="=(B8-B13-B16)*0.1" x:num="31722.591650000002">31.722,59</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=(B8-B13-B16)*0,1">=(B8-B13-B16)*0,1</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl45 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; WIDTH: 353pt; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffcc" width=470 height=20>Kalan Dağıtılabilecek Kar</TD>
    <TD =xl46 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffcc" align=right x:fmla="=B8-B13-B16-B20" x:num="285503.32484999998">285.503,32</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B8-B13-B16-B20">=B8-B13-B16-B20</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl47 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; WIDTH: 353pt; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffcc" width=470 height=20>Stopaja Tabi Olmayan Kısım ( stopaj düşüldükten sonraki, İstisna Kazanç)</TD>
    <TD =xl27 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffcc" align=right x:num="303003.34140000003">303.003,34</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl48 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; WIDTH: 353pt; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffcc" width=470 height=20>Kar Dağıtımı Nedeniyle Stopaj Matrahı (1.Temettü de vergilendirilir.)</TD>
    <TD =xl49 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffcc" align=right x:fmla="=B21+B16-B22" x:num="-1.6550000058487058E-2">-0,02</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B21+B16-B22">=B21+B16-B22</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl47 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; WIDTH: 353pt; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffcc" width=470 height=20>Hesaplanan Stopaj</TD>
    <TD =xl27 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffcc" align=right x:fmla="=B23*0.1" x:num="-1.6550000058487059E-3">0,00</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B23*0,1">=B23*0,1</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl50 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; WIDTH: 353pt; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; : #ccffcc" width=470 height=20>Dağıtılabilir Net Kar</TD>
    <TD =xl51 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 1pt solid; : #ccffcc" align=right x:fmla="=B16+B21" x:num="303003.32484999998">303.003,32</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B16+B21">=B16+B21</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl52 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20>Ortaklar Kar Payları Vergi Hesaplaması (Dağıtılan Kar)</TD>
    <TD =xl53 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: windowtext; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff" align=right x:fmla="=B25" x:num="303003.32484999998">303.003,32</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B25">=B25</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK (%34)</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=$B$26*34%" x:num="103021.130449">103.021,13</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=$B$26*34%">=$B$26*34%</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK Kar Payının 1/9'u</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B27/9" x:num="11446.792272111112">11.446,79</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B27/9">=B27/9</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK Kar Payı Tutarı</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B27+B28" x:num="114467.92272111111">114.467,92</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B27+B28">=B27+B28</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl41 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK Beyan Edilmeyecek Tutar</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=$B$29/2" x:num="57233.961360555557">57.233,96</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=$B$29/2">=$B$29/2</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl41 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK Beyan Edilecek Tutar</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B29/2" x:num="57233.961360555557">57.233,96</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B29/2">=B29/2</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK Hesaplanan Gelir Vergisi</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:num="17451.89">17.451,89</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=DGV2005(B31)">=DGV2005(B31)</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK Mahsup Edilecek kısım 1/5</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B31/5" x:num="11446.792272111112">11.446,79</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B31/5">=B31/5</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl37 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffff99" height=20>Salim AK Ödenecek Gelir Vergisi</TD>
    <TD =xl38 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffff99" align=right x:fmla="=B32-B33" x:num="6005.0977278888877">6.005,10</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent" x:str="'=B32-B33">=B32-B33</TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl32 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20></TD>
    <TD =xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff"></TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl56 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK (%33)</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:fmla="=$B$26*33%" x:num="99991.097200499993">99.991,10</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl56 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK Kar Payının 1/9'u</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:fmla="=B36/9" x:num="11110.121911166665">11.110,12</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl56 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK Kar Payı Tutarı</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:fmla="=B36+B37" x:num="111101.21911166667">111.101,22</TD>
    <TD =xl26 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl58 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK Beyan Edilmeyecek Tutar</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:fmla="=$B$29/2" x:num="57233.961360555557">57.233,96</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl58 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK Beyan Edilecek Tutar</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:fmla="=B38/2" x:num="55550.609555833333">55.550,61</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl56 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK Hesaplanan Gelir Vergisi</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:num="16862.71">16.862,71</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl56 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK Mahsup Edilecek kısım 1/5</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:fmla="=B40/5" x:num="11110.121911166667">11.110,12</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl56 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ffcc00" height=20>Vedat AK Ödenecek Gelir Vergisi</TD>
    <TD =xl57 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ffcc00" align=right x:fmla="=B41-B42" x:num="5752.5880888333322">5.752,59</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl32 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20></TD>
    <TD =xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff"></TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl59 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK (%33)</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:fmla="=$B$26*33%" x:num="99991.097200499993">99.991,10</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl59 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK Kar Payının 1/9'u</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:fmla="=B45/9" x:num="11110.121911166665">11.110,12</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl59 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK Kar Payı Tutarı</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:fmla="=B45+B46" x:num="111101.21911166667">111.101,22</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl61 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK Beyan Edilmeyecek Tutar</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:fmla="=$B$29/2" x:num="57233.961360555557">57.233,96</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl61 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK Beyan Edilecek Tutar</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:fmla="=B47/2" x:num="55550.609555833333">55.550,61</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl59 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK Hesaplanan Gelir Vergisi</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:num="16862.71">16.862,71</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl59 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK Mahsup Edilecek kısım 1/5</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:fmla="=B49/5" x:num="11110.121911166667">11.110,12</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl59 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ff99cc" height=20>Sedat AK Ödenecek Gelir Vergisi</TD>
    <TD =xl60 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ff99cc" align=right x:fmla="=B50-B51" x:num="5752.5880888333322">5.752,59</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl32 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: #e0dfe3 0.5pt; HEIGHT: 15pt; : #ccffff" height=20></TD>
    <TD =xl31 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3 0.5pt; : #ccffff"></TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR>
    <TR style="HEIGHT: 15pt; mso-height-source: userset" height=20>
    <TD =xl54 style="BORDER-RIGHT: #e0dfe3 0.5pt; BORDER-TOP: #e0dfe3; BORDER-LEFT: windowtext 1pt solid; BORDER-BOTTOM: windowtext 1pt solid; HEIGHT: 15pt; : #ccffff" height=20>Toplam Ödenecek Gelir Vergisi</TD>
    <TD =xl55 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: windowtext 1pt solid; : #ccffff" align=right x:fmla="=SUM(B34,B43,B52)" x:num="17510.27390555555">17.510,27</TD>
    <TD =xl24 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; BORDER-BOTTOM: #e0dfe3; : transparent"></TD></TR></T></TABLE>


    Excelde olmayan tarafımdan eklenen diğer Gelirlerin Vergisini hesaplayan bu fonksiyonu Excelde AltF11 ile açılan pencereden Insert Module komutu ile eklenen modüle ekleyiniz.


    Function DGV2005(Matrah As Double) As Double
    Select Case Matrah
    Case 0# To 6600#: DGV2005 = CDbl(Round(0.2 * Matrah, 2))
    Case 6601# To 15000#: DGV2005 = CDbl(Round(0.25 * (Matrah - 6600#), 2) + 1320)
    Case 15001# To 30000#: DGV2005 = CDbl(Round(0.3 * (Matrah - 15000#), 2) + 3420)
    Case 30001# To 78000#: DGV2005 = CDbl(Round(0.35 * (Matrah - 30000#), 2) + 7920)
    Case Is &gt;= 78001#: DGV2005 = CDbl(Round(0.4 * (Matrah - 78000#), 2) + 24720)
    End Select
    End Function



    http://www.excel.name.tr/Kitap.gif<a href=\"www.excel.name.tr/forum/viewtopic.php?t=2\" target=\"_blank\"> <img src=\"http://www.excel.name.tr/CD.gif\" border=\"0\"

Yetkileriniz

  • Konu Acma Yetkiniz Yok
  • Cevap Yazma Yetkiniz Yok
  • Eklenti Yükleme Yetkiniz Yok
  • Mesajınızı Değiştirme Yetkiniz Yok
  •