Spreadsheets Analisis Laporan Keuangan.xls

1 HOME 1. LAPORAN NERACA 2. LAPORAN RUGI LABA 3. ANALISIS RASIO 4. ANALISIS DUPONT 5. PROFORMA RUGI LABA 6. PROFORMA NERACA 7. ANALISIS RASIO (PROFORMA) 8. ANALISIS DUPONT (PROFORMA) 9. ANALISIS SENSITIITAS

2

HOME Nama Perusahaan Yang Akan Di Analisa

PT Bumi Resource

Tahun Terakhir Laporan Keuangan

20 07

P!"#$%#& P!$'*$ S+,!*-!!" 1. angan melakukan !nser"# Dele"e# $o%e# &an 'u". ika "anpa senga(a segera )n&o. 2. !silah cell *ang +er,arna kuning sa(a. -. angan menghapus cell *ang +er,arna selain kuning karena +erisi rumus a"au ke"erangan. ke"erangan.

 Ri/k*  Bu&i# )!# 2003

LAPORAN NERACA PT B#/ R!0#,! URAIAN

25

26

27

Analisis 4er5kal 200

Analisis 6ori/on"al

2008

2007

2008

2007

HARTA HARTA LANCAR Kas &an Bank

800#907

1#281#32

2#:38#707

7.78;

19.-:;

23.20;

110.12;

123.81;

Piu"ang )saha

21#-7

7:3#900

8:3#70

8.7-;

3.00;

8.3;

1.91;

<12.82;

Piu"ang Lain
900#08

-:3#700

20#300

.17;

9.99;

2.0:;

<2.3;

<97.18;

Perse&iaan < Bahan Baku < Barang &alam proses < Barang a&i < Bahan Bakar

< 1#933#-91 <

< 1#30:#93 <

< 2#003#0:9 <

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

13.-7;

21.7;

20.2;

27.23;

.27;

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0? <22.23;

)ang $uka

1#27:

2#-31

1#::

0.02;

0.0-;

0.02;

:7.03;

Bia*a &i+a*ar &imuka

1#120

1#28

1#7-

0.01;

0.01;

0.02;

12.19;

-:.19;

Ase" lancar lainn*a

2#20

#130

2#00

0.0-;

0.08;

0.0-;

1-0.87;

<1.:-;

T0"* H*,"* L*$*, HARTA TETAP

32589

435824

587534

-3.03;

93.8:;

:.-;

99.0-;

--.28;

N* P!,0!*$ Tanah

00#000

00#000

00#000

8.98;

.70;

.09;

0.00;

0.00;

Bangunan

22#000

22#000

22#000

2.31;

2.8;

2.27;

0.00;

0.00;

$esin
10#000

10#000

10#000

1.39;

1.71;

1.1;

0.00;

0.00;

LAPORAN NERACA PT B#/ R!0#,! URAIAN

25

26

27

Analisis 4er5kal 200


800#907

1#281#32

2#:38#707

Piu"ang )saha

21#-7

7:3#900

8:3#70

Piu"ang Lain
900#08

-:3#700

20#300

Analisis 6ori/on"al

2008

2007

2008

2007

7.78;

19.-:;

23.20;

110.12;

123.81;

8.7-;

3.00;

8.3;

1.91;

<12.82;

.17;

9.99;

2.0:;

<2.3;

<97.18;

Perse&iaan < Bahan Baku < Barang &alam proses < Barang a&i < Bahan Bakar

< 1#933#-91 <

< 1#30:#93 <

< 2#003#0:9 <

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

13.-7;

21.7;

20.2;

27.23;

.27;

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0? <22.23;

)ang $uka

1#27:

2#-31

1#::

0.02;

0.0-;

0.02;

:7.03;


1#120

1#28

1#7-

0.01;

0.01;

0.02;

12.19;

-:.19;

Ase" lancar lainn*a

2#20

#130

2#00

0.0-;

0.08;

0.0-;

