Microsoft Office Excel ® Kod Kılavuzu

Microsoft Office Excel® Code Guide

24 Haziran 2010 Perşembe

DuPont Analizi [DuPont Analysis (Return on Assets (ROA) and Return on Equity (ROE))]




'Module1

'A) VBProject References List

'Name: VBA, Description: Visual Basic For Applications, FullPath: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
'Name: Excel, Description: Microsoft Excel 11.0 Object Library, FullPath: C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE
'Name: stdole, Description: OLE Automation, FullPath: C:\WINDOWS\system32\stdole2.tlb
'Name: Office, Description: Microsoft Office 11.0 Object Library, FullPath: C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL

'B) DuPont Analysis Resource References

'Prof. Dr. Atilla GÖNENLİ
'Finansal Tablolar Analiz ve Yorumu
'Sermet Matbaası, İst. 1979 II. Baskı S.364-365

Sub DuPontAnaliziKur()

On Error Resume Next
'GelirTablosu [Income Statement]
Sheets("GelirTablosu").Select
If VBA.Err.Number <> 0 Then VBA.Err.Number = 0: ThisWorkbook.Worksheets.Add Sheets(1): ActiveSheet.Name = "GelirTablosu"
ActiveSheet.Unprotect
Cells.Select: Selection.Delete Shift:=xlUp
ActiveWindow.FreezePanes = False
Range("A1").FormulaR1C1 = "GELİR TABLOSU [INCOME STATEMENT] [USD]"
Range("A3").FormulaR1C1 = "İşlem Tanımı (Description)"
Range("C3").FormulaR1C1 = "2009"
Range("A4").FormulaR1C1 = "A -BRÜT SATIŞLAR": Range("B4").FormulaR1C1 = "A -GROSS SALES": Range("C4").FormulaR1C1 = "=SUM(R[1]C:R[3]C)":
Range("A5").FormulaR1C1 = " 1-Yurtiçi Satışlar": Range("B5").FormulaR1C1 = " 1-Domestic Sales": Range("C5").FormulaR1C1 = "2132500":
Range("A6").FormulaR1C1 = " 2-Yurtdışı Satışlar": Range("B6").FormulaR1C1 = " 2-Export Sales": Range("C6").FormulaR1C1 = "499400":
Range("A7").FormulaR1C1 = " 3-Diğer Gelirler": Range("B7").FormulaR1C1 = " 3-Other Sales": Range("C7").FormulaR1C1 = "657100":
Range("A8").FormulaR1C1 = "B -SATIŞ İNDİRİMLERİ (-)": Range("B8").FormulaR1C1 = "B -SALES DISCOUNTS (-)": Range("C8").FormulaR1C1 = "=SUM(R[1]C:R[3]C)":
Range("A9").FormulaR1C1 = " 1-Satış İadeleri (-)": Range("B9").FormulaR1C1 = " 1-Sales Returns (-)": Range("C9").FormulaR1C1 = "86100":
Range("A10").FormulaR1C1 = " 2-Satış Iskontoları (-)": Range("B10").FormulaR1C1 = " 2-Sales Discounts (-)": Range("C10").FormulaR1C1 = "55100":
Range("A11").FormulaR1C1 = " 3-Diğer İndirimler (-)": Range("B11").FormulaR1C1 = " 3-Other Discounts (-)": Range("C11").FormulaR1C1 = "92950":
Range("A12").FormulaR1C1 = "C -NET SATIŞLAR": Range("B12").FormulaR1C1 = "C -NET SALES": Range("C12").FormulaR1C1 = "=R[-8]C-R[-4]C":
Range("A13").FormulaR1C1 = "D -SATIŞLARIN MALİYETİ (-)": Range("B13").FormulaR1C1 = "D -COST OF SALES(-)": Range("C13").FormulaR1C1 = "=SUM(R[1]C:R[4]C)":
Range("A14").FormulaR1C1 = " 1-Satılan Mamuller Maliyeti (-)": Range("B14").FormulaR1C1 = " 1-Cost of Goods Solds(Product) (-)": Range("C14").FormulaR1C1 = "277975":
Range("A15").FormulaR1C1 = " 2-Satılan Ticari Mallar Maliyeti (-)": Range("B15").FormulaR1C1 = " 2-Cost of Commercial Goods Sold (-)": Range("C15").FormulaR1C1 = "351750":
Range("A16").FormulaR1C1 = " 3-Satılan Hizmet Maliyeti (-)": Range("B16").FormulaR1C1 = " 3-Cost of Services Sold (-)": Range("C16").FormulaR1C1 = "417550":
Range("A17").FormulaR1C1 = " 4-Diğer Satışların Maliyeti (-)": Range("B17").FormulaR1C1 = " 4-Cost of Other Sales (-)": Range("C17").FormulaR1C1 = "96600":
Range("A18").FormulaR1C1 = "BRÜT SATIŞ KARI VEYA ZARARI": Range("B18").FormulaR1C1 = "GROSS PROFİT/LOSS": Range("C18").FormulaR1C1 = "=R[-6]C-R[-5]C": Range("E18").FormulaR1C1 = "=IF(R12C3=0,0,RC[-2]/R12C3)"
Range("A19").FormulaR1C1 = "E -FAALİYET GİDERLERİ (-)": Range("B19").FormulaR1C1 = "E -OPERATING EXPENSES (-)": Range("C19").FormulaR1C1 = "=SUM(R[1]C:R[3]C)":
Range("A20").FormulaR1C1 = " 1-Araştırma ve Geliştirme Giderleri (-)": Range("B20").FormulaR1C1 = " 1-Research and Development Expenses (-)": Range("C20").FormulaR1C1 = "72950":
Range("A21").FormulaR1C1 = " 2-Pazarlama, Satış ve Dağıtım Giderleri (-)": Range("B21").FormulaR1C1 = " 2-Marketing, Selling and Distribution Expenses (-)": Range("C21").FormulaR1C1 = "126500":
Range("A22").FormulaR1C1 = " 3-Genel Yönetim Giderleri (-)": Range("B22").FormulaR1C1 = " 3-General Adminitrative Expenses (-)": Range("C22").FormulaR1C1 = "312800":
Range("A23").FormulaR1C1 = "FAALİYET KARI VEYA ZARARI": Range("B23").FormulaR1C1 = "OPERATING PROFIT/LOSS": Range("C23").FormulaR1C1 = "=R[-5]C-R[-4]C": Range("E23").FormulaR1C1 = "=IF(R12C3=0,0,RC[-2]/R12C3)"
Range("A24").FormulaR1C1 = "F -DİĞER FAALİYETLERDEN OLAĞAN GELİR VE KARLAR": Range("B24").FormulaR1C1 = "F -INCOME AND PROFIT FROM OTHER OPERATIONS": Range("C24").FormulaR1C1 = "=SUM(R[1]C:R[10]C)":
Range("A25").FormulaR1C1 = " 1-İştiraklerden Temettü Gelirleri": Range("B25").FormulaR1C1 = " 1-Dividend Income from Participations": Range("C25").FormulaR1C1 = "52400":
Range("A26").FormulaR1C1 = " 2-Bağlı Ortaklıklardan Temettü Geliri": Range("B26").FormulaR1C1 = " 2-Dividend Income from Subsidiaries": Range("C26").FormulaR1C1 = "71350":
Range("A27").FormulaR1C1 = " 3-Faiz Geliri": Range("B27").FormulaR1C1 = " 3-Interest Income": Range("C27").FormulaR1C1 = "18500":
Range("A28").FormulaR1C1 = " 4-Komisyon Gelirleri": Range("B28").FormulaR1C1 = " 4-Commission Income": Range("C28").FormulaR1C1 = "62100":
Range("A29").FormulaR1C1 = " 5-Konusu Kalmayan Karşılıklar": Range("B29").FormulaR1C1 = " 5-Provisions No Longer Required": Range("C29").FormulaR1C1 = "82800":
Range("A30").FormulaR1C1 = " 6-Menkul Kıymetler Satış Karları": Range("B30").FormulaR1C1 = " 6-Gains on Marketable Securities' Sales": Range("C30").FormulaR1C1 = "91750":
Range("A31").FormulaR1C1 = " 7-Kambiyo Karları": Range("B31").FormulaR1C1 = " 7-Foreign Exchange Gain": Range("C31").FormulaR1C1 = "5890":
Range("A32").FormulaR1C1 = " 8-Reeskont Faiz Gelirleri": Range("B32").FormulaR1C1 = " 8-Discount on Interest Gain": Range("C32").FormulaR1C1 = "42210":
Range("A33").FormulaR1C1 = " 9-Enflasyon Düzeltmesi Karları": Range("B33").FormulaR1C1 = " 9-Gains from Inflation Adjustment": Range("C33").FormulaR1C1 = "24410":
Range("A34").FormulaR1C1 = " 10-Faaliyetle İlgili Diğer Olağan Gelirler ve Karlar": Range("B34").FormulaR1C1 = " 10-Other Income and Profit from Operations": Range("C34").FormulaR1C1 = "8850":
Range("A35").FormulaR1C1 = "G -DİĞER FAALİYETLERDEN OLAĞAN GİDER VE ZARARLARI (-)": Range("B35").FormulaR1C1 = "G -EXPENSES AND LOSS FROM OTHER OPERATIONS (-)": Range("C35").FormulaR1C1 = "=SUM(R[1]C:R[7]C)":
Range("A36").FormulaR1C1 = " 1-Komisyon Giderleri (-)": Range("B36").FormulaR1C1 = " 1-Commision Expenses (-)": Range("C36").FormulaR1C1 = "62100":
Range("A37").FormulaR1C1 = " 2-Karşılık Giderleri (-)": Range("B37").FormulaR1C1 = " 2-Provision Expenses (-)": Range("C37").FormulaR1C1 = "44300":
Range("A38").FormulaR1C1 = " 3-Menkul Kıymet Satış Zararları (-)": Range("B38").FormulaR1C1 = " 3-Losses on Marketable Securities' Sales(-)": Range("C38").FormulaR1C1 = "1685":
Range("A39").FormulaR1C1 = " 4-Kambiyo Zararları (-)": Range("B39").FormulaR1C1 = " 4-Foreign Exchange Losses (-)": Range("C39").FormulaR1C1 = "72100":
Range("A40").FormulaR1C1 = " 5-Reeskont Faiz Giderleri (-)": Range("B40").FormulaR1C1 = " 5-Interest Expenses on Discounted Notes (-)": Range("C40").FormulaR1C1 = "83300":
Range("A41").FormulaR1C1 = " 6-Enflasyon Düzeltmesi Zararları (-)": Range("B41").FormulaR1C1 = " 6-Loss from Inflation Adjustment (-)": Range("C41").FormulaR1C1 = "59400":
Range("A42").FormulaR1C1 = " 7-Faaliyetle İlgili Diğer Olağan Gider ve Zararlar (-)": Range("B42").FormulaR1C1 = " 7-Other Expenses and Losses (-)": Range("C42").FormulaR1C1 = "9580":
Range("A43").FormulaR1C1 = "H -FİNANSMAN GİDERLERİ (-)": Range("B43").FormulaR1C1 = "H -FINANCIAL EXPENSES (-)": Range("C43").FormulaR1C1 = "=SUM(R[1]C:R[2]C)":
Range("A44").FormulaR1C1 = " 1-Kısa Vadeli Borçlanma Giderleri (-)": Range("B44").FormulaR1C1 = " 1-Short-Term Borrowing Expenses (-)": Range("C44").FormulaR1C1 = "419750":
Range("A45").FormulaR1C1 = " 2-Uzun Vadeli Borçlanma Giderleri (-)": Range("B45").FormulaR1C1 = " 2-Long-Term Borrowing Expenses (-)": Range("C45").FormulaR1C1 = "27985":
Range("A46").FormulaR1C1 = "OLAĞAN KAR VEYA ZARAR": Range("B46").FormulaR1C1 = "OPERATIONAL PROFIT/(LOSS)": Range("C46").FormulaR1C1 = "=R[-23]C+R[-22]C-(R[-11]C+R[-3]C)": Range("E46").FormulaR1C1 = "=IF(R12C3=0,0,RC[-2]/R12C3)"
Range("A47").FormulaR1C1 = "I -OLAĞANDIŞI GELİR VE KARLAR": Range("B47").FormulaR1C1 = "I -EXTRAORDINARY INCOME AND PROFIT": Range("C47").FormulaR1C1 = "=SUM(R[1]C:R[2]C)":
Range("A48").FormulaR1C1 = " 1-Önceki Dönem Gelir ve Karları": Range("B48").FormulaR1C1 = " 1-Income and Profit Relating to Previous Years": Range("C48").FormulaR1C1 = "7560":
Range("A49").FormulaR1C1 = " 2-Diğer Olağandışı Gelir ve Karlar": Range("B49").FormulaR1C1 = " 2-Other Extraordinary Expenses and Loss (-)": Range("C49").FormulaR1C1 = "8235":
Range("A50").FormulaR1C1 = "J -OLAĞAN DIŞI GİDER VE ZARARLAR (-)": Range("B50").FormulaR1C1 = "J -EXTRAORDINARY EXPENSE AND LOSS": Range("C50").FormulaR1C1 = "=SUM(R[1]C:R[3]C)":
Range("A51").FormulaR1C1 = " 1-Çalışmayan Kısım Gider ve Zararları (-)": Range("B51").FormulaR1C1 = " 1-Idle Capacity Expenses and Losses (-)": Range("C51").FormulaR1C1 = "92485":
Range("A52").FormulaR1C1 = " 2-Önceki Dönem Gider ve Zararları (-)": Range("B52").FormulaR1C1 = " 2-Previous Period Expenses and Losses (-)": Range("C52").FormulaR1C1 = "1685":
Range("A53").FormulaR1C1 = " 3-Diğer Olağandışı Gider ve Zararlar (-)": Range("B53").FormulaR1C1 = " 3-Other Extraordinary Expense and Loss (-)": Range("C53").FormulaR1C1 = "3475":
Range("A54").FormulaR1C1 = "DÖNEM KARI VEYA ZARARI": Range("B54").FormulaR1C1 = "PROFIT/(LOSS) FOR THE PERIOD": Range("C54").FormulaR1C1 = "=R[-8]C+R[-7]C-R[-4]C": Range("E54").FormulaR1C1 = "=IF(R12C3=0,0,RC[-2]/R12C3)"
Range("A55").FormulaR1C1 = "K -DÖNEM KARI VERGİ VE DİĞER YASAL YÜK. KRŞ. (-)": Range("B55").FormulaR1C1 = "K -PROVISIONS FOR TAXATION AND OTHER LEGAL LIABILITIES(-)": Range("C55").FormulaR1C1 = "=ROUND(R[-1]C*0.36,0)":
Range("A56").FormulaR1C1 = "DÖNEM NET KARI VEYA ZARARI": Range("B56").FormulaR1C1 = "NET PROFIT/(LOSS) FOR THE PERIOD": Range("C56").FormulaR1C1 = "=R[-2]C-R[-1]C": Range("E56").FormulaR1C1 = "=IF(R12C3=0,0,RC[-2]/R12C3)"
Range("C4:C56").NumberFormat = "#,##0.00" :Range("A4:A56").Font.Name="Arial Tur"
Range("E18,E23,E46,E54,E56").NumberFormat = "0.00%"
With Range("A1:C1,A3:B3,C3")

