SuperCalc ver. 1.12 This is a Sample SuperCalc Worksheet  P7 "This is a Sample SuperCalc Worksheet "his  "his  "Jan  "Feb  "Mar  "Apr  "May  "Jun  "Jul  "Aug  "Sep  "Oct  "Nov  "Dec !"Totals a Sam!"ASSETS a Sam""Acct.s ReceivableupeP1000.‚DP1.05*B5upe‚DP1.05*C5upe‚DWbP1.05*D5upe‚DPbP1.05*E5upe‚Dv(bP1.05*F5upe‚D@ V@bP1.05*G5upe‚D"ebP1.05*H5upe ‚DwETCxc1.05*I5upe ‚DQ2‚—…1.05*J5upe ‚D(‰F&wtB1.05*K5upe ‚D3“Xc1.05*L5upe ‚E‘q&RBXSUM(B5:M5)e!"CashBXSUM(P300h‚CP0.5*B5M5)e‚CRP0.5*C5M5)e‚CUP0.5*D5M5)e‚CWˆP0.5*E5M5)e‚C`wSP0.5*F5M5)e‚Cc@xP0.5*G5M5)e‚CgG‚P0.5*H5M5)e ‚Cp5P!(P0.5*I5M5)e ‚Cs‡'r”S0.5*J5M5)e ‚CwVdy‰%€0.5*K5M5)e ‚CDG13ˆr0.5*L5M5)e ‚Dt9516SUM(B6:M6)e""Unsold GoodsB6:M6)e‚C%0.25*B56)e‚C'V%0.25*D56)e‚BhbP0.25*C76)e‚C(”%0.25*E56)e‚C08vV%0.25*F56)e‚C1p9%0.25*G56)e‚C3P#‘V%0.25*H56)e‚C5uVd%0.25*I56)e ‚C6“c† G&X0.25*J56)e ‚C8x29”b0.25*K56)e ‚C@r#ef”60.25*L56)e ‚CBu„ƒ•)…0.25*M56)e ‚D7…hx€HSUM(B7:M7)e '_hx€"hx€""Total AssetsB7:M7)e‚DPSUM(B5:B7)e‚D%bPSUM(C5:C7)e‚D–@bPSUM(D5:D7)e‚D˜(PSUM(E5:E7)e‚D ˜SPSUM(F5:F7)e‚D"PxPSUM(G5:G7)e‚D#&2PSUM(H5:H7)e‚D$(’3Hc(SUM(I5:I7)e ‚D%P6•DTSUM(J5:J7)e ‚D&wˆy‘†vwSUM(K5:K7)e ‚D(x#‘FaSUM(L5:L7)e ‚D)R7ASUM(M5:M7)e ‚E'b˜6SUM(B9:M9)e "b˜ !"LIABILITIES( ""Acct.s Payable:M9)e P1000. ƒC‘ffffffgB12-(B12/12)Calc Wo ƒC„wwwwwxC12-(C12/12)Calc Wo ƒCwTb–)b—D12-(D12/12)Calc Wo ƒCp`ft8'E12-(E12/12)Calc Wo ƒCdr'„…#F12-(F12/12)Calc Wo ƒCY2’De‡G12-(G12/12)Calc Wo ƒCT8Q‚`8ƒH12-(H12/12)Calc Wo ƒCI…0$g8h“I12-(I12/12)Calc Wo ƒCEi†•FRJ12-(J12/12)Calc Wo ƒCA‰ˆx„Y1K12-(K12/12)Calc Wo ƒC89•#`‡pL12-(L12/12)Calc Wo ƒDwv$cƒWSUM(B12:M12)Calc Wo ""Storage Costs12:M12) P50ora P50ora P50ora P50ora P50ora P50ora P50ora P50ora P50ora P50ora P50ora P50ora ƒC`SUM(B13:M13)Calc Wo !"LaborSUM( P100or ‚CP1.05*B1413) ‚CP1.05*C1413) ‚CWbP1.05*D1413) ‚CPbP1.05*E1413) ‚Cv(bP1.05*F1413) ‚C@ V@bP1.05*G1413) ‚C"ebP1.05*H1413) ‚CwETCxc1.05*I1413) ‚CQ2‚—…1.05*J1413) ‚C(‰F&wtB1.05*K1413) ‚C3“Xc1.05*L1413) ƒD‘q&RBXSUM(B14:M14)Calc Wo!"MaterialsUM(P50ter‚BRP1.05*B1514)‚BUP1.05*C1514)‚BWˆP1.05*D1514)‚B`wSP1.05*E1514)‚Bc@xP1.05*F1514)‚BgG‚P1.05*G1514)‚Bp5P!(P1.05*H1514) ‚Bs‡'r”S1.05*I1514) ‚BwVdy‰%y1.05*J1514) ‚BDG13ˆr1.05*K1514) ‚B…QigXh1.05*L1514) ƒCyXV2`"’SUM(B15:M15)Calc Wo '_V2`"V2`""Total Liabilities15)ƒDSUM(B12:B15)Calc WoƒD$ffffgSUM(C12:C15)Calc WoƒDUe'wwwxSUM(D12:D15)Calc WoƒC™8˜7–)b—SUM(E12:E15)Calc WoƒC“ƒ’h'SUM(F12:F15)Calc WoƒCˆ†p(ƒ#SUM(G12:G15)Calc WoƒC„CTYbSUM(H12:H15)Calc WoƒC€I$X‚XSUM(I12:I15)Calc Wo ƒCwHV3‡SUM(J12:J15)Calc Wo ƒCs–…)$&SUM(K12:K15)Calc Wo ƒCq28 ”SUM(L12:L15)Calc Wo ƒCiFBx2ASUM(M12:M15)Calc Wo ƒEv6!D–tSUM(B17:M17)Calc Wo "v6!D!"NIBT–tSUM(‚C5B9-B17:M17)‚CpX33330C9-C17:M17)‚CdSG""" D9-D17:M17)‚D8(p7pE9-E17:M17)‚DY€&1(9F9-F17:M17)‚DCI•$iG9-G17:M17)‚Dh•7‘G"H9-H17:M17)‚D$q—9‡I9-I17:M17) ‚D€" RutJ9-J17:M17) ‚D8 &™–4K9-K17:M17) ‚D ˜TC U˜RL9-L17:M17) ‚D"a‚SvuWM9-M17:M17) ƒE4%†S˜bSUM(B19:M19)Calc Wo""Dep. Allowance9:M19)BC1200/12M19)BC1200/12M19)BC1200/12M19)BC1200/12M19)BC1200/12M19)BC1200/12M19)BC1200/12M19)BC1200/12M19) BC1200/12M19) BC1200/12M19) BC1200/12M19) BC1200/12M19) ƒDSUM(B20:M20)Calc Wo""Taxable Income0:M20)‚C%B19-B20M20)‚C`X33330C19-C20M20)‚CTSG""" D19-D20M20)‚CC‚‡p7E19-E20M20)‚DY€&1(9F19-F20M20)‚DCI•$iG19-G20M20)‚Dh•7‘G"H19-H20M20)‚D$q—9‡I19-I20M20) ‚D€" RutJ19-J20M20) ‚D8 &™–4K19-K20M20) ‚D˜TC U˜RL19-L20M20) ‚D!a‚SvuWM19-M20M20) ƒE%†S˜bSUM(B21:M21)Calc Wo '_%†S"%†S!"Taxes(@30%)(‚Bu0.3*B21M21)‚C7I™™™™0.3*C21M21)‚C"&fff0.3*D21M21)‚C'†0.3*E21M21)‚C1y@x“Q…0.3*F21M21)‚C6C0I…rS0.3*G21M21)‚CA†tAHf0.3*H21M21)‚CEr ’a0.3*I21M21) ‚CP@f(X'"0.3*J21M21) ‚CU`€™ˆ0.3*K21M21) ‚CY•c)(g•V0.3*L21M21) ‚Cd…Ga0&sp0.3*M21M21) ƒDEBwYa”XˆSUM(B23:M23)Calc Wo '=wYa"wYa!"Net IncomeM(‚C'PB19-B23M23)‚CR ƒ3331C19-C23M23)‚CG…'CUUTD19-D23M23)‚Cs0h’Y%E19-E23M23)‚C„a„ ˜sF19-F23M23)‚C•Ifi#ƒG19-G23M23)‚DX&vT5H19-H23M23)‚Df€Itˆ‘I19-I23M23) ‚DvFf“„J19-J23M23) ‚D†t‰—#K19-K23M23) ‚D˜˜i–L19-L23M23) ‚D'wcrSM19-M23M23) ƒEy˜WxssSUM(B25:M25)Calc Wo