Zakat_El_Mall.xls

3 pages
22 views

Please download to get full document.

View again

of 3
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
Zakat Calculation Spreadsheet 02/09/2018 Zakat Calculator ‫حساب الزكاة‬ (Use Only YELLOW cells to fill Values. Please refer to the Appe
Tags
Transcript
  Zakat Calculation Spreadsheet 02/09/2018Page 1 of 3 Zakat Calculator  كزلا   ب سح (Use Only YELLOW cells to fill Values. Please refer to the Appendix Sheet for more explanations on Each Section  ! # $%&')% *+,-)*# /0 )% $,1% Price23mEstimated Value Zakat Payable1ZAKAT ON GO! #$ لا 4%&5)*6 789)% 4%&5)% &:;<+&+= >)% <?0 )%@ Barat 3old2CeDelry   .FF  % @@ Barat 3old2CeDelery   .FF  % GH Barat 3old2CeDelry.FF  % Other 3old ValuaIles. (Pls insert the Burrent Estimated Value  % &ZAKAT ON P'(C)O*+ +TON(+ ,-./0 لا      2 ح 3 ا  % 4ZAKAT ON +)5('  ,67 لا .FF  % 8ZAKAT ON CA+9 )N 9AN! :;ANK  <=>? لا Actual ValueBash in Jand=K 0)% # = MN )%  % Bash in an in SaQinRs Accounts& 0#9>)% T*6* # &?)% # = MN )%  % Bash in an in Burrent Accounts< +X*5)% T*6*)% # &?)% # = MN )%  % Bash held in Zixed [eposits<>6*\)% T*]%=+^% # =_  MN )%  % @ ا     -BD3 ا  E FE/> لا Actual ValueLoans `eceiQaIle from Zriends and `elatiQes$*6&b% $*=b% 1 4,>;) <g6* &  % nQestment in 3oQt onds<019j T%=M; # X*?\>;^%  % ProQident Zund BontriIution to date.  % nsurance Premiums includinR Ionus up to datek=b% ,:)% ) ?>+  01q T%,]  %  % 3oQernment Security [eposits A[`s etc)% <+&; <019j T*]=+%  % nQestment in PriQate Bhits Zunds etc)% <*v w%91% # X*?\>;^%  % Other Sources of Wealth&\N )% 1 &v Xk*1  % ZAKAT ON AN!(! P'OP('TH,.    >I لا   ا     -BD3 ا Estimate Value  % JZAKAT ON ;*+)N(++    -L3 ا Value of SaleaIle Stocz0{g) |6* )% 7}-?)% <?0Value of [amaRed 2 [ead Stoc Amount `eceiQaIle from Bredit Salesk*?>]^% T*:0{1 1 4,>;) <g6* <0?~LESSã ad [eIts TOTA 5A*( OM +TOCKE ز  - لا  QR ,S U ك  ,-SVWXX % YZAKAT ON +9A'( )N PA'TN('+9)P M)'+  ك /[ ل  \ ]^D      \ , ك /[- لا Bapital alance as per Last Ialance Sheet& 0v = 0X <€X* ?)*6 0X =0XLoans AdQanced Iy you to the Zirm as of [ate +Xq>N )% 1 %X*{>]‚ < ~&ƒN )% „)‚ /j>…;%96 †‡ 1=N  ˆ & )% LESSã WithdraDals made Iy you durinR the current Year. N(TT TOTA _O'T9 CAC*AT(!` س  R ب = س   Rd f    g h=-2RWXX % iZAKAT ON AG')C*T*'A P'O!*C(,SL ا  زلا      2?- لا Value of Produce  % % % 1XZAKAT ON AN)A+ j PO*T'H j M)+9 MA')NG-D ,L ا  E ,?m ا < =Sn E      ا =S ح ‰otal Value  % 11 ]pq  ا      q     S ل Es س  R E fvU ل  ,U\    V ,R    L     S ل Es س  R Loans taen from from Zriends 2 `elatiQes  Loans ‰aen from ans 2 nstitutionsncome ‰ax 2 Wealth ‰ax PayaIle TOTA )A;))T)(+,S U ك      S ل Es س  RWXXWXX TOTA ZAKAT PAHA;(  كز  U ل  ,Sw    ^? لا  ,-S> لا WXX WeiRht in 3ŠS@g 2 <0{‹ Œ%&0 @@g 2 <0{‹ Œ%&0 GHg 2 <0{‹ Œ%&0 (<ˆ 0)*)% <?0 )% ‡ 0N?-_ |‡ vk% $*X  .&v <0{‹ <?0Balculate the nett Šaret Value of the Precious stones lie [iamonds `uIies Etc. and add them to the Estimated Value BolumnT*;*?)% |\1 < ?+&~ X*5b ˆ #*N)% Žˆ9)% &:; ‡ ‚ ? -ˆ ?_ )% < ?0 )% k9?] „)‚ /‘'0+_ .)% T9*+nclude Jousehold SilQer Utensils Artefacts and CeDelery. Zor Utensils usually the silQer is ’F“ pure so tae ’F“ of the total DeiRhtT%k”) .„g <+=+ T*]9M1 <ˆ 0>06 <ˆ 0N# Tˆ%k ‡ ?N 79j <')% k*]’F  _ vq‡ ˆ %) <0#* “ ’F789)% 1 “K gj)% ZAKAT ON OAN+ : )N5(+T(NT+: M*N!+: +9A'(+x (TC 7–% =) X*vkN^% Ž=M <?‹*1.Value of Shares (stocs includinR [iQidends. ‰ae their maret Qalue on the date of calculation/‘9; &:; ‡ v_ .—)% ) ?>+ ( z*6  / ‘;b% <?0˜*)%  +Xq „g]Landed Property held as an nQestment 2 usiness (Estimate the current ŠaŽet Value(<0)*)% <09)% <?0 )% 0?- <+X* :)% T%X*?\>;™%†01 7}-1 2 < 6&-ˆ 1_ <?0LESSã Amount PayaIle to Suppliers (Bredit taen from suppliers for stocinR Roods+kXN9?)% 1 ˆ v%ˆ k*?>]‚  +kXN91 „)‚ z#=g) <g6* <0?~ ã|(<€}-1 z  *{) <>0?)% 79+=)% ã| <0)*)% <MN)% w,v /j>…;%96 T‡v% „>)% T*69)% ã|.Accumulated Profit from the date of alance Sheet to this [ate (Estimate the Profit Value as it is difficult to Ret exact fiRures in the middle of AccountinR Yearš 6X 0?-   +Xq>)% %‹ „)‚ = 0&N)%  +Xq 1 z? 5ˆ 1_ š6X˜* › >M1 # <Œ9{1 šˆ {_ 7‡ˆ _ :)% 1 œ€™ < ?0 )%( < MN)%Produce [ependent on `ain Water   GF“ of product (crop in Value or žind  & …?)% $*1 „g] ›9>1 Ÿ‡*>€GFw91  Ÿ*>€^% 1 “9MN )%  < ?0 )% # (Produce totally dependent on Artificial rriRation lie Banal ‰an oreDell etc.   ¡“ of Produce (crop in Value or in žind.)% |01&6 *M )% |\1  ]*M)% ¢&N)% „g] * 0g~ ›9>1 Ÿ‡*>€ ¡9MN )% #  < ?0 )% # ( w91  £ >M?)% 1 “Produce dependent Partially on `ain Water and Partially on Artificial rriRation  ¤.¡“ of the Produce Value or in žind¢X „g] } |jƒ6 & …?)% $*1 „g] } |jƒ6 z ˆ 6* Ÿ‡*>€  ]*M)%¤.¡9MN )% #  £ >M?)% < ?0 1 “Animals2 irds more than ¥ months Old   G Animal or ird PE` F either in žind or Value of the same. &?] 1 &\~ T*€90 2 X90Œ¥  &‘¦ G&0Œ  7%90 |Nj)F§'€ < ?0  < ?0&N)% # *1N . G(N('A )A;))T)(+ % Hou eez to zezuct your z{rect Payable| or {ab{l{t{e| }~{c~ are ot zezuctez aboãe $*6& 2 $*= 1 1 T‡v%ˆ & )%T*;¨1 2 X*1 1 T‡v%ˆ & )%z  #=g) <g6* &© <{+&ª 2 |vk <{+&ª   Appendix: Explanations To be used in conjunction with the Spreadsheet on Zakat Calculator  Page 2 of 3 Dear Brothers & Sisters,Details of Each Section to be used in conjunction with the Calculation Spreadsheet.1Zakat on Pure old and old !eweller #Zakat on Precious and Se$i%Precious Stones One may calculate the saleable value of Items at hand on the date of Zakat Calculaton! Zakat on Sil'er.(Zakat on Cash and Bank Balances ou may make you# best $udgement and the best %ay s to &ay on #emanng amount on the day of calculaton )Zakat on *oans i'en, +unds, etcZakat on *anded Propert  'lhamdulllah( the month of )amadhan has been besto%ed u&on us by 'llah! Z'*'+ s one of the fve fundamental &lla#s of Islam( mandato#y on all muslms %ho a#e of elgble %ealth! Zakat s due f#om and &ayable by a &e#son on hs %ealth ,and not hs ncome-( %hch has #emaned %th hm/he# fo# one Islamc yea#!It s dffcult to calculate the com&leton of one yea# on each tem of %ealth( because &u#chase dates may va#y! +o ove#come ths dffculty( a &#actcal method s to f. a date ,e!g! 1st of )amadhan-( com&ute you# total %ealth on that date and calculate Zakat( the#eon!+he attached s&#eadsheet s a humble attem&t at makng the calculaton &#ocess sm&le and consoldated( fo# all b#othe#s and sste#s %ho a#e fo#tunate to be %o#thy of &ayng Zakat! If the#e a#e any e##o#s( ts &u#ely due to my ncom&#ehenson and may be b#ought to my notce mmdtly by emal at a$ameelyahoo!com! Please #emembe# me n you# su&&lcatons and may 'llah gve us all the #e%a#ds of both %o#lds! 'ameen! ou#s #othe# n Islam( -rif !a$eel. Zakat should be calculated at 2! of the ma#ket value as on the date of valuaton ,In ou# case %e consde# 1st of )amadhan-! ost 4lema favou# the a#ket 5alue &#evalng as on the date of Calculaton and not the &u#chase &#ce! ' )educton of 2 f#om the %eght of 6e%elle#y can be allo%ed to%a#ds studded stones $e%elle#y 7 2 f#om the %eght of *4' 6e%elle#y!+he#e s some contenton on %hethe# these a#e to be consde#ed fo# valuaton! In my humble o&non f they have a value( then they calculate to%a#ds you# %ealth( and t s on the %ealth that Zakat s mandato#y!Zakat s to be &ad on :lve# n Pu#e fo#m o# 6e%elle#y( 4tensls( eco#atve tems and all household tems ncludng c#ocke#y( cutle#y made of slve# at 2! of the &#evalng ma#ket #ates!Zakat should be &ad at 2! on all cash balance and bank balances n you# savngs( cu##ent o# ; accounts! +he amount techncally should be n the bank fo# one yea#! 4sually t ha&&ens that the balance kee&s on changng as &e# &e#sonal #e<u#ements!Zakat s &ayable by you on loans you have gven to you# f#ends and #elatves! It should be t#eated as Cash n =and! ou may deduct >oans Payable by you to a##ve at the nett &#esent value of you# %ealth!Zakat s &ayable on all ?ovt onds( Publc :ecto# ond( &ad@u& Insu#ance &#emums( you# &ad@u& &o#ton of P#ovdent ;unds( ?ovt lls #ecevables( etc! Zakat s not &ayable on &e#sonal #esdental =ouse even f you have mo#e than one and meant fo# #esdental &u#&ose only! 'lso Zakat s not a&&lcable on P#o&e#ty gven on #ent ##es&ectve of ho% many! =o%eve# Zakat s &ayable on the #ental ncome!=o%eve# f you# ntenton of holdng &#o&e#tes s to sell at a futu#e date fo# a &#oft o# as an nvestment( then Zakat s &ayable on the a#ket 5alue! 'lso( f you# ntenton of holdng &#o&e#tes changes n the cu##ent yea#( I!e! f#om self use to busness then you need to &ay Zakat on that P#o&e#ty 5alue   Appendix: Explanations To be used in conjunction with the Spreadsheet on Zakat Calculator  Page 3 of 3 Zakat on Business/0Zakat on Partnership +ir$s. +hs can only be estmated as t s dffcult to calculate the e.act &#oft o# loss bet%een an accountng yea#! Zakat on -2ricultural Product +he fo#mula fo# Zakat calculaton on 'g#cultu#e s as follo%sA 13Zakat on -ni$als11*iabilities Deductions +hs s fo# usness Pe#sons only! o matte# %hat busness you a#e nto( youBve got to &ay Zakat on all :+OC*@I@+)'! +he stock must be valued at ts >anded Cost P#ce! If you have any blls #ecevable ,sales gven on c#edt- then you need to add the same to%a#ds calculatons!educt the 'mounts due to you# su&&le#s and deduct the loans on stock on the date of calculaton! ead :tock should be calculated on sc#a& value o# ts saleable value! amaged stock should also be valued at ts sc#a& value! e honest n the calculatons( as Z'*'+ s an I:4)'C on you# :+OC* d#ectly f#om '>>'= and %ho bette# an nsu#e# than =m! +he#e s no Zakat on ;acto#y uldngs o# any knd of machne#y( but the#e s Dakat on &#oducts &#oduced n the facto#y ,!e! fnshed goods value-! Please #efe# to a com&etent oulv o# a schola# %ho can shed mo#e lght on you# s&ecfc ssues!Zakat can be &ad I+=) by the f#m O) se&a#ately by the o%ne#s! If the f#m s not &ayng( and the &a#tne# %ants to calculate hs sha#e( he should take the amount standng to hs ca&tal and loan account as &e# the last balance sheet! 'dd hs estmated sha#e of &#oft tll the date Dakat s calculated!Zakat s &ayable on all 'g#cultu#al &#oduce ncludng f#uts( comme#cally g#o%n flo%e#s( vegetables and all ty&es of g#ans at the ha#vest tme tself! +he &assng of One yea# does not a&&ly fo# ag#ultu#al &#oduce! If the#e a#e t%o o# mo#e c#o&s on the same land &e# yea#( then Zakat has to be &ad as many tmes on the c#o&( ##es&ectve of the tme!On c#o&s de&endent &u#ely on #an %ate# t %ll be 10 of &#oduce( On c#o&s not ##gated th#ough #an %ate# but use Canal Eate#( +ank Eate#( o#e%ell and O&en %ells( the Zakat s  of the &#oduce! ;o# C#o&s de&endent &a#tly on )an Eate# and &a#tly on othe# %ate#( the Zakat a&&lcable %ould be F! of &#oduce! On all g#aDng anmals lke goats( shee( camel( co%s( b#ole# chckens( the consensus Zakat &ayable s one anmal/b#d fo# eve#y G0 anmals o%ned! =o%eve# you may %sh to gve cash n leu of the anmal/b#d tself!Please consult you# local :chola# o# aulv o# Imaam %ho can gude you to the #ght d#ecton( o# #efe# to books of ;<h f you %ould lke to have f#st hand conf#maton of the stuaton! If you have any &endng ta. &ayable to the govt( as of the date of Zakat Calculaton( then the same may be deducted befo#e a##vng at the net %o#th! If you have taken any loans f#om any &e#son o# nsttuton( and f you have not al#eady deducted the same f#om any of the above sectons( then you can deduct you# Payables ove# he#e! Please be t#uthful( as Zakat s a su#e %ay of &#otectng ones %ealth f Zakat has been &ad on t #egula#ly and fully!;OO+O+A Please note that Inte#est n any fo#m s =a#am and st#ctly &#ohbted! :o &lease stay a%ay f#om takng >oans on Inte#ests ' Collecton of Inte#ests f#om any body o# nsttuton!
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks