Kamis, 27 Juni 2013

Cash Return On Total Assets Ratio

MUTMAINNAH MILMAN
46110037
3AD4

Cah Flow Statement Analysis
Cash Return On Total Assets Ratio Method

A.      Cash Flow Statement
Cash Flow Statement is financial report that records amount of cash and cash equivalent which entering into company’s and leaving from a company’s. This report a mandatory part of a company’s financial reports since 1987 and completing Balance sheet, Capital Statement and Income Statement.
The Amount of cash that enter in Company called Cash Inflows, and the amount of cash that going out from company called Cash Outflows
Cash flow Statement is partitioned into three segments, namely :
1.      Cash flow resulting from operating activity
2.    Cash flow resulting from investing activity
3.    Cash flow resulting from financing activity
a.       Cash Flow From Operating Activity
Cash inflows and Outflows resulting from day-to-day business operations, includingthe collection of cash from sales and payment of expenses. Example:
·      Receipts from the sale ofgoods or service
·      Interest received on loans
·      Payment to suppliers for goods and service
·      Payment to employees
·      Buying merchandise item
b.      Cash Flow From Investing Activity
The investing activities encompass the acquisition and desposition of asset in transactions that are separate from the central activity of the reporting company like sell or buy non-current assets. Example buy or sell Fixed Asset.

c.       Cash Flow From Financing Activity
Financing Activity related primarily to liabilities and shareholders equity in transactions that are separate from central, day-to-day activities of the company. Cash inflows from financing activities usually include issuing capital stock or incurring liabilities such as bonds or notes payable. Outflows are created by the distribution of devidens, the aquisition of treasury stocks, the payment of noncurrent liabilities, and the like.
As we know the financial statement just show to us the amount of financial statement it self, so the Stockholders or financial user not understan what the meaning of amount in Financial Statement, it’s why we need to analysis the the financial statement specially Cash Flow Statement. The Adventages of analysis Cash flow statement are:
1.    The  shareholders can know where cash and cash equivalent coming from and how its being spend,
2.    Provide information on a company’s liquidity and solvency and it’s ability to change cash flows in the future circumstances,
3.    Provide additional information for evaluating changes in assets, liabilities and equity.
Many Method we can use for analysis financial Statment those are:
1.      Horizontal analysis
2.      Vertical analysis
3.      Cross-section
4.      Ratio analysis
a. Horizontal analysis is a prosedure infundamental analysis in which company’s financial statementsover a certain period of time. The analysis will use his or her discretion when choosing a particular timeline, however, the decision is often based of the investing time horison under consideration
b.      Vertical Analysis
Vertical Analysis is a method of financial statement anaylis inn which each entry for each of the three major categories of accounts (asset, liabilies and equities) in balance sheets is represented as a proportion of the total account. The main adventages of vertical analysis is that the balance sheets of businesses of all sizes can easly be compared. It also makes it easy to see relative annual changes whitin on business.
c.       Cross- section
Cross- section is a type of analysis investor, analysis or portofolio manager may conduct on company in relation to that company’s industry or industry peers. The analysis compares one company against the industry it operates whitin, or directly against certain competitors whitin the same industry, in an attempt to discover the best of the breed.
d.      Financial Ratio Analysis
A tool used by individuals to conduct a quantitative analysis of information in a company's financial statements. Ratios are calculated from current year numbers and are then compared to previous years, other companies, the industry, or even the economy to judge the performance of the company. Ratio analysis is predominately used by proponents of fundamental analysis. The kinds of financial Ratio Analysis are:
·      Cash Return On Current Liabilities Ratio
·      Cash Return On Total Liabilities Ratio
·      Cash Return On Total Assets Ratio

Cash Return On Total Assets Ratio (CROTA) is ratio that we use for measuring how much cash flow from operating activity which is result by company for funding all the company’s Assets, whether it’s current assets or non-current assets. The formula of Cash Return On Total Assets Ratio:
 CROTA = Net cash flow from operating activity / Total Assets
 For exampel in PT XL AXIATA Tbk Financial Statement
