IMD 1.16: 29/05/2007 18:25:46 FOGCPM.056 6/86 --FOGCPM056CASHFLW CAL1 CASHFLW DOC ELNA CAL ELNA CAL-06-00 86 ELNA DOC$ !"#$ELNAEX CAL%&'()*+,-./01234ELNAEX CALH56789:;<=-CPM056 DOCTAXSHLTRCAL'>?@ABTAXSHLTRDOC CDTAXTMPL DOCEFGHIJKLMNOPQRSTTAXTMPL DOC$UVWXYTAXTMPL1CALEZ[\]^_`abTAXTMPL2CALcdefghijklmnopqrTAXTMPL2CALsTAXTMPL3CAL%tuvwxTAXTMPL4CAL1yz{|}~TAXTMPL5CAL_TAXTMPL6CALTAXTMPL6CALTAXTMPL7CALTAXTMPL7CAL This is the disk name. SuperCalc ver. 1.12  B   P7 A" CASH FLOW ANALYSIST" AS OF"PROPERTY ADDRESS " LASTADDR"CURRENTADDR"POTENTIALDDR"MORTGAGEDDR"MORTGAGEDDR"PROPERTYDDR"REPAIRS &DDR"UTILITIESDDR " ADMINDDR " TOTALDDR "NET CASHDDR" INCREASEDR" RENTASEDR" RENTASEDR"PAYMENT1EDR"PAYMENT2EDR" TAXESEDR"MAINTENANCER "EXPENSESCER " FLOWSCER'------------------------------------"--------------------"--------------------"--------------------"--------------------"--------------------"--------------------"--------------------"-------------------- "-------------------- "-------------------- "-------------------- "-------------------- "--------------------"--------------------"--------------------"416 P00 2/P002/P00P002/P00---P002/P002/P00 P002/ SUM(E9:J9)- C9-K9:J9)- "133  P008/8 P00/8 P00/8 P00.16 P00.33 P00.33 P00.33 P00 P00.33 SUM(E10:J10)------- C10-K10J10) "447B P001/8 P00/8 P00/8 P00/8 P00/8 P00/8 P00/8 P00 P00/8 SUM(E11:J11)------- C11-K11J11) "454  P0017/ P007/ P007/ P007/ P00/8 P007/ P007/ P00 P007/ SUM(E12:J12)------- C12-K12J12) "57 N P001/8 P00/8 P00/8 P00.01 P0073 P0073 P0073 P00 P0073 SUM(E13:J13)------- C13-K13J13) "73 N P00/6/ P006/ P006/ P006/ P0073 P006/ P006/ P00 P006/ SUM(E14:J14)------- C14-K14J14)"25 NP0013/P003/P003/P003/P0073P003/P003/P00 P003/ SUM(E15:J15)------- C15-K15J15)"432 P004/8P00/8P00/8P00/8P00/8P00/8P00/8P00 P00/8 SUM(E16:J16)------- C16-K16J16)"482 P009/8P00/8P00/8P00.3P00/8P003P003P00 P003 SUM(E17:J17)------- C17-K17J17)"4 LiP00/15P0015P0015P0015P00/8P0015P0015P00 P0015 SUM(E18:J18)------- C18-K18J18)"231 P001/8P00/8P00/8P00.61P0033P003P003P00 P003 SUM(E19:J19)------- C19-K19J19)"130 P001/8P0030 P000 P000 P000 P000 P000 P000 P000 SUM(E20:J20)------- C20-K20J20)" apP00/1/P001/P001/P00a/P000 P00a/P00a/P000 P00a/ SUM(E21:J21)------- C21-K21J21)" apP00autP00utP00utP00atP000 P00atP00atP000 P00at SUM(E22:J22)------- C22-K22J22)" apP001/8P00/8P00/8P00a8P000 P00a8P00a8P000 P00a8 SUM(E23:J23)------- C23-K23J23)" apP001/8P00/8P00/8P00a8P000 P00a8P00a8P000 P00a8 SUM(E24:J24)------- C24-K24J24)"43 MP001/8P00/8P00/8P00/8P000 P00/8P00/8P000 P00/8 SUM(E25:J25)------- C25-K25J25)"61 NP001/8P00/8P00/8P00.5P000 P00.5P00.5P000 P00.5 SUM(E26:J26)------- C26-K26J26)"045 P001/8P00/8P00/8P00/8P000 P00/8P00/8P000 P00/8 SUM(E27:J27)------- C27-K27J27)"315 P00/15P0015P0015P00.4P000 P004P004P000 P004 SUM(E28:J28)------- C28-K28J28)"060 P001/8P00/8P00/8P00.81P000 P00.81P00.81P000 P00.81 SUM(E29:J29)------- C29-K29J29)"572 P00/1/P001/P001/P00.11P0015P0015P0015P000 P0015 SUM(E30:J30)------- C30-K30J30)"577 P0014/P004/P004/P004/P0015P004/P004/P000 P004/ SUM(E31:J31)------- C31-K31J31)"t. EP00aEP00aEP00EP00.07P0015P00.07P00.07P000 P00.07 SUM(E32:J32)------- C32-K32J32) "6 Ne P007/8 P00/8 P00/8 P00/8 P00/8 P00/8 P00/8 P000 P00/8 SUM(E33:J33)------- P00!'-----------------------------------"" TOTAL--"SUM(C9:C33)--------"SUM(E9:E33)--------"SUM(G9:G33)--------"SUM(H9:H33)--------"SUM(I9:I33)-------- "SUM(J9:J33)-------- "SUM(K9:K33)-------- "SUM(L9:L33)--------#'-----------------------------------$" POTENTIAL-$SUM(D9:D33)--------&" NET INCREASE POSSIBLE====&D37-C3533)''==================================-('=================================-004/P000 P004/ SUM(E31:J31)------- C31-K31J31)"t. EP00aEP00aEP00EP00.07P0015P00.07P00.07P000 P00.07 SUM(E32:J32)------- C32-K32J32) "6 Ne P007/8 P00/8 P00/8 P00/8 P00/8 P00/8 P00/8 P000 P00/8 SUM(E33:J33)------- P00!'-----------------------------------"" TOTAL--"SUM(C9:C33)--------"SUM(E9:E33)--------"SUM(G9:G33)--------"SUM(H9:H33)--------"SUM(I9:I33)-------- "SUM(J9:J33)-------- "SUM(K9:K33)-------- "SUM(L9:L33)--------#'-----------------------------------$" POTENTIAL-$SUM(D9:D33)--------&" NET INCREASE POSSIBLE====&D37-C3533)''=============== CASHFLW.CA̠ i n analysi too t estimat actual net cas flow from rental property. T us it boo Supercal i th "A drive an thi dis i th "B drive Loa "B:CASHFLW.CAL int th spreadsheet an fil i th blank fo you properties Th syste automaticall total an calculate th columns Thi progra i ver usefu fo tryin t decid objectivel whethe o no t d maintenance hire management, refinance, or rais rents. For this last item, se th "difference cel dow belo "tota rent an "potentia rent" cal thi th "goo guy figure becaus thi i wha i cost i dollar t b "goo guy an kee you rent lo an you tenant happ an solvent. Yo mus mak your own mora decision regardin tha figure an wha th cost ar i yo los tenan becaus o to vigorou desir t lowe it wil no attemp t quantif thos implications The ar different for every property and every person. I hope you enjoy the program and find it useful! Copyright (c) 1983 Anthony Hoffman, Realtorl i th "A drive an thi dis i th "B drive Loa "B:CASHFLW.CAL int th spreadsheet an fil i th blank fo you properties Th syste automaticall total an calculate th columns Thi progra i ver usefu fo tryin t decid objectivel whethe o no t d maintenance hire management, refinance, or rais rents. For this last item, se th "difference cel dow belo "tota rent an "potentia rent" cal thi th "goo guy figure becaus thi i wha i cost i dollar t b "goo guy an kee you rent lo an you tenant happ an solvent. Yo mus mak your own mora decision regardin tha figure an wha th cost ar i yo los tenan becaus o to vigorou desir t lowe it wil no attemp t quantif thos implications The ar different for every property and every pSuperCalc Ver. 1.05 L            4: !"STOCK PORTFOLIO "" FROM THE PURCHASE DATES THRU THIS DATE100!"STOCK PORTFOLIO6.88)-1)*100 " ||C@((C3 "% CHANGE OF"AS OF __/__/__ "D.J.IND>>"12__.__ERROR4  '----------- "FROM THE PUR"AS OF __/__/__67.92)-1)*100 "SHARE "SHARE1)*100 " ||)-1)*100 "MKT PRICE OF "MKT PRICE "========== "========= "EST. "EST.ATEDOCK "EST. "EST. EST.  "CAPITAL  "% CAPITAL  "D.J.AVG  " % D.J.IND "VALUE LINE "% OF % "% OFq@((C3 " ||)-1)*100!"1 SHARE OF EA. "TOTAL "MARKET "TOTAL "ANNUAL-82 "TOTAL "ANNUAL "ANNUAL  "GAIN  "GAIN  "PURCHASE  " GAIN OR "INDUSTRY " TOTALL "TOTAL1)*100 " || gp((C2 "COMPANY'SCK!"NAME OF STOCK "NO. OF "PRICE "MARKET "COSTOST "DIV.END "ANNUAL "YIELD "YIELD  "OR  "OR  "DATE  " LOSS!"NAME OF STOCK963.99)-1)*100!"CLASSIF.ATION "MARKET "COSTR ((C3 " ||)-1)*100 " STOCK SINCE "SHARES "PER SHR "VALUE "RATE "DIVS. "ON MKT "ON COST  "LOSS  "LOSS  "(SEE N47)  " (SEE N47) "VALUE " ||)-1)*100" __/__/__ " ||1WP((C3 " (SEE N51) "(SEE N51)D67PB9*C9C&@B9*F9ArWsXv((G9/D9)*100Ah"a5$7(G9/E9)*100 #pD9-E9 YD(J9/E9)*100 ERROR((C3/L9)-1)*100100A@P!d)(D9/D39)*100A!R5h'(E9/E39)*1001)*100 " ||)-1)*100ERROR((C9/V9)-1)*10000 DuB10*C10 C B10*F10 ArWsXv((G10/D10)*100 AdyQ4GDGe(G10/E10)*100 !@D10-E10 r&Y5(J10/E10)*100 ERROR((C4/L10)-1)*10000 @T6!D(D10/D39)*100 A3sCy(X(E10/E39)*100 " || ERROR((C10/V10)-1)*1000 D5a%B11*C11 C&@B11*F11 Attt(G11/D11)*100 AHxXeW(G11/E11)*100 6fD11-E11 4S0XC(J11/E11)*100 ERROR((C5/L11)-1)*10000 A#UU(D11/D39)*100 A0aPr(E11/E39)*100 " || ERROR((C11/V11)-1)*1000Ap$y3B((C1 DYuB12*C12 CTB12*F12 A7eivV(G12/D12)*100 BBQQ8(G12/E12)*100 DgD12-E12 B!vY15!(J12/E12)*100 ERROR((C6/L12)-1)*10000 A1P9iW(D12/D39)*100 A')d9Af"(E12/E39)*100 " || ERROR((C12/V12)-1)*10002/51.00)-1)*100 DYuB13*C13 CTB13*F13 A7eivV(G13/D13)*100 AeU69A(G13/E13)*100 C pD13-E13 A614dD6(J13/E13)*100 ERROR((C7/L13)-1)*10000 A1P9iW(D13/D39)*100 A29&7(E13/E39)*100 " || ERROR((C13/V13)-1)*1000 D8uB14*C14 C5B14*F14 A7eivV(G14/D14)*100 Ag080dR(G14/E14)*100 0GD14-E14 wCrVXG(J14/E14)*100 ERROR((C8/L14)-1)*10000 A quFP"(D14/D39)*100 A!w0HiF'y(E14/E39)*100 " || ERROR((C14/V14)-1)*1000DPCuB15*C15CB15*F15A5hw24 C(G15/D15)*100AVv(W X%(G15/E15)*100 DrfD15-E15 BYAB&e9'(J15/E15)*100 ERROR((C9/L15)-1)*10000A&pgXSX(D15/D39)*100AcPV(E15/E39)*100 " ||ERROR((C15/V15)-1)*1000DyiPB16*C16C"B16*F16A(`rs2(G16/D16)*100A(16%UR(G16/E16)*100 ƒD16-E16 2p"7R(J16/E16)*100 ERROR((C10/L16)-1)*1000ABQQg1r(D16/D39)*100ADy32Y'r7(E16/E39)*100 " ||ERROR((C16/V16)-1)*1000DerPB17*C17C0B17*F17AF$haG(G17/D17)*100ARgFU(G17/E17)*100 Cfr D17-E17 B)Q(J17/E17)*100 ERROR((C11/L17)-1)*1000A5%C FR(D17/D39)*100A2!eb(E17/E39)*100 " ||ERROR((C17/V17)-1)*1000B`@&V7X@((C1DV7PB18*C18CQpB18*F18Aps1ps(G18/D18)*100B& Id9C(G18/E18)*100 CYD18-E18 BsDR(J18/E18)*100 ERROR((C12/L18)-1)*1000A0Ef%'5r(D18/D39)*100A(p$Vr(E18/E39)*100 " ||ERROR((C18/V18)-1)*1000D0I7PB19*C19C @B19*F19AfTp82u(G19/D19)*100AUt(`c(G19/E19)*100 `uD19-E19 ffffffg(J19/E19)*100 ERROR((C13/L19)-1)*1000A&v)RP(D19/D39)*100A 5GeSQv(E19/E39)*100 " ||ERROR((C19/V19)-1)*10008/35.00)-1)*100E B20*C20CtB20*F20AC2U9SI(G20/D20)*100AuxU(G20/E20)*100 Ds47D20-E20 Bt4&BQ(J20/E20)*100 ERROR((C14/L20)-1)*1000Aut4)0(D20/D39)*100ATpq(E20/E39)*100 " ||ERROR((C20/V20)-1)*1000BaiI%@((C2EB21*C21DB21*F21B@3a4E8(G21/D21)*100AEHir1b(G21/E21)*100 !BPD21-E21 %rTv#(e(J21/E21)*100 ERROR((C15/L21)-1)*1000AcH3AbD(D21/D39)*100Ax!#V3p(E21/E39)*100 " ||ERROR((C21/V21)-1)*10001/27.75)-1)*100DcCuB22*C22CBB22*F22Af hU$(G22/D22)*100A`r S&c(G22/E22)*100 V!D22-E22 @g1pfG(J22/E22)*100 ERROR((C16/L22)-1)*1000A3""Uq%(D22/D39)*100A8AFDdw(E22/E39)*100 " ||ERROR((C22/V22)-1)*1000E!4huB23*C23CB23*F23A7Fd U(G23/D23)*100AhR00(G23/E23)*100 DXPD23-E23 ByUW4qS(J23/E23)*100 ERROR((C17/L23)-1)*1000B8y$WT(D23/D39)*100Af)Hb(E23/E39)*100 " ||ERROR((C23/V23)-1)*1000D&B24*C24BPB24*F24A#i#i#(G24/D24)*100Ai'w42(G24/E24)*100 QVD24-E24 (yuUuS(J24/E24)*100 ERROR((C18/L24)-1)*1000A GB(D24/D39)*100A 1u4$(E24/E39)*100 " ||ERROR((C24/V24)-1)*1000A9(W(W((C2DRDuB25*C25CIrB25*F25AHH(G25/D25)*100BfyHBs(G25/E25)*100 DQD25-E25 B3a`3fx(J25/E25)*100 ERROR((C19/L25)-1)*1000A'I$$(D25/D39)*100A!CHuG(E25/E39)*100 " ||ERROR((C25/V25)-1)*1000/35.00)-1)*100EPB26*C26CUPB26*F26ATHH(G26/D26)*100A`ACDC66(G26/E26)*100 C@D26-E26 B!SX7u(J26/E26)*100 ERROR((C20/L26)-1)*1000ATArfB(D26/D39)*100AQ &Bv(E26/E39)*100 " ||ERROR((C26/V26)-1)*1000DPB27*C27B&B27*F27AqBqB(G27/D27)*100A)6tfp(G27/E27)*100 bD27-E27 &d Q(J27/E27)*100 ERROR((C21/L27)-1)*1000@5xU3(D27/D39)*100AIpEB1(E27/E39)*100 " ||ERROR((C27/V27)-1)*1000B hU$((C2DquB28*C28CS`B28*F28Atp82u&$(G28/D28)*100A6T'U6F`V(G28/E28)*100 tuD28-E28 Q1Xc(D(J28/E28)*100 ERROR((C22/L28)-1)*1000A8'g hS(D28/D39)*100AYbqf)(E28/E39)*100 " ||ERROR((C28/V28)-1)*1000DH7PB29*C29C B29*F29AA46i%E(G29/D29)*100Ad#v'(y9(G29/E29)*100 D$D29-E29 BU7Gb2w(J29/E29)*100 ERROR((C23/L29)-1)*1000A%gxX(D29/D39)*100A1ib(E29/E39)*100 " ||ERROR((C29/V29)-1)*10008/35.00)-1)*100D7PB30*C30C%RB30*F30AgC)Pp(G30/D30)*100A6S4EVwB(G30/E30)*100 2D30-E30 E%`AC(J30/E30)*100 ERROR((C24/L30)-1)*1000A i6)(D30/D39)*100A8e3D)(E30/E39)*100 " ||ERROR((C30/V30)-1)*1000AcUF!((C3EPB31*C31CHB31*F31A@Yf3aR(G31/D31)*100ATE&7T11(G31/E31)*100 D0D31-E31 B4cAF4c(J31/E31)*100 ERROR((C25/L31)-1)*1000Ac26S(X(D31/D39)*100AI8xC v(E31/E39)*100 " ||ERROR((C31/V31)-1)*10001/83.00)-1)*100D3uB32*C32CB32*F32A0($W!(G32/D32)*100AFhG((G32/E32)*100 Df%D32-E32 BTfU(J32/E32)*100 ERROR((C26/L32)-1)*1000ApFPBr(D32/D39)*100A3 1H (E32/E39)*100 " ||ERROR((C32/V32)-1)*1000 D9uB33*C33 C(B33*F33 ApDQW#'(G33/D33)*100 AGqSpU0 (G33/E33)*100 D33-E33 2&9t$(J33/E33)*100 ERROR((C27/L33)-1)*1000 A! Uicr(D33/D39)*100 A2drV(E33/E39)*100 " || ERROR((C33/V33)-1)*1000B8&iVR@((C3!DI%B34*C34!CB$B34*F34!Ab5Sr(G34/D34)*100!Av&@30#(G34/E34)*100 !TpD34-E34 !x#a(B(J34/E34)*100 !ERROR((C28/L34)-1)*1000!A&bi7cX(D34/D39)*100!A0rry(E34/E39)*100! " ||!ERROR((C34/V34)-1)*1000"DB35*C35"C6B35*F35"A8)xr4%S(G35/D35)*100"A3w8e(G35/E35)*100 "`D35-E35 "BCS(J35/E35)*100 "ERROR((C29/L35)-1)*1000"APer(D35/D39)*100"AY)gRv'(E35/E39)*100" " ||"ERROR((C35/V35)-1)*1000A9(W(W((C3#DF7PB36*C36#C"B36*F36#AID HQu (G36/D36)*100#AGiYq(G36/E36)*100 # V0D36-E36 #BEyyU(J36/E36)*100 #ERROR((C30/L36)-1)*1000#A$s1f$P(D36/D39)*100#A&X8b(E36/E39)*100# " ||#ERROR((C36/V36)-1)*10006/42.00)-1)*100$D8rB37*C37$B8@B37*F37$@5Sq&(G37/D37)*100$AtWR%(G37/E37)*100 $C)hD37-E37 $Ac4uG(J37/E37)*100 $ERROR((C31/L37)-1)*1000$A e`35)(D37/D39)*100$Ar2biC(E37/E39)*100$ " ||$ERROR((C37/V37)-1)*1000% " -------%!" ---------*C38% " ---------%!" --------38*F38 % " -------G38 %ERROR((C32/L38)-1)*100%!" -------D38/D39)*100% " -------% " ||& " TOTALS&DASUM(B8:B38)&FtPuSUM(D8:D38)&FscSUM(E8:E38)&ErgSUM(G8:G38)&AW"E$0(G39/D39)*100&AYfaid(G39/E39)*100 &DvwD39-E39 &ABpCrY(J39/E39)*100 &ERROR((C33/L39)-1)*100& " TOTALS(C3&CSUM(R8:R38)0&CSUM(S8:S38)& " ||&!" AVERAGERAGE(T9:T38)100'!"===============,D25,D29)RRO' "=========' "=========B49'!"=============E4 SUM('!"=============)' "=========D49' "==========' "=========49-' "========= ' "============ '!"=============DSUM( '!"=============) ' "===OR(H49'!"===============ERROR(H49' "====0' "============' "=========' "=========B50' " ||'ERRORAVERAGE(U8:U37)(!"STOCK PORTFOLIOERRORSUM(( " BY(!" TOTALS OF EAERROR(H51( "CH CLASSI( "FICATION--M(( "-----FROMRRO( " PURCHASE ( " TO DATE(B52( " ||)"AS OF __/__/__)!" -------ERRORSUM()!"-------------)) "----------52) "----------) "---------) "--------- ) "------------ )!"-------------ERRORSUM() " ||) " D.J.IND) "D.J.AVG* "BYTOTALS OF * "BY DATE(F50* "EST. TOTAL* "ANNUALED* "ANNUAL0 * "CAPITAL * "% CAPITAL* " ||* " % CHANGER+!"(FORMULAS MUST BE ADJUSTED+ "MARKETIFICAT+ "COST0+ "ANNUAL(H50+ "YIELD0(G8/+ "YIELDSUM( + "GAIN ORB51- + "GAIN ORSUM(+ " ||+ERROR((C3/V44)-1)*10000,!"TO CORRESPOND TO GROUPING), "VALUEM PURCH, "DIVS., "ON MKTx(E20, "ON COST) , "LOSS , "LOSSROR), " ||.EFPSUM(D22,D26),D26).E %SUM(E22,E26)*B12.CPSUM(G22,G26).AY 0610(G47/D47)*100.A`Xr0a"B(G47/E47)*100 .C7bPD47-E47.95)-1)*100 .A#8VsEe(J47/E47)*100KRAFT.#"NOTE: THE D.J.IND. USED IN THIS FORMULA MUST BE/EDESUM(D17,D37)30)/DHSUM(E17,E37)B15*/C4dSUM(G17,G37)/A3W0ya(G48/D48)*100/A6S452(G48/E48)*100(H50 /C@ D48-E48 /BrH$(J48/E48)*100/#" THE D.J.IND. CLOSING AVERAGE ON THE STOCK'S0DfbPSUM(D11,D19)31)0DWSUM(E11,E19)BU(G150CFSUM(G11,G19)0ApyQ!I%S(G49/D49)*1000AQg&HVI(G49/E49)*100(D51 0$FSPD49-E49 0'!d(J49/E49)*1000!" PURCHASE DATE.ED IN TH1ESUM(D15,D32,D36)1Eg SUM(E15,E32,E36)G151CPSUM(G15,G32,G36)1A9SaSb(G50/D50)*1001APa1)(G50/E50)*100R) 1D(3(D50-E50 1B'gQR(J50/E50)*1002E!4huSUM(D23)29,D33)2E SUM(E23)pD15-2CSUM(G23)01)-1)*1002A7Fd U(G51/D51)*1002AhR00(G51/E51)*100 2DXPD51-E51 2ByUW4qS(J51/E51)*1002#"NOTE: THIS COLUMN CONTAINS FORMULAS WHICH GIVE3E"PSUM(D18,D25)34)3DcvSUM(E18,E25)H6(J153D(SUM(G18,G25)R NATL 3A Iwi02(G52/D52)*1003B1S@76)(G52/E52)*100 3DID52-E52 3B!@'7$A(J52/E52)*1003#" THE MARKET PRICE OF EACH STOCK ON THE DATE4EPSUM(D31)32,D36)4DSUM(E31)6h9P((C34CHSUM(G31)NKSG4A@Yf3aR(G53/D53)*1004ATE&7T11(G53/E53)*100 4D0D53-E53 4B4cAF4c(J53/E53)*1004#" ENTERED ON CELL T 7. IF YOU CHANGE THE T 75EDuSUM(D9,D10,D34)5EDISUM(E9,E10,E34)5CSUM(G9,G10,G34)5Ax3E)y"(G54/D54)*1005AqPx3390(G54/E54)*100 5ÙtD54-E54 5y11&7(J54/E54)*1005#" DATE, YOU MUST CHANGE THE MARKET VALUES OF6DquSUM(D28)34,D38)6EfwPSUM(E28)74)-1)*1006CS`SUM(G28)*1006Atp82u&$(G55/D55)*1006A6T'U6F`V(G55/E55)*100 6tuD55-E55 6Q1Xc(D(J55/E55)*1006""   EACH STOCK TO CORRESPOND!7EeSUM(D21,D30,D33)7E&`SUM(E21,E30,E33)D157D5 SUM(G21,G30,G33)007A&&q@f(G56/D56)*1007AdQQEUPG(G56/E56)*100 7r6QD56-E56 7&U!(J56/E56)*1008E SUM(D20)36,D40)8DecSUM(E20)6Ectxq(E158CtSUM(G20)8AC2U9SI(G57/D57)*1008AuxU(G57/E57)*100 8Ds47D57-E57 8Bt4&BQ(J57/E57)*1009E6SUM(D16,D35)41)9Eq&`SUM(E16,E35)9CXSUM(G16,G35)9A3$BI(G58/D58)*1009A1B%wGU(G58/E58)*100 9CD58-E58 9qwCx4T(J58/E58)*100:DH7PSUM(D29)38,D42):D1DSUM(E29)27.2:C SUM(G29).025)*B18:AA46i%E(G59/D59)*100:Ad#v'(y9(G59/E59)*100 :D$D59-E59 :BU7Gb2w(J59/E59)*100;DCPSUM(D24,D27)43);D`!SUM(E24,E27)B19*;BvSUM(G24,G27);AGd6x (G60/D60)*100;Abd4Q(g(G60/E60)*100 ;qD60-E60 ;'v3v4W(J60/E60)*100<E7PSUM(D12,D13,D14)<EXp0SUM(E12,E13,E14)249<D1SUM(G12,G13,G14)<A7eivV(G61/D61)*100v(D20<AG$ C(G61/E61)*100 <DFrD61-E61 <AFwXY(J61/E61)*100=!" -----------=!" -----------A$2.4=!" -----------D20)*100 = " ----------> "TOTALS(B53>FtPuSUM(D46:D62)23.5>FscSUM(E46:E62)>ErgSUM(G46:G62)>AW"E$0(G63/D63)*100(D50>AYfaid(G63/E63)*100 >DvwSUM(J46:J62) >ABpCrY(J63/E63)*100Ad#v'(y9(G59/E59)*100 :D$D59-E59 :BU7Gb2w(J59/E59)*100;DCPSUM(D24,D27)43).op STOCK PORTFOLIO ANALYSIS TEMPLATE by REUBEN SAND April 14, 1983 Thi templat i t assis stoc marke investo t recor an analyz portfoli o commo stocks. Th progra i don i "SuperCalc whic i trad mar o Sorci Corp.. Afte loadin SuperCal int driv A loa th Templat Dis int driv and afte initializin SuperCalc type /LB:ELN >ADFT1046.54  "------------ !"------------- !"-------------IS DATE6@((C3 "AS OF 12-31-8267.92)-1)*100 "SHARE "SHARE1)*100 " ||)-1)*100 "MKT PRICE OF "========== "========= "EST. "EST.ATEDOCK "EST. "EST. EST.  "CAPITAL  "% CAPITAL  " % D.J.IND "VALUE LINE "% OF % "% OFq@((C3 " ||)-1)*100!"1 SHARE OF EA. "TOTAL "MARKET "TOTAL "ANNUAL-82 "TOTAL "ANNUAL "ANNUAL  "GAIN  "GAIN  " GAIN OR "INDUSTRY " TOTALL "TOTAL1)*100 " || gp((C2 "COMPANY'SCK!"NAME OF STOCK "NO. OF "PRICE "MARKET "COSTOST "DIV.END "ANNUAL "YIELD "YIELD  "OR  "OR  " LOSS !"NAME OF STOCK963.99)-1)*100!"CLASSIF.ATION "MARKET "COSTR ((C3 " ||)-1)*100 " STOCK SINCE "SHARES "PER SHR "VALUE "RATE "DIVS. "ON MKT "ON COST  "LOSS  "LOSS  " (SEE N47) "VALUE " ||)-1)*100" 6-30-82 " ||1WP((C3 " (SEE N51)"AETNA LIFE & C@C100AB67P36.375D67PB9*C9aD8i73869.37.025)*B9AA&@2.64C&@B9*F9ArWsXv((G9/D9)*100Ah"a5$7(G9/E9)*100 #pD9-E9 YD(J9/E9)*100 B X76@((C3/867.92)-1)*100 "AETNA LIFE & C76.88)-1)*100"INSURANCEA@P!d)(D9/D39)*100A!R5h'(E9/E39)*1001)*100 " ||)-1)*100A9(W(W((C9/35.00)-1)*100 " AETNA L & C @BP50 AB67P36.375  DuB10*C10 aD 72037.19 AA&@2.64 C B10*F10 ArWsXv((G10/D10)*100 AdyQ4GDGe(G10/E10)*100 !@D10-E10 r&Y5(J10/E10)*100 Aq0V((C3/976.88)-1)*100 " AETNA L & C " INSURANCE @T6!D(D10/D39)*100 A3sCy(X(E10/E39)*100 " || "ALLIED CORP. @C110 AB27P32.375 D5a%B11*C11 aDS5397.911.025)*B10 @A$2.4 C&@B11*F11 Attt(G11/D11)*100 AHxXeW(G11/E11)*100 6fD11-E11 4S0XC(J11/E11)*100 B X76@((C3/867.92)-1)*100 "ALLIED CORP. "CHEMICALD38- A#UU(D11/D39)*100 A0aPr(E11/E39)*100 " || Ap$y3B((C11/30.25)-1)*100Ap$y3B((C1 "AMER TEL & TEL @C100 ABYu59.75 DYuB12*C12 aDI4907.18.025)*B11 @AT5.4 CTB12*F12 A7eivV(G12/D12)*100 BBQQ8(G12/E12)*100 DgD12-E12 B!vY15!(J12/E12)*100 Ac6h9P((C3/963.99)-1)*100 "AMER TEL & TEL75.92)-1)*100 "TELECOM A1P9iW(D12/D39)*100 A')d9Af"(E12/E39)*100 " || BhbtP((C12/51.00)-1)*1002/51.00)-1)*100 " AMER T & T @C100 ABYu59.75 DYuB13*C13 aDWec5765.63 @AT5.4 CTB13*F13 A7eivV(G13/D13)*100 AeU69A(G13/E13)*100 C pD13-E13 A614dD6(J13/E13)*100 Aq0V((C3/976.88)-1)*100 " AMER T & T3 " TELECOM A1P9iW(D13/D39)*100 A29&7(E13/E39)*100 " || " AMER T & T @Be65 ABYu59.75 D8uB14*C14 aD9"3914.22 @AT5.4 C5B14*F14 A7eivV(G14/D14)*100 Ag080dR(G14/E14)*100 0GD14-E14 wCrVXG(J14/E14)*100 BGG`((C3/875.92)-1)*100 " AMER T & T " TELECOM A quFP"(D14/D39)*100 A!w0HiF'y(E14/E39)*100 " ||"BRISTOL MEYERS@Bu75ABg%67.25DPCuB15*C15aD1q 3171.09.025)*B13@A$2.4CB15*F15A5hw24 C(G15/D15)*100AVv(W X%(G15/E15)*100 DrfD15-E15 BYAB&e9'(J15/E15)*100 B$wRXR ((C3/838.74)-1)*100 "BRISTOL MEYERS76.88)-1)*100"DRUGSA&pgXSX(D15/D39)*100AcPV(E15/E39)*100 " ||B v@D@((C15/55.625)-1)*100"BURL NORTHERN@C150ABS53.13DyiPB16*C16aDRf8052.661.025)*B14AA 1.52C"B16*F16A(`rs2(G16/D16)*100A(16%UR(G16/E16)*100 ƒD16-E16 2p"7R(J16/E16)*100 Aq0V((C3/976.88)-1)*100 "BURL NORTHERN811.93)-1)*100"RR/RESOURCESABQQg1r(D16/D39)*100ADy32Y'r7(E16/E39)*100 " ||B92XBif0((C16/44.50)-1)*100"CBS. INC.@C110ABYu59.75DerPB17*C17aDY(5905.281.025)*B15@A(2.8C0B17*F17AF$haG(G17/D17)*100ARgFU(G17/E17)*100 Cfr D17-E17 B)Q(J17/E17)*100 B(SHC@((C3/811.93)-1)*100 "CBS. INC.(C3"BRDCST/CABLEA5%C FR(D17/D39)*100A2!eb(E17/E39)*100 " ||B`@&V7X@((C17/37.25)-1)*100B`@&V7X@((C1"CON EDISON NYD@C'P275AB P20.5DV7PB18*C18aDP8R5038.521.025)*B16AA1.88CQpB18*F18Aps1ps(G18/D18)*100B& Id9C(G18/E18)*100 CYD18-E18 BsDR(J18/E18)*100 B(SHC@((C3/811.93)-1)*100 "CON EDISON NY805.01)-1)*100"ELEC UTILA0Ef%'5r(D18/D39)*100A(p$Vr(E18/E39)*100 " ||BhShSp((C18/17.875)-1)*100"DU PONT, E.I.@B85AB5P35.875D0I7PB19*C19aD6Y%3659.25.025)*B19@A$2.4C @B19*F19AfTp82u(G 19/D19)*100AUt(`c(G19/E19)*100 `uD19-E19 ffffffg(J19/E19)*100 Ac6h9P((C3/963.99)-1)*100 "DU PONT, E.I.963.99)-1)*100"CHEMICALA&v)RP(D19/D39)*100A 5GeSQv(E19/E39)*100 " ||A((C19/33.00)-1)*1008/35.00)-1)*100"EASTMAN KODAK@C 200@B86E B20*C20aDec9865.631.025)*B20@A73.7CtB20*F20AC2U9SI(G20/D20)*100AuxU(G20/E20)*100 Ds47D20-E20 Bt4&BQ(J20/E20)*100 B$wRXR ((C3/838.74)-1)*100 "EASTMAN KODAK838.74)-1)*100"PRECIS INSTRAut4)0(D20/D39)*100ATpq(E20/E39)*100 " ||BaiI%@((C20/73.75)-1)*100BaiI%@((C2"EXXON@C@400AB)u29.75EB21*C21aE%14042.5.025)*B21@A03DB21*F21B@3a4E8(G21/D21)*100AEHir1b(G21/E21)*100 !BPD21-E21 %rTv#(e(J21/E21)*100 Aq0V((C3/976.88)-1)*100 "EXXON((C3"PETROLEUMAcH3AbD(D21/D39)*100Ax!#V3p(E21/E39)*100 " ||Ar r r((C21/27.75)-1)*1001/27.75)-1)*100"FIRST CHICAGO@C5350ABP18.125DcCuB22*C22aDi6905.94.025)*B22@A1.2CBB22*F22Af hU$(G22/D22)*100A`r S&c(G22/E22)*100 V!D22-E22 @g1pfG(J22/E22)*100 BGG`((C3/875.92)-1)*100 "FIRST CHICAGO875.92)-1)*100"BANKSA3""Uq%(D22/D39)*100A8AFDdw(E22/E39)*100 " ||BT gp((C22/15.50)-1)*100"GENERAL ELEC@C"P225ABP94.875E!4huB23*C23aE 11888.72025)*B23@A63.6CB23*F23A7Fd U(G23/D23)*100AhR00(G23/E23)*100 DXPD23-E23 ByUW4qS(J23/E23)*100 B X76@((C3/867.92)-1)*100 "GENERAL ELEC"ELEC EQUIPB8y$WT(D23/D39)*100Af)Hb(E23/E39)*100 " ||BIYUY((C23/63.625)-1)*100"INLAND STEEL@C100@B&26D&B24*C24aD6QV3651.561.025)*B24@@P.5BPB24*F24A#i#i#(G24/D24)*100Ai'w42(G24/E24)*100 QVD24-E24 (yuUuS(J24/E24)*100 B$wRXR ((C3/838.74)-1)*100 "INLAND STEEL"STEEL(INTEG)A GB(D24/D39)*100A 1u4$(E24/E39)*100 " ||B2H@vC1!((C24/19.625)-1)*100A9(W(W((C2"MONTANA-DAK UT@C" 222AB#bP23.625DRDuB25*C25aD9%$3925.24.025)*B25AA"@2.24CIrB25*F25AHH(G25/D25)*100BfyHBs(G25/E25)*100 DQD25-E25 B3a`3fx(J25/E25)*100 B$)Q@((C3/841.98)-1)*100 "MONTANA-DAK UT38.74)-1)*100"ELEC UTILA'I$$(D25/D39)*100A!CHuG(E25/E39)*100 " ||B94x&((C25/20.125)-1)*100/35.00)-1)*100"MORGAN, JP & CO@C150ABgP67.5EPB26*C26aDV9186.56.025)*B26@A73.7CUPB26*F26ATHH(G26/D26)*100A`ACDC66(G26/E26)*100 C@D26-E26 B!SX7u(J26/E26)*100 Aq0V((C3/976.88)-1)*100 "MORGAN, JP & CO1.98)-1)*100"BANKSATArfB(D26/D39)*100AQ &Bv(E26/E39)*100 " ||B0CG`p((C26/51.75)-1)*100"NATIONAL STEEL@C100ABP17.5DPB27*C27aD#p12370.311.025)*B27@@&.26B&B27*F27AqBqB(G27/D27)*100A)6tfp(G27/E27)*100 bD27-E27 &d Q(J27/E27)*100 BGG`((C3/875.92)-1)*100 "NATIONAL STEEL76.88)-1)*100"STEEL(INTEG)@5xU3(D27/D39)*100AIpEB1(E27/E39)*100 " ||B hU$((C27/14.50)-1)*100B hU$((C2"NORTHWEST IND@C 200AB5P35.875DquB28*C28aEfwP14667.75025)*B28AA&2.68CS`B28*F28Atp82u& $(G28/D28)*100A6T'U6F`V(G28/E28)*100 tuD28-E28 Q1Xc(D(J28/E28)*100 B`EqBq@((C3/875.00)-1)*100 "NORTHWEST IND875.92)-1)*100"MULTIFORMA8'g hS(D28/D39)*100AYbqf)(E28/E39)*100 " ||1P5y"g0((C28/52.375)-1)*100"PENNEY, J.C.@C100ABH7P48.375DH7PB29*C29aD1D3113.441.025)*B29@A 2C B29*F29AA46i%E(G29/D29)*100Ad#v'(y9(G29/E29)*100 D$D29-E29 BU7Gb2w(J29/E29)*100 B03SVP((C3/805.01)-1)*100 "PENNEY, J.C."RETAIL STOREA%gxX(D29/D39)*100A1ib(E29/E39)*100 " ||B)((C29/37.50)-1)*1008/35.00)-1)*100"PHILLIPS PETRO@C`116AB2bP32.625D7PB30*C30aDi86985.38.025)*B30@A"2.2C%RB30*F30AgC)Pp(G30/D30)*100A6S4EVwB(G30/E30)*100 2D30-E30 E%`AC(J30/E30)*100 B`EqBq@((C3/875.00)-1)*100 "PHILLIPS PETRO75.00)-1)*100"PETROLEUMA i6)(D30/D39)*100A8e3D)(E30/E39)*100 " ||AcUF!((C30/29.75)-1)*100AcUF!((C3"PROCTOR & GAMBLE@C100ACP118.25EPB31*C31aD88150*1.025)*B31@AH4.8CHB31*F31A@Yf3aR(G31/D31)*100ATE&7T11(G31/E31)*100 D0D31-E31 B4cAF4c(J31/E31)*100 B'yc9S((C3/818.95)-1)*100 "PROCTOR & GAMBLE.01)-1)*100"HOUSEHD PRODAc26S(X(D31/D39)*100AI8xC v(E31/E39)*100 " ||BBFyQr0((C31/83.00)-1)*1001/83.00)-1)*100"SQUIBB CORP.@Bu75ABD%44.25D3uB32*C32aD!RP2152.51.025)*B32AA@1.34CB32*F32A0($W!(G32/D32)*100AFhG((G32/E32)*100 Df%D32-E32 BTfU(J32/E32)*100 B03SVP((C3/805.01)-1)*100 "SQUIBB CORP."DRUGSApFPBr(D32/D39)*100A3 1H (E32/E39)*100 " ||B(rrrrrrp((C32/34.375)-1)*100 "ST. OIL OF IND @C100 AB9u39.75 D9uB33*C33 aDXh5868.13.025)*B33 @A(2.8 C(B33*F33 ApDQW#'(G33/D33)*100 AGqSpU0 (G33/E33)*100 D33-E33 2&9t$(J33/E33)*100 B X76@((C3/867.92)-1)*100 "ST. OIL OF IND18.95)-1)*100 "PETROLEUM A! Uicr(D33/D39)*100 A2drV(E33/E39)*100 " || B8&iVR@((C33/28.75)-1)*100B8&iVR@((C3!"USF&G CORP!@C110!ABE7P45.375!DI%B34*C34!aDU845538.341.025)*B34!AA8@3.84!CB$B34*F34!Ab5Sr(G34/D34)*100!Av&@30#(G34/E34)*100 !TpD34-E34 !x#a(B(J34/E34)*100 !Aq0V((C3/976.88)-1)*100 !"USF&G CORP0!"INSURANCE!A&bi7cX(D34/D39)*100!A0rry(E34/E39)*100! " ||!B YdE0((C34/37.625)-1)*100""UNION PACIFIC"@C 200"@BG47"DB35*C35"aEf10660.1.025)*B35"AA1.8"C6B35*F35"A8)xr4%S(G35/D35)*100"A3w8e(G35/E35)*100 "`D35-E35 "BCS(J35/E35)*100 "B`EqBq@((C3/875.00)-1)*100 ""UNION PACIFIC805.01)-1)*100""RR/RESOURCES"APer(D35/D39)*100"AY)gRv'(E35/E39)*100" " ||"B8tSE8tP((C35/33.875)-1)*100A9(W(W((C3#"UPJOHN#@C100#ABF7P46.375#DF7PB36*C36#aDHC4843.13.025)*B36#AA"2.28#C"B36*F36#AID HQu (G36/D36)*100#AGiYq(G36/E36)*100 # V0D36-E36 #BEyyU(J36/E36)*100 #B$wRXR ((C3/838.74)-1)*100 #"UPJOHN@((C3#"DRUGS#A$s1f$P(D36/D39)*100#A&X8b(E36/E39)*100# " ||#BAfffffp((C36/42.00)-1)*1006/42.00)-1)*100$"VIACOM INT.$@C128$AB0%30.25$D8rB37*C37$aD5u 3575.21.025)*B37$@@0.3$B8@B37*F37$@5Sq&(G37/D37)*100$AtWR%(G37/E37)*100 $C)hD37-E37 $Ac4uG(J37/E37)*100 $B`EqBq@((C3/875.00)-1)*100 $"VIACOM INT.$"BRDCST/CABLE$A e`35)(D37/D39)*100$Ar2biC(E37/E39)*100$ " ||$BY!&1WP((C37/19.00)-1)*100% " -------%!" ---------*C38% " ---------%!" --------38*F38 % " -------G38%!" -------D38/D39)*100% " -------% " ||&" TOTALS,&DASUM(B8:B38)&FtPuSUM(D8:D38)&FscSUM(E8:E38)&ErgSUM(G8:G38)&AW"E$0(G39/D39)*100&AYfaid(G39/E39)*100 &DvwD39-E39 &ABpCrY(J39/E39)*100 &" TOTALS,(C3&CSUM(Q8:Q38)0&CSUM(R8:R38)& " ||&!" AVERAGERAGE(T9:T38)100'"===============,D25,D29)RRO' "=========' "=========B49'!"=============E4 SUM('!"=============)' "=========D49' "==========' "=========49-' "========= ' "============ '!"=============DSUM( '!"=============) ' "===OR(H49 '!"===============ERROR(H49' "====0' "============' "=========' "=========B50' " ||'B"dhyAVERAGE(T8:T37)("STOCK PORTFOLIOERRORSUM(( " BY(!" TOTALS OF EAERROR(H51( "CH CLASSI( "FICATION--M(( "-----FROMRRO( " PURCHASE ( " TO DATE(B52( " ||)"AS OF 12-31-82)!" -------ERRORSUM()!"-------------)) "---------D52) "---------) "---------) "--------- ) "------------ )!"-------------ERRORSUM() " ||) " D.J.IND* "BYTOTALS OF * "BY DATE(F50* "EST. TOTAL* "ANNUALED* "ANNUAL0 * "CAPITAL * "% CAPITAL* " ||* " % CHANGER+ "MARKETIFICAT+ "COST0+ "ANNUAL(H50+ "YIELD0(G8/+ "YIELDSUM( + "GAIN ORB51- + "GAIN ORSUM(+ " ||+B(SHC@((C3/811.93)-1)*100, "VALUEM PURCH, "DIVS., "ON MKTx(E20, "ON COST) , "LOSS , "LOSSROR), " ||."BANKING.EFPSUM(D22,D26),D26).E %SUM(E22,E26)*B12.CPSUM(G22,G26).AY 0610(G47/D47)*100.A`Xr0a"B(G47/E47)*100 .C7bPD47-E47.95)-1)*100 .A#8VsEe(J47/E47)*100KRAFT .#"NOTE: THE D.J.IND. USED IN THIS FORMULA MUST BE/"BRDCST/CABLE/EDESUM(D17,D37)30)/DHSUM(E17,E37)B15*/C4dSUM(G17,G37)/A3W0ya(G48/D48)*100/A6S452(G48/E48)*100(H50 /C@ D48-E48 /BrH$(J48/E48)*100 /#" THE D.J.IND. CLOSING AVERAGE ON THE STOCK'S0"CHEMICAL0DfbPSUM(D11,D19)31)0DWSUM(E11,E19)BU(G150CFSUM(G11,G19)0ApyQ!I%S(G49/D49)*1000AQg&HVI(G49/E49)*100(D51 0$FSPD49-E49 0'!d(J49/E49)*100 0!" PURCHASE DATE.ED IN TH1"DRUGS1ESUM(D15,D32,D36)1Eg SUM(E15,E32,E36)G151CPSUM(G15,G32,G36)1A9SaSb(G50/D50)*1001APa1)(G50/E50)*100R) 1D(3(D50-E50 1B'gQR(J50/E50)*1002"ELEC EQUIP2E!4huSUM(D23)29,D33)2E SUM(E23)pD15-2CSUM(G23)01)-1)*1002A7Fd U(G51/D51)*1002AhR00(G51/E51)*100 2DXPD51-E51 2ByUW4qS(J51/E51)*100 2#"NOTE: THIS COLUMN CONTAINS FORMULAS WHICH GIVE3"ELEC UTIL3E"PSUM(D18,D25)34)3DcvSUM(E18,E25)H6(J153D(SUM(G18,G25)R NATL 3A Iwi02(G52/D52)*1003B1S@76)(G52/E52)*100 3DID52-E52 3B!@'7$A(J52/E52)*100 3#" THE MARKET PRICE OF EACH STOCK ON THE DATE4"HOUSEHD PROD4EPSUM(D31)32,D36)4DSUM(E31)6h9P((C34CHSUM(G31)NKSG4A@Yf3aR(G53/D53)*1004ATE&7T11(G53/E53)*100 4D0D53-E53 4B4cAF4c(J53/E53)*100 4#" ENTERED ON CELL T 7. IF YOU CHAGE THE T 75"INSURANCERRO5EDuSUM(D9,D10,D34)5EDISUM(E9,E10,E34)5CSUM(G9,G10,G34)5Ax3E)y"(G54/D54)*1005AqPx3390(G54/E54)*100 5ÙtD54-E54 5y11&7(J54/E54)*100 5#" DATE, YOU MUST CHANGE THE MARKET VALUES OF6"MULTIFORM6DquSUM(D28)34,D38)6EfwPSUM(E28)74)-1)*1006CS`SUM(G28)*1006Atp82u&$(G55/D55)*1006A6T'U6F`V(G55/E55)*100 6tuD55-E55 6Q1Xc(D(J55/E55)*100 6""  EACH STOCK TO CORRESPOND!7"PETROLEUMH527EeSUM(D21,D30,D33)7E&`SUM(E21,E30,E33)D157D5 SUM(G21,G30,G33)007A&&q@f(G56/D56)*1007AdQQEUPG(G56/E56)*100 7r6QD56-E56 7&U!(J56/E56)*1008"PRECIS INSTR8E SUM(D20)36,D40)8DecSUM(E20)6Ectxq(E158CtSUM(G20)8AC2U9SI(G57/D57)*1008AuxU(G57/E57)*100 8Ds47D57-E57 8Bt4&BQ(J57/E57)*1009"RR/RESOURCES9E6SUM(D16,D35)41)9Eq&`SUM(E16,E35)9CXSUM(G16,G35)9A3$BI(G58/D58)*1009A1B%wGU(G58/E58)*100 9CD58-E58 9qwCx4T(J58/E58)*100:"RETAIL STORE:DH7PSUM(D29)38,D42):D1DSUM(E29)27.2:C SUM(G29).025)*B18:AA46i%E(G59/D59)*100:Ad#v'(y9(G59/E59)*100 :D$D59-E59 :BU7Gb2w(J59/E59)*100;"STEEL(INTEG);DCPSUM(D24,D27)43);D`!SUM(E24,E27)B19*;BvSUM(G24,G27);AGd6x (G60/D60)*100;Abd4Q(g(G60/E60)*100 ;qD60-E60 ;'v3v4W(J60/E60)*100<"TELECOM<E7PSUM(D12,D13,D14)<EXp0SUM(E12,E13,E14)249<D1SUM(G12,G13,G14)<A7eivV(G61/D61)*100v(D20<AG$ C(G61/E61)*100 <DFrD61-E61 <AFwXY(J61/E61)*100=!" -----------=!" -----------A$2.4=!" -----------D20)*100 = " ---------->"TOTALS,(B53>FtPuSUM(D46:D62)23.5>FscSUM(E46:E62)>ErgSUM(G46:G62)>AW"E$0(G63/D63)*100(D50>AYfaid(G63/E63)*100 >DvwSUM(J46:J62) >ABpCrY(J63/E63)*100SuperCalc ver. 1.12 AN  P(;7* " AN"ALYSIS OF " TAX SHEL "TER "ER "*****************************************"********************"*******************"******************"*******************"********************"ESTIMATED BASIS FOR DEPRECIATION****" land (non-depreciable)T"e)......%(noP20...E .20*J6eprec"PRICE.20* Q100000.20*" Building....................***".........%ngP80...E.80*J6....."DOWN P10000" other........................**".........%..P0....P0...."CLOSING.%.. P2000I"1ST LOAN%.. P80000 " TOTAL...................** "........%TOT BC7+C8...... " FD6+D7...... " INT RATE+D P10INT "INT " ----------D " TERM----D P30TER "TER " MO PMT--D Q666.66MT--D "ESTIMATED DEPRECIATION...... "2ND LOAN DEP P5000L " first yearIATIO " INT RATEye P10INT" TERMATEye P5 TER" Building estimated......"life(yrs)ng P15fe(" MO PMTng P41.66" straight line......"method..trai"........traiDS3333333D7/C16 line"OTHER33D7/C P5000R" other (est. life)......"in (yrs)r (eP0n (y" INT RATE(e P10INT" straight line......"method strai"........traiP0...." TERM.trai P5 TER" MO PMTtrai P41.66" TOTAL....................**"........OTAL"..........AL"..........ALDS3333333D17+D19...."MO INCOME17+ P800IN" ----------+"PROP TAXES+ D.012*J6...."INSURANCE012 C#.0023*J6..."ESTIMATED INTEREST.."MAINTENANCET CH.05*(12*J21)......." first year*J21)"UTILITIES ye"VACANCYS ye By.01*(J12*12)......." first mortgage....DJ9*(.01*J10)ge...."MISC.J9*(" second mtgCPJ13*(.01*J14)e...."APPRECIAT. RATE1*J14 P8PPRE" other.......e....CP(J17)*(.01*J18)...."TAX BRACKET7 P50X B" TOTAL............."........ TOT"...................."............DB27+B28+B29......." ----------+!"TOTAL DEPRECIATION9""AND INTEREST-first yr......""..........T-""..........T-""...........-"E3333333E21+E31t yr#" ----------+%"EST NET OPERATING INCOME...%"....RENT=ERA%CJ21%"...............G INC%Dv(J21*12)-SUM(J22:J27)..**'"FIRST YEAR REAL ESTATE22:J27("TAXABLE INCOME/LOSST("............./LOSST("...............OSST("..............OSST(g#3%3330E38-E35SST)" -----------+"ANALYSIS---+" OF RETURN-+"N ON INVESTM+"ENT ,"___________________________________*,"____________________,"____________,"____."INVESTMENT (including clo___."sing cost (i."s).........i.EJ7+J8luding0" CASH FLOW...........___0".........FLO0"..........LO0#yE38-((J12*12)+J22+J23+J24+J25+J26+J27)0&S3333D49/D472*122" EQUITY BUILDUP......+J22".......... B2".......... B2$((J12+J16+J20)*12)-E3124+J22 D51/D476+J24" TAX SAVINGS.........)-E4BPJ294"%BRACKETJ294D3afbfffeE41*(-.01*J29).)-E4@(8UUUTD53/D471*J26" APPRECIATION.........-E6AJ28TION....6"%YR.......86D(J28*.01)*J6....-E6@fffffffgD55/D47)*J68"TOTAL RETURN ON INVESTMENT-E8DPxfffeSUM(D49:D55)MENT-E8@tXSUM(F49:F55)MENT-E9"__________________________-E9"_________________________-E9"____________________9"____________9"____9"---------__:"------------------------------24+J2:"--------------------:"--------------------:"------------:"-----------;" copyright (c) 1983 by Anthony Hoffman8-((J12*12)+J22+J23+J24+J25+J26+J27)0&S3333D49/D472*122" EQUITY BUILDUP......+J22".......... B2"... TAXSHLTR.CA̠ i Supercal progra whic compute th ta benefit fro particula piec o rea estate Th sam progra als automaticall compute th rate o retur fro cas flow equit buildup an appreciation an give tota retur o investe cash. T us th program boo Supercal i th "A drive Plac thi dis i th "B drive an loa th fil "B:TAXSHLTR.CAL ont th worksheet Scrol righ t wher th "J colum usuall is hav delete Th colum letter fo neate printout, an inpu th dat aske fo int cell J throug approx J30 (Th propert taxes insurance maintenance an vacanc facto wil b adde automaticall b th program s don' inpu dat o thos cells. Pa particula attentio t th "appreciatio rate an "ta bracket lines Us whol number fo al percentage (i.e. 1 fo 12% 3 fo 30% etc. That' al ther i t it No scrol lef t th edge an you'l se tha th progra ha automaticall calculate an fille ou th for there fro ro throug ro 42 Th informatio wil prin ont on standar 8.5X1 sheet Whe printing fo rang ente "A1:F42" Goo luck an i yo nee an hel o consultation cal o write Anthon Hoffman, P.O.Box 221, Santa Clara, Ca. 95052 (408)247-3330 Copyright (c) 1983 by Anthony Hoffman, Realtor Th colum letter fo neate printout, an inpu th dat aske fo int cell J throug approx J30 (Th propert taxes insurance maintenance an vacanc facto wil b adde automaticall b th program s don' inpu dat o thos cells. Pa particula attentio t th "appreciatio rate an "ta bracket lines Us whol number fo al percentage (i.e. 1 fo 12% 3 fo 30% etc. That' al ther i t it No scrol lef t th edge an you'l se tha th p 2/28/83 Revised 2/29/84 DOCUMENTATION SUPERCALC TAX CALCULATION TEMPLATES TAXTMPL1.CAL THROUGH TAXTMPL7.CAL, REV 83.1 NOTE: This revision made by Richard J. Switz for the 1983 tax | year, and is complete, EXCEPT FOR SCHEDULE G (Income Averaging) | ON TAXTMPL2.CAL, which has not been changed from the 1982 tax year| values. Vertical bars have been placed in the right margin of the | changed lines of this doc. file. | (This doc. file modified by Jim Switz) | INTRODUCTION: "TAXTMPLx.CAL" stands for "Tax Template No. X" and refers to a series of SuperCalc(tm) templates that imitate various Internal Revenue Service (IRS) tax forms. The current version is Rev 83.1 | and is intended to cover the 1983 tax year, the tax year with a | nominal filing date of April 15, 1984. | This material is being placed in the public domain and may be copied without restriction, but no sale or resale is authorized (see however the section below called "On a Personal Note"). OBJECTIVES: These templates are intended to: 1) Simplify the preparation of individual IRS tax forms by performing all needed calculations, given adequate input values, and outputting a reasonably complete simulation of the forms to a computer terminal and/or printer. Please note that these templates are not intended to be direct substitutes for IRS-originated forms but rather will perform all requisite calculations and assist in the preparation of the IRS forms. 2) Assist individuals to avoid overpaying 1983 Federal | Income Tax by making rapid calculation of tax sensitivity to various permutations of filing status, standard versus itemized deductions, etc easy to accomplish. 3) Provide a basis for longer-term tax planning efforts by allowing an easy and rapid investigation of the future tax consequences of different investments, contributions, gifts, payment groupings etc. Note however that all calculations in these templates reflect 1983 tax year | regulations - no attempt has been made to anticipate future tax regulations. FILE ORGANIZATION: The TAXTMPL "system" consists of 8 different files, with the following names and contents; FILENAME.TYP CONTENTS ============ =============================== TAXTMPL .DOC This Documentation TAXTMPL1.CAL Form 1040, page 1 + Schedule A TAXTMPL2.CAL Form 1040, page 2 + Schedule G + Tax Rate Schedules TAXTMPL3.CAL Schedule B TAXTMPL4.CAL Schedule C TAXTMPL5.CAL Schedule D TAXTMPL6.CAL Schedule E TAXTMPL7.CAL Form 4562 You should note that with the exception of Form 1040 and Schedules A & G, all IRS forms in this system have their own separate template and filename. Some thought was given to combining the various forms onto one master template and file, with values being passed from one form to another, but memory limits of 27 K prevented this approach. Consideration was also given to the possibility of passing values from one template to another using a "carry data forward" approach that uses partial loading of data from previously-run templates ( see an article titled "Supercalc Tips" on page 5 of the "SuperNews by Sorcim" newsletter, Issue No. 3, Fourth Quarter 1982 for details of this technique). A review of the relationship between the various Forms and Schedules indicated that, with the exception of Form 1040 relative to Schedules A & G, relatively little data was carried from one form to another - usually just one "bottom- line" value from each form. Thus, the most expedient approach is to provide one template per form and have each user run only those templates that are needed then manually provide the transfer of data from one form to another. The interchange of data between page 2 of Form 1040, Schedule G, and the tax calculation routine is, however, fairly intimate. Similarly, Schedule A uses values in several places that can be obtained from Form 1040, page 1. Memory limitations prevent the inclusion of all three forms and the tax rate schedules onto one template but they readily fit onto two separate templates. Thus, anybody with a relatively straightforward tax return (i.e. limited to Form 1040 with or without itemized deductions and/or income averaging) need only run TAXTMPL1.CAL and TAXTMPL2.CAL to complete a set of tax calculations. Those users with more complex tax situations need only run those additional templates that are pertinent and input the calculated values from them into TAXTMPL1.CAL & TAXTMPL2.CAL as appropriate. INITIAL DEVELOPMENT: All templates were initially developed using Sorcim's SuperCalc, Version 1.05 as distributed by the Osborne Computer Corp., and using CP/M 2.2. No attempt has been made as of this writing to verify satisfactory operation of all of these templates with any other version of SuperCalc nor, for that matter, with any other electronic spreadsheet. Verification of satisfactory operation of some of the templates with SuperCalc Version 1.12 has been done. Indeed, Sorcim indicates that all Ver. 1.05 templates should be upward compatible with Ver. 1.12. But watch out for the dread case of "downward incompatibility" - ANY FILE THAT IS SAVED USING SUPERCALC VER. 1.12 WILL FOREVERAFTER BE UNLOADABLE BY USERS WITH SUPERCALC VER. 1.05, EVEN IF THE TEMPLATE ITSELF IS FULLY COMPATIBLE WITH VER. 1.05 CAPABILITIES. SORCIM, IN THEIR INFINITE WISDOM, HAS COMPLETELY CHANGED THE WAY FILES ARE STORED WHEN THEY WENT FROM VER. 1.05 TO 1.12 - AND THEY DON'T PROVIDE ANY MEANS TO TRANSLATE BACK TO VER. 1.05 FROM FILES SAVED USING VER. 1.12. WHAT'S EVEN WORSE, THEY DIDN'T WARN ANYBODY ABOUT THIS, AT LEAST THEY DIDN'T WARN ME. I HAD TO SPEND 5+ HOURS RE-ENTERING A TEMPLATE THAT I HAD MODIFIED AND SAVED USING VER. 1.12. BOY, WAS I CHAPPED. SORCIM SAID, "GEE, THATS TOO BAD - YOUR STARTING AT THE BOTTOM OF THE LEARNING CURVE." SO BE WARNED, AND BENE- FIT FROM MY UNHAPPY EXPERIENCE! THE SAME IS TRUE OF FILES SAVED BY SUPERCALC2; THESE | FILES WILL NOT BE COMPATIBLE WITH SUPERCALC! | The computer used was an Osborne I with the double density and 80 column plus modifications. The initial use of double density (DD) is not expected to have any adverse impact on outside use of this package, other than possibly requiring more than one diskette to store the entire package. Development work did use the 80 column capability. All individual forms except for Form 4562 can fit within this screen width. Given a little judicious fiddling with the various column widths, most templates could probably be made to fit within a 52 column-wide screen. Screen width, per se, should not have an adverse impact on the templates' accuracy of calculation, but it is nice to have the template fit within the screen borders. The printer used was an Epson MX-80 initialized into the 132 column wide (compressed) print mode. The forms have all been setup to fit within this carriage width. Two of the templates, those for Schedules B and D will fit within a carriage width of 80 characters per line without any modification. The template for Form 4562 and part of Schedule E is much too wide to be readily modified for the 80 character per line carriage width. The remaining forms all can be fairly readily modified to fit a narrower carriage because they consist of two pages of form squeezed to fit into one page of printout. The required modification consists of inserting several blank columns between the two separate forms or pages on the template with column widths that require two pages for full printout. Check the template for Schedule D to see how this was done. Some "fiddling" with column widths on Schedule D and pages 1 and 2 of Schedule E may also be required to fit them within an 80 column- wide printer carriage. USEAGE NOTES AND SUGGESTIONS: FILENAMES: The filenames used here were selected so that the files involved would be grouped together in any User Group library or RCPM Directory (Remote CP/M "bulletin board" system), a sort of "systems" approach where related files have related filenames. Users should feel free to rename any files with a filename more descriptive of the file's contents, such as; renaming TAXTMPL5.CAL as SCHED-D.CAL. If you don't wish to rename the files, you can still get a quick reminder of each file's content by getting a listing of "SuperCalc" format files while in SuperCalc. The sequence of commands, /L(oad),C,drive no.,S(upercalc), will list all ".CAL " files on the drive number selected along with the contents of cell A1 for each file. All TAXTMPLx.CAL files contain data in Cell A1 on the content of each file, including version number, IRS Schedule(s), and tax year. If you decide to rename any or all of the files, PLEASE use the original filenames when passing on copies to other users, user group libraries, and RCPM's. In this way, the templates will remain in a group along with this documentation. SIMPLIFIED DIRECTIONS (see also "Direction Annotations" for more detail): 1) Load SuperCalc 2) Load desired template, e.g. /L(oad),TAXTMPL1,A(ll) *3) Fill in the blanks (areas with question marks - "?") with appropriate values *4) When satisfied, manually force a calculation 3 to 4 times using the exclamation mark - "!". *5) Examine results - if satisfied, record pertinent results for use later, save the (renamed) file to disk, and/or output the finished template to the printer. 6) Repeat from Step 2 as required with other templates after /Z(apping) the previous file to clear SuperCalc's memory. Direction Annotations: *3) Areas to be filled in by the user are indicated with question marks and are unprotected (see "Protection" for details). Generally, user inputs are also indicated by labels with capital letters while values to be calculated by the template are labelled with lower-case letters and have ".00" in the results column. When entering text, such as names, be sure to preface the entry with a quotation mark. Social security numbers should be entered as numbers (i.e. without the quotation mark) but without inserting hyphens between number groups. If you don't have a numerical value for each blank space (each "?"), and you won't, just skip the entry. SuperCalc will interpret all remaining ?'s as null values. *4) All templates are initially in the manual calculation mode, which means that an "!" is required to force a calculation of all formulas after you are satisfied with the input. This is done for several reasons, one of which is to minimize automatic recalculation and thereby speedup input. The main reason however is because of "forward references" that are built-in to several templates. Forward references occur when formulas utilize values for calculation that are derived from calculations made later in the calculation sequence. The net result from this phenomenon is that several recalculations may sometimes be required before all calculations settle down to their final values. Final form can be verified by forcing a recalculation (!) while watching some "bottom-line" value. If, after several recalculations, the value has not changed, you should be safe in assuming that all values have stabilized. *5) A template with filled-in values should be renamed when saving to disk to prevent it being written over the blank template originally on the disk (note that a message indicating a duplicate file name will be generated, but better safe than sorry). PROTECTION: With minor exception, discussed below, all template areas not requiring user input are protected. This means that the only place where user-derived values can be entered are those "blanks" marked with a "?". All other template values are protected from accidental modification by the user and are either template text, template boundaries, formulas, or constants. Users can remove the protection selectively or from the entire template using the /U(nprotect) function. If you do so, be sure to not accidently modify any formula or constant. The exception noted above will be found on Form 4562, page 2, line 8 and marked with a ">" to the left of the data block. This value will normally be calculated by the template, but users should enter a ZERO if they are dealing with a partnership. In so doing, the user will be overwriting the formula with a 0 value. It is further suggested that all template disk files be set to "Read Only" status using CP/M's STAT command (e.g. STAT *.CAL $R/O). If this is done, you will not have to worry about accidently recording over the blank template file with a filled- in template while trying to save it to disk. Note that a blank template is a desireable starting point as there are no "stray" entries left over to creep into a calculation. RESULTS: Final values from any template that may need to be transferred to another template are marked with an "*" in the border immediately to the right of the value. OTHER: These templates are not intended to be printed out and sent to the IRS as is, but rather should be used to guide the user in completing "Official" forms. Most templates generally follow the IRS form but occasionally some questionnaire sections have not been included, a few data blocks have been relocated where nothing of value would be lost, and some labels have been abbreviated. The user is encouraged to have blank IRS forms on hand to clarify these abbreviations should they prove difficult to interpret and to provide further guidance as to the intent of the form. TAXTMPL1.CAL and TAXTMPL2.CAL both have scratch pad areas in the lower right hand corner of the first pages. If, after running a calculation, you see a "999999" in the scratchpad area, you have made an error. In the case of TAXTMPL1, you would have tried to claim a filing status other than the allowed values of 1,2,3,4, or 5. The error indication in TAXTMPL2 means that a tax table calculation has been requested but the taxable income exceeds the allowed upper limit of $50,000. TAXTMPL5, Schedule D, has an unusual feature - a zero width (and therefore invisible) column. Column N is used to generate values for lines 4 and 11, columns J & L. It is simply a mathematical tool and would serve no purpose on a printout, so the column width was set to 0 and the values become invisible. DISCLAIMER: The author of this package of material is not an accountant, certified public or any other kind. Nor is he a professional programmer. Further, since distribution of this material will be through RCPM's, User Groups, etc., and therefore out of the author's control (and, consequently, subject to modification by evil intermediaries), no guarantees as to the suitability, accuracy, or general all-round wholesomeness of this package of material can be given. USE IT AT YOUR OWN RISK!!! Rest assured, however, that the author will be using this package to do his 1982 income taxes, as well as tax planning for the next 5+ years. ON A PERSONAL NOTE: I've spent the best part of the month of February working on this package and I hope that all who use it are able to benefit from the application. Occasionally, after some all-night session, my mind would tend to wander off and I would begin to think about charging a fee for this wonderful piece of work. Daylight (what there is of it in Alaska this time of year) would bring the cold realization that I am gainfully employed for 40+ hours per week and did not have the time, resources, or inclination to set up and run a software distribution company - nor did I have time to dicker with some other firm to handle same. After all, April 15 is less than two months away. Yet my desire for monetary recompense was undiminished. What to do? I thought about disseminating these goods "to the winds" via the various RCPM's I'm familiar with, accompanied by a crass plea for a check from any user that found this material to be to his (or her) liking. On the other hand, I garner a fair amount of free goodies from the RCPM's and User Groups that I hang around - why not return the favor? Further, I could not prevent the "forces of evil" from modifying the templates or even, horrors, this documentation, then passing same onto another innocent RCPM. Nor did I wish to assume any kind of legal responsibilty for the use of this software. Yet my desire for monetary recompense remained undiminished. Now what to do? Enter "BYTE" magazine, Volume 7, No. 11 (the November 1982 issue), with a column by the redoubtable and illustrious Jerry Pournelle starting on page 394. When I got to page 408, and was reading about How Software Piracy Will Bring Profits To Its Victims, the light bulb lit up. Jerry's main point on this topic, and I think a very salient one, is that profits in the future will come from selling documentation about software (and software updates) rather than from the sale of the software itself. Indeed, Jerry suggests that software publishers will be secretly pleased when their goods are purloined and the purloiner winds up having to buy documentation to figure out how the stuff works. Seems like a good idea to me, so....... Here's my deal - This software package comes complete with all documentation required to run it. Use it as much as you like with a clear conscience, pass it on to friends and relatives, User Groups, and especially other RCPM's and bulletin boards. If you like it, fine. If you don't, I don't want to hear about it. If you think the effort is deserving of a reward, any contributions will be greatly welcomed. If you don't think any reward is justified, well thats OK too. But beware the forces of evil. If you are concerned that the templates in your possession may have been tampered with sometime during the convoluted transmission between yr obd't servant and your fine self, or if you simply wish to assure yourself that Murphy's Law does not always prevail, I have what you need. I will be more than pleased to send a genuine, honest to the original, Xerox copy of my TAXTMPLx.CAL template contents listing to you in exchange for the paltry sum of $8.25 (check or money order) and a stamped, self-addressed envelope. We're talking about 12 plus pages of stuff, so you probably ought to put two stamps on the envelope. In this way, I get compensated, you can feel more comfortable with the software (and can bask in the inner glow that develops when one aids another human being, i.e. me), and together we foil those nasty forces of evil and confusion. Send your checks, marked with the phrase "Taxtemplates", to the following; John E. Olson II SRA 2393-K Anchorage, AK 99507 P.S. To those forces of evil and confusion out there, I hope that if you change the name and/or address above that you wind as a camel dentist for your next 25 reincarnations. P.P.S. Seriously folks, I do hope that this material is of some good to you and that we, as a group, are able to keep the IRS from dipping too deeply into our pockets while keeping things honest. Judge Learned Hand is reported to have said that nobody has the obligation to arrange their affairs to pay more income tax than necessary. I'm with the judge - so here's to affairs that are better arranged!pe. In this way, I get compensated, you can feel more comfortable with the software (and can bask in the inner glow that develops when one aids another human being, i.e. me), and together we foil those nasty forces of evil and confusion. Send your checks, marked with the phrase "Taxtemplates", to the following; John E. Olson II SRA 2393-K Anchorage, AK 99507 P.S. To those forces of evil and confusion out there, I hope that if you change the name and/or address above that you winSuperCalc ver. 1.00 TAXTMPL1...REV 84.RJS 1983 IRS FORM 1040-PAGE 1 & SCHEDULE AL A, h4         '"TAXTMPL1...REV 84.RJS 1983 IRS FORM 1040-PAGE 1 & SCHEDULE A!"SCHEDULE ARE"1983"|83'-83"| |""ITEMIZED DEDUCTIONSS"|EMI"NAMES:D DEDU" ?D DEDU"| |  '-| "|| "HOME ADDRESS:TIONSS" ?DRESS:"| | #"1) MEDICINE AND DRUGS:983 IR" |E" ?CINE A"| "CITY/STATE/ZIP:DRUGS" ?ATE/ZI"| | $"2) 1% of Form 1040, Line 33:S FORM 1" |%.01*D57...R"|'="||"| |%"3) Line 1 - Line 2, 0 if Line 2 is larger:GE" |iIF(H4>=H5,H4-H5,0)J"|"PAGE 1IF("|| SOC SEC NO - is la" ? "| | $"4) OTHER MEDICAL AND DENTAL EXPENSES" |T!"////////////"|/// '=///"| |/%"4a) DOCTOR, DENTIST, NURSE, HOSPITAL, etc:GE" |D" ?TOR, D"| ""FILING STATUS:TIST, " |N" ?STATUS"| | ""4b) TRANSPORTATION: " |T" ?NSPORT"| "" 1) singleON:  " |  "////////////leON:  "| |/ !"4c) OTHER:/ " |O " ?ER:/ "| %" 2) married filing joint return etc:GE " |  "\\\\\\\\\\\\ied fili "| |\ #"5) add Lines 3 through 4c:nt " |d SUM(H7:H10)+H6,0)J "| %" 3) married filing separate returnc:GE " |  "////////////ied fili "| |/ #"6) 5% of Form 1040, Ln. 33:r " |% .05*D5710)+ "| %" 4) head of household (see p 6)rnc:GE " |  "\\\\\\\\\\\\ of hous "| |\ %"7) Line 5 - Line 6, 0 if Line 6 is larger:GE " |i IF(H11>H12,H11-H12,0)1983 I "| $" 5) qualifying widow(er)6 is la " |  "////////////ifying w "| |/ " |/ "||/ '-|/"--|/'-|/"| |/" |/"||/#"6) NUMBER OF EXEMPTIONS:(er)" |U" ?ER OF "| |  '-| "--| '-| "|| %" yourself + 65 or older + blindrger:GE" | "////////////f + 65 o"| |/$"8) STATE AND LOCAL INCOME TAXES:ind" |T" ?E AND "| $" spouse + 65 or older + blindd" | "\\\\\\\\\\\\+ 65 or "| |\#"9) REAL ESTATE TAXES:lder + " |E" ? ESTAT"| #" dependent childrenr + " | "////////////nt child"| |/%"10a) GENERAL SALES TAX (see sales tax tble):" | " ?NERAL "| #" other dependents(see s" | "\\\\\\\\\\\\ependent"| |\%"10b) GENERAL SALES TAX ON MOTOR VEHICLE:e):" | " ?NERAL "|  '- "--| '-| "| | %"11) OTHER TAXES (include personal property):" |O" ?ER TAX"| !"INCOMEER TAX"| |M""12) total taxes:incl" |tSUM(H17:H21)1-H12,0"| '."| | '-|"--|'-|"||$"7) WAGES, SALARIES, TIPS, ETC.:l pro" |A" ?S, SAL"| | %"13a) HOME MORTGAGE INTEREST TO BANKS:erty):" | " ?ME MOR"| %"8) INTEREST INCOME (Sched B if over $400)::" |N" ?REST I"| | %"13b) HOME MORTGAGE INTEREST TO INDIVIDUALS:" | " ?ME MOR"| %"9a) DIVIDENDS (Sched B if over $400):UALS:" |D" ?IDENDS"| | %"14) CREDIT CARDS/CHARGE ACCOUNT INTEREST::" |C" ?DIT CA"| &" b) EXCLUSION ($100 max, $200 max if joint): 1 & SCH" |E" ?LUSION"| | ""15) OTHER INTEREST:m" |O" ?ER INT"| #" c) subtract 9b from 9a:$200" |sAIF(D26>D27,D26-D27,0)1983 I"| |""16) total interest:-" |tSUM(H24:H27)6-D27,0"|&"10) REFUND STATE/LOCAL INCOME TAX (see p 10):/P& SCH" |R" ?UND ST"| |  '-| "--| '-| "|| #"11) ALIMONY RECEIVED: INCOME" |A" ?MONY R"| | %"17a) CASH CONTRIBS UNDER $3000, ANY 1 ORGAN:" | " ?SH CON"| %"12) BUSINESS INCOME OR (LOSS) (Sched C):AN:" |B" ?INESS "| | &"17b) CASH CONTRIBS OVER $3000 TO ANY 1 ORGAN:P& SCH" | " ?SH CON"| %"13) CAPITAL GAIN OR (LOSS) (Sched D): ORGAN:" |C" ?ITAL G"| | %"18) NON-CASH CONTRIBUTIONS (see p 19):ORGAN:" |N" ?-CASH "| &"14) 40% CAP GAIN NOT RPTD LINE 13 (see p 10):& SCH " |4 " ? CAP G "| |  $"19) CARRYOVER FROM PRIOR YEARS:'D(se " |C " ?RYOVER "| !%"15) SUPPLEMENTAL GAINS (LOSSES) (Frm 4797):!" |S!" ?PLEMEN!"| | !$"20) total deductable contributions: !" |t!SUM(H30:H33)6-D27,0!"|"&"16) PENSIONS, IRAs, ANNUITIES NOT ON LINE 17:& SCH"" |P"" ?SIONS,""| | " '-| ""--| "'-| ""|| #%"17a) OTHER PENSIONS & ANNUITIES, TOTALS:D:#" | #" ?HER PE#"| | #%"21) CASUALTY OR THEFT LOSSES (Frm 4684):D:#" |C#" ?UALTY #"| $%" b) TAXABLE AMOUNT FROM WORKSHEET, p 10::$" | $" ?XABLE $"| | $$"22) UNION & PROFESSIONAL DUES:EET, p$" |U$" ?ON & P$"| %%"18) RENTS, ROYALTY, PARTNERSHIPS (Sched E):%" |R%" ?TS, RO%"| | %$"23) TAX RETURN PREPARATION FEE: (Sch%" |T%" ? RETUR%"| &%"19) FARM INCOME OR (LOSS) (Sched F):ed E):&" |F&" ?M INCO&"| | &$"24) OTHER MISCELLANEOUS DEDUCTIONS:&" |O&" ?ER MIS&"| '%"20a) UNEMPLOYMENT INS COMPENSATION, TOTAL:'" | '" ?EMPLOY'"| | '%"25) total casualty, theft & misc deductions:'" |t'SUM(H36:H39)6-D27,0'"|(%" b) TAXABLE AMOUNT FROM WORKSHEET, p 11:s:(" | (" ?XABLE ("| | ( '-| ("--| ('-| ("|| )#"21) OTHER INCOME (see p 11):)" |O)" ?ER INC)"| | )#"26) total deductions:p 11):)" |t)H13+H22+H28+H34+H40)"|*""22) total income:"+*" |t*ASUM(D24:D42)-D26-D27-D36-D40S FORM *"| |*$"27) filing status adjustment:(ET, p*" |f*FIF(OR(H52=1,H52=4),2300,IF(OR(H52=2,H52=5),3400,IF(H52=3,1700,999999)))----*"|+ '-+"--|+A'-|+"| |+#"28) allowable deductions:230+" |a+ƙH42-H432=1,+"*,#"ADJUSTMENTS TO INCOMEns:230,A DJUS,"| |S, '-|S,"--|S,'-|S,"||S- '.|S-"| |S-"||S.%"23) MOVING EXPENSE (Frm 3903 or 3903F):2,4=." |M." ?ING EX."| | ."|| /%"24) EMPLOYEE BUSINESS EXPENSE (Frm 2106):4=/" |E/" ?LOYEE /"| | / '=| /"|| 0%"25) IRA PAYMENTS (note code fr p12 needed):0" |I0" ? PAYME0"| | 0#"SCRATCH PAD AREA BELOW code 0"|RAT1$"26) PAYMENTS TO A KEOGH PLAN: p12 n1" |P1" ?MENTS 1"| | 1 '=| 1"|| 2%"27) PENALTY FOR EARLY SAVINGS WITHDRAWAL:):2" |P2" ?ALTY F2"| | 2%"check area, ignore unless N = 999999AL:):2" |k2"||k3""28) ALIMONY PAID: un3" |A3" ?MONY P3"| | 3""CHK FILE STATUS: un3" |F3FIF(AND(D9>=1,D9<=5),INT(D9),999999)3"|4&"29) DEDUCT MARRIED/WORKING COUPLE (Sched W):5),3400,4" |D4" ?UCT MA4"| | 4" | 4"|| 5%"30) DISABILITY INCOME EXCLUSION (Frm 2440):5" |D5" ?ABILIT5"| | 5" | 5"|| 6#"31) total adjustments:XCLUSI6" |t6ASUM(D47:D54)D9<=5),6"| |6" |6"||7 '-|7"--|7A'-|7"| |7" |7"||8#"32) ADJUSTED GROSS INCOME:SI8" |A8AD43-D55D54)8"* |8" |8"||9 '-|9"--|9'-|9"| |9" |9"||:" |:"||;" |;"||NTS 1"| | 1 '=| 1"|| 2%"27) PENALTY FOR EARLY SAVINGS WITHDRAWAL:):2" |P2" ?ALTY F2"| | 2%"check area, ignore unless N = 999999AL:):2" |k2"||k3""28) ALIMONY PAID: un3" |A3" ?MONY P3"| | 3""CHK FILE STATUS: un3" |F3FIF(AND(D9>=1,D9<=5),INT(D9),999999)3"|4&"29) DEDUCT MARRIED/WORKING SuperCalc ver. 1.00 TAXTMPL2...REV 84.RJS...1983 IRS FORM 1040-PAGE 2,L - h4         "TAXTMPL2...REV 84.RJS...1983 IRS FORM 1040-PAGE 2,"SCHEDULE GRE"|HED " |D "SCHEDULE X (FILING STATUS 1)IRS FORM"TBL RD OFF(FEVbPIF((H49-100*(INT(H49/100)))<=50,(100*INT(H49/100))+25,(100*INT(H49/100))+75)=======" SCHEDULE G, AND TAX TABLES100*I"| | "INCOME AVERAGINGDULE"|COM " |M P0 |M P0 |M P0 |MP0 |MP0 |MP0 |M"NAMES:AVERAG" ?BR SWI"| |N'-|N"||N "T |N P2300N P2300N P2300NP.11NP2300NP000N"HOME ADDRESS:ZDULE" ?MAPLE "| | "1) 1978 FORM 1040, Ln 34 OR 1040A, Ln 10:0*I"| 19" ?8 FORM "| ? " |? P3400? P3400? P3400?P.13?P3400?P121?"TAX TABLERM Ex`INT((((S1-LOOKUP(S1,L2:L15))*LOOKUP(S1,N2:N15))+LOOKUP(S1,P2:P15))+.5))+75)"CITY/STATE/ZIP:-LO" ?NDO, C"| |E"2) 1978 TOTAL EXEMPTIONS * $750:))*"| 19" ?8 TOTAL"| ? "A |? P4400? P4400? P4400?P.15?P4400?P251?"SCH XYZTOTALEycE((D14-LOOKUP(D14,L2:L15))*LOOKUP(D14,N2:N15))+LOOKUP(D14,P2:P15))+.'=cE"| |"3) difference:OOKUP("| diIF(H4>H5,H4-H5,0)2:"| " | P8500 P8500 P8500P.17P8500P866"G-L26IF(DWWB ((H36-LOOKUP(H36,L2:L15))*LOOKUP(H36,N2:N15))+LOOKUP(H36,P2:P15))+."PAGE 2(($"FILING STATUS FROM PAGE 1:" ?NDO, C"| |N'.|N"|..N'..N"|.N "X |N P10800 P10800 P10800P.190P10800P1257"G-L27 STATUSDWWB ((H34-LOOKUP(H34,L2:L15))*LOOKUP(H34,N2:N15))+LOOKUP(H34,P2:P15))+.'=WB "| | "4) 1979 FORM 1040, Ln 34 OR 1040A, Ln 11::"| 19" ?9 FORM "| ? " |? P12900 P12900 P12900P.210P12900P1656"G-L289 FORM ((H33-LOOKUP(H33,L2:L15))*LOOKUP(H33,N2:N15))+LOOKUP(H33,P2:P15))+."33) ADJUSTED GROSS INCOME (p. 1, line 32)::"|) A" ?STED "| |."5) 1979 TOTAL EXEMPTIONS * $1000:ine"| 19" ?9 TOTAL"| ? " |? P15000 P15000 P15000P.240P15000P2097"G-L319 TOTALEycE((H22-LOOKUP(H22,L2:L15))*LOOKUP(H22,N2:N15))+LOOKUP(H22,P2:P15))+. "34a) ITEMIZED DEDUCTIONS (Sched A, Line 28): "|a)  " ?MIZED "| |. "6) difference:EDUCTI "| di IF(H8>H9,H8-H9,0)2: "| " | P18200 P18200 P18200 P.280 P18200 P2865 "G-L32IF( EycE((H24-LOOKUP(H24,L2:L15))*LOOKUP(H24,N2:N15))+LOOKUP(H24,P2:P15))+. " b) NON-ITEMIZE CHARITY (Worksheet, p.14):: "|b)  " ?MIZED "| |  '.|  "|..  '..  "|. "R | P23500 P23500 P23500 P.320 P23500 P4349 "35) line 33 - either line 34a or 34b:.14):: "|) l D9-D10-D11P "| | "7) 1980 FORM 1040, Ln 34 OR 1040A, Ln 11::: "| 19 " ?0 FORM  "| ? " |? P28800 P28800 P28800 P.360 P28800 P6045 "36) # EXEMPTIONS * $1000 (Pg1, Line 6e)::: "|) # " ? - "| |# "8) 1980 TOTAL EXEMPTIONS * $1000:e 6 "| 19 " ?0 TOTAL "| ? "A |? P34100 P34100 P34100 P.400 P34100 P7953 "37) taxable income:I "|) t D12-D1311P "| | "9) difference:ome:I "| di IF(H12>H13,H12-H13,0)5))*LO "| " | P41500 P41500 P41500 P.450 P41500 P10913" TAX CALC SOURCE NO. ,0)$1"|TAX" ? -"| |X'.|X"|..X'..X"|.X "T |X P55300 P55300 P55300P.500P55300P17123" (SELECT ONE)E NO."|//S"//////////ON"| |/"10) 1981 FORM 1040, Ln 34 OR 1040A, Ln 12::"|) 1" ?81 FORM"| ? " |?" 1) TAX TABLE40, L"|//)"//////////AB"| |/'.|/"|../'../"|./ "E |/ "SCHEDULE Z (FILING STATUS 4)040A, L" 2) RATE SCHED X,Y,ZTUS 4)"|//)"//////////SC"| |/"11) 1978-81 INCOME EARNED OUTSIDE USA:12::"|) 1" ?78-81 I"| ? " |? P0 |? P0 |? P0 |?P0 |?P0 |?P0 |?" 3) SCHEDULE GE EA"|//)"//////////UL"| |/"12) totalsUL"|) tH6+H10+H14+H16+H180"| " | P2300 P2300 P2300P.11P2300P000"38) tax:+"|) tN/AIF(D15=3,H45,LOOKUP(D7*(D15^3)+.01,G51:G60))+LOOKUP"| |'.|"|..'.."|. " | P4400 P4400 P4400P.13P4400P231"TAX TABLEF(EPPINT((((S1-LOOKUP(S1,L18:L31))*LOOKUP(S1,N18:N31))+LOOKUP(S1,P18:P31))+.5)5)"39) ADDED TAX (Frm 4970, 4972, 5544, Sec 72):,:)"|) A" ?IF("| |A"13) 30% of line 12:9"|) 3.3*H19S1-LO"| "S | P6500 P6500 P6500P.15P6500P504"SCH XYZ.3*((D14-LOOKUP(D14,L18:L31))*LOOKUP(D14,N18:N31))+LOOKUP(D14,P18:P31)'.EC`"|..`'..`"| |`"14) 1982 taxable income (Form 1040, ln 37)::"|) 1D14"|f " | P8700 P8700 P8700P.18P8700P834"G-L26aD(@((H36-LOOKUP(H36,L18:L31))*LOOKUP(H36,N18:N31))+LOOKUP(H36,P18:P31)"40) total tax:OOKUP("|) tN/AD21+D20OKUP"| |"15) SECTION 72 PENALTY, SEE INSTRUCTIONS::"|) S" ?CTION 7"| ? "C |? Q11800CTION 7 Q11800CTION 7 Q11800CTION 7P.190Q11800CTION 7P1392"G-L27CTION 7D(@((H34-LOOKUP(H34,L18:L31))*LOOKUP(H34,N18:N31))+LOOKUP(H34,P18:P31)'-(@"|--@'--@"| |@"16) difference:OKUP("|) dH22-H23OKUP"|f " | Q15000- Q15000- Q15000-P.210Q15000-P2000"G-L28-((H33-LOOKUP(H33,L18:L31))*LOOKUP(H33,N18:N31))+LOOKUP(H33,P18:P31)"41) CREDIT FOR THE ELDERLY (Sched R & RP)::"|) C" ?+"| |C"17) IF COMMON PROPERTY STATE, SEE INSTRUCTS:))+LOO"|) I" ? COMMON"| ? "H |? Q18200 COMMON Q18200 COMMON Q18200 COMMONP.250Q18200 COMMONP2672"G-L31 COMMON((H22-LOOKUP(H22,L18:L31))*LOOKUP(H22,N18:N31))+LOOKUP(H22,P18:P31)"42) FOREIGN TAX CREDIT (Frm 1116):KU"|) F" ?+"| |F"18) difference:CREDI"|) dIF(H24>H25,H24-H25,0)31))*L"|f " | Q23500IF( Q23500IF( Q23500IF(P.290Q23500IF(P3997"G-L32IF(((H24-LOOKUP(H24,L18:L31))*LOOKUP(H24,N18:N31))+LOOKUP(H24,P18:P31)"43) INVESTMENT CREDIT (Frm 3468):OKU"|) I" ?+"| |I"19) line 13 above:IT"|) lH21"| "E | Q28800a Q28800a Q28800aP.340Q28800aP5534"44) PARTIAL CREDIT FOR POLITICAL CONTRIBS::"|) P" ?+"| |P"20) averageable income:OLITI"|) aH26-H27OKUP"|f " | Q34100- Q34100- Q34100-P.370Q34100-P7336"45) CHILD/DEPENDENT CARE CREDIT (Frm 2441)::"|) C" ?+"| |C'-|C"||C "D |C Q44700HILD/DEP Q44700HILD/DEP Q44700HILD/DEPP.440Q44700HILD/DEPP11258"46) JOBS CREDIT (Frm 5884):D"|) J" ?+"| |J"INELIGIBLE FOR INCOME AVERAGING IF LINE 20 IS $3000 OR LESS"|ELI " |I Q60600GIBLE FO Q60600GIBLE FO Q60600GIBLE FOP.480Q60600GIBLE FOP18254"47) RESIDENTIAL ENERGY CREDIT (Frm 5695): IS"|) R" ?+"| |'-|"|| "U | P81800 P81800 P81800P.500P81800P28430"|30"| |"21) 20% of line 20:G"|) 2.2*H28OKUP"|8 " | "SCHEDULE Y1 (FILING STATUS 2 OR 5)56 "48) total credits:ad "|) t SUM(D25:D31)H24,L18 "| | "22) line 13::)d "|) l H21 "| "L | P0 | P0 | P0 | P0 | P0 | P0 |!'.|!"|..!'..!"| |!"23) sum of lines 21 & 22:>47!"|) s!H32+H33D31)!"|8 !" | !P3400 !P3400 !P3400!P.11!P3400!P000"#"49) balance (line 40-48)>47""|) b"N/AD23-D33D31)""| |""24) line 17:!ne 40-""|) l"H25""| ""E | "P5500 "P5500 "P5500"P.13"P5500"P231""TAX TABLE"Ef@INT((((S1-LOOKUP(S1,L33:L46))*LOOKUP(S1,N33:N46))+LOOKUP(S1,P33:P46))+.5)5)#'-@#"|--#'--#"| |#"25) sum of lines 23 & 24:,#"|) s#H34+H351-LO#"|8 #" | #P7600 #P7600 #P7600#P.15#P7600#P504#"SCH XYZ"+#((D14-LOOKUP(D14,L33:L46))*LOOKUP(D14,N33:N46))+LOOKUP(D14,P33:P46)$"50) SELF-EMPLOYMENT TAX (Sched SE):U$"|) S$" ?-$"| |S$"26) tax on line 25:T$"|) t$Dc@IF(D7=1,S6,IF(D7=4,S22,IF(D7=3,S52,S37)))N4$"|@ $"S | $Q11900IF( $Q11900IF( $Q11900IF($P.170$Q11900IF($P1149$"G-L26IF($((H36-LOOKUP(H36,L33:L46))*LOOKUP(H36,N33:N46))+LOOKUP(H36,P33:P46)%"|@%"| |%"27) tax on line 23:(%"|) t%Dc@IF(D7=1,S7,IF(D7=4,S23,IF(D7=3,S53,S38)))N4%"|@ %" | %Q16000IF( %Q16000IF( %Q16000IF(%P.190%Q16000IF(%P1846%"G-L27IF(%((H34-LOOKUP(H34,L33:L46))*LOOKUP(H34,N33:N46))+LOOKUP(H34,P33:P46)&"51) ALTERNATIVE MINIMUM TAX (Frm 6251):",!:&"|) A&" ?-&"| |A&"28) tax on line 22:M&"|) t&IF(D7=1,S8,IF(D7=4,S24,IF(D7=3,S54,S39)))N4&"| &" | &Q20200IF( &Q20200IF( &Q20200IF(&P.230&Q20200IF(&P2644&"G-L28IF(&((H33-LOOKUP(H33,L33:L46))*LOOKUP(H33,N33:N46))+LOOKUP(H33,P33:P46)'"52) INVESTMENT CREDIT RECAPT TAX (Frm 4255):'"|) I'" ?-'"| |I'"29) difference:REDIT'"|) d'Dc@H38-H39OKUP'"|@ '" | 'Q24600&- 'Q24600&- 'Q24600&-'P.260'Q24600&-'P3656'"G-L31&-'((H22-LOOKUP(H22,L33:L46))*LOOKUP(H22,N33:N46))+LOOKUP(H22,P33:P46)("53) SOC. SEC. (FICA) TAX ON TIPS (Frm 4137):("|) S(" ?-("| |S("30) 4 * difference: ("|) 4(DBS`(4*H40LOOKUP("|`( ("& | (Q299004*( (Q299004*( (Q299004*((P.300(Q299004*((P5034("G-L324*((((H24-LOOKUP(H24,L33:L46))*LOOKUP(H24,N33:N46))+LOOKUP(H24,P33:P46))"54) UNCOLLECTED FICA/RRTA ON TIPS (Frm W-2):)"|) U)" ?-)"| |U)"31) if entry on line 15, tax on line 14:2):)"|) i)IF(H23=0,0,IF(D7=1,S9,IF(D7=4,S25,IF(D7=3,S55,S40))))(H24,P)"| )" | )Q35200IF( )Q35200IF( )Q35200IF()P.350)Q35200IF()P6624*"55) TAX ON IRA (Frm 5329): *"|) T*" ?-*"| |T*"32) if entry on line 15, tax on line 16:IF(*"|) i*IF(H23=0,0,IF(D7=1,S10,IF(D7=4,S26,IF(D7=3,S56,S41))))H24,P*"| *" | *Q45800IF( *Q45800IF( *Q45800IF(*P.400*Q45800IF(*P10334+"|34+"| |+"33) difference:,0,IF+"|) d+H42-H43,0,I+"| +" | +Q60000*- +Q60000*- +Q60000*-+P.440+Q60000*-+P16014,'=14,"|==,'==,"| |,"34) total tax due:IF,"|) t,DS5H37+H41+H44,"|5 ,"C | ,Q85600%+ ,Q85600%+ ,Q85600%+,P.480,Q85600%+,P27278-"56) total tax:,IF-"|) t-N/AD35+D37+SUM(D39:D43)0,IF(D7-"| |-'=|-"|| -" | -Q109400#+ -Q109400#+ -Q109400#+-P.5400-Q109400#+-P38702.'=02."|==.'==."| |." SCRATCH PAD AREA BELOW ."| ."A | ."SCHEDULE Y2 (FILING STATUS 3)IF(=4/"57) TOTAL FEDERAL INCOME TAX WITHHELD:,IF(/"|) T/" ?L FED/"| |./"IF TAX TABLE CALC DESIRED, TESTS INCOME FOR ELIGIBILITY;),/"| TA /" |A /P0 |A /P0 |A /P0 |A/P0 |A/P0 |A/P0 |A0"58) 1983 ESTIMATED TAX PAYMENTS:INCO0"|) 10" ?L FED0"| |10"IGNORE IF TEST NOT = 999999 TEST =LIGIBILI0IF(OR(D15<>1,D14<=50000),D14,999999)(D7=3,S0"|f 0"L | 0P1700 0P1700 0P17000P.110P17000P0001"59) EARNED INCM CRED (ln 33<10000,see p 16):1"|) E1" ?L FED1"| |E1"||E 1" |E 1P2750E 1P2750E 1P2750E1P.13E1P2750E1P115.51"TAX TABLE IN1E 1@INT((((S1-LOOKUP(S1,L48:L61))*LOOKUP(S1,N48:N61))+LOOKUP(S1,P48:P61))+.5)5)2"60) AMOUNT PAID WITH FORM 4868:=))*2"|) A2" ?L FED2"| |A2"LOOKUP TABLE FOR TAX CALCS:62P1OOKU2Ex`S4(2"|` 2"C | 2P3800 2P3800 2P38002P.152P38002P2522"SCH XYZ 2((D14-LOOKUP(D14,L48:L61))*LOOKUP(D14,N48:N61))+LOOKUP(D14,P48:P61)3"61) EXCESS FICA & RRTA TAX WITHHELD:3"|) E3" ?L FED3"| |E3P2 |E3Ef@S353"|@ 3" | 3P5950 3P5950 3P59503P.173P59503P574.53"G-L26#I3((H36-LOOKUP(H36,L48:L61))*LOOKUP(H36,N48:N61))+LOOKUP(H36,P48:P61)4"62) CREDIT FOR FED TAX ON FUELS (Frm 4136)::4"|) C4" ?L FED4"| |C4P3 |C4E 1@S504"|@ 4"S | 4P8000 4P8000 4P80004P.194P80004P9234"G-L272O4((H34-LOOKUP(H34,L48:L61))*LOOKUP(H34,N48:N61))+LOOKUP(H34,P48:P61)5"63) REGULATED INVEST CO. CREDITS (Frm 2439):5"|) R5" ?L FED5"| |R5P4 |R5EPPS205"|P 5" | 5Q10100D 5Q10100D 5Q10100D5P.2305Q10100D5P13225"G-L28D5((H33-LOOKUP(H33,L48:L61))*LOOKUP(H33,N48:N61))+LOOKUP(H33,P48:P61)6'.6"|..6'..6"| |6P5 |6Ef@S356"|@ 6" | 6Q12300#! 6Q12300#! 6Q12300#!6P.2606Q12300#!6P18286"G-L31#!6((H22-LOOKUP(H22,L48:L61))*LOOKUP(H22,N48:N61))+LOOKUP(H22,P48:P61)7"64) total payments:(7"|) t7SUM(D48:D54)H22,L487"| |7P8 |7EycES5(7"|cE 7" | 7Q14950( 7Q14950( 7Q14950(7P.3507Q14950(7P25177"G-L32(7((H24-LOOKUP(H24,L48:L61))*LOOKUP(H24,N48:N61))+LOOKUP(H24,P48:P61)8'-CE8"|--8'--8"| |8P16|8S368"|&v 8" | 8Q17600$ 8Q17600$ 8Q17600$8P.3508Q17600$8P33129"65) amount overpaid:9"|) a9N/AD56-D46OKUP9"| |9P24|9S519"|CE 9" | 9Q229003 9Q229003 9Q2290039P.4009Q2290039P5167:"66) AMOUNT TO BE REFUNDED TO YOU:OKU:"|) A:N/AD58:"| |:P32|:S21:"|EC` :" |` :Q30000O :Q30000O :Q30000O:P.440:Q30000O:P8007;"67) amount to be credited to 1984 est tax:0:;"|) a;N/AD58-D59OKUP;"| |;P40|;S51;"|CE ;" | ;Q428003 ;Q428003 ;Q428003;P.480;Q428003;P13639<"68) amount you owe:d<"|) a<N/AIF(D56'- >"|  ?(S1" | 1" ? 1"| 2" ?(S2" | 2" ? 2"| 3" ?(S3" | 3" ? 3"| 4" ?(S4" | 4" ? 4"| 5" ?(S5" | 5" ? 5"| 6" ?(S6" | 6" ? 6"| 7" ?(S7" | 7" ? 7"| 8"31) total deductions (sum lines 6 TO 30):D):8" |t8SUM(D23:D56)-D45+D46 1983 I8"|9"32) net profit or loss (1040 ln 12 & Sch SE):SAREA9" |n9D19-D57D56)9"*:'-:"|;"IF A LOSS, DO YOU HAVE AMOUNTS FOR WHICHSE):;"[ ] ;" YESSS, DO;"| YE<"YOU ARE NOT "AT RISK" IN THIS BUSINESS?SE):<"[ ]A<" NOE NOT "<"| NO=" (see instructions/form)BUSINESSuperCalc ver. 1.00 TAXTMPL5...REV 84.RJS...1983 IRS SCHEDULE D - 2 PAGESL    & 1 h 4         '"TAXTMPL5...REV 84.RJS...1983 IRS SCHEDULE D - 2 PAGESR 1969: "|V 8 '-V 8  "|V 8 '-V 8 "|V 8)"SCHEDULE D 1983  "|HED)"SCHEDULE D  1983 1982 "|HED*"CAPITAL GAINS & LOSSES PAGE 175)  "|PIT)"CAPITAL GAINS & LOSSES PAGE 2AGE 1 "|PIT '-PIT  "|PIT '-PIT "|PIT!"NAME(S):AINS " ?(!"SOC SEC NO-S  "?C S  "|C S!"NAME(S):O-S!" ?S):O-S "SSNL6T "| '-  "| '- "|)"PART I - SHORT-TERM CAPITAL GAINS & LOSSES - ASSETS HELD ONE YEAR OR LESSE 1  "|RT $"PART III - SUMMARY OF PARTS I & II L "|RT  '.RT  "|RT  '.RT  "|RT ""KIND OF PROPERTYY OF " |  !"DATE AQ'DOPE " |  !"DATE SOLDOPE " |  !"PRICE-EXPNSE " |E !"ADJ BASISSE " |B !"GAIN/-LOSSE "|IN/ #"20) combine lines 8 & 19:S I " |c L31+L58...R "| '. "..| '.| "..| '.| "..| '.| "..| '.| "..| '.| "|| '"21) if line 20>0, smaller of line 19 or 20, else enter 0:NE  " |i IF(S10<=0,0,IF(L58S12,S10-S12,0),L58,S "* !" ?IF( " |  !" ?IF( " |  !" ?IF( " |  !" ?IF( " | !" ?IF( " | H14-J1412,S "| ABS(L14)2,S %" if not 0, else see lines 24 & 25:r on 1 " |  '/|  "|| !"  ?not 0 " | !" ?not 0 " | !" ?not 0 " | !" ?not 0 " | !" ?not 0  " | H15-J152,S  "| ABS(L15)2,S$"24) 50 % of loss calculation:23 & 24 " |5IF(AND(L58<0,L31<0),L31+(.5*L58),IF(L58>=0,S10,.5*S10))... "|!" ?IF(A " | !" ?IF(A " | !" ?IF(A " | !" ?IF(A " | !" ?IF(A  " | H16-J1658<0  "| ABS(L16)8<0&"25) IF LINE 23 = 0, ENTER HERE & FORM 1040, LINE 13 " (I!" ?LINE 2 ")* !" ?INE 2 " | !" ?INE 2 " | !" ?INE 2 " | !" ?INE 2 " | !" ?INE 2  " | H17-J178<0  "| ABS(L17)8<0&" THE SMALLEST OF: a) LINE 24, b) $3000 ($150013 " |  '\|  "|| !" ? SMAL " | !" ? SMAL " | !" ? SMAL " | !" ? SMAL "  | !" ? SMAL  " | H18-J188<0  "| ABS(L18)8<0&" IF MARRIED & FILING SEPARATE), OR c) TAXABLE13 " |  '/|  "|| !" ?MARRI " | !" ?MARRI " | !" ?MARRI " | !" ?MARRI " | !" ?MARRI  " | H19-J198<0  "| ABS(L19)8<0#" INCOME, AS ADJUSTEDSEPA " |  '\|  "|| !" ?OME,  " | !" ?OME,  " | !" ?OME,  " | !" ?OME,  " | !" ?OME,  " | H20-J208<0  "| ABS(L20)8<0 '- "|!" ?ABS( " | !" ?ABS( " | !" ?ABS( " | !" ?ABS( " | !" ?ABS(  " | H21-J218<0  "| ABS(L21)8<0)"PART IV - COMPLETE ONLY IF ELECTING OUT OF INSTALLMENT METHOD (MORE)LESSE 1 "|RT !" ?- COM " | !" ?- COM " | !" ?- COM " | !" ?- COM " | !" ?- COM  " | H22-J228<0  "| ABS(L22)8<0!" [ ]ABS(&"CHECK HERE IF ELECTING OUT THE INSTALLMENT METHODMEN "|ECK!" ?RE IF " | !" ?RE IF " | !" ?RE IF " | !" ?RE IF " | !" ?RE IF  " | H23-J238<0  "| ABS(L23)8<0'"ENTER THE FACE AMOUNT OF THE NOTE OR OTHER OBLIGATION:METHOD "?TER "|TER '.TER  "|TER ABS(L24)8<0&"ENTER THE % OF VALUATION OF THE NOTE OR OBLIGATION:N "?TER "|TER)"2) GAIN FROM SALE/EXCHANGE OF PRINCIPAL RESIDENCE HELD 1 YEAR OR LESS:SSE 1  " |G !" ?N FRM  "| ABS(L25)8<0 '- "|)"3) SHORT-TERM CAPITAL GAIN FRM INSTLMNT SALES (Frm 6252, ln 21 or 29):SE 1  " |S !" ?RT-TER  "| ABS(L26)8<0)"PART V - COMPUTATION OF POST-1969 CAPITAL LOSS CARRYOVER FM 1982 TO 1983E 1 "|RT ("4) NET SHORT-TERM GAIN (OR LOSS) FROM PARTNERSHIPS & FIDUCIARIES:O 1  " |E !" ?SHORT-  "| ABS(L27)8<0 '. "|$"5) separate sum of losses/gains FROM " |e (SUM(L12:L27)-SUM(N12:N27))/28),IF(  " | (SUM(L12:L27)+SUM(N12:N27))/28),IF(  "|)"SECTION A - SHORT-TERM CAPITAL LOSS CARRYOVER (only if line 23 < 24)983E 1 "|CTI""6) net gain or loss:  " |e J28+L28:L27  "| '. "|("7) SHORT-TERM LOSS CARRYOVER FROM YEARS BEGINNING AFTER 1969: < 24)  " (H !" ?T-TERM  ") &"26) loss on line 8, else 0 & skip to line 31:ING AFT " |lIF(S15=0,0,ABS(L31)),0) "|%"8) net short-term capital gain of loss: 31:  " |e L29-L3016,I  "|$"27) gain on line 19, else 0 if loss: " |gIF(S30=0,0,IF(L58>0,L58,0)) "| '-  "|%"28) reduce line 26 loss by line 27 gain: 31: " |rIF(S30=0,0,IF(S31>S30,0,S30-S31))) "| *"PART II - LONG-TERM CAPITAL GAINS AND LOSSES - ASSETS HELD MORE THAN ONE YEAR75) "|RT  " |l "|! '. ! "|!#"29) lesser of line 25 or 28:! " |l!IF(S30=0,0,IF(S320,0,ABS(L58)))0)' "|(!" ?IF(( " | (!" ?IF(( " | (!" ?IF(( " | (!" ?IF(( " | (!" ?IF( ( " | (H41-J41,0,I ( "| (ABS(L41)0,I($"33) gain on line 8, else 0 if loss:)( " |g(IF(S39=0,0,IF(L31<0,0,L31))( "|)!" ?IF() " | )!" ?IF() " | )!" ?IF() " | )!" ?IF() " | )!" ?IF( ) " | )H42-J42,0,I ) "| )ABS(L42)0,I)&"34) line 32 - line 33 or 0, whichever greater:e line) " |l)IF(S39=0,0,IF(S40SUM(%"|. &SUM(AM12:AM18)84.RJ'"|"3a) RENTS RECEIVED "|) R" ?NTS REC"| ?" ?NTS REC"| ?" ?NTS REC"| ? "| ? " S?"|S?"26) total columns c) & d) ."|) tSUM(T14:T19))84.RJ"|SUM(V14:V19))84.RJ"|'-"|--'--"|--'--"|-- '--%"|--&'--'"|-" b) ROYALTIES RECEIVEDd) ."|) R" ?YALTIES"| ?" ?YALTIES"| ?" ?YALTIES"| ? SUM(C19:H22))84.RJ "| " H"|H"|..'.."|..'.."|."P."|." ?:)E"| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| '. "|.. '.. "|.. '.. "|.. '.. "|.. '.. "|. " I "|I "27) combine columns c) & d)"|) cV20-T20H22)"|"R"|" ?umns c"| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "RENT & ROYALTY EXPENSE& d)'/NT '/NT "|NT " P "|P "28) EXPENSE DEDUCT FOR SECT 179 PROPERTY (see form)l"() E" ?ENSE D") "O "| " ?UCT FO"| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "4) ADVERTISINGUCT FO"| AD" ?ERTISIN"| ?" ?ERTISIN"| ?" ?ERTISIN"|//? '//? "|/? " S?"|S?"29) total partnership income or lossRTY (see"|) tV22-V23H22)"|"P - B-"|- B" ?ership"| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "5) AUTO & TRAVELship"| AU" ?O & TRA"| ?" ?O & TRA"| ?" ?O & TRA"|//? '//? "|/? './?"|..?'..?"|..?'..?"|.?"R.?"|.?" ?Lship"| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "6) CLEANING/MAINTENANCEcome "| CL" ?ANING/M"| ?" ?ANING/M"| ?" ?ANING/M"|//? '//? "|/? " E TNING/M"| " ?AINTENAN"| " ? ?"| " ? ?"| " ? ?"| "T "|.. '.. "|.. '.. "|.. '.. "|.. '.. !"|.. "'.. #"|.. $'.. %"|.. &'.. '"|. "7) COMMISSIONSNTENAN"| CO" ?MISSION"| ?" ?MISSION"| ?" ?MISSION"|//? '//? "|/? " S RISSION"| " ?SNTENAN"| " ? ?"| " ? ?"| " ? ?"| "Y "| "Totals - Property B . . .or loss' .l"|.lSUM(AE21:AE25)84.RJ"| . ' .$" . .>SUM(%"|. &SUM(AM20:AM26)84.RJ'"|"8) INSURANCE:) "| IN" ?URANCE"| ?" ?URANCE"| ?" ?URANCE"|//? '//? "|/? " T O URANCE"| O " ?:) "| " ? ?"| " ? ?"| " ? ?"| '- "|-- '-- "|-- '-- "|-- '-- %"|-- &'-- '"|- "9) INTEREST"| IN" ?EREST"| ! ?" ?EREST"| ?" ?EREST"|//? '//? "|/? " A R SREST"|.. '.. "|.. '.. "|.. '.. "|.. '.. "|. "P. "|. " ?:) "| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "10) LEGAL/PROFESS FEES . ."|) L" ?GAL/PRO"| ?" ?GAL/PRO"| ?" ?GAL/PRO"|//? '//? "|/? " T TAL/PRO"| "30) total columns c) & d) ."|) tSUM(T25:T29))84.RJ"|SUM(V25:V29))84.RJ"|"R"|" ?:) "| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "11) REPAIRS "|) R" ?PAIRS "| ?" ?PAIRS "|  ?" ?PAIRS "|//? '//? "|/? " E SAIRS "| "|.. '.. "|.. '.. "|. "O. "|. " ?:) "| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "12) SUPPLIES?:) "|) S" ?PPLIES"| ?" ?PPLIES"| ?" ?PPLIES"|//? '//? "|/? " S?"|?"31) total estate or trust income or loss(see"|) tV30-T30V29)"|"P - C-"|- C" ?e or t"| " ? "| ?" ? "| " ? !"| "" ? #"| $" ? %"| ?&" ? '"| "13) TAXES (EX. WINDFALL PROF TX)or l "|) T " ?XES (EX "| ? " ?XES (EX "| ? " ?XES (EX "|//? '//? "|/? './? "|..? '..? "|..? '..? "|.? "R.? "|.? " ?WINDFA "|  " ?  "| ? " ?  "| " ? ! "| " " ? # "| $ " ? % "| ?& " ? ' "| !"14) UTILITIESWINDFA!"|) U!" ?ILITIES!"| ?!" ?ILITIES!"| ?!" ?ILITIES!"|//? !'//? !"|/? !" B!"| B!" ?WINDFA!"| !" ? ?!"| !" ? ?!"| !" ? ?!"| !"T !"|.. !'.. !"|.. !'.. !"|.. !'.. !"|.. !'.. !!"|.. "!'.. #!"|.. $!'.. %!"|.. &!'.. '!"|. ""15) WAGES/SALARIESFA""|) W"" ?GES/SAL""| ?"" ?GES/SAL""| ?"" ?GES/SAL""|//? "'//? ""|/? "" S U CLITIES""| U "" ?ARIESFA""| "" ? ?""| "" ? ?""| "" ? ?""| ""Y ""| ""Totals - Property C . . .TX)or l"' .l""|.l"SUM(AE29:AE33)84.RJ""| . "' .$"" . .>SUM(%""|. &"SUM(AM28:AM34)84.RJ'""|#"16) OTHER (LIST)") #"|//O#'//O #'//O #"|/O #" M S OER (LI#"| S #" ?ST)") #"| #" ? ?#"| #" ? ?#"| #" ? ?#"| #'- #"|-- #'-- #"|-- #'-- #"|-- #'-- %#"|-- &#'-- '#"|- $" ? ?$"| $" ? ? ?$"| ?$" ? ? ?$"| ?$" ? ? ?$"|//? $'//? $"|/? $" A I R? ?$"|.. $'.. $"|.. $'.. $"|.. $'.. $"|.. $'.. $"|. %" ? ?%"| %" ? ? ?%"| ?%" ? ? ?%"| ?%" ? ? ?%"|//? %'//? %"|/? %" L N P ?%"| N %"32) total columns c) & d) .%"|) t%SUM(T33:T37))84.RJ%"|%SUM(V33:V37))84.RJ%"|&"  ?UM(&"| &" ??UM(&"| ?&" ??UM(&"| ?&" ??UM(&"|//? &"//////////|( &" L E&"|/?&"33) SUM COLUMNS c) and d)179&"|) S&"|) S&V38-T38V37)&"| '" ?UM('"; '" ??UM('"| ?'" ??UM('"| ?'" ??UM('"|//? '"//////////|( '"|/// '" S'"|/?'"34) DEDUCTION FOR SECTION 179 PROPERTY (1120S, K-1)l'"|'" ?&-'"|- (" ?SUM(("| (" ? ?SUM(("| ?(" ? ?SUM(("| ?(" ? ?SUM(("|//? ('//? ("|/?("| S("35) total small business corp. income or lossform)l("|) t(V39-V40V37)("|)" ?&-)"| )" ? ?&-)"| ?)" ? ?&-)"| ?)" ? ?&-)"|//? )'//? )"|/? )'-/?)"|--?)'--?)"|--?)'--?)"|-?*" ?&-*"| *" ? ?&-*"| ?*" ? ?&-*"| ?*" ? ?&"-*"|//? *'//? *"|/? *"PART III - WINDFALL PROFITS TAX SUMMARY loss*"|RT +" ?- WI+"| +" ? ?- WI+"| ?+" ? ?- WI+"| ?+" ? ?- WI+"|//? +'//? +"|/? +'./?+"|/?," ?- WI,"| ," ? ?- WI,"| ?," ? ?- WI,"| ?," ? ?- WI,"|//? ,'//? ,"|/? ,"36) WINDFALL PROFIT TAX CREDIT OR REFUND IN 1983 (see instructions)n,"|) W," ?DFALL ,"| -" ?ALL -"| -" ? ?ALL -"| ?-" ? ?ALL -"| ?-" ? ?ALL -"|//? -'//? -"|/? -"37) WINDFALL PROFITS TAX WITHHELD IN 1983 (see instructions)-"() W-" ?DFALL -") ." ?ALL ."| ." ? ?ALL ."| ?." ? ?ALL ."| ?." ? ?ALL ."|//? .'//? ."|/? ."38) combine amounts on lines 36 & 37."|) c.V45-V46V37)."|/'./"|../'../"|../'../"|../'../"|// /'// /"|/ /'-//"|--/'--/"|-0"17) total expenses abovenes 0"|) t0SUM(D23:D48))84.RJ0"|0SUM(F23:F48))84.RJ0"|0SUM(H23:H48))84.RJ0"| 0SUM(C49:H49))84.RJ 0"| 0"PART IV - SUMMARY)b0"|RT 1"18) DEPRECIATION/DEPLETION EXPNS 351"|) D1" ?PRECIAT1"| ?1" ?PRECIAT1"| ?1" ?PRECIAT1"| ? 1SUM(C50:H50))84.RJ 1"| 1'.1"|2"19) total above1)L2"|) t2D49+D50H50)2"|2F49+F50H50)2"|2H49+H50H50)2"|// 2'// 2"|/ 2"39) total income or loss (lines 25+29+31+35+38)(Fm 1040, ln 18)ns)n2"|) t2J59+V24+V32+V41+V472"*3"20) total income or loss(lin3"|) t3D20+D21-D513"|3F20+F21-F513"|3H20+H21-H513"|// 3'// 3"|/ 3"40) SHARE OF GROSS FISH/FARM INCOME APPLIC TO PARTS I & II 13"|) S3" ?RE OF 3"| 4"|.. 4'.. 4"|.. 4'.. 4"|.. 4'.. 4"|// 4'// 4"|/ 4'-/ 4"|-- 4'-- 4"|- 5"21) total from properties with gainsPPLIC TO5"|) t 5(SUM(D52:H52)+(ABS(D52)+ABS(F52)+ABS(H52)))/23 PAGE 5"|6"22) total from properties with lossesABS(3)6"|) t 6(SUM(D52:H52)-(ABS(D52)+ABS(F52)+ABS(H52)))/23 PAGE 6"|7"23) net profit or lossBS(3)7"|) n 7J54+J55:H52 7"|8'.8"|.. 8'.. 8"|.9"24) NET FARM RENTAL PROFIT OR LOSS (FORM 4835, LINE 50)II 19"|) N 9" ?T FARM 9"| ?:"25) total rental or royalty income or loss35:"|) t :SUM(J56:J58)-(ABS(D :"*;'-;"|-- ;'-- ;"|-F20+F21-F513"|3H20+H21-H513"|// 3'// 3"|/ 3"40) SHARE OF GROSS FISH/FARM INCOME APPSuperCalc ver. 1.00 TAXTMPL7...REV 84.RJS...1983 IRS FORM 4562 - 2 PAGESL         h 4         &"TAXTMPL7...REV 84.RJS...1983 IRS FORM 4562 - 2 PAGES "|V 8 "|V 8 '-V 8 "|V 8 '-V 8 "|V 8)"FORM 4562 1983 "|RM )"FORM 4562  1983 "|RM )"DEPRECIATION & AMORTIZATION PAGE 1 "|PRE)"DEPRECIATION & AMORTIZATION PAGE 2 "|PRE '-PRE "|PRE '-PRE "|PRE!"NAME(S):ION "" ?MORTI!"SOC SEC NO-  " ? S "| S!"NAME(S):O- "" ?MORTI!"SOC SEC NO- J6T "| '- "| '- "|#"PART I - DEPRECIATIONATION  "|RT &"SECTION C - DEPRECIATION OF NONRECOVERY PROPERTY  "|CTI '.CTI "|CTI '.CTI "|CTI ("SECTION A - ELECTION TO EXPENSE RECOVERY PROPERTY (SECT. 179)  "|CTI #" A) CLASS OF PROPERTYEXPEN "| A) !"B) DATEASS O "| DA ""C) COST/OTHER PROPER "| CO !"D) DEPREC.ER "| DE !"E) DEPREC.ER "| DE !"F) LIFEC.ER "| LI !"G) DEDUCT.ER "| DE '. DE "| DE " DE "| DE !" ACQR'D.ER "|ACQ !" BASISER# "|  !" ALLOWEDER "| AL !" METHODER "| ME !"OR RATEDER "| RA !" THIS YEARER "|HIS &" A) CLASS OF PROPERTYRTY (SE "| !"B) COST "| CO ""C) EXPNS DEDUCT  "| EX '. EX "|..X '..X "|..X '..X "|..X '..X "|..X '..X "|..X '..X "|..X '..X "|.X $" ?OF "| !" ? "| !" ?  "|  *"5) CLASS LIFE ASSET DEPRECIATION RANGE (CLADR) SYSTEM DEPRECIATION . . . ' .L !". . .>LIFE "| .  !" ?LIFE "| $" ?ANG "| !" ? "| !" ?  "|  &"6) OTHER DEPRECIATION (see instructions) ///) SYSTEM '/ OT "| OT$" ?tio  "| !" ?  "| !" ?  "| "" ?  "| !" ?  "| ?!"  ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| $" ?tio  "| !" ?  "| !" ?  "| "" ?  "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| $" ?tio  "| !" ?  "| !" ?  "| "" ?  "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| ,"1) total (not more than $5000), enter here & line 8 (Partnerships - enter on Sch K, Frm 1065):  "| to IF(SUM(N12:N17)>5000,5000,SUM(N12:N17))62 - "*"" ?( : "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  '.  '.  "|..  '..  "|. "" ?( : "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| &"SECTION B - DEPRECIATION OF RECOVERY PROPERTYine 8 ( "|CTI"" ?RECIAT "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  '.  '.  '.  "| "" ?RECIAT "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| #" A) CLASS OF PROPERTY OF R "| A)!"B) DATE IN O "| DA""C) COST/OTHER PROPER "| CO!"D) RECOV.HER "| RE !"E) DEPREC.ER  "| DE !"F) PERCENTER  "| PE !"G) DEDUCT.ER "| DE"" ?PROPER "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  "| !" SERVICE  "| SE!" BASIS  "| B!" PERIOD  "|PER !" METHOD  "|MET  "|MET !" THIS YEAR  "|THI"" ?PROPER "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  '.  "|..  '..  "|..  '..  "|..  '..  "|..  '..  "|..  '..  "|..  '..  "|. "" ?PROPER "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| )"2) ACCELERATED COST RECOVERY SYSTEM (ACRS) (see instructions): //////// on  '/ AC "| AC"" ?COST R "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  "| !" ?  "| !" ?  "| !" ? ?  "| ? !" ? ?  "| ? !" ??  "| (F26*L26)/100)>5000 "|"" ?)/100 "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| #" a) 3-year propertyECOVERY  "|a) !" ?year p "| !" ?ar p "| !" ? ?ar p "| ? !" ? ?ar p  "| ? !" ??ar p  "| (F27*L27)/100)>5000 "|"" ?)/100 "| !" ?  "| ?!" ?  "| !" ?  "| $ !" ?  "| !" ?  "| ?!" ?  "|  "| !" ?  "| !" ?  "| !" ? ?  "| ? !" ? ?  "| ? !" ??  "| (F28*L28)/100)>5000 "|"" ?)/100 "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  '.  "|..  '..  "|..  '..  "|..  '..  "|..  '..  "|..  '..  "|..  '..  "|. "" ?)/100 "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  "| !" ?  "| !" ?  "| !" ? ?  "| ? !" ? ?  "| ? !" ??  "| (F30*L30)/100)>5000 "|"" ?)/100 "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  "| !" ?  "| !" ?  "| !" ? ?  "| ? !" ? ?  "| ? !" ??  "| (F31*L31)/100)>5000 "|"" ?)/100 "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "| #" b) 5-year propertyECOVERY  "|b) !" ?year p "| !" ?ar p "| !" ? ?ar p "| ? !" ? ?ar p  "| ? !" ??ar p  "| (F32*L32)/100)>5000 "|"" ?)/100 "| !" ?  "| ?!" ?  "| !" ?  "| !" ?  "| !" ?  "| ?!" ?  "|  "|  !" ?  "|  !" ?  "|  !" ? ?  "| ? !" ? ? "| ? !" ?? "| (F33*L33)/100)>5000 "| "" ?)/100 "|  !" ?  "| ? !" ?  "|  !" ?  "|  !" ?  "|  !" ?  "| ? !" ?  "| ! "| !!" ? ! "| !!" ? ! "| !!" ? ? ! "| ? !!" ? ? ! "| ? !!" ?? ! "| !(F34*L34)/100)>5000! "|!"" ?)/100! "| !!" ? ! "| ?!!" ? ! "| !!" ? ! "| !!" ? ! "| !!" ? ! "| ?!!" ? ! "| " '. " "|.. " '.. " "|.. " '.. " "|.. " '.. " "|.. " '.. " "|.. " '.. " "|.. " '.. " "|. """ ?)/100" "| "!" ? " "| ?"!" ?  " "| "!" ? " "| "!" ? " "| "!" ? " "| ?"!" ? " "| # "| #!" ? # "| #!" ? # "| #!" ? ? # "| ? #!" ? ? # "| ? #!" ?? # "| #(F36*L36)/100)>5000# "|#"" ?)/100# "| #!" ? # "| ?#!" ? # "| #!" ? # "| #!" ? # "| #!" ? # "| ?#!" ? # "| $ "| $!" ? $ "| $!" ? $ "| $!" ? ? $ "| ? $!" ? ? $ "| ? $!" ?? $ "| $(F37*L37)/100)>5000$ "|$"" ?)/100$ "| $!" ? $ "| ?$!" ? $ "| $!" ? $ "| $!" ? $ "| $!" ? $ "| ?$!" ? $ "| %#" c) 10-year propertyCOVERY % "|c) %!" ?-year % "| %!" ?ear % "| %!" ? ?ear % "| ? %!" ? ?ear % "| ? %!" ??ear % "| %(F38*L38)/100)>5000% "|% '.% "|..% '..% "|..% '..% "|..% '..% "|..% '..% "|..% '..% "|..% '..% "|.& "|.&!" ?(&*& "| &!" ?(&*& "| &!" ? ?(&*& "| ? &!" ? ?(&* & "| ? &!" ??(&* & "| &(F39*L39)/100)>5000& "|&$"7) total column G, section C:YSTEM (& "| to&SUM(AB13:AB37)>5000& "|' '.' "|..' '..' "|..' '..' "|..' '..' "|.. ' '.. ' "|.. ' '.. ' "|.. ' '..' "|.'&"8) section A, line 1 (PARTNERSHIPS ENTER ZERO):instr' "|>se'N18' "|( "|(!" ?,( "| (!" ?,( "| (!" ? ?,( "| ? (!" ? ?, ( "| ? (!" ??, ( "| ((F41*L41)/100>5000( "|(#"9) section B, line 4(PARTNER( "|% se(N63( "|)#" d) 15-year propertyPARTNER) "|d) )!" ?-year ) "| )!" ?ear ) "| )!" ? ?ear ) "| ? )!" ? ?ear ) "| ? )!" ??ear ) "| )(F42*L42)/100>5000) "|)("10) total lines 7, 8, & 9, here & DEPRECIATION line of return /////) "|) t)SUM(AB39:AB41)>5000) "** '.* "|..* '..* "|..* '..* "|..* '..* "|.. * '.. * "|.. * '.. * "|.. * '..* "|.* '-.* "|--* '--* "|-+#" e) 15-year property - lowe+ "|e) +!" ?-year + "| +!" ?ear + "| +!" ? ?ear + "| ? +!" ? ?ear + "| ? +!" ??ear + "| +(F44*L44)/100>5000+ "|+$"PART II - AMORTIZATION OF PROPERTYEP+ "|RT ,"" income housingO, "| ,!" ?come h, "| ,!" ?me h, "| ,!" ? ?me h, "| ? ,!" ? ?me h , "| ? ,!" ??me h , "|  ,(F45*L45)/100>5000, "|, '., '., "|- '.- "|..- '..- "|..- '..- "|..- '..- "|.. - '.. - "|.. - '.. - "|.. - '..- "|.-$" A) DESCRIPTION OF PROPERTYERTYEP- "| A)-!"B) DATESCRIP- "| DA-""C) COST/OTHERION OF - "| CO-!"D) AMORTIZER- "| AM-!"E) CODEIZER- "| CO-!"F) AMORTZER- "| AM-!"G) AMORTIZER- "| AM. "| AM.!" ?TIZER. "| .!" ?ZER. "| .!" ? ?ZER. "| ? .!" ? ?ZER . "| ? .!" ??ZER . "| .(F47*L47)/100>5000. "|. ". "|.!" ACQR'D(/*. "|ACQ.!" BASIS/*. "| B.!" ALLOWED/*. "| AL.!" SECTION/*. "|SEC.!"%/PERIOD/*. "|PER.!" THIS YEAR/*. "|HIS/ "|HIS/!" ?EAR/*/ "| /!" ?R/*/ "| /!" ? ?R/*/ "| ? /!" ? ?R/* / "| ? /!" ??R/* / "| /(F48*L48)/100>5000/ "|/ './ './ "|0 "|0!" ?(0*0 "| 0!" ?(0*0 "| 0!" ? ?(0*0 "| ? 0!" ? ?(0* 0 "| ? 0!" ??(0* 0 "| 0(F49*L49)/100>50000 "|0"" ?)/1000 "| 0!" ? 0 "| ?0!" ? 0 "| 0!" ? 0 "| 0!" ? 0 "| 0!" ? 0 "| ?0!" ? 0 "| 1#" f) 15-year real propertyTY1 "|f) 1!" ?-year 1 "| 1!" ?ear 1 "| 1!" ? ?ear 1 "| ? 1!" ? ?ear 1 "| ? 1!" ??ear 1 "| 1(F50*L50)/100>50001 "|1"" ?)/1001 "| 1!" ? 1 "| ?1!" ? 1 "| 1!" ? 1 "| 1!" ? 1 "| 1!" ? 1 "| ?1!" ? 1 "| 2#" other than low-incomeTY2 "| 2!" ?her th2 "| 2!" ?r th2 "| 2!" ? ?r th2 "| ? 2!" ? ?r th 2 "| ? 2!" ??r th 2 "| 2(F51*L51)/100>50002 "|2"" ?)/1002 "| 2!" ? 2 "| ?2!" ? 2 "| 2!" ? 2 "| 2!" ? 2 "| 2!" ? 2 "| ?2!" ? 2 "| 3"" housing?)/1003 "| 3!" ?using3 "| 3!" ?ing3 "| 3!" ? ?ing3 "| ? 3!" ? ?ing 3 "| ? 3!" ??ing 3 "| 3(F52*L52)/100>50003 "|3"" ?)/1003 "| 3!" ? 3 "| ?3!" ? 3 "| 3!" ? 3 "| 3!" ? 3 "| 3!" ? 3 "| ?3!" ? 3 "| 4 "| 4!" ? 4 "| 4!" ? 4 "| 4!" ? ? 4 "| ? 4!" ? ? 4 "| ? 4!" ?? 4 "| 4(F53*L53)/100>50004 "|4 '.4 "|5 "|5!" ?(5*5 "| 5!" ?(5*5 "| 5!" ? ?(5*5 "| ? 5!" ? ?(5* 5 "| ? 5!" ??(5* 5 "| 5(F54*L54)/100>50005 "|5*"total column G, part II, here & on OTHER DEDUCTION OR EXPENSE line of returnSch K, F5 "|tal5SUM(AB49:AB52)>50005 "*6 '.6 "|..6 '..6 "|..6 '..6 "|..6 '..6 "|.. 6 '.. 6 "|.. 6 '.. 6 "|.. 6 '..6 "|.6 '..6 "|..6 '..6 "|.7)"3) PROPERTY SUBJECT TO SECTION 168(e)(2) ELECTION (see instructions):return7 '/ PR7 "| PR8"" ?UBJECT T8 "| 8!" ? ?8 "| 8!" ? ?8 "|\\ 8 '\\ 8 "|\ 8!" ?? ? 8 "| 8!" ? ?8 "| 9"" ?UBJECT T9 "| 9!" ? ?9 "| 9!" ? ?9 "|// 9 '// 9 "|/ 9!" ?? ? 9 "| 9!" ? ?9 "| :"" ?UBJECT T: "| :!" ? ?: "| :!" ? ?: "|\\ : '\\ : "|\ :!" ?? ? : "| :!" ? ?: "| ;"" ?UBJECT& T; "| ;!" ? ?; "| ;!" ? ?; "|// ; '// ; "|/ ;!" ?? ? ; "| ;!" ? ?; "| <"" ?UBJECT T< "| %"4) total column G), enter here & line 9:ELEC> ' .o > ' .o > "|.o >SUM(N25:N62))>5000> "|? '-? '- ? "|-- ? '--? "|-" ? ?8 "| 9"" ?UBJECT T9 "| 9!" ? ?9 "| 9!" ? ?9 "|// 9 '// 9 "|/ 9!" ?? ? 9 "| 9!" ? ?9 "| :"" ?UBJECT T: "| :!" ? ?: "| :!" ? ?: "|\\ : '\\ : "|\ :!" ?? ? : "| :!" ? ?: "| ;"" ?UBJECT This is the release date of the disk. TAXTMPL4CAL yTAXTMPL5CAL /TAXTMPL6CAL GAXTMPL6CAL TAXTMPL7CAL FAXTMPL7CAL TAXTMPL2.CAL 18 94 17024 133 TAXTMPL3.CAL 56 10 4736 37 TAXTMPL4.CAL E3 17 6272 49 TAXTMPL5.CAL 1D CF 12160 95 TAXTMPL6.CAL 3A 18 18304 143 TAXTMPL7.CAL 84 19 18048 141  Fog Library Disk FOG-CPM.056 Copyright (1986) by Fog International Computer Users Group to the extent not copyrighted by the original author for the exclusive use and enjoyment of its members. Any reproduction or distribution for profit or personal gain is strictly forbidden. For information, contact FOG, P. O. Box 3474, Daly City, CA. 94015-0474. as part of the description of a file indicates that the program is distributed on a "try first, pay if you like it" basis. If you find the program(s) meet your need, please refer to the author's documentation for information on becoming a registered user. Only by registering and paying for the programs you like and use will the authors of such programs continue development. Often, more complete documentation, additional modules, and new releases are available only to registered users. SuperCalc applications. Filename Description -06-00 .86 This is the release date of the disk. -CPM056 .DOC This is the description of the disk contents. CASHFLW .CAL 14A1 7K [Cash flow 1 of 2] A SuperCalc 1.12 template to estimate net cash flow from rental property. CASHFLW .DOC 2975 2K [Cash flow 2 of 2] ELNA .CAL BB29 20K [ELNA 1 of 3] A SuperCalc 1.05 stock portfolio analysis template. Both the blank master template and a sample are included. ELNA .DOC D2DE 5K [ELNA 2 of 3] ELNAEX .CAL F2E4 25K [ELNA 3 of 3] TAXSHLTR.CAL 0A16 5K [Tax Shelter 1 of 2] A SuperCalc 1.12 template which calculates the tax benefits from real estate. TAXSHLTR.DOC 978F 2K [Tax Shelter 2 of 2] TAXTMPL .DOC A011 21K [1983 Tax Returns 1 of 8] SuperCalc 2 templates to help prepare 1983 income tax returns TAXTMPL1.CAL 51B1 9K [1983 Tax Returns 2 of 8] TAXTMPL2.CAL 1894 17K [1983 Tax Returns 3 of 8] TAXTMPL3.CAL 5610 5K [1983 Tax Returns 4 of 8] TAXTMPL4.CAL E317 7K [1983 Tax Returns 5 of 8] TAXTMPL5.CAL 1DCF 12K [1983 Tax Returns 6 of 8] TAXTMPL6.CAL 3A18 18K [1983 Tax Returns 7 of 8] TAXTMPL7.CAL 8419 18K [1983 Tax Returns 8 of 8]  SuperCalc 2 templates to help prepare 1983 income tax returns TAXTMPL1.CAL 51B1 9K [1983 Tax Returns 2 of 8] TAXTMPL2.CAL 1894 17K [1983 Tax '