1-0.87;

<1.:-;

T0"* H*,"* L*$*, HARTA TETAP

32589

435824

587534

-3.03;

93.8:;

:.-;

99.0-;

--.28;

N* P!,0!*$ Tanah

00#000

00#000

00#000

8.98;

.70;

.09;

0.00;

0.00;

Bangunan

22#000

22#000

22#000

2.31;

2.8;

2.27;

0.00;

0.00;

$esin
10#000

10#000

10#000

1.39;

1.71;

1.1;

0.00;

0.00;

1#000

1#000

1#000

0.13;

0.17;

0.1;

0.00;

0.00;

Perala"an Kan"or

1#20

1#20

1#20

0.02;

0.01;

0.01;

0.00;

0.00;

)5li5es

:#00

:#00

:#00

0.11;

0.10;

0.03;

0.00;

0.00;

Ken&araan

umlah Nilai Perolehan

:33#70

:33#70

:33#70

11.82;

10.28;

3.07;

0.00;

0.00;

Akumulasi Pen*usu"an

@218#-78

@28#03

@-1-#:19

<2.73;

<-.02;

<-.18;

22.2;

1:.-:;

683374

634655

585936

:.:-;

7.2-;

.31;

<7.1-;

<7.8:;

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

H*,"* T!"*+ (N!")

PROE DALAM ONSTRUSI HARTA LAINLAIN Bia*a Pra<perasi







#090#98

#090#98

#090#98

8.11;

7.9;

0.:0;

0.00;

0.00;

Akumulasi Amor5sasi

@1#00:#032

@1#280#11

@1#12#1-:

<1-.02;

<19.-8;

<1.29;

2.00;

20.00;

H*,"* L*$*$ ($!")

432364

378341

3528318

2.03;

9-.03;

-.8;

<8.2;

<8.87;

TOTAL HARTA

7741547

87732

9921788

100.00;

100.00;

100.00;

1-.-2;

1-.03;

17#:1

1#---

13#:0-

0.2-;

0.17;

0.20;

<19.11;

23.1;

HUTANG DAN EUITAS HUTANG LANCAR 6u"ang )saha 6u"ang Bunga

20#917

20#--3

22#09

0.28;

0.2-;

0.22;

<0.-:;

:.-3;

6u"ang Pa(ak

33#303

890#:77

8:9#339

7.7;

7.-1;

8.30;

8.:-;

8.::;

6u"ang Di%i&en&

#000

-#90

0.00;

0.08;

0.0-;

=D!4>0?

<-1.00;

-#12

1#03

8#90

0.09;

0.01;

0.07;

<89.38;

9:3.09;

00#000

00#000

00#000

8.98;

.70;

.09;

0.00;

0.00;

1#20

1#000

:00

0.02;

0.01;

0.01;

<20.00;

<20.00;

T0"* H#"*$' L*$*, HUTANG ANGA PANANG 6u"ang Bank angka Pan(ang

1142552

1183644

1237542

19.78;

1-.93;

12.97;

-.80;

9.;

2#000#000

1#00#000

1#000#000

2.:-;

17.10;

10.0:;

<2.00;

<--.--;

TOTAL HUTANG

3142552

2683644

2237542

90.3;

-0.3;

22.;

<19.80;

<18.82;

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

Bia*a *ang masih harus &i+a*ar 6u"ang Bank angka Pen&ek 6u"ang Lain
<

HA MINORITAS EUITAS $o&al &ise"or

1#18#3::

1#18#3::

1#18#3::

19.3;

1-.13;

11.88;

0.00;

0.00;

Kumula5C La+a Tahun Lalu

2#092#220

-#9-7#00:

9#32:#3-:

28.-:;

-3.1:;

93.8:;

8:.-0;

9-.91;

La+a "ahun +er(alan

1#-33#7:7

1#93#-:1

1#3:#-13

1:.0:;

17.0;

18.11;

8.:-;

8.::;

