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