ࡱ> [  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ]^_`abcdefghijklmnopqrstuvwxyz{|}~RF njCWorkbookBook \ySummaryInformation( N\pimac se Ba==x<8"8@"1Arial1Arial1Arial1Arial1 Arial1$Arial1 Arial1Arial1Arial1Arial1Arial1 Arial1QTahoma1Arial1Arial1 Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.0050_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-$"_._."\ #,##0_-;"_._."\ #,##0\-)$"_._."\ #,##0_-;[Red]"_._."\ #,##0\-*%"_._."\ #,##0.00_-;"_._."\ #,##0.00\-/*"_._."\ #,##0.00_-;[Red]"_._."\ #,##0.00\-D?_-"_._."\ * #,##0_-;_-"_._."\ * #,##0\-;_-"_._."\ * "-"_-;_-@_-,'_-* #,##0_-;_-* #,##0\-;_-* "-"_-;_-@_-LG_-"_._."\ * #,##0.00_-;_-"_._."\ * #,##0.00\-;_-"_._."\ * "-"??_-;_-@_-4/_-* #,##0.00_-;_-* #,##0.00\-;_-* "-"??_-;_-@_-"KD"#,##0;\-"KD"#,##0"KD"#,##0;[Red]\-"KD"#,##0 "KD"#,##0.00;\-"KD"#,##0.00% "KD"#,##0.00;[Red]\-"KD"#,##0.0083_-"KD"* #,##0_-;\-"KD"* #,##0_-;_-"KD"* "-"_-;_-@_-@;_-"KD"* #,##0.00_-;\-"KD"* #,##0.00_-;_-"KD"* "-"??_-;_-@_- "$"#,###.## #,###.0083_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)                  + ) , *  +  33+ #33+  33 + #33  ( (  (!@ (8!@    8!@  * * (* #* + *  *  * !@ *  !@ * #!@ *  !@ *  !@ *  * #*  * #*  !@ #!@ *  *  !@ * #!@ *   !@ *   *  *   *  #*  #!@ *  !@ *   !@ *  #!@ *  !@ *   * #*  * (* !@ * (* (*  (!@ *  (*  (!@ *  * !@ * !@ * !@ * !@ * *  *  * # *  * (  *  * Followed Hyperlink Hyperlink83ffff̙3f3fff3f3f33333f33333\`+> Calculations ESummary and InstructionsSheet3"  ;?  ;iaZR  3  @@   fep(Use Only YELLOW cells to fill Values. Please refer to the Appendix Sheet for more explanations on Each Section)Zakat should be calculated at 2.5% of the market value as on the date of valuation (In our case we consider 1st of Ramadhan). Most Ulema favour the Market Value prevailing as on the date of Calculation and not the purchase price.Value of Damaged / Dead Stock#Amount Receivable from Credit SalesRLESS: Amount Payable to Suppliers (Credit taken from suppliers for stocking goods)LESS: Bad DebtsTOTAL VALUE OF STOCK#ZAKAT ON SHARE IN PARTNERSHIP FIRMS)Capital Balance as per Last balance Sheet,Loans Advanced by you to the Firm as of Date7LESS: Withdrawals made by you during the current Year.Accumulated Profit from the date of Balance Sheet to this Date (Estimate the Profit Value as it is difficult to get exact figures in the middle of Accounting Year)NETT TOTAL WORTH CALCULATEDZAKAT ON AGRICULTURAL PRODUCEValue of ProduceJProduce Dependent on Rain Water - @ 10% of product (crop) in Value or KindProduce totally dependent on Artificial Irrigation like Canal, Tank, Borewell, etc. - @ 5% of Produce (crop) in Value or in KindwProduce dependent Partially on Rain Water and Partially on Artificial Irrigation - 7.5% of the Produce Value or in Kind)ZAKAT ON ANIMALS & POULTRY & FISH FARMING Total ValuegAnimals/ Birds more than 6 months Old - @ 1 Animal or Bird PER 40 either in Kind or Value of the same.)Loans taken from from Friends / Relatives%Loans Taken from Banks / InstitutionsIncome Tax / Wealth Tax PayableTOTAL LIABILITIESTOTAL ZAKAT PAYABLE%Zakat on Pure Gold and Gold Jewellery*Zakat on Precious and Semi-Precious StonesZakat on Silver.Zakat is to be paid on Silver in Pure form or Jewellery, Utensils, Decorative items and all household items including crockery, cutlery made of silver at 2.5% of the prevailing market rates.Zakat on Cash and Bank Balances Zakat on Loans Given, Funds, etcZakat on Landed PropertyZakat on Business:Zakat on Partnership Firms.Zakat on Agricultural ProductZakat on AnimalsLiabilities DeductionsiGENERAL LIABILITIES - You need to deduct your direct Payables or Liabilities which are not deducted above@On crops dependent purely on rain water it will be 10% of produce, On crops not irrigated through rain water but use Canal Water, Tank Water, Borewell and Open wells, the Zakat is 5% of the produce. For Crops dependent partly on Rain Water and partly on other water, the Zakat applicable would be 7.5% of produce. On all grazing animals like goats, shee, camel, cows, broiler chickens, the consensus Zakat payable is one animal/bird for every 40 animals owned. However you may wish to give cash in lieu of the animal/bird itself.Please consult your local Scholar or Maulvi or Imaam who can guide you to the right direction, or refer to books of Fiqh if you would like to have first hand confirmation of the situation.Zakat Calculator Weight in GMSPrice/GmEstimated Value Zakat Payable ZAKAT ON GOLD24 Carat Gold/Jewelry22 Carat Gold/Jewelery18 Carat Gold/Jewelry?Other Gold Valuables. (Pls insert the Current Estimated Value)ZAKAT ON PRECIOUS STONES}Calculate the nett Market Value of the Precious stones like Diamonds, Rubies, Etc. and add them to the Estimated Value ColumnZAKAT ON SILVERInclude Household Silver Utensils, Artefacts, and Jewelery. For Utensils, usually the silver is 90% pure so take 90% of the total weightZAKAT ON CASH IN HAND /BANK Actual Value Cash in Hand Cash in Bank in Savings Accounts Cash in Bank in Current AccountsCash held in Fixed Deposits0ZAKAT ON LOANS / INVESTMENTS/ FUNDS/ SHARES, ETC+Loans Receivable from Friends and RelativesInvestment in Govt Bonds$Provident Fund Contribution to date.-Insurance Premiums including bonus up to date`Value of Shares (stocks) including Dividends. Take their market value on the date of calculation'Government Security Deposits, ADRs, etc'Investment in Private Chits, Funds, etcOther Sources of WealthZAKAT ON LANDED PROPERTYEstimate ValueZAKAT ON BUSINESSValue of Saleable Stock5However if your intention of holding properties is to sell at a future date for a profit or as an investment, then Zakat is payable on the Market Value. Also, if your intention of holding properties changes in the current year, I.e. from self use to business then you need to pay Zakat on that Property ValueThis is for Business Persons only. No matter what business you are into, you've got to pay Zakat on all STOCK-IN-TRADE. The stock must be valued at its Landed Cost Price. If you have any bills receivable (sales given on credit) then you need to add the same towards calculations.Deduct the Amounts due to your suppliers and deduct the loans on stock on the date of calculation. Dead Stock should be calculated on scrap value or its saleable value. Damaged stock should also be valued at its scrap value. There is no Zakat on Factory Buildings or any kind of machinery, but there is zakat on products produced in the factory (i.e. finished goods value). Please refer to a competent Moulvi or a scholar who can shed more light on your specific issues.2Zakat can be paid EITHER by the firm OR separately by the owners. If the firm is not paying, and the partner wants to calculate his share, he should take the amount standing to his capital and loan account as per the last balance sheet. Add his estimated share of profit till the date zakat is calculated.oThis can only be estimated as it is difficult to calculate the exact profit or loss between an accounting year.cZakat is payable on all Agricultural produce including fruits, commercially grown flowers, vegetables and all types of grains at the harvest time itself. The passing of One year does not apply for agrultural produce. If there are two or more crops on the same land per year, then Zakat has to be paid as many times on the crop, irrespective of the time.?The formula for Zakat calculation on Agriculture is as follows:The attached spreadsheet is a humble attempt at making the calculation process simple and consolidated, for all brothers and sisters who are fortunate to be worthy of paying Zakat. If there are any errors, its purely due to my incomprehension and may be brought to my notice immdtly by email at ajameel@yahoo.com. Please remember me in your supplications and may Allah give us all the rewards of both worlds. Aameen. %Yours Brother in Islam, Arif Jameel.SDetails of Each Section to be used in conjunction with the Calculation Spreadsheet.TLanded Property held as an Investment / Business (Estimate the current Market Value)A Reduction of 2% from the weight of Jewellery can be allowed towards studded stones jewellery & 25% from the weight of KUNDAN Jewellery.There is some contention on whether these are to be considered for valuation. In my humble opinion if they have a value, then they calculate towards your wealth, and it is on the wealth that Zakat is mandatory.WOne may calculate the saleable value of Items at hand on the date of Zakat Calculation.Zakat should be paid at 2.5% on all cash balance and bank balances in your savings, current or FD accounts. The amount technically should be in the bank for one year. Usually it happens that the balance keeps on changing as per personal requirements.Zakat is payable on all Govt Bonds, Public Sector Bond, paid-up Insurance premiums, your paid-up portion of Provident Funds, Govt Bills receivables, etc. Zakat is not payable on personal residential House even if you have more than one and meant for residential purpose only. Also Zakat is not applicable on Property given on rent irrespective of how many. However Zakat is payable on the rental income.iYou may make your best judgement and the best way is to pay on remaining amount on the day of calculation If you have any pending tax payable to the govt, as of the date of Zakat Calculation, then the same may be deducted before arriving at the net worth. If you have taken any loans from any person or institution, <sand if you have not already deducted the same from any of the above sections, then you can deduct your Payables over here. Please be truthful, as Zakat is a sure way of protecting ones wealth if Zakat has been paid on it regularly and fully.Zakat is payable by you on loans you have given to your friends and relatives. It should be treated as Cash in Hand. You may deduct Loans Payable by you to arrive at the nett present value of your wealth.Be honest in the calculations, as ZAKAT is an INSURANCE on your STOCK directly from ALLAH and who better an insurer than Him. FOOTNOTE: Please note that Interest in any form is Haram and strictly prohibited. So please stay away from taking Loans on Interests AND Collection of Interests from any body or institution.Dear Brothers & Sisters,:Alhamdulillah, the month of Ramadhan has been bestowed upon us by Allah. ZAKAT is one of the five fundamental pillars of Islam, mandatory on all muslims who are of eligible wealth. Zakat is due from and payable by a person on his wealth (and not his income), which has remained with him/her for one Islamic year.It is difficult to calculate the completion of one year on each item of wealth, because purchase dates may vary. To overcome this difficulty, a practical method is to fix a date (e.g. 1st of Ramadhan), compute your total wealth on that date and calculate Zakat, thereon.b2 !NxR!NQ+hB S- !NL & =A" !N#/ 6W sp!NU!NT!NT!NT!NT!NT=A0 sp!NWP sp !NT!NT!NT`!NT =A sp! @ sp 첸=AX=A=T5=P!NT!NV!NU!NT!NVH !NT!NWP!NV!NU!NT==a|=aP!NU@!NV,!NU\!NU\Z!NXT!NU!NT=XP!NU$!NV=A0!NVH!NV sp! !NWP=KZ!NU=A!NU!NV=A0!NU spZ!NXT(!NVos_a_imp sp ,!NXT!NWX R !NV<=A!NV8 ,Z Ƞ 첸=A =A=aD=a4!NV!NV,!NV,!NVp !NWP=a{!NV=A sp !NWP Ƞ sp 첸=A6@=A@=aq=ap!NV Ƞ 첸=A =A =aq=ap!NV!NW!NV!NV!NWx=A0=A0 sp! !NWP=aC!NW!NW,=A sp!NWP! ƨ! !NW!NXT !NW sp \! !x! ! !x Z 4! !Nxi!Nxph !NX[ @!Nq Ƞ !NX[!NXY!NXZ! N T?HJ6SW\aVfkotvy>~·^&  dMbP?_*+%63&C&"Arial,Bold"&11Zakat Calculation Spreadsheet&R&D Page &P of &N&Q?'q= ףp?" d X??cU } $ } U'% }  # }  C }  C } : } * # LL(6Q`L``JpC (60CJxB J  fJ@B ݍD J+  MKL LKLppML P@M AL (60CMhKL W*WWWWW XXXXXX MN O+ O, O- P.~ R? D/STTU E0 !& DD&'?D@ E1 !& DD&'D@ E2 !& DD&'D@ E3 (&&' D@E(&&)~ *@ F4 +,,- E5 (&& ' D @ E(&&)~ *@ F6 +,,- E7 ! &  D D & 'D @E(&&)~ *@ F8 +, ,9- E: (&&'D@ E; (&&'D@ E< (&&'D@ E= (&&'D@E(&&)~ *@ F> +, ,9- E? (&&'D@ E@ (&'L@ EA (&' EB (&' EC &' ED &' EE &' EF &'(E &&)~ *@ FG ., ,H-D) l""F.kkkH.H.kBHHHHBH[==;;;; L!L"(6Q`#L@$`J%pC& '(60C(J@xb)J*Jb+ݍD,J - M.KL/@ 0LK1Lp2pM3L456P7@M89: ;A<L =(6@0c>MhK?LB EV && ' D @!E !&&)~ "*@ "FI".,,- #EJ #&) $E $&) %E %&) &G&/0) 'G'/0) (H (127(3(!%#%D&@D'@&('/D(@)E )&&)~ ** @ *F*.,,- +E +&) ,E ,&) -G -/0) .E .&) /H /12-/4/D+D,D-D.&/'2D/@0E 0&&)~ 1*"@ 1F 1., 1,1- 2E 2& 2'3 D2  3E 3& 3'4 D3 4E 4&&4'7D4@5E 5&&)~ 6*$@ 6F 6., 6,6- 7E 7&&7'=D7@8E 8&&)~ 95&@ 9I&96778 :G:/09 ;G;/09 <G </0 =J =;<#=== %:< *=9D=@>E >&&)?> ?K ??@@#?A %>DlF. . wB@@FBF. q@LALB(6Q@CL@D`JEpCF G(60CHJxBIJJJBKݍDLJ M MNKLOPLKQLpRpMSLTUVPW@MXYZ [A\L ](60C^MhK_LB @&&) A&&) B&&) C&&) D&&) E&&) F&&) G&&) H&&) I&&) J&&) K&&) L&&) M&&) N&&) O&&) P&&) Q&&) R&&) S&&) T&&) U&&) V&&) W&&) X&&) Y&&) Z&&) [&&) \&&) ]&&) ^&&) _&&)Dl`LaLb(6Q@cL@d`JepCf g(60ChJxBiJjJBkݍDlJ m MnKLopLKqLprpMsLtuvPw@Mxyz {A|L }(60C~MhKLB `&&) a&&) b&&) c&&) d&&) e&&) f&&) g&&) h&&) i&&) j&&) k&&) l&&) m&&) n&&) o&&) p&&) q&&) r&&) s&&) t&&) u&&) v&&) w&&) x&&) y&&) z&&) {&&) |&&) }&&) ~&&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxB J JB ݍD J   MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)Dl L!L"(6Q@#L@$`J%pC& '(60C(JxB)J*JB+ݍD,J - M.KL/0LK1Lp2pM3L456P7@M89: ;A<L =(60C>MhK?LB &&) !&&) "&&) #&&) $&&) %&&) &&&) '&&) (&&) )&&) *&&) +&&) ,&&) -&&) .&&) /&&) 0&&) 1&&) 2&&) 3&&) 4&&) 5&&) 6&&) 7&&) 8&&) 9&&) :&&) ;&&) <&&) =&&) >&&) ?&&)Dl@LALB(6Q@CL@D`JEpCF G(60CHJxBIJJJBKݍDLJ M MNKLOPLKQLpRpMSLTUVPW@MXYZ [A\L ](60C^MhK_LB @&&) A&&) B&&) C&&) D&&) E&&) F&&) G&&) H&&) I&&) J&&) K&&) L&&) M&&) N&&) O&&) P&&) Q&&) R&&) S&&) T&&) U&&) V&&) W&&) X&&) Y&&) Z&&) [&&) \&&) ]&&) ^&&) _&&)Dl`LaLb(6Q@cL@d`JepCf g(60ChJxBiJjJBkݍDlJ m MnKLopLKqLprpMsLtuvPw@Mxyz {A|L }(60C~MhKLB `&&) a&&) b&&) c&&) d&&) e&&) f&&) g&&) h&&) i&&) j&&) k&&) l&&) m&&) n&&) o&&) p&&) q&&) r&&) s&&) t&&) u&&) v&&) w&&) x&&) y&&) z&&) {&&) |&&) }&&) ~&&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxBJJBݍDJ  MKLLKLppMLP@M AL (60CMhKLB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlLL(6Q@L@`JpC (60CJxB J JB ݍD J   MKLLKLppMLPǾ &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)2< (  x  6X!XPP? ]4@!X ! 5pbj>5@ϑy V<WYou will need to find out the market price as of today and insert the same in Price/Gm< VSxx  6!XPP? vd]4@! !̇ vA# WX U<VThese are just notional Values, please check current market price and insert it here < U Axx  6 !XPP? k]4@! !x !*MI e@AVX V<WThese are just notional Values, please check current market price and insert it here < Vcquxx  6!XPP? k]4@! !$ &AXG+'ȨX V<WThese are just notional Values, please check current market price and insert it here < Vxx  6!XPP?  k ]4@! !Љ -&$[C w'X L<MPlease find out the value of Silver per Gm and insert it in Price/Gm Column < kL foxx  6L!XPP?  v]4@!L !|  H$ M4^3X V<WThese are just notional Values, please check current market price and insert it here < Vxx  6!XPP? k]4@! !( ߹UXM0xdMX <List out your entire sources of wealth. Even money receivable given as a loan to someone is to be calculated for zakat purposes< hxx  6!XPP? ),]4@! !ԋ o~jvH`+X < If your company as a whole pays zakat then you need not calculate personal zakat. If not then you have to see your personal share in the firm and pay zakat on that percentage. < l'xx   6x!XPP? 68]4 @!x ! CePB%"PX <The calculation Fish Farming and Poultry Birds is a little bit complicated. Pls contact your Local Aalim for the right calculations. < m-!A satisfied Microsoft Office userr-!A satisfied Microsoft Office userr-!A satisfied Microsoft Office userr-!A satisfied Microsoft Office userr- !A satisfied Microsoft Office userr- !A satisfied Microsoft Office userr-!A satisfied Microsoft Office userr-*!A satisfied Microsoft Office userr-7 !A satisfied Microsoft Office userr>@??? N 4֭H  dMbP?_*+%&L&"Arial,Italic"&8Appendix: Explanations To be used in conjunction with the Spreadsheet on Zakat Calculator&RPage &P of &N&Gz?'q= ףp?(p= ף?)(\?" dX,zG?RQ?U } !} Y} 4w@E @$@ @w JDDzE J  J K,L K `\L<K<@`K 4E\B $  b c Vd VS VT U~ "?   W~ "@  X Y~ "@  ~ "@  Z ]~ "@  _ [~ "@  \ K~ "@ ! L M8 E! #$ $@%' € ( )JDD*uzE@,J -J.K0,L 1`3 K @ ` !N~ #" @ #" $O %P~ '""@ '# (Q )R *'~ ,"$@ ,$ -( .)~ 0"&@ 0% 1^ 3a"6>@ N S  dMbP?_*+%"??U } >@ #\pimac se [B'b Calculations$ ;?$ ;=x<8"8@"1NArial1NArial1NArial1NArial1 NArial1$NArial1 NArial1NArial1NArial1NArial1NArial1 NArial1QNTahoma1NArial1NArial1 NArial1NArial1NArial1NArial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00!""#,##0.00;[Red]\-""#,##0.0030_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-*'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-;8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-2/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-""_._."\ #,##0_-;"_._."\ #,##0\-'$"_._."\ #,##0_-;[Red]"_._."\ #,##0\-(%"_._."\ #,##0.00_-;"_._."\ #,##0.00\--*"_._."\ #,##0.00_-;[Red]"_._."\ #,##0.00\-B?_-"_._."\ * #,##0_-;_-"_._."\ * #,##0\-;_-"_._."\ * "-"_-;_-@_-*'_-* #,##0_-;_-* #,##0\-;_-* "-"_-;_-@_-JG_-"_._."\ * #,##0.00_-;_-"_._."\ * #,##0.00\-;_-"_._."\ * "-"??_-;_-@_-2/_-* #,##0.00_-;_-* #,##0.00\-;_-* "-"??_-;_-@_-"KD"#,##0;\-"KD"#,##0"KD"#,##0;[Red]\-"KD"#,##0"KD"#,##0.00;\-"KD"#,##0.00# "KD"#,##0.00;[Red]\-"KD"#,##0.0063_-"KD"* #,##0_-;\-"KD"* #,##0_-;_-"KD"* "-"_-;_-@_->;_-"KD"* #,##0.00_-;\-"KD"* #,##0.00_-;_-"KD"* "-"??_-;_-@_- "$"#,###.## #,###.0063_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_)2/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_).+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)                  + ) , *  +   + # +   + #  ( (  ( (8    8  * * (* #* + *  *  * *  * #*  *  *  * #*  * #*  #*  *  * #*   *   *  *   *  #*  #*  *   *  #*  *   * #* * (* * (* (*  (*  (*  (*  * * * * * * *  * #*  * (  * * AFollowed Hyperlink  Hyperlink83ffff̙3f3fff3f3f33333f33333 Calculations{Summary and Instructions (Sheet3 # PQ["0k53:>CHSMRV[s`;ejnsw  dMbP?_*+%"43&C&"Arial,Bold"&11Zakat Calculation Spreadsheet&R&D Page &P of &N&Q?'q= ףp?" d X??cU } $ } U'% }  # }  C }  C } : } * #  L@L(6Q`L`IpC (6`BIxB I  fI@? $ JU  PL@JL$ L@LL LJKJ$J JJLpC (6`BhK@K WZakat CalculatorWWWWWxXp(Use Only YELLOW cells to fill Values. Please refer to the Appendix Sheet for more explanations on Each Section)XXXXX MNO Weight in GMSOPrice/GmOEstimated ValueP Zakat Payable~ R?D ZAKAT ON GOLDSTTUE24 Carat Gold/Jewelry & DD%'?D@E22 Carat Gold/Jewelery & DD%'D@E18 Carat Gold/Jewelry & DD%'D@GE?Other Gold Valuables. (Pls insert the Current Estimated Value) (&%' D@E(&&)~ *@ FZAKAT ON PRECIOUS STONES +,,- E}Calculate the nett Market Value of the Precious stones like Diamonds, Rubies, Etc. and add them to the Estimated Value Column (&% ' D @ E(&&)~ *@ FZAKAT ON SILVER +,,- EInclude Household Silver Utensils, Artefacts, and Jewelery. For Utensils, usually the silver is 90% pure so take 90% of the total weight  &  D D % 'D @E(&&)~ *@#FZAKAT ON CASH IN HAND /BANK +,, Actual Value-E Cash in Hand (&%'D@(E Cash in Bank in Savings Accounts (&%'D@(E Cash in Bank in Current Accounts (&%'D@#ECash held in Fixed Deposits (&%'D@E(&&)~ *@8F0ZAKAT ON LOANS / INVESTMENTS/ FUNDS/ SHARES, ETC +,, Actual Value-3E+Loans Receivable from Friends and Relatives (&%'D@ EInvestment in Govt Bonds (&'L@,E$Provident Fund Contribution to date. (&'5E-Insurance Premiums including bonus up to date (&'hE`Value of Shares (stocks) including Dividends. Take their market value on the date of calculation &'/E'Government Security Deposits, ADRs, etc &'/E'Investment in Private Chits, Funds, etc &'EOther Sources of Wealth &'(E &&)~ *@ FZAKAT ON LANDED PROPERTY .,,Estimate Value-Dl0o9{|{D;eQee`zpp_h``P L@!L"(6Q`#L@$I%pC& '(6`B(I@xb)I*I? +$,JU-PL.@JL/$@ 0L@1L 2L 3L4JK5J6J 7J8JL9:;pC< =(6@`b>hK?@KB \ ETLanded Property held as an Investment / Business (Estimate the current Market Value) &% ' D @!E !&&)~ "*@"FZAKAT ON BUSINESS".,,-#EValue of Saleable Stock #&)%$EValue of Damaged / Dead Stock $&)+%E#Amount Receivable from Credit Sales %&)Z&GRLESS: Amount Payable to Suppliers (Credit taken from suppliers for stocking goods)&/0)'GLESS: Bad Debts'/0)(HTOTAL VALUE OF STOCK (123(3(%#%D&@D'@%('/D(@)E )&&)~ ** @+*F#ZAKAT ON SHARE IN PARTNERSHIP FIRMS*.,,-1+E)Capital Balance as per Last balance Sheet +&)4,E,Loans Advanced by you to the Firm as of Date ,&)?-G7LESS: Withdrawals made by you during the current Year.-/0).EAccumulated Profit from the date of Balance Sheet to this Date (Estimate the Profit Value as it is difficult to get exact figures in the middle of Accounting Year) .&)#/HNETT TOTAL WORTH CALCULATED /12)/4/D+D,D-D.%/'2D/@0E 0&&)~ 1*"@%1FZAKAT ON AGRICULTURAL PRODUCE 1.,1,Value of Produce1-R2EJProduce Dependent on Rain Water - @ 10% of product (crop) in Value or Kind 2&2'3 D2 3EProduce totally dependent on Artificial Irrigation like Canal, Tank, Borewell, etc. - @ 5% of Produce (crop) in Value or in Kind 3&3'4 D34EwProduce dependent Partially on Rain Water and Partially on Artificial Irrigation - 7.5% of the Produce Value or in Kind 4&%4'7D4@5E 5&&)~ 6*$@16F)ZAKAT ON ANIMALS & POULTRY & FISH FARMING 6.,6, Total Value6-o7EgAnimals/ Birds more than 6 months Old - @ 1 Animal or Bird PER 40 either in Kind or Value of the same. 7&%7'=D7@8E 8&&)~ 95&@v9IiGENERAL LIABILITIES - You need to deduct your direct Payables or Liabilities which are not deducted above967781:G)Loans taken from from Friends / Relatives:/09-;G%Loans Taken from Banks / Institutions;/09'<GIncome Tax / Wealth Tax Payable </0=JTOTAL LIABILITIES =;<!=== %:< )=9D=@>E >&&)?>?KTOTAL ZAKAT PAYABLE ??@@!?AAK %>Dl=39?p-OEHUkrGC;}@L@ALB(6Q@CL@DIEpCF G(6`BHIxBIIJI?K$LJUMPLN@JLO$ PL@QLRL SLTJKUJVJ WJXJLYZ[pC\ ](6`B^hK_@KB @&&) A&&) B&&) C&&) D&&) E&&) F&&) G&&) H&&) I&&) J&&) K&&) L&&) M&&) N&&) O&&) P&&) Q&&) R&&) S&&) T&&) U&&) V&&) W&&) X&&) Y&&) Z&&) [&&) \&&) ]&&) ^&&) _&&)Dl`L@aLb(6Q@cL@dIepCf g(6`BhIxBiIjI?k$lJUmPLn@JLo$ pL@qLrL sLtJKuJvJ wJxJLyz{pC| }(6`B~hK@KB `&&) a&&) b&&) c&&) d&&) e&&) f&&) g&&) h&&) i&&) j&&) k&&) l&&) m&&) n&&) o&&) p&&) q&&) r&&) s&&) t&&) u&&) v&&) w&&) x&&) y&&) z&&) {&&) |&&) }&&) ~&&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxB I I? $ JU PL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)Dl L@!L"(6Q@#L@$I%pC& '(6`B(IxB)I*I?+$,JU-PL.@JL/$ 0L@1L2L 3L4JK5J6J 7J8JL9:;pC< =(6`B>hK?@KB &&) !&&) "&&) #&&) $&&) %&&) &&&) '&&) (&&) )&&) *&&) +&&) ,&&) -&&) .&&) /&&) 0&&) 1&&) 2&&) 3&&) 4&&) 5&&) 6&&) 7&&) 8&&) 9&&) :&&) ;&&) <&&) =&&) >&&) ?&&)Dl@L@ALB(6Q@CL@DIEpCF G(6`BHIxBIIJI?K$LJUMPLN@JLO$ PL@QLRL SLTJKUJVJ WJXJLYZ[pC\ ](6`B^hK_@KB @&&) A&&) B&&) C&&) D&&) E&&) F&&) G&&) H&&) I&&) J&&) K&&) L&&) M&&) N&&) O&&) P&&) Q&&) R&&) S&&) T&&) U&&) V&&) W&&) X&&) Y&&) Z&&) [&&) \&&) ]&&) ^&&) _&&)Dl`L@aLb(6Q@cL@dIepCf g(6`BhIxBiIjI?k$lJUmPLn@JLo$ pL@qLrL sLtJKuJvJ wJxJLyz{pC| }(6`B~hK@KB `&&) a&&) b&&) c&&) d&&) e&&) f&&) g&&) h&&) i&&) j&&) k&&) l&&) m&&) n&&) o&&) p&&) q&&) r&&) s&&) t&&) u&&) v&&) w&&) x&&) y&&) z&&) {&&) |&&) }&&) ~&&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxBII?$JUPL@JL$ L@LL LJKJJ JJLpC (6`BhK@KB &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)DlL@L(6Q@L@IpC (6`BIxB I I? $ JU PL@JL$ L@LL LJKJJ &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&) &&)2<\VYou will need to find out the market price as of today and insert the same in Price/Gm[UThese are just notional Values, please check current market price and insert it here \VThese are just notional Values, please check current market price and insert it here \VThese are just notional Values, please check current market price and insert it here R LPlease find out the value of Silver per Gm and insert it in Price/Gm Column \ VThese are just notional Values, please check current market price and insert it here List out your entire sources of wealth. Even money receivable given as a loan to someone is to be calculated for zakat purposes* If your company as a whole pays zakat then you need not calculate personal zakat. If not then you have to see your personal share in the firm and pay zakat on that percentage. 7The calculation Fish Farming and Poultry Birds is a little bit complicated. Pls contact your Local Aalim for the right calculations. =x<8"8> ???"  # 4?}}  dMbP?_*+%"&L&"Arial,Italic"&8Appendix: Explanations To be used in conjunction with the Spreadsheet on Zakat Calculator&RPage &P of &N&Gz?'q= ףp?(p= ף?)(\?" dX,zG?RQ? CalculationsU } !oi} Yio} oi 4w@L@@L(6Q@L@I@pCw (6`BIxB I  I? $J PL@J `$ L@L L LJ `JJ J JL Dear Brothers & Sisters,Alhamdulillah, the month of Ramadhan has been bestowed upon us by Allah. ZAKAT is one of the five fundamental pillars of Islam, mandatory on all muslims who are of eligible wealth. Zakat is due from and payable by a person on his wealth (and not his incVIt is difficult to calculate the completion of one year on each item of wealth, because purchase dates may vary. To overcome this difficulty, a practical method is to fix a date (e.g. 1st of Ramadhan), compute your total wealth on that date and calculateVThe attached spreadsheet is a humble attempt at making the calculation process simple and consolidated, for all brothers and sisters who are fortunate to be worthy of paying Zakat. If there are any errors, its purely due to my incomprehension and may be 0V%Yours Brother in Islam, Arif Jameel.[SDetails of Each Section to be used in conjunction with the Calculation Spreadsheet.~ "?-%Zakat on Pure Gold and Gold JewelleryZakat should be calculated at 2.5% of the market value as on the date of valuation (In our case we consider 1st of Ramadhan). Most Ulema favour the Market Value prevailing as on the date of Calculation and not the purchase price.A Reduction of 2% from the weight of Jewellery can be allowed towards studded stones jewellery & 25% from the weight of KUNDAN Jewellery.~ "@2 *Zakat on Precious and Semi-Precious Stones There is some contention on whether these are to be considered for valuation. In my humble opinion if they have a value, then they calculate towards your wealth, and it is on the wealth that Zakat is mandatory._ WOne may calculate the saleable value of Items at hand on the date of Zakat Calculation.~ "@Zakat on Silver.Zakat is to be paid on Silver in Pure form or Jewellery, Utensils, Decorative items and all household items including crockery, cutlery made of silver at 2.5% of the prevailing market rates.~ "@'Zakat on Cash and Bank BalancesZakat should be paid at 2.5% on all cash balance and bank balances in your savings, current or FD accounts. The amount technically should be in the bank for one year. Usually it happens that the balance keeps on changing as per personal requirements.qiYou may make your best judgement and the best way is to pay on remaining amount on the day of calculation~ "@( Zakat on Loans Given, Funds, etcZakat is payable by you on loans you have given to your friends and relatives. It should be treated as Cash in Hand. You may deduct Loans Payable by you to arrive at the nett present value of your wealth.Zakat is payable on all Govt Bonds, Public Sector Bond, paid-up Insurance premiums, your paid-up portion of Provident Funds, Govt Bills receivables, etc. ~ "@ Zakat on Landed PropertyZakat is not payable on personal residential House even if you have more than one and meant for residential purpose only. Also Zakat is not applicable on Property given on rent irrespective of how many. However Zakat is payable on the rental income.However if your intention of holding properties is to sell at a future date for a profit or as an investment, then Zakat is payable on the Market Value. Also, if your intention of holding properties changes in the current year, I.e. from self use to busi~ "@Zakat on Business:This is for Business Persons only. No matter what business you are into, you've got to pay Zakat on all STOCK-IN-TRADE. The stock must be valued at its Landed Cost Price. If you have any bills receivable (sales given on credit) then you need to add the Deduct the Amounts due to your suppliers and deduct the loans on stock on the date of calculation. Dead Stock should be calculated on scrap value or its saleable value. Damaged stock should also be valued at its scrap value. 8$   4_?Dc*9u:2 ,  L@!L#(6 `$L@%I' `( )(6`B*uI@xB,I -I?.$0J 1`PL3@J @ Be honest in the calculations, as ZAKAT is an INSURANCE on your STOCK directly from ALLAH and who better an insurer than Him. !There is no Zakat on Factory Buildings or any kind of machinery, but there is zakat on products produced in the factory (i.e. finished goods value). Please refer to a competent Moulvi or a scholar who can shed more light on your specific issues.~ #" @##Zakat on Partnership Firms.$Zakat can be paid EITHER by the firm OR separately by the owners. If the firm is not paying, and the partner wants to calculate his share, he should take the amount standing to his capital and loan account as per the last balance sheet. Add his estimatedw%oThis can only be estimated as it is difficult to calculate the exact profit or loss between an accounting year.~ '""@%'Zakat on Agricultural Product(Zakat is payable on all Agricultural produce including fruits, commercially grown flowers, vegetables and all types of grains at the harvest time itself. The passing of One year does not apply for agrultural produce. If there are two or more crops on thG)?The formula for Zakat calculation on Agriculture is as follows:*On crops dependent purely on rain water it will be 10% of produce, On crops not irrigated through rain water but use Canal Water, Tank Water, Borewell and Open wells, the Zakat is 5% of the produce. For Crops dependent partly on Rain Water and partly o~ ,"$@,Zakat on Animals-On all grazing animals like goats, shee, camel, cows, broiler chickens, the consensus Zakat payable is one animal/bird for every 40 animals owned. However you may wish to give cash in lieu of the animal/bird itself..Please consult your local Scholar or Maulvi or Imaam who can guide you to the right direction, or refer to books of Fiqh if you would like to have first hand confirmation of the situation.~ 0"&@0Liabilities Deductions1 If you have any pending tax payable to the govt, as of the date of Zakat Calculation, then the same may be deducted before arriving at the net worth. If you have taken any loans from any person or institution, and if you have not already deducted the sa3FOOTNOTE: Please note that Interest in any form is Haram and strictly prohibited. So please stay away from taking Loans on Interests AND Collection of Interests from any body or institution." 5 {7 K *0 =x<8"8> " #   dMbP?_*+%""??et CalculationsU } oi =x<8"8> "   Oh+'0HPl| 'Internal Systems0imac seMicrosoft Excel@#Fzk@q e@ap ՜.+,08@ \d l 'Oracle Corporation0  CalculationsSummary and InstructionsSheet3 Hojas de clculoDocumentSummaryInformation8CompObj ZFHoja de clculo de MS Excel8FIBExcel.Sheet.5