T0"* E&#"*

4598996

689376

7684246

3.91;

83.91;

77.9;

-2.91;

28.13;

PROE DALAM ONSTRUSI HARTA LAINLAIN



Bia*a Pra<perasi





0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

#090#98

#090#98

#090#98

8.11;

7.9;

0.:0;

0.00;

0.00;

Akumulasi Amor5sasi

@1#00:#032

@1#280#11

@1#12#1-:

<1-.02;

<19.-8;

<1.29;

2.00;

20.00;

H*,"* L*$*$ ($!")

432364

378341

3528318

2.03;

9-.03;

-.8;

<8.2;

<8.87;

TOTAL HARTA

7741547

87732

9921788

100.00;

100.00;

100.00;

1-.-2;

1-.03;

HUTANG DAN EUITAS HUTANG LANCAR 6u"ang )saha

17#:1

1#---

13#:0-

0.2-;

0.17;

0.20;

<19.11;

23.1;

6u"ang Bunga

20#917

20#--3

22#09

0.28;

0.2-;

0.22;

<0.-:;

:.-3;

6u"ang Pa(ak

33#303

890#:77

8:9#339

7.7;

7.-1;

8.30;

8.:-;

8.::;

6u"ang Di%i&en&

#000

-#90

0.00;

0.08;

0.0-;

=D!4>0?

<-1.00;

-#12

<

1#03

8#90

0.09;

0.01;

0.07;

<89.38;

9:3.09;

00#000

00#000

00#000

8.98;

.70;

.09;

0.00;

0.00;

1#20

1#000

:00

0.02;

0.01;

0.01;

<20.00;

<20.00;

T0"* H#"*$' L*$*, HUTANG ANGA PANANG 6u"ang Bank angka Pan(ang

1142552

1183644

1237542

19.78;

1-.93;

12.97;

-.80;

9.;

2#000#000

1#00#000

1#000#000

2.:-;

17.10;

10.0:;

<2.00;

<--.--;

TOTAL HUTANG

3142552

2683644

2237542

90.3;

-0.3;

22.;

<19.80;

<18.82;

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

Bia*a *ang masih harus &i+a*ar 6u"ang Bank angka Pen&ek 6u"ang Lain
HA MINORITAS EUITAS $o&al &ise"or

1#18#3::

1#18#3::

1#18#3::

19.3;

1-.13;

11.88;

0.00;

0.00;


2#092#220

-#9-7#00:

9#32:#3-:

28.-:;

-3.1:;

93.8:;

8:.-0;

9-.91;

La+a "ahun +er(alan

1#-33#7:7

1#93#-:1

1#3:#-13

1:.0:;

17.0;

18.11;

8.:-;

8.::;

T0"* E&#"*

4598996

689376

7684246

3.91;

83.91;

77.9;

-2.91;

28.13;

TOTAL HUTANG -*$ EUITAS

7741547

877321

9921788

100.00;

100.00;

100.00;

1-.-2;

1-.03;

LAPORAN RUGI LABA PT B#/ R!0#,! URAIAN

25

26

27

12#:1#00

1-#7#00

19#-0#800

