forecasting
DESCRIPTION
ForecastingTRANSCRIPT
Sheet1Forecasting StepEstimasi 2014Penjualan Bersih1Rp84,483,104Beban Pokok Penjualan3Rp61,881,516Laba Kotor2Rp22,601,588Beban Penjualan4Rp4,990,114Beban Umum dan Administrasi4Rp1,170,667Penghasilan lain-lain50.0Beban lain-lain50.0Penghasilan Keuangan60.0Biaya Keuangan6Rp73,142Bagian atas hasil bersih entitas asosiasi7Rp24,812Laba sebelum pajak penghasilan8Rp16,392,476Beban pajak penghasilan9Rp4,170,194Laba tahun berjalan10Rp12,222,283Laba (Rugi) komprehensif lain110.0Laba komprehensif tahun berjalan12Rp12,222,283Selected Ratio (dalam %)2010201120122013Sales Growth0.21841143090.26050458910.1260629258Gross Profit Margin0.29173603740.28748485430.35014076170.2675279123Selling expense/sales0.06740145450.07915050250.0590664148General and administrative expense/sales0.01841210010.0138568228Interest expense/Prior year long term debt346840.0299518299Bagian atas hasil bersih entitas asosiasi-0.73984226812.6258633922Income tax expense/pretax income0.2543968143
Sheet2ASSETCashRp4,229,696ReceivableRp1,568,786InventoriesRp19,517,551Other Current AssetRp10,049Total Current AssetRp25,326,082PPERp4,757,585Acumulated DepreciationRp578,353PPE, netRp4,179,232Other Asset0.0TOTAL ASSETRp29,505,314
LIABILITASAccount PayableRp660,860Short-Term DebtRp2,835,478Accrued ExpenseRp176,707Excise Tax PayableRp6,164,841Income Taxes and OtherRp1,409,876Total Current LiabilitiesRp11,247,762Deferred Income Taxes and Other LiabilitesRp154,410Long term Debt0.0TOTAL LIABILITIESRp11,402,172
EQUITYCommon StockRp438,300Additional Paid in CapitalRp120,622Retained EarningsRp17,544,220Shareholder's EquityRp18,103,142TOTAL LIABILITIES AND NET WORTHRp29,505,3142013Selected RatioAR Turnover53.8525417038Inventory Turnover4.3285709472AP Turnover34.2002572819Accrued Expense Turnover424.5740519617Tax Payable1409876Tax Expense3691224Tax Ratio0.38195352Dividend/ShareCAPEX779407CAPEX/Sales0.0103886018
Sheet3