YEAR
CASH FLOW FROM OPERATING ACTIVITY
TOTAL ASSET
2010
4.289.332
27.251.281
2011
4.307.783
28.413.561
2010 = 4.289.332 / 27.251.281 
         = 0.16 or 16%
2010 = 4.307.783 / 28.413.561 
         = 0.15 or 15%
Based on analysis, it shows us that in 2010, PT XL AXIATA Tbk able to provide cash flow from operating activity about 16 % to covering total of assets, while in 2011, company able to provide cash flow from operating activity about 15 % to covering total of assets.  its mean that solvability of company decrease about 1%.



Minggu, 23 Desember 2012

Latihan_60_46110037

Deskripsi Form Latihan 60
Terdapat 3 object yaitu Label, Textbox dan Button
Object Label
Terdapat 2 yaitu  Rincian Transaksi berdasarkan harga dan Insert the Price will be Preview.
Object Textbox
Terdapat 2 textbox yaituNo. Transaksi dan Nama Kasir
Object Button
Terdapat  1 Button yaitu Priviewyang ketika di click akan menampilkan report Latihan 59 berdasarkan Nomor Transaksi dan akan Menampilkan Nama Kasir
Script Unique
Mengatur Nilai Parameter
 Laporan.SetParameterValue("nama", NK_46110037.Text)

Even
Click
Property
-
Langkah-Langkah Menjalankan Form Latihan 60 46110037
Click Start Debugging untuk menjalankan Script Latihan_58_46110037
Langkah-langkah Menyelesaikan Form Latihan 60 46110037
  • Buka project yang telah dibuat.
  • Buat form baru, caranya click Project pada Toolbar pilih Add Windows Form kemudian ketik nama form yang diinginkan lalu click Add
  • Buat desain form seperti gambar di atas (Latihan_60_46110037) Label, Textbox dan Button.
  • Ganti nama Label, Textbox dan Button di properties-Name,
  • Click Kanan pada design Latihan_60_46110037 lalu pilih View Code kemudian buatlah Script seperti dibawah ini:
Public Class LATIHAN_60_46110037
    Private Sub View_46110037_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles View_46110037.Click
        Dim Laporan As New CrystalDecisions.CrystalReports.Engine.ReportDocument

        Dim botto As New ByIskandar.MengaturDataBaseCrystalReport
        Laporan = botto.AturDatabase(New LATIHAN_59_46110037, Application.StartupPath, "data report.accdb")

        LATIHAN_53_46110037.CrystalReportViewer1.ReportSource = Laporan

        Laporan.SetParameterValue("nama", NK_46110037.Text)

        LATIHAN_53_46110037.CrystalReportViewer1.SelectionFormula = "{detailtransaksi.notrans} = '" & NT_46110037.Text & "'"

        If LATIHAN_53_46110037.Visible = False Then
            LATIHAN_53_46110037.Show()
        Else
            LATIHAN_53_46110037.Activate()
        End If
    End Sub
End Class
  • Save dan Click Start Debugging untuk menjalankan form


Latihan_59_46110037