.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = True
.ReadingOrder = xlContext
.MergeCells = True

End With
Range("A1:C4,A8:C8,A12:C13,A18:C19,E18,A23:C24,E23,A35:C35,A43:C43,A46:C47,E46,A50:C50,A54:C56,E54,E56").Font.Bold = True
With Range("C5:C7,C9:C11,C14:C17,C20:C22,C25:C34,C36:C42,C44:C45,C48:C49,C51:C53,C55")

.Font.ColorIndex = 32
.Locked = False

End With
With Range("A1:C1")

With .Font

.Name = "Arial Tur"
.Size = 14
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 2

End With
With .Interior

.ColorIndex = 5
.Pattern = xlSolid

End With

End With
With Range("A3:C56,C3:C56,E18,E23,E46,E54,E56,A3:C3")

.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
With .Borders(xlInsideVertical)

.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5

End With
With .Borders(xlInsideHorizontal)

.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5

End With
With .Borders(xlEdgeLeft)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeTop)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeBottom)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeRight)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With

End With
Columns("A:B").ColumnWidth = 62
Columns("C:C").ColumnWidth = 14
Columns("D:D").ColumnWidth = 1
Rows("2:2").RowHeight = 6
Rows("4:4").Select: ActiveWindow.FreezePanes = True
Range("C3").Select
ActiveSheet.Protect
'Bilanço [Balance Sheet]
Sheets("Bilanço").Select
If VBA.Err.Number <> 0 Then VBA.Err.Number = 0: ThisWorkbook.Worksheets.Add , After:=Sheets("GelirTablosu"): ActiveSheet.Name = "Bilanço"
ActiveSheet.Unprotect
Cells.Select: Selection.Delete Shift:=xlUp
ActiveWindow.FreezePanes = False
Range("A1").FormulaR1C1 = "VARLIK-KAYNAK DENGESİ (BİLANÇO) TABLOSU [BALANCE SHEET] [USD]"
Range("A3").FormulaR1C1 = "İşlem Tanımı (Description)"
Range("C3").FormulaR1C1 = "2008"
Range("D3").FormulaR1C1 = "2009"
Range("A4").FormulaR1C1 = "I.DÖNEN VARLIKLAR ": Range("B4").FormulaR1C1 = "I.CURRENT ASSETS ": Range("C4").FormulaR1C1 = "=SUM(R[1]C+R[7]C+R[13]C+R[22]C+R[31]C+R[39]C+R[43]C+R[46]C)": Range("D4").FormulaR1C1 = "=SUM(R[1]C+R[7]C+R[13]C+R[22]C+R[31]C+R[39]C+R[43]C+R[46]C)"
Range("A5").FormulaR1C1 = " A.Hazır Değerler ": Range("B5").FormulaR1C1 = " A.Liquıd Assets ": Range("C5").FormulaR1C1 = "=(R[1]C+R[2]C+R[3]C+R[5]C)-R[4]C": Range("D5").FormulaR1C1 = "=(R[1]C+R[2]C+R[3]C+R[5]C)-R[4]C"
Range("A6").FormulaR1C1 = " 1.Kasa": Range("B6").FormulaR1C1 = " 1.Cash ": Range("C6").FormulaR1C1 = "5114": Range("D6").FormulaR1C1 = "6175"
Range("A7").FormulaR1C1 = " 2.Alınan Çekler": Range("B7").FormulaR1C1 = " 2.Cheques Received": Range("C7").FormulaR1C1 = "64929": Range("D7").FormulaR1C1 = "76603"
Range("A8").FormulaR1C1 = " 3.Bankalar": Range("B8").FormulaR1C1 = " 3.Banks": Range("C8").FormulaR1C1 = "56516": Range("D8").FormulaR1C1 = "55723"
Range("A9").FormulaR1C1 = " 4.Verilen Çek ve Ödeme Emirleri (-)": Range("B9").FormulaR1C1 = " 4.Cheques Given and Payment Orders(-)": Range("C9").FormulaR1C1 = "1020": Range("D9").FormulaR1C1 = "5126"
Range("A10").FormulaR1C1 = " 5.Diğer Hazır Değerler": Range("B10").FormulaR1C1 = " 5.Other Liguid Assets": Range("C10").FormulaR1C1 = "4568": Range("D10").FormulaR1C1 = "5713"
Range("A11").FormulaR1C1 = " B. Menkul Kıymetler ": Range("B11").FormulaR1C1 = " B. Marketable Securities ": Range("C11").FormulaR1C1 = "=SUM(R[1]C:R[5]C)-R[5]C": Range("D11").FormulaR1C1 = "=SUM(R[1]C:R[5]C)-R[5]C"
Range("A12").FormulaR1C1 = " 1.Hisse Senetleri": Range("B12").FormulaR1C1 = " 1.Common Stocks": Range("C12").FormulaR1C1 = "89046": Range("D12").FormulaR1C1 = "48065"
Range("A13").FormulaR1C1 = " 2.Özel Kesim Tahvil, Senet, Bonoları": Range("B13").FormulaR1C1 = " 2.Private Sector Bonds, Notes and Shares": Range("C13").FormulaR1C1 = "23197": Range("D13").FormulaR1C1 = "84978"
Range("A14").FormulaR1C1 = " 3.Kamu Kesim Tahvil,Senet, Bonoları": Range("B14").FormulaR1C1 = " 3.Public Sector Bonds, Notes And Shares": Range("C14").FormulaR1C1 = "6855": Range("D14").FormulaR1C1 = "13313"
Range("A15").FormulaR1C1 = " 4.Diğer Menkul Kıymetler": Range("B15").FormulaR1C1 = " 4.Other Marketable Securities": Range("C15").FormulaR1C1 = "96423": Range("D15").FormulaR1C1 = "83391"
Range("A16").FormulaR1C1 = " 5.Menkul Kıymet Değer Düşüklüğü Karşılığı (-)": Range("B16").FormulaR1C1 = " 5.Provision for Decrease in Value of Marketable Sec.(-)": Range("C16").FormulaR1C1 = "2343": Range("D16").FormulaR1C1 = "9666"
Range("A17").FormulaR1C1 = " C.Ticari Alacaklar ": Range("B17").FormulaR1C1 = " C.Trade Receivables ": Range("C17").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C+R[6]C+R[7]C)-(R[8]C+R[3]C)": Range("D17").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C+R[6]C+R[7]C)-(R[8]C+R[3]C)"
Range("A18").FormulaR1C1 = " 1.Alıcılar": Range("B18").FormulaR1C1 = " 1.Customers": Range("C18").FormulaR1C1 = "62611": Range("D18").FormulaR1C1 = "97071"
Range("A19").FormulaR1C1 = " 2.AlacakSenetleri": Range("B19").FormulaR1C1 = " 2.Notes Receivable": Range("C19").FormulaR1C1 = "42073": Range("D19").FormulaR1C1 = "5669"
Range("A20").FormulaR1C1 = " 3.Alacak Senetleri Reeskontu (-)": Range("B20").FormulaR1C1 = " 3.Rediscount on Notes Receivables (-)": Range("C20").FormulaR1C1 = "87825": Range("D20").FormulaR1C1 = "16277"
Range("A21").FormulaR1C1 = " 4.Kazanılmamış Finansal Kiralama Faiz Gelirleri (-)": Range("B21").FormulaR1C1 = " 4.Unearned Lease Interest Income (-)": Range("C21").FormulaR1C1 = "4910": Range("D21").FormulaR1C1 = "1796"
Range("A22").FormulaR1C1 = " 5.Verilen Depozito ve Teminatlar": Range("B22").FormulaR1C1 = " 5.Deposıts and Guarantees Given": Range("C22").FormulaR1C1 = "36532": Range("D22").FormulaR1C1 = "52895"
Range("A23").FormulaR1C1 = " 6.Diğer Ticari Alacaklar": Range("B23").FormulaR1C1 = " 6.Other Trade Receivables": Range("C23").FormulaR1C1 = "91839": Range("D23").FormulaR1C1 = "54663"
Range("A24").FormulaR1C1 = " 7.Şüpheli Ticari Alacaklar": Range("B24").FormulaR1C1 = " 7.Doubtful Trade Receıvables": Range("C24").FormulaR1C1 = "95970": Range("D24").FormulaR1C1 = "76462"
Range("A25").FormulaR1C1 = " 8.Şüpheli Ticari Alacak Karşılığı (-)": Range("B25").FormulaR1C1 = " 8.Provisions for Doubtful Trade Receivables (-)": Range("C25").FormulaR1C1 = "497": Range("D25").FormulaR1C1 = "608"
Range("A26").FormulaR1C1 = " D.Diğer Alacaklar ": Range("B26").FormulaR1C1 = " D.Other Receivables ": Range("C26").FormulaR1C1 = "=SUM(R[1]C:R[8]C)-(R[6]C+R[8]C)": Range("D26").FormulaR1C1 = "=SUM(R[1]C:R[8]C)-(R[6]C+R[8]C)"
Range("A27").FormulaR1C1 = " 1.Ortaklardan Alacaklar": Range("B27").FormulaR1C1 = " 1.Due from Shareholders": Range("C27").FormulaR1C1 = "4558": Range("D27").FormulaR1C1 = "3860"
Range("A28").FormulaR1C1 = " 2.İştiraklerden Alacaklar": Range("B28").FormulaR1C1 = " 2.Due from Participations": Range("C28").FormulaR1C1 = "36318": Range("D28").FormulaR1C1 = "41599"
Range("A29").FormulaR1C1 = " 3.Bağlı Ortaklıklardan Alacaklar": Range("B29").FormulaR1C1 = " 3.Due from Subsidiaries": Range("C29").FormulaR1C1 = "36542": Range("D29").FormulaR1C1 = "63108"
Range("A30").FormulaR1C1 = " 4.Personelden Alacaklar": Range("B30").FormulaR1C1 = " 4.Due from Personnel": Range("C30").FormulaR1C1 = "17974": Range("D30").FormulaR1C1 = "43434"
Range("A31").FormulaR1C1 = " 5.Diğer Çeşitli Alacaklar": Range("B31").FormulaR1C1 = " 5.Other Receivables": Range("C31").FormulaR1C1 = "15630": Range("D31").FormulaR1C1 = "97059"
Range("A32").FormulaR1C1 = " 6.Diğer Alacak Senetleri Reeskontu (-)": Range("B32").FormulaR1C1 = " 6.Discounts on Notes Receivables(-)": Range("C32").FormulaR1C1 = "7474": Range("D32").FormulaR1C1 = "5877"
Range("A33").FormulaR1C1 = " 7.Şüpheli Diğer Alacaklar": Range("B33").FormulaR1C1 = " 7.Other Doubtful Receıvables": Range("C33").FormulaR1C1 = "80476": Range("D33").FormulaR1C1 = "71002"
Range("A34").FormulaR1C1 = " 8.Şüpheli Diğer Alacaklar Karşılığı (-)": Range("B34").FormulaR1C1 = " 8.Provision for Other Doubtful Receivables(-)": Range("C34").FormulaR1C1 = "5200": Range("D34").FormulaR1C1 = "9029"
Range("A35").FormulaR1C1 = " E.Stoklar ": Range("B35").FormulaR1C1 = " E.Inventories ": Range("C35").FormulaR1C1 = "=SUM(R[1]C:R[6]C)-R[6]C": Range("D35").FormulaR1C1 = "=SUM(R[1]C:R[6]C)-R[6]C"
Range("A36").FormulaR1C1 = " 1.İlk Madde ve Malzeme": Range("B36").FormulaR1C1 = " 1.Raw Materials and Supplies": Range("C36").FormulaR1C1 = "27102": Range("D36").FormulaR1C1 = "46297"
Range("A37").FormulaR1C1 = " 2.Yarı Mamuller": Range("B37").FormulaR1C1 = " 2.Semi-finished Goods in Production": Range("C37").FormulaR1C1 = "91295": Range("D37").FormulaR1C1 = "92307"
Range("A38").FormulaR1C1 = " 3.Mamuller": Range("B38").FormulaR1C1 = " 3.Finished Goods": Range("C38").FormulaR1C1 = "50007": Range("D38").FormulaR1C1 = "88448"
Range("A39").FormulaR1C1 = " 4.Ticari Mallar": Range("B39").FormulaR1C1 = " 4.Trade Goods": Range("C39").FormulaR1C1 = "57250": Range("D39").FormulaR1C1 = "42220"
Range("A40").FormulaR1C1 = " 5.Diğer Stoklar": Range("B40").FormulaR1C1 = " 5.Other Inventories": Range("C40").FormulaR1C1 = "81933": Range("D40").FormulaR1C1 = "72675"
Range("A41").FormulaR1C1 = " 6.Stok Değer Düşüklüğü Karşılığı (-)": Range("B41").FormulaR1C1 = " 6.Provision for Inventories (-)": Range("C41").FormulaR1C1 = "9554": Range("D41").FormulaR1C1 = "5352"
Range("A42").FormulaR1C1 = " 7.Verilen Sipariş Avansları": Range("B42").FormulaR1C1 = " 7.Advances Given to Suppliers": Range("C42").FormulaR1C1 = "77403": Range("D42").FormulaR1C1 = "66661"
Range("A43").FormulaR1C1 = " F.Yıllara Yaygın İnşaat Maliyetleri ": Range("B43").FormulaR1C1 = " F.Contract Progress Cost ": Range("C43").FormulaR1C1 = "=SUM(R[1]C:R[3]C)": Range("D43").FormulaR1C1 = "=SUM(R[1]C:R[3]C)"
Range("A44").FormulaR1C1 = " 1.Yıllara Yaygın İnşaat ve Onarım Maliyetleri": Range("B44").FormulaR1C1 = " 1.Contract Progress Costs": Range("C44").FormulaR1C1 = "77756": Range("D44").FormulaR1C1 = "77637"
Range("A45").FormulaR1C1 = " 2.Yıllara Yaygın İnşaat Enflasyon Düzeltme Hesabı": Range("B45").FormulaR1C1 = " 2.Contract Progress Inflation": Range("C45").FormulaR1C1 = "7372": Range("D45").FormulaR1C1 = "3782"
Range("A46").FormulaR1C1 = " 3.Taşeronlara Verilen Avanslar": Range("B46").FormulaR1C1 = " 3.Advances Given to Sub-Contractors": Range("C46").FormulaR1C1 = "56460": Range("D46").FormulaR1C1 = "16451"
Range("A47").FormulaR1C1 = " G.Gelecek Aylara Ait Giderler ve Gelir Tahakkukları ": Range("B47").FormulaR1C1 = " G.Prepaid Expenses and Income Accruals for the Following Months ": Range("C47").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D47").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A48").FormulaR1C1 = " 1.Gelecek Aylara Ait Giderler": Range("B48").FormulaR1C1 = " 1.Prepaid Expense for The Following Months": Range("C48").FormulaR1C1 = "89425": Range("D48").FormulaR1C1 = "86623"
Range("A49").FormulaR1C1 = " 2.Gelir Tahakkukları": Range("B49").FormulaR1C1 = " 2.Income Accruals": Range("C49").FormulaR1C1 = "38432": Range("D49").FormulaR1C1 = "96550"
Range("A50").FormulaR1C1 = " H.Diğer Dönen Varlıklar ": Range("B50").FormulaR1C1 = " H.Other Current Assets ": Range("C50").FormulaR1C1 = "=SUM(R[1]C:R[9]C)-R[9]C": Range("D50").FormulaR1C1 = "=SUM(R[1]C:R[9]C)-R[9]C"
Range("A51").FormulaR1C1 = " 1.Devreden KDV": Range("B51").FormulaR1C1 = " 1.Deferred VAT": Range("C51").FormulaR1C1 = "44685": Range("D51").FormulaR1C1 = "77914"
Range("A52").FormulaR1C1 = " 2.İndirilecek KDV": Range("B52").FormulaR1C1 = " 2.Deductible VAT": Range("C52").FormulaR1C1 = "30857": Range("D52").FormulaR1C1 = "7885"
Range("A53").FormulaR1C1 = " 3.Diğer KDV": Range("B53").FormulaR1C1 = " 3.Other VAT": Range("C53").FormulaR1C1 = "87977": Range("D53").FormulaR1C1 = "57924"
Range("A54").FormulaR1C1 = " 4.Peşin Ödenen Vergi ve Fonlar": Range("B54").FormulaR1C1 = " 4.Prepaid Tax and Funds": Range("C54").FormulaR1C1 = "86162": Range("D54").FormulaR1C1 = "80959"
Range("A55").FormulaR1C1 = " 5.İş Avansları": Range("B55").FormulaR1C1 = " 5.Work Advance": Range("C55").FormulaR1C1 = "76787": Range("D55").FormulaR1C1 = "92398"
Range("A56").FormulaR1C1 = " 6.Personel Avansları": Range("B56").FormulaR1C1 = " 6.Advance Given To Personnel": Range("C56").FormulaR1C1 = "5029": Range("D56").FormulaR1C1 = "82487"
Range("A57").FormulaR1C1 = " 7.Sayım Tesellüm Noksanları": Range("B57").FormulaR1C1 = " 7.Stock Count and Delivery Shortages": Range("C57").FormulaR1C1 = "22814": Range("D57").FormulaR1C1 = "27485"
Range("A58").FormulaR1C1 = " 8.Diğer Çeşitli Dönen Varlıklar": Range("B58").FormulaR1C1 = " 8.Other Current Assets": Range("C58").FormulaR1C1 = "5263": Range("D58").FormulaR1C1 = "90306"
Range("A59").FormulaR1C1 = " 9.Diğer Dönen Varlıklar Karşılığı (-)": Range("B59").FormulaR1C1 = " 9.Provision for Other Current Assets (-)": Range("C59").FormulaR1C1 = "8795": Range("D59").FormulaR1C1 = "6227"
Range("A60").FormulaR1C1 = "II.DURAN VARLIKLAR ": Range("B60").FormulaR1C1 = "II.LONG TERM ASSETS ": Range("C60").FormulaR1C1 = "=SUM(R[1]C+R[8]C+R[16]C+R[27]C+R[38]C+R[47]C+R[53]C+R[56]C)": Range("D60").FormulaR1C1 = "=SUM(R[1]C+R[8]C+R[16]C+R[27]C+R[38]C+R[47]C+R[53]C+R[56]C)"
Range("A61").FormulaR1C1 = " A.Ticari Alacaklar ": Range("B61").FormulaR1C1 = " A.Trade Receivables ": Range("C61").FormulaR1C1 = "=SUM(R[1]C:R[5]C)-R[6]C": Range("D61").FormulaR1C1 = "=SUM(R[1]C:R[5]C)-R[6]C"
Range("A62").FormulaR1C1 = " 1.Alıcılar": Range("B62").FormulaR1C1 = " 1.Customers": Range("C62").FormulaR1C1 = "12940": Range("D62").FormulaR1C1 = "60488"
Range("A63").FormulaR1C1 = " 2.Alacak Senetleri": Range("B63").FormulaR1C1 = " 2.Notes Receivable": Range("C63").FormulaR1C1 = "58610": Range("D63").FormulaR1C1 = "85698"
Range("A64").FormulaR1C1 = " 3.Alacak Senetleri Reeskontu (-)": Range("B64").FormulaR1C1 = " 3.Rediscount on Notes Receivables (-)": Range("C64").FormulaR1C1 = "8823": Range("D64").FormulaR1C1 = "2031"
Range("A65").FormulaR1C1 = " 4.Kazanılmamış Finansal Kiralama Faiz Gelirleri (-)": Range("B65").FormulaR1C1 = " 4.Unearned Lease Interest Income (-)": Range("C65").FormulaR1C1 = "3404": Range("D65").FormulaR1C1 = "6048"
Range("A66").FormulaR1C1 = " 5.Verilen Depozito ve Teminatlar": Range("B66").FormulaR1C1 = " 5.Deposıts and Guarantees Given": Range("C66").FormulaR1C1 = "28578": Range("D66").FormulaR1C1 = "83351"
Range("A67").FormulaR1C1 = " 6.Şüpheli Alacaklar Karşılığı (-)": Range("B67").FormulaR1C1 = " 6.Provison for Doubtful Receivables": Range("C67").FormulaR1C1 = "30695": Range("D67").FormulaR1C1 = "97422"
Range("A68").FormulaR1C1 = " B. Diğer Alacaklar ": Range("B68").FormulaR1C1 = " B. Other Receivables ": Range("C68").FormulaR1C1 = "=SUM(R[1]C:R[7]C)-(R[6]C+R[7]C)": Range("D68").FormulaR1C1 = "=SUM(R[1]C:R[7]C)-(R[6]C+R[7]C)"
Range("A69").FormulaR1C1 = " 1.Ortaklardan Alacaklar": Range("B69").FormulaR1C1 = " 1.Due from Shareholders": Range("C69").FormulaR1C1 = "80582": Range("D69").FormulaR1C1 = "60773"
Range("A70").FormulaR1C1 = " 2.İştiraklerden Alacaklar": Range("B70").FormulaR1C1 = " 2.Due from Affiliates": Range("C70").FormulaR1C1 = "35623": Range("D70").FormulaR1C1 = "58553"
Range("A71").FormulaR1C1 = " 3.Bağlı Ortaklıklardan Alacaklar": Range("B71").FormulaR1C1 = " 3.Due from Subsidiaries": Range("C71").FormulaR1C1 = "66074": Range("D71").FormulaR1C1 = "58324"
Range("A72").FormulaR1C1 = " 4.Personelden Alacaklar": Range("B72").FormulaR1C1 = " 4.Receivables From Personnel": Range("C72").FormulaR1C1 = "5885": Range("D72").FormulaR1C1 = "84022"
Range("A73").FormulaR1C1 = " 5.Diğer Çeşitli Alacaklar": Range("B73").FormulaR1C1 = " 5.Other Receivables": Range("C73").FormulaR1C1 = "5904": Range("D73").FormulaR1C1 = "15130"
Range("A74").FormulaR1C1 = " 6.Diğer Alacak Senetleri Reeskontu (-)": Range("B74").FormulaR1C1 = " 6.Rediscount on Other Notes Receivable (-)": Range("C74").FormulaR1C1 = "1586": Range("D74").FormulaR1C1 = "3565"
Range("A75").FormulaR1C1 = " 7.Şüpheli Diğer Alacaklar Karşılığı (-)": Range("B75").FormulaR1C1 = " 7.Provision for Other Doubtful Receivables(-)": Range("C75").FormulaR1C1 = "2337": Range("D75").FormulaR1C1 = "5640"
Range("A76").FormulaR1C1 = " C.Mali Duran Varlıklar ": Range("B76").FormulaR1C1 = " C.Financial Non-Current Assets ": Range("C76").FormulaR1C1 = "=SUM(R[1]C:R[10]C)": Range("D76").FormulaR1C1 = "=SUM(R[1]C:R[10]C)"
Range("A77").FormulaR1C1 = " 1.Bağlı Menkul Kıymetler": Range("B77").FormulaR1C1 = " 1.Long Term Securities": Range("C77").FormulaR1C1 = "23988": Range("D77").FormulaR1C1 = "5261"
Range("A78").FormulaR1C1 = " 2.Bağlı Menkul Kıymetler Değer Düşüklüğü Karşılığı (-)": Range("B78").FormulaR1C1 = " 2.Decrease in Value of Long Term Marketable Securities (-)": Range("C78").FormulaR1C1 = "8038": Range("D78").FormulaR1C1 = "8670"
Range("A79").FormulaR1C1 = " 3.İştirakler": Range("B79").FormulaR1C1 = " 3.Participations": Range("C79").FormulaR1C1 = "13633": Range("D79").FormulaR1C1 = "66919"
Range("A80").FormulaR1C1 = " 4.İştiraklere Sermaye Taahhütleri (-)": Range("B80").FormulaR1C1 = " 4.Capital Commitments for Participations (-)": Range("C80").FormulaR1C1 = "6292": Range("D80").FormulaR1C1 = "7225"
Range("A81").FormulaR1C1 = " 5.İştirakler Sermaye Payları Değer Düşüklüğü Karşılığı (-)": Range("B81").FormulaR1C1 = " 5.Decrease in Value of Participations' Shares (-)": Range("C81").FormulaR1C1 = "1017": Range("D81").FormulaR1C1 = "2621"
Range("A82").FormulaR1C1 = " 6.Bağlı Ortaklıklar": Range("B82").FormulaR1C1 = " 6.Subsidiaries": Range("C82").FormulaR1C1 = "50615": Range("D82").FormulaR1C1 = "61964"
Range("A83").FormulaR1C1 = " 7.Bağlı Ortaklık Sermaye Taahhütleri (-)": Range("B83").FormulaR1C1 = " 7.Capital Commitments for Subsidiaries (-)": Range("C83").FormulaR1C1 = "1675": Range("D83").FormulaR1C1 = "2021"
Range("A84").FormulaR1C1 = " 8.Bağlı Ortaklıklar Sermaye Payları Değer Düşüklüğü Krş. (-)": Range("B84").FormulaR1C1 = " 8.Decrease in Value of Subsidiaries Shares (-)": Range("C84").FormulaR1C1 = "4299": Range("D84").FormulaR1C1 = "8262"
Range("A85").FormulaR1C1 = " 9.Diğer Mali Duran Varlıklar ": Range("B85").FormulaR1C1 = " 9.Other Financial Assets": Range("C85").FormulaR1C1 = "34735": Range("D85").FormulaR1C1 = "3979"
Range("A86").FormulaR1C1 = " 10.Diğer Mali Duran Varlıklar Değer Düşüklüğü Krş. (-)": Range("B86").FormulaR1C1 = " 10.Decrease in Value of Other Financial Assets (-)": Range("C86").FormulaR1C1 = "9014": Range("D86").FormulaR1C1 = "9355"
Range("A87").FormulaR1C1 = " D.Maddi Duran Varlıklar ": Range("B87").FormulaR1C1 = " D.Tangible Fix Assets ": Range("C87").FormulaR1C1 = "=(R[1]C+R[2]C+R[3]C+R[4]C+R[5]C+R[6]C+R[7]C+R[9]C)-R[8]C": Range("D87").FormulaR1C1 = "=(R[1]C+R[2]C+R[3]C+R[4]C+R[5]C+R[6]C+R[7]C+R[9]C)-R[8]C"
Range("A88").FormulaR1C1 = " 1.Arazi ve Arsalar": Range("B88").FormulaR1C1 = " 1.Land": Range("C88").FormulaR1C1 = "25124": Range("D88").FormulaR1C1 = "55406"
Range("A89").FormulaR1C1 = " 2.Yeraltı ve Yerüstü Düzenleri ": Range("B89").FormulaR1C1 = " 2.Land Improvements": Range("C89").FormulaR1C1 = "4447": Range("D89").FormulaR1C1 = "81413"
Range("A90").FormulaR1C1 = " 3.Binalar": Range("B90").FormulaR1C1 = " 3.Buildings": Range("C90").FormulaR1C1 = "46995": Range("D90").FormulaR1C1 = "54564"
Range("A91").FormulaR1C1 = " 4.Tesis, Makina ve Cihazlar": Range("B91").FormulaR1C1 = " 4.Machinery,Equipment and Installatıons ": Range("C91").FormulaR1C1 = "37661": Range("D91").FormulaR1C1 = "14707"
Range("A92").FormulaR1C1 = " 5.Taşıtlar": Range("B92").FormulaR1C1 = " 5.Motor Vehıcles": Range("C92").FormulaR1C1 = "73309": Range("D92").FormulaR1C1 = "22032"
Range("A93").FormulaR1C1 = " 6.Demirbaşlar": Range("B93").FormulaR1C1 = " 6.Furniture and Fixtures": Range("C93").FormulaR1C1 = "21024": Range("D93").FormulaR1C1 = "32317"
Range("A94").FormulaR1C1 = " 7.Diğer Maddi Duran Varlıklar": Range("B94").FormulaR1C1 = " 7.Other Tangible Fix Assets": Range("C94").FormulaR1C1 = "42379": Range("D94").FormulaR1C1 = "74124"
Range("A95").FormulaR1C1 = " 8.Birikmiş Amortismanlar (-)": Range("B95").FormulaR1C1 = " 8.Accumulated Depreciation(-)": Range("C95").FormulaR1C1 = "11844": Range("D95").FormulaR1C1 = "23575"
Range("A96").FormulaR1C1 = " 9.Yapılmakta Olan Yatırımlar": Range("B96").FormulaR1C1 = " 9.Construction in Progress": Range("C96").FormulaR1C1 = "82458": Range("D96").FormulaR1C1 = "57330"
Range("A97").FormulaR1C1 = " 10.Verilen Avanslar": Range("B97").FormulaR1C1 = " 10.Fix Assets Advances Given": Range("C97").FormulaR1C1 = "76897": Range("D97").FormulaR1C1 = "29395"
Range("A98").FormulaR1C1 = " E.Maddi Olmayan Duran Varlıklar ": Range("B98").FormulaR1C1 = " E.Intangible Assets ": Range("C98").FormulaR1C1 = "=(R[1]C+R[2]C+R[3]C+R[4]C+R[5]C+R[6]C+R[8]C)-R[7]C": Range("D98").FormulaR1C1 = "=(R[1]C+R[2]C+R[3]C+R[4]C+R[5]C+R[6]C+R[8]C)-R[7]C"
Range("A99").FormulaR1C1 = " 1.Haklar": Range("B99").FormulaR1C1 = " 1.Rights": Range("C99").FormulaR1C1 = "50249": Range("D99").FormulaR1C1 = "68837"
Range("A100").FormulaR1C1 = " 2.Şerefiyeler": Range("B100").FormulaR1C1 = " 2.Goodwill": Range("C100").FormulaR1C1 = "35236": Range("D100").FormulaR1C1 = "63302"
Range("A101").FormulaR1C1 = " 3.Kuruluş ve Örgütlenme Giderleri": Range("B101").FormulaR1C1 = " 3.Pre-operating Expenses": Range("C101").FormulaR1C1 = "16060": Range("D101").FormulaR1C1 = "90666"
Range("A102").FormulaR1C1 = " 4.Araştırma ve Geliştirme Giderleri": Range("B102").FormulaR1C1 = " 4.Research and Development Expenses": Range("C102").FormulaR1C1 = "36961": Range("D102").FormulaR1C1 = "81491"
Range("A103").FormulaR1C1 = " 5.Özel Maliyetler": Range("B103").FormulaR1C1 = " 5.Special Cost": Range("C103").FormulaR1C1 = "16403": Range("D103").FormulaR1C1 = "49917"
Range("A104").FormulaR1C1 = " 6.Diğer Maddi Olmayan Duran Varlıklar": Range("B104").FormulaR1C1 = " 6.Other Intangible Fixed Assets": Range("C104").FormulaR1C1 = "3372": Range("D104").FormulaR1C1 = "74763"
Range("A105").FormulaR1C1 = " 7.Birikmiş Amortismanlar (-)": Range("B105").FormulaR1C1 = " 7.Accumulated Amortization(-)": Range("C105").FormulaR1C1 = "84070": Range("D105").FormulaR1C1 = "109458"
Range("A106").FormulaR1C1 = " 8.Verilen Avanslar": Range("B106").FormulaR1C1 = " 8.Advances Given to Suppliers": Range("C106").FormulaR1C1 = "42116": Range("D106").FormulaR1C1 = "51427"
Range("A107").FormulaR1C1 = " F.Özel Tükenmeye Tabi Varlıklar ": Range("B107").FormulaR1C1 = " F.Assets Subject to Depletion ": Range("C107").FormulaR1C1 = "=SUM(R[1]C:R[5]C)-R[4]C": Range("D107").FormulaR1C1 = "=SUM(R[1]C:R[5]C)-R[4]C"
Range("A108").FormulaR1C1 = " 1.Arama Giderleri": Range("B108").FormulaR1C1 = " 1.Research Expenses": Range("C108").FormulaR1C1 = "97657": Range("D108").FormulaR1C1 = "9340"
Range("A109").FormulaR1C1 = " 2.Hazırlık ve Geliştirme Giderleri": Range("B109").FormulaR1C1 = " 2.Preperation and Development Expenses": Range("C109").FormulaR1C1 = "78046": Range("D109").FormulaR1C1 = "4416"
Range("A110").FormulaR1C1 = " 3.Diğer Özel Tükenmeye Tabi Varlıklar ": Range("B110").FormulaR1C1 = " 3.Other Depletable Assets": Range("C110").FormulaR1C1 = "96589": Range("D110").FormulaR1C1 = "99972"
Range("A111").FormulaR1C1 = " 4.Birikmiş Tükenme Payları (-)": Range("B111").FormulaR1C1 = " 4.Accumulated Depletion (-)": Range("C111").FormulaR1C1 = "68868": Range("D111").FormulaR1C1 = "78790"
Range("A112").FormulaR1C1 = " 5.Verilen Avanslar": Range("B112").FormulaR1C1 = " 5.Advances Given": Range("C112").FormulaR1C1 = "17945": Range("D112").FormulaR1C1 = "17471"
Range("A113").FormulaR1C1 = " G.Gelecek Yıllar Gider/Gelir Tahakkukları ": Range("B113").FormulaR1C1 = " G.Prepaid Expenses and Income Accruals for the Following Years ": Range("C113").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D113").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A114").FormulaR1C1 = " 1.Gelecek Yıllara Ait Giderler": Range("B114").FormulaR1C1 = " 1.Prepaid Expenses for the Following Years": Range("C114").FormulaR1C1 = "88514": Range("D114").FormulaR1C1 = "12722"
Range("A115").FormulaR1C1 = " 2.Gelir Tahakkukları": Range("B115").FormulaR1C1 = " 2.Income Accruals": Range("C115").FormulaR1C1 = "15044": Range("D115").FormulaR1C1 = "26993"
Range("A116").FormulaR1C1 = " H.Diğer Duran Varlıklar ": Range("B116").FormulaR1C1 = " H.Other Non-Current Assets ": Range("C116").FormulaR1C1 = "=SUM(R[1]C:R[8]C)": Range("D116").FormulaR1C1 = "=SUM(R[1]C:R[8]C)"
Range("A117").FormulaR1C1 = " 1.Gelecek Yıllarda İndirilecek KDV": Range("B117").FormulaR1C1 = " 1.VAT Deductible for the Following Years": Range("C117").FormulaR1C1 = "90184": Range("D117").FormulaR1C1 = "23959"
Range("A118").FormulaR1C1 = " 2.Diğer KDV": Range("B118").FormulaR1C1 = " 2.Other VAT": Range("C118").FormulaR1C1 = "70089": Range("D118").FormulaR1C1 = "83084"
Range("A119").FormulaR1C1 = " 3.Gelecek Yıllar İhtiyacı Stoklar": Range("B119").FormulaR1C1 = " 3.Long Term Stocks": Range("C119").FormulaR1C1 = "8693": Range("D119").FormulaR1C1 = "81834"
Range("A120").FormulaR1C1 = " 4.Elden Çıkarılacak Stoklar ve Maddi Duran Varlıklar": Range("B120").FormulaR1C1 = " 4.Inventories and Tangible Fixed Assets to be Sold ": Range("C120").FormulaR1C1 = "81254": Range("D120").FormulaR1C1 = "20219"
Range("A121").FormulaR1C1 = " 5.Peşin Ödenen Vergiler ve Fonlar": Range("B121").FormulaR1C1 = " 5.Prepaid Expenses and Funds": Range("C121").FormulaR1C1 = "10397": Range("D121").FormulaR1C1 = "62392"
Range("A122").FormulaR1C1 = " 6.Diğer Çeşitli Duran Varlıklar": Range("B122").FormulaR1C1 = " 6.Other Fixed Assets": Range("C122").FormulaR1C1 = "7574": Range("D122").FormulaR1C1 = "62279"
Range("A123").FormulaR1C1 = " 7.Stok Değer Düşüklüğü Karşılığı (-)": Range("B123").FormulaR1C1 = " 7.Decrease in Value of Stocks (-)": Range("C123").FormulaR1C1 = "6156": Range("D123").FormulaR1C1 = "9300"
Range("A124").FormulaR1C1 = " 8.Birikmiş Amortismanlar (-)": Range("B124").FormulaR1C1 = " 8.Accumulated Depreciation (-)": Range("C124").FormulaR1C1 = "9295": Range("D124").FormulaR1C1 = "9777"
Range("A125").FormulaR1C1 = "AKTİF (VARLIKLAR) TOPLAMI ": Range("B125").FormulaR1C1 = "TOTAL ASSETS ": Range("C125").FormulaR1C1 = "=R[-65]C+R[-121]C": Range("D125").FormulaR1C1 = "=R[-65]C+R[-121]C"
Range("A126").FormulaR1C1 = "I.KISA VADELİ YABANCI KAYNAKLAR ": Range("B126").FormulaR1C1 = "I.SHORT-TERM LIABILITIES ": Range("C126").FormulaR1C1 = "=SUM(R[1]C+R[11]C+R[17]C+R[24]C+R[27]C+R[30]C+R[35]C+R[40]C+R[43]C)": Range("D126").FormulaR1C1 = "=SUM(R[1]C+R[11]C+R[17]C+R[24]C+R[27]C+R[30]C+R[35]C+R[40]C+R[43]C)"
Range("A127").FormulaR1C1 = " A.Mali Borçlar ": Range("B127").FormulaR1C1 = " A.Financial Liabilities ": Range("C127").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C+R[6]C+R[7]C+R[9]C)-(R[3]C+R[8]C)": Range("D127").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C+R[6]C+R[7]C+R[9]C)-(R[3]C+R[8]C)"
Range("A128").FormulaR1C1 = " 1.Banka Kredileri": Range("B128").FormulaR1C1 = " 1.Bank Loans": Range("C128").FormulaR1C1 = "73378": Range("D128").FormulaR1C1 = "42773"
Range("A129").FormulaR1C1 = " 2.Finansal Kiralama İşlemlerinden Borçlar": Range("B129").FormulaR1C1 = " 2.Leasing Payables": Range("C129").FormulaR1C1 = "45958": Range("D129").FormulaR1C1 = "46043"
Range("A130").FormulaR1C1 = " 3.Ertelenmiş Finansal Kiralama Borçlanma Maliyetleri (-)": Range("B130").FormulaR1C1 = " 3.Interest Payables of Deferred Lease Costs (-)": Range("C130").FormulaR1C1 = "85625": Range("D130").FormulaR1C1 = "41115"
Range("A131").FormulaR1C1 = " 4.Uzun Vadeli Kredilerin Ana Para,Taksitleri ve Faizleri": Range("B131").FormulaR1C1 = " 4.Current Maturities of Long Term Credits and Accrued Interest": Range("C131").FormulaR1C1 = "70683": Range("D131").FormulaR1C1 = "37615"
Range("A132").FormulaR1C1 = " 5.Tahvil Anapara, Borç, Taksit Faizi": Range("B132").FormulaR1C1 = " 5.Current Maturities of Bonds and Accrued Interest": Range("C132").FormulaR1C1 = "38668": Range("D132").FormulaR1C1 = "23709"
Range("A133").FormulaR1C1 = " 6.Çıkarılmış Bonolar ve Senetler": Range("B133").FormulaR1C1 = " 6.Bonds and Notes Issued": Range("C133").FormulaR1C1 = "22730": Range("D133").FormulaR1C1 = "6984"
Range("A134").FormulaR1C1 = " 7.Çıkarılmış Diğer Menkul Kıymetler": Range("B134").FormulaR1C1 = " 7.Other Securities Issued": Range("C134").FormulaR1C1 = "79023": Range("D134").FormulaR1C1 = "82260"
Range("A135").FormulaR1C1 = " 8.Menkul Kıymetler İhraç Farkı (-)": Range("B135").FormulaR1C1 = " 8.Value Difference of Securities Issued (-)": Range("C135").FormulaR1C1 = "33235": Range("D135").FormulaR1C1 = "41998"
Range("A136").FormulaR1C1 = " 9.Diğer Mali Borçlar": Range("B136").FormulaR1C1 = " 9.Other Financial Liabilities": Range("C136").FormulaR1C1 = "99395": Range("D136").FormulaR1C1 = "69899"
Range("A137").FormulaR1C1 = " B.Ticari Borçlar ": Range("B137").FormulaR1C1 = " B.Trade Payables ": Range("C137").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C)-R[3]C": Range("D137").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C)-R[3]C"
Range("A138").FormulaR1C1 = " 1.Satıcılar": Range("B138").FormulaR1C1 = " 1.Suppliers": Range("C138").FormulaR1C1 = "33994": Range("D138").FormulaR1C1 = "15246"
Range("A139").FormulaR1C1 = " 2.Borç Senetleri": Range("B139").FormulaR1C1 = " 2.Notes Payable": Range("C139").FormulaR1C1 = "90577": Range("D139").FormulaR1C1 = "51077"
Range("A140").FormulaR1C1 = " 3.Borç Senetleri Reeskontu (-)": Range("B140").FormulaR1C1 = " 3.Rediscount on Notes Payables (-)": Range("C140").FormulaR1C1 = "78848": Range("D140").FormulaR1C1 = "61470"
Range("A141").FormulaR1C1 = " 4.Alınan Depozito ve Teminatlar": Range("B141").FormulaR1C1 = " 4.Deposits and Guarantees Received": Range("C141").FormulaR1C1 = "34545": Range("D141").FormulaR1C1 = "96247"
Range("A142").FormulaR1C1 = " 5.Diğer Ticari Borçlar": Range("B142").FormulaR1C1 = " 5.Other Trade Payables": Range("C142").FormulaR1C1 = "37112": Range("D142").FormulaR1C1 = "30356"
Range("A143").FormulaR1C1 = " C.Diğer Borçlar ": Range("B143").FormulaR1C1 = " C.Other Liabilities ": Range("C143").FormulaR1C1 = "=SUM(R[1]C:R[6]C)": Range("D143").FormulaR1C1 = "=SUM(R[1]C:R[6]C)"
Range("A144").FormulaR1C1 = " 1.Ortaklara Borçlar": Range("B144").FormulaR1C1 = " 1.Due to Shareholders": Range("C144").FormulaR1C1 = "89382": Range("D144").FormulaR1C1 = "11362"
Range("A145").FormulaR1C1 = " 2.İştiraklere Borçlar": Range("B145").FormulaR1C1 = " 2.Due to Affiliates": Range("C145").FormulaR1C1 = "90388": Range("D145").FormulaR1C1 = "62167"
Range("A146").FormulaR1C1 = " 3.Bağlı Ortaklıklara Borçlar": Range("B146").FormulaR1C1 = " 3.Due to Subsidiaries": Range("C146").FormulaR1C1 = "89010": Range("D146").FormulaR1C1 = "75686"
Range("A147").FormulaR1C1 = " 4.Personele Borçlar": Range("B147").FormulaR1C1 = " 4.Due to Personnel": Range("C147").FormulaR1C1 = "32791": Range("D147").FormulaR1C1 = "53827"
Range("A148").FormulaR1C1 = " 5.Diğer Çeşitli Borçlar": Range("B148").FormulaR1C1 = " 5.Other Liabilities": Range("C148").FormulaR1C1 = "82413": Range("D148").FormulaR1C1 = "15326"
Range("A149").FormulaR1C1 = " 6.Diğer Borç Senetleri Reeskontu (-)": Range("B149").FormulaR1C1 = " 6.Rediscount on Other Notes Payable (-)": Range("C149").FormulaR1C1 = "79325": Range("D149").FormulaR1C1 = "42865"
Range("A150").FormulaR1C1 = " D.Alınan Avanslar ": Range("B150").FormulaR1C1 = " D.Advances Received ": Range("C150").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D150").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A151").FormulaR1C1 = " 1.Alınan Sipariş Avansları": Range("B151").FormulaR1C1 = " 1.Advances Received": Range("C151").FormulaR1C1 = "5653": Range("D151").FormulaR1C1 = "83534"
Range("A152").FormulaR1C1 = " 2.Alınan Diğer Avanslar": Range("B152").FormulaR1C1 = " 2.Other Advances Received": Range("C152").FormulaR1C1 = "98419": Range("D152").FormulaR1C1 = "1927"
Range("A153").FormulaR1C1 = " E.Yıllara Yaygın İnşaat Hakedişleri ": Range("B153").FormulaR1C1 = " E.Contract Progress Income ": Range("C153").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D153").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A154").FormulaR1C1 = " 1.Yıllara Yaygın İnşaat ve Onarım Hakedişleri": Range("B154").FormulaR1C1 = " 1.Contract Progress Income": Range("C154").FormulaR1C1 = "12001": Range("D154").FormulaR1C1 = "38452"
Range("A155").FormulaR1C1 = " 2.Yıllara Yaygın İnşaat Enflasyon Düzeltme Hesabı": Range("B155").FormulaR1C1 = " 2.Inflation Adjustments on Contract Progress Income": Range("C155").FormulaR1C1 = "49280": Range("D155").FormulaR1C1 = "90007"
Range("A156").FormulaR1C1 = " F.Ödenecek Vergi ve Diğer Yükümlülükler ": Range("B156").FormulaR1C1 = " F.Taxes Payable and Other Liabilities ": Range("C156").FormulaR1C1 = "=SUM(R[1]C:R[4]C)": Range("D156").FormulaR1C1 = "=SUM(R[1]C:R[4]C)"
Range("A157").FormulaR1C1 = " 1.Ödenecek Vergi ve Fonlar": Range("B157").FormulaR1C1 = " 1.Taxes And Funds Payables": Range("C157").FormulaR1C1 = "65273": Range("D157").FormulaR1C1 = "22228"
Range("A158").FormulaR1C1 = " 2.Ödenecek Sosyal Güvenlik Kesintileri": Range("B158").FormulaR1C1 = " 2.Social Security Premiums Payable": Range("C158").FormulaR1C1 = "4676": Range("D158").FormulaR1C1 = "91141"
Range("A159").FormulaR1C1 = " 3.Vadesi Geçmiş Ertelenmiş veya Taks. Vergi ve Diğer Yük.": Range("B159").FormulaR1C1 = " 3.Overdue,Deferred or Restructed Taxes and Other Libilities": Range("C159").FormulaR1C1 = "49073": Range("D159").FormulaR1C1 = "67043"
Range("A160").FormulaR1C1 = " 4.Ödenecek Diğer Yükümlülükler": Range("B160").FormulaR1C1 = " 4.Other Liabilities Payable": Range("C160").FormulaR1C1 = "6583": Range("D160").FormulaR1C1 = "1361"
Range("A161").FormulaR1C1 = " G.Borç ve Gider Karşılıkları ": Range("B161").FormulaR1C1 = " G.Provisions for Liabilities and Expenses ": Range("C161").FormulaR1C1 = "=(R[1]C+R[3]C+R[4]C)-R[2]C": Range("D161").FormulaR1C1 = "=(R[1]C+R[3]C+R[4]C)-R[2]C"
Range("A162").FormulaR1C1 = " 1.Dönem Karı Vergi ve Diğer Yasal Yükümlülük Karşılığı": Range("B162").FormulaR1C1 = " 1.Prov. for Income Taxes and Oth.Legal Liabilities": Range("C162").FormulaR1C1 = "89295": Range("D162").FormulaR1C1 = "44558"
Range("A163").FormulaR1C1 = " 2.Dönem Karı Peşin Ödenen Vergi ve Diğer Yük. (-)": Range("B163").FormulaR1C1 = " 2.Prepaid Taxes and Funds on Profit for the Period": Range("C163").FormulaR1C1 = "16995": Range("D163").FormulaR1C1 = "28756"
Range("A164").FormulaR1C1 = " 3.Kıdem Tazminatı Karşılığı": Range("B164").FormulaR1C1 = " 3.Provision for Employee Termination Benefits": Range("C164").FormulaR1C1 = "75010": Range("D164").FormulaR1C1 = "85386"
Range("A165").FormulaR1C1 = " 4.Diğer Borç ve Gider Karşılıkları": Range("B165").FormulaR1C1 = " 4.Provision for Other Liabilities and Expenses": Range("C165").FormulaR1C1 = "25592": Range("D165").FormulaR1C1 = "34728"
Range("A166").FormulaR1C1 = " H.Gelecek Aylar Gelir/Gider Tahakkukları ": Range("B166").FormulaR1C1 = " H.Short Term Deferred Income and Expense Accruals ": Range("C166").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D166").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A167").FormulaR1C1 = " 1.Gelecek Aylara Ait Gelirler": Range("B167").FormulaR1C1 = " 1.Short Term Deferred Income": Range("C167").FormulaR1C1 = "41571": Range("D167").FormulaR1C1 = "59567"
Range("A168").FormulaR1C1 = " 2.Gider Tahakkukları": Range("B168").FormulaR1C1 = " 2.Expense Accruals": Range("C168").FormulaR1C1 = "18952": Range("D168").FormulaR1C1 = "94430"
Range("A169").FormulaR1C1 = " I.Diğer Kısa Vadeli Yabancı Kaynaklar ": Range("B169").FormulaR1C1 = " I.Other Short Term Liabilities ": Range("C169").FormulaR1C1 = "=SUM(R[1]C:R[4]C)": Range("D169").FormulaR1C1 = "=SUM(R[1]C:R[4]C)"
Range("A170").FormulaR1C1 = " 1.Diğer KDV": Range("B170").FormulaR1C1 = " 1.Other VAT": Range("C170").FormulaR1C1 = "32220": Range("D170").FormulaR1C1 = "60022"
Range("A171").FormulaR1C1 = " 2.Merkez ve Şubeler Cari Hesabı": Range("B171").FormulaR1C1 = " 2.Head Office and Branch Current Accounts": Range("C171").FormulaR1C1 = "37890": Range("D171").FormulaR1C1 = "64215"
Range("A172").FormulaR1C1 = " 3.Sayım ve Tesellüm Fazlaları": Range("B172").FormulaR1C1 = " 3.Stock Count Delivery Surpluses": Range("C172").FormulaR1C1 = "74199": Range("D172").FormulaR1C1 = "71120"
Range("A173").FormulaR1C1 = " 4.Diğer Çeşitli Yabancı Kaynaklar": Range("B173").FormulaR1C1 = " 4.Other Short Term Liabilities": Range("C173").FormulaR1C1 = "18486": Range("D173").FormulaR1C1 = "5754"
Range("A174").FormulaR1C1 = "II.UZUN VADELİ YABANCI KAYNAKLAR ": Range("B174").FormulaR1C1 = "II.LONG-TERM LIABILITIES ": Range("C174").FormulaR1C1 = "=SUM(R[1]C+R[9]C+R[15]C+R[22]C+R[25]C+R[28]C+R[31]C)": Range("D174").FormulaR1C1 = "=SUM(R[1]C+R[9]C+R[15]C+R[22]C+R[25]C+R[28]C+R[31]C)"
Range("A175").FormulaR1C1 = " A.Mali Borçlar ": Range("B175").FormulaR1C1 = " A.Financial Liabilities ": Range("C175").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C+R[7]C)-(R[3]C+R[6]C)": Range("D175").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C+R[7]C)-(R[3]C+R[6]C)"
Range("A176").FormulaR1C1 = " 1.Banka Kredileri": Range("B176").FormulaR1C1 = " 1.Bank Loans": Range("C176").FormulaR1C1 = "65605": Range("D176").FormulaR1C1 = "90897"
Range("A177").FormulaR1C1 = " 2.Finansal Kiralama İşlemlerinden Borçlar": Range("B177").FormulaR1C1 = " 2.Leasing Payables": Range("C177").FormulaR1C1 = "27172": Range("D177").FormulaR1C1 = "25641"
Range("A178").FormulaR1C1 = " 3.Ertelenmiş Finansal Kiralama Borçlanma Maliyetleri (-)": Range("B178").FormulaR1C1 = " 3.Deferred Lease Interest Payables (-)": Range("C178").FormulaR1C1 = "77104": Range("D178").FormulaR1C1 = "75857"
Range("A179").FormulaR1C1 = " 3.Çıkarılmış Tahviller": Range("B179").FormulaR1C1 = " 4.Bonds Issued": Range("C179").FormulaR1C1 = "38918": Range("D179").FormulaR1C1 = "15525"
Range("A180").FormulaR1C1 = " 4.Çıkarılmış Diğer Menkul Kıymetler": Range("B180").FormulaR1C1 = " 5.Other Marketable Securities Issued": Range("C180").FormulaR1C1 = "57085": Range("D180").FormulaR1C1 = "12012"
Range("A181").FormulaR1C1 = " 5.Menkul Kıymetler İhraç Farkı (-)": Range("B181").FormulaR1C1 = " 6.Value Differences of Securities Inssued (-)": Range("C181").FormulaR1C1 = "27157": Range("D181").FormulaR1C1 = "85697"
Range("A182").FormulaR1C1 = " 6.Diğer Mali Borçlar": Range("B182").FormulaR1C1 = " 7.Other Financial Liabilities": Range("C182").FormulaR1C1 = "66907": Range("D182").FormulaR1C1 = "46537"
Range("A183").FormulaR1C1 = " B.Ticari Borçlar ": Range("B183").FormulaR1C1 = " B.Trade Payables ": Range("C183").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C)-R[3]C": Range("D183").FormulaR1C1 = "=(R[1]C+R[2]C+R[4]C+R[5]C)-R[3]C"
Range("A184").FormulaR1C1 = " 1.Satıcılar": Range("B184").FormulaR1C1 = " 1.Suppliers": Range("C184").FormulaR1C1 = "1619": Range("D184").FormulaR1C1 = "25530"
Range("A185").FormulaR1C1 = " 2.Borç Senetleri": Range("B185").FormulaR1C1 = " 2.Notes Payable": Range("C185").FormulaR1C1 = "95246": Range("D185").FormulaR1C1 = "5502"
Range("A186").FormulaR1C1 = " 3.Borç Senetleri Reeskontu (-)": Range("B186").FormulaR1C1 = " 3.Rediscount on Notes Payable(-)": Range("C186").FormulaR1C1 = "85276": Range("D186").FormulaR1C1 = "8081"
Range("A187").FormulaR1C1 = " 4.Alınan Depozito ve Teminatlar": Range("B187").FormulaR1C1 = " 4.Deposits and Guarentees Taken": Range("C187").FormulaR1C1 = "72033": Range("D187").FormulaR1C1 = "26826"
Range("A188").FormulaR1C1 = " 5.Diğer Ticari Borçlar": Range("B188").FormulaR1C1 = " 5.Other Trade Payables": Range("C188").FormulaR1C1 = "91247": Range("D188").FormulaR1C1 = "5328"
Range("A189").FormulaR1C1 = " C.Diğer Borçlar ": Range("B189").FormulaR1C1 = " C.Other Long-Term Liabilities ": Range("C189").FormulaR1C1 = "=SUM(R[1]C:R[6]C)": Range("D189").FormulaR1C1 = "=SUM(R[1]C:R[6]C)"
Range("A190").FormulaR1C1 = " 1.Ortaklara Borçlar": Range("B190").FormulaR1C1 = " 1.Due to Shareholders": Range("C190").FormulaR1C1 = "87533": Range("D190").FormulaR1C1 = "44523"
Range("A191").FormulaR1C1 = " 2.İştiraklere Borçlar": Range("B191").FormulaR1C1 = " 2.Due to Participations": Range("C191").FormulaR1C1 = "83068": Range("D191").FormulaR1C1 = "82635"
Range("A192").FormulaR1C1 = " 3.Bağlı Ortaklıklara Borçlar": Range("B192").FormulaR1C1 = " 3.Due to Subsidiaries": Range("C192").FormulaR1C1 = "7073": Range("D192").FormulaR1C1 = "58094"
Range("A193").FormulaR1C1 = " 4.Diğer Çeşitli Borçlar": Range("B193").FormulaR1C1 = " 4.Other Payables": Range("C193").FormulaR1C1 = "50777": Range("D193").FormulaR1C1 = "79240"
Range("A194").FormulaR1C1 = " 5.Diğer Borç Senetleri Reeskontu (-)": Range("B194").FormulaR1C1 = " 5.Rediscount on Notes Payable (-)": Range("C194").FormulaR1C1 = "43063": Range("D194").FormulaR1C1 = "97708"
Range("A195").FormulaR1C1 = " 6.Kamuya Olan Ertelenmiş veya Taksitlendirilmiş Borçlar": Range("B195").FormulaR1C1 = " 6.Deferred or Restructed Debts of Public Sector": Range("C195").FormulaR1C1 = "14186": Range("D195").FormulaR1C1 = "67260"
Range("A196").FormulaR1C1 = " D.Alınan Avanslar ": Range("B196").FormulaR1C1 = " D.Advace Received ": Range("C196").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D196").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A197").FormulaR1C1 = " 1.Alınan Sipariş Avansları": Range("B197").FormulaR1C1 = " 1.Advances Received": Range("C197").FormulaR1C1 = "49645": Range("D197").FormulaR1C1 = "98897"
Range("A198").FormulaR1C1 = " 2.Alınan Diğer Avanslar": Range("B198").FormulaR1C1 = " 2.Other Advances Received": Range("C198").FormulaR1C1 = "85313": Range("D198").FormulaR1C1 = "17295"
Range("A199").FormulaR1C1 = " E.Borç ve Gider Karşılıkları ": Range("B199").FormulaR1C1 = " E.Provisions for Liabilities and Expenses ": Range("C199").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D199").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A200").FormulaR1C1 = " 1.Kıdem Tazminatı Karşılıkları": Range("B200").FormulaR1C1 = " 1.Provisions for Employee Termination Benefits": Range("C200").FormulaR1C1 = "87045": Range("D200").FormulaR1C1 = "73354"
Range("A201").FormulaR1C1 = " 2.Diğer Borç ve Gider Karşılıkları": Range("B201").FormulaR1C1 = " 2.Provisions for Other Liabilities and Expenses": Range("C201").FormulaR1C1 = "39468": Range("D201").FormulaR1C1 = "9748"
Range("A202").FormulaR1C1 = " F.Gelecek Yıllara Ait Gelirler ve Gider Tahakkukları ": Range("B202").FormulaR1C1 = " F.Long Term Deferred Income and Expense Accruals ": Range("C202").FormulaR1C1 = "=SUM(R[1]C:R[2]C)": Range("D202").FormulaR1C1 = "=SUM(R[1]C:R[2]C)"
Range("A203").FormulaR1C1 = " 1.Gelecek Yıllara Ait Gelirler": Range("B203").FormulaR1C1 = " 1.Long Term Deferred Income": Range("C203").FormulaR1C1 = "67332": Range("D203").FormulaR1C1 = "30966"
Range("A204").FormulaR1C1 = " 2.Gider Tahakkukları": Range("B204").FormulaR1C1 = " 2.Expense Accruals": Range("C204").FormulaR1C1 = "8710": Range("D204").FormulaR1C1 = "63290"
Range("A205").FormulaR1C1 = " G.Diğer Uzun Vadeli Yabancı Kaynaklar ": Range("B205").FormulaR1C1 = " G.Other Long-Term Liabilities ": Range("C205").FormulaR1C1 = "=SUM(R[1]C:R[3]C)": Range("D205").FormulaR1C1 = "=SUM(R[1]C:R[3]C)"
Range("A206").FormulaR1C1 = " 1.Gelecek Yıllara Ertelenen veya Terkin Edilecek KDV": Range("B206").FormulaR1C1 = " 1.Long Term Deferred or Postponed VAT": Range("C206").FormulaR1C1 = "84076": Range("D206").FormulaR1C1 = "93369"
Range("A207").FormulaR1C1 = " 2.Tesise Katılma Payları": Range("B207").FormulaR1C1 = " 2.Installation Participation": Range("C207").FormulaR1C1 = "21099": Range("D207").FormulaR1C1 = "14833"
Range("A208").FormulaR1C1 = " 3.Diğer Çeşitli Uzun Vadeli Yabancı Kaynaklar": Range("B208").FormulaR1C1 = " 3.Other Long Term Liabilities": Range("C208").FormulaR1C1 = "71613": Range("D208").FormulaR1C1 = "81077"
Range("A209").FormulaR1C1 = "III.ÖZ KAYNAKLAR ": Range("B209").FormulaR1C1 = "III.SHARE HOLDERS' EQUITY ": Range("C209").FormulaR1C1 = "=(R[1]C+R[6]C+R[12]C+R[18]C+R[20]C)-R[19]C": Range("D209").FormulaR1C1 = "=(R[1]C+R[6]C+R[12]C+R[18]C+R[20]C)-R[19]C"
Range("A210").FormulaR1C1 = " A.Ödenmiş Sermaye ": Range("B210").FormulaR1C1 = " A.Paid-in Capital ": Range("C210").FormulaR1C1 = "=(R[1]C+R[3]C)-(R[4]C+R[2]C)": Range("D210").FormulaR1C1 = "=(R[1]C+R[3]C)-(R[4]C+R[2]C)"
Range("A211").FormulaR1C1 = " 1.Sermaye": Range("B211").FormulaR1C1 = " 1.Capital": Range("C211").FormulaR1C1 = "113139": Range("D211").FormulaR1C1 = "351295"
Range("A212").FormulaR1C1 = " 2.Ödenmemiş Sermaye (-)": Range("B212").FormulaR1C1 = " 2.Unpaid Capital(-)": Range("C212").FormulaR1C1 = "52168": Range("D212").FormulaR1C1 = "47468"
Range("A213").FormulaR1C1 = " 3.Sermaye Düzeltmesi Olumlu Farkları": Range("B213").FormulaR1C1 = " 3.Pozitive Distinction from Capital Adjustment": Range("C213").FormulaR1C1 = "": Range("D213").FormulaR1C1 = ""
Range("A214").FormulaR1C1 = " 4.Sermaye Düzeltmesi Olumsuz Farkları (-)": Range("B214").FormulaR1C1 = " 4.Negative Distinction from Capital Adjustment (-)": Range("C214").FormulaR1C1 = "2650": Range("D214").FormulaR1C1 = "6261"
Range("A215").FormulaR1C1 = " B.Sermaye Yedekleri ": Range("B215").FormulaR1C1 = " B.Capital Reserves ": Range("C215").FormulaR1C1 = "=SUM(R[1]C:R[5]C)": Range("D215").FormulaR1C1 = "=SUM(R[1]C:R[5]C)"
Range("A216").FormulaR1C1 = " 1.Hisse Senedi İhraç Primleri": Range("B216").FormulaR1C1 = " 1.Share Premium": Range("C216").FormulaR1C1 = "15854": Range("D216").FormulaR1C1 = "16027"
Range("A217").FormulaR1C1 = " 2.Hisse Senedi İptal Karları": Range("B217").FormulaR1C1 = " 2.Share Premium of Cancelled Shares": Range("C217").FormulaR1C1 = "24145": Range("D217").FormulaR1C1 = "17633"
Range("A218").FormulaR1C1 = " 3.M.D.V. Yeniden Değerleme Artışları": Range("B218").FormulaR1C1 = " 3.Revaluation Fund of Tangible Fixed Assets": Range("C218").FormulaR1C1 = "52398": Range("D218").FormulaR1C1 = "96167"
Range("A219").FormulaR1C1 = " 4.İştirakler Yeniden Değerleme Artışları": Range("B219").FormulaR1C1 = " 4.Revaluation Fund of Investments": Range("C219").FormulaR1C1 = "39414": Range("D219").FormulaR1C1 = "29760"
Range("A220").FormulaR1C1 = " 5.Diğer Sermaye Yedekleri": Range("B220").FormulaR1C1 = " 5.Other Capital Reserves": Range("C220").FormulaR1C1 = "67213": Range("D220").FormulaR1C1 = "23132"
Range("A221").FormulaR1C1 = " C.Kar Yedekleri ": Range("B221").FormulaR1C1 = " C.Profit Reserves ": Range("C221").FormulaR1C1 = "=SUM(R[1]C:R[5]C)": Range("D221").FormulaR1C1 = "=SUM(R[1]C:R[5]C)"
Range("A222").FormulaR1C1 = " 1.Yasal Yedekler": Range("B222").FormulaR1C1 = " 1.Legal Reserves": Range("C222").FormulaR1C1 = "4863": Range("D222").FormulaR1C1 = "94486"
Range("A223").FormulaR1C1 = " 2.Statü Yedekleri": Range("B223").FormulaR1C1 = " 2.Special Reserves": Range("C223").FormulaR1C1 = "27318": Range("D223").FormulaR1C1 = "67465"
Range("A224").FormulaR1C1 = " 3.Olağanüstü Yedekler": Range("B224").FormulaR1C1 = " 3.Extraordinary Reserves": Range("C224").FormulaR1C1 = "99848": Range("D224").FormulaR1C1 = "37971"
Range("A225").FormulaR1C1 = " 4.Diğer Kar Yedekleri": Range("B225").FormulaR1C1 = " 4.Other Profit Reserves": Range("C225").FormulaR1C1 = "36536": Range("D225").FormulaR1C1 = "45791"
Range("A226").FormulaR1C1 = " 5.Özel Fonlar": Range("B226").FormulaR1C1 = " 5.Special Funds": Range("C226").FormulaR1C1 = "71928": Range("D226").FormulaR1C1 = "25565"
Range("A227").FormulaR1C1 = " D.Geçmiş Yıllar Karları ": Range("B227").FormulaR1C1 = " D.Retained Earning s ": Range("C227").FormulaR1C1 = "87256": Range("D227").FormulaR1C1 = "78128"
Range("A228").FormulaR1C1 = " E.Geçmiş Yıllar Zararları (-) ": Range("B228").FormulaR1C1 = " E.Accumulated Deficit(-) ": Range("C228").FormulaR1C1 = "46425": Range("D228").FormulaR1C1 = "12547"
Range("A229").FormulaR1C1 = " F.Dönem Net Karı (Zararı) ": Range("B229").FormulaR1C1 = " F.Net Profit(Loss) for The Period ": Range("C229").FormulaR1C1 = "19889": Range("D229").FormulaR1C1 = "=+GelirTablosu!R[-173]C[-1]"
Range("A230").FormulaR1C1 = "PASİF (KAYNAKLAR) TOPLAMI ": Range("B230").FormulaR1C1 = "TOTAL LIABILITIES ": Range("C230").FormulaR1C1 = "=SUM(R[-21]C+R[-56]C+R[-104]C)": Range("D230").FormulaR1C1 = "=SUM(R[-21]C+R[-56]C+R[-104]C)"
Range("A231").FormulaR1C1 = "Kontrol": Range("B231").FormulaR1C1 = "Control": Range("C231").FormulaR1C1 = "=+R[-106]C-R[-1]C": Range("D231").FormulaR1C1 = "=+R[-106]C-R[-1]C"
Range("C4:D231").NumberFormat = "#,##0.00" :Range("A4:A231").Font.Name="Arial Tur"
With Range("A1:D1,A3:B3,C3,D3")

