Minggu, 16 Maret 2014

Cara Menghitung Pajak PPh 21 Dengan Excel

RUMUS EXCEL LENGKAP

Cara Menghitung Pajak PPh 21 Dengan Excel

Materi kursus online microsoft excel kali ini berusaha menjawab pertanyaan – Bagaimana cara menghitung Pajak Penghasilan Pasal 21 atau PPh 21 dengan Excel? Ini merupakan suatu pertanyaan yang akan ditanyakan Wajib Pajak atau orang yang terkena pajak, jika mendapat rekomendasi untuk menghitung PPh 21 terutang dengan bantuan Excel.

Caranya tentu sangat mudah, dengan menggunakan beberapa fungsi dan rumus penghitungan PPh 21 dengan bantuan Excel ini bisa diselesaikan dengan cepat dan tepat. Mari jangan berlama-lama, kita langsung saja kepada prakteknya menghitung PPh 21 terutang.

Langkah pertama, siapkan 2 (dua) Worksheet atau lembar kerja pada Excel.

1. Worksheet pertama (Hitung PPh 21), berisikan data penghitungan PPh 21. Misalnya Wajib Pajak memperoleh penghasilan per bulan Rp 2.500.00 maka penghasilan disetahunkan Rp 30.000.000 sebagai berikut.

menghitung pajak dengan excel 1 Cara Menghitung Pajak PPh 21 Dengan Excel2. Worksheet kedua (Data Tarif), berisikan data Tarif PPh 21 sebagai berikut.

menghitung pajak dengan excel 2 Cara Menghitung Pajak PPh 21 Dengan ExcelSelanjutnya untuk menentukan Status tanggungan pada Worksheet pertama, gunakan fungsi Combo Box, data dari Status tanggungan tersebut didapat dari Worksheet kedua. Misal status K/1 (Menikah dengan 1 tanggungan anak) adalah Rp 28.350.000

menghitung pajak dengan excel 3 Cara Menghitung Pajak PPh 21 Dengan ExcelSelanjutnya mengisi penghasilan bruto, dengan masukan =E6 pada sel E11. Kemudian untuk menghitung biaya jabatan tempatkan kursor pada sel E13 dan isikan =IF((E11*0.06)>6000000,6000000,(E11*0.06)). Mka hasilnya sebesar Rp 1.800.000, ini didapat dari 15 % x 30.000.000.

menghitung pajak dengan excel 4 Cara Menghitung Pajak PPh 21 Dengan ExcelSelanjutnya untuk menghitung penghasilan neto adalah =E11-E13 atau penghasilan bruto dikurangi biaya jabatan hasilnya Rp 28.200.000, untuk menentukan besar PTKP hasilnya akan sama dengan status tanggungan Rp 28.350.000. kemudian untuk jumlah PKP yaitu =E14-E15 atau jumlah penghasilan neto dikurangi PTKP hasilnya Rp 150.000.

menghitung pajak dengan excel 5 Cara Menghitung Pajak PPh 21 Dengan ExcelSetelah jumlah PTKP dan PKP didapat, maka selanjutnya menghitung PPh 21 terutang, caranya jumlah PKP di kali tarif pasal 17 ayat 1 huruf a UU PPh, yaitu Rp 150.000 x 5% atau pada sel E18 isikan =D18*B18 maka hasilnya adalah sebesar Rp 7.500. Dan Jumlah PPh 21 terutang yang harus dibayarkan kepada kantor pajak adalah sebesar Rp Rp 7.500 per bulan.

menghitung pajak dengan excel 6 Cara Menghitung Pajak PPh 21 Dengan ExcelKesimpulan, Menghitung PPh 21 dengan Excel ini sangat membantu untuk Wajib Pajak, karena seperti yang diketahui, dalam melakukan pembayaran PPh 21 terutang, Wajib Pajak diberi tanggung jawab untuk dapat menghitung sendiri jumlah PPh 21 terutang tersebut. Maka dengan adanya fungsi dan rumus PPh 21 Excel ini semoga dapat membantu Wajib Pajak.

Begitulah materi kursus online tentang penggunaan excel untuk menghitung pajak PPh 21 ini tentu masih banyak kekurangan disana sini namun berharap  ada sedikit manfaatnya. Semoga Sukses Selalu.