Deskripsi Form Latihan 59
Latihan  59 adalah latihan membuat report (laporan) yang tampilannya berulang-ulang, pada latihan ini berdasarkan Nomor transaksi, tetapi juga menampilkan siapa yang bertugas dan tanggal pada hari tersebut.
Langkah-langkah Menyelesaikan Form Latihan 59 46110037

  • Click Project kemudian pilih Add Windows Form- dibagian Categories pilih Reporting- pilih CRYSTAL REPORT kemudian ganti nama report yang diinginkan kemuadianclick ADD – pilih As A Blank Report
  • Di bagian Kiri ada Field Explorer – click kanan Database Fileds – DataBase Expert – Create New Connection – OLE DB (Ado)
  • Pilih Tabel yang akan dibuatkan Report, caranya Geser Ke kanan tabel yang diiginkan, atau clik tanda “>” di antara sisi kiri dan sisi kanan kemudian Klik OK.
  • Click kanan Group Name Fields – Insert Group – pilih berdasarkan Kode Barang. Buatlah seperti gambar di bawah ini.
  • Untuk manampilkan Nama caranya Click kanan Parameter Fields – new – isi kolom Name dengan NAMA- OK. Kemudian geser sesuai dengan tempatnya seperti gambar di atas
  • Untuk menampilkan tanggal pilih Print Date pada Special Fields
  • Untukpenjumlahan ke bawah caranya Clik kanan Object yang akan dijumlahkan  – Insert -  Summary – pada bagian Calculate this Summary pilih SUM – OK
  • Untuk Menambahkan Judul bisa pakai tool Textbox, kemudian ketik judul yang diinginkan
  • Untuk menghilangkan angka Nol dibelakang koma, Click kanan object yang akan dihilangkan komanya pilih format Object, pilih Custom Style – pilih customize – Ubah dibagian Decimal – kemuadian click OK
  • Untuk melihat Laporan pilih Main Report Preview di bagian bawah, dan Main Report untuk mendesain Report



Latihan_58_46110037

Deskripsi Form Latihan 58
Terdapat 3 object yaitu Label, DateTimePicker dan Button
Object Label
Terdapat 2 yaitu  Rincian Transaksi berdasarkan harga dan Insert the Price will be Preview.
Object DateTimePicker
Terdapat 2 textbox yaitu Dari Tanggal dan Sampai Tanggal
Object Button
Terdapat  1 Button yaitu Priviewyang ketika di click akan menampilkan report Latihan 50 berdasarkan tanggal
Script Unique
Tidak ada script unique pada latihan ini.
Even
Click
Property
-
Langkah-Langkah Menjalankan Form Latihan 58 46110037
Click Start Debugging untuk menjalankan Script Latihan_58_46110037
Langkah-langkah Menyelesaikan Form Latihan 58 46110037
  • Buka project yang telah dibuat.
  • Buat form baru, caranya click Project pada Toolbar pilih Add Windows Form kemudian ketik nama form yang diinginkan lalu click Add
  • Buat desain form seperti gambar di atas (Latihan_58_46110037) Label, DateTimePicker dan Button.
  • Ganti nama LabelDateTimePicker dan Button di properties-Name,
  • Click Kanan pada design Latihan_58_46110037 lalu pilih View Code kemudian buatlah Script seperti dibawah ini:
Public Class LATIHAN_58_46110037
    Private Sub View_46110037_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles LIAT_46110037.Click
        Dim Laporan As New CrystalDecisions.CrystalReports.Engine.ReportDocument

        Dim botto As New ByIskandar.MengaturDataBaseCrystalReport
        Laporan = botto.AturDatabase(New LATIHAN_50_46110037, Application.StartupPath, "data report.accdb")

        LATIHAN_53_46110037.CrystalReportViewer1.ReportSource = Laporan

        LATIHAN_53_46110037.CrystalReportViewer1.SelectionFormula = "datevalue({mastertransaksi.tanggaltransaksi}) = #" & DARITGL_46110037.Value.Month & "/" & DARITGL_46110037.Value.Day & "/" & DARITGL_46110037.Value.Year & "#" & "and datevalue({mastertransaksi.tanggaltransaksi}) <= #" & SAMPAITGL_46110037.Value.Month & "/" & SAMPAITGL_46110037.Value.Day & "/" & SAMPAITGL_46110037.Value.Year & "#"


        If LATIHAN_53_46110037.Visible = False Then
            LATIHAN_53_46110037.Show()
        Else
            LATIHAN_53_46110037.Activate()
        End If
    End Sub
End Class
  • Save dan Click Start Debugging untuk menjalankan form