.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = True
.ReadingOrder = xlContext
.MergeCells = True

End With
Range("A1:D5,A11:D11,A17:D17,A26:D26,A35:D35,A43:D43,A47:D47,A50:D50,A60:D61,A35:D35,A68:D68,A76:D76,A87:D87,A98:D98,A107:D107,A113:D113,A116:D116,A125:D127,A137:D137,A143:D143").Font.Bold = True
Range("A150:D150,A153:D153,A156:D156,A161:D161,A166:D166,A169:D169,A174:D175,A183:D183,A189:D189,A196:D196,A199:D199,A202:D202,A205:D205,A209:D210,A215:D215,A221:D221,A227:D231").Font.Bold = True
With Range("C6:D10,C12:D16,C18:D25,C27:D34,C36:D42,C44:D46,C48:D49,C51:D59,C62:D67,C69:D75,C77:D86,C88:D97,C99:D106,C108:D112,C114:D115,C117:D124,C128:D136,C138:D142,C144:D149,C151:D152,C154:D155")

.Font.ColorIndex = 32
.Locked = False

End With
With Range("C157:D160,C162:D165,C167:D168,C170:D173,C176:D182,C184:D188,C190:D195,C197:D198,C200:D201,C203:D204,C206:D208,C211:D214,C216:D220,C222:D226,C227:C229,D227:D228")

