SuperCalc Ver. 1.06 This is a Sample SuperCalc Worksheet  P7 "This is a Sample SuperCalc Worksheet "orage Costs " "Jan "Feb "Mar "Apr "May "Jun "Jul "Aug  "Sep  "Oct  "Nov  "Dec  "Total "ASSETSSSETS!"Acct.s Receivable)AD100015DP1.05*B5DP1.05*C5DWbP1.05*D5DPbP1.05*E5Dv(bP1.05*F5D@ V@bP1.05*G5D"ebP1.05*H5 DwETCxc1.05*I5 DQ2‚—…1.05*J5 D(‰F&wtB1.05*K5 D3“Xc1.05*L5 E‘q&RBXSUM(B5:M5)!"Cash ReceivableAC0300B3CP0.5*B5CRP0.5*C5CUP0.5*D5CWˆP0.5*E5C`wSP0.5*F5Cc@xP0.5*G5CgG‚P0.5*H5 Cp5P!(P0.5*I5 Cs‡'r”S0.5*J5 CwVdy‰%€0.5*K5 CDG13ˆr0.5*L5 Dt9516SUM(B6:M6) "Unsold GoodsC%0.25*B5C&%0.25*C5BebP0.25*C7C(”%0.25*E5C08vV%0.25*F5C1p9%0.25*G5C3P#‘V%0.25*H5C5uVd%0.25*I5 C6“c† G&X0.25*J5 C8x29”b0.25*K5 C@r#ef”60.25*L5 CBu„ƒ•)…0.25*M5 D7i(0HSUM(B7:M7) '_s is a Samp"uperCalc Wor "Total AssetsDPSUM(B5:B7)DPSUM(C5:C7)D“PSUM(D5:D7)D˜(PSUM(E5:E7)D ˜SPSUM(F5:F7)D"PxPSUM(G5:G7)D#&2PSUM(H5:H7)D$(’3Hc(SUM(I5:I7) D%P6•DTSUM(J5:J7) D&wˆy‘†vwSUM(K5:K7) D(x#‘FaSUM(L5:L7) D)R7ASUM(M5:M7) E'˜s6SUM(B9:M9) " "LIABILITIES !"Acct.s Payable AD1000 C‘ffffffgB12-(B12/12) C„wwwwwxC12-(C12/12) CwTb–)b—D12-(D12/12) Cp`ft8'E12-(E12/12) Cdr'„…#F12-(F12/12) CY2’De‡G12-(G12/12) CT8Q‚`8ƒH12-(H12/12) CI…0$g8h“I12-(I12/12) CEi†•FRJ12-(J12/12) CA‰ˆx„Y1K12-(K12/12) C89•#`‡pL12-(L12/12) Dwv$cƒWSUM(B12:M12) !"Storage Costs @BP50 @BP50 @BP50 @BP50 @BP50 @BP50 @BP50 @BP50 @BP50 @BP50 @BP50 @BP50 C`SUM(B13:M13) "Labor AC100 CP1.05*B14 CP1.05*C14 CWbP1.05*D14 CPbP1.05*E14 Cv(bP1.05*F14 C@ V@bP1.05*G14 C"ebP1.05*H14 CwETCxc1.05*I14 CQ2‚—…1.05*J14 C(‰F&wtB1.05*K14 C3“Xc1.05*L14 D‘q&RBXSUM(B14:M14) "Materials@BP50BRP1.05*B15BUP1.05*C15BWˆP1.05*D15B`wSP1.05*E15Bc@xP1.05*F15BgG‚P1.05*G15Bp5P!(P1.05*H15 Bs‡'r”S1.05*I15 BwVdy‰%y1.05*J15 BDG13ˆr1.05*K15 B…QigXh1.05*L15 CyXV2`"’SUM(B15:M15) '_tksheet"____________!"Total LiabilitiesDSUM(B12:B15)13D$ffffgSUM(C12:C15)13DUe'wwwxSUM(D12:D15)2C™8˜7–)b—SUM(E12:E15)2C“ƒ’h'SUM(F12:F15)2Cˆ†p(ƒ#SUM(G12:G15)2C„CTYbSUM(H12:H15)2C€I$X‚XSUM(I12:I15)2 CwHV3‡SUM(J12:J15)2 Cs–…)$&SUM(K12:K15)2 Cq28 ”SUM(L12:L15)2 CiFBx2ASUM(M12:M15)2 Ev6!D–tSUM(B17:M17) " "NIBTC5B9-B17Chƒ333330C9-C17Cctr"""" D9-D17D8(p7pE9-E17DY€&1(9F9-F17DCI•$iG9-G17Dh•7‘G"H9-H17D$q—9‡I9-I17 D€" RutJ9-J17 D8 &™–4K9-K17 D ˜TC U˜RL9-L17 D"a‚SvuWM9-M17 E2a€(˜bSUM(B19:M19)!"Dep. AllowanceAC1200/12AC1200/12AC1200/12AC1200/12AC1200/12AC1200/12AC1200/12AC1200/12 AC1200/12 AC1200/12 AC1200/12 AC1200/12 DSUM(B20:M20)!"Taxable IncomeC%B19-B20CXƒ333330C19-C20CStr"""" D19-D20CC‚‡p7E19-E20DY€&1(9F19-F20DCI•$iG19-G20Dh•7‘G"H19-H20D$q—9‡I19-I20 D€" RutJ19-J20 D8 &™–4K19-K20 D˜TC U˜RL19-L20 D!a‚SvuWM19-M20 Ea€(˜bSUM(B21:M21) '_______"___ "Taxes(@30%)Bu0.3*B21Cd™™™™™™0.3*C21CAfffff0.3*D21C'†0.3*E21C1y@x“Q…0.3*F21C6C0I…rS0.3*G21CA†tAHf0.3*H21CEr ’a0.3*I21 CP@f(X'"0.3*J21 CU`€™ˆ0.3*K21 CY•c)(g•V0.3*L21 Cd…Ga0&sp0.3*M21 DE7…@†”XˆSUM(B23:M23) '=___________"____________ "Net IncomeC'PB19-B23CQ333331C19-C23CGb0UUUUTD19-D23Cs0h’Y%E19-E23C„a„ ˜sF19-F23C•Ifi#ƒG19-G23DX&vT5H19-H23Df€Itˆ‘I19-I23 DvFf“„J19-J23 D†t‰—#K19-K23 D˜˜i–L19-L23 D'wcrSM19-M23 Exƒ& (ssSUM(B25:M25)