LnSOS BOOT 1.1 SOS.KERNEL SOS KRNLI/O ERRORFILE 'SOS.KERNEL' NOT FOUND%INVALID KERNEL FILE: xةw,@  ȱlmi8#)!)>AL24:/F$((AL10*AJ10)+(AL11*AJ11)+(AL12*AJ12)+(AL15*AJ15)+(AL20*AJ20)+(AL22*AJ22))/AJ24 >AK24:+AK13+AK15+AK20+AK22 >AJ24:+AJ13+AJ15+AJ20+AJ22 >AI24:/F$((AI10*AG10)+(AI11*AG11)+(AI12*AG12)+(AI15*AG15)+(AI20*AG20)+(AI22*AG22))/AG24 >AH24:+AH13+AH15+AH20+AH22%SEG.T j۸ Ÿ/ /BANKCALC2.ASCII  ܸ ܸ#C&MODEL7$!E&MODEL82&MODEL9 'MODEL102`*MENU.MAKER 3*8DISKNAME.DAT ۸ ۸ III.AWZ.08u' &MODEL1\-&MODEL2 4&MODEL3< )&MODEL4H c&MODEL5S&MODEL6d >dLԡm#i㰼m#iЕOLԡȱfg hi !dLԡ憦  Ljmkm l y`2 Lԡ8(Je稽)ʈ@L >AG24:+AG13+AG15+AG20+AG22 >AF24:/F$((AF10*AD10)+(AF11*AD11)+(AF12*AD12)+(AF15*AD15)+(AF20*AD20)+(AF22*AD22))/AD24 >AE24:+AE13+AE15+AE20+AE22 >AD24:+AD13+AD15+AD20+AD22 >AC24:/F$((AC10*AA10)+(AC11*AA11)+(AC12*AA12)+(AC15*AA15)+(AC20*AA20)+(AC22*AA22))/AA2  >D19:" ........ >B19:" TAXABLE >A19:+A18+1 >AL18:/F$(((AK18*12)/.54)/AJ18)*100 >AK18:" ......... >AJ18:" .......... >AI18:/F$(((AH18*12)/.54)/AG18)*100 >AH18:" ......... >AG18:" .......... >AF18:/F$(((AE18*12)/.54)/AD18)*100 >AE18:" ...>T19:/F$((S19*12)/R18)*100 >S19:" ........ >Q19:/F$((P19*12)/O18)*100 >P19:" ........ >N19:/F$((M19*12)/L18)*100 >M19:" ........ >K19:/F$((J19*12)/I18)*100 >J19:" ........ >H19:/F$((G19*12)/F18)*100 >G19:" ........ >E19:/F$((D19*12)/C18)*100" ........ >AI19:/F$((AH19*12)/AG18)*100 >AH19:" ........ >AF19:/F$((AE19*12)/AD18)*100 >AE19:" ........ >AC19:/F$((AB19*12)/AA18)*100 >AB19:" ........ >Z19:/F$((Y19*12)/X18)*100 >Y19:" ........ >W19:/F$((V19*12)/U18)*100 >V19:" ........ >P20:+P18+P19 >O20:+O18 >N20:/F$+N18+N19 >M20:+M18+M19 >L20:+L18 >K20:/F$+K18+K19 >J20:+J18+J19 >I20:+I18 >H20:/F$+H18+H19 >G20:+G18+G19 >F20:+F18 >E20:/F$+E18+E19 >D20:+D18+D19 >C20:+C18 >B20:" SUBTOTAL EQ >A20:+A19+1 >AL19:/F$((AK19*12)/AJ18)*100 >AK19:8+AH19 >AG20:+AG18 >AF20:/F$+AF18+AF19 >AE20:+AE18+AE19 >AD20:+AD18 >AC20:/F$+AC18+AC19 >AB20:+AB18+AB19 >AA20:+AA18 >Z20:/F$+Z18+Z19 >Y20:+Y18+Y19 >X20:+X18 >W20:/F$+W18+W19 >V20:+V18+V19 >U20:+U18 >T20:/F$+T18+T19 >S20:+S18+S19 >R20:+R18 >Q20:/F$+Q18+Q19F$(((G22/H6)*365)/F22)*100 >G22:" ......... >F22:" ......... >E22:/F$(((D22/E6)*365)/C22)*100 >D22:" ......... >C22:" ......... >B22:" BROKER >A22:+A21+1 >A21:+A20+1 >AL20:/F$+AL18+AL19 >AK20:+AK18+AK19 >AJ20:+AJ18 >AI20:/F$+AI18+AI19 >AH20:+AH1" ......... >R22:" ......... >Q22:/F$(((P22/Q6)*365)/O22)*100 >P22:" ......... >O22:" ......... >N22:/F$(((M22/N6)*365)/L22)*100 >M22:" ......... >L22:" ......... >K22:/F$(((J22/K6)*365)/I22)*100 >J22:" ......... >I22:" ......... >H22:/2:/F$(((AB22/AC6)*365)/AA22)*100 >AB22:" ......... >AA22:" ......... >Z22:/F$(((Y22/Z6)*365)/X22)*100 >Y22:" ......... >X22:" ......... >W22:/F$(((V22/W6)*365)/U22)*100 >V22:" ......... >U22:" ......... >T22:/F$(((S22/T6)*365)/R22)*100 >S22:A23+1 >A23:+A22+1 >AL22:/F$(((AK22/AL6)*365)/AJ22)*100 >AK22:" ......... >AJ22:" ......... >AI22:/F$(((AH22/AI6)*365)/AG22)*100 >AH22:" ......... >AG22:" ......... >AF22:/F$(((AE22/AF6)*365)/AD22)*100 >AE22:" ......... >AD22:" ......... >AC2:/F$((H10*F10)+(H11*F11)+(H12*F12)+(H15*F15)+(H20*F20)+(H22*F22))/F24 >G24:+G13+G15+G20+G22 >F24:+F13+F15+F20+F22 >E24:/F$((E10*C10)+(E11*C11)+(E12*C12)+(E15*C15)+(E20*C20)+(E22*C22))/C24 >D24:+D13+D15+D20+D22 >C24:+C13+C15+C20+C22 >B24:"GRAND TOTAL >A24:+O13+O15+O20+O22 >N24:/F$((N10*L10)+(N11*L11)+(N12*L12)+(N15*L15)+(N20*L20)+(N22*L22))/L24 >M24:+M13+M15+M20+M22 >L24:+L13+L15+L20+L22 >K24:/F$((K10*I10)+(K11*I11)+(K12*I12)+(K15*I15)+(K20*I20)+(K22*I22))/I24 >J24:+J13+J15+J20+J22 >I24:+I13+I15+I20+I22 >H243+V15+V20+V22 >U24:+U13+U15+U20+U22 >T24:/F$((T10*R10)+(T11*R11)+(T12*R12)+(T15*R15)+(T20*R20)+(T22*R22))/R24 >S24:+S13+S15+S20+S22 >R24:+R13+R15+R20+R22 >Q24:/F$((Q10*O10)+(Q11*O11)+(Q12*O12)+(Q15*O15)+(Q20*O20)+(Q22*O22))/O24 >P24:+P13+P15+P20+P22 >O24:+4 >AB24:+AB13+AB15+AB20+AB22 >AA24:+AA13+AA15+AA20+AA22 >Z24:/F$((Z10*X10)+(Z11*X11)+(Z12*X12)+(Z15*X15)+(Z20*X20)+(Z22*X22))/X24 >Y24:+Y13+Y15+Y20+Y22 >X24:+X13+X15+X20+X22 >W24:/F$((W10*U10)+(W11*U11)+(W12*U12)+(W15*U15)+(W20*U20)+(W22*U22))/U24 >V24:+V1...... >AD18:" .......... >AC18:/F$(((AB18*12)/.54)/AA18)*100 >AB18:" ......... >AA18:" .......... >Z18:/F$(((Y18*12)/.54)/X18)*100 >Y18:" ......... >X18:" .......... >W18:/F$(((V18*12)/.54)/U18)*100 >V18:" ......... >U18:" .......... >T18:/F$(((S18*12)/.54)/R18)*100 >S18:" ......... >R18:" .......... >Q18:/F$(((P18*12)/.54)/O18)*100 >P18:" ......... >O18:" .......... >N18:/F$(((M18*12)/.54)/L18)*100 >M18:" ......... >L18:" .......... >K18:/F$(((J18*12)/.54)/I18)*100 >J18:" 0 >Y11:" ......... >X11:" .......... >W11:/F$(((V11/W6)*365)/U11)*100 >V11:" ......... >U11:" .......... >T11:/F$(((S11/T6)*365)/R11)*100 >S11:" ......... >R11:" .......... >Q11:/F$(((P11/Q6)*365)/O11)*100 >P11:" ......... >O11:" .......... >N1/F$(((AH11/AI6)*365)/AG11)*100 >AH11:" ......... >AG11:" .......... >AF11:/F$(((AE11/AF6)*365)/AD11)*100 >AE11:" ......... >AD11:" .......... >AC11:/F$(((AB11/AC6)*365)/AA11)*100 >AB11:" ......... >AA11:" .......... >Z11:/F$(((Y11/Z6)*365)/X11)*10... >H12:/F$(((G12/H6)*365)/F12)*100 >G12:" ........ >F12:" .......... >E12:/F$(((D12/E6)*365)/C12)*100 >D12:" ........ >C12:" .......... >B12:" DEMAND >A12:+A11+1 >AL11:/F$(((AK11/AL6)*365)/AJ11)*100 >AK11:" ......... >AJ11:" .......... >AI11:R12)*100 >S12:" ........ >R12:" .......... >Q12:/F$(((P12/Q6)*365)/O12)*100 >P12:" ........ >O12:" .......... >N12:/F$(((M12/N6)*365)/L12)*100 >M12:" ........ >L12:" .......... >K12:/F$(((J12/K6)*365)/I12)*100 >J12:" ........ >I12:" ....... .......... >AC12:/F$(((AB12/AC6)*365)/AA12)*100 >AB12:" ........ >AA12:" .......... >Z12:/F$(((Y12/Z6)*365)/X12)*100 >Y12:" ........ >X12:" .......... >W12:/F$(((V12/W6)*365)/U12)*100 >V12:" ........ >U12:" .......... >T12:/F$(((S12/T6)*365)/0+C11+C12 >B13:" SUBTOTAL >A13:+A12+1 >AL12:/F$(((AK12/AL6)*365)/AJ12)*100 >AK12:" ........ >AJ12:" .......... >AI12:/F$(((AH12/AI6)*365)/AG12)*100 >AH12:" ........ >AG12:" .......... >AF12:/F$(((AE12/AF6)*365)/AD12)*100 >AE12:" ........ >AD12:"(M13/N6)*365)/L13)*100 >M13:+M10+M11+M12 >L13:+L10+L11+L12 >K13:/F$(((J13/K6)*365)/I13)*100 >J13:+J10+J11+J12 >I13:+I10+I11+I12 >H13:/F$(((G13/H6)*365)/F13)*100 >G13:+G10+G11+G12 >F13:+F10+F11+F12 >E13:/F$(((D13/E6)*365)/C13)*100 >D13:+D10+D11+D12 >C13:+C100 >Y13:+Y10+Y11+Y12 >X13:+X10+X11+X12 >W13:/F$(((V13/W6)*365)/U13)*100 >V13:+V10+V11+V12 >U13:+U10+U11+U12 >T13:/F$(((S13/T6)*365)/R13)*100 >S13:+S10+S11+S12 >R13:+R10+R11+R12 >Q13:/F$(((P13/Q6)*365)/O13)*100 >P13:+P10+P11+P12 >O13:+O10+O11+O12 >N13:/F$((AI6)*365)/AG13)*100 >AH13:+AH10+AH11+AH12 >AG13:+AG10+AG11+AG12 >AF13:/F$(((AE13/AF6)*365)/AD13)*100 >AE13:+AE10+AE11+AE12 >AD13:+AD10+AD11+AD12 >AC13:/F$(((AB13/AC6)*365)/AA13)*100 >AB13:+AB10+AB11+AB12 >AA13:+AA10+AA11+AA12 >Z13:/F$(((Y13/Z6)*365)/X13)*1100 >G15:" ........ >F15:" .......... >E15:/F$(((D15/E6)*365)/C15)*100 >D15:" ........ >C15:" .......... >B15:" AUTO LEASE >A15:+A14+1 >A14:+A13+1 >AL13:/F$(((AK13/AL6)*365)/AJ13)*100 >AK13:+AK10+AK11+AK12 >AJ13:+AJ10+AJ11+AJ12 >AI13:/F$(((AH13/.......... >Q15:/F$(((P15/Q6)*365)/O15)*100 >P15:" ........ >O15:" .......... >N15:/F$(((M15/N6)*365)/L15)*100 >M15:" ........ >L15:" .......... >K15:/F$(((J15/K6)*365)/I15)*100 >J15:" ........ >I15:" .......... >H15:/F$(((G15/H6)*365)/F15)*AA15)*100 >AB15:" ........ >AA15:" .......... >Z15:/F$(((Y15/Z6)*365)/X15)*100 >Y15:" ........ >X15:" .......... >W15:/F$(((V15/W6)*365)/U15)*100 >V15:" ........ >U15:" .......... >T15:/F$(((S15/T6)*365)/R15)*100 >S15:" ........ >R15:" :/F$(((AK15/AL6)*365)/AJ15)*100 >AK15:" ........ >AJ15:" .......... >AI15:/F$(((AH15/AI6)*365)/AG15)*100 >AH15:" ........ >AG15:" .......... >AF15:/F$(((AE15/AF6)*365)/AD15)*100 >AE15:" ........ >AD15:" .......... >AC15:/F$(((AB15/AC6)*365)/ ......... >I18:" .......... >H18:/F$(((G18*12)/.54)/F18)*100 >G18:" ......... >F18:" .......... >E18:/F$(((D18*12)/.54)/C18)*100 >D18:" ......... >C18:" .......... >B18:" TAX FREE >A18:+A17+1 >B17:" EQUIPMENT >A17:+A16+1 >A16:+A15+1 >AL151:/F$(((M11/N6)*365)/L11)*100 >M11:" ......... >L11:" .......... >K11:/F$(((J11/K6)*365)/I11)*100 >J11:" ......... >I11:" .......... >H11:/F$(((G11/H6)*365)/F11)*100 >G11:" ......... >F11:" .......... >E11:/F$(((D11/E6)*365)/C11)*100 >D11:" ......... >C11:" .......... >B11:" UNSECURED >A11:+A10+1 >AL10:/F$(((AK10/AL6)*365)/AJ10)*100 >AK10:" ......... >AJ10:" .......... >AI10:/F$(((AH10/AI6)*365)/AG10)*100 >AH10:" ......... >AG10:" .......... >AF10:/F$(((AE10/AF6)*365)/AD10)*100 >AE10:" >A51:+A50+1 >AL34:/F$(((AL10*AJ10)+(AL14*AJ14)+(AL18*AJ18)+(AL22*AJ22)+(AL26*AJ26)+(AL32*AJ32))/AJ34) >AK34:+AK30+AK32 >AJ34:+AJ30+AJ32 >AI34:/F$(((AI10*AG10)+(AI14*AG14)+(AI18*AG18)+(AI22*AG22)+(AI26*AG26)+(AI32*AG32))/AG34) >AH34:+AH30+AH32 >AG34:+AG30+AA1+1 >D1:"N YIELDS >C1:"MMERCIAL LOA >B1:"MODEL 1 - CO >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: U >T2:" T >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+1 >AL2:" AL >AK2:" AK >AJ2:" AJ >AI2:" AI >AH2:" AH >AG2:" AG >AF2:" AF >AE2:" AE >AD2:" AD >AC2:" AC >AB2:" AB >AA2:" AA >Z2:" Z >Y2:" Y >X2:" X >W2:" W >V2:" V >U2:" :" JUL >T3:" JUN >S3:" JUN >R3:" JUN >Q3:" MAY >P3:" MAY >O3:" MAY >N3:" APR >M3:" APR >L3:" APR >K3:" MAR >J3:" MAR >I3:" MAR >H3:" FEB >G3:" FEB >F3:" FEB >E3:" JAN >D3:" JAN >C3:" JAN >A3:+A2+VG MO BAL >A4:+A3+1 >AL3:" DEC >AK3:" DEC >AJ3:" DEC >AI3:" NOV >AH3:" NOV >AG3:" NOV >AF3:" OCT >AE3:" OCT >AD3:" OCT >AC3:" SEP >AB3:" SEP >AA3:" SEP >Z3:" AUG >Y3:" AUG >X3:" AUG >W3:" JUL >V3:" JUL >U3ELD >S4:" INCOME >R4:" AVG MO BAL >Q4:" YIELD >P4:" INCOME >O4:" AVG MO BAL >N4:" YIELD >M4:" INCOME >L4:" AVG MO BAL >K4:" YIELD >J4:" INCOME >I4:" AVG MO BAL >H4:" YIELD >G4:" INCOME >F4:" AVG MO BAL >E4:" YIELD >D4:" INCOME >C4:" AMO BAL >AI4:" YIELD >AH4:" INCOME >AG4:" AVG MO BAL >AF4:" YIELD >AE4:" INCOME >AD4:" AVG MO BAL >AC4:" YIELD >AB4:" INCOME >AA4:" AVG MO BAL >Z4:" YIELD >Y4:" INCOME >X4:" AVG MO BAL >W4:" YIELD >V4:" INCOME >U4:" AVG MO BAL >T4:" YI" >R6:" >Q6:" ........ >P6:" >O6:" >N6:" ........ >M6:" >L6:" >K6:" ........ >J6:" >I6:" >H6:" ........ >G6:" >F6:" >E6:" ........ >D6:" >C6:" >B6:"DAYS PER MTH >A6:+A5+1 >A5:+A4+1 >AL4:" YIELD >AK4:" INCOME >AJ4:" AVG 8+1 >A8:+A7+1 >A7:+A6+1 >AL6:" ........ >AK6:" >AJ6:" >AI6:" ........ >AH6:" >AG6:" >AF6:" ........ >AE6:" >AD6:" >AC6:" ........ >AB6:" >AA6:" >Z6:" ........ >Y6:" >X6:" >W6:" ........ >V6:" >U6:" >T6:" ........ >S6:AE9:" >AD9:" >AC9:/F$" >AB9:" >AA9:" >Z9:/F$" >Y9:" >X9:" >W9:/F$" >V9:" >U9:" >T9:/F$" >S9:" >R9:" >Q9:/F$" >P9:" >O9:" >N9:/F$" >M9:" >L9:" >K9:/F$" >J9:" >I9:" >H9:/F$" >G9:" >F9:" >E9:/F$" >D9:" >C9:" >B9:"COMM LOANS >A9:+A. >I10:" .......... >H10:/F$(((G10/H6)*365)/F10)*100 >G10:" ......... >F10:" .......... >E10:/F$(((D10/E6)*365)/C10)*100 >D10:" ......... >C10:" .......... >B10:" SECURED >A10:+A9+1 >AL9:/F$" >AK9:" >AJ9:" >AI9:/F$" >AH9:" >AG9:" >AF9:/F$" >$(((S10/T6)*365)/R10)*100 >S10:" ......... >R10:" .......... >Q10:/F$(((P10/Q6)*365)/O10)*100 >P10:" ......... >O10:" .......... >N10:/F$(((M10/N6)*365)/L10)*100 >M10:" ......... >L10:" .......... >K10:/F$(((J10/K6)*365)/I10)*100 >J10:" ................. >AD10:" .......... >AC10:/F$(((AB10/AC6)*365)/AA10)*100 >AB10:" ......... >AA10:" .......... >Z10:/F$(((Y10/Z6)*365)/X10)*100 >Y10:" ......... >X10:" .......... >W10:/F$(((V10/W6)*365)/U10)*100 >V10:" ......... >U10:" .......... >T10:/FG32 >AF34:/F$(((AF10*AD10)+(AF14*AD14)+(AF18*AD18)+(AF22*AD22)+(AF26*AD26)+(AF32*AD32))/AD34) >AE34:+AE30+AE32 >AD34:+AD30+AD32 >AC34:/F$(((AC10*AA10)+(AC14*AA14)+(AC18*AA18)+(AC22*AA22)+(AC26*AA26)+(AC32*AA32))/AA34) >AB34:+AB30+AB32 >AA34:+AA30+AA32 >Z34!"#$%&'()*+,-./0123456789:18)+(E22*C22)+(E26*C26))/C30) >D30:+D10+D14+D18+D22+D26 >C30:+C28-C29 >B30:"SUB NET IL >A30:+A29+1 >AJ29:+AJ9+AJ13+AJ17+AJ21+AJ25 >AG29:+AG9+AG13+AG17+AG21+AG25 >AD29:+AD9+AD13+AD17+AD21+AD25 >AA29:+AA9+AA13+AA17+AA21+AA25 >X29:+X9+X13+X17+X21+X25 >U29:+U9L28-L29 >K30:/F$(((K10*I10)+(K14*I14)+(K18*I18)+(K22*I22)+(K26*I26))/I30) >J30:+J10+J14+J18+J22+J26 >I30:+I28-I29 >H30:/F$(((H10*F10)+(H14*F14)+(H18*F18)+(H22*F22)+(H26*F26))/F30) >G30:+G10+G14+G18+G22+G26 >F30:+F28-F29 >E30:/F$(((E10*C10)+(E14*C14)+(E18*C*R26))/R30) >S30:+S10+S14+S18+S22+S26 >R30:+R28-R29 >Q30:/F$(((Q10*O10)+(Q14*O14)+(Q18*O18)+(Q22*O22)+(Q26*O26))/O30) >P30:+P10+P14+P18+P22+P26 >O30:+O28-O29 >N30:/F$(((N10*L10)+(N14*L14)+(N18*L18)+(N22*L22)+(N26*L26))/L30) >M30:+M10+M14+M18+M22+M26 >L30:+(Z10*X10)+(Z14*X14)+(Z18*X18)+(Z22*X22)+(Z26*X26))/X30) >Y30:+Y10+Y14+Y18+Y22+Y26 >X30:+X28-X29 >W30:/F$(((W10*U10)+(W14*U14)+(W18*U18)+(W22*U22)+(W26*U26))/U30) >V30:+V10+V14+V18+V22+V26 >U30:+U28-U29 >T30:/F$(((T10*R10)+(T14*R14)+(T18*R18)+(T22*R22)+(T26$(((AF10*AD10)+(AF14*AD14)+(AF18*AD18)+(AF22*AD22)+(AF26*AD26))/AD30) >AE30:+AE10+AE14+AE18+AE22+AE26 >AD30:+AD28-AD29 >AC30:/F$(((AC10*AA10)+(AC14*AA14)+(AC18*AA18)+(AC22*AA22)+(AC26*AA26))/AA30) >AB30:+AB10+AB14+AB18+AB22+AB26 >AA30:+AA28-AA29 >Z30:/F$((/F$(((AL10*AJ10)+(AL14*AJ14)+(AL18*AJ18)+(AL22*AJ22)+(AL26*AJ26))/AJ30) >AK30:+AK10+AK14+AK18+AK22+AK26 >AJ30:+AJ28-AJ29 >AI30:/F$(((AI10*AG10)+(AI14*AG14)+(AI18*AG18)+(AI22*AG22)+(AI26*AG26))/AG30) >AH30:+AH10+AH14+AH18+AH22+AH26 >AG30:+AG28-AG29 >AF30:/F2:/F$(((J32/K6)*365)/I32)*100 >J32:" ......... >I32:" ......... >H32:/F$(((G32/H6)*365)/F32)*100 >G32:" ......... >F32:" ......... >E32:/F$(((D32/E6)*365)/C32)*100 >D32:" ......... >C32:" ......... >B32:" STUDENT >A32:+A31+1 >A31:+A30+1 >AL30:0 >V32:" ......... >U32:" ......... >T32:/F$(((S32/T6)*365)/R32)*100 >S32:" ......... >R32:" ......... >Q32:/F$(((P32/Q6)*365)/O32)*100 >P32:" ......... >O32:" ......... >N32:/F$(((M32/N6)*365)/L32)*100 >M32:" ......... >L32:" ......... >K3>AF32:/F$(((AE32/AF6)*365)/AD32)*100 >AE32:" ......... >AD32:" ......... >AC32:/F$(((AB32/AC6)*365)/AA32)*100 >AB32:" ......... >AA32:" ......... >Z32:/F$(((Y32/Z6)*365)/X32)*100 >Y32:" ......... >X32:" ......... >W32:/F$(((V32/W6)*365)/U32)*10*C22)+(E26*C26)+(E32*C32))/C34) >D34:+D30+D32 >C34:+C30+C32 >B34:"TOT INST LN >A34:+A33+1 >A33:+A32+1 >AL32:/F$(((AK32/AL6)*365)/AJ32)*100 >AK32:" ......... >AJ32:" ......... >AI32:/F$(((AH32/AI6)*365)/AG32)*100 >AH32:" ......... >AG32:" ......... L32 >K34:/F$(((K10*I10)+(K14*I14)+(K18*I18)+(K22*I22)+(K26*I26)+(K32*I32))/I34) >J34:+J30+J32 >I34:+I30+I32 >H34:/F$(((H10*F10)+(H14*F14)+(H18*F18)+(H22*F22)+(H26*F26)+(H32*F32))/F34) >G34:+G30+G32 >F34:+F30+F32 >E34:/F$(((E10*C10)+(E14*C14)+(E18*C18)+(E2226*R26)+(T32*R32))/R34) >S34:+S30+S32 >R34:+R30+R32 >Q34:/F$(((Q10*O10)+(Q14*O14)+(Q18*O18)+(Q22*O22)+(Q26*O26)+(Q32*O32))/O34) >P34:+P30+P32 >O34:+O30+O32 >N34:/F$(((N10*L10)+(N14*L14)+(N18*L18)+(N22*L22)+(N26*L26)+(N32*L32))/L34) >M34:+M30+M32 >L34:+L30+:/F$(((Z10*X10)+(Z14*X14)+(Z18*X18)+(Z22*X22)+(Z26*X26)+(Z32*X32))/X34) >Y34:+Y30+Y32 >X34:+X30+X32 >W34:/F$(((W10*U10)+(W14*U14)+(W18*U18)+(W22*U22)+(W26*U26)+(W32*U32))/U34) >V34:+V30+V32 >U34:+U30+U32 >T34:/F$(((T10*R10)+(T14*R14)+(T18*R18)+(T22*R22)+(T+U13+U17+U21+U25 >R29:+R9+R13+R17+R21+R25 >O29:+O9+O13+O17+O21+O25 >L29:+L9+L13+L17+L21+L25 >I29:+I9+I13+I17+I21+I25 >F29:+F9+F13+F17+F21+F25 >C29:+C9+C13+C17+C21+C25 >B29:"SUBTOT UNERN >A29:+A28+1 >AJ28:+AJ8+AJ12+AJ16+AJ20+AJ24 >AG28:+AG8+AG12+AG16+AG20+AG24 >AD28:+AD8+AD12+AD16+AD20+AD24 >AA28:+AA8+AA12+AA16+AA20+AA24 >X28:+X8+X12+X16+X20+X24 >U28:+U8+U12+U16+U20+U24 >R28:+R8+R12+R16+R20+R24 >O28:+O8+O12+O16+O20+O24 >L28:+L8+L12+L16+L20+L24 >I28:+I8+I12+I16+I20+I24 >F28:+F8+F12+F16+F20+F24 >C28:+C8+C12+C1>E18:/F$((D18*12)/C18)*100 >D18:+D16+D17 >C18:+C16-C17 >B18:" SUB PER >A18:+A17+1 >AK17:" ......... >AJ17:" ......... >AH17:" ......... >AG17:" ......... >AE17:" ......... >AD17:" ......... >AB17:" ......... >AA17:" ......... >Y17:" ....18)*100 >S18:+S16+S17 >R18:+R16-R17 >Q18:/F$((P18*12)/O18)*100 >P18:+P16+P17 >O18:+O16-O17 >N18:/F$((M18*12)/L18)*100 >M18:+M16+M17 >L18:+L16-L17 >K18:/F$((J18*12)/I18)*100 >J18:+J16+J17 >I18:+I16-I17 >H18:/F$((G18*12)/F18)*100 >G18:+G16+G17 >F18:+F16-F17 AF18:/F$((AE18*12)/AD18)*100 >AE18:+AE16+AE17 >AD18:+AD16-AD17 >AC18:/F$((AB18*12)/AA18)*100 >AB18:+AB16+AB17 >AA18:+AA16-AA17 >Z18:/F$((Y18*12)/X18)*100 >Y18:+Y16+Y17 >X18:+X16-X17 >W18:/F$((V18*12)/U18)*100 >V18:+V16+V17 >U18:+U16-U17 >T18:/F$((S18*12)/R ......... >L20:" ......... >I20:" ......... >F20:" ......... >C20:" ......... >B20:" COM IL >A20:+A19+1 >A19:+A18+1 >AL18:/F$((AK18*12)/AJ18)*100 >AK18:+AK16+AK17 >AJ18:+AJ16-AJ17 >AI18:/F$((AH18*12)/AG18)*100 >AH18:+AH16+AH17 >AG18:+AG16-AG17 >. >L21:" .......... >I21:" .......... >F21:" .......... >C21:" .......... >B21:" UNEARNED >A21:+A20+1 >AJ20:" ......... >AG20:" ......... >AD20:" ......... >AA20:" ......... >X20:" ......... >U20:" ......... >R20:" ......... >O20:" 21 >E22:/F$((D22*12)/C22)*100 >D22:" ......... >C22:+C20-C21 >B22:" SUB COM IL >A22:+A21+1 >AJ21:" .......... >AG21:" .......... >AD21:" .......... >AA21:" .......... >X21:" .......... >U21:" .......... >R21:" .......... >O21:" ............. >R22:+R20-R21 >Q22:/F$((P22*12)/O22)*100 >P22:" ......... >O22:+O20-O21 >N22:/F$((M22*12)/L22)*100 >M22:" ......... >L22:+L20-L21 >K22:/F$((J22*12)/I22)*100 >J22:" ......... >I22:+I20-I21 >H22:/F$((G22*12)/F22)*100 >G22:" ......... >F22:+F20-F ......... >AD22:+AD20-AD21 >AC22:/F$((AB22*12)/AA22)*100 >AB22:" ......... >AA22:+AA20-AA21 >Z22:/F$((Y22*12)/X22)*100 >Y22:" ......... >X22:+X20-X21 >W22:/F$((V22*12)/U22)*100 >V22:" ......... >U22:+U20-U21 >T22:/F$((S22*12)/R22)*100 >S22:" ........ >F24:" ......... >C24:" ......... >B24:" DISCOUNT >A24:+A23+1 >A23:+A22+1 >AL22:/F$((AK22*12)/AJ22)*100 >AK22:" ......... >AJ22:+AJ20-AJ21 >AI22:/F$((AH22*12)/AG22)*100 >AH22:" ......... >AG22:+AG20-AG21 >AF22:/F$((AE22*12)/AD22)*100 >AE22:" 25:" ......... >C25:" ......... >B25:" UNEARNED >A25:+A24+1 >AJ24:" ......... >AG24:" ......... >AD24:" ......... >AA24:" ......... >X24:" ......... >U24:" ......... >R24:" ......... >O24:" ......... >L24:" ......... >I24:" ......D26:" ......... >C26:+C24-C25 >B26:" SUB DIS >A26:+A25+1 >AJ25:" ......... >AG25:" ......... >AD25:" ......... >AA25:" ......... >X25:" ......... >U25:" ......... >R25:" ......... >O25:" ......... >L25:" ......... >I25:" ......... >F6*12)/O26)*100 >P26:" ......... >O26:+O24-O25 >N26:/F$((M26*12)/L26)*100 >M26:" ......... >L26:+L24-L25 >K26:/F$((J26*12)/I26)*100 >J26:" ......... >I26:+I24-I25 >H26:/F$((G26*12)/F26)*100 >G26:" ......... >F26:+F24-F25 >E26:/F$((D26*12)/C26)*100 >26:/F$((AB26*12)/AA26)*100 >AB26:" ......... >AA26:+AA24-AA25 >Z26:/F$((Y26*12)/X26)*100 >Y26:" ......... >X26:+X24-X25 >W26:/F$((V26*12)/U26)*100 >V26:" ......... >U26:+U24-U25 >T26:/F$((S26*12)/R26)*100 >S26:" ......... >R26:+R24-R25 >Q26:/F$((P26+C20+C24 >B28:"SUBTOT PRIN >A28:+A27+1 >A27:+A26+1 >AL26:/F$((AK26*12)/AJ26)*100 >AK26:" ......... >AJ26:+AJ24-AJ25 >AI26:/F$((AH26*12)/AG26)*100 >AH26:" ......... >AG26:+AG24-AG25 >AF26:/F$((AE26*12)/AD26)*100 >AE26:" ......... >AD26:+AD24-AD25 >AC..... >X17:" ......... >V17:" ......... >U17:" ......... >S17:" ......... >R17:" ......... >P17:" ......... >O17:" ......... >M17:" ......... >L17:" ......... >J17:" ......... >I17:" ......... >G17:" ......... >F17:" ......... >D17:" ......... >C17:" ......... >B17:" UNEARNED >A17:+A16+1 >AK16:" ......... >AJ16:" .......... >AH16:" ......... >AG16:" .......... >AE16:" ......... >AD16:" .......... >AB16:" ......... >AA16:" .......... >Y16:" ......... >X16:" +1 >A5:+A4+1 >AL4:" YIELD >AK4:" INCOME >AJ4:" AVG MO BAL >AI4:" YIELD >AH4:" INCOME >AG4:" AVG MO BAL >AF4:" YIELD >AE4:" INCOME >AD4:" AVG MO BAL >AC4:" YIELD >AB4:" INCOME >AA4:" AVG MO BAL >Z4:" YIELD >Y4:" INCOME >X4:" AVG MO BAL >>W6:" ......... >V6:" >U6:" >T6:" ......... >S6:" >R6:" >Q6:" ......... >P6:" >O6:" >N6:" ......... >M6:" >L6:" >K6:" ......... >J6:" >I6:" >H6:" ......... >G6:" >F6:" >E6:" ......... >D6:" >C6:" >B6:"DAYS PER MTH >A6:+A5 ......... >F8:" ......... >C8:" ......... >B8:" AUTO >A8:+A7+1 >A7:+A6+1 >AL6:" ......... >AK6:" >AJ6:" >AI6:" ......... >AH6:" >AG6:" >AF6:" ......... >AE6:" >AD6:" >AC6:" ......... >AB6:" >AA6:" >Z6:" ......... >Y6:" >X6:" . >I9:" ......... >F9:" ......... >C9:" ......... >B9:" UNEARNED >A9:+A8+1 >AJ8:" ......... >AG8:" ......... >AD8:" ......... >AA8:" ......... >X8:" ......... >U8:" ......... >R8:" ......... >O8:" ......... >L8:" ......... >I8:" F8-F9 >E10:/F$((D10*12)/C10)*100 >D10:" ......... >C10:+C8-C9 >B10:" SUB AUTO >A10:+A9+1 >AJ9:" ......... >AG9:" ......... >AD9:" ......... >AA9:" ......... >X9:" ......... >U9:" ......... >R9:" ......... >O9:" ......... >L9:" ........S10:" ......... >R10:+R8-R9 >Q10:/F$((P10*12)/O10)*100 >P10:" ......... >O10:+O8-O9 >N10:/F$((M10*12)/L10)*100 >M10:" ......... >L10:+L8-L9 >K10:/F$((J10*12)/I10)*100 >J10:" ......... >I10:+I8-I9 >H10:/F$((G10*12)/F10)*100 >G10:" ......... >F10:+)/AD10)*100 >AE10:" ......... >AD10:+AD8-AD9 >AC10:/F$((AB10*12)/AA10)*100 >AB10:" ......... >AA10:+AA8-AA9 >Z10:/F$((Y10*12)/X10)*100 >Y10:" ......... >X10:+X8-X9 >W10:/F$((V10*12)/U10)*100 >V10:" ......... >U10:+U8-U9 >T10:/F$((S10*12)/R10)*100 > .......... >I12:" .......... >F12:" .......... >C12:" .......... >B12:" FHA >A12:+A11+1 >A11:+A10+1 >AL10:/F$((AK10*12)/AJ10)*100 >AK10:" ......... >AJ10:+AJ8-AJ9 >AI10:/F$((AH10*12)/AG10)*100 >AH10:" ......... >AG10:+AG8-AG9 >AF10:/F$((AE10*123:" ......... >F13:" ......... >C13:" ......... >B13:" UNEARNED >A13:+A12+1 >AJ12:" .......... >AG12:" .......... >AD12:" .......... >AA12:" .......... >X12:" .......... >U12:" .......... >R12:" .......... >O12:" .......... >L12:" D14*12)/C14)*100 >D14:" ......... >C14:+C12-C13 >B14:" SUB FHA >A14:+A13+1 >AJ13:" ......... >AG13:" ......... >AD13:" ......... >AA13:" ......... >X13:" ......... >U13:" ......... >R13:" ......... >O13:" ......... >L13:" ......... >I12-R13 >Q14:/F$((P14*12)/O14)*100 >P14:" ......... >O14:+O12-O13 >N14:/F$((M14*12)/L14)*100 >M14:" ......... >L14:+L12-L13 >K14:/F$((J14*12)/I14)*100 >J14:" ......... >I14:+I12-I13 >H14:/F$((G14*12)/F14)*100 >G14:" ......... >F14:+F12-F13 >E14:/F$((D14:+AD12-AD13 >AC14:/F$((AB14*12)/AA14)*100 >AB14:" ......... >AA14:+AA12-AA13 >Z14:/F$((Y14*12)/X14)*100 >Y14:" ......... >X14:+X12-X13 >W14:/F$((V14*12)/U14)*100 >V14:" ......... >U14:+U12-U13 >T14:/F$((S14*12)/R14)*100 >S14:" ......... >R14:+R1........ >C16:" .......... >B16:" PERSONAL >A16:+A15+1 >A15:+A14+1 >AL14:/F$((AK14*12)/AJ14)*100 >AK14:" ......... >AJ14:+AJ12-AJ13 >AI14:/F$((AH14*12)/AG14)*100 >AH14:" ......... >AG14:+AG12-AG13 >AF14:/F$((AE14*12)/AD14)*100 >AE14:" ......... >A .......... >V16:" ......... >U16:" .......... >S16:" ......... >R16:" .......... >P16:" ......... >O16:" .......... >M16:" ......... >L16:" .......... >J16:" ......... >I16:" .......... >G16:" ......... >F16:" .......... >D16:" .W4:" YIELD >V4:" INCOME >U4:" AVG MO BAL >T4:" YIELD >S4:" INCOME >R4:" AVG MO BAL >Q4:" YIELD >P4:" INCOME >O4:" AVG MO BAL >N4:" YIELD >M4:" INCOME >L4:" AVG MO BAL >K4:" YIELD >J4:" INCOME >I4:" AVG MO BAL >H4:" YIELD >G4:" INCOME >F4:" AVG MO BAL >E4:" YIELD >D4:" INCOME >C4:" AVG MO BAL >A4:+A3+1 >AL3:" DEC >AK3:" DEC >AJ3:" DEC >AI3:" NOV >AH3:" NOV >AG3:" NOV >AF3:" OCT >AE3:" OCT >AD3:" OCT >AC3:" SEP >AB3:" SEP >AA3:" SEP >Z3:" AUG ..... >Q12:/F$(((P12*12)/O12)*100 >P12:" ......... >O12:" ......... >N12:/F$(((M12*12)/L12)*100 >M12:" ......... >L12:" ......... >K12:/F$(((J12*12)/I12)*100 >J12:" ......... >I12:" ......... >H12:/F$(((G12*12)/F12)*100 >G12:" ......... >F12:F$(((AB12*12)/AA12)*100 >AB12:" ......... >AA12:" ......... >Z12:/F$(((Y12*12)/X12)*100 >Y12:" ......... >X12:" ......... >W12:/F$(((V12*12)/U12)*100 >V12:" ......... >U12:" ......... >T12:/F$(((S12*12)/R12)*100 >S12:" ......... >R12:" ....GRAND TOTAL >A14:+A13+1 >A13:+A12+1 >AL12:/F$(((AK12*12)/AJ12)*100 >AK12:" ......... >AJ12:" ......... >AI12:/F$(((AH12*12)/AG12)*100 >AH12:" ......... >AG12:" ......... >AF12:/F$(((AE12*12)/AD12)*100 >AE12:" ......... >AD12:" ......... >AC12:/L14:+L8+L10+L12 >K14:/F$(((K8*I8)+(K10*I10)+(K12*I12))/I14) >J14:+J8+J10+J12 >I14:+I8+I10+I12 >H14:/F$(((H8*F8)+(H10*F10)+(H12*F12))/F14) >G14:+G8+G10+G12 >F14:+F8+F10+F12 >E14:/F$(((E8*C8)+(E10*C10)+(E12*C12))/C14) >D14:+D8+D10+D12 >C14:+C8+C10+C12 >B14:"14) >V14:+V8+V10+V12 >U14:+U8+U10+U12 >T14:/F$(((T8*R8)+(T10*R10)+(T12*R12))/R14) >S14:+S8+S10+S12 >R14:+R8+R10+R12 >Q14:/F$(((Q8*O8)+(Q10*O10)+(Q12*O12))/O14) >P14:+P8+P10+P12 >O14:+O8+O10+O12 >N14:/F$(((N8*L8)+(N10*L10)+(N12*L12))/L14) >M14:+M8+M10+M12 >;=>?@ABCDEF) >AE14:+AE8+AE10+AE12 >AD14:+AD8+AD10+AD12 >AC14:/F$(((AC8*AA8)+(AC10*AA10)+(AC12*AA12))/AA14) >AB14:+AB8+AB10+AB12 >AA14:+AA8+AA10+AA12 >Z14:/F$(((Z8*X8)+(Z10*X10)+(Z12*X12))/X14) >Y14:+Y8+Y10+Y12 >X14:+X8+X10+X12 >W14:/F$(((W8*U8)+(W10*U10)+(W12*U12))/U>H34:/F$ >H32:/F$ >AL14:/F$(((AL8*AJ8)+(AL10*AJ10)+(AL12*AJ12))/AJ14) >AK14:+AK8+AK10+AK12 >AJ14:+AJ8+AJ10+AJ12 >AI14:/F$(((AI8*AG8)+(AI10*AG10)+(AI12*AG12))/AG14) >AH14:+AH8+AH10+AH12 >AG14:+AG8+AG10+AG12 >AF14:/F$(((AF8*AD8)+(AF10*AD10)+(AF12*AD12))/AD142:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >D1:" YIELDS >C1:"ALLMENT LOAN >B1:"MODEL 2 INST >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: Y >X2:" X >W2:" W >V2:" V >U2:" U >T2:" T >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E FEB >E3:" JAN >D3:" JAN >C3:" JAN >A3:+A2+1 >AL2:" AL >AK2:" AK >AJ2:" AJ >AI2:" AI >AH2:" AH >AG2:" AG >AF2:" AF >AE2:" AE >AD2:" AD >AC2:" AC >AB2:" AB >AA2:" AA >Z2:" Z >Y2:" >Y3:" AUG >X3:" AUG >W3:" JUL >V3:" JUL >U3:" JUL >T3:" JUN >S3:" JUN >R3:" JUN >Q3:" MAY >P3:" MAY >O3:" MAY >N3:" APR >M3:" APR >L3:" APR >K3:" MAR >J3:" MAR >I3:" MAR >H3:" FEB >G3:" FEB >F3:" " ......... >E12:/F$(((D12*12)/C12)*100 >D12:" ......... >C12:" ......... >B12:"U S GOVT >A12:+A11+1 >A11:+A10+1 >AL10:/F$(((AK10*12)/AJ10)*100 >AK10:" ......... >AJ10:" ......... >AI10:/F$(((AH10*12)/AG10)*100 >AH10:" ......... >AG10:" ......... >AF10:/F$(((AE10*12)/AD10)*100 >AE10:" ......... >AD10:" ......... >AC10:/F$(((AB10*12)/AA10)*100 >AB10:" ......... >AA10:" ......... >Z10:/F$(((Y10*12)/X10)*100 >Y10:" ......... >X10:" ......... >W10:/F$(((V10*12)/U10)*100 >V10:" ......>H34:/F$ >H32:/F$ >AL12:/F$(((AL8*AJ8)+(AL10*AJ10))/AJ12) >AK12:+AK10+AK8 >AJ12:+AJ10+AJ8 >AI12:/F$(((AI8*AG8)+(AI10*AG10))/AG12) >AH12:+AH10+AH8 >AG12:+AG10+AG8 >AF12:/F$(((AF8*AD8)+(AF10*AD10))/AD12) >AE12:+AE10+AE8 >AD12:+AD10+AD8 >AC12:/F$(((AC8*AA8)+( RE >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >D1:"AN YIELDS >C1:"AL ESTATE LO >B1:"MODEL 3 -" AI >AH2:" AH >AG2:" AG >AF2:" AF >AE2:" AE >AD2:" AD >AC2:" AC >AB2:" AB >AA2:" AA >Z2:" Z >Y2:" Y >X2:" X >W2:" W >V2:" V >U2:" U >T2:" T >S2:" S >R2:" R >Q2:" :" MAY >P3:" MAY >O3:" MAY >N3:" APR >M3:" APR >L3:" APR >K3:" MAR >J3:" MAR >I3:" MAR >H3:" FEB >G3:" FEB >F3:" FEB >E3:" JAN >D3:" JAN >C3:" JAN >A3:+A2+1 >AL2:" AL >AK2:" AK >AJ2:" AJ >AI2::" DEC >AI3:" NOV >AH3:" NOV >AG3:" NOV >AF3:" OCT >AE3:" OCT >AD3:" OCT >AC3:" SEP >AB3:" SEP >AA3:" SEP >Z3:" AUG >Y3:" AUG >X3:" AUG >W3:" JUL >V3:" JUL >U3:" JUL >T3:" JUN >S3:" JUN >R3:" JUN >Q34:" INCOME >O4:" AVG MO BAL >N4:" YIELD >M4:" INCOME >L4:" AVG MO BAL >K4:" YIELD >J4:" INCOME >I4:" AVG MO BAL >H4:" YIELD >G4:" INCOME >F4:" AVG MO BAL >E4:" YIELD >D4:" INCOME >C4:" AVG MO BAL >A4:+A3+1 >AL3:" DEC >AK3:" DEC >AJ3BAL >AF4:" YIELD >AE4:" INCOME >AD4:" AVG MO BAL >AC4:" YIELD >AB4:" INCOME >AA4:" AVG MO BAL >Z4:" YIELD >Y4:" INCOME >X4:" AVG MO BAL >W4:" YIELD >V4:" INCOME >U4:" AVG MO BAL >T4:" YIELD >S4:" INCOME >R4:" AVG MO BAL >Q4:" YIELD >PE6:" >AD6:" >AB6:" >AA6:" >Y6:" >X6:" >V6:" >U6:" >S6:" >R6:" >P6:" >O6:" >M6:" >L6:" >J6:" >I6:" >G6:" >F6:" >D6:" >C6:" >A6:+A5+1 >A5:+A4+1 >AL4:" YIELD >AK4:" INCOME >AJ4:" AVG MO BAL >AI4:" YIELD >AH4:" INCOME >AG4:" AVG MO . >K8:/F$(((J8*12)/I8)*100 >J8:" ......... >I8:" ......... >H8:/F$(((G8*12)/F8)*100 >G8:" ......... >F8:" ......... >E8:/F$(((D8*12)/C8)*100 >D8:" ......... >C8:" ......... >B8:"RESIDENTIAL >A8:+A7+1 >A7:+A6+1 >AK6:" >AJ6:" >AH6:" >AG6:" >A" ......... >W8:/F$(((V8*12)/U8)*100 >V8:" ......... >U8:" ......... >T8:/F$(((S8*12)/R8)*100 >S8:" ......... >R8:" ......... >Q8:/F$(((P8*12)/O8)*100 >P8:" ......... >O8:" ......... >N8:/F$(((M8*12)/L8)*100 >M8:" ......... >L8:" ........ ......... >AI8:/F$(((AH8*12)/AG8)*100 >AH8:" ......... >AG8:" ......... >AF8:/F$(((AE8*12)/AD8)*100 >AE8:" ......... >AD8:" ......... >AC8:/F$(((AB8*12)/AA8)*100 >AB8:" ......... >AA8:" ......... >Z8:/F$(((Y8*12)/X8)*100 >Y8:" ......... >X8: ......... >I10:" ......... >H10:/F$(((G10*12)/F10)*100 >G10:" ......... >F10:" ......... >E10:/F$(((D10*12)/C10)*100 >D10:" ......... >C10:" ......... >B10:"COMMERCIAL >A10:+A9+1 >A9:+A8+1 >AL8:/F$(((AK8*12)/AJ8)*100 >AK8:" ......... >AJ8:" ... >U10:" ......... >T10:/F$(((S10*12)/R10)*100 >S10:" ......... >R10:" ......... >Q10:/F$(((P10*12)/O10)*100 >P10:" ......... >O10:" ......... >N10:/F$(((M10*12)/L10)*100 >M10:" ......... >L10:" ......... >K10:/F$(((J10*12)/I10)*100 >J10:" AC10*AA10))/AA12) >AB12:+AB10+AB8 >AA12:+AA10+AA8 >Z12:/F$(((Z8*X8)+(Z10*X10))/X12) >Y12:+Y10+Y8 >X12:+X10+X8 >W12:/F$(((W8*U8)+(W10*U10))/U12) >V12:+V10+V8 >U12:+U10+U8 >T12:/F$(((T8*R8)+(T10*R10))/R12) >S12:+S10+S8 >R12:+R10+R8 >Q12:/F$(((Q8*O8)+(Q10*O10GIJKLMNOPQME >C4:" AVG MO BAL >A4:+A3+1 >AL3:" DEC >AK3:" DEC >AJ3:" DEC >AI3:" NOV >AH3:" NOV >AG3:" NOV >AF3:" OCT >AE3:" OCT >AD3:" OCT >AC3:" SEP >AB3:" SEP >AA3:" SEP >Z3:" AUG >Y3:" AUG >X3:" AUG >W3:" JUL >V3:" >T4:" YIELD >S4:" INCOME >R4:" AVG MO BAL >Q4:" YIELD >P4:" INCOME >O4:" AVG MO BAL >N4:" YIELD >M4:" INCOME >L4:" AVG MO BAL >K4:" YIELD >J4:" INCOME >I4:" AVG MO BAL >H4:" YIELD >G4:" INCOME >F4:" AVG MO BAL >E4:" YIELD >D4:" INCOAJ4:" AVG MO BAL >AI4:" YIELD >AH4:" INCOME >AG4:" AVG MO BAL >AF4:" YIELD >AE4:" INCOME >AD4:" AVG MO BAL >AC4:" YIELD >AB4:" INCOME >AA4:" AVG MO BAL >Z4:" YIELD >Y4:" INCOME >X4:" AVG MO BAL >W4:" YIELD >V4:" INCOME >U4:" AVG MO BAL ......... >S6:" >R6:" >Q6:" ......... >P6:" >O6:" >N6:" ......... >M6:" >L6:" >K6:" ......... >J6:" >I6:" >H6:" ......... >G6:" >F6:" >E6:" ......... >D6:" >C6:" >B6:"DAYS PER MTH >A6:+A5+1 >A5:+A4+1 >AL4:" YIELD >AK4:" INCOME >........ >B8:"SEC PUR RES >A8:+A7+1 >A7:+A6+1 >AL6:" ......... >AK6:" >AJ6:" >AI6:" ......... >AH6:" >AG6:" >AF6:" ......... >AE6:" >AD6:" >AC6:" ......... >AB6:" >AA6:" >Z6:" ......... >Y6:" >X6:" >W6:" ......... >V6:" >U6:" >T6:" >N8:/F$(((M8/N4)*365)/L8)*100 >M8:" ......... >L8:" ......... >K8:/F$(((J8/K4)*365)/I8)*100 >J8:" ......... >I8:" ......... >H8:/F$(((G8/H4)*365)/F8)*100 >G8:" ......... >F8:" ......... >E8:/F$(((D8/E4)*365)/C8)*100 >D8:" ......... >C8:" .(((Y8/Z4)*365)/X8)*100 >Y8:" ......... >X8:" ......... >W8:/F$(((V8/W4)*365)/U8)*100 >V8:" ......... >U8:" ......... >T8:/F$(((S8/T4)*365)/R8)*100 >S8:" ......... >R8:" ......... >Q8:/F$(((P8/Q4)*365)/O8)*100 >P8:" ......... >O8:" ........." ......... >AJ8:" ......... >AI8:/F$(((AH8/AI4)*365)/AG8)*100 >AH8:" ......... >AG8:" ......... >AF8:/F$(((AE8/AF4)*365)/AD8)*100 >AE8:" ......... >AD8:" ......... >AC8:/F$(((AB8/AC4)*365)/AA8)*100 >AB8:" ......... >AA8:" ......... >Z8:/F$0:" .......... >I10:" ......... >H10:/F$(((G10/H6)*365)/F10)*100 >G10:" .......... >F10:" ......... >E10:/F$(((D10/E6)*365)/C10)*100 >D10:" .......... >C10:" ......... >B10:"FED FUNDS >A10:+A9+1 >A9:+A8+1 >AL8:/F$(((AK8/AL4)*365)/AJ8)*100 >AK8:... >T10:/F$(((S10/T6)*365)/R10)*100 >S10:" .......... >R10:" ......... >Q10:/F$(((P10/Q6)*365)/O10)*100 >P10:" .......... >O10:" ......... >N10:/F$(((M10/N6)*365)/L10)*100 >M10:" .......... >L10:" ......... >K10:/F$(((J10/K6)*365)/I10)*100 >J110:" .......... >AD10:" ......... >AC10:/F$(((AB10/AC6)*365)/AA10)*100 >AB10:" .......... >AA10:" ......... >Z10:/F$(((Y10/Z6)*365)/X10)*100 >Y10:" .......... >X10:" ......... >W10:/F$(((V10/W6)*365)/U10)*100 >V10:" .......... >U10:" ......0+D8 >C12:+C10+C8 >B12:"GRAND TOTAL >A12:+A11+1 >A11:+A10+1 >AL10:/F$(((AK10/AL6)*365)/AJ10)*100 >AK10:" .......... >AJ10:" ......... >AI10:/F$(((AH10/AI6)*365)/AG10)*100 >AH10:" .......... >AG10:" ......... >AF10:/F$(((AE10/AF6)*365)/AD10)*100 >AE))/O12) >P12:+P10+P8 >O12:+O10+O8 >N12:/F$(((N8*L8)+(N10*L10))/L12) >M12:+M10+M8 >L12:+L10+L8 >K12:/F$(((K8*I8)+(K10*I10))/I12) >J12:+J10+J8 >I12:+I10+I8 >H12:/F$(((H8*F8)+(H10*F10))/F12) >G12:+G10+G8 >F12:+F10+F8 >E12:/F$(((E8*C8)+(E10*C10))/C12) >D12:+D1 JUL >U3:" JUL >T3:" JUN >S3:" JUN >R3:" JUN >Q3:" MAY >P3:" MAY >O3:" MAY >N3:" APR >M3:" APR >L3:" APR >K3:" MAR >J3:" MAR >I3:" MAR >H3:" FEB >G3:" FEB >F3:" FEB >E3:" JAN >D3:" JAN >C3:" JAN >A3:+A2+1 >AL2:" AL >AK2:" AK >AJ2:" AJ >AI2:" AI >AH2:" AH >AG2:" AG >AF2:" AF >AE2:" AE >AD2:" AD >AC2:" AC >AB2:" AB >AA2:" AA >Z2:" Z >Y2:" Y >X2:" X >W2:" W >V2:" V >AK13:" ......... >AJ13:" ......... >AI13:/F$(((AH13*12)/.54)/AG13)*100 >AH13:" ......... >AG13:" ......... >AF13:/F$(((AE13*12)/.54)/AD13)*100 >AE13:" ......... >AD13:" ......... >AC13:/F$(((AB13*12)/.54)/AA13)*100 >AB13:" ......... >AA13:" >K14:/F$((J14*12)/I14)*100 >J14:" ......... >I14:" ......... >H14:/F$((G14*12)/F14)*100 >G14:" ......... >F14:" ......... >E14:/F$((D14*12)/C14)*100 >D14:" ......... >C14:" ......... >B14:" CORP >A14:+A13+1 >AL13:/F$(((AK13*12)/.54)/AJ13)*1004:/F$((V14*12)/U14)*100 >V14:" ......... >U14:" ......... >T14:/F$((S14*12)/R14)*100 >S14:" ......... >R14:" ......... >Q14:/F$((P14*12)/O14)*100 >P14:" ......... >O14:" ......... >N14:/F$((M14*12)/L14)*100 >M14:" ......... >L14:" .........14)*100 >AH14:" ......... >AG14:" ......... >AF14:/F$((AE14*12)/AD14)*100 >AE14:" ......... >AD14:" ......... >AC14:/F$((AB14*12)/AA14)*100 >AB14:" ......... >AA14:" ......... >Z14:/F$((Y14*12)/X14)*100 >Y14:" ......... >X14:" ......... >W116:+G11+G13+G14 >F16:+F11+F13+F14 >E16:/F$((E9*C9)+(E10*C10)+(E13*C13)+(E14*C14))/C16 >D16:+D11+D13+D14 >C16:+C11+C13+C14 >B16:"GRAND TOTAL >A16:+A15+1 >A15:+A14+1 >AL14:/F$((AK14*12)/AJ14)*100 >AK14:" ......... >AJ14:" ......... >AI14:/F$((AH14*12)/AGP13+P14 >O16:+O11+O13+O14 >N16:/F$((N9*L9)+(N10*L10)+(N13*L13)+(N14*L14))/L16 >M16:+M11+M13+M14 >L16:+L11+L13+L14 >K16:/F$((K9*I9)+(K10*I10)+(K13*I13)+(K14*I14))/I16 >J16:+J11+J13+J14 >I16:+I11+I13+I14 >H16:/F$((H9*F9)+(H10*F10)+(H13*F13)+(H14*F14))/F16 >G>X16:+X11+X13+X14 >W16:/F$((W9*U9)+(W10*U10)+(W13*U13)+(W14*U14))/U16 >V16:+V11+V13+V14 >U16:+U11+U13+U14 >T16:/F$((T9*R9)+(T10*R10)+(T13*R13)+(T14*R14))/R16 >S16:+S11+S13+S14 >R16:+R11+R13+R14 >Q16:/F$((Q9*O9)+(Q10*O10)+(Q13*O13)+(Q14*O14))/O16 >P16:+P11+RTUVWXYZ[\]^_`abAD10)+(AF13*AD13)+(AF14*AD14))/AD16 >AE16:+AE11+AE13+AE14 >AD16:+AD11+AD13+AD14 >AC16:/F$((AC9*AA9)+(AC10*AA10)+(AC13*AA13)+(AC14*AA14))/AA16 >AB16:+AB11+AB13+AB14 >AA16:+AA11+AA13+AA14 >Z16:/F$((Z9*X9)+(Z10*X10)+(Z13*X13)+(Z14*X14))/X16 >Y16:+Y11+Y13+Y14 >H34:/F$ >H32:/F$ >AL16:/F$((AL9*AJ9)+(AL10*AJ10)+(AL13*AJ13)+(AL14*AJ14))/AJ16 >AK16:+AK11+AK13+AK14 >AJ16:+AJ11+AJ13+AJ14 >AI16:/F$((AI9*AG9)+(AI10*AG10)+(AI13*AG13)+(AI14*AG14))/AG16 >AH16:+AH11+AH13+AH14 >AG16:+AG11+AG13+AG14 >AF16:/F$((AF9*AD9)+(AF10* B >A2:+A1+1 >D1:"IELDS >C1:"NEY MARKET Y >B1:"MODEL 4 - MO >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: >U2:" U >T2:" T >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" ......... >Z13:/F$(((Y13*12)/.54)/X13)*100 >Y13:" ......... >X13:" ......... >W13:/F$(((V13*12)/.54)/U13)*100 >V13:" ......... >U13:" ......... >T13:/F$(((S13*12)/.54)/R13)*100 >S13:" ......... >R13:" ......... >Q13:/F$(((P13*12)/.54)/O13)*100 >P13:" ......... >O13:" ......... >N13:/F$(((M13*12)/.54)/L13)*100 >M13:" ......... >L13:" ......... >K13:/F$(((J13*12)/.54)/I13)*100 >J13:" ......... >I13:" ......... >H13:/F$(((G13*12)/.54)/F13)*100 >G13:" ......... >F13:" ......... >E >AA6:" >Z6:" ......... >Y6:" >X6:" >W6:" ......... >V6:" >U6:" >T6:" ......... >S6:" >R6:" >Q6:" ......... >P6:" >O6:" >N6:" ......... >M6:" >L6:" >K6:" ......... >J6:" >I6:" >H6:" ......... >G6:" >F6:" >E6:" ......... >D6:":" >N8:/F$ >M8:" >L8:" >K8:/F$ >J8:" >I8:" >H8:/F$ >G8:" >F8:" >E8:/F$ >D8:" >C8:" >B8:"INV SEC >A8:+A7+1 >A7:+A6+1 >AL6:" ......... >AK6:" >AJ6:" >AI6:" ......... >AH6:" >AG6:" >AF6:" ......... >AE6:" >AD6:" >AC6:" ......... >AB6:" 65)/C9)*100 >D9:" ......... >C9:" ......... >B9:" US GOV >A9:+A8+1 >AL8:/F$ >AK8:" >AJ8:" >AI8:/F$ >AH8:" >AG8:" >AF8:/F$ >AE8:" >AD8:" >AC8:/F$ >AB8:" >AA8:" >Z8:/F$ >Y8:" >X8:" >W8:/F$ >V8:" >U8:" >T8:/F$ >S8:" >R8:" >Q8:/F$ >P8:" >O8100 >P9:" ......... >O9:" ......... >N9:/F$(((M9/N6)*365)/L9)*100 >M9:" ......... >L9:" ......... >K9:/F$(((J9/K6)*365)/I9)*100 >J9:" ......... >I9:" ......... >H9:/F$(((G9/H6)*365)/F9)*100 >G9:" ......... >F9:" ......... >E9:/F$(((D9/E6)*3 ......... >AA9:" ......... >Z9:/F$(((Y9/Z6)*365)/X9)*100 >Y9:" ......... >X9:" ......... >W9:/F$(((V9/W6)*365)/U9)*100 >V9:" ......... >U9:" ......... >T9:/F$(((S9/T6)*365)/R9)*100 >S9:" ......... >R9:" ......... >Q9:/F$(((P9/Q6)*365)/O9)*>AL9:/F$(((AK9/AL6)*365)/AJ9)*100 >AK9:" ......... >AJ9:" ......... >AI9:/F$(((AH9/AI6)*365)/AG9)*100 >AH9:" ......... >AG9:" ......... >AF9:/F$(((AE9/AF6)*365)/AD9)*100 >AE9:" ......... >AD9:" ......... >AC9:/F$(((AB9/AC6)*365)/AA9)*100 >AB9:" ......... >L10:" ......... >K10:/F$((J10*12)/I10)*100 >J10:" ......... >I10:" ......... >H10:/F$((G10*12)/F10)*100 >G10:" ......... >F10:" ......... >E10:/F$((D10*12)/C10)*100 >D10:" ......... >C10:" ......... >B10:" US AGENCY >A10:+A9+1 ........ >X10:" ......... >W10:/F$((V10*12)/U10)*100 >V10:" ......... >U10:" ......... >T10:/F$((S10*12)/R10)*100 >S10:" ......... >R10:" ......... >Q10:/F$((P10*12)/O10)*100 >P10:" ......... >O10:" ......... >N10:/F$((M10*12)/L10)*100 >M10:"........ >AI10:/F$((AH10*12)/AG10)*100 >AH10:" ......... >AG10:" ......... >AF10:/F$((AE10*12)/AD10)*100 >AE10:" ......... >AD10:" ......... >AC10:/F$((AB10*12)/AA10)*100 >AB10:" ......... >AA10:" ......... >Z10:/F$((Y10*12)/X10)*100 >Y10:" .*I9)+(K10*I10))/I11) >J11:+J9+J10 >I11:+I9+I10 >H11:/F$(((H9*F9)+(H10*F10))/F11) >G11:+G9+G10 >F11:+F9+F10 >E11:/F$(((E9*C9)+(E10*C10))/C11) >D11:+D9+D10 >C11:+C9+C10 >B11:" SUBTOTAL >A11:+A10+1 >AL10:/F$((AK10*12)/AJ10)*100 >AK10:" ......... >AJ10:" .10 >W11:/F$(((W9*U9)+(W10*U10))/U11) >V11:+V9+V10 >U11:+U9+U10 >T11:/F$(((T9*R9)+(T10*R10))/R11) >S11:+S9+S10 >R11:+R9+R10 >Q11:/F$(((Q9*O9)+(Q10*O10))/O11) >P11:+P9+P10 >O11:+O9+O10 >N11:/F$(((N9*L9)+(N10*L10))/L11) >M11:+M9+M10 >L11:+L9+L10 >K11:/F$(((K9G9)+(AI10*AG10))/AG11) >AH11:+AH9+AH10 >AG11:+AG9+AG10 >AF11:/F$(((AF9*AD9)+(AF10*AD10))/AD11) >AE11:+AE9+AE10 >AD11:+AD9+AD10 >AC11:/F$(((AC9*AA9)+(AC10*AA10))/AA11) >AB11:+AB9+AB10 >AA11:+AA9+AA10 >Z11:/F$(((Z9*X9)+(Z10*X10))/X11) >Y11:+Y9+Y10 >X11:+X9+X2:" >T12:/F$ >S12:" >R12:" >Q12:/F$ >P12:" >O12:" >N12:/F$ >M12:" >L12:" >K12:/F$ >J12:" >I12:" >H12:/F$ >G12:" >F12:" >E12:/F$ >D12:" >C12:" >A12:+A11+1 >AL11:/F$(((AL9*AJ9)+(AL10*AJ10))/AJ11) >AK11:+AK9+AK10 >AJ11:+AJ9+AJ10 >AI11:/F$(((AI9*A13:/F$(((D13*12)/.54)/C13)*100 >D13:" ......... >C13:" ......... >B13:" ST & MUNI >A13:+A12+1 >AL12:/F$ >AK12:" >AJ12:" >AI12:/F$ >AH12:" >AG12:" >AF12:/F$ >AE12:" >AD12:" >AC12:/F$ >AB12:" >AA12:" >Z12:/F$ >Y12:" >X12:" >W12:/F$ >V12:" >U1 >C6:" >B6:"DAYS PER MTH >A6:+A5+1 >A5:+A4+1 >AL4:" YIELD >AK4:" INCOME >AJ4:" AVG MO BAL >AI4:" YIELD >AH4:" INCOME >AG4:" AVG MO BAL >AF4:" YIELD >AE4:" INCOME >AD4:" AVG MO BAL >AC4:" YIELD >AB4:" INCOME >AA4:" AVG MO BAL >Z4:" YIELD >Y4:" INCOME >X4:" AVG MO BAL >W4:" YIELD >V4:" INCOME >U4:" AVG MO BAL >T4:" YIELD >S4:" INCOME >R4:" AVG MO BAL >Q4:" YIELD >P4:" INCOME >O4:" AVG MO BAL >N4:" YIELD >M4:" INCOME >L4:" AVG MO BAL >K4:" YIELD >J4:" INCOME >I4:" AVG G27:+G25+G26 >F27:+F25+F26 >E27:/F$(((D27/E6)*365)/C27)*100 >D27:+D25+D26 >C27:+C25+C26 >B27:" SUBTOTAL >A27:+A26+1 >AL26:/F$(((AK26/AL6)*365)/AJ26)*100 >AK26:" ......... >AJ26:" ......... >AI26:/F$(((AH26/AI6)*365)/AG26)*100 >AH26:" ......... >AG26)/R27)*100 >S27:+S25+S26 >R27:+R25+R26 >Q27:/F$(((P27/Q6)*365)/O27)*100 >P27:+P25+P26 >O27:+O25+O26 >N27:/F$(((M27/N6)*365)/L27)*100 >M27:+M25+M26 >L27:+L25+L26 >K27:/F$(((J27/K6)*365)/I27)*100 >J27:+J25+J26 >I27:+I25+I26 >H27:/F$(((G27/H6)*365)/F27)*100 >7)*100 >AE27:+AE25+AE26 >AD27:+AD25+AD26 >AC27:/F$(((AB27/AC6)*365)/AA27)*100 >AB27:+AB25+AB26 >AA27:+AA25+AA26 >Z27:/F$(((Y27/Z6)*365)/X27)*100 >Y27:+Y25+Y26 >X27:+X25+X26 >W27:/F$(((V27/W6)*365)/U27)*100 >V27:+V25+V26 >U27:+U25+U26 >T27:/F$(((S27/T6)*365E23*C23))/C29 >D29:+D23+D27 >C29:+C23+C27 >B29:"GRAND TOTAL >A29:+A28+1 >A28:+A27+1 >AL27:/F$(((AK27/AL6)*365)/AJ27)*100 >AK27:+AK25+AK26 >AJ27:+AJ25+AJ26 >AI27:/F$(((AH27/AI6)*365)/AG27)*100 >AH27:+AH25+AH26 >AG27:+AG25+AG26 >AF27:/F$(((AE27/AF6)*365)/AD27*O27)+(Q23*O23))/O29 >P29:+P23+P27 >O29:+O23+O27 >N29:/F$((N27*L27)+(N23*L23))/L29 >M29:+M23+M27 >L29:+L23+L27 >K29:/F$((K27*I27)+(K23*I23))/I29 >J29:+J23+J27 >I29:+I23+I27 >H29:/F$((H27*F27)+(H23*F23))/F29 >G29:+G23+G27 >F29:+F23+F27 >E29:/F$((E27*C27)+(cefghijklmnopqrstuvwxyz{|}~AA27)+(AC23*AA23))/AA29 >AB29:+AB23+AB27 >AA29:+AA23+AA27 >Z29:/F$((Z27*X27)+(Z23*X23))/X29 >Y29:+Y23+Y27 >X29:+X23+X27 >W29:/F$((W27*U27)+(W23*U23))/U29 >V29:+V23+V27 >U29:+U23+U27 >T29:/F$((T27*R27)+(T23*R23))/R29 >S29:+S23+S27 >R29:+R23+R27 >Q29:/F$((Q2>H34:/F$ >H32:/F$ >AL29:/F$((AL27*AJ27)+(AL23*AJ23))/AJ29 >AK29:+AK23+AK27 >AJ29:+AJ23+AJ27 >AI29:/F$((AI27*AG27)+(AI23*AG23))/AG29 >AH29:+AH23+AH27 >AG29:+AG23+AG27 >AF29:/F$((AF27*AD27)+(AF23*AD23))/AD29 >AE29:+AE23+AE27 >AD29:+AD23+AD27 >AC29:/F$((AC27* H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >D1:"LDS >C1:"VESTMENT YIE >B1:"MODEL 5 - IN >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: >AA2:" AA >Z2:" Z >Y2:" Y >X2:" X >W2:" W >V2:" V >U2:" U >T2:" T >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" >H3:" FEB >G3:" FEB >F3:" FEB >E3:" JAN >D3:" JAN >C3:" JAN >A3:+A2+1 >AL2:" AL >AK2:" AK >AJ2:" AJ >AI2:" AI >AH2:" AH >AG2:" AG >AF2:" AF >AE2:" AE >AD2:" AD >AC2:" AC >AB2:" AB SEP >AA3:" SEP >Z3:" AUG >Y3:" AUG >X3:" AUG >W3:" JUL >V3:" JUL >U3:" JUL >T3:" JUN >S3:" JUN >R3:" JUN >Q3:" MAY >P3:" MAY >O3:" MAY >N3:" APR >M3:" APR >L3:" APR >K3:" MAR >J3:" MAR >I3:" MARMO BAL >H4:" YIELD >G4:" INCOME >F4:" AVG MO BAL >E4:" YIELD >D4:" INCOME >C4:" AVG MO BAL >A4:+A3+1 >AL3:" DEC >AK3:" DEC >AJ3:" DEC >AI3:" NOV >AH3:" NOV >AG3:" NOV >AF3:" OCT >AE3:" OCT >AD3:" OCT >AC3:" SEP >AB3:" :" ......... >AF26:/F$(((AE26/AF6)*365)/AD26)*100 >AE26:" ......... >AD26:" ......... >AC26:/F$(((AB26/AC6)*365)/AA26)*100 >AB26:" ......... >AA26:" ......... >Z26:/F$(((Y26/Z6)*365)/X26)*100 >Y26:" ......... >X26:" ......... >W26:/F$(((V26/W6)*365)/U26)*100 >V26:" ......... >U26:" ......... >T26:/F$(((S26/T6)*365)/R26)*100 >S26:" ......... >R26:" ......... >Q26:/F$(((P26/Q6)*365)/O26)*100 >P26:" ......... >O26:" ......... >N26:/F$(((M26/N6)*365)/L26)*100 >M26:" ......... >L26:" ))/AJ21 >AK21:+AK18+AK19+AK20 >AJ21:+AJ18+AJ19+AJ20 >AI21:/F$((AI19*AG19)+(AI18*AG18)+(AI20*AG20))/AG21 >AH21:+AH18+AH19+AH20 >AG21:+AG18+AG19+AG20 >AF21:/F$((AF19*AD19)+(AF18*AD18)+(AF20*AD20))/AD21 >AE21:+AE18+AE19+AE20 >AD21:+AD18+AD19+AD20 >AC21:/F$((A12)/I22)*100 >J22:" ........ >I22:" ......... >H22:/F$((G22*12)/F22)*100 >G22:" ........ >F22:" ......... >E22:/F$((D22*12)/C22)*100 >D22:" ........ >C22:" ......... >B22:"PUBLIC FUNDS >A22:+A21+1 >AL21:/F$((AL19*AJ19)+(AL18*AJ18)+(AL20*AJ20U22)*100 >V22:" ........ >U22:" ......... >T22:/F$((S22*12)/R22)*100 >S22:" ........ >R22:" ......... >Q22:/F$((P22*12)/O22)*100 >P22:" ........ >O22:" ......... >N22:/F$((M22*12)/L22)*100 >M22:" ........ >L22:" ......... >K22:/F$((J22* ........ >AG22:" ......... >AF22:/F$((AE22*12)/AD22)*100 >AE22:" ........ >AD22:" ......... >AC22:/F$((AB22*12)/AA22)*100 >AB22:" ........ >AA22:" ......... >Z22:/F$((Y22*12)/X22)*100 >Y22:" ........ >X22:" ......... >W22:/F$((V22*12)/23:+F15+F16+F21+F22 >E23:/F$((E21*C21)+(E16*C16)+(E15*C15)+(E22*C22))/C23 >D23:+D15+D16+D21+D22 >C23:+C15+C16+C21+C22 >B23:" TOTAL TIME >A23:+A22+1 >AL22:/F$((AK22*12)/AJ22)*100 >AK22:" ........ >AJ22:" ......... >AI22:/F$((AH22*12)/AG22)*100 >AH22:"+(N16*L16)+(N15*L15)+(N22*L22))/L23 >M23:+M15+M16+M21+M22 >L23:+L15+L16+L21+L22 >K23:/F$((K21*I21)+(K16*I16)+(K15*I15)+(K22*I22))/I23 >J23:+J15+J16+J21+J22 >I23:+I15+I16+I21+I22 >H23:/F$((H21*F21)+(H16*F16)+(H15*F15)+(H22*F22))/F23 >G23:+G15+G16+G21+G22 >F23:+V15+V16+V21+V22 >U23:+U15+U16+U21+U22 >T23:/F$((T21*R21)+(T16*R16)+(T15*R15)+(T22*R22))/R23 >S23:+S15+S16+S21+S22 >R23:+R15+R16+R21+R22 >Q23:/F$((Q21*O21)+(Q16*O16)+(Q15*O15)+(Q22*O22))/O23 >P23:+P15+P16+P21+P22 >O23:+O15+O16+O21+O22 >N23:/F$((N21*L21)AA21)+(AC16*AA16)+(AC15*AA15)+(AC22*AA22))/AA23 >AB23:+AB15+AB16+AB21+AB22 >AA23:+AA15+AA16+AA21+AA22 >Z23:/F$((Z21*X21)+(Z16*X16)+(Z15*X15)+(Z22*X22))/X23 >Y23:+Y15+Y16+Y21+Y22 >X23:+X15+X16+X21+X22 >W23:/F$((W21*U21)+(W16*U16)+(W15*U15)+(W22*U22))/U23 >VJ22 >AI23:/F$((AI21*AG21)+(AI16*AG16)+(AI15*AG15)+(AI22*AG22))/AG23 >AH23:+AH15+AH16+AH21+AH22 >AG23:+AG15+AG16+AG21+AG22 >AF23:/F$((AF21*AD21)+(AF16*AD16)+(AF15*AD15)+(AF22*AD22))/AD23 >AE23:+AE15+AE16+AE21+AE22 >AD23:+AD15+AD16+AD21+AD22 >AC23:/F$((AC21* ......... >F25:" ......... >E25:/F$(((D25/E6)*365)/C25)*100 >D25:" ......... >C25:" ......... >B25:"SS REPURO >A25:+A24+1 >A24:+A23+1 >AL23:/F$((AL21*AJ21)+(AL16*AJ16)+(AL15*AJ15)+(AL22*AJ22))/AJ23 >AK23:+AK15+AK16+AK21+AK22 >AJ23:+AJ15+AJ16+AJ21+A.. >Q25:/F$(((P25/Q6)*365)/O25)*100 >P25:" ......... >O25:" ......... >N25:/F$(((M25/N6)*365)/L25)*100 >M25:" ......... >L25:" ......... >K25:/F$(((J25/K6)*365)/I25)*100 >J25:" ......... >I25:" ......... >H25:/F$(((G25/H6)*365)/F25)*100 >G25:" )*100 >AB25:" ......... >AA25:" ......... >Z25:/F$(((Y25/Z6)*365)/X25)*100 >Y25:" ......... >X25:" ......... >W25:/F$(((V25/W6)*365)/U25)*100 >V25:" ......... >U25:" ......... >T25:/F$(((S25/T6)*365)/R25)*100 >S25:" ......... >R25:" ......./F$(((AK25/AL6)*365)/AJ25)*100 >AK25:" ......... >AJ25:" ......... >AI25:/F$(((AH25/AI6)*365)/AG25)*100 >AH25:" ......... >AG25:" ......... >AF25:/F$(((AE25/AF6)*365)/AD25)*100 >AE25:" ......... >AD25:" ......... >AC25:/F$(((AB25/AC6)*365)/AA25 ......... >K26:/F$(((J26/K6)*365)/I26)*100 >J26:" ......... >I26:" ......... >H26:/F$(((G26/H6)*365)/F26)*100 >G26:" ......... >F26:" ......... >E26:/F$(((D26/E6)*365)/C26)*100 >D26:" ......... >C26:" ......... >B26:"FF PUR >A26:+A25+1 >AL25:C19*AA19)+(AC18*AA18)+(AC20*AA20))/AA21 >AB21:+AB18+AB19+AB20 >AA21:+AA18+AA19+AA20 >Z21:/F$((Z19*X19)+(Z18*X18)+(Z20*X20))/X21 >Y21:+Y18+Y19+Y20 >X21:+X18+X19+X20 >W21:/F$((W19*U19)+(W18*U18)+(W20*U20))/U21 >V21:+V18+V19+V20 >U21:+U18+U19+U20 >T21:/F$((T19*R19)+(T18*R18)+(T20*R20))/R21 >S21:+S18+S19+S20 >R21:+R18+R19+R20 >Q21:/F$((Q19*O19)+(Q18*O18)+(Q20*O20))/O21 >P21:+P18+P19+P20 >O21:+O18+O19+O20 >N21:/F$((N19*L19)+(N18*L18)+(N20*L20))/L21 >M21:+M18+M19+M20 >L21:+L18+L19+L20 >K21:/F$((K19*I19)+(K18*I18)16:" ......... >X16:" ......... >W16:/F$(((V16/W6)*365)/U16)*100 >V16:" ......... >U16:" ......... >T16:/F$(((S16/T6)*365)/R16)*100 >S16:" ......... >R16:" ......... >Q16:/F$(((P16/Q6)*365)/O16)*100 >P16:" ......... >O16:" ......... >N16:/F((AH16/AI6)*365)/AG16)*100 >AH16:" ......... >AG16:" ......... >AF16:/F$(((AE16/AF6)*365)/AD16)*100 >AE16:" ......... >AD16:" ......... >AC16:/F$(((AB16/AC6)*365)/AA16)*100 >AB16:" ......... >AA16:" ......... >Z16:/F$(((Y16/Z6)*365)/X16)*100 >Y((G18/H6)*365)/F18)*100 >G18:" ......... >F18:" .......... >E18:/F$(((D18/E6)*365)/C18)*100 >D18:" ......... >C18:" .......... >B18:"TCD >A18:+A17+1 >A17:+A16+1 >AL16:/F$(((AK16/AL6)*365)/AJ16)*100 >AK16:" ......... >AJ16:" ......... >AI16:/F$( ......... >R18:" .......... >Q18:/F$(((P18/Q6)*365)/O18)*100 >P18:" ......... >O18:" .......... >N18:/F$(((M18/N6)*365)/L18)*100 >M18:" ......... >L18:" .......... >K18:/F$(((J18/K6)*365)/I18)*100 >J18:" ......... >I18:" .......... >H18:/F$(F$(((AB18/AC6)*365)/AA18)*100 >AB18:" ......... >AA18:" .......... >Z18:/F$(((Y18/Z6)*365)/X18)*100 >Y18:" ......... >X18:" .......... >W18:/F$(((V18/W6)*365)/U18)*100 >V18:" ......... >U18:" .......... >T18:/F$(((S18/T6)*365)/R18)*100 >S18:" RT >A19:+A18+1 >AL18:/F$(((AK18/AL6)*365)/AJ18)*100 >AK18:" ......... >AJ18:" .......... >AI18:/F$(((AH18/AI6)*365)/AG18)*100 >AH18:" ......... >AG18:" .......... >AF18:/F$(((AE18/AF6)*365)/AD18)*100 >AE18:" ......... >AD18:" .......... >AC18:/..... >L19:" .......... >K19:/F$(((J19/K6)*365)/I19)*100 >J19:" ......... >I19:" .......... >H19:/F$(((G19/H6)*365)/F19)*100 >G19:" ......... >F19:" .......... >E19:/F$(((D19/E6)*365)/C19)*100 >D19:" ......... >C19:" .......... >B19:"OTHER CEF$(((V19/W6)*365)/U19)*100 >V19:" ......... >U19:" .......... >T19:/F$(((S19/T6)*365)/R19)*100 >S19:" ......... >R19:" .......... >Q19:/F$(((P19/Q6)*365)/O19)*100 >P19:" ......... >O19:" .......... >N19:/F$(((M19/N6)*365)/L19)*100 >M19:" .... >AG19:" .......... >AF19:/F$(((AE19/AF6)*365)/AD19)*100 >AE19:" ......... >AD19:" .......... >AC19:/F$(((AB19/AC6)*365)/AA19)*100 >AB19:" ......... >AA19:" .......... >Z19:/F$(((Y19/Z6)*365)/X19)*100 >Y19:" ......... >X19:" .......... >W19:/.. >F20:" ......... >E20:/F$(((D20/E6)*365)/C20)*100 >D20:" ......... >C20:" ......... >B20:"ALL SAVERS >A20:+A19+1 >AL19:/F$(((AK19/AL6)*365)/AJ19)*100 >AK19:" ......... >AJ19:" .......... >AI19:/F$(((AH19/AI6)*365)/AG19)*100 >AH19:" .........F$(((P20/Q6)*365)/O20)*100 >P20:" ......... >O20:" ......... >N20:/F$(((M20/N6)*365)/L20)*100 >M20:" ......... >L20:" ......... >K20:/F$(((J20/K6)*365)/I20)*100 >J20:" ......... >I20:" ......... >H20:/F$(((G20/H6)*365)/F20)*100 >G20:" .......20:" ......... >AA20:" ......... >Z20:/F$(((Y20/Z6)*365)/X20)*100 >Y20:" ......... >X20:" ......... >W20:/F$(((V20/W6)*365)/U20)*100 >V20:" ......... >U20:" ......... >T20:/F$(((S20/T6)*365)/R20)*100 >S20:" ......... >R20:" ......... >Q20:/0/AL6)*365)/AJ20)*100 >AK20:" ......... >AJ20:" ......... >AI20:/F$(((AH20/AI6)*365)/AG20)*100 >AH20:" ......... >AG20:" ......... >AF20:/F$(((AE20/AF6)*365)/AD20)*100 >AE20:" ......... >AD20:" ......... >AC20:/F$(((AB20/AC6)*365)/AA20)*100 >AB+(K20*I20))/I21 >J21:+J18+J19+J20 >I21:+I18+I19+I20 >H21:/F$((H19*F19)+(H18*F18)+(H20*F20))/F21 >G21:+G18+G19+G20 >F21:+F18+F19+F20 >E21:/F$((E19*C19)+(E18*C18)+(E20*C20))/C21 >D21:+D18+D19+D20 >C21:+C18+C19+C20 >B21:" TOTAL CD >A21:+A20+1 >AL20:/F$(((AK2$(((M16/N6)*365)/L16)*100 >M16:" ......... >L16:" ......... >K16:/F$(((J16/K6)*365)/I16)*100 >J16:" ......... >I16:" ......... >H16:/F$(((G16/H6)*365)/F16)*100 >G16:" ......... >F16:" ......... >E16:/F$(((D16/E6)*365)/C16)*100 >D16:" ......... >C16:" ......... >B16:"NOW ACCOUNTS >A16:+A15+1 >AL15:/F$((AL13*AJ13)+(AL14*AJ14))/AJ15 >AK15:+AK14+AK13 >AJ15:+AJ14+AJ13 >AI15:/F$((AI13*AG13)+(AI14*AG14))/AG15 >AH15:+AH14+AH13 >AG15:+AG14+AG13 >AF15:/F$((AF13*AD13)+(AF14*AD14))/AD15 >AE15:+AE14+AE131:" ......... >M11:" ......... >L11:" ......... >J11:" ......... >I11:" ......... >G11:" ......... >F11:" ......... >D11:" ......... >C11:" ......... >B11:"PREM >A11:+A10+1 >AK10:" ......... >AJ10:" ......... >AH10:" ......... >AG10>AH11:" ......... >AG11:" ......... >AE11:" ......... >AD11:" ......... >AB11:" ......... >AA11:" ......... >Y11:" ......... >X11:" ......... >V11:" ......... >U11:" ......... >S11:" ......... >R11:" ......... >P11:" ......... >O112:" ......... >O12:" ......... >M12:" ......... >L12:" ......... >J12:" ......... >I12:" ......... >G12:" ......... >F12:" ......... >D12:" ......... >C12:" ......... >B12:"PREM PLUS >A12:+A11+1 >AK11:" ......... >AJ11:" ......... >AJ12:" ......... >AH12:" ......... >AG12:" ......... >AE12:" ......... >AD12:" ......... >AB12:" ......... >AA12:" ......... >Y12:" ......... >X12:" ......... >V12:" ......... >U12:" ......... >S12:" ......... >R12:" ......... >P)*100 >J13:+J9+J10+J11+J12 >I13:+I8+I9+I10+I11+I12 >H13:/F$(((G13/H6)*365)/F13)*100 >G13:+G9+G10+G11+G12 >F13:+F8+F9+F10+F11+F12 >E13:/F$(((D13/E6)*365)/C13)*100 >D13:+D9+D10+D11+D12 >C13:+C8+C9+C10+C11+C12 >B13:" SUBTOTAL >A13:+A12+1 >AK12:" ......... /F$(((S13/T6)*365)/R13)*100 >S13:+S9+S10+S11+S12 >R13:+R8+R9+R10+R11+R12 >Q13:/F$(((P13/Q6)*365)/O13)*100 >P13:+P9+P10+P11+P12 >O13:+O8+O9+O10+O11+O12 >N13:/F$(((M13/N6)*365)/L13)*100 >M13:+M9+M10+M11+M12 >L13:+L8+L9+L10+L11+L12 >K13:/F$(((J13/K6)*365)/I132 >AC13:/F$(((AB13/AC6)*365)/AA13)*100 >AB13:+AB9+AB10+AB11+AB12 >AA13:+AA8+AA9+AA10+AA11+AA12 >Z13:/F$(((Y13/Z6)*365)/X13)*100 >Y13:+Y9+Y10+Y11+Y12 >X13:+X8+X9+X10+X11+X12 >W13:/F$(((V13/W6)*365)/U13)*100 >V13:+V9+V10+V11+V12 >U13:+U8+U9+U10+U11+U12 >T13:*365)/AJ13)*100 >AK13:+AK9+AK10+AK11+AK12 >AJ13:+AJ8+AJ9+AJ10+AJ11+AJ12 >AI13:/F$(((AH13/AI6)*365)/AG13)*100 >AH13:+AH9+AH10+AH11+AH12 >AG13:+AG8+AG9+AG10+AG11+AG12 >AF13:/F$(((AE13/AF6)*365)/AD13)*100 >AE13:+AE9+AE10+AE11+AE12 >AD13:+AD8+AD9+AD10+AD11+AD1>K14:/F$(((J14/K6)*365)/I14)*100 >J14:" ......... >I14:" ......... >H14:/F$(((G14/H6)*365)/F14)*100 >G14:" ......... >F14:" ......... >E14:/F$(((D14/E6)*365)/C14)*100 >D14:" ......... >C14:" ......... >B14:"IRA >A14:+A13+1 >AL13:/F$(((AK13/AL6)*100 >V14:" ......... >U14:" ......... >T14:/F$(((S14/T6)*365)/R14)*100 >S14:" ......... >R14:" ......... >Q14:/F$(((P14/Q6)*365)/O14)*100 >P14:" ......... >O14:" ......... >N14:/F$(((M14/N6)*365)/L14)*100 >M14:" ......... >L14:" ......... .. >AF14:/F$(((AE14/AF6)*365)/AD14)*100 >AE14:" ......... >AD14:" ......... >AC14:/F$(((AB14/AC6)*365)/AA14)*100 >AB14:" ......... >AA14:" ......... >Z14:/F$(((Y14/Z6)*365)/X14)*100 >Y14:" ......... >X14:" ......... >W14:/F$(((V14/W6)*365)/U14)>F15:+F14+F13 >E15:/F$((E13*C13)+(E14*C14))/C15 >D15:+D14+D13 >C15:+C14+C13 >B15:" SUBTOTAL >A15:+A14+1 >AL14:/F$(((AK14/AL6)*365)/AJ14)*100 >AK14:" ......... >AJ14:" ......... >AI14:/F$(((AH14/AI6)*365)/AG14)*100 >AH14:" ......... >AG14:" .......S14+S13 >R15:+R14+R13 >Q15:/F$((Q13*O13)+(Q14*O14))/O15 >P15:+P14+P13 >O15:+O14+O13 >N15:/F$((N13*L13)+(N14*L14))/L15 >M15:+M14+M13 >L15:+L14+L13 >K15:/F$((K13*I13)+(K14*I14))/I15 >J15:+J14+J13 >I15:+I14+I13 >H15:/F$((H13*F13)+(H14*F14))/F15 >G15:+G14+G13 >AD15:+AD14+AD13 >AC15:/F$((AC13*AA13)+(AC14*AA14))/AA15 >AB15:+AB14+AB13 >AA15:+AA14+AA13 >Z15:/F$((Z13*X13)+(Z14*X14))/X15 >Y15:+Y14+Y13 >X15:+X14+X13 >W15:/F$((W13*U13)+(W14*U14))/U15 >V15:+V14+V13 >U15:+U14+U13 >T15:/F$((T13*R13)+(T14*R14))/R15 >S15:+:" ......... >AE10:" ......... >AD10:" ......... >AB10:" ......... >AA10:" ......... >Y10:" ......... >X10:" ......... >V10:" ......... >U10:" ......... >S10:" ......... >R10:" ......... >P10:" ......... >O10:" ......... >M10:" ......... >L10:" ......... >J10:" ......... >I10:" ......... >G10:" ......... >F10:" ......... >D10:" ......... >C10:" ......... >B10:"GOLDEN >A10:+A9+1 >AK9:" ......... >AJ9:" ......... >AH9:" ......... >AG9:" ......... >AE9:" ....+(S16*T16)+(S26*T26)+(S34*T34)+(S39*T39))/(+S9+S16+S26+S34+S39) >R50:/F$((Q9*R9)+(Q16*R16)+(Q26*R26)+(Q34*R34)+(Q39*R39))/(+Q9+Q16+Q26+Q34+Q39) >P50:/F$((O9*P9)+(O16*P16)+(O26*P26)+(O34*P34)+(O39*P39))/(+O9+O16+O26+O34+O39) >N50:/F$((M9*N9)+(M16*N16)+(M26*>Z50:/F$((Y9*Z9)+(Y16*Z16)+(Y26*Z26)+(Y34*Z34)+(Y39*Z39))/(+Y9+Y16+Y26+Y34+Y39) >X50:/F$((W9*X9)+(W16*X16)+(W26*X26)+(W34*X34)+(W39*X39))/(+W9+W16+W26+W34+W39) >V50:/F$((U9*V9)+(U16*V16)+(U26*V26)+(U34*V34)+(U39*V39))/(+U9+U16+U26+U34+U39) >T50:/F$((S9*T9) H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >C1:"SIT COST >B1:"MODEL 6 DEPO >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: B >AA2:" AA >Z2:" Z >Y2:" Y >X2:" X >W2:" W >V2:" V >U2:" U >T2:" T >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:"AR >H3:" FEB >G3:" FEB >F3:" FEB >E3:" JAN >D3:" JAN >C3:" JAN >A3:+A2+1 >AL2:" AL >AK2:" AK >AJ2:" AJ >AI2:" AI >AH2:" AH >AG2:" AG >AF2:" AF >AE2:" AE >AD2:" AD >AC2:" AC >AB2:" A" SEP >AA3:" SEP >Z3:" AUG >Y3:" AUG >X3:" AUG >W3:" JUL >V3:" JUL >U3:" JUL >T3:" JUN >S3:" JUN >R3:" JUN >Q3:" MAY >P3:" MAY >O3:" MAY >N3:" APR >M3:" APR >L3:" APR >K3:" MAR >J3:" MAR >I3:" MG MO BAL >H4:" YIELD >G4:" INCOME >F4:" AVG MO BAL >E4:" YIELD >D4:" INCOME >C4:" AVG MO BAL >A4:+A3+1 >AL3:" DEC >AK3:" DEC >AJ3:" DEC >AI3:" NOV >AH3:" NOV >AG3:" NOV >AF3:" OCT >AE3:" OCT >AD3:" OCT >AC3:" SEP >AB3:LD >Y4:" INCOME >X4:" AVG MO BAL >W4:" YIELD >V4:" INCOME >U4:" AVG MO BAL >T4:" YIELD >S4:" INCOME >R4:" AVG MO BAL >Q4:" YIELD >P4:" INCOME >O4:" AVG MO BAL >N4:" YIELD >M4:" INCOME >L4:" AVG MO BAL >K4:" YIELD >J4:" INCOME >I4:" AV:" >C6:" >B6:"DAYS PER MTH >A6:+A5+1 >A5:+A4+1 >AL4:" YIELD >AK4:" INCOME >AJ4:" AVG MO BAL >AI4:" YIELD >AH4:" INCOME >AG4:" AVG MO BAL >AF4:" YIELD >AE4:" INCOME >AD4:" AVG MO BAL >AC4:" YIELD >AB4:" INCOME >AA4:" AVG MO BAL >Z4:" YIE" >AA6:" >Z6:" ......... >Y6:" >X6:" >W6:" ......... >V6:" >U6:" >T6:" ......... >S6:" >R6:" >Q6:" ......... >P6:" >O6:" >N6:" ......... >M6:" >L6:" >K6:" ......... >J6:" >I6:" >H6:" ......... >G6:" >F6:" >E6:" ......... >D6O8:" .......... >L8:" .......... >I8:" .......... >F8:" .......... >C8:" .......... >B8:"SAVINGS >A8:+A7+1 >A7:+A6+1 >AL6:" ......... >AK6:" >AJ6:" >AI6:" ......... >AH6:" >AG6:" >AF6:" ......... >AE6:" >AD6:" >AC6:" ......... >AB6:.... >I9:" ......... >G9:" ......... >F9:" ......... >D9:" ......... >C9:" ......... >B9:"HOLIDAY >A9:+A8+1 >AJ8:" .......... >AG8:" .......... >AD8:" .......... >AA8:" .......... >X8:" .......... >U8:" .......... >R8:" .......... >..... >AD9:" ......... >AB9:" ......... >AA9:" ......... >Y9:" ......... >X9:" ......... >V9:" ......... >U9:" ......... >S9:" ......... >R9:" ......... >P9:" ......... >O9:" ......... >M9:" ......... >L9:" ......... >J9:" .....N26)+(M34*N34)+(M39*N39))/(+M9+M16+M26+M34+M39) >L50:/F$((K9*L9)+(K16*L16)+(K26*L26)+(K34*L34)+(K39*L39))/(+K9+K16+K26+K34+K39) >J50:/F$((I9*J9)+(I16*J16)+(I26*J26)+(I34*J34)+(I39*J39))/(+I9+I16+I26+I34+I39) >H50:/F$((G9*H9)+(G16*H16)+(G26*H26)+(G34*H34)+(O38:" ......... >N38:/F$" ......... >M38:" ......... >L38:/F$" ......... >K38:" ......... >J38:/F$" ......... >I38:" ......... >H38:/F$" ......... >G38:" ......... >F38:/F$" ......... >E38:" ......... >D38:/F$" ......... >C38:" ..9:"TOTAL REAL E >A39:+A38+1 >Z38:/F$" ......... >Y38:" ......... >X38:/F$" ......... >W38:" ......... >V38:/F$" ......... >U38:" ......... >T38:/F$" ......... >S38:" ......... >R38:/F$" ......... >Q38:" ......... >P38:/F$" ......... >...... >N39:/F$" ......... >M39:" ......... >L39:/F$" ......... >K39:" ......... >J39:/F$" ......... >I39:" ......... >H39:/F$" ......... >G39:" ......... >F39:/F$" ......... >E39:" ......... >D39:/F$" ......... >C39:" ......... >B3RAFT >A40:+A39+1 >Z39:/F$" ......... >Y39:" ......... >X39:/F$" ......... >W39:" ......... >V39:/F$" ......... >U39:" ......... >T39:/F$" ......... >S39:" ......... >R39:/F$" ......... >Q39:" ......... >P39:/F$" ......... >O39:" ...S >A41:+A40+1 >Y40:" ......... >W40:" ......... >U40:" ......... >S40:" ......... >Q40:" ......... >O40:" ......... >M40:" ......... >K40:" ......... >I40:" ......... >G40:" ......... >E40:" ......... >C40:" ......... >B40:" OVERD42:+A41+1 >Y41:" ......... >W41:" ......... >U41:" ......... >S41:" ......... >Q41:" ......... >O41:" ......... >M41:" ......... >K41:" ......... >I41:" ......... >G41:" ......... >E41:" ......... >C41:" ......... >B41:" UNEARN DI+A42+1 >Y42:" ......... >W42:" ......... >U42:" ......... >S42:" ......... >Q42:" ......... >O42:" ......... >M42:" ......... >K42:" ......... >I42:" ......... >G42:" ......... >E42:" ......... >C42:" ......... >B42:" LOAN LOSS >A26+Q34+Q39+Q40+Q41+Q42 >O43:+O26+O34+O39+O40+O41+O42 >M43:+M26+M34+M39+M40+M41+M42 >K43:+K26+K34+K39+K40+K41+K42 >I43:+I26+I34+I39+I40+I41+I42 >G43:+G26+G34+G39+G40+G41+G42 >E43:+E26+E34+E39+E40+E41+E42 >C43:+C26+C34+C39+C40+C41+C42 >B43:"TOTAL LOANS >A43:....... >K44:" ......... >I44:" ......... >G44:" ......... >E44:" ......... >C44:" ......... >B44:"INT REC >A44:+A43+1 >Y43:+Y26+Y34+Y39+Y40+Y41+Y42 >W43:+W26+W34+W39+W40+W41+W42 >U43:+U26+U34+U39+U40+U41+U42 >S43:+S26+S34+S39+S40+S41+S42 >Q43:+Q.... >K45:" ......... >I45:" ......... >G45:" ......... >E45:" ......... >C45:" ......... >B45:"OTHER ASSETS >A45:+A44+1 >Y44:" ......... >W44:" ......... >U44:" ......... >S44:" ......... >Q44:" ......... >O44:" ......... >M44:" ... >K46:" ......... >I46:" ......... >G46:" ......... >E46:" ......... >C46:" ......... >B46:"FIXED ASSETS >A46:+A45+1 >Y45:" ......... >W45:" ......... >U45:" ......... >S45:" ......... >Q45:" ......... >O45:" ......... >M45:" .....I46 >G47:+G10+G16+G43+G44+G45+G46 >E47:+E10+E16+E43+E44+E45+E46 >C47:+C10+C16+C43+C44+C45+C46 >B47:"TOTAL ASSETS >A47:+A46+1 >Y46:" ......... >W46:" ......... >U46:" ......... >S46:" ......... >Q46:" ......... >O46:" ......... >M46:" ........Y16+Y43+Y44+Y45+Y46 >W47:+W10+W16+W43+W44+W45+W46 >U47:+U10+U16+U43+U44+U45+U46 >S47:+S10+S16+S43+S44+S45+S46 >Q47:+Q10+Q16+Q43+Q44+Q45+Q46 >O47:+O10+O16+O43+O44+O45+O46 >M47:+M10+M16+M43+M44+M45+M46 >K47:+K10+K16+K43+K44+K45+K46 >I47:+I10+I16+I43+I44+I45+G39*H39))/(+G9+G16+G26+G34+G39) >F50:/F$((E9*F9)+(E16*F16)+(E26*F26)+(E34*F34)+(E39*F39))/(+E9+E16+E26+E34+E39) >D50:/F$((C9*D9)+(C16*D16)+(C26*D26)+(C34*D34)+(C39*D39))/(+C9+C16+C26+C34+C39) >B50:"TOTAL YIELD >A50:+A49+1 >A49:+A48+1 >A48:+A47+1 >Y47:+Y10+....... >B38:" GOV GUAR >A38:+A37+1 >Z37:/F$" ......... >Y37:" ......... >X37:/F$" ......... >W37:" ......... >V37:/F$" ......... >U37:" ......... >T37:/F$" ......... >S37:" ......... >R37:/F$" ......... >Q37:" ......... >P37:/F$" ......... >O37:" ......... >N37:/F$" ......... >M37:" ......... >L37:/F$" ......... >K37:" ......... >J37:/F$" ......... >I37:" ......... >H37:/F$" ......... >G37:" ......... >F37:/F$" ......... >E37:" ......... >D37:/F$" ......... >..... >U29:" ......... >T29:/F$" ......... >S29:" ......... >R29:/F$" ......... >Q29:" ......... >P29:/F$" ......... >O29:" ......... >N29:/F$" ......... >M29:" ......... >L29:/F$" ......... >K29:" ......... >J29:/F$" ......... >I29.... >H30:/F$" ......... >G30:" ......... >F30:/F$" ......... >E30:" ......... >D30:/F$" ......... >C30:" ......... >B30:" PERSONAL >A30:+A29+1 >Z29:/F$" ......... >Y29:" ......... >X29:/F$" ......... >W29:" ......... >V29:/F$" ....:" ......... >T30:/F$" ......... >S30:" ......... >R30:/F$" ......... >Q30:" ......... >P30:/F$" ......... >O30:" ......... >N30:/F$" ......... >M30:" ......... >L30:/F$" ......... >K30:" ......... >J30:/F$" ......... >I30:" ...../F$" ......... >G31:" ......... >F31:/F$" ......... >E31:" ......... >D31:/F$" ......... >C31:" ......... >B31:" COM INST >A31:+A30+1 >Z30:/F$" ......... >Y30:" ......... >X30:/F$" ......... >W30:" ......... >V30:/F$" ......... >U30.... >T31:/F$" ......... >S31:" ......... >R31:/F$" ......... >Q31:" ......... >P31:/F$" ......... >O31:" ......... >N31:/F$" ......... >M31:" ......... >L31:/F$" ......... >K31:" ......... >J31:/F$" ......... >I31:" ......... >H31:...... >G32:" ......... >F32:/F$" ......... >E32:" ......... >D32:/F$" ......... >C32:" ......... >B32:" DISCNTED >A32:+A31+1 >Z31:/F$" ......... >Y31:" ......... >X31:/F$" ......... >W31:" ......... >V31:/F$" ......... >U31:" ...../F$" ......... >S32:" ......... >R32:/F$" ......... >Q32:" ......... >P32:/F$" ......... >O32:" ......... >N32:/F$" ......... >M32:" ......... >L32:/F$" ......... >K32:" ......... >J32:/F$" ......... >I32:" ......... >H32:/F$" ... ......... >F33:/F$" ........... >E33:" ......... >D33:/F$" ........... >C33:" ......... >B33:" STUDENT >A33:+A32+1 >Z32:/F$" ......... >Y32:" ......... >X32:/F$" ......... >W32:" ......... >V32:/F$" ......... >U32:" ......... >T32: ......... >R33:/F$" ........... >Q33:" ......... >P33:/F$" ........... >O33:" ......... >N33:/F$" ........... >M33:" ......... >L33:/F$" ........... >K33:" ......... >J33:/F$" ........... >I33:" ......... >H33:/F$" ........... >G33:"... >E34:" ......... >D34:/F$" ......... >C34:" ......... >B34:"TOTAL INSTAL >A34:+A33+1 >Z33:/F$" ........... >Y33:" ......... >X33:/F$" ........... >W33:" ......... >V33:/F$" ........... >U33:" ......... >T33:/F$" ........... >S33:" " ......... >Q34:" ......... >P34:/F$" ......... >O34:" ......... >N34:/F$" ......... >M34:" ......... >L34:/F$" ......... >K34:" ......... >J34:/F$" ......... >I34:" ......... >H34:/F$" ......... >G34:" ......... >F34:/F$" .......... >C36:" ......... >B36:" RESIDENT >A36:+A35+1 >B35:" REAL ESTE >A35:+A34+1 >Z34:/F$" ......... >Y34:" ......... >X34:/F$" ......... >W34:" ......... >V34:/F$" ......... >U34:" ......... >T34:/F$" ......... >S34:" ......... >R34:/F$$" ......... >O36:" ......... >N36:/F$" ......... >M36:" ......... >L36:/F$" ......... >K36:" ......... >J36:/F$" ......... >I36:" ......... >H36:/F$" ......... >G36:" ......... >F36:/F$" ......... >E36:" ......... >D36:/F$" .....C37:" ......... >B37:" COMM >A37:+A36+1 >Z36:/F$" ......... >Y36:" ......... >X36:/F$" ......... >W36:" ......... >V36:/F$" ......... >U36:" ......... >T36:/F$" ......... >S36:" ......... >R36:/F$" ......... >Q36:" ......... >P36:/F:" ......... >H29:/F$" ......... >G29:" ......... >F29:/F$" ......... >E29:" ......... >D29:/F$" ......... >C29:" ......... >B29:" FHA >A29:+A28+1 >Z28:/F$" ......... >Y28:" ......... >X28:/F$" ......... >W28:" ......... >V28:/F$" ......... >U28:" ......... >T28:/F$" ......... >S28:" ......... >R28:/F$" ......... >Q28:" ......... >P28:/F$" ......... >O28:" ......... >N28:/F$" ......... >M28:" ......... >L28:/F$" ......... >K28:" ......... >J28:/F$" .............. >B21:" UNSECURED >A21:+A20+1 >Z20:/F$" ......... >Y20:" ......... >X20:/F$" ......... >W20:" ......... >V20:/F$" ......... >U20:" ......... >T20:/F$" ......... >S20:" ......... >R20:/F$" ......... >Q20:" ......... >P20:/F$" ..1:" ......... >N21:/F$" ......... >M21:" ......... >L21:/F$" ......... >K21:" ......... >J21:/F$" ......... >I21:" ......... >H21:/F$" ......... >G21:" ......... >F21:/F$" ......... >E21:" ......... >D21:/F$" ......... >C21:" ....22:" DEMAND >A22:+A21+1 >Z21:/F$" ......... >Y21:" ......... >X21:/F$" ......... >W21:" ......... >V21:/F$" ......... >U21:" ......... >T21:/F$" ......... >S21:" ......... >R21:/F$" ......... >Q21:" ......... >P21:/F$" ......... >O2....... >N22:/F$" ......... >M22:" ......... >L22:/F$" ......... >K22:" ......... >J22:/F$" ......... >I22:" ......... >H22:/F$" ......... >G22:" ......... >F22:/F$" ......... >E22:" ......... >D22:/F$" ......... >C22:" ......... >BPMENT >A23:+A22+1 >Z22:/F$" ......... >Y22:" ......... >X22:/F$" ......... >W22:" ......... >V22:/F$" ......... >U22:" ......... >T22:/F$" ......... >S22:" ......... >R22:/F$" ......... >Q22:" ......... >P22:/F$" ......... >O22:" .. ......... >M23:" .......... >L23:/F$" ......... >K23:" .......... >J23:/F$" ......... >I23:" .......... >H23:/F$" ......... >G23:" .......... >F23:/F$" ......... >E23:" .......... >D23:/F$" ......... >C23:" .......... >B23:" EQUI/F$" ......... >Y23:" .......... >X23:/F$" ......... >W23:" .......... >V23:/F$" ......... >U23:" .......... >T23:/F$" ......... >S23:" .......... >R23:/F$" ......... >Q23:" .......... >P23:/F$" ......... >O23:" .......... >N23:/F$"24:" ......... >L24:/F$" ......... >K24:" ......... >J24:/F$" ......... >I24:" ......... >H24:/F$" ......... >G24:" ......... >F24:/F$" ......... >E24:" ......... >D24:/F$" ......... >C24:" ......... >B24:" BROKERS >A24:+A23+1 >Z23:....... >Y24:" ......... >X24:/F$" ......... >W24:" ......... >V24:/F$" ......... >U24:" ......... >T24:/F$" ......... >S24:" ......... >R24:/F$" ......... >Q24:" ......... >P24:/F$" ......... >O24:" ......... >N24:/F$" ......... >M. >L25:/F$" ......... >K25:" .......... >J25:/F$" ......... >I25:" .......... >H25:/F$" ......... >G25:" .......... >F25:/F$" ......... >E25:" .......... >D25:/F$" ......... >C25:" .......... >B25:" AUTO LSE >A25:+A24+1 >Z24:/F$" ....... >X25:/F$" ......... >W25:" .......... >V25:/F$" ......... >U25:" .......... >T25:/F$" ......... >S25:" .......... >R25:/F$" ......... >Q25:" .......... >P25:/F$" ......... >O25:" .......... >N25:/F$" ......... >M25:" .......... >K26:" ......... >J26:/F$" .......... >I26:" ......... >H26:/F$" .......... >G26:" ......... >F26:/F$" .......... >E26:" ......... >D26:/F$" .......... >C26:" ......... >B26:"TOTAL COM LN >A26:+A25+1 >Z25:/F$" ......... >Y25:" .......... >W26:" ......... >V26:/F$" .......... >U26:" ......... >T26:/F$" .......... >S26:" ......... >R26:/F$" .......... >Q26:" ......... >P26:/F$" .......... >O26:" ......... >N26:/F$" .......... >M26:" ......... >L26:/F$" ......... >I28:" ......... >H28:/F$" ......... >G28:" ......... >F28:/F$" ......... >E28:" ......... >D28:/F$" ......... >C28:" ......... >B28:" AUTO >A28:+A27+1 >B27:" INSTALL >A27:+A26+1 >Z26:/F$" .......... >Y26:" ......... >X26:/F$" ............ >O20:" ......... >N20:/F$" ......... >M20:" ......... >L20:/F$" ......... >K20:" ......... >J20:/F$" ......... >I20:" ......... >H20:/F$" ......... >G20:" ......... >F20:/F$" ......... >E20:" ......... >D20:/F$" ......... >C20:" ......... >B20:" SECURED >A20:+A19+1 >B19:" COMMERCIAL >A19:+A18+1 >B18:"LOANS >A18:+A17+1 >A17:+A16+1 >Z16:/F$" ......... >Y16:" ......... >X16:/F$" ......... >W16:" ......... >V16:/F$" ......... >U16:" ......... >T16:/F$" ............... >M7:" ......... >K7:" ......... >I7:" ......... >G7:" ......... >E7:" ......... >C7:" ......... >B7:" CASH >A7:+A6+1 >B6:"CASH & DUE >A6:+A5+1 >A5:+A4+1 >Z4:" YIELD >Y4:" AVG MO BAL >X4:" YIELD >W4:" AVG MO BAL >V4:" YIELD >U4:" ... >O8:" ......... >M8:" ......... >K8:" ......... >I8:" ......... >G8:" ......... >E8:" ......... >C8:" ......... >B8:" DUE FROM >A8:+A7+1 >Y7:" ......... >W7:" ......... >U7:" ......... >S7:" ......... >Q7:" ......... >O7:" ......... >I9:" ......... >H9:/F$" ......... >G9:" ......... >F9:/F$" ......... >E9:" ......... >D9:/F$" ......... >C9:" ......... >B9:" FED FUNDS >A9:+A8+1 >Y8:" ......... >W8:" ......... >U8:" ......... >S8:" ......... >Q8:" .............. >V9:/F$" ......... >U9:" ......... >T9:/F$" ......... >S9:" ......... >R9:/F$" ......... >Q9:" ......... >P9:/F$" ......... >O9:" ......... >N9:/F$" ......... >M9:" ......... >L9:/F$" ......... >K9:" ......... >J9:/F$" ..:+K7+K8+K9 >J10:/F$" ......... >I10:+I7+I8+I9 >H10:/F$" ......... >G10:+G7+G8+G9 >F10:/F$" ......... >E10:+E7+E8+E9 >D10:/F$" ......... >C10:+C7+C8+C9 >B10:"TOTAL CASH >A10:+A9+1 >Z9:/F$" ......... >Y9:" ......... >X9:/F$" ......... >W9:" .7+Y8+Y9 >X10:/F$" ......... >W10:+W7+W8+W9 >V10:/F$" ......... >U10:+U7+U8+U9 >T10:/F$" ......... >S10:+S7+S8+S9 >R10:/F$" ......... >Q10:+Q7+Q8+Q9 >P10:/F$" ......... >O10:+O7+O8+O9 >N10:/F$" ......... >M10:+M7+M8+M9 >L10:/F$" ......... >K10$" .......... >I13:" ......... >H13:/F$" .......... >G13:" ......... >F13:/F$" .......... >E13:" ......... >D13:/F$" .......... >C13:" ......... >B13:" GOV >A13:+A12+1 >B12:"INVESTMENTS >A12:+A11+1 >A11:+A10+1 >Z10:/F$" ......... >Y10:+Y3:/F$" .......... >U13:" ......... >T13:/F$" .......... >S13:" ......... >R13:/F$" .......... >Q13:" ......... >P13:/F$" .......... >O13:" ......... >N13:/F$" .......... >M13:" ......... >L13:/F$" .......... >K13:" ......... >J13:/F .......... >H14:/F$" .......... >G14:" .......... >F14:/F$" .......... >E14:" .......... >D14:/F$" .......... >C14:" .......... >B14:" STATE >A14:+A13+1 >Z13:/F$" .......... >Y13:" ......... >X13:/F$" .......... >W13:" ......... >V1 .......... >T14:/F$" .......... >S14:" .......... >R14:/F$" .......... >Q14:" .......... >P14:/F$" .......... >O14:" .......... >N14:/F$" .......... >M14:" .......... >L14:/F$" .......... >K14:" .......... >J14:/F$" .......... >I14:"........ >G15:" .......... >F15:/F$" ......... >E15:" .......... >D15:/F$" ......... >C15:" .......... >B15:" OTHER >A15:+A14+1 >Z14:/F$" .......... >Y14:" .......... >X14:/F$" .......... >W14:" .......... >V14:/F$" .......... >U14:" ......... >S15:" .......... >R15:/F$" ......... >Q15:" .......... >P15:/F$" ......... >O15:" .......... >N15:/F$" ......... >M15:" .......... >L15:/F$" ......... >K15:" .......... >J15:/F$" ......... >I15:" .......... >H15:/F$" . ......... >F16:/F$" ......... >E16:" ......... >D16:/F$" ......... >C16:" ......... >B16:"TOTAL SEC >A16:+A15+1 >Z15:/F$" ......... >Y15:" .......... >X15:/F$" ......... >W15:" .......... >V15:/F$" ......... >U15:" .......... >T15:/F$". >S16:" ......... >R16:/F$" ......... >Q16:" ......... >P16:/F$" ......... >O16:" ......... >N16:/F$" ......... >M16:" ......... >L16:/F$" ......... >K16:" ......... >J16:/F$" ......... >I16:" ......... >H16:/F$" ......... >G16:" AVG MO BAL >T4:" YIELD >S4:" AVG MO BAL >R4:" YIELD >Q4:" AVG MO BAL >P4:" YIELD >O4:" AVG MO BAL >N4:" YIELD >M4:" AVG MO BAL >L4:" YIELD >K4:" AVG MO BAL >J4:" YIELD >I4:" AVG MO BAL >H4:" YIELD >G4:" AVG MO BAL >F4:" YIELD >E4:" AVG MO BAL >D4:" YIELD >C4:" AVG MO BAL >B4:"========= >A4:+A3+1 >Z3:" DEC >Y3:" DEC >X3:" NOV >W3:" NOV >V3:" OCT >U3:" OCT >T3:" SEP >S3:" SEP >R3:" AUG >Q3:" AUG >P3:" JUL >O3:" JUL >N3:" JUN >M3:" JUN >L3:" MAY >K >V42:/F$((V21*U21)+(V23*U23))/(U21+U23) >T42:/F$((T21*S21)+(T23*S23))/(S21+S23) >R42:/F$((R21*Q21)+(R23*Q23))/(Q21+Q23) >P42:/F$((P21*O21)+(P23*O23))/(O21+O23) >N42:/F$((N21*M21)+(N23*M23))/(M21+M23) >L42:/F$((L21*K21)+(L23*K23))/(K21+K23) >J42:/F$((J21*I/100)+((E21*F21)/100)+((E23*F23)/100))/(E33+E21+E23))*100 >D44:/F$((((C33*D33/100)+((C21*D21)/100)+((C23*D23)/100))/(C33+C21+C23))*100 >B44:"COST LIB+CN >A44:+A43+1 >A43:+A42+1 >Z42:/F$((Z21*Y21)+(Z23*Y23))/(Y21+Y23) >X42:/F$((X21*W21)+(X23*W23))/(W21+W23))*100 >L44:/F$((((K33*L33/100)+((K21*L21)/100)+((K23*L23)/100))/(K33+K21+K23))*100 >J44:/F$((((I33*J33/100)+((I21*J21)/100)+((I23*J23)/100))/(I33+I21+I23))*100 >H44:/F$((((G33*H33/100)+((G21*H21)/100)+((G23*H23)/100))/(G33+G21+G23))*100 >F44:/F$((((E33*F33*T23)/100))/(S33+S21+S23))*100 >R44:/F$((((Q33*R33/100)+((Q21*R21)/100)+((Q23*R23)/100))/(Q33+Q21+Q23))*100 >P44:/F$((((O33*P33/100)+((O21*P21)/100)+((O23*P23)/100))/(O33+O21+O23))*100 >N44:/F$((((M33*N33/100)+((M21*N21)/100)+((M23*N23)/100))/(M33+M21+M23)00)+((Y21*Z21)/100)+((Y23*Z23)/100))/(Y33+Y21+Y23))*100 >X44:/F$((((W33*X33/100)+((W21*X21)/100)+((W23*X23)/100))/(W33+W21+W23))*100 >V44:/F$((((U33*V33/100)+((U21*V21)/100)+((U23*V23)/100))/(U33+U21+U23))*100 >T44:/F$((((S33*T33/100)+((S21*T21)/100)+((S23)+((G23*H23)/100))/(G33+G21+G23+G11))*100 >F45:/F$((((E33*F33/100)+((E21*F21)/100)+((E23*F23)/100))/(E33+E21+E23+E11))*100 >D45:/F$((((C33*D33/100)+((C21*D21)/100)+((C23*D23)/100))/(C33+C21+C23+C11))*100 >B45:"CST LIB+CN+D >A45:+A44+1 >Z44:/F$((((Y33*Z33/1(M21*N21)/100)+((M23*N23)/100))/(M33+M21+M23+M11))*100 >L45:/F$((((K33*L33/100)+((K21*L21)/100)+((K23*L23)/100))/(K33+K21+K23+K11))*100 >J45:/F$((((I33*J33/100)+((I21*J21)/100)+((I23*J23)/100))/(I33+I21+I23+I11))*100 >H45:/F$((((G33*H33/100)+((G21*H21)/10033*T33/100)+((S21*T21)/100)+((S23*T23)/100))/(S33+S21+S23+S11))*100 >R45:/F$((((Q33*R33/100)+((Q21*R21)/100)+((Q23*R23)/100))/(Q33+Q21+Q23+Q11))*100 >P45:/F$((((O33*P33/100)+((O21*P21)/100)+((O23*P23)/100))/(O33+O21+O23+O11))*100 >N45:/F$((((M33*N33/100)+(>Z45:/F$((((Y33*Z33/100)+((Y21*Z21)/100)+((Y23*Z23)/100))/(Y33+Y21+Y23+Y11))*100 >X45:/F$((((W33*X33/100)+((W21*X21)/100)+((W23*X23)/100))/(W33+W21+W23+W11))*100 >V45:/F$((((U33*V33/100)+((U21*V21)/100)+((U23*V23)/100))/(U33+U21+U23+U11))*100 >T45:/F$((((S1 /W1 /GOC /GRM /GC12 /X>A1:>A1: >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >C1:"SET YIELDS >B1:"MODEL 7 - AS >A1:3:" MAY >J3:" APR >I3:" APR >H3:" MAR >G3:" MAR >F3:" FEB >E3:" FEB >D3:" JAN >C3:" JAN >B3:"ASSETS >A3:+A2+1 >Z2:" Z >Y2:" Y >X2:" X >W2:" W >V2:" V >U2:" U >T2:" T >S2:" S >R2:" R 21)+(J23*I23))/(I21+I23) >H42:/F$((H21*G21)+(H23*G23))/(G21+G23) >F42:/F$((F21*E21)+(F23*E23))/(E21+E23) >D42:/F$((D21*C21)+(D23*C23))/(C21+C23) >B42:"COST LIB >A42:+A41+1 >A41:+A40+1 >A40:+A39+1 >Y39:+Y22+Y23+Y30+Y37 >W39:+W22+W23+W30+W37 >U39:+U22+U23+U30+U37 >S39:+S22+S23+S30+S37 >Q39:+Q22+Q23+Q30+Q37 >O39:+O22+O23+O30+O37 >M39:+M22+M23+M30+M37 >K39:+K22+K23+K30+K37 >I39:+I22+I23+I30+I37 >G39:+G22+G23+G30+G37 >E39:+E22+E23+E30+E37 >C39:+C22+C23+C30+C37 >B39:"TOT LIB & EQ >A39:+A38+1 >A38:+A37+1 >Y37:+Y3 >K23:" ......... >J23:/F$" ......... >I23:" ......... >H23:/F$" ......... >G23:" ......... >F23:/F$" ......... >E23:" ......... >D23:/F$" ......... >C23:" ......... >B23:"SEC SOLD UAR >A23:+A22+1 >Y22:+Y21+Y11 >W22:+W21+W11 >U22:+U21+U11 ......... >W23:" ......... >V23:/F$" ......... >U23:" ......... >T23:/F$" ......... >S23:" ......... >R23:/F$" ......... >Q23:" ......... >P23:/F$" ......... >O23:" ......... >N23:/F$" ......... >M23:" ......... >L23:/F$" ............. >O26:" ......... >M26:" ......... >K26:" ......... >I26:" ......... >G26:" ......... >E26:" ......... >C26:" ......... >B26:" TAXES >A26:+A25+1 >B25:"OTHER LIB >A25:+A24+1 >A24:+A23+1 >Z23:/F$" ......... >Y23:" ......... >X23:/F$" .... >O27:" ......... >M27:" ......... >K27:" ......... >I27:" ......... >G27:" ......... >E27:" ......... >C27:" ......... >B27:" INT PAY >A27:+A26+1 >Y26:" ......... >W26:" ......... >U26:" ......... >S26:" ......... >Q26:" .....:" .......... >M28:" .......... >K28:" .......... >I28:" .......... >G28:" .......... >E28:" .......... >C28:" .......... >B28:" OTHER EXP >A28:+A27+1 >Y27:" ......... >W27:" ......... >U27:" ......... >S27:" ......... >Q27:" ....... >M29:" .......... >K29:" .......... >I29:" .......... >G29:" .......... >E29:" .......... >C29:" .......... >B29:" ACCT PAY >A29:+A28+1 >Y28:" .......... >W28:" .......... >U28:" .......... >S28:" .......... >Q28:" .......... >O28K30:+K26+K27+K28+K29 >I30:+I26+I27+I28+I29 >G30:+G26+G27+G28+G29 >E30:+E26+E27+E28+E29 >C30:+C26+C27+C28+C29 >B30:"TOT OTH LIB >A30:+A29+1 >Y29:" .......... >W29:" .......... >U29:" .......... >S29:" .......... >Q29:" .......... >O29:" ............ >C33:" ......... >B33:" CAP NOTES >A33:+A32+1 >F32:/F$ >B32:"CAPITAL >A32:+A31+1 >A31:+A30+1 >Y30:+Y26+Y27+Y28+Y29 >W30:+W26+W27+W28+W29 >U30:+U26+U27+U28+U29 >S30:+S26+S27+S28+S29 >Q30:+Q26+Q27+Q28+Q29 >O30:+O26+O27+O28+O29 >M30:+M26+M27+M28+M29 >$" ......... >O33:" ......... >N33:/F$" ......... >M33:" ......... >L33:/F$" ......... >K33:" ......... >J33:/F$" ......... >I33:" ......... >H33:/F$" ......... >G33:" ......... >F33:/F$" ......... >E33:" ......... >D33:/F$" ....." ......... >B34:" CAP STOCK >A34:+A33+1 >Z33:/F$" ......... >Y33:" ......... >X33:/F$" ......... >W33:" ......... >V33:/F$" ......... >U33:" ......... >T33:/F$" ......... >S33:" ......... >R33:/F$" ......... >Q33:" ......... >P33:/F.... >B35:" SURPLUS >A35:+A34+1 >Y34:" ......... >W34:" ......... >U34:" ......... >S34:" ......... >Q34:" ......... >O34:" ......... >M34:" ......... >K34:" ......... >I34:" ......... >G34:" ......... >F34:/F$ >E34:" ......... >C34:. >B36:" UND PROFIT >A36:+A35+1 >Y35:" ......... >W35:" ......... >U35:" ......... >S35:" ......... >Q35:" ......... >O35:" ......... >M35:" ......... >K35:" ......... >I35:" ......... >G35:" ......... >E35:" ......... >C35:" .....>B37:"TOT CAPITAL >A37:+A36+1 >Y36:" ......... >W36:" ......... >U36:" ......... >S36:" ......... >Q36:" ......... >O36:" ......... >M36:" ......... >K36:" ......... >I36:" ......... >G36:" ......... >E36:" ......... >C36:" ........3+Y34+Y35+Y36 >W37:+W33+W34+W35+W36 >U37:+U33+U34+U35+U36 >S37:+S33+S34+S35+S36 >Q37:+Q33+Q34+Q35+Q36 >O37:+O33+O34+O35+O36 >M37:+M33+M34+M35+M36 >K37:+K33+K34+K35+K36 >I37:+I33+I34+I35+I36 >G37:+G33+G34+G35+G36 >E37:+E33+E34+E35+E36 >C37:+C33+C34+C35+C36 >S22:+S21+S11 >Q22:+Q21+Q11 >O22:+O21+O11 >M22:+M21+M11 >K22:+K21+K11 >I22:+I21+I11 >G22:+G21+G11 >E22:+E21+E11 >C22:+C21+C11 >B22:"TOT DEPOSITS >A22:+A21+1 >Z21:/F$" ......... >Y21:" .......... >X21:/F$" ......... >W21:" .......... >V21:/F$" ......... >U21:" .......... >T21:/F$" ......... >S21:" .......... >R21:/F$" ......... >Q21:" .......... >P21:/F$" ......... >O21:" .......... >N21:/F$" ......... >M21:" .......... >L21:/F$" ......... >K21:" .......... >J21:/F$" .......... >Y14:" ......... >X14:/F$" ......... >W14:" ......... >V14:/F$" ......... >U14:" ......... >T14:/F$" ......... >S14:" ......... >R14:/F$" ......... >Q14:" ......... >P14:/F$" ......... >O14:" ......... >N14:/F$" ......... >M14:......... >L15:/F$" ......... >K15:" ......... >J15:/F$" ......... >I15:" ......... >H15:/F$" ......... >G15:" ......... >F15:/F$" ......... >E15:" ......... >D15:/F$" ......... >C15:" ......... >B15:" IRA >A15:+A14+1 >Z14:/F$" ..... >Y15:" ......... >X15:/F$" ......... >W15:" ......... >V15:/F$" ......... >U15:" ......... >T15:/F$" ......... >S15:" ......... >R15:/F$" ......... >Q15:" ......... >P15:/F$" ......... >O15:" ......... >N15:/F$" ......... >M15:" ..... >L16:/F$" ......... >K16:" ......... >J16:/F$" ......... >I16:" ......... >H16:/F$" ......... >G16:" ......... >F16:/F$" ......... >E16:" ......... >D16:/F$" ......... >C16:" ......... >B16:" NOW >A16:+A15+1 >Z15:/F$" .........6:" ......... >X16:/F$" ......... >W16:" ......... >V16:/F$" ......... >U16:" ......... >T16:/F$" ......... >S16:" ......... >R16:/F$" ......... >Q16:" ......... >P16:/F$" ......... >O16:" ......... >N16:/F$" ......... >M16:" ....L17:/F$" ......... >K17:" ......... >J17:/F$" ......... >I17:" ......... >H17:/F$" ......... >G17:" ......... >F17:/F$" ......... >E17:" ......... >D17:/F$" ......... >C17:" ......... >B17:" T-CERT >A17:+A16+1 >Z16:/F$" ......... >Y1........ >X17:/F$" ......... >W17:" ......... >V17:/F$" ......... >U17:" ......... >T17:/F$" ......... >S17:" ......... >R17:/F$" ......... >Q17:" ......... >P17:/F$" ......... >O17:" ......... >N17:/F$" ......... >M17:" ......... >......... >K18:" ......... >J18:/F$" ......... >I18:" ......... >H18:/F$" ......... >G18:" ......... >F18:/F$" ......... >E18:" ......... >D18:/F$" ......... >C18:" ......... >B18:" OTHER CERT >A18:+A17+1 >Z17:/F$" ......... >Y17:" .18:/F$" ......... >W18:" ......... >V18:/F$" ......... >U18:" ......... >T18:/F$" ......... >S18:" ......... >R18:/F$" ......... >Q18:" ......... >P18:/F$" ......... >O18:" ......... >N18:/F$" ......... >M18:" ......... >L18:/F$" .......... >J19:/F$" ......... >I19:" .......... >H19:/F$" ......... >G19:" .......... >F19:/F$" ......... >E19:" .......... >D19:/F$" ......... >C19:" .......... >B19:" ALL SAVERS >A19:+A18+1 >Z18:/F$" ......... >Y18:" ......... >X19:" .......... >V19:/F$" ......... >U19:" .......... >T19:/F$" ......... >S19:" .......... >R19:/F$" ......... >Q19:" .......... >P19:/F$" ......... >O19:" .......... >N19:/F$" ......... >M19:" .......... >L19:/F$" ......... >K19:"/F$" ......... >I20:" ......... >H20:/F$" ......... >G20:" ......... >F20:/F$" ......... >E20:" ......... >D20:/F$" ......... >C20:" ......... >B20:" PUBLIC FND >A20:+A19+1 >Z19:/F$" ......... >Y19:" .......... >X19:/F$" ......... >W.... >V20:/F$" ......... >U20:" ......... >T20:/F$" ......... >S20:" ......... >R20:/F$" ......... >Q20:" ......... >P20:/F$" ......... >O20:" ......... >N20:/F$" ......... >M20:" ......... >L20:/F$" ......... >K20:" ......... >J20:... >I21:" .......... >H21:/F$" ......... >G21:" .......... >F21:/F$" ......... >E21:" .......... >D21:/F$" ......... >C21:" .......... >B21:"TOTAL TIME >A21:+A20+1 >Z20:/F$" ......... >Y20:" ......... >X20:/F$" ......... >W20:" ....." ......... >L14:/F$" ......... >K14:" ......... >J14:/F$" ......... >I14:" ......... >H14:/F$" ......... >G14:" ......... >F14:/F$" ......... >E14:" ......... >D14:/F$" ......... >C14:" ......... >B14:" SAVINGS >A14:+A13+1 >B13:"TIME DEPOSIT >A13:+A12+1 >A12:+A11+1 >Y11:+Y8+Y9+Y10 >W11:+W8+W9+W10 >U11:+U8+U9+U10 >S11:+S8+S9+S10 >Q11:+Q8+Q9+Q10 >O11:+O8+O9+O10 >M11:+M8+M9+M10 >K11:+K8+K9+K10 >I11:+I8+I9+I10 >G11:+G8+G9+G10 >E11:+E8+E9+E10 >C11:+C8+C9+C10 >B11:"TOTAL DEMAND >A11:+A10+122:"BURDEN >A22:+A21+1 >A21:+A20+1 >O20:/F$+O6-O17 >N20:/F$+N6-N17 >M20:/F$+M6-M17 >L20:/F$+L6-L17 >K20:/F$+K6-K17 >J20:/F$+J6-J17 >I20:/F$+I6-I17 >H20:/F$+H6-H17 >G20:/F$+G6-G17 >F20:/F$+F6-F17 >E20:/F$+E6-E17 >D20:/F$+D6-D17 >C20:" DEPOSIT >B20:" DEMANE >A24:+A23+1 >A23:+A22+1 >O22:/F$" ..... >N22:/F$" ..... >M22:/F$" ..... >L22:/F$" ..... >K22:/F$" ..... >J22:/F$" ..... >I22:/F$" ..... >H22:/F$" ..... >G22:/F$" ..... >F22:/F$" ..... >E22:/F$" ..... >D22:/F$" ..... >B>O24:/F$" ..... >N24:/F$" ..... >M24:/F$" ..... >L24:/F$" ..... >K24:/F$" ..... >J24:/F$" ..... >I24:/F$" ..... >H24:/F$" ..... >G24:/F$" ..... >F24:/F$" ..... >E24:/F$" ..... >D24:/F$" ..... >C24:"N YIELD >B24:"BREAK EV F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >D1:"ITIES >C1:"ST OF LIABIL >B1:"MODEL 8 - CO >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: >Y2:" Y >X2:" X >W2:" W >V2:" V >U2:" U >T2:" T >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" 3:" SEP >S3:" SEP >R3:" AUG >Q3:" AUG >P3:" JUL >O3:" JUL >N3:" JUN >M3:" JUN >L3:" MAY >K3:" MAY >J3:" APR >I3:" APR >H3:" MAR >G3:" MAR >F3:" FEB >E3:" FEB >D3:" JAN >C3:" JAN >A3:+A2+1 >Z2:" ZAVG MO BAL >L4:" YIELD >K4:" AVG MO BAL >J4:" YIELD >I4:" AVG MO BAL >H4:" YIELD >G4:" AVG MO BAL >F4:" YIELD >E4:" AVG MO BAL >D4:" YIELD >C4:" AVG MO BAL >A4:+A3+1 >Z3:" DEC >Y3:" DEC >X3:" NOV >W3:" NOV >V3:" OCT >U3:" OCT >T============ >A6:+A5+1 >B5:"LIABILITIES >A5:+A4+1 >Z4:" YIELD >Y4:" AVG MO BAL >X4:" YIELD >W4:" AVG MO BAL >V4:" YIELD >U4:" AVG MO BAL >T4:" YIELD >S4:" AVG MO BAL >R4:" YIELD >Q4:" AVG MO BAL >P4:" YIELD >O4:" AVG MO BAL >N4:" YIELD >M4:" .. >W8:" ......... >U8:" ......... >S8:" ......... >Q8:" ......... >O8:" ......... >M8:" ......... >K8:" ......... >I8:" ......... >G8:" ......... >E8:" ......... >C8:" ......... >B8:" DEMAND >A8:+A7+1 >B7:"DEMAND DEP >A7:+A6+1 >B6:"Y9:" ......... >W9:" ......... >U9:" ......... >S9:" ......... >Q9:" ......... >O9:" ......... >M9:" ......... >K9:" ......... >I9:" ......... >G9:" ......... >E9:" ......... >C9:" ......... >B9:" TRES TAX >A9:+A8+1 >Y8:" ....... >Y10:" ......... >W10:" ......... >U10:" ......... >S10:" ......... >Q10:" ......... >O10:" ......... >M10:" ......... >K10:" ......... >I10:" ......... >G10:" ......... >E10:" ......... >C10:" ......... >B10:" SUNDRY >A10:+A9+1 >D >A20:+A19+1 >D19:"TH >C19:"MARGIN WI >B19:"INTEREST >A19:+A18+1 >A18:+A17+1 >O17:" ..... >N17:" ..... >M17:" ..... >L17:" ..... >K17:" ..... >J17:" ..... >I17:" ..... >H17:" ..... >G17:" ..... >F17:" ..... >E17:" ..... >D17:" ..... >C17:" DEPOSIT >B17:" DEMAND >A17:+A16+1 >D16:"H >C16:"ITIES WIT >B16:"COST LIAB >A16:+A15+1 >A15:+A14+1 >O14:/F$+O6-O12 >N14:/F$+N6-N12 >M14:/F$+M6-M12 >L14:/F$+L6-L12 >K14:/F$+K6-K12 >J14:/F$+J6-J12 >I14:/F$+I6-I12 >H14:/F$+H6-H12 >G14:/F*.85)/J58*100 >I178:/F$+I81+(T99*.85)/I58*100 >H178:"......... >G178:".......... >D178:"ASSETS >C178:" EARNING >B178:" AVERAGE >E177:"O >D177:"E (FTE) TO >C177:"EST INCOM >B177:"NET INTER >W176:/FI+W158-W173 >V176:/FI+V158-V173 >U176:/FI+U158-U173 >T176:56*100 >G181:/F$ >C181:" ASSETS >B181:" AVERAGE >V180:6 >U180:5 >T180:4 >S180:3 >R180:2 >Q180:1 >P180:"YEAR >O180:"MONTH OF >D180:"SE TO >C180:"EAD EXPEN >B180:"NET OVERH >L178:/F$+L81+(W99*.85)/L58*100 >K178:/F$+K81+(V99*.85)/K58*100 >J178:/F$+J81+(U99"MONTH OF >D183:"SE TO >C183:"EST EXPENSE >B183:"NON-INTEREST >V181:2 >U181:2.4 >T181:3 >S181:4 >R181:6 >Q181:12 >P181:"N FACTOR >O181:"CONVERSION >L181:/F$-L100/L56*100 >K181:/F$-K100/K56*100 >J181:/F$-J100/J56*100 >I181:/F$-I100/I56*100 >H181:/F$-H100/H >P184:"N FACTOR >O184:"CONVERSION >L184:/F$+L97/L56*100 >K184:/F$+K97/K56*100 >J184:/F$+J97/J56*100 >I184:/F$+I97/I56*100 >H184:/F$+H97/H56*100 >G184:/F$ >C184:" ASSETS >B184:" AVERAGE >V183:12 >U183:11 >T183:10 >S183:9 >R183:8 >Q183:7 >P183:"YEAR >O183:>W187:@IF(W4<7,@LOOKUP(W4,Q180...V180),@LOOKUP(W4,Q183...V183)) >V187:"ONTH ---> >U187:"CURRENT M >T187:"CTOR FOR >S187:"ERSION FACT >R187:" CONVER >Q187:+W4 >P187:"ONTH ---> >O187:"CURRENT M >V184:1 >U184:1.09 >T184:1.2 >S184:1.33 >R184:1.5 >Q184:1.71 K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >D1:" MARGIN >C1:" INTEREST >B1:"MODEL 9 - COMPARAT >A1:1 /W1 /GOC /GRM /GC9 /X>A1:>A1: = >E4:" ===== >D4:" ===== >A4:+A3+1 >O3:/FR"DEC >N3:/FR"NOV >M3:/FR"OCT >L3:/FR"SEP >K3:/FR"AUG >J3:/FR"JUL >I3:/FR"JUN >H3:/FR"MAY >G3:/FR"APR >F3:/FR" MAR >E3:/FR" FEB >D3:/FR" JAN >A3:+A2+1 >O2:" O >N2:" N >M2:" M >L2:" L >K2:" ..... >E6:/F$" ..... >D6:/F$" ..... >B6:" ASSETS >A6:+A5+1 >C5:"EARNING >B5:"YIELD ON >A5:+A4+1 >O4:" ===== >N4:" ===== >M4:" ===== >L4:" ===== >K4:" ===== >J4:" ===== >I4:" ===== >H4:" ===== >G4:" ===== >F4:" ====9:"L NOTES >B9:" CAPITA >A9:+A8+1 >C8:"ITIES W/O >B8:"COST LIAB >A8:+A7+1 >A7:+A6+1 >O6:/F$" ..... >N6:/F$" ..... >M6:/F$" ..... >L6:/F$" ..... >K6:/F$" ..... >J6:/F$" ..... >I6:/F$" ..... >H6:/F$" ..... >G6:/F$" ..... >F6:/F$"B11:"COST LIAB >A11:+A10+1 >A10:+A9+1 >O9:/F$" ..... >N9:/F$" ..... >M9:/F$" ..... >L9:/F$" ..... >K9:/F$" ..... >J9:/F$" ..... >I9:/F$" ..... >H9:/F$" ..... >G9:/F$" ..... >F9:/F$" ..... >E9:/F$" ..... >D9:/F$" ..... >CM12:/F$" ..... >L12:/F$" ..... >K12:/F$" ..... >J12:/F$" ..... >I12:/F$" ..... >H12:/F$" ..... >G12:/F$" ..... >F12:/F$" ..... >E12:/F$" ..... >D12:/F$" ..... >C12:"L NOTES >B12:" CAPITA >A12:+A11+1 >D11:"H >C11:"ITIES WIT >$+G6-G12 >F14:/F$+F6-F12 >E14:/F$+E6-E12 >D14:/F$+D6-D12 >C14:"MARGIN >B14:"INTEREST >A14:+A13+1 >O13:/F$ >N13:/F$ >M13:/F$ >L13:/F$ >K13:/F$ >J13:/F$ >I13:/F$ >H13:/F$ >G13:/F$ >F13:/F$ >E13:/F$ >D13:/F$ >A13:+A12+1 >O12:/F$" ..... >N12:/F$" ..... >/FI+T158-T173 >S176:" (LOSSES) >R176:"ITY GAINS >Q176:" OF SECURITY >P176:"AX EFFECT >O176:" 3. TA >W174:" ========== >V174:" ========== >U174:" ========== >T174:" ========== >W173:/FI@SUM(W166...W172) >V173:/FI@SUM(V166...V172) >U173:/FI@SUM(U166...U172) >T173:/FI@SUM(T166...T172) >R173:"FIT) >Q173:"TAX (BENEFIT >P173:" INCOME >W172:" -------- >V172:" -------- >U172:" -------- >T172:" -------- >L172:/F$+L154+W131/L140*100 >K172:/F$+K154+V131/K140*100 >J172:/F$+J154+U131/J140*100 >I172:/F$+I154+T131/I1IF(W147<51,0,(W147-50)*R154) >V154:/FI@IF(V147>75,25*R154,@IF(V147<51,0,(V147-50)*R154) >U154:/FI@IF(U147>75,25*R154,@IF(U147<51,0,(U147-50)*R154) >T154:/FI@IF(T147>75,25*R154,@IF(T147<51,0,(T147-50)*R154) >R154:/FG.3 >L154:/FI+L39 >K154:/FI+K39 >J154:/FI+5*R155,@IF(W147<76,0,(W147-75)*R155) >V155:/FI@IF(V147>100,25*R155,@IF(V147<76,0,(V147-75)*R155) >U155:/FI@IF(U147>100,25*R155,@IF(U147<76,0,(U147-75)*R155) >T155:/FI@IF(T147>100,25*R155,@IF(T147<76,0,(T147-75)*R155) >R155:.4 >W154:/FI@IF(W147>75,25*R154,@7-100*R156,0) >U156:/FI@IF(U147>100,U147-100*R156,0) >T156:/FI@IF(T147>100,T147-100*R156,0) >R156:.46 >L156:+L36 >K156:+K36 >J156:+J36 >I156:+I36 >H156:+H36 >G156:+G36 >E156:"ITTED) >D156:"T (000 OM >C156:"NATED DEB >B156:" SUBORDI >W155:/FI@IF(W147>100,2...G156) >C158:"TOTAL >W157:" -------- >V157:" -------- >U157:" -------- >T157:" -------- >L157:" -------- >K157:" -------- >J157:" -------- >I157:" -------- >H157:" -------- >G157:" -------- >W156:/FI@IF(W147>100,W147-100*R156,0) >V156:/FI@IF(V147>100,V14...U157) >T158:/FI@SUM(T151...T157) >S158:"IONS >R158:"OM OPERAT >Q158:"NEFIT) FROM >P158:" TAX (BEN >L158:/FI@SUM(L154...L156) >K158:/FI@SUM(K154...K156) >J158:/FI@SUM(J154...J156) >I158:/FI@SUM(I154...I156) >H158:/FI@SUM(H154...H156) >G158:/FI@SUM(G1542. TA >W159:" ========== >V159:" ========== >U159:" ========== >T159:" ========== >L159:" ======== >K159:" ======== >J159:" ======== >I159:" ======== >H159:" ======== >G159:" ======== >W158:/FI@SUM(W151...W157) >V158:/FI@SUM(V151...V157) >U158:/FI@SUM(U151ATIO OF >R164:" TAX RATE >C163:"====== >W162:/FI+K103-W99+W102 >V162:/FI+J103-V99+V102 >U162:/FI+I103-U99+U102 >T162:/FI+H103-T99+T102 >R162:"LOSSES >Q162:"GAINS OR >P162:"SECURITY >C162:"RATIOS >R161:"R >Q161:"COME AFTER >P161:"AXABLE INC >O161:" IF(U162<0,-U162*R166,0) >T166:/FI@IF(T162<0,-T162*R166,0) >S166:" (NOL) >R166:-.46 >L166:/F$+L52 >K166:/F$+K52 >J166:/F$+J52 >I166:/F$+I52 >H166:/F$+H52 >G166:/F$+G52 >C166:"SSETS >B166:" TOTAL AS >R165:" ========= >D165:"UNDS TO >C165:"CAPITAL F >B165:"R167)) >V167:/FI@IF(V162<0,0,@IF(V162>25,25*R167,V162*R167)) >U167:/FI@IF(U162<0,0,@IF(U162>25,25*R167,U162*R167)) >T167:/FI@IF(T162<0,0,@IF(T162>25,25*R167,T162*R167)) >R167:.16 >W166:/FI@IF(W162<0,-W162*R166,0) >V166:/FI@IF(V162<0,-V162*R166,0) >U166:/FI@26,0,(W162-50)*R168) >V168:/FI@IF(V162>50,25*R168,@IF(V162<26,0,(V162-50)*R168) >U168:/FI@IF(U162>50,25*R168,@IF(U162<26,0,(U162-50)*R168) >T168:/FI@IF(T162>50,25*R168,@IF(T162<26,0,(T162-50)*R168) >R168:.19 >W167:/FI@IF(W162<0,0,@IF(W162>25,25*R167,W162*R >T169:/FI@IF(T162>75,25*R169,@IF(T162<51,0,(T162-50)*R169) >R169:/FG.3 >L169:/F$+L54 >K169:/F$+K54 >J169:/F$+J54 >I169:/F$+I54 >H169:/F$+H54 >G169:/F$+G54 >E169:"SETS >D169:" TOTAL AS >C169:"EQUITY TO >B169:"RATIO OF >W168:/FI@IF(W162>50,25*R168,@IF(W162<-75)*R170) >T170:/FI@IF(T162>100,25*R170,@IF(T162<76,0,(T162-75)*R170) >R170:.4 >W169:/FI@IF(W162>75,25*R169,@IF(W162<51,0,(W162-50)*R169) >V169:/FI@IF(V162>75,25*R169,@IF(V162<51,0,(V162-50)*R169) >U169:/FI@IF(U162>75,25*R169,@IF(U162<51,0,(U162-50)*R169)62-100*R171,0) >R171:.46 >E171:"SETS >D171:" TOTAL AS >C171:"EQUITY TO >B171:"RATIO OF >W170:/FI@IF(W162>100,25*R170,@IF(W162<76,0,(W162-75)*R170) >V170:/FI@IF(V162>100,25*R170,@IF(V162<76,0,(V162-75)*R170) >U170:/FI@IF(U162>100,25*R170,@IF(U162<76,0,(U16240*100 >H172:/F$+H154+S131/H140*100 >G172:"......... >E172:"E >D172:"BT RESERVE >C172:"NG BAD DEB >B172:" INCLUDI >W171:/FI@IF(W162>100,W162-100*R171,0) >V171:/FI@IF(V162>100,V162-100*R171,0) >U171:/FI@IF(U162>100,U162-100*R171,0) >T171:/FI@IF(T162>100,T1J39 >I154:/FI+I39 >H154:/FI+H39 >G154:+G39 >E154:"TED) >D154:"(000 0MIT >B154:" EQUITY >W153:/FI@IF(W147>50,25*R153,@IF(W147<26,0,(W147-50)*R153) >V153:/FI@IF(V147>50,25*R153,@IF(V147<26,0,(V147-50)*R153) >U153:/FI@IF(U147>50,25*R153,@IF(U147<26,0,(U147-50)*R153) >T153:/FI@IF(T147>50,25*R153,@IF(T147<26,0,(T147-50)*R153) >R153:.19 >W152:/FI@IF(W147<0,0,@IF(W147>25,25*R152,W147*R152)) >V152:/FI@IF(V147<0,0,@IF(V147>25,25*R152,V147*R152)) >U152:/FI@IF(U147<0,0,@IF(U147>25,25*R152,U147*R152)) >T152:/FI@IF(T14NT >P121:"DATA : >O121:"COMPUTED >R116:"GE) >Q116:"HE % CHAN >P116:"TEAD OF TH >O116:" INSTEAD >W115:" -------- >V115:" -------- >U115:" -------- >T115:" -------- >R115:"ION TO OR >Q115:" IN ADDITION >P115:"IS CAN BE >O115:" (TH >W114:".........========= >T123:"========== >S123:"========== >R123:"========== >Q123:"========== >P123:"========== >O123:"========= >W122:"......... >V122:"......... >U122:"......... >T122:"......... >S122:"S LINE. >R122:"BELOW THIS LIN >Q122:"TER DATA BE >P122:"DO NOT E B. SHAREHOL >L127:/F$ >K127:/F$ >J127:/F$ >I127:/F$ >H127:/F$ >G127:/F$ >W125:/FI+K24*W12/100+K24 >V125:/FI+J24*V12/100+J24 >U125:/FI+I24*U12/100+I24 >T125:/FI+H24*T12/100+H24 >P125:"L ASSETS >O125:" A. TOTAL >W123:"========== >V123:"========== >U123:"=FI+K56*V60/100 >U129:/FI+J56*U60/100 >T129:/FI+I56*T60/100 >R129:" AMOUNT >Q129:"NG ASSETS >P129:"AGE EARNI >O129:" C. AVER >W127:/FI+K39-W53+L109 >V127:/FI+J39-V53+K109 >U127:/FI+I39-U53+J109 >T127:/FI+H39-T53+I109 >Q127:" EQUITY >P127:"EHOLDERS' >O127:"+U74 >T133:/F$+T77+T74 >Q133:"ME >P133:"REST INCOM >O133:" E. INTEREST >W131:/FI+L18*W109/100 >V131:/FI+K18*V109/100 >U131:/FI+J18*U109/100 >T131:/FI+I18*T109/100 >P131:" RESERVE >O131:" D. LOAN >H130:"MARY >G130:" SUM >W129:/FI+L56*W60/100 >V129:/I77+(T99*.85)/I58*100 >R135:"S (FTE) >Q135:"ING ASSET >P135:"D ON EARN >O135:" F. YIEL >L135:"......... >K135:"......... >J135:"......... >I135:"......... >H135:"......... >G135:"......... >H134:"PROJECTED >W133:/F$+W77+W74 >V133:/F$+V77+V74 >U133:/F$+U77>I137:" (000) >H137:" (000) >G137:" (000) >L136:" ======== >K136:" ======== >J136:" ======== >I136:" ======== >H136:" ======== >G136:" ======== >W135:/F$+L77+(W99*.85)/L58*100 >V135:/F$+K77+(V99*.85)/K58*100 >U135:/F$+J77+(U99*.85)/J58*100 >T135:/F$+SET >W137:/F$+L97-K97/K97*100 >V137:/F$+K97-J97/J97*100 >U137:/F$+J97-I97/I97*100 >T137:/F$+I97-H97/H97*100 >S137:"SES >R137:"HER EXPENSES >Q137:"ASE IN OTHER EX >P137:"L % INCREASE IN >O137:" G. TOTAL % IN >L137:" (000) >K137:" (000) >J137:" (000) (000 0MIT >B140:" AMOUNT >Y139:/F$ >W139:/F$+L87/L97*100 >V139:/F$+K87/K97*100 >U139:/F$+J87/J97*100 >T139:/F$+I87/I97*100 >S139:"EXPENSES >R139:"TO OTHER EXP. >Q139:"R INCOME TO OTHER >P139:"O OF OTHER INC >O139:" H. RATIO OF >C138:"ETS- >B138:"TOTAL AS100 >U141:/F$+J79/(J28+J29)*100 >T141:/F$+I79/(I28+I29)*100 >S141:"WED FUNDS >R141:". & BORRO >Q141:" % OF DEP. >P141:" EXP.AS A >O141:" I. INT. >L140:/FI+L44 >K140:/FI+K44 >J140:/FI+J44 >I140:/FI+I44 >H140:/FI+H44 >G140:/FI".......... >D140:"TED) >C140:"NCOM >W144:/FI >V144:/FI >U144:/FI >Q144:"ON >P144:"COMPUTATION >O144:" J. TAX >L142:/F$+L50 >K142:/F$+K50 >J142:/F$+J50 >I142:/F$+I50 >H142:/F$+H50 >G142:/F$ >D142:"(%) >C142:" GROWTH >B142:" PERCENT >W141:/F$+L79/(L28+L29)*100 >V141:/F$+K79/(K28+K29)* >P147:"SECURITY >L147:/F$+L114 >K147:/F$+K114 >J147:/F$+J114 >I147:/F$+I114 >H147:/F$+H114 >G147:/F$+G114 >E147:" (%) >D147:"E ASSETS >C147:"ON AVERAG >B147:" RETURN >R146:"RE >Q146:"COME BEFO >P146:"AXABLE INC >O146:" 1. TA >C145:"E- >B145:"NET I >R149:" TAX RATE >L149:/FI+L109 >K149:/FI+K109 >J149:/FI+J109 >I149:/FI+I109 >H149:/FI+H109 >G149:/FI+G109 >D149:"TED) >C149:"(000 0MIT >B149:" AMOUNT >W147:/FI+K103-W99 >V147:/FI+J103-V99 >U147:/FI+I103-U99 >T147:+H103-T99 >R147:"LOSSES >Q147:"GAINS OR7<0,0,@IF(T147>25,25*R152,T147*R152)) >R152:.16 >C152:"UNDS- >B152:"CAPITAL F >W151:/FI@IF(W147<0,-W147*R151,0) >V151:/FI@IF(V147<0,-V147*R151,0) >U151:/FI@IF(U147<0,-U147*R151,0) >T151:/FI@IF(T147<0,-T147*R151,0) >S151:" (NOL) >R151:-.46 >R150:" ========= >V114:"......... >U114:"......... >T114:"......... >S114:"ASE >R114:" OR DECRE >Q114:" INCREASE >P114:"AR AMT OF >O114:" A. DOLLAR >L114:/F$+L109/L56*100 >K114:/F$+K109/K56*100 >J114:/F$+J109/J56*100 >I114:/F$+I109/I56*100 >H114:/F$+H109/H56*100 >G114:/F$+G109/G56*100 >D114:"ASSETS >C114:" AVERAGE >B114:"RETURN ON >P112:"========= >O112:"========== >P111:"BENIFITS >O111:"SALARY & >W110:" -------- >V110:" -------- >U110:" -------- >T110:" -------- >M110:" ========= >L110:" ========= >K110:" ========= >J1... >T90:/F$"......... >P90:"CUPANCY >O90:" 2. OCC >W89:" -------- >V89:" -------- >U89:" -------- >T89:" -------- >C89:"ENSE: >B89:"OTHER EXPE >W88:/F$"......... >V88:/F$"......... >U88:/F$"......... >T88:/F$"......... >Q88:"NEFITS >P88:"LARY & BE >O88......... >L91:/FI+K91*W88/100+K91+W114 >K91:/FI+J91*V88/100+J91+V114 >J91:/FI+I91*U88/100+I91+U114 >I91:/FI+H91*T88/100+H91+T114 >H91:+M91*W187 >G91:"......... >D91:"ITS >C91:"S & BENEF >B91:" SALARIE >W90:/F$"......... >V90:/F$"......... >U90:/F$"......93 >I93:/FI+H93*T90/100+H93 >H93:+M93*W187 >G93:"......... >C93:"CY >B93:" OCCUPAN >W92:/F$"......... >V92:/F$"......... >U92:/F$"......... >T92:/F$"......... >P92:"HER >O92:" 3. OT >W91:" -------- >V91:" -------- >U91:" -------- >T91:" -------- >M91:"....... >U94:"......... >T94:"......... >R94:" AMONT) >Q94:"N (DOLLAR >P94:" PROVISION >O94:"LOAN LOSS >W93:" -------- >V93:" -------- >U93:" -------- >T93:" -------- >M93:"......... >L93:/FI+K93*W90/100+K93 >K93:/FI+J93*V90/100+J93 >J93:/FI+I93*U90/100+I------ >W95:" -------- >V95:" -------- >U95:" -------- >T95:" -------- >M95:"......... >L95:/FI+K95*W92/100+K95 >K95:/FI+J95*V92/100+J95 >J95:/FI+I95*U92/100+I95 >I95:/FI+H95*T92/100+H95 >H95:+M95*W187 >G95:"......... >B95:" OTHER >W94:"......... >V94:"..5) >I97:/FI@SUM(I91...I95) >H97:@SUM(H91...H95) >G97:@SUM(G91...G96) >D97:"XPENSE >C97:"L OTHER E >B97:" TOTAL >P96:"PTION: >O96:"TAX ASSUM >M96:" --------- >L96:" --------- >K96:" --------- >J96:" --------- >I96:" --------- >H96:" --------- >G96:" ---G"......... >U99:/FG"......... >T99:/FG"......... >S99:"T) >R99:"LAR AMOUNT) >Q99:"COME (DOLLAR >P99:"EXEMPT INCOME >O99:" A. TAX >T98:/FG >P97:"====== >O97:/-= >M97:/FI@SUM(M91...M95) >L97:/FI@SUM(L91...L95) >K97:/FI@SUM(K91...K95) >J97:/FI@SUM(J91...J9" -------- >V100:" -------- >U100:" -------- >T100:" -------- >M100:/FI+M87-M97 >L100:/FI+L87-L97 >K100:/FI+K87-K97 >J100:/FI+J87-J97 >I100:/FI+I87-I97 >H100:/FI+H87-H97 >G100:+G87-G97 >D100:"NSE >C100:"TING EXPE >B100:"NET OPERA >W99:/FG"......... >V99:/F >V102:"......... >U102:"......... >T102:"......... >R102:"SSES >Q102:"S OR -LOSSES >P102:"RITY GAINS >O102:" B. SECURITY >M101:" --------- >L101:" --------- >K101:" --------- >J101:" --------- >I101:" --------- >H101:" --------- >G101:" --------- >W100:>U103:" -------- >T103:" -------- >M103:/FI+M85+M100 >L103:/FI+L85+L100 >K103:/FI+K85+K100 >J103:/FI+J85+J100 >I103:/FI+I85+I100 >H103:/FI+H85+H100 >G103:/FI+G85+G100 >E103:"ITY GAINS >D103:"S & SECURI >C103:"FORE TAXES >B103:"INCOME BEFOR >W102:".........S, NE >B107:"SECURITY >P106:"RVE: >O106:"LOAN RESERVE >L105:/FI+W158 >K105:/FI+V158 >J105:/FI+U158 >I105:/FI+T158 >H105:/FI"......... >G105:"......... >E105:"PERATIONS >D105:"T) FROM O >C105:"X (BENEFIT) >B105:"INCOME TA >W103:" -------- >V103:" -------- -- >W107:/FG >V107:/FG >U107:/FG >T107:/FG >S107:/FG >R107:/FG >Q107:/FG >P107:"==== >O107:/-= >L107:/FI+W102+W176 >K107:/FI+V102+V176 >J107:/FI+U102+U176 >I107:/FI+T102+T176 >H107:".......... >G107:"......... >E107:"TED TAX >D107:"T OF RELATED >C107:"GAIN:/FI+K103-K105+K107 >J109:/FI+J103-J105+J107 >I109:/FI+I103-I105+I107 >H109:+H103-H105+H107 >G109:+G103-G105+G107 >C109:"E >B109:"NET INCOM >M108:" -------- >L108:" -------- >K108:" -------- >J108:" -------- >I108:" -------- >H108:" -------- >G108:" ------10:" ========= >I110:" ========= >H110:" ========= >G110:" ========= >W109:".......... >V109:"......... >U109:"......... >T109:"......... >R109:" NET >Q109:"TO LOANS, >P109:" RESERVE >O109:" A. LOAN >M109:/FI+M103-M105+M107 >L109:/FI+L103-L105+L107 >K109:" 1. SALA >M88:" --------- >L88:" --------- >K88:" --------- >J88:" --------- >I88:" --------- >H88:" --------- >G88:" --------- >M87:"......... >L87:/FI+K87*W84/100+K87 >K87:/FI+J87*V84/100+J87 >J87:/FI+I87*U84/100+I87 >I87:/FI+H87*T84/100+H87 >H87:+M87*W187 >G87:"......... >C87:"OME >B87:"OTHER INCOME >R86:" CHANGE) >Q86:" (PERCENT >P86:"R EXPENSE >O86:" B. OTHER >M86:" --------- >L86:" --------- >K86:" --------- >J86:" --------- >I86:" --------- >H86:" --------- >G86:" --------- >W85:" -------- >V8/F$+J42/J44*100 >I52:/F$+I42/I44*100 >H52:/F$+H42/H44*100 >G52:/F$+G42/G44*100 >D52:"ATIO >C52:"O ASSET R >B52:"CAPITAL T >W51:" -------- >V51:" -------- >U51:" -------- >T51:" -------- >W50:"......... >V50:"......... >U50:"......... >T50:"......... >P50:"/F$+I39/I44*100 >H54:/F$+H39/H44*100 >G54:/F$+G39/G44*100 >E54:"IO >D54:"ASSET RATIO >C54:"PITAL TO >B54:"EQUITY CA >W53:"......... >V53:"......... >U53:"......... >T53:"......... >P53:"DEND >O53:" D. DIVIDE >L52:/F$+L42/L44*100 >K52:/F$+K42/K44*100 >J52:+L24/2 >K56:/FI+J24+K24/2 >J56:/FI+I24+J24/2 >I56:/FI+H24+I24/2 >H56:"......... >G56:"......... >C56:"SSETS >B56:"AVERAGE A >W54:" -------- >V54:" -------- >U54:" -------- >T54:" -------- >L54:/F$+L39/L44*100 >K54:/F$+K39/K44*100 >J54:/F$+J39/J44*100 >I54:....... >R60:"CENT >Q60:"SSET- PERC >P60:"EARNING A >O60:" B. AVG. >P58:"== >O58:/-= >L58:/FI+W129 >K58:/FI+V129 >J58:/FI+U129 >I58:/FI+T129 >H58:"......... >G58:"......... >D58:"SETS >C58:"ARNING ASS >B58:"AVERAGE E >P57:"A: >O57:"OTHER DAT >L56:/FI+K24.. >M68:" CURRENT >M67:" THIS COL >I67:"N >H67:"PROJECTIO >G67:"OUR YEAR >F67:" F >M66:" INPUT IN >C64:/FL >B64:/FL >W61:" -------- >V61:" -------- >U61:" -------- >T61:" -------- >W60:/F$"......... >V60:/F$"......... >U60:/F$"......... >T60:/F$"..>Q70:"=== >P70:/-= >O70:/-= >M70:" INCOME & >W69:" ======== >V69:" ======== >U69:" ======== >T69:" ======== >Q69:"NS: >P69:"ASSUMPTIONS >O69:"INTEREST >M69:"YEAR, YTD >H69:" OF RUN >G69:/FR"DATE >W68:"......... >V68:"......... >U68:"......... >T68:".......======= >G74:" ========= >M73:"......... >L73:"......... >K73:"......... >J73:"......... >I73:"......... >H73:"......... >G73:"......... >R72:"NG ASSETS >Q72:"AGE EARNI >P72:"D ON AVERAGE >O72:" A. BASED >M72:" DATA >I72:"D >H72:" PROJECTED >M71:" EXENSE (000) >H75:" (000) >G75:" (000) >W74:/F$"......... >V74:/F$"......... >U74:/F$"......... >T74:/F$"......... >Q74:"T MARGIN >P74:"T INTEREST >O74:" 1. NET >M74:" ========= >L74:" ========= >K74:" ========= >J74:" ========= >I74:" ========= >H74:" ==:"PENSE >P77:"TEREST EXP >O77:" 2. INTER >M77:"........ >L77:/FI+L79+L81 >K77:/FI+K79+K81 >J77:/FI+J79+J81 >I77:/FI+I79+I81 >H77:/FI+M77*W187 >G77:"........ >C77:"INCOME >B77:"INTEREST >M75:" (000) >L75:" (000) >K75:" (000) >J75:" (000) >I75:" 129/100 >J79:/FI+U77*U129/100 >I79:/FI+T77*T129/100 >H79:+M79*W187 >G79:"......... >C79:"EXPENSE >B79:"INTEREST >W78:" -------- >V78:" -------- >U78:" -------- >T78:" -------- >W77:/F$"......... >V77:/F$"......... >U77:/F$"......... >T77:/F$"......... >Q77 >I81:/FI+T74*T129/100 >H81:+G77-G79 >G81:+G77-G79 >D81:"E >C81:"EST INCOME >B81:"NET INTER >M80:" -------- >L80:" -------- >K80:" -------- >J80:" -------- >I80:" -------- >H80:" -------- >G80:" -------- >M79:"......... >L79:/FI+W77*W129/100 >K79:/FI+V77*V+V94 >J83:+U94 >I83:+T94 >H83:+M83*W187 >G83:"......... >D83:" LOSSES >C83:" FOR LOAN >B83:"PROVISION >Q82:"==== >P82:/-= >O82:/-= >Q81:"NSE: >P81:"TING EXPEN >O81:"NET OPERATI >M81:+M77-M79 >L81:/FI+W74*W129/100 >K81:/FI+V74*V129/100 >J81:/FI+U74*U129/100...... >U84:/F$"......... >T84:/F$"......... >R84:"CHANGE) >Q84:"(PERCENT >P84:"R INCOME >O84:" A. OTHER >M84:" --------- >L84:" --------- >K84:" --------- >J84:" --------- >I84:" --------- >H84:" --------- >G84:" --------- >M83:"......... >L83:+W94 >K83:5:" -------- >U85:" -------- >T85:" -------- >M85:/FI+M81-M83 >L85:/FI+L81-L83 >K85:/FI+K81-K83 >J85:/FI+J81-J83 >I85:/FI+I81-I83 >H85:+H81-H83 >G85:+G81-G83 >E85:"ROVISION >D85:"E AFTER PROV >C85:"EST INCOME >B85:"NET INTER >W84:/F$"......... >V84:/F$"...TAL NOTE >O50:" B. CAPITAL >L50:/F$+L44-K44/K44*100 >K50:/F$+K44-J44/J44*100 >J50:/F$+J44-I44/I44*100 >I50:/F$+I44-H44/H44*100 >H50:/F$+H44-G44/G44*100 >G50:/F$ >C50:"WTH >B50:"ASSET GRO >W48:" -------- >V48:" -------- >U48:" -------- >T48:" -------- >L48:/F$ >K48:/F$ >J48:/F$ >I48:/F$ >H48:/F$ >G48:/F$ >W47:/F$"......... >V47:/F$"......... >U47:/F$"......... >T47:/F$"......... >Q47:"BILITIES >P47:"CRUED LIA >O47:" 2. ACCR >L45:" ======== >K45:" ======== >J45:" ======== >I45:" ======== >H45:" ======== >23:" --------- >H23:" --------- >G23:" --------- >W22:/F$"......... >V22:/F$"......... >U22:/F$"......... >T22:/F$"......... >R22:"ANKS >Q22:"F OTHER B >P22:"ME DEP. O >O22:" 3. TI >L22:/FI+W125*W32/100 >K22:/FI+V125*V32/100 >J22:/FI+U125*U32/100 >I22:/...K22) >J24:/FI@SUM(J15...J22) >I24:/FI@SUM(I15...I22) >H24:@SUM(H15...H23) >G24:@SUM(G15...G22) >D24:"S >C24:" RESOURCES >B24:" TOTAL >W23:" -------- >V23:" -------- >U23:" -------- >T23:" -------- >L23:" --------- >K23:" --------- >J23:" --------- >I -------- >L25:" ======== >K25:" ======== >J25:" ======== >I25:" ======== >H25:" ======== >G25:" ======== >W24:/F$"......... >V24:/F$"......... >U24:/F$"......... >T24:/F$"......... >P24:"ANS, NET >O24:" 4. LOANS >L24:/FI@SUM(L15...L22) >K24:/FI@SUM(K15.... >R28:"ENT >Q28:" & EQUIPME >P28:" PREMISES >O28:" C. BANK >L28:/FI+W125*W43/100 >K28:/FI+V125*V43/100 >J28:/FI+U125*U43/100 >I28:/FI+T125*T43/100 >H28:/FI"......... >G28:"......... >B28:"DEPOSITS >W25:" -------- >V25:" -------- >U25:" -------- >T25:"0,L36,L39) >K29:/FI+V125-@SUM(K28,K30,K36,K39) >J29:/FI+U125-@SUM(J28,J30,J36,J39) >I29:/FI+T125-@SUM(I28,I30,I36,I39) >H29:/FI"......... >G29:"......... >D29:"DS >C29:"ROWED FUNDS >B29:"OTHER BOR >W28:"......... >V28:"......... >U28:"......... >T28:".....L30:/FI+W47*W125/100 >K30:/FI+V47*V125/100 >J30:/FI+U47*U125/100 >I30:/FI+T47*T125/100 >H30:/FI"......... >G30:"......... >D30:"PENSES >C30:"AXES & EX >B30:"ACCRUED T >W29:" -------- >V29:" -------- >U29:" -------- >T29:" -------- >L29:/FI+W125-@SUM(L28,L331:" -------- >T31:" -------- >L31:" -------- >K31:" -------- >J31:" -------- >I31:" -------- >H31:" -------- >G31:" -------- >W30:"......... >V30:"......... >U30:"......... >T30:"......... >R30:" ACQUIRED >Q30:"ON ASSETS >P30:"IUM PAID >O30:" D. PREMIU >... >P32:"R ASSETS >O32:" E. OTHER >L32:/FI@SUM(L28...L30) >K32:/FI@SUM(K28...K30) >J32:/FI@SUM(J28...J30) >I32:/FI@SUM(I28...I30) >H32:/FI@SUM(H28...H30) >G32:@SUM(G28...G30) >D32:"IES >C32:" LIABILITIES >B32:" TOTAL >W31:" -------- >V31:" -------- >U >B36:"CAPITAL N >W33:" -------- >V33:" -------- >U33:" -------- >T33:" -------- >L33:" --------- >K33:" --------- >J33:" --------- >I33:" --------- >H33:" --------- >G33:" --------- >W32:/F$"......... >V32:/F$"......... >U32:/F$".......... >T32:/F$"......8:" ASSUMPTIONS >O38:"LIABILITY >L37:" --------- >K37:" --------- >J37:" --------- >I37:" --------- >H37:" --------- >G37:" --------- >M36:/FI >L36:/FI+K36-W50 >K36:/FI+J36-V50 >J36:/FI+I36-U50 >I36:/FI+H36-T50 >H36:/FI"......... >G36:".......... >C36:"OTE >K40:" -------- >J40:" -------- >I40:" -------- >H40:" -------- >G40:" -------- >Q39:"==== >P39:/-= >O39:/-= >L39:/FI+W127 >K39:/FI+V127 >J39:/FI+U127 >I39:/FI+T127 >H39:/FI"......... >G39:"......... >D39:"TY >C39:"ERS' EQUI >B39:"SHAREHOLD >Q38:"ONS: >P3L39) >K42:/FI@SUM(K36,K39) >J42:/FI@SUM(J36,J39) >I42:/FI@SUM(I36,I39) >H42:/FI@SUM(H36,H39) >G42:@SUM(G36,G39) >F42:"S' EQUITY >E42:"AREHOLDER >D42:"NOTE & SHA >C42:" CAPITAL >B42:" TOTAL >Q41:"OF ASSETS >P41:" PERCENT O >O41:" A. AS A >L40:" --------C44:" LIABILITY >B44:" TOTAL >W43:/F$"......... >V43:/F$"......... >U43:/F$"......... >T43:/F$"......... >P43:"POSITS >O43:" 1. DE >L43:" --------- >K43:" --------- >J43:" --------- >I43:" --------- >H43:" --------- >G43:" --------- >L42:/FI@SUM(L36,G45:" ======== >W44:" -------- >V44:" -------- >U44:" -------- >T44:" -------- >L44:/FI@SUM(L32,L42) >K44:/FI@SUM(K32,K42) >J44:/FI@SUM(J32,J42) >I44:/FI@SUM(I32,I42) >H44:@SUM(H32,H42) >G44:@SUM(G32,G42) >F44:"' EQUITY >E44:"REHOLDERS' >D44:"IES & SHARE >FI+T125*T32/100 >H22:/FI"......... >G22:"......... >B22:"OTHER >W21:" -------- >V21:" -------- >U21:" -------- >T21:" -------- >L21:+K21-W30 >K21:+J21-V30 >J21:+I21-U30 >I21:+H21-T30 >H21:"......... >G21:"......... >E21:"RED >D21:"SET ACQUIRED >C21:"AID ON ASSE >B21:"PREMIUM P >W20:/F$"......... >V20:/F$"......... >U20:/F$"......... >T20:/F$"......... >R20:"S >Q20:"SECURITIES >P20:"VESTMENT >O20:" 2. INVESTMENT >L20:+W28 >K20:+V28 >J20:+U28 >I20:+T28 >H20:/FI"......... >G20:"......... >D20:"UIPMENT >C20:OLUME NAME (/DISKNAME) OR DEVICE NAME (.Dx)"P12);::"80C";a$;:Zb$="CHANGING DISKS"$d=23:=0::"80C";b$;::12).n=12:=20:"MAKE A NEW MENU FOR DISK: ";N$xN$)<2110=N$ :210 I=1L(A$(I),A$))200B$(/ WAP /// SIG MENU.MAKER PROGRAM (v. 6.1) =".D1"210: Coldstart (320: Warmstart &*X=11000: TEXT SLOW-DOWN LOOP ,X.1 CHANGE DISK SUBROUTINE23œ202:2200<RFa$=" YOU MAY SELECT YOUR DISK BY V /W1 /GOC /GRM /GC9 /X>A1:>A1: " V >U2:" U >T2:" T >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >E1:"ON >D1:" PROJECTI >C1:"-EARNINGS >B1:"MODEL 10........ >V7:"......... >U7:"......... >T7:"......... >I7:"N >H7:"PROJECTIO >G7:"OUR YEAR >F7:" F >W4:".......... >V4:" 12) >U4:"FROM 1 TO >T4:"A NUMBER >S4:"YTD P&L ( >R4:"UALIZING >Q4:"H FOR ANNUL >P4:"RENT MONTH >O4:"INPUT CURR >W2:" W >V2:G12:" ========= >L11:"......... >K11:"......... >J11:"......... >I11:"......... >H11:"......... >G11:"......... >P10:/-= >O10:/-= >P9:"UMPTIONS: >O9:"ASSET ASS >H9:" OF RUN >G9:/FR"DATE >W8:" ========= >V8:" ========= >U8:" ========= >T8:" ========= >W7:".000) >I13:" (000) >H13:" (000) >G13:" (000) >W12:/F$"......... >V12:/F$"......... >U12:/F$".......... >T12:/F$"......... >Q12:"RATE >P12:"T GROWTH >O12:" A. ASSET >L12:" ========= >K12:" ========= >J12:" ========= >I12:" ========= >H12:" ========= >*W18/100 >K15:/FI+V125*V18/100 >J15:/FI+U125*U18/100 >I15:/FI+T125*T18/100 >H15:"......... >G15:"......... >D15:"NKS >C15:"E FROM BAN >B15:"CASH & DUE >W13:" -------- >V13:" -------- >U13:" -------- >T13:" -------- >L13:" (000) >K13:" (000) >J13:" (7:"INVESTMEN >L16:/FI+W125*W22/100 >K16:/FI+V125*V22/100 >J16:/FI+U125*U22/100 >I16:/FI+T125*T22/100 >H16:"......... >G16:"......... >E16:"S >D16:"THER BANKS >C16:"SITS OF OTH >B16:"TIME DEPOSI >Q15:"OF ASSETS >P15:" PERCENT O >O15:" B. AS A >L15:/FI+W125*V24/100 >J18:/FI+U125*U24/100 >I18:/FI+T125*T24/100 >H18:/FI"......... >G18:"......... >B18:"LOANS,NET >L17:/FI+W125*W20/100 >K17:/FI+V125*V20/100 >J17:/FI+U125*U20/100 >I17:/FI+T125*T20/100 >H17:/FI"......... >G17:"......... >D17:"IES >C17:"T SECURIT >B1.I18)-@SUM(I20...I22) >H19:"......... >G19:"......... >C19:"UNDS SOLD >B19:"FEDERAL FU >W18:/F$"......... >V18:/F$"......... >U18:/F$"......... >T18:/F$"......... >R18:"S >Q18:"FROM BANKS >P18:"SH & DUE >O18:" 1. CA >L18:/FI+W125*W24/100 >K18:/FI+V125"ISES & EQUI >B20:"BANK PREMI >W19:" -------- >V19:" -------- >U19:" -------- >T19:" -------- >L19:/FI+W125-@SUM(L15...L18)-@SUM(L20...L22) >K19:/FI+V125-@SUM(K15...K18)-@SUM(K20...K22) >J19:/FI+U125-@SUM(J15...J18)-@SUM(J20...J22) >I19:/FI+T125-@SUM(I15..J)=A$(I),1,31)!J/2<>J/2)=4:=+1:ۙ=44B$(J);:J=J+1I:1,180,22:2,280,21:2,2380,23:8A$(1000),B$(1000),C%(511),C$(20),name$(20):=10:=0UCA=128:LCA=UCA+32CT=15 IF PREFIX$= PREFIX$+MID$(B$(I),1 MENU.MAKER TEXT MODULESEG=0"MENU.MAKER"890&*X=11000: TEXT SLOW-DOWN LOOP ,X.1,180,22:2,280,21:2,2380,23:z:A$="LISTING "+B$(I),16,B)$=01:=0::"80C";A$;::12)>=23:=0::"BANKCALC #3 202 :F*=08:"78C";"SORRY BUT MENU.MAKER CAN'T READ PASCAL TEXT FILES."04=10:"78C";"ANY KEY RETURNS TO THE MENU.">G$:::320H: Error Routine 202:U=11:"79C";"BAD PATH ERROR (NO DISK IN DISK DRIVE OR DESIRED FILE ,2))=0"12";џ,6);:ٟ;$П,2))=>12" PM-":" AM-" 1830WW=1530 =26:=21 1600 &:WW=1:0 :SEG=1;".D1/S EG.F" SEG=1".D1/SEG.G"diskname$=3802  CATCH PASCAL TEXT FILES "JUNE":1750M$="JULY":1750M$="AUGUST":1750M$="SEPTEMBER":1750M$="OCTOBER":1750M$="NOVEMBER":1750M$="DECEMBER":1750826);"-";M$;" ";Ѡ,2));", ";"19";Р,2);" ";/П,2))=>13П,2))-12;џ,6);:1780$~240:=24:=0:"@ ..... "DATE.TIME.LINE" ....JM=Ҡ,4,2))BTM1630,1640,1650,1660,1670,1680,1690,1700,1710,1720,1730,1740^M$="JANUARY":1750hM$="FEBRUARY":1750rM$="MARCH":1750|M$="APRIL":1750M$="MAY":1750M$=B$(I),"CAT 0")1140*B$(I),"FONT 0")18504B$(I),"FOTO 0")1930>B$(I),"PASTXT 0")2070H540R\A$="RUNNING "+B$(I),16,B)f"79C";A$;:=0pB$(I),16,B) z::SEG=1".D1/SEG.T"t=+B$(I),16,B) yCT=CT+1I=1:I=2I>2=-1:I=I-2:IBOTM<30THPOS=44I=IBOTM/2)*2:=+IBOTM/2)-1:0=+IBOTM/2-.5):I=IBOTM:I/2=I/2)I=I-1 œ2120B=B$(I),16)," ")-1 B$(I),"BASIC 0")850B$(I),"TEXT 0")890 81+LCA):::: RebootN=THPOS:B$(I);XA<8A>11540bA-7640,660,690,720l:=THPOS:B$(I);v:520: 500THPOS=4:I/2=I/2)I=I-1I=IBOTM THPOS=44:I/2<>I/2)I=I+1I13000Zha$="{,|,~,}; selects; to new disk; 1842:::Z=1980*:=23:=0::"79C";"CONTINUE...?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"10 ties. As this is a PD offering, buyer beware takes precidence here. You should find some of these useful. But there is no implied guarantee that any of these models as presented will return information accurate for the 1990s. NOTE #2: THE BOOKS THAT ACCand 3EZP/Appleworks format as well. While these models should hold for the present, please be aware that they all came out in the early 1980s and reflect the situation at that time. Some of these models may require some changes based on today's reali RATHER THAN DIF. We've included Menu.Maker on this disk so that (after you've booted into Business Basic from another disk or off your hard disk) you can look at these files or print them if you like. This information file is available in both Text rt of a continuing attempt to make all formerly commercial Apple /// products (that are not still on the market in some form) available to the /// community. NOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS A VISICALC FILE may wish to use them as a base for developing his own customized programs. Note that these models can all be pulled into 3EZ Pieces or Appleworks and may be of use to the home user in some form or another. We've put them into the public domain as pa ftware Houses and contributed to the publication. According to the Introduction: The purpose of this book is to provide bank personnel with Visicalc models which can be used immediately. As the banker gains experience in VC by using these models, he BANKCALC #2 INFORMATION ABOUT THIS DISK : BANKCALC was written by Anthony Powers and published by Micro Book, Inc. of Arlington Heights, Illinois in 1982. It is a collection of 14 VisiCalc models written by community bankers or Banking Industry SoEAD PASCAL TEXT FILES."04=10:"78C";"ANY KEY RETURNS TO THE MENU."!>G$:::".D1/MENU.MAKER",320R",220(204::"79A";""; 2D=1:F=1 <#4;a$ FD=D+1 P#5;a$ZD=60#5;12)dD=60D=1nF=F+1::d$;::Y=1100:Y x13402  CATCH PASCAL TEXT FILES 202 :F*=08:"78C";"SORRY BUT MENU.MAKER CAN'T R".D1/MENU.MAKER",220 d$="" A$="PRINTING "+B$(I),16,B)=01:=0::"80C";A$;:#3,B$(I),16,B)Z=1#3;b$:"78A";b$Z=Z+1:Z=18:1290 1260 #4,B$(I),16,B)#5,".PRINTER"+ž#4#5;12):::".D1/MENU.MAKE30C$="N"C$="n"1160;:=23:=0::"79C";"PRESS ANY KEY TO HALT LISTING": $1020.202 8::Z=1B::=23:=0::"79C";"WOULD YOU LIKE A PRINTED COPY?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"1170*C$="N"C$="n"OMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE WAP OFFICE SHOULD YOU NEED TO REFERENCE THEM. On Side One of this disk (III.ZAW.08) you'll find the following Visicalc models: YIELD MODELS -: Model 1: Commercial Loan Yields The calculation of monthly yields for all classes of Commercial Loans. -: Model 2: Installment Loan Yields The calculation of monthly yields for all classes of Installment Loans. -: Model 3: Real Estate Loan Yields 12405l=ơ):: Routine to back up one directory level.a$=С,l-1) s=a$)a$=a$,s-1)a$,1)="/"5060:s=s-1 5030=a$240( MENU.MAKER 6.10 * Thanks to C.M.Davidson for his help!NOT FOUND.)"X=11000:X:::210Z a$="{,|,~,}; selects; back 1 level;