.Font.ColorIndex = 32
.Locked = False

End With
With Range("A1:D1")

With .Font

.Name = "Arial Tur"
.Size = 14
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 2

End With
With .Interior

.ColorIndex = 5
.Pattern = xlSolid

End With

End With
With Range("A3:D231,C3:D231,A3:D3")

.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
With .Borders(xlInsideVertical)

.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5

End With
With .Borders(xlInsideHorizontal)

.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5

End With
With .Borders(xlEdgeLeft)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeTop)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeBottom)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeRight)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With

End With
Columns("A:B").ColumnWidth = 62
Columns("C:D").ColumnWidth = 14
Rows("2:2").RowHeight = 6
Rows("4:4").Select: ActiveWindow.FreezePanes = True
Range("D3").Select
ActiveSheet.Protect
'DuPont Analizi [DuPont Analysis]
Sheets("DupondAnalizi").Select
If VBA.Err.Number <> 0 Then VBA.Err.Number = 0: ThisWorkbook.Worksheets.Add , After:=Sheets("Bilanço"): ActiveSheet.Name = "DuPontAnalizi"
ActiveSheet.Unprotect
Cells.Select: Selection.Delete Shift:=xlUp
ActiveWindow.FreezePanes = False
Range("A1").FormulaR1C1 = "DuPont Analizi [DuPont Analysis (Return on Assets (ROA) and Return on Equity (ROE))] [USD]"
Call RangeFormat("A3", "A")
Call RangeFormat("B3", "DÖNEM NET KARI VEYA ZARARI [NET PROFIT/(LOSS) FOR THE PERIOD]")
Call RangeFormat("C3", "=+GelirTablosu!R[53]C")
Call RangeFormat("E5", "E=A / B")
Call RangeFormat("F5", "NET KAR MARJI [NET MARGIN]")
Call RangeFormat("G5", "=+R[-2]C[-4]/R[2]C[-4]")
Call RangeFormat("A7", "B")
Call RangeFormat("B7", "NET SATIŞLAR [NET SALES]")
Call RangeFormat("C7", "=+GelirTablosu!R[5]C")
Call RangeFormat("E9", "F=B / C")
Call RangeFormat("F9", "AKTİF DEVİR HIZI [ASSET TURNOVER]")
Call RangeFormat("G9", "=+R[-2]C[-4]/R[2]C[-4]")
Call RangeFormat("A11", "C")
Call RangeFormat("B11", "ORTALAMA AKTİF (VARLIKLAR) TOPLAMI [AVERAGE TOTAL ASSETS]")
Call RangeFormat("C11", "=(Bilanço!R[114]C+Bilanço!R[114]C[1])/2")
Call RangeFormat("E13", "G=D / C")
Call RangeFormat("F13", "ORTALAMA BORÇLANMA ORANI [AVERAGE LIABILITIES RATE]")
Call RangeFormat("G13", "=+R[2]C[-4]/R[-2]C[-4]")
Call RangeFormat("A15", "D")
Call RangeFormat("B15", "ORTALAMA TOPLAM BORÇLAR [AVERAGE TOTAL LIABILITIES ]")
Call RangeFormat("C15", "=(Bilanço!R[111]C+Bilanço!R[111]C[1]+Bilanço!R[159]C+Bilanço!R[159]C[1])/2")
Call RangeFormat("I7", "H=E * F")
Call RangeFormat("J7", "AKTİF KARLILIĞI [RETURN On INVESTMENT(ROI)RATIO]")
Call RangeFormat("K7", "=R[-2]C[-4]*R[2]C[-4]")
Call RangeFormat("I11", "I=(1 - G)")
Call RangeFormat("J11", "ORTALAMA ÖZ VARLIK ORANI [AVERAGE SHARE HOLDERS' EQUITY RATE]")
Call RangeFormat("K11", "=1-R[2]C[-4]")
Call RangeFormat("M9", "J=H / I")
Call RangeFormat("N9", "ORTALAMA ÖZ VARLIK KARLILIĞI [RETURN On EQUITY(ROE)RATIO]")
Call RangeFormat("O9", "=+R[-2]C[-4]/R[2]C[-4]")
Range("C3,C7,C11,C15").NumberFormat = "#,##0.00"
Range("G5,G9,G13,K7,K11,O9").NumberFormat = "%0.00"
Columns("A:A").ColumnWidth = 6: Columns("E:E").ColumnWidth = 6: Columns("I:I").ColumnWidth = 6: Columns("M:M").ColumnWidth = 6
Columns("B:B").ColumnWidth = 24: Columns("F:F").ColumnWidth = 24: Columns("J:J").ColumnWidth = 24: Columns("N:N").ColumnWidth = 24
Columns("D:D").ColumnWidth = 1: Columns("H:H").ColumnWidth = 1: Columns("L:L").ColumnWidth = 1
Columns("C:C").ColumnWidth = 12: Columns("G:G").ColumnWidth = 12: Columns("K:K").ColumnWidth = 12: Columns("O:O").ColumnWidth = 12
Rows("3:3").RowHeight = 36: Rows("5:5").RowHeight = 36: Rows("7:7").RowHeight = 36: Rows("9:9").RowHeight = 36: Rows("11:11").RowHeight = 36: Rows("13:13").RowHeight = 36: Rows("15:15").RowHeight = 36
With Range("A3:C3,A7:C7,A11:C11,A15:C15,E5:G5,E9:G9,E13:G13,I7:K7,I11:K11,M9:O9")

