Teachers Manual Velin Ini.xlsx

  • Uploaded by: Ria R Sagala
  • 0
  • 0
  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Teachers Manual Velin Ini.xlsx as PDF for free.

More details

  • Words: 1,105
  • Pages: 10
KETERANGAN

Total

Modal Sendiri

A. INVESTASI HARTA TETAP 1. Tanah

Rp

10,500,000,000 Rp

5,250,000,000

2. Bangungan

Rp

189,600,000 Rp

94,800,000

3. Mesin & Peralatan

Rp

5,000,000 Rp

2,500,000

4. Inventaris Kantor

Rp

2,000,000 Rp

1,000,000

5. Kendalaraan

Rp

500,000 Rp

250,000

6. Lainnya

Rp

500,000 Rp

250,000

Total Harta Tetap

Rp

10,697,600,000 Rp

5,348,800,000

1. Rencana Usaha

Rp

1,000,000 Rp

500,000

2. Perijinan

Rp

20,000 Rp

10,000

3. Pelatihan

Rp

1,000,000 Rp

500,000

4. Produk Percobaan

Rp

70,000,000 Rp

35,000,000

5. Lainnya

Rp

1,000,000 Rp

500,000

Total Pra-Operasi

Rp

73,020,000 Rp

36,510,000

C. TOTAL INVESTASI (A+B)

Rp

B. INVESTASI PRA-OPERASI

10,770,620,000

Rp

5,385,310,000

D. MODAL KERJA

BIAYA POKOK PRODUKSI

1. Bahan baku & Pembantu

Rp

40,000,000

2. Upah langsung

Rp

5,000,000

3. Biaya Umum Kas

Rp

2,000,000

Total Biaya Produksi

Rp

47,000,000

1. Biaya Adm Umum Kas

Rp

3,000,000

2. Biaya Pemasaran Kas

Rp

3,000,000

Total Biaya Usaha

Rp

6,000,000

TOTAL BIAYA OPERASI/TH

Rp

53,000,000

BIAYA USAHA

TOTAL MODAL KERJA

Rp

53,000,000 Rp

26,500,000

TOTAL BIAYA PROYEK (C+D)

Rp

10,823,620,000 Rp

5,411,810,000

Prosentase (%)

Kredit

Rp

5,250,000,000

Rp

94,800,000

Rp

2,500,000

Rp

1,000,000

Rp

250,000

Rp

250,000

Rp

5,348,800,000

Rp

500,000

Rp

10,000

Rp

500,000

Rp

35,000,000

Rp

500,000

Rp

36,510,000

Rp

5,385,310,000

Rp

26,500,000

Rp

5,411,810,000

tanah bangunan alat dan mesin kantor surat sarana prasarana pemasaran admin

Rp Rp Rp Rp Rp Rp Rp Rp

10,500,000,000 189,700,000 6,200,000 15,840,000 8,595,000 100,000,000 2,000,000 2,500,000

umum

Rp Rp Rp Rp Rp

5,000,000 10,829,835,000 21,659,670,000 4,331,934,000 17,327,736,000

9000

Keterangan

Th1

Th2

Th3

Rp

176,000,000 Rp

352,000,000 Rp

1,056,000,000

1. Bahan Baku & Penolong

Rp

100,000,000 Rp

200,000,000 Rp

600,000,000

2. Tenaga Kerja Produksi

Rp

20,000,000 Rp

40,000,000 Rp

120,000,000

3. Biaya Umum Pabrik (kas)

Rp

5,000,000 Rp

10,000,000 Rp

30,000,000

Rp

125,000,000 Rp

250,000,000 Rp

750,000,000

Rp

51,000,000 Rp

102,000,000 Rp

306,000,000

1. Biaya Admin Umum (kas)

Rp

3,000,000 Rp

4,500,000 Rp

6,000,000

2. Biaya Pemasaran (kas)

Rp

3,000,000 Rp

4,500,000 Rp

6,000,000

Rp

6,000,000 Rp

12,000,000 Rp

18,000,000

3. Biaya Penyusutan

Rp

5,280,000 Rp

10,560,000 Rp

31,680,000

4. Biaya Amortisasi

Rp

4,500,000 Rp

8,050,000 Rp

20,505,000

E. TOTAL BIAYA USAHA

Rp

17,280,000 Rp

31,560,000 Rp

61,680,000

F. LABA USAHS (C-E)

Rp

33,720,000 Rp

70,440,000 Rp

244,320,000

7.25%

8.25%

A. PENDAPATAN B. BIAYA POKOK PRODUKSI