R Programming: Tutorial Program Aplikasi Software Statistik

Tutorial Membuat Website Sendiri Gratis Template Website Iklan Rumah

Tutorial Matlab: Modul Belajar Contoh Aplikasi Program

Menjadi Instruktur iTutor

Cara Membuat Website Sendiri Gratis Template

Cara Membuat Website Sendiri (Website Iklan Baris)

Cara Membuat Website Gratis Template

Cara Membuat Web Komunitas Seperti Facebook

Cara Membuat Facebook dan Twitter Menggunakan Template

Cara Membuat Blog, Toko Online, Iklan Google, Promosi Produk Afiliasi

Cara Membuat Aplikasi Android: Contoh Aplikasi Android Game dan Memonetasinya

Belajar Visual Basic: Video Tutorial Aplikasi Program

Belajar Microsoft Excel: 100% Video Tutorial Lengkap

Belajar Javascript: 100% Video Tutorial ---

cek kursus kami

Manajemen Data Menggunakan Stata

Analisa Data Susenas Menggunakan Stata

data panel menggunakan stata

regresi logistik dengan spss

kursus snse dan spa

cara menggunakan oxmetrics

analisa input output

kursus ahp analythical hierarchy process

analisa regresi spss

arima garch var ecm menggunakan stata

logit tobit probit panel logit stata menggunakan stata

ifls tutorial menggunakan stata

dynamic panel data menggunakan stata

data envelopment analysis (dea)

belajar cara menggunakan eviews

belajar cara menggunakan spss

kursus cara menggunakan stata ======

Sabtu, 15 Maret 2014

How Avoiding Electric Shocks That Will Kill You

Your body is a delicate machine. Electric shocks, depending on certain conditions, can be fatal, even at relatively low voltages. What comes out of your wall outlet is deadly if you play around with it. Even electrical gadgets working off batteries can cause you serious damage.

How voltage and current can get you