.Borders(xlDiagonalDown).LineStyle = xlNone
.Borders(xlDiagonalUp).LineStyle = xlNone
With .Borders(xlEdgeLeft)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeTop)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeBottom)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlEdgeRight)

.LineStyle = xlContinuous
.Weight = xlMedium
.ColorIndex = 5

End With
With .Borders(xlInsideVertical)

.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = 5

End With

End With
With Range("A1:O1")

.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = False
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = True
.Merge
With .Font

.Name = "Arial Tur"
.Size = 14
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = 2

End With
With .Interior

.ColorIndex = 5
.Pattern = xlSolid

End With

End With
Range("O9").Select
ActiveSheet.Protect

End Sub
Private Function RangeFormat(Adress1 As String, Text1 As String)

On Error Resume Next
With Range(Adress1)

.FormulaR1C1 = Text1
With .Characters().Font

.Name = "Arial Tur"
.FontStyle = "Regular"
.Size = 8
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic

End With
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlCenter
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = True
.ReadingOrder = xlContext
.MergeCells = False

End With

End Function

Hiç yorum yok:

Blog Arşivi

Bu gadget'ta bir hata oluştu

Bu Blogda Ara

Contributor

Contributor
Mustafa ULUSARAÇ İstanbul, TÜRKİYE
free counters
T. C. Central Bank Indicative Exchange Rates
Currency Exchange Rate Widget,Currency Converter Widget
Borsa İstanbul