Total Biaya Produksi C. LABA USAHA (A-B) D. BIAYA USAHA

Total Biaya Usaha

G. BUNGA

8.25%

H. LABA SEBELUM PAJAK

Rp

31,275,300 Rp

64,628,700 Rp

224,163,600

I. PAJAK

Rp

189,600 Rp

208,560 Rp

227,520

J. LABA BERSIH

Rp

31,085,700 Rp

64,420,140 Rp

223,936,080

K. BEP (E/C)*100%

Rp

0 Rp

0 Rp

0

L. Profit Margin (A/J)x100%

Rp

6 Rp

5 Rp

5

Th4

Th5

Rp

1,408,000,000 Rp

1,760,000,000

Rp

800,000,000 Rp

1,000,000,000

Rp

160,000,000 Rp

200,000,000

Rp

40,000,000 Rp

50,000,000

Rp

1,000,000,000 Rp

1,250,000,000

Rp

408,000,000 Rp

510,000,000

Rp

7,500,000 Rp

9,000,000

Rp

7,500,000 Rp

9,000,000

Rp

15,000,000 Rp

18,000,000

Rp

42,240,000 Rp

52,800,000

Rp

38,000,000 Rp

45,000,500

Rp

72,240,000 Rp

88,800,000

Rp

335,760,000 Rp

421,200,000

8.25%

176000000

8.25%

Rp

308,059,800 Rp

386,451,000

Rp

246,480 Rp

Rp

307,813,320 Rp

Rp

0 Rp

0

Rp

5 Rp

5

265,440 Rp 386,185,560 Rp

37,920,000 189,600

KETERANGAN

Tahun 1

Tahun 2

Tahun 3

A. ARUS KAS MASUSK 1. Penjualan Tunai

Rp

2. Piutang

-

3. Modal Sendiri

Rp

85,000,000.00 Rp

170,000,000.00 Rp

528,000,000.00

4. Kredit Investasi

Rp

90,000,000.00 Rp

180,000,000.00 Rp

400,000,000.00

5. Kredit Modal Kerja

Rp

26,500,000.00 Rp

53,000,000.00 Rp

100,000,000.00

6. Saldo Kas Awal

Rp

50,000,000.00 Rp

175,000,000.00 Rp

200,000,000.00

Rp

427,500,000.00 Rp

930,000,000.00 Rp

2,284,000,000.00

1. Investasi

Rp

5,385,310,000.00 Rp

10,770,620,000.00 Rp

32,311,860,000.00

2. Biaya Pokok Produksi (kas)

Rp

47,000,000.00 Rp

70,500,000.00 Rp

84,600,000.00

3. Biaya usaha (kas)

Rp

6,000,000.00 Rp

9,000,000.00 Rp

10,800,000.00

TOTAL KAS MASUK

176,000,000.00 Rp

352,000,000.00 Rp

-

1,056,000,000.00

-

B. ARUS KAS KELUAR

4. Bunga 5. Pajak

7.25%

Rp

189,600 Rp

8.25%

208,560 Rp

8.25%

227,520

TOTAL KAS KELUAR

Rp

5,438,499,600 Rp

10,850,328,560 Rp

32,407,487,520

C. KAS NETTO (A-B)

Rp

(5,010,999,600) Rp

(9,920,328,560) Rp

(30,123,487,520)

1. Angsuran Kredit Investasi

Rp

5,000,000.00 Rp

10,000,000.00 Rp

60,000,000.00

2. Angsuran Kredit M Kerja

Rp

5,000,000.00 Rp

10,000,000.00 Rp

30,000,000.00

TOTAL KEWAJIBAN BANK Rp

10,000,000 Rp

20,000,000 Rp

90,000,000

(5,020,999,600) Rp

(9,940,328,560) Rp

(30,213,487,520)

D. KEWAJIBAN BANK

E. SALDO KAS AKHIR (CD)

Rp

Tahun 4

Rp

Tahun 5

1,408,000,000.00 Rp

-

1,760,000,000.00

-

Rp

704,000,000.00 Rp

880,000,000.00

Rp

500,000,000.00 Rp

650,000,000.00

Rp

125,600,000.00 Rp

150,700,000.00

Rp

225,000,000.00 Rp

250,000,000.00

Rp

2,962,600,000.00 Rp

3,690,700,000.00

Rp

43,082,480,000.00 Rp

53,853,100,000.00

Rp

112,800,000.00 Rp

122,200,000.00

Rp

14,400,000.00 Rp

15,600,000.00

8.25%

Rp

246,480 Rp

8.25%

265,440