6arga Pokok Pen(ualan

:#338#00

3#02#:0

10#09#920

L** 0"0,

385545

47265

43518

1#03-

182#228

17:#738

:#120

:8#10

::#00

Bia*a Pemasaran

1#2:#10

1#-7#0

1#929#080

Bia*a Depresiasi

9:#713

9:#713

9:#713

Bia*a Amor5sasi

22#02-

22#02-

22#02-

3#313 1 836 24

3#313 1 916 542

3#313 2 2 17

Pen(ualan

B*:* O+!,*0$* -*$ P!/**,*$ )pah>a(i Bia*a A&minis"rasi &an )mum

Bia*a Asuransi T0"* B*:* O+!,*0$* -*$ P!/**,*$

LAPORAN RUGI LABA PT B#/ R!0#,! URAIAN

25

26

27

12#:1#00

1-#7#00

19#-0#800

6arga Pokok Pen(ualan

:#338#00

3#02#:0

10#09#920

L** 0"0,

385545

47265

43518

1#03-

182#228

17:#738

:#120

:8#10

::#00

Bia*a Pemasaran

1#2:#10

1#-7#0

1#929#080

Bia*a Depresiasi

9:#713

9:#713

9:#713

Bia*a Amor5sasi

22#02-

22#02-

22#02-


3#313 183624

3#313 1916542

3#313 2217

L** O+!,*

219426

215618

233163

20#80

20#700

20#70

320 1999696

:0 2136258

300 2283313

33#303

890#:77

8:9#339

1399787

1495381

1598319

Pen(ualan


Bia*a Bunga Pen&apa"an @Bia*a lain
Analisis 4er5kal

Analisis 6ori/on"al

200 100.00;

2008 100.00;

2007 100.00;

2008 .8-;

2007 .71;

70.00;

70.00;

70.00;

.8-;

.71;

-0.00;

-0.00;

-0.00;

.8-;

.71;

1.21;

1.13;

1.2;

9.80;

10.21;

0.88;

0.8-;

0.82;

1.18;

2.7:;

10.00;

10.00;

3.32;

.8-;

9.30;

0.-:;

0.-8;

0.-9;

0.00;

0.00;

1.38;

1.:8;

1.78;

0.00;

0.00;

0.0:;

0.07;

0.07;

0.00;

0.00;

19.23;

19.12;

1-.3;

9.-3;

9.98;

1.71;

1.::;

18.0;

8.77;

8.:2;

0.18;

0.1;

0.19;

0.29;

0.29;

0.01;

0.01;

0.01;

<7.81;

.::;

1.8;

1.79;

1.31;

8.:-;

8.::;

9.87;

9.72;

9.77;

8.:-;

8.::;

0.00;

0.00;

0.00;

=D!4>0?

=D!4>0?

10.:3;

11.02;

11.19;

8.:-;

8.::;

ANALISIS RASIO PT B#/ R!0#,! R*0R*0

6is"oris 200

R*0 L&#-"* Ne" Eorking 'api"al

Rasio !n&us"ri

2008

2007

1#::-#27

-#179#-:0

9#83#332

'urren" Ra5o

2.89:

-.8:2

9.83-

Fuick Ra5o

1.--8

2.083

-.083

'ash Ra5o

0.2

1.088

2.-91

R*0 A&;<"* Recei%a+le Turno%er A%erage 'ollec5on Perio& !n%en"or* Turno%er

10.981

:.8-

12.017

-9.:3-

92.283

-0.-79

8.000

9.373

.000

A%erage Da*s Gupplies in !n%en"or*

80.:--

7-.-09

7-.000

iHe& Asse" Turno%er

1:.:08

21.-30

29.932

To"al Asse" Turno%er

1.880

1.97

1.998

Time !n"eres" arne&

37.73-

109.180

110.338

De+" "o Iui"* Ra5o

8:.--1;

99.071;

23.113;

De+" Ra5o

90.3-;

-0.30;

22.2;

R*0 P,0>"*"* ross ProJ" $argin pera5ng $argin

-0.000;

-0.000;

-0.000;

1.719;

1.::2;

18.093;

Pre"aH $argin

1.80;

1.7-8;

1.311;

ProJ" $argin

10.:32;

11.01;

11.1-:;

200

2008

2007

R*0 S0<*"*=L!
Re"urn on Asse"

1:.0:1;

17.09;

18.103;

Re"urn on" To"al 'api"al

1:.28:;

17.210;

18.28;

Re"urn on Iui"*

-0.9-7;

29.7;

20.:00;

A"/*$? @ S0,!

9.-02

-.7:

-.8:

< Nilai Pasar kui"as @6arga Gaham  Gaham u"s"an&ing

9#9#88

-

-

-


9#9#88

ANALISIS DUPONT PT B#/ R!0#,! ROE

ROA

200

-0.99;

2008

29.8;

2007

20.:0;

E#": M#"+!,

200

1:.0:;

=4AL)? 200

1.8:-

2008

17.0;

=4AL)? 2008

1.991

2007

18.11;

=4AL)? 2007

1.231

ANALISIS DUPONT PT B#/ R!0#,! ROE 200

-0.99;

2008

29.8;

2007

20.:0;

ROA

E#": M#"+!,

200

1:.0:;

=4AL)? 200

1.8:-

2008

17.0;

=4AL)? 2008

1.991

2007

18.11;

=4AL)? 2007

1.231

PM

TATO

200

10.:3;

200

1.880

2008

11.02;

2008

1.97

2007

11.19;

2007

1.998

NI

SALES

SALES

200

1#-33#7:7

200

12#:1#00

200

12#:1#00

2008

1#93#-:1

2008

1-#7#00

2008

1-#7#00

2007

1#3:#-13

2007

19#-0#800

2007

19#-0#800

T0"* A!" 200

7#791#97

2008

:#77-#020

2007

3#321#7::

PROFORMA RUGI LABA PT B#/ R!0#,! A#/ :*$' -#"#&*$ Kenaikan pen(ualan per "ahun

20;

Tingka" Pa(ak

-0;

P,0F0,/* R#' L** URAIAN

27

 0$ S*!

28

29

Pen(ualan

19#-0#800

100.00;

17#220#720

20#889#:89

6arga Pokok Pen(ualan L** 0"0,

10#09#920 43518

70.00; 3.

12#09#09 5166216

19#98#90 6199459

17:#738

1.2;

219#

27#988

::#00

0.82;

108#200

127#990

Bia*a Pemasaran

1#929#080

3.32;

1#70:#:72

2#00#898

Bia*a Depresiasi

9:#713

0.-9;

9:#713

9:#713

Bia*a Amor5sasi

22#02-

1.78;

22#02-

22#02-


3#313 2217

0.07; 13.95

11#302342272

19#2:275578

L** O+!,*

233163

2823944

3448882

20#70

20#:00

20#:0

1#0:0 284224

1#238 3429328

:91#287

1#02:#73:


Bia*a Bunga Pen&apa"an @Bia*a lain
300 2283313

0.01; 1.31;

8:9#339 < 1598319

0.00; 11.19;

< 1962957

< 24529

21

29#737#:-7 17#-:#9:8 7439351 -0:#33 12#32: 2#980#778 9:#713 22#0217#190 324545 419886 20#300 1# 4179461 1#2-#:-: < 2925623

PROFORMA NERACA PT B#/ R!0#,! A#/ :*$' -#"#&*$ Kenaikan pen(ualan per "ahun

20;

Presen"ase ks"ernal inancing < 6u"ang Bank

90;

< 6u"ang angka Pan(ang

80;

Re"en5on Ra"e

80;

PROFORMA NERACA PT B#/ R!0#,! URAIAN

27

 0$ S*!

28

29

21


2#:38#707

20.13;

-#978#09:

9#171#2:

#00#10

Piu"ang )saha

8:3#70

9.:1;

:27#700

33-#290

1#131#:::

Piu"ang Lain
20#300

1.9-;

297#0:0

238#938

-#73

Perse&iaan < Bahan Baku

<

0.00;

<

<

<

< Barang &alam proses

<

0.00;

<

<

<

< Barang a&i < Bahan Bakar

2#003#0:9 <

19.00; 0.00;

2#910#301 <

2#:3-#0:1 <

-#971#837 <

)ang $uka

1#::

0.01;

2#2-0

2#878

-#211


1#7-

0.01;

2#0:2

2#93:

2#33:

Ase" lancar lainn*a

2#00

0.02;

-#000

-#800

9#-20

T0"* H*,"* L*$*,

587534

4.47

696941

8362849

135419

Tanah

00#000

-.9:;

800#000

720#000

:89#000

Bangunan

22#000

1.7;

270#000

-29#000

-::#:00

$esin
10#000

1.0;

1:0#000

218#000

23#200

1#000

0.10;

1:#000

21#800

2#320

Perala"an Kan"or

1#20

0.01;

1#00

1#:00

2#180

)5li5es

:#00

0.08;

10#200

12#290

19#8::

umlah Nilai Perolehan

:33#70

8.27;

1#073#700

1#23#890

1#9#78:

Akumulasi Pen*usu"an H*,"* T!"*+ (N!")

@-1-#:19 585936

4.8

@-82#-- 1796867

@911#22 21828

@93#371 2649565

-.12;

#090#98

#090#98

#090#98

@1#789#181

@2#018#1:9

@2#28:#207

HARTA TETAP N* P!,0!*$

Ken&araan

PROE DALAM ONSTRUSI

<

HARTA LAINLAIN Bia*a Pra<perasi

#090#98

Akumulasi Amor5sasi

@1#12#1-:

H*,"* L*$*$ ($!")

3528318

24.59

3276295

324272

2772249

TOTAL HARTA

9921788

69.14

124223

13567149

15457233

HUTANG DAN EUITAS

HUTANG LANCAR 6u"ang )saha

13#:0-

0.19;

2-#789

2:#18

-9#220

6u"ang Bunga

22#09

0.1;

28#99

-1#79

-:#039

6u"ang Pa(ak

8:9#339

9.77;

:21#33-

3:8#-31

1#1:-#870

6u"ang Di%i&en&

-#90

0.02;

Bia*a *ang masih harus &i+a*ar

8#90

0.09;

7#790

3#2::

11#198

00#000

-.9:;

313#703

::-#0::

:2#909

:00 1237542

0.01;

380 18619

1#12 19418

1#-:2 212915

6u"ang Bank angka Pen&ek 6u"ang Lain
<

<

<

HUTANG ANGA PANANG 6u"ang Bank angka Pan(ang

1#000#000

1#-73#89

1#-29#8-1

1#27:#808

TOTAL HUTANG

2237542

318183

3264812

3399522

HA MINORITAS



.







EUITAS $o&al &ise"or

1#18#3::

1#18#3::

1#18#3::

1#18#3::


9#32:#3-:

8#27#2:

7#70#0-2

3#19#-93

La+a "ahun +er(alan T0"* E&#"*

1#3:#-13 7684246

1#177#779 88622

1#990#-1: 132337

1#7#-79 1257711

TOTAL HUTANG -*$ EUITAS

9921788

124223

13567149

15457233

2299273

227719

213111

!#"#*$ -*$* -*, #*,

ANALISIS RASIO (PROFORMA) PT B#/ R!0#,! 6is"oris

R*0R*0 R*0 L&#-"* Ne" Eorking 'api"al

Pro*eksi

200

2008

2007

200: #18:#921

2003 8#922#883

Rasio !n&us"ri 2010

1#::-#27

-#179#-:0

9#83#332

'urren" Ra5o

2.89:

-.8:2

9.83-

-.:70

9.-10

Fuick Ra5o

1.--8

2.083

-.083

2.-1

2.:13

-.03

'ash Ra5o

0.2

1.088

2.-91

1.3-0

2.10

2.-80

2007

200:

2003

9.7-2

10.981

:.8-

12.017

12.017

12.017

12.017

A%erage 'ollec5on Perio&

-9.:3-

92.283

-0.-79

-0.-79

-0.-79

-0.-79

8.000

9.373

.000

.000

.000

.000

A%erage Da*s Gupplies in !n%en"or*

80.:--

7-.-09

7-.000

7-.000

7-.000

7-.000


1:.:08

21.-30

29.932

3.:9

3.973

3.-3

To"al Asse" Turno%er

1.880

1.97

1.998

1.9-0

1.2-

1.809

R*0 S0<*"*=L!
2008

7#319#09

R*0 A&;<"* Recei%a+le Turno%er !n%en"or* Turno%er

200

37.73-

109.180

110.338

1-.787

18.919

200.300


8:.--1;

99.071;

23.113;

-.::8;

-1.830;

2:.139;

De+" Ra5o

90.3-;

-0.30;

22.2;

28.903;

29.089;

21.33-;

ross ProJ" $argin

-0.000;

-0.000;

-0.000;

-0.000;

-0.000;

-0.000;

pera5ng $argin

1.719;

1.::2;

18.093;

18.-33;

18.830;

18.3-2;

Pre"aH $argin

1.80;

1.7-8;

1.311;

18.2:9;

18.3;

18.:9;

ProJ" $argin

10.:32;

11.01;

11.1-:;

11.-33;

11.818;

11.73:;

R*0 P,0>"*"*

Re"urn on Asse"

1:.0:1;

17.09;

18.103;

18.-01;

17.839;

1:.327;


1:.28:;

17.210;

18.28;

18.922;

17.:01;

13.022;

Re"urn on Iui"*

-0.9-7;

29.7;

20.:00;

22.10;

2-.-01;

29.289;

A"/*$? @ S0,!

9.-02

-.7:

-.8:

-.81-

-.:72

9.101


9#9#88

-

-

-

-

-


2010

9#9#88

2010

-

ANALISIS DUPONT (PROFORMA) PT B#/ R!0#,! ROE

ROA

200

-0.9-7;

2008

29.7;

2007

20.:00;

0 200:

22.10;

0 2003

2-.-01;

0 2010

29.289;

E#": M#"+!,

200

1:.0:1;

=4AL)? 200

1.8:-

2008

17 09;

=4AL)? 2008

1 991

ANALISIS DUPONT (PROFORMA) PT B#/ R!0#,! ROE 200

-0.9-7;

2008

29.7;

2007

20.:00;

0 200:

22.10;

0 2003

2-.-01;

0 2010

29.289;

ROA

E#": M#"+!,

200

1:.0:1;

=4AL)? 200

1.8:-

2008

17.09;

=4AL)? 2008

1.991

2007

18.103;

=4AL)? 2007

1.231

0 200:

18.-01;

1 200:

1.-3

0 2003

17.839;

1 2003

1.-17

0 2010

1:.327;

1 2010

1.2:2

PM

TATO

200

10.:32;

200

1.880

2008

11.01;

2008

1.97

2007

11.1-:;

2007

1.998

200:

11.-33;

200:

1.9-0

2003

11.818;

2003

1.2-

2010

11.73:;

2010

1.809

NI

SALES

SALES

200

1#-33#7:7

200

12#:1#00

200

12#:1#00

2008

1#93#-:1

2008

1-#7#00

2008

1-#7#00

2007

1#3:#-13

2007

19#-0#800

2007

19#-0#800

200:

1#382#37

200:

17#220#720

200:

17#220#720

2003

2#900#23

2003

20#889#:89

2003

20#889#:89

2010

2#32#82-

2010

29#737#:-7

2010

29#737#:-7

T0"* A!" 200

7#791#97

2008

:#77-#020

2007

3#321#7::

200:

12#092#20-

2003

1-#87#193

2010

1#97#2--

ANALISIS SENSITIITAS PT B#/ R!0#,! A#/ Kenaikan Pen(ualan

20.00;

Ba"as Ba,ah

10.00;

Ba"as A"as

-0.00;

ANALISIS SENSITIITAS PT B#/ R!0#,! Rasio
200:

Gensi5%i"as

20.00;

10.00;

12.00;

19.00;

18.00;

1:.00;

20.00;

#18:#921

9#:32#2-9

9#397#972

#002#703

#07#398

#11-#1:9

#18:#921

'urren" Ra5o

-.:70

9.270

9.17:

9.032

9.01-

-.3-3

-.:70

Fuick Ra5o

2.-1

2.73-

2.7-2

2.878

2.82

2.78

2.-1

'ash Ra5o

1.3-0

2.1-0

2.0:9

2.091

2.002

1.38

1.3-0

Recei%a+le Turno%er

12.017

12.017

12.017

12.017

12.017

12.017

12.017

A%erage 'ollec5on Perio&

-0.-79

-0.-79

-0.-79

-0.-79

-0.-79

-0.-79

-0.-79

.000

.000

.000

.000

.000

.000

.000

7-.000

7-.000

7-.000

7-.000

7-.000

7-.000

7-.000


3.:9

3.78-

3.729

3.8:7

3.81

3.817

3.:9

To"al Asse" Turno%er R*0 S0<*"*=L!
1.9-0

1.-33

1.908

1.912

1.91:

1.929

1.9-0

Time !n"eres" arne&

1-.787

12-.29:

12.72

12:.2

1-0.73

1--.28-

1-.787


-.::8; 2:.:3-; -0.-0; -1.711; --.103; -9.01; -.::8;

De+" Ra5o

28.903; 22.918; 2-.27; 29.078; 29.:79; 2.81; 28.903;

R*0 L&#-"* Ne" Eorking 'api"al

R*0 A&;<"*

!n%en"or* Turno%er A%erage Da*s Gupplies in !n%en"or*

R*0 P,0>"*"* ross ProJ" $argin

-0.000; -0.000; -0.000; -0.000; -0.000; -0.000; -0.000;

pera5ng $argin

18.-33; 18.290; 18.279; 18.-07; 18.--:; 18.-83; 18.-33;

Pre"aH $argin

18.2:9; 18.119; 18.11; 18.1:8; 18.220; 18.22; 18.2:9;

ProJ" $argin

11.-33; 11.2:0; 11.-0; 11.--0; 11.-9; 11.-77; 11.-33;

Re"urn on Asse"

18.-01; 1.7:9; 1.:32; 1.333; 18.102; 18.20-; 18.-01;


18.922; 1.31-; 18.020; 18.129; 18.228; 18.-2; 18.922;

Re"urn on Iui"*

22.10; 20.-99; 20.703; 21.072; 21.9--; 21.73-; 22.10;

A"/*$? @ S0,!

-.81-

-.811

-.811

-.812

-.812

-.81-

-.81-

22.00;

29.00;

28.00;

2:.00;

-0.00;

#22-#83

#27:#:38

#--9#1-9

#-:3#-71

#999#803

-.:08

-.798

-.8:3

-.8-8

-.:8

2.9:3

2.90

2.91-

2.-7:

2.-98

1.:3:

1.:8:

1.:90

1.:19

1.7:3

12.017

12.017

12.017

12.017

12.017

-0.-79

-0.-79

-0.-79

-0.-79

-0.-79

.000

.000

.000

.000

.000

7-.000

7-.000

7-.000

7-.000

7-.000

3.2

3.22

3.93-

3.989

3.9-7

1.9-8

1.991

1.997

1.92

1.97

1-:.270

190.779

19-.27:

19.7:2

19:.2:

-7.28-; -:.8-9; -3.333; 91.-7; 92.70:; 27.197; 27.:8:; 2:.71; 23.27; 23.327; -0.000; -0.000; -0.000; -0.000; -0.000; 18.927; 18.9; 18.9:2; 18.0:; 18.--; 18.-1; 18.-99; 18.-7-; 18.901; 18.92:; 11.920; 11.991; 11.981; 11.9:0; 11.933; 18.-38; 18.930; 18.:1; 18.870; 18.78; 18.18; 18.80:; 18.837; 18.7:; 18.:70; 22.08; 22.:80; 2-.21-; 2-.89; 2-.31-; -.819

-.819

-.81

-.81

-.818

Spreadsheets Analisis Laporan Keuangan.xls

Recommend Documents