Your body is like a big resistor. Usually, your body's resistance is high enough to prevent damage when you're exposed to low voltages. However, certain conditions can lower your body's resistance, lowering the amount of voltage needed to cause you serious damage, such as giving you a nasty burn. Those conditions might include handling electronics with sweaty palms or trying to change your 12 volt (V) car battery on a rainy day — either can turn a slight tingle into a fatal event.
Both AC (alternating current, such as the power from your wall outlet) and DC (direct current, such as from a battery) voltage can damage you in different ways:
  • AC voltage: This type of voltage regularly reverses direction. This can cause your heart to shift its regular beating pattern in a condition known as ventricular fibrillation. If this happens, your heart muscles go out of whack in a way that causes blood to stop pumping. In this situation, even if you cut the current, your heart might not be able to find its proper rhythm, and you could die.
  • DC voltage: This type of voltage is on constantly and causes your muscles to contract and seize up quickly (including your heart muscle). If you grab an electrical device in conditions that cause your body to conduct DC voltage, your hands could become frozen (unable to let go of the device), and your heart could stop. If someone cuts the current quickly, though, your heart might begin to beat again (and you'll be able to attend that Rotary luncheon next week).
Short of killing you, electric shock can cause burns as the current dissipates across your body's natural resistance (that is, your skin).

How much is too much?

Most resistance in your body is in your skin. If your skin is wet or damp, that resistance is lowered. If you handle an electrical device with damp hands, even voltages under 20V or so (not enough to even light a low-wattage lamp) might be sufficient to do you serious damage. The 120V coming out of your electrical outlet has a lot of punch: more than enough to kill you.
Four AA batteries in series generate only about 6V. Just because AA batteries don't have a high voltage output, don't think that they can't hurt you. If you short them out, all the electrons will flow quickly from the negative to the positive poles and generate a lot of heat — enough heat, in some cases, to destroy the battery and possibly burn you. If you feel heat coming from your circuit or the batteries, you might have a short-circuit or a component inserted the wrong way. Turn it off and let things cool down; then check to see what's causing the problem.
The resistance in your body can vary greatly. For example, if you have sweaty hands and touch a live wire with one hand while the other hand rests on a metal table, this is a very dangerous situation. Because you have moisture on your hands — which lowers your contact resistance — a higher current will flow through your body for a given voltage. If you have dry hands — one hand touching a live wire, the other hand in your pocket — and your feet on a dry, rubber mat, there's far less danger from the same amount of voltage because your resistance is higher. However, if a higher voltage comes your way, even with the higher resistance, you could die. Bottom line: There is no iron clad rule as to what level of voltage will kill or seriously injure a person because of all the variables.
Regardless of how much voltage you work with, develop safe work habits now.

Common sense: Protecting yourself from getting shocked

Although you should always use care working with electricity, especially avoid some common situations that could turn your body into a super conductor. You know you shouldn't stick your finger into an electrical outlet, but you should also get into some other good habits. Read on.

Rings are out

Metal is a dandy conductor. Wearing rings or other metal jewelry around electricity is a lousy idea. For example, when the skin on your finger is surrounded by a ring (a terrific contact point) and you touch a voltage source, your body's resistance can be very low. In that state, even a lower voltage jolt could do you serious damage. Leave jewelry somewhere else — including your wedding ring — when working with electricity.
Another good reason to avoid jewelry is that it can snag on things. Imagine working on a breadboard filled with wires and tiny components, only to have your ring or necklace catch on something and yank it out. At the least, you have to put the component back in place; at the worst, you could damage the component and have to replace it.

Beware of water!

Don't work in a wet environment (say, outdoors on a rainy day, or while standing on a damp garage floor). This prevention might seem obvious, but consider that cup of coffee on your workbench. What would happen if you knocked it over while working with electricity? You need to become super careful about anything wet or moist in or near your work area. This includes you: If you just came in out of the rain or from a run, dry off before working on electrical equipment.

Respect electricity

Here's one simple rule that you should memorize right now: Never touch a component in a circuit that has power (an energized circuit). Turn off all power sources or remove the source from the circuit entirely before touching it.
One trick that electricians use is to keep their left hands in their pockets when working with electrical equipment. If a zap occurs, it will flow from their right hands to the ground — not from hand to hand, passing right through the heart. You shouldn't be working with live electricity — ever! — but this trick of trade used by more advanced users shows how important it is to understand how electricity works and respect its authority.
Even when the source is removed, some electricity might remain. To be absolutely sure, before you touch anything, test the circuit with your multimeter. And don't take somebody else's word that the power is off; always check and double-check this yourself!
Don't work with AC-operated circuits unless you absolutely have to. And if you do, it might not be a bad idea to have a friend nearby who is trained in CPR. The Red Cross has more information about CPR training.


R Programming: Tutorial Program Aplikasi Software Statistik

Tutorial Membuat Website Sendiri Gratis Template Website Iklan Rumah

Tutorial Matlab: Modul Belajar Contoh Aplikasi Program

Menjadi Instruktur iTutor

Cara Membuat Website Sendiri Gratis Template

Cara Membuat Website Sendiri (Website Iklan Baris)

Cara Membuat Website Gratis Template

Cara Membuat Web Komunitas Seperti Facebook

Cara Membuat Facebook dan Twitter Menggunakan Template

Cara Membuat Blog, Toko Online, Iklan Google, Promosi Produk Afiliasi

Cara Membuat Aplikasi Android: Contoh Aplikasi Android Game dan Memonetasinya

Belajar Visual Basic: Video Tutorial Aplikasi Program

Belajar Microsoft Excel: 100% Video Tutorial Lengkap

Belajar Javascript: 100% Video Tutorial ---

cek kursus kami

Manajemen Data Menggunakan Stata

Analisa Data Susenas Menggunakan Stata

data panel menggunakan stata

regresi logistik dengan spss

kursus snse dan spa

cara menggunakan oxmetrics

analisa input output

kursus ahp analythical hierarchy process

analisa regresi spss

arima garch var ecm menggunakan stata

logit tobit probit panel logit stata menggunakan stata

ifls tutorial menggunakan stata

dynamic panel data menggunakan stata

data envelopment analysis (dea)

belajar cara menggunakan eviews

belajar cara menggunakan spss

kursus cara menggunakan stata ======