Rp

43,209,926,480 Rp

53,991,165,440

Rp

(40,247,326,480) Rp

(50,300,465,440)

Rp

80,000,000.00 Rp

100,000,000.00

Rp

80,000,000.00 Rp

100,000,000.00

Rp

160,000,000 Rp

200,000,000

Rp

(40,407,326,480) Rp

(50,500,465,440)

KETERANGAN

Tahun 1

Tahun 2

Tahun 3

I. HARTA A. HARTA LANCAR 1. Kas

Rp

427,500,000 Rp

2. Piutang

Rp

- Rp

3. Persediaan

Rp

50,000,000 Rp

Total Harta Lancar Rp

930,000,000 Rp 2,284,000,000 175,000,000 Rp

200,000,000

477,500,000 Rp 1,105,000,000 Rp 2,484,000,000

B. HARTA TETAP 1. Tanah

Rp

2. Bangunan

Rp

189,600,000 Rp

379,200,000 Rp

568,800,000

3. Mesin & Peralatan

Rp

5,000,000 Rp

10,000,000 Rp

15,000,000

4. Inventaris Kantor

Rp

2,000,000 Rp

4,000,000 Rp

6,000,000

5. Kendaraan

Rp

500,000 Rp

1,000,000 Rp

1,500,000

6. Lain-lain

Rp

500,000 Rp

1,000,000 Rp

1,500,000

Total Harta Tetap Akumulasi Penyusutan Nilai Buku Harta Tetap C. INVESTASI PRA OPERASI

Rp

10,500,000,000 Rp 21,000,000,000 Rp 31,500,000,000

10,697,600,000 Rp 21,395,200,000 Rp 32,092,800,000

Rp

5,280,000 Rp

10,560,000 Rp

31,680,000

Rp

2,000,000 Rp

4,000,000 Rp

6,000,000

Akumulasi Amortisasi

Rp

4,500,000 Rp

8,050,000 Rp

20,505,000

Nilai Buku Harta Tak berwujud

Rp

1,500,000 Rp

3,000,000 Rp

4,500,000

TOTAL HARTA (A+B+C)

Rp

11,188,380,000 Rp 22,525,810,000 Rp 34,639,485,000

II. HUTANG DAN MODAL A. HUTANG LANCAR 1. Hutang Dagang 2. Kredit Modal Kerja Total Hutang Lancar B. HUTANG JANGKA PANJANG 1. Hutang investasi Total Hutang Jangka Panjang C. MODAL

Rp 20,000,000

Rp40,000,000

Rp60,000,000

Rp 26,500,000

Rp53,000,000

###

Rp 46,500,000

Rp93,000,000

###

###

###

###

###

###

###

1. Modal Sendiri 2. Laba Periode lalu 3. Laba

Rp 85,000,000

###

###

Rp

-

Rp31,085,700

Rp64,420,140

Rp 31,085,700

Rp64,420,140

###

Total Modal

Rp 116,085,700

###

###

###

###

###

TOTAL HUTANG DAN MODAL ROI (%)

Tahun 4

Tahun 5

Rp

2,962,600,000 Rp

3,690,700,000

Rp

225,000,000 Rp

250,000,000

Rp

3,187,600,000 Rp

3,940,700,000

Rp

42,000,000,000 Rp

52,500,000,000

Rp

758,400,000 Rp

948,000,000

Rp

20,000,000 Rp

25,000,000

Rp

8,000,000 Rp

10,000,000

Rp

2,000,000 Rp

2,500,000

Rp

2,000,000 Rp

2,500,000

Rp

42,790,400,000 Rp

53,488,000,000

Rp

42,240,000 Rp

52,800,000

Rp

8,000,000 Rp

10,000,000

Rp

38,000,000 Rp

45,000,500

Rp

6,000,000 Rp

7,500,000

Rp

46,072,240,000 Rp

57,544,000,500

Rp 106,000,000

Rp

100,000,000

Rp 125,600,000

Rp

150,700,000

Rp 231,600,000

Rp

250,700,000

###

Rp53,853,100,000

###

Rp53,853,100,000

Rp 704,000,000

Rp

880,000,000

Rp 223,936,080

Rp

307,813,320

Rp 307,813,320

Rp

386,185,560

Rp1,235,749,400

Rp 1,573,998,880

###

###

Related Documents


More Documents from "ALEJANDRO"

343673_hammer Test.pdf
November 2019 14
Wirus Ini.docx
November 2019 5
Uji Lengkung Baja.docx
November 2019 4
November 2019 5
Coba2.docx
November 2019 9