LnSOS BOOT 1.1 SOS.KERNEL SOS KRNLI/O ERRORFILE 'SOS.KERNEL' NOT FOUND%INVALID KERNEL FILE: xةw,@  ȱlmi8#)!)>M34:/F$@SUM(M23...M32) >L34:/F$@SUM(L23...L32) >K34:/F$@SUM(K23...K32) >J34:/F$@SUM(J23...J32) >I34:/F$@SUM(I23...I32) >G34:/F$@SUM(G23...G32) >M32:/F$@IF(F32=5,((@INT((+G32-I32-J32-K32-L32)*100+.5))/100),0) >L32:/F$@IF(F32=3,0,(@IF(F32=5,((@INT((+G32*.21 <!&!'*MENU.MAKER  3+8MENU.MAKER3+3+%SEG.T j۸ Ÿ/ (BANKCALCP  ܸܸIII.AWZ.08u' 'MODEL119# ! 'MODEL12&B1!!'MODEL13h1n_!!'MODEL14 !! 'MODEL15=v!#!$'MODEL16 >dLԡm#i㰼m#iЕOLԡȱfg hi !dLԡ憦  Ljmkm l y`2 Lԡ8(Je稽)ʈ@L)*100+.5))/100),0)) >K32:/F$@IF(F32=3,((@INT((+G32-I32-J32)*100+.5))/100),(@IF(F32=5,((@INT((+G32*.21)*100+.5))/100),0)) >J32:/F$@IF(F32=3,((@INT((+G32*.38)*100+.5))/100),(@IF(F32=5,((@INT((+G32*.22)*100+.5))/100),0)) >I32:/F$@IF(F32=3,((@INT((+G32*.25)*10  !"#$@INT((+G26*.21)*100+.5))/100),0)) >K26:/F$@IF(F26=3,((@INT((+G26-I26-J26)*100+.5))/100),(@IF(F26=5,((@INT((+G26*.21)*100+.5))/100),0)) >J26:/F$@IF(F26=3,((@INT((+G26*.38)*100+.5))/100),(@IF(F26=5,((@INT((+G26*.22)*100+.5))/100),0)) >I26:/F$@IF(F26=3,((@INT+G27*.15)*100+.5))/100),0)) >H27:/FI" ....... >G27:/F$" ....... >F27:/FI" ...... >E27:"...... >D27:".........." >C27:"......... >B27:"....... >A27:+A26+1 >M26:/F$@IF(F26=5,((@INT((+G26-I26-J26-K26-L26)*100+.5))/100),0) >L26:/F$@IF(F26=3,0,(@IF(F26=5,(((F27=3,((@INT((+G27-I27-J27)*100+.5))/100),(@IF(F27=5,((@INT((+G27*.21)*100+.5))/100),0)) >J27:/F$@IF(F27=3,((@INT((+G27*.38)*100+.5))/100),(@IF(F27=5,((@INT((+G27*.22)*100+.5))/100),0)) >I27:/F$@IF(F27=3,((@INT((+G27*.25)*100+.5))/100),(@IF(F27=5,((@INT((. >G28:/F$" ....... >F28:/FI" ...... >E28:"...... >D28:".........." >C28:"......... >B28:"....... >A28:+A27+1 >M27:/F$@IF(F27=5,((@INT((+G27-I27-J27-K27-L27)*100+.5))/100),0) >L27:/F$@IF(F27=3,0,(@IF(F27=5,((@INT((+G27*.21)*100+.5))/100),0)) >K27:/F$@IFIF(F28=5,((@INT((+G28*.21)*100+.5))/100),0)) >J28:/F$@IF(F28=3,((@INT((+G28*.38)*100+.5))/100),(@IF(F28=5,((@INT((+G28*.22)*100+.5))/100),0)) >I28:/F$@IF(F28=3,((@INT((+G28*.25)*100+.5))/100),(@IF(F28=5,((@INT((+G28*.15)*100+.5))/100),0)) >H28:/FI" ......"...... >D29:".........." >C29:"......... >B29:"....... >A29:+A28+1 >M28:/F$@IF(F28=5,((@INT((+G28-I28-J28-K28-L28)*100+.5))/100),0) >L28:/F$@IF(F28=3,0,(@IF(F28=5,((@INT((+G28*.21)*100+.5))/100),0)) >K28:/F$@IF(F28=3,((@INT((+G28-I28-J28)*100+.5))/100),(@>J29:/F$@IF(F29=3,((@INT((+G29*.38)*100+.5))/100),(@IF(F29=5,((@INT((+G29*.22)*100+.5))/100),0)) >I29:/F$@IF(F29=3,((@INT((+G29*.25)*100+.5))/100),(@IF(F29=5,((@INT((+G29*.15)*100+.5))/100),0)) >H29:/FI" ....... >G29:/F$" ....... >F29:/FI" ...... >E29:0:"....... >A30:+A29+1 >M29:/F$@IF(F29=5,((@INT((+G29-I29-J29-K29-L29)*100+.5))/100),0) >L29:/F$@IF(F29=3,0,(@IF(F29=5,((@INT((+G29*.21)*100+.5))/100),0)) >K29:/F$@IF(F29=3,((@INT((+G29-I29-J29)*100+.5))/100),(@IF(F29=5,((@INT((+G29*.21)*100+.5))/100),0)) 100),(@IF(F30=5,((@INT((+G30*.22)*100+.5))/100),0)) >I30:/F$@IF(F30=3,((@INT((+G30*.25)*100+.5))/100),(@IF(F30=5,((@INT((+G30*.15)*100+.5))/100),0)) >H30:/FI" ....... >G30:/F$" ....... >F30:/FI" ...... >E30:"...... >D30:".........." >C30:"......... >B3NT((+G30-I30-J30-K30-L30)*100+.5))/100),0) >L30:/F$@IF(F30=3,0,(@IF(F30=5,((@INT((+G30*.21)*100+.5))/100),0)) >K30:/F$@IF(F30=3,((@INT((+G30-I30-J30)*100+.5))/100),(@IF(F30=5,((@INT((+G30*.21)*100+.5))/100),0)) >J30:/F$@IF(F30=3,((@INT((+G30*.38)*100+.5))/0),0)) >I31:/F$@IF(F31=3,((@INT((+G31*.25)*100+.5))/100),(@IF(F31=5,((@INT((+G31*.15)*100+.5))/100),0)) >H31:/FI" ....... >G31:/F$" ....... >F31:/FI" ...... >E31:"...... >D31:".........." >C31:"......... >B31:"....... >A31:+A30+1 >M30:/F$@IF(F30=5,((@I31:/F$@IF(F31=3,0,(@IF(F31=5,((@INT((+G31*.21)*100+.5))/100),0)) >K31:/F$@IF(F31=3,((@INT((+G31-I31-J31)*100+.5))/100),(@IF(F31=5,((@INT((+G31*.21)*100+.5))/100),0)) >J31:/F$@IF(F31=3,((@INT((+G31*.38)*100+.5))/100),(@IF(F31=5,((@INT((+G31*.22)*100+.5))/100+.5))/100),(@IF(F32=5,((@INT((+G32*.15)*100+.5))/100),0)) >H32:/FI" ....... >G32:/F$" ....... >F32:/FI" ...... >E32:"...... >D32:".........." >C32:"......... >B32:"....... >A32:+A31+1 >M31:/F$@IF(F31=5,((@INT((+G31-I31-J31-K31-L31)*100+.5))/100),0) >L((+G26*.25)*100+.5))/100),(@IF(F26=5,((@INT((+G26*.15)*100+.5))/100),0)) >H26:/FI" ....... >G26:/F$" ....... >F26:/FI" ...... >E26:"...... >D26:".........." >C26:"......... >B26:"....... >A26:+A25+1 >M25:/F$@IF(F25=5,((@INT((+G25-I25-J25-K25-L25)*100+.5))/100),0) >L25:/F$@IF(F25=3,0,(@IF(F25=5,((@INT((+G25*.21)*100+.5))/100),0)) >K25:/F$@IF(F25=3,((@INT((+G25-I25-J25)*100+.5))/100),(@IF(F25=5,((@INT((+G25*.21)*100+.5))/100),0)) >J25:/F$@IF(F25=3,((@INT((+G25*.38)*100+.5))/100),(@IF(F25=5,((@INT((+G25*.2(@INT((+G19*.22)*100+.5))/100),0)) >I19:/F$@IF(F19=3,((@INT((+G19*.25)*100+.5))/100),(@IF(F19=5,((@INT((+G19*.15)*100+.5))/100),0)) >H19:/FI" ....... >G19:/F$" ....... >F19:/FI" ...... >E19:"...... >D19:".........." >C19:"......... >B19:"....... >A19:+K19-L19)*100+.5))/100),0) >L19:/F$@IF(F19=3,0,(@IF(F19=5,((@INT((+G19*.21)*100+.5))/100),0)) >K19:/F$@IF(F19=3,((@INT((+G19-I19-J19)*100+.5))/100),(@IF(F19=5,((@INT((+G19*.21)*100+.5))/100),0)) >J19:/F$@IF(F19=3,((@INT((+G19*.38)*100+.5))/100),(@IF(F19=5,(F(F20=3,((@INT((+G20*.25)*100+.5))/100),(@IF(F20=5,((@INT((+G20*.15)*100+.5))/100),0)) >H20:/FI" ....... >G20:/F$" ....... >F20:/FI" ...... >E20:"...... >D20:".........." >C20:"......... >B20:"....... >A20:+A19+1 >M19:/F$@IF(F19=5,((@INT((+G19-I19-J19-,(@IF(F20=5,((@INT((+G20*.21)*100+.5))/100),0)) >K20:/F$@IF(F20=3,((@INT((+G20-I20-J20)*100+.5))/100),(@IF(F20=5,((@INT((+G20*.21)*100+.5))/100),0)) >J20:/F$@IF(F20=3,((@INT((+G20*.38)*100+.5))/100),(@IF(F20=5,((@INT((+G20*.22)*100+.5))/100),0)) >I20:/F$@IF21=5,((@INT((+G21*.15)*100+.5))/100),0)) >H21:/FI" ....... >G21:/F$" ....... >F21:/FI" ...... >E21:"...... >D21:".........." >C21:"......... >B21:"....... >A21:+A20+1 >M20:/F$@IF(F20=5,((@INT((+G20-I20-J20-K20-L20)*100+.5))/100),0) >L20:/F$@IF(F20=3,0)) >K21:/F$@IF(F21=3,((@INT((+G21-I21-J21)*100+.5))/100),(@IF(F21=5,((@INT((+G21*.21)*100+.5))/100),0)) >J21:/F$@IF(F21=3,((@INT((+G21*.38)*100+.5))/100),(@IF(F21=5,((@INT((+G21*.22)*100+.5))/100),0)) >I21:/F$@IF(F21=3,((@INT((+G21*.25)*100+.5))/100),(@IF(2:/FI" ....... >G22:/F$" ....... >F22:/FI" ...... >E22:"...... >D22:".........." >C22:"......... >B22:"....... >A22:+A21+1 >M21:/F$@IF(F21=5,((@INT((+G21-I21-J21-K21-L21)*100+.5))/100),0) >L21:/F$@IF(F21=3,0,(@IF(F21=5,((@INT((+G21*.21)*100+.5))/100),00+.5))/100),(@IF(F22=5,((@INT((+G22*.21)*100+.5))/100),0)) >J22:/F$@IF(F22=3,((@INT((+G22*.38)*100+.5))/100),(@IF(F22=5,((@INT((+G22*.22)*100+.5))/100),0)) >I22:/F$@IF(F22=3,((@INT((+G22*.25)*100+.5))/100),(@IF(F22=5,((@INT((+G22*.15)*100+.5))/100),0)) >H2 ...... >E23:"...... >D23:".........." >C23:"......... >B23:"....... >A23:+A22+1 >M22:/F$@IF(F22=5,((@INT((+G22-I22-J22-K22-L22)*100+.5))/100),0) >L22:/F$@IF(F22=3,0,(@IF(F22=5,((@INT((+G22*.21)*100+.5))/100),0)) >K22:/F$@IF(F22=3,((@INT((+G22-I22-J22)*10.5))/100),0)) >J23:/F$@IF(F23=3,((@INT((+G23*.38)*100+.5))/100),(@IF(F23=5,((@INT((+G23*.22)*100+.5))/100),0)) >I23:/F$@IF(F23=3,((@INT((+G23*.25)*100+.5))/100),(@IF(F23=5,((@INT((+G23*.15)*100+.5))/100),0)) >H23:/FI" ....... >G23:/F$" ....... >F23:/FI" "......... >B24:"....... >A24:+A23+1 >M23:/F$@IF(F23=5,((@INT((+G23-I23-J23-K23-L23)*100+.5))/100),0) >L23:/F$@IF(F23=3,0,(@IF(F23=5,((@INT((+G23*.21)*100+.5))/100),0)) >K23:/F$@IF(F23=3,((@INT((+G23-I23-J23)*100+.5))/100),(@IF(F23=5,((@INT((+G23*.21)*100+.38)*100+.5))/100),(@IF(F24=5,((@INT((+G24*.22)*100+.5))/100),0)) >I24:/F$@IF(F24=3,((@INT((+G24*.25)*100+.5))/100),(@IF(F24=5,((@INT((+G24*.15)*100+.5))/100),0)) >H24:/FI" ....... >G24:/F$" ....... >F24:/FI" ...... >E24:"...... >D24:".........." >C24:@IF(F24=5,((@INT((+G24-I24-J24-K24-L24)*100+.5))/100),0) >L24:/F$@IF(F24=3,0,(@IF(F24=5,((@INT((+G24*.21)*100+.5))/100),0)) >K24:/F$@IF(F24=3,((@INT((+G24-I24-J24)*100+.5))/100),(@IF(F24=5,((@INT((+G24*.21)*100+.5))/100),0)) >J24:/F$@IF(F24=3,((@INT((+G24*2)*100+.5))/100),0)) >I25:/F$@IF(F25=3,((@INT((+G25*.25)*100+.5))/100),(@IF(F25=5,((@INT((+G25*.15)*100+.5))/100),0)) >H25:/FI" ....... >G25:/F$" ....... >F25:/FI" ...... >E25:"...... >D25:".........." >C25:"......... >B25:"....... >A25:+A24+1 >M24:/F$A18+1 >M18:/F$@IF(F18=5,((@INT((+G18-I18-J18-K18-L18)*100+.5))/100),0) >L18:/F$@IF(F18=3,0,(@IF(F18=5,((@INT((+G18*.21)*100+.5))/100),0)) >K18:/F$@IF(F18=3,((@INT((+G18-I18-J18)*100+.5))/100),(@IF(F18=5,((@INT((+G18*.21)*100+.5))/100),0)) >J18:/F$@IF(F18=3,((@INT((+G18*.38)*100+.5))/100),(@IF(F18=5,((@INT((+G18*.22)*100+.5))/100),0)) >I18:/F$@IF(F18=3,((@INT((+G18*.25)*100+.5))/100),(@IF(F18=5,((@INT((+G18*.15)*100+.5))/100),0)) >H18:/FI" ....... >G18:/F$" ....... >F18:/FI" ...... >E18:"...... >D18:"....... >D12:".........." >C12:"......... >B12:"....... >A12:+A11+1 >M11:/F$@IF(F11=5,((@INT((+G11-I11-J11-K11-L11)*100+.5))/100),0) >L11:/F$@IF(F11=3,0,(@IF(F11=5,((@INT((+G11*.21)*100+.5))/100),0)) >K11:/F$@IF(F11=3,((@INT((+G11-I11-J11)*100+.5))/100),(@IF(2:/F$@IF(F12=3,((@INT((+G12*.38)*100+.5))/100),(@IF(F12=5,((@INT((+G12*.22)*100+.5))/100),0)) >I12:/F$@IF(F12=3,((@INT((+G12*.25)*100+.5))/100),(@IF(F12=5,((@INT((+G12*.15)*100+.5))/100),0)) >H12:/FI" ....... >G12:/F$" ....... >F12:/FI" ...... >E12:"......... >A13:+A12+1 >M12:/F$@IF(F12=5,((@INT((+G12-I12-J12-K12-L12)*100+.5))/100),0) >L12:/F$@IF(F12=3,0,(@IF(F12=5,((@INT((+G12*.21)*100+.5))/100),0)) >K12:/F$@IF(F12=3,((@INT((+G12-I12-J12)*100+.5))/100),(@IF(F12=5,((@INT((+G12*.21)*100+.5))/100),0)) >J1),(@IF(F13=5,((@INT((+G13*.22)*100+.5))/100),0)) >I13:/F$@IF(F13=3,((@INT((+G13*.25)*100+.5))/100),(@IF(F13=5,((@INT((+G13*.15)*100+.5))/100),0)) >H13:/FI" ....... >G13:/F$" ....... >F13:/FI" ...... >E13:"...... >D13:".........." >C13:"......... >B13:"(+G13-I13-J13-K13-L13)*100+.5))/100),0) >L13:/F$@IF(F13=3,0,(@IF(F13=5,((@INT((+G13*.21)*100+.5))/100),0)) >K13:/F$@IF(F13=3,((@INT((+G13-I13-J13)*100+.5))/100),(@IF(F13=5,((@INT((+G13*.21)*100+.5))/100),0)) >J13:/F$@IF(F13=3,((@INT((+G13*.38)*100+.5))/1000)) >I14:/F$@IF(F14=3,((@INT((+G14*.25)*100+.5))/100),(@IF(F14=5,((@INT((+G14*.15)*100+.5))/100),0)) >H14:/FI" ....... >G14:/F$" ....... >F14:/FI" ...... >E14:"...... >D14:".........." >C14:"......... >B14:"....... >A14:+A13+1 >M13:/F$@IF(F13=5,((@INT(/F$@IF(F14=3,0,(@IF(F14=5,((@INT((+G14*.21)*100+.5))/100),0)) >K14:/F$@IF(F14=3,((@INT((+G14-I14-J14)*100+.5))/100),(@IF(F14=5,((@INT((+G14*.21)*100+.5))/100),0)) >J14:/F$@IF(F14=3,((@INT((+G14*.38)*100+.5))/100),(@IF(F14=5,((@INT((+G14*.22)*100+.5))/100),5))/100),(@IF(F15=5,((@INT((+G15*.15)*100+.5))/100),0)) >H15:/FI" ....... >G15:/F$" ....... >F15:/FI" ...... >E15:"...... >D15:".........." >C15:"......... >B15:"....... >A15:+A14+1 >M14:/F$@IF(F14=5,((@INT((+G14-I14-J14-K14-L14)*100+.5))/100),0) >L14:00+.5))/100),0)) >K15:/F$@IF(F15=3,((@INT((+G15-I15-J15)*100+.5))/100),(@IF(F15=5,((@INT((+G15*.21)*100+.5))/100),0)) >J15:/F$@IF(F15=3,((@INT((+G15*.38)*100+.5))/100),(@IF(F15=5,((@INT((+G15*.22)*100+.5))/100),0)) >I15:/F$@IF(F15=3,((@INT((+G15*.25)*100+.)/100),0)) >H16:/FI" ....... >G16:/F$" ....... >F16:/FI" ...... >E16:"...... >D16:".........." >C16:"......... >B16:"....... >A16:+A15+1 >M15:/F$@IF(F15=5,((@INT((+G15-I15-J15-K15-L15)*100+.5))/100),0) >L15:/F$@IF(F15=3,0,(@IF(F15=5,((@INT((+G15*.21)*116-I16-J16)*100+.5))/100),(@IF(F16=5,((@INT((+G16*.21)*100+.5))/100),0)) >J16:/F$@IF(F16=3,((@INT((+G16*.38)*100+.5))/100),(@IF(F16=5,((@INT((+G16*.22)*100+.5))/100),0)) >I16:/F$@IF(F16=3,((@INT((+G16*.25)*100+.5))/100),(@IF(F16=5,((@INT((+G16*.15)*100+.5)... >F17:/FI" ...... >E17:"...... >D17:".........." >C17:"......... >B17:"....... >A17:+A16+1 >M16:/F$@IF(F16=5,((@INT((+G16-I16-J16-K16-L16)*100+.5))/100),0) >L16:/F$@IF(F16=3,0,(@IF(F16=5,((@INT((+G16*.21)*100+.5))/100),0)) >K16:/F$@IF(F16=3,((@INT((+G+G17*.21)*100+.5))/100),0)) >J17:/F$@IF(F17=3,((@INT((+G17*.38)*100+.5))/100),(@IF(F17=5,((@INT((+G17*.22)*100+.5))/100),0)) >I17:/F$@IF(F17=3,((@INT((+G17*.25)*100+.5))/100),(@IF(F17=5,((@INT((+G17*.15)*100+.5))/100),0)) >H17:/FI" ....... >G17:/F$" ..........." >C18:"......... >B18:"....... >A18:+A17+1 >M17:/F$@IF(F17=5,((@INT((+G17-I17-J17-K17-L17)*100+.5))/100),0) >L17:/F$@IF(F17=3,0,(@IF(F17=5,((@INT((+G17*.21)*100+.5))/100),0)) >K17:/F$@IF(F17=3,((@INT((+G17-I17-J17)*100+.5))/100),(@IF(F17=5,((@INT((F11=5,((@INT((+G11*.21)*100+.5))/100),0)) >J11:/F$@IF(F11=3,((@INT((+G11*.38)*100+.5))/100),(@IF(F11=5,((@INT((+G11*.22)*100+.5))/100),0)) >I11:/F$@IF(F11=3,((@INT((+G11*.25)*100+.5))/100),(@IF(F11=5,((@INT((+G11*.15)*100+.5))/100),0)) >H11:/FI" ....... >G11:/F$" ....... >F11:/FI" ...... >E11:"...... >D11:".........." >C11:"......... >B11:"....... >A11:+A10+1 >M10:/F$@IF(F10=5,((@INT((+G10-I10-J10-K10-L10)*100+.5))/100),0) >L10:/F$@IF(F10=3,0,(@IF(F10=5,((@INT((+G10*.21)*100+.5))/100),0)) >K10:/F$@IF(F1L90+L92+L101 >K103:/FI+K75+K83+K88+K90+K92+K101 >J103:/FI+J75+J83+J88+J90+J92+J101 >I103:/FI+I75+I83+I88+I90+I92+I101 >H103:/FI+H75+H83+H88+H90+H92+H101 >G103:/FI+G75+G83+G88+G90+G92+G101 >F103:/FI+F75+F83+F88+F90+F92+F101 >E103:/FI+E75+E83+E88+E90+E92+E10%'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdef75+S83+S88+S90+S92+S101 >R103:/FI+R75+R83+R88+R90+R92+R101 >Q103:/FI+Q75+Q83+Q88+Q90+Q92+Q101 >P103:/FI+P75+P83+P88+P90+P92+P101 >O103:/FI+O75+O83+O88+O90+O92+O101 >N103:/FI+N75+N83+N88+N90+N92+N101 >M103:/FI+M75+M83+M88+M90+M92+M101 >L103:/FI+L75+L83+L88+>Z103:/FI+Z75+Z83+Z88+Z90+Z92+Z101 >Y103:/FI+Y75+Y83+Y88+Y90+Y92+Y101 >X103:/FI+X75+X83+X88+X90+X92+X101 >W103:/FI+W75+W83+W88+W90+W92+W101 >V103:/FI+V75+V83+V88+V90+V92+V101 >U103:/FI+U75+U83+U88+U90+U92+U101 >T103:/FI+T75+T83+T88+T90+T92+T101 >S103:/FI+S >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >E1:" RECOVERY >D1:"ATED COST >C1:"- ACCELER >B1:"MODEL 11 >A1:1 /W1 /GOC /GRM /GC9 /X>A1:>A1: DATE >A6:+A5+1 >M5:"--------- >L5:"--------- >K5:"ECIATION- >J5:"-----DEPR >I5:"--------- >H5:" ASSET >F5:" YEARS >A5:+A4+1 >L4:"ERY >K4:"OST RECOV >J4:"LERATED C >I4:" ACCE >A4:+A3+1 >A3:+A2+1 >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I=== >G7:" ======= >F7:" ======= >E7:"======== >D7:"========= >C7:"========= >B7:"======= >A7:+A6+1 >M6:" 1986 >L6:" 1985 >K6:" 1984 >J6:" 1983 >I6:" 1982 >H6:" NUMBER >G6:" COST >F6:" LIFE >E6:"ET >D6:"ON OF ASS >C6:"DESCRIPTI >B6:" 00),(@IF(F8=5,((@INT((+G8*.15)*100+.5))/100),0)) >H8:/FI" ....... >G8:/F$" ....... >F8:/FI" ...... >E8:"...... >D8:".........." >C8:"......... >B8:"....... >A8:+A7+1 >M7:" ======= >L7:" ======= >K7:" ======= >J7:" ======= >I7:" ======= >H7:" ====+G8*.21)*100+.5))/100),0)) >K8:/F$@IF(F8=3,((@INT((+G8-I8-J8)*100+.5))/100),(@IF(F8=5,((@INT((+G8*.21)*100+.5))/100),0)) >J8:/F$@IF(F8=3,((@INT((+G8*.38)*100+.5))/100),(@IF(F8=5,((@INT((+G8*.22)*100+.5))/100),0)) >I8:/F$@IF(F8=3,((@INT((+G8*.25)*100+.5))/1(F9=5,((@INT((+G9*.15)*100+.5))/100),0)) >H9:/FI" ....... >G9:/F$" ....... >F9:/FI" ...... >E9:"...... >D9:".........." >C9:"......... >B9:"....... >A9:+A8+1 >M8:/F$@IF(F8=5,((@INT((+G8-I8-J8-K8-L8)*100+.5))/100),0) >L8:/F$@IF(F8=3,0,(@IF(F8=5,((@INT((*100+.5))/100),0)) >K9:/F$@IF(F9=3,((@INT((+G9-I9-J9)*100+.5))/100),(@IF(F9=5,((@INT((+G9*.21)*100+.5))/100),0)) >J9:/F$@IF(F9=3,((@INT((+G9*.38)*100+.5))/100),(@IF(F9=5,((@INT((+G9*.22)*100+.5))/100),0)) >I9:/F$@IF(F9=3,((@INT((+G9*.25)*100+.5))/100),(@IF0*.15)*100+.5))/100),0)) >H10:/FI" ....... >G10:/F$" ....... >F10:/FI" ...... >E10:"...... >D10:".........." >C10:"......... >B10:"....... >A10:+A9+1 >M9:/F$@IF(F9=5,((@INT((+G9-I9-J9-K9-L9)*100+.5))/100),0) >L9:/F$@IF(F9=3,0,(@IF(F9=5,((@INT((+G9*.21)0=3,((@INT((+G10-I10-J10)*100+.5))/100),(@IF(F10=5,((@INT((+G10*.21)*100+.5))/100),0)) >J10:/F$@IF(F10=3,((@INT((+G10*.38)*100+.5))/100),(@IF(F10=5,((@INT((+G10*.22)*100+.5))/100),0)) >I10:/F$@IF(F10=3,((@INT((+G10*.25)*100+.5))/100),(@IF(F10=5,((@INT((+G11 >D103:/FI+D75+D83+D88+D90+D92+D101 >C103:/FI+C75+C83+C88+C90+C92+C101 >B103:"NSE >A103:"TOTAL EXPENSE >Z102:/FR"===== >Y102:/FR"===== >X102:/FR"===== >W102:/FR"===== >V102:/FR"===== >U102:/FR"===== >T102:/FR"===== >S102:/FR"===== >R102:/FR"===== >Q102:/FR"===== >P102:/FR"===== >O102:/FR"===== >N102:/FR"===== >M102:/FR"===== >L102:/FR"===== >K102:/FR"===== >J102:/FR"===== >I102:/FR"===== >H102:/FR"===== >G102:/FR"===== >F102:/FR"===== >E102:/FR"===== >D102:/FR"===== >C102:/FR"===== >Z101:@SUM(Z95...Z100 ....... >O92:" ....... >N92:" ....... >M92:" ....... >L92:" ....... >K92:" ....... >J92:" ....... >I92:" ....... >H92:" ....... >G92:" ....... >F92:" ....... >E92:" ....... >D92:" ....... >C92:" ....... >B92:"G >A92:"ADVERTISIN..... >D95:" ....... >C95:" ....... >A95:"LEGAL >B94:"EMS >A94:"PREMIUM IT >Z92:" ....... >Y92:" ....... >X92:" ....... >W92:" ....... >V92:" ....... >U92:" ....... >T92:" ....... >S92:" ....... >R92:" ....... >Q92:" ....... >P92:"...... >S95:" ....... >R95:" ....... >Q95:" ....... >P95:" ....... >O95:" ....... >N95:" ....... >M95:" ....... >L95:" ....... >K95:" ....... >J95:" ....... >I95:" ....... >H95:" ....... >G95:" ....... >F95:" ....... >E95:" .. ....... >H96:" ....... >G96:" ....... >F96:" ....... >E96:" ....... >D96:" ....... >C96:" ....... >B96:"OAN LOSS >A96:"PROV FOR L >Z95:" ....... >Y95:" ....... >X95:" ....... >W95:" ....... >V95:" ....... >U95:" ....... >T95:" . ....... >W96:" ....... >V96:" ....... >U96:" ....... >T96:" ....... >S96:" ....... >R96:" ....... >Q96:" ....... >P96:" ....... >O96:" ....... >N96:" ....... >M96:" ....... >L96:" ....... >K96:" ....... >J96:" ....... >I96:" 7:" ....... >M97:" ....... >L97:" ....... >K97:" ....... >J97:" ....... >I97:" ....... >H97:" ....... >G97:" ....... >F97:" ....... >E97:" ....... >D97:" ....... >C97:" ....... >A97:"COMPUTER >Z96:" ....... >Y96:" ....... >X96:"8:" ....... >C98:" ....... >A98:"STATIONARY >Z97:" ....... >Y97:" ....... >X97:" ....... >W97:" ....... >V97:" ....... >U97:" ....... >T97:" ....... >S97:" ....... >R97:" ....... >Q97:" ....... >P97:" ....... >O97:" ....... >N998:" ....... >R98:" ....... >Q98:" ....... >P98:" ....... >O98:" ....... >N98:" ....... >M98:" ....... >L98:" ....... >K98:" ....... >J98:" ....... >I98:" ....... >H98:" ....... >G98:" ....... >F98:" ....... >E98:" ....... >D9I99:" ....... >H99:" ....... >G99:" ....... >F99:" ....... >E99:" ....... >D99:" ....... >C99:" ....... >A99:"BANK CARDS >Z98:" ....... >Y98:" ....... >X98:" ....... >W98:" ....... >V98:" ....... >U98:" ....... >T98:" ....... >S>X99:" ....... >W99:" ....... >V99:" ....... >U99:" ....... >T99:" ....... >S99:" ....... >R99:" ....... >Q99:" ....... >P99:" ....... >O99:" ....... >N99:" ....... >M99:" ....... >L99:" ....... >K99:" ....... >J99:" ....... > ....... >M100:" ....... >L100:" ....... >K100:" ....... >J100:" ....... >I100:" ....... >H100:" ....... >G100:" ....... >F100:" ....... >E100:" ....... >D100:" ....... >C100:" ....... >A100:"OTHER >Z99:" ....... >Y99:" ....... "R EXPENSES >A101:"TOTAL OTHER >Z100:" ....... >Y100:" ....... >X100:" ....... >W100:" ....... >V100:" ....... >U100:" ....... >T100:" ....... >S100:" ....... >R100:" ....... >Q100:" ....... >P100:" ....... >O100:" ....... >N100:" ...N100 >M101:@SUM(M95...M100 >L101:@SUM(L95...L100 >K101:@SUM(K95...K100 >J101:@SUM(J95...J100 >I101:@SUM(I95...I100 >H101:@SUM(H95...H100 >G101:@SUM(G95...G100 >F101:@SUM(F95...F100 >E101:@SUM(E95...E100 >D101:@SUM(D95...D100 >C101:@SUM(C95...C100 >B101:>Y101:@SUM(Y95...Y100 >X101:@SUM(X95...X100 >W101:@SUM(W95...W100 >V101:@SUM(V95...V100 >U101:@SUM(U95...U100 >T101:@SUM(T95...T100 >S101:@SUM(S95...S100 >R101:@SUM(R95...R100 >Q101:@SUM(Q95...Q100 >P101:@SUM(P95...P100 >O101:@SUM(O95...O100 >N101:@SUM(N95G >Z90:" ....... >Y90:" ....... >X90:" ....... >W90:" ....... >V90:" ....... >U90:" ....... >T90:" ....... >S90:" ....... >R90:" ....... >Q90:" ....... >P90:" ....... >O90:" ....... >N90:" ....... >M90:" ....... >L90:" ....... >K90:" ....... >J90:" ....... >I90:" ....... >H90:" ....... >G90:" ....... >F90:" ....... >E90:" ....... >D90:" ....... >C90:" ....... >B90:"EXPENSE >A90:"OCCUPANCY >Z88:/FI@SUM(Z85...Z87 >Y88:/FI@SUM(Y85...Y87 >X88:/FI@SUM(X85...X87 >W8... >L81:/FI" ....... >K81:/FI" ....... >J81:/FI" ....... >I81:/FI" ....... >H81:/FI" ....... >G81:/FI" ....... >F81:/FI" ....... >E81:/FI" ....... >D81:/FI" ....... >C81:/FI" ....... >B81:"POSIT >A81:"CERT OF DE >Z80:/FI" ....... >Y8>Y81:/FI" ....... >X81:/FI" ....... >W81:/FI" ....... >V81:/FI" ....... >U81:/FI" ....... >T81:/FI" ....... >S81:/FI" ....... >R81:/FI" ....... >Q81:/FI" ....... >P81:/FI" ....... >O81:/FI" ....... >N81:/FI" ....... >M81:/FI" ..... >L82:/FI" ....... >K82:/FI" ....... >J82:/FI" ....... >I82:/FI" ....... >H82:/FI" ....... >G82:/FI" ....... >F82:/FI" ....... >E82:/FI" ....... >D82:/FI" ....... >C82:/FI" ....... >B82:"LL DEPOSIT >A82:"STATE OF I >Z81:/FI" ....... 82:/FI" ....... >X82:/FI" ....... >W82:/FI" ....... >V82:/FI" ....... >U82:/FI" ....... >T82:/FI" ....... >S82:/FI" ....... >R82:/FI" ....... >Q82:/FI" ....... >P82:/FI" ....... >O82:/FI" ....... >N82:/FI" ....... >M82:/FI" ......K83:/FI@SUM(K79...K82 >J83:/FI@SUM(J79...J82 >I83:/FI@SUM(I79...I82 >H83:/FI@SUM(H79...H82 >G83:/FI@SUM(G79...G82 >F83:/FI@SUM(F79...F82 >E83:/FI@SUM(E79...E82 >D83:/FI@SUM(D79...D82 >C83:/FI@SUM(C79...C82 >B83:"SITS >A83:"TOTAL DEPO >Z82:/FI" ....... >Y2 >V83:/FI@SUM(V79...V82 >U83:/FI@SUM(U79...U82 >T83:/FI@SUM(T79...T82 >S83:/FI@SUM(S79...S82 >R83:/FI@SUM(R79...R82 >Q83:/FI@SUM(Q79...Q82 >P83:/FI@SUM(P79...P82 >O83:/FI@SUM(O79...O82 >N83:/FI@SUM(N79...N82 >M83:/FI@SUM(M79...M82 >L83:/FI@SUM(L79...L82 >I" ....... >H85:/FI" ....... >G85:/FI" ....... >F85:/FI" ....... >E85:/FI" ....... >D85:/FI" ....... >C85:/FI" ....... >B85:"PURCHASED >A85:"FED FUNDS >Z83:/FI@SUM(Z79...Z82 >Y83:/FI@SUM(Y79...Y82 >X83:/FI@SUM(X79...X82 >W83:/FI@SUM(W79...W8 ....... >U85:/FI" ....... >T85:/FI" ....... >S85:/FI" ....... >R85:/FI" ....... >Q85:/FI" ....... >P85:/FI" ....... >O85:/FI" ....... >N85:/FI" ....... >M85:/FI" ....... >L85:/FI" ....... >K85:/FI" ....... >J85:/FI" ....... >I85:/F" ....... >I86:/FI" ....... >H86:/FI" ....... >G86:/FI" ....... >F86:/FI" ....... >E86:/FI" ....... >D86:/FI" ....... >C86:/FI" ....... >A86:"REPO'S >Z85:/FI" ....... >Y85:/FI" ....... >X85:/FI" ....... >W85:/FI" ....... >V85:/FI" ....... >V86:/FI" ....... >U86:/FI" ....... >T86:/FI" ....... >S86:/FI" ....... >R86:/FI" ....... >Q86:/FI" ....... >P86:/FI" ....... >O86:/FI" ....... >N86:/FI" ....... >M86:/FI" ....... >L86:/FI" ....... >K86:/FI" ....... >J86:/FI" ....... >J87:" ....... >I87:" ....... >H87:" ....... >G87:" ....... >F87:" ....... >E87:" ....... >D87:" ....... >C87:" ....... >B87:"& LOAN >A87:"TREAS TAX & LOAN >Z86:/FI" ....... >Y86:/FI" ....... >X86:/FI" ....... >W86:/FI" :" ....... >Y87:" ....... >X87:" ....... >W87:" ....... >V87:" ....... >U87:" ....... >T87:" ....... >S87:" ....... >R87:" ....... >Q87:" ....... >P87:" ....... >O87:" ....... >N87:" ....... >M87:" ....... >L87:" ....... >K87:FI@SUM(L85...L87 >K88:/FI@SUM(K85...K87 >J88:/FI@SUM(J85...J87 >I88:/FI@SUM(I85...I87 >H88:/FI@SUM(H85...H87 >G88:/FI@SUM(G85...G87 >F88:/FI@SUM(F85...F87 >E88:/FI@SUM(E85...E87 >D88:/FI@SUM(D85...D87 >C88:/FI@SUM(C85...C87 >B88:"OWED >A88:"TOTAL BORR >Z878:/FI@SUM(W85...W87 >V88:/FI@SUM(V85...V87 >U88:/FI@SUM(U85...U87 >T88:/FI@SUM(T85...T87 >S88:/FI@SUM(S85...S87 >R88:/FI@SUM(R85...R87 >Q88:/FI@SUM(Q85...Q87 >P88:/FI@SUM(P85...P87 >O88:/FI@SUM(O85...O87 >N88:/FI@SUM(N85...N87 >M88:/FI@SUM(M85...M87 >L88:/0:/FI" ....... >X80:/FI" ....... >W80:/FI" ....... >V80:/FI" ....... >U80:/FI" ....... >T80:/FI" ....... >S80:/FI" ....... >R80:/FI" ....... >Q80:/FI" ....... >P80:/FI" ....... >O80:/FI" ....... >N80:/FI" ....... >M80:/FI" ....... >L80:/FI" ....... >K80:/FI" ....... >J80:/FI" ....... >I80:/FI" ....... >H80:/FI" ....... >G80:/FI" ....... >F80:/FI" ....... >E80:/FI" ....... >D80:/FI" ....... >C80:/FI" ....... >A80:"CD>100M >Z79:/FI" ....... >Y79:/FI" ....... >....... >E64:/F$" ....... >D64:/F$" ....... >C64:/F$" ....... >B64:"ED >A64:"FF PURCHAS >Z63:/F$" ....... >Y63:/F$" ....... >X63:/F$" ....... >W63:/F$" ....... >V63:/F$" ....... >U63:/F$" ....... >T63:/F$" ....... >S63:/F$" ....... >R... >R64:/F$" ....... >Q64:/F$" ....... >P64:/F$" ....... >O64:/F$" ....... >N64:/F$" ....... >M64:/F$" ....... >L64:/F$" ....... >K64:/F$" ....... >J64:/F$" ....... >I64:/F$" ....... >H64:/F$" ....... >G64:/F$" ....... >F64:/F$" ...... >F65:/F$" ....... >E65:/F$" ....... >D65:/F$" ....... >C65:/F$" ....... >A65:"REPO'S >Z64:/F$" ....... >Y64:/F$" ....... >X64:/F$" ....... >W64:/F$" ....... >V64:/F$" ....... >U64:/F$" ....... >T64:/F$" ....... >S64:/F$" ...... >S65:/F$" ....... >R65:/F$" ....... >Q65:/F$" ....... >P65:/F$" ....... >O65:/F$" ....... >N65:/F$" ....... >M65:/F$" ....... >L65:/F$" ....... >K65:/F$" ....... >J65:/F$" ....... >I65:/F$" ....... >H65:/F$" ....... >G65:/F$" .9:/FR >I69:/FR >H69:/FR >G69:/FR >F69:/FR >E69:/FR >D69:/FR >C69:/FR >B69:"========== >A69:"========== >A68:"EXPENSES >Z65:/F$" ....... >Y65:/F$" ....... >X65:/F$" ....... >W65:/F$" ....... >V65:/F$" ....... >U65:/F$" ....... >T65:/F$" .....:/FR >J71:/FR >I71:/FR >H71:/FR >G71:/FR >F71:/FR >E71:/FR >D71:/FR >C71:/FR >B71:" BENEFIT >A71:"SALARY AND >Z69:/FR >Y69:/FR >X69:/FR >W69:/FR >V69:/FR >U69:/FR >T69:/FR >S69:/FR >R69:/FR >Q69:/FR >P69:/FR >O69:/FR >N69:/FR >M69:/FR >L69:/FR >K69:/FR >J673:" ....... >E73:" ....... >D73:" ....... >C73:" ....... >A73:"SALARIES >B72:"----------- >A72:"---------- >Z71:/FR >Y71:/FR >X71:/FR >W71:/FR >V71:/FR >U71:/FR >T71:/FR >S71:/FR >R71:/FR >Q71:/FR >P71:/FR >O71:/FR >N71:/FR >M71:/FR >L71:/FR >K71U73:" ....... >T73:" ....... >S73:" ....... >R73:" ....... >Q73:" ....... >P73:" ....... >O73:" ....... >N73:" ....... >M73:" ....... >L73:" ....... >K73:" ....... >J73:" ....... >I73:" ....... >H73:" ....... >G73:" ....... >F. >J74:" ....... >I74:" ....... >H74:" ....... >G74:" ....... >F74:" ....... >E74:" ....... >D74:" ....... >C74:" ....... >B74:"ENEFITS >A74:"EMPLOYEE B >Z73:" ....... >Y73:" ....... >X73:" ....... >W73:" ....... >V73:" ....... >.. >Y74:" ....... >X74:" ....... >W74:" ....... >V74:" ....... >U74:" ....... >T74:" ....... >S74:" ....... >R74:" ....... >Q74:" ....... >P74:" ....... >O74:" ....... >N74:" ....... >M74:" ....... >L74:" ....... >K74:" ......N73...N74 >M75:@SUM(M73...M74 >L75:@SUM(L73...L74 >K75:@SUM(K73...K74 >J75:@SUM(J73...J74 >I75:@SUM(I73...I74 >H75:@SUM(H73...H74 >G75:@SUM(G73...G74 >F75:@SUM(F73...F74 >E75:@SUM(E73...E74 >D75:@SUM(D73...D74 >C75:@SUM(C73...C74 >A75:"TOTAL >Z74:" .....EST E >Z75:@SUM(Z73...Z74 >Y75:@SUM(Y73...Y74 >X75:@SUM(X73...X74 >W75:@SUM(W73...W74 >V75:@SUM(V73...V74 >U75:@SUM(U73...U74 >T75:@SUM(T73...T74 >S75:@SUM(S73...S74 >R75:@SUM(R73...R74 >Q75:@SUM(Q73...Q74 >P75:@SUM(P73...P74 >O75:@SUM(O73...O74 >N75:@SUM(.. >K79:/FI" ....... >J79:/FI" ....... >I79:/FI" ....... >H79:/FI" ....... >G79:/FI" ....... >F79:/FI" ....... >E79:/FI" ....... >D79:/FI" ....... >C79:/FI" ....... >A79:"SAV&NOW >B78:"--------- >A78:"----------- >B77:"XPENSE >A77:"INTERX79:/FI" ....... >W79:/FI" ....... >V79:/FI" ....... >U79:/FI" ....... >T79:/FI" ....... >S79:/FI" ....... >R79:/FI" ....... >Q79:/FI" ....... >P79:/FI" ....... >O79:/FI" ....... >N79:/FI" ....... >M79:/FI" ....... >L79:/FI" .....63:/F$" ....... >Q63:/F$" ....... >P63:/F$" ....... >O63:/F$" ....... >N63:/F$" ....... >M63:/F$" ....... >L63:/F$" ....... >K63:/F$" ....... >J63:/F$" ....... >I63:/F$" ....... >H63:/F$" ....... >G63:/F$" ....... >F63:/F$" ....... >E63:/F$" ....... >D63:/F$" ....... >C63:/F$" ....... >B63:"DEPOSIT >A63:"STATE GOV >Z62:/F$" ....... >Y62:/F$" ....... >X62:/F$" ....... >W62:/F$" ....... >V62:/F$" ....... >U62:/F$" ....... >T62:/F$" ....... >S62:/F$" ....... >R6247) >J48:@SUM(J42...J47) >I48:@SUM(I42...I47) >H48:@SUM(H42...H47) >G48:@SUM(G42...G47) >F48:@SUM(F42...F47) >E48:@SUM(E42...E47) >D48:@SUM(D42...D47) >C48:@SUM(C42...C47) >B48:"ICE CHARGE >A48:"TOTAL SERVI >Z47:" ....... >Y47:" ....... >X47:" .........W47) >V48:@SUM(V42...V47) >U48:@SUM(U42...U47) >T48:@SUM(T42...T47) >S48:@SUM(S42...S47) >R48:@SUM(R42...R47) >Q48:@SUM(Q42...Q47) >P48:@SUM(P42...P47) >O48:@SUM(O42...O47) >N48:@SUM(N42...N47) >M48:@SUM(M42...M47) >L48:@SUM(L42...L47) >K48:@SUM(K42...K >K50:" ....... >J50:" ....... >I50:" ....... >H50:" ....... >G50:" ....... >F50:" ....... >E50:" ....... >D50:" ....... >C50:" ....... >B50:"ME >A50:"OTHER INCO >Z48:@SUM(Z42...Z47) >Y48:@SUM(Y42...Y47) >X48:@SUM(X42...X47) >W48:@SUM(W42 >Z50:" ....... >Y50:" ....... >X50:" ....... >W50:" ....... >V50:" ....... >U50:" ....... >T50:" ....... >S50:" ....... >R50:" ....... >Q50:" ....... >P50:" ....... >O50:" ....... >N50:" ....... >M50:" ....... >L50:" .......==== >N51:" ====== >M51:" ====== >L51:" ====== >K51:" ====== >J51:" ====== >I51:" ====== >H51:" ====== >G51:" ====== >F51:" ====== >E51:" ====== >D51:" ====== >C51:" ====== >B51:"=========== >A51:"===========FI+C28+C38+C48+C50 >B52:"ME >A52:"TOTAL INCO >Z51:" ====== >Y51:" ====== >X51:" ====== >W51:" ====== >V51:" ====== >U51:" ====== >T51:" ====== >S51:" ====== >R51:" ====== >Q51:" ====== >P51:" ====== >O51:" ==>M52:/FI+M28+M38+M48+M50 >L52:/FI+L28+L38+L48+L50 >K52:/FI+K28+K38+K48+K50 >J52:/FI+J28+J38+J48+J50 >I52:/FI+I28+I38+I48+I50 >H52:/FI+H28+H38+H48+H50 >G52:/FI+G28+G38+G48+G50 >F52:/FI+F28+F38+F48+F50 >E52:/FI+E28+E38+E48+E50 >D52:/FI+D28+D38+D48+D50 >C52:/8+X50 >W52:/FI+W28+W38+W48+W50 >V52:/FI+V28+V38+V48+V50 >U52:/FI+U28+U38+U48+U50 >T52:/FI+T28+T38+T48+T50 >S52:/FI+S28+S38+S48+S50 >R52:/FI+R28+R38+R48+R50 >Q52:/FI+Q28+Q38+Q48+Q50 >P52:/FI+P28+P38+P48+P50 >O52:/FI+O28+O38+O48+O50 >N52:/FI+N28+N38+N48+N50 ..... >C60:/F$" ....... >A60:"SAV & NOW >B58:"TIONS----- >A58:" ASSUMP >B57:"ATE >A57:"INTEREST R >B56:"========== >A56:"========== >A55:"EXPENSES >B54:"========== >A54:"========== >Z52:/FI+Z28+Z38+Z48+Z50 >Y52:/FI+Y28+Y38+Y48+Y50 >X52:/FI+X28+X38+X4. >P60:/F$" ....... >O60:/F$" ....... >N60:/F$" ....... >M60:/F$" ....... >L60:/F$" ....... >K60:/F$" ....... >J60:/F$" ....... >I60:/F$" ....... >H60:/F$" ....... >G60:/F$" ....... >F60:/F$" ....... >E60:/F$" ....... >D60:/F$" .... >D61:/F$" ....... >C61:/F$" ....... >A61:"CD >100M >Z60:/F$" ....... >Y60:/F$" ....... >X60:/F$" ....... >W60:/F$" ....... >V60:/F$" ....... >U60:/F$" ....... >T60:/F$" ....... >S60:/F$" ....... >R60:/F$" ....... >Q60:/F$" ......Q61:/F$" ....... >P61:/F$" ....... >O61:/F$" ....... >N61:/F$" ....... >M61:/F$" ....... >L61:/F$" ....... >K61:/F$" ....... >J61:/F$" ....... >I61:/F$" ....... >H61:/F$" ....... >G61:/F$" ....... >F61:/F$" ....... >E61:/F$" .....>E62:/F$" ....... >D62:/F$" ....... >C62:/F$" ....... >A62:"REG CD'S >Z61:/F$" ....... >Y61:/F$" ....... >X61:/F$" ....... >W61:/F$" ....... >V61:/F$" ....... >U61:/F$" ....... >T61:/F$" ....... >S61:/F$" ....... >R61:/F$" ....... >:/F$" ....... >Q62:/F$" ....... >P62:/F$" ....... >O62:/F$" ....... >N62:/F$" ....... >M62:/F$" ....... >L62:/F$" ....... >K62:/F$" ....... >J62:/F$" ....... >I62:/F$" ....... >H62:/F$" ....... >G62:/F$" ....... >F62:/F$" ....... . >W47:" ....... >V47:" ....... >U47:" ....... >T47:" ....... >S47:" ....... >R47:" ....... >Q47:" ....... >P47:" ....... >O47:" ....... >N47:" ....... >M47:" ....... >L47:" ....... >K47:" ....... >J47:" ....... >I47:" ....... >H47:" ....... >G47:" ....... >F47:" ....... >E47:" ....... >D47:" ....... >C47:" ....... >B47:"ICE CHARGE >A47:"OTHER SERV >Z46:" ....... >Y46:" ....... >X46:" ....... >W46:" ....... >V46:" ....... >U46:" ....... >T46:" ....... .... >O36:" ....... >N36:" ....... >M36:" ....... >L36:" ....... >K36:" ....... >J36:" ....... >I36:" ....... >H36:" ....... >G36:" ....... >F36:" ....... >E36:" ....... >D36:" ....... >C36:" ....... >A36:"OTHER LOAN >Z35:/FI" ....... >E37:" ....... >D37:" ....... >C37:" ....... >A37:"VISA MC >Z36:" ....... >Y36:" ....... >X36:" ....... >W36:" ....... >V36:" ....... >U36:" ....... >T36:" ....... >S36:" ....... >R36:" ....... >Q36:" ....... >P36:" ... ....... >T37:" ....... >S37:" ....... >R37:" ....... >Q37:" ....... >P37:" ....... >O37:" ....... >N37:" ....... >M37:" ....... >L37:" ....... >K37:" ....... >J37:" ....... >I37:" ....... >H37:" ....... >G37:" ....... >F37:" H32...H37) >G38:/FI@SUM(G32...G37) >F38:/FI@SUM(F32...F37) >E38:/FI@SUM(E32...E37) >D38:/FI@SUM(D32...D37) >C38:/FI@SUM(C32...C37) >B38:"S-------- >A38:"TOTAL LOAN >Z37:" ....... >Y37:" ....... >X37:" ....... >W37:" ....... >V37:" ....... >U37:" 7) >R38:/FI@SUM(R32...R37) >Q38:/FI@SUM(Q32...Q37) >P38:/FI@SUM(P32...P37) >O38:/FI@SUM(O32...O37) >N38:/FI@SUM(N32...N37) >M38:/FI@SUM(M32...M37) >L38:/FI@SUM(L32...L37) >K38:/FI@SUM(K32...K37) >J38:/FI@SUM(J32...J37) >I38:/FI@SUM(I32...I37) >H38:/FI@SUM(------- >A41:"---------- >C40:"E >B40:"ARGE INCOM >A40:"SERVICE CH >Z38:/FI@SUM(Z32...Z37) >Y38:/FI@SUM(Y32...Y37) >X38:/FI@SUM(X32...X37) >W38:/FI@SUM(W32...W37) >V38:/FI@SUM(V32...V37) >U38:/FI@SUM(U32...U37) >T38:/FI@SUM(T32...T37) >S38:/FI@SUM(S32...S3:" ....... >M42:" ....... >L42:" ....... >K42:" ....... >J42:" ....... >I42:" ....... >H42:" ....... >G42:" ....... >F42:" ....... >E42:" ....... >D42:" ....... >C42:" ....... >B42:"G ON DEP. >A42:"SERVICE CHARGE >C41:"- >B41:"----3:" ....... >C43:" ....... >A43:"NSF CHARGE >Z42:" ....... >Y42:" ....... >X42:" ....... >W42:" ....... >V42:" ....... >U42:" ....... >T42:" ....... >S42:" ....... >R42:" ....... >Q42:" ....... >P42:" ....... >O42:" ....... >N4243:" ....... >R43:" ....... >Q43:" ....... >P43:" ....... >O43:" ....... >N43:" ....... >M43:" ....... >L43:" ....... >K43:" ....... >J43:" ....... >I43:" ....... >H43:" ....... >G43:" ....... >F43:" ....... >E43:" ....... >D4...... >H44:" ....... >G44:" ....... >F44:" ....... >E44:" ....... >D44:" ....... >C44:" ....... >B44:"IT >A44:"SAFE DEPOS >Z43:" ....... >Y43:" ....... >X43:" ....... >W43:" ....... >V43:" ....... >U43:" ....... >T43:" ....... >S....... >W44:" ....... >V44:" ....... >U44:" ....... >T44:" ....... >S44:" ....... >R44:" ....... >Q44:" ....... >P44:" ....... >O44:" ....... >N44:" ....... >M44:" ....... >L44:" ....... >K44:" ....... >J44:" ....... >I44:" . ....... >M45:" ....... >L45:" ....... >K45:" ....... >J45:" ....... >I45:" ....... >H45:" ....... >G45:" ....... >F45:" ....... >E45:" ....... >D45:" ....... >C45:" ....... >A45:"BANK CARD >Z44:" ....... >Y44:" ....... >X44:" D46:" ....... >C46:" ....... >A46:"TRUST >Z45:" ....... >Y45:" ....... >X45:" ....... >W45:" ....... >V45:" ....... >U45:" ....... >T45:" ....... >S45:" ....... >R45:" ....... >Q45:" ....... >P45:" ....... >O45:" ....... >N45:" >S46:" ....... >R46:" ....... >Q46:" ....... >P46:" ....... >O46:" ....... >N46:" ....... >M46:" ....... >L46:" ....... >K46:" ....... >J46:" ....... >I46:" ....... >H46:" ....... >G46:" ....... >F46:" ....... >E46:" ....... >....... >Y35:/FI" ....... >X35:/FI" ....... >W35:/FI" ....... >V35:/FI" ....... >U35:/FI" ....... >T35:/FI" ....... >S35:/FI" ....... >R35:/FI" ....... >Q35:/FI" ....... >P35:/FI" ....... >O35:/FI" ....... >N35:/FI" ....... >M35:/FI" ....... >L35:/FI" ....... >K35:/FI" ....... >J35:/FI" ....... >I35:/FI" ....... >H35:/FI" ....... >G35:/FI" ....... >F35:/FI" ....... >E35:/FI" ....... >D35:/FI" ....... >C35:/FI" ....... >B35:"E >A35:"REAL ESTAT >Z34:/FI" ....... ....... >M25:" ....... >L25:" ....... >K25:" ....... >J25:" ....... >I25:" ....... >H25:" ....... >G25:" ....... >F25:" ....... >E25:" ....... >D25:" ....... >C25:" ....... >B25:"SOLD >A25:"FED FUNDS >Z24:/FI" ....... >Y24:/FI" ....... >C26:/FI" ....... >A26:"CD'S PURCH >Z25:" ....... >Y25:" ....... >X25:" ....... >W25:" ....... >V25:" ....... >U25:" ....... >T25:" ....... >S25:" ....... >R25:" ....... >Q25:" ....... >P25:" ....... >O25:" ....... >N25:".... >P26:/FI" ....... >O26:/FI" ....... >N26:/FI" ....... >M26:/FI" ....... >L26:/FI" ....... >K26:/FI" ....... >J26:/FI" ....... >I26:/FI" ....... >H26:/FI" ....... >G26:/FI" ....... >F26:/FI" ....... >E26:/FI" ....... >D26:/FI" ....... >C27:" ....... >B27:"COUNT >A27:"TRADING ACCOUNT >Z26:/FI" ....... >Y26:/FI" ....... >X26:/FI" ....... >W26:/FI" ....... >V26:/FI" ....... >U26:/FI" ....... >T26:/FI" ....... >S26:/FI" ....... >R26:/FI" ....... >Q26:/FI" ... ....... >R27:" ....... >Q27:" ....... >P27:" ....... >O27:" ....... >N27:" ....... >M27:" ....... >L27:" ....... >K27:" ....... >J27:" ....... >I27:" ....... >H27:" ....... >G27:" ....... >F27:" ....... >E27:" ....... >D27:" 7 >F28:/FI@SUM(F22...F27 >E28:/FI@SUM(E22...E27 >D28:/FI@SUM(D22...D27 >C28:/FI@SUM(C22...C27 >B28:"STMENT---- >A28:"TOTAL INVESTM >Z27:" ....... >Y27:" ....... >X27:" ....... >W27:" ....... >V27:" ....... >U27:" ....... >T27:" ....... >S27:".R27 >Q28:/FI@SUM(Q22...Q27 >P28:/FI@SUM(P22...P27 >O28:/FI@SUM(O22...O27 >N28:/FI@SUM(N22...N27 >M28:/FI@SUM(M22...M27 >L28:/FI@SUM(L22...L27 >K28:/FI@SUM(K22...K27 >J28:/FI@SUM(J22...J27 >I28:/FI@SUM(I22...I27 >H28:/FI@SUM(H22...H27 >G28:/FI@SUM(G22...G2LE PAY >B31:"---------- >A31:"---------- >A30:"LOANS >Z28:/FI@SUM(Z22...Z27 >Y28:/FI@SUM(Y22...Y27 >X28:/FI@SUM(X22...X27 >W28:/FI@SUM(W22...W27 >V28:/FI@SUM(V22...V27 >U28:/FI@SUM(U22...U27 >T28:/FI@SUM(T22...T27 >S28:/FI@SUM(S22...S27 >R28:/FI@SUM(R22..... >M32:/FI" ........ >L32:/FI" ........ >K32:/FI" ........ >J32:/FI" ........ >I32:/FI" ........ >H32:/FI" ........ >G32:/FI" ........ >F32:/FI" ........ >E32:/FI" ........ >D32:/FI" ........ >C32:/FI" ........ >B32:"MENT >A32:"SING....... >Y32:/FI" ........ >X32:/FI" ........ >W32:/FI" ........ >V32:/FI" ........ >U32:/FI" ........ >T32:/FI" ........ >S32:/FI" ........ >R32:/FI" ........ >Q32:/FI" ........ >P32:/FI" ........ >O32:/FI" ........ >N32:/FI" ..... ....... >L33:/FI" ....... >K33:/FI" ....... >J33:/FI" ....... >I33:/FI" ....... >H33:/FI" ....... >G33:/FI" ....... >F33:/FI" ....... >E33:/FI" ....... >D33:/FI" ....... >C33:/FI" ....... >B33:"NSTALLMENT >A33:"CONSUMER I >Z32:/FI" ..... >Y33:/FI" ....... >X33:/FI" ....... >W33:/FI" ....... >V33:/FI" ....... >U33:/FI" ....... >T33:/FI" ....... >S33:/FI" ....... >R33:/FI" ....... >Q33:/FI" ....... >P33:/FI" ....... >O33:/FI" ....... >N33:/FI" ....... >M33:/FI" .... >L34:/FI" ....... >K34:/FI" ....... >J34:/FI" ....... >I34:/FI" ....... >H34:/FI" ....... >G34:/FI" ....... >F34:/FI" ....... >E34:/FI" ....... >D34:/FI" ....... >C34:/FI" ....... >B34:"CREDIT >A34:"REVOLVING CREDIT >Z33:/FI" ... >Y34:/FI" ....... >X34:/FI" ....... >W34:/FI" ....... >V34:/FI" ....... >U34:/FI" ....... >T34:/FI" ....... >S34:/FI" ....... >R34:/FI" ....... >Q34:/FI" ....... >P34:/FI" ....... >O34:/FI" ....... >N34:/FI" ....... >M34:/FI" ... ....... >X24:/FI" ....... >W24:/FI" ....... >V24:/FI" ....... >U24:/FI" ....... >T24:/FI" ....... >S24:/FI" ....... >R24:/FI" ....... >Q24:/FI" ....... >P24:/FI" ....... >O24:/FI" ....... >N24:/FI" ....... >M24:/FI" ....... >L24:/FI" ....... >K24:/FI" ....... >J24:/FI" ....... >I24:/FI" ....... >H24:/FI" ....... >G24:/FI" ....... >F24:/FI" ....... >E24:/FI" ....... >D24:/FI" ....... >C24:/FI" ....... >A24:"MUNICIPALS >Z23:/FI" ........ >Y23:/FI" ........ >X2.... >M13:/F$" ....... >L13:/F$" ....... >K13:/F$" ....... >J13:/F$" ....... >I13:/F$" ....... >H13:/F$" ....... >G13:/F$" ....... >F13:/F$" ....... >E13:/F$" ....... >D13:/F$" ....... >C13:/F$" ....... >B13:" LOANS >A13:"COMMERCIAL > >Z13:/F$" ....... >Y13:/F$" ....... >X13:/F$" ....... >W13:/F$" ....... >V13:/F$" ....... >U13:/F$" ....... >T13:/F$" ....... >S13:/F$" ....... >R13:/F$" ....... >Q13:/F$" ....... >P13:/F$" ....... >O13:/F$" ....... >N13:/F$" ... ....... >M14:/F$" ....... >L14:/F$" ....... >K14:/F$" ....... >J14:/F$" ....... >I14:/F$" ....... >H14:/F$" ....... >G14:/F$" ....... >F14:/F$" ....... >E14:/F$" ....... >D14:/F$" ....... >C14:/F$" ....... >B14:"T >A14:"INSTALLMENTLVING >Z14:/F$" ....... >Y14:/F$" ....... >X14:/F$" ....... >W14:/F$" ....... >V14:/F$" ....... >U14:/F$" ....... >T14:/F$" ....... >S14:/F$" ....... >R14:/F$" ....... >Q14:/F$" ....... >P14:/F$" ....... >O14:/F$" ....... >N14:/F$"$" ....... >M15:/F$" ....... >L15:/F$" ....... >K15:/F$" ....... >J15:/F$" ....... >I15:/F$" ....... >H15:/F$" ....... >G15:/F$" ....... >F15:/F$" ....... >E15:/F$" ....... >D15:/F$" ....... >C15:/F$" ....... >B15:"CREDIT >A15:"REVOL ESTATE >Z15:/F$" ....... >Y15:/F$" ....... >X15:/F$" ....... >W15:/F$" ....... >V15:/F$" ....... >U15:/F$" ....... >T15:/F$" ....... >S15:/F$" ....... >R15:/F$" ....... >Q15:/F$" ....... >P15:/F$" ....... >O15:/F$" ....... >N15:/FN16:/F$" ....... >M16:/F$" ....... >L16:/F$" ....... >K16:/F$" ....... >J16:/F$" ....... >I16:/F$" ....... >H16:/F$" ....... >G16:/F$" ....... >F16:/F$" ....... >E16:/F$" ....... >D16:/F$" ....... >C16:/F$" ....... >B16:"E >A16:"REA18:"INCOME STA >Z16:/F$" ....... >Y16:/F$" ....... >X16:/F$" ....... >W16:/F$" ....... >V16:/F$" ....... >U16:/F$" ....... >T16:/F$" ....... >S16:/F$" ....... >R16:/F$" ....... >Q16:/F$" ....... >P16:/F$" ....... >O16:/F$" ....... >Y19:/FR >X19:/FR >W19:/FR >V19:/FR >U19:/FR >T19:/FR >S19:/FR >R19:/FR >Q19:/FR >P19:/FR >O19:/FR >N19:/FR >M19:/FR >L19:/FR >K19:/FR >J19:/FR >I19:/FR >H19:/FR >G19:/FR >F19:/FR >E19:/FR >D19:/FR >C19:/FR >B19:"========== >A19:"========== >B18:"TEMENT >A---- >Z20:/FR >Y20:/FR >X20:/FR >W20:/FR >V20:/FR >U20:/FR >T20:/FR >S20:/FR >R20:/FR >Q20:/FR >P20:/FR >O20:/FR >N20:/FR >M20:/FR >L20:/FR >K20:/FR >J20:/FR >I20:/FR >H20:/FR >G20:/FR >F20:/FR >E20:/FR >D20:/FR >C20:/FR >B20:"S >A20:"INVESTMENT >Z19:/FR >22:/FI" ....... >K22:/FI" ....... >J22:/FI" ....... >I22:/FI" ....... >H22:/FI" ....... >G22:/FI" ....... >F22:/FI" ....... >E22:/FI" ....... >D22:/FI" ....... >C22:/FI" ....... >B22:"NMENT >A22:"U.S. GOVER >B21:"---------- >A21:"------FI" ....... >X22:/FI" ....... >W22:/FI" ....... >V22:/FI" ....... >U22:/FI" ....... >T22:/FI" ....... >S22:/FI" ....... >R22:/FI" ....... >Q22:/FI" ....... >P22:/FI" ....... >O22:/FI" ....... >N22:/FI" ....... >M22:/FI" ....... >LI" ........ >K23:/FI" ........ >J23:/FI" ........ >I23:/FI" ........ >H23:/FI" ........ >G23:/FI" ........ >F23:/FI" ........ >E23:/FI" ........ >D23:/FI" ........ >C23:/FI" ........ >B23:"IES >A23:"U.S. AGENC >Z22:/FI" ....... >Y22:/3:/FI" ........ >W23:/FI" ........ >V23:/FI" ........ >U23:/FI" ........ >T23:/FI" ........ >S23:/FI" ........ >R23:/FI" ........ >Q23:/FI" ........ >P23:/FI" ........ >O23:/FI" ........ >N23:/FI" ........ >M23:/FI" ........ >L23:/FZ12:/F$" ....... >Y12:/F$" ....... >X12:/F$" ....... >W12:/F$" ....... >V12:/F$" ....... >U12:/F$" ....... >T12:/F$" ....... >S12:/F$" ....... >R12:/F$" ....... >Q12:/F$" ....... >P12:/F$" ....... >O12:/F$" ....... >N12:/F$" ....... >M12:/F$" ....... >L12:/F$" ....... >K12:/F$" ....... >J12:/F$" ....... >I12:/F$" ....... >H12:/F$" ....... >G12:/F$" ....... >F12:/F$" ....... >E12:/F$" ....... >D12:/F$" ....... >C12:/F$" ....... >B12:"ASED >A12:"CD'S PURCH >Z11:>AA79:" ======= >Z79:" ======= >Y79:" ======= >X79:" ======= >W79:" ======= >V79:" ======= >U79:" ======= >T79:" ======= >S79:" ======= >R79:" ======= >Q79:" ======= >P79:" ======= >O79:" ======= >N79:" ======= >M7A1:"MODEL 12 /W1 /GOC /GRM /GFG /GC10 /X>A1:>A1: "JUNE >M4:/FR"JUNE >L4:/FR"MAY >K4:/FR"MAY >J4:/FR"APRIL >I4:/FR"APRIL >H4:/FR"MARCH >G4:" MARCH >F4:" FEBRUARY >E4:" FEBRUARY >D4:/FR"JANUARY >C4:/FR"JANUARY >C3:".......... >B3:/FR".......... >A3:"DATE RUN >D1:"SES >C1:"COME EXPEN >B1:"-BUDGET IN >>E5:/FR"BUDGET >D5:/FR"ACTUAL >C5:/FR"BUDGET >A5:"INCOME >Z4:/FR"DECEMBER >Y4:/FR"DECEMBER >X4:/FR"NOVEMBER >W4:/FR"NOVEMBER >V4:/FR"OCTOBER >U4:/FR"OCTOBER >T4:/FR"SEPTEMBER >S4:/FR"SEPTEMBER >R4:/FR"AUGUST >Q4:/FR"AUGUST >P4:/FR"JULY >O4:/FR"JULY >N4:/FRT5:/FR" ACTUAL >S5:/FR"BUDGET >R5:/FR" ACTUAL >Q5:/FR"BUDGET >P5:/FR" ACTUAL >O5:/FR"BUDGET >N5:/FR" ACTUAL >M5:/FR"BUDGET >L5:/FR" ACTUAL >K5:/FR"BUDGET >J5:/FR" ACTUAL >I5:/FR"BUDGET >H5:/FR" ACTUAL >G5:/FR"BUDGET >F5:/FR" ACTUAL ======= >I6:" ======= >H6:" ======= >G6:" ======= >F6:" ======= >E6:" ======= >D6:" ======= >C6:" ======= >B6:"========== >A6:"========== >Z5:/FR" ACTUAL >Y5:/FR"BUDGET >X5:/FR" ACTUAL >W5:/FR"BUDGET >V5:/FR" ACTUAL >U5:/FR"BUDGET > ======= >Y6:" ======= >X6:" ======= >W6:" ======= >V6:" ======= >U6:" ======= >T6:" ======= >S6:" ======= >R6:" ======= >Q6:" ======= >P6:" ======= >O6:" ======= >N6:" ======= >M6:" ======= >L6:" ======= >K6:" ======= >J6:" ....... >J9:/F$" ....... >I9:/F$" ....... >H9:/F$" ....... >G9:/F$" ....... >F9:/F$" ....... >E9:/F$" ....... >D9:/F$" ....... >C9:/F$" ....... >B9:"MENT >A9:"U S GOVERN >B8:"--------- >A8:"---------- >B7:"PTIONS >A7:"RATE ASSUM >Z6:" >X9:/F$" ....... >W9:/F$" ....... >V9:/F$" ....... >U9:/F$" ....... >T9:/F$" ....... >S9:/F$" ....... >R9:/F$" ....... >Q9:/F$" ....... >P9:/F$" ....... >O9:/F$" ....... >N9:/F$" ....... >M9:/F$" ....... >L9:/F$" ....... >K9:/F$"... >L10:/F$" ....... >K10:/F$" ....... >J10:/F$" ....... >I10:/F$" ....... >H10:/F$" ....... >G10:/F$" ....... >F10:/F$" ....... >E10:/F$" ....... >D10:/F$" ....... >C10:/F$" ....... >A10:"AGENCIES >Z9:/F$" ....... >Y9:/F$" .......>Y10:/F$" ....... >X10:/F$" ....... >W10:/F$" ....... >V10:/F$" ....... >U10:/F$" ....... >T10:/F$" ....... >S10:/F$" ....... >R10:/F$" ....... >Q10:/F$" ....... >P10:/F$" ....... >O10:/F$" ....... >N10:/F$" ....... >M10:/F$" ....M11:/F$" ....... >L11:/F$" ....... >K11:/F$" ....... >J11:/F$" ....... >I11:/F$" ....... >H11:/F$" ....... >G11:/F$" ....... >F11:/F$" ....... >E11:/F$" ....... >D11:/F$" ....... >C11:/F$" ....... >A11:"MUNICIPALS >Z10:/F$" ....... /F$" ....... >Y11:/F$" ....... >X11:/F$" ....... >W11:/F$" ....... >V11:/F$" ....... >U11:/F$" ....... >T11:/F$" ....... >S11:/F$" ....... >R11:/F$" ....... >Q11:/F$" ....... >P11:/F$" ....... >O11:/F$" ....... >N11:/F$" ....... >9:" ======= >L79:" ======= >K79:" ======= >J79:" ======= >I79:" ======= >H79:" ======= >G79:" ======= >F79:" ======= >E79:" ======= >D79:" ======= >C79:"========== >B79:"========== >A79:+A78+1 >AA78:/FR+AA56+AA63+AA65+AA67+AA7gijklmnopqrstuvwxyz{|}~" ...... >T72:" ...... >S72:" ...... >R72:" ...... >Q72:" ...... >P72:" ...... >O72:" ...... >N72:" ...... >M72:" ...... >L72:" ...... >K72:" ...... >J72:" ...... >I72:" ...... >H72:" ...... >G72:" ...... >F72:" ...... >I73:" ...... >H73:" ...... >G73:" ...... >F73:" ...... >E73:" ...... >D73:" ...... >C73:"TE >B73:"CAPITAL NO >A73:+A72+1 >AA72:" ...... >Z72:" ...... >Y72:" ...... >X72:" ...... >W72:" ...... >V72:" ...... >U72: ...... >X73:" ...... >W73:" ...... >V73:" ...... >U73:" ...... >T73:" ...... >S73:" ...... >R73:" ...... >Q73:" ...... >P73:" ...... >O73:" ...... >N73:" ...... >M73:" ...... >L73:" ...... >K73:" ...... >J73:" >N74:" ...... >M74:" ...... >L74:" ...... >K74:" ...... >J74:" ...... >I74:" ...... >H74:" ...... >G74:" ...... >F74:" ...... >E74:" ...... >D74:" ...... >B74:"SURPLUS >A74:+A73+1 >AA73:" ...... >Z73:" ...... >Y73:" ROFIT >B75:"UNDIVIDED >A75:+A74+1 >AA74:" ...... >Z74:" ...... >Y74:" ...... >X74:" ...... >W74:" ...... >V74:" ...... >U74:" ...... >T74:" ...... >S74:" ...... >R74:" ...... >Q74:" ...... >P74:" ...... >O74:" ...... ...... >Q75:" ...... >P75:" ...... >O75:" ...... >N75:" ...... >M75:" ...... >L75:" ...... >K75:" ...... >J75:" ...... >I75:" ...... >H75:" ...... >G75:" ...... >F75:" ...... >E75:" ...... >D75:" ...... >C75:"P6:@SUM(F71...F75 >E76:@SUM(E71...E75 >D76:@SUM(D71...D75 >C76:"TAL >B76:"TOTAL CAPI >A76:+A75+1 >AA75:" ...... >Z75:" ...... >Y75:" ...... >X75:" ...... >W75:" ...... >V75:" ...... >U75:" ...... >T75:" ...... >S75:" ...... >R75:"UM(S71...S75 >R76:@SUM(R71...R75 >Q76:@SUM(Q71...Q75 >P76:@SUM(P71...P75 >O76:@SUM(O71...O75 >N76:@SUM(N71...N75 >M76:@SUM(M71...M75 >L76:@SUM(L71...L75 >K76:@SUM(K71...K75 >J76:@SUM(J71...J75 >I76:@SUM(I71...I75 >H76:@SUM(H71...H75 >G76:@SUM(G71...G75 >F7FR"====== >G77:/FR"====== >F77:/FR"====== >E77:/FR"====== >D77:/FR"====== >A77:+A76+1 >AA76:@SUM(AA71...AA75 >Z76:@SUM(Z71...Z75 >Y76:@SUM(Y71...Y75 >X76:@SUM(X71...X75 >W76:@SUM(W71...W75 >V76:@SUM(V71...V75 >U76:@SUM(U71...U75 >T76:@SUM(T71...T75 >S76:@SFR"====== >W77:/FR"====== >V77:/FR"====== >U77:/FR"====== >T77:/FR"====== >S77:/FR"====== >R77:/FR"====== >Q77:/FR"====== >P77:/FR"====== >O77:/FR"====== >N77:/FR"====== >M77:/FR"====== >L77:/FR"====== >K77:/FR"====== >J77:/FR"====== >I77:/FR"====== >H77:/I65+I67+I76 >H78:/FR+H56+H63+H65+H67+H76 >G78:/FR+G56+G63+G65+G67+G76 >F78:/FR+F56+F63+F65+F67+F76 >E78:/FR+E56+E63+E65+E67+E76 >D78:/FR+D56+D63+D65+D67+D76 >C78:"ILITIES >B78:"TOTAL LIABI >A78:+A77+1 >AA77:/FR"====== >Z77:/FR"====== >Y77:/FR"====== >X77:/67+R76 >Q78:/FR+Q56+Q63+Q65+Q67+Q76 >P78:/FR+P56+P63+P65+P67+P76 >O78:/FR+O56+O63+O65+O67+O76 >N78:/FR+N56+N63+N65+N67+N76 >M78:/FR+M56+M63+M65+M67+M76 >L78:/FR+L56+L63+L65+L67+L76 >K78:/FR+K56+K63+K65+K67+K76 >J78:/FR+J56+J63+J65+J67+J76 >I78:/FR+I56+I63+6 >Z78:/FR+Z56+Z63+Z65+Z67+Z76 >Y78:/FR+Y56+Y63+Y65+Y67+Y76 >X78:/FR+X56+X63+X65+X67+X76 >W78:/FR+W56+W63+W65+W67+W76 >V78:/FR+V56+V63+V65+V67+V76 >U78:/FR+U56+U63+U65+U67+U76 >T78:/FR+T56+T63+T65+T67+T76 >S78:/FR+S56+S63+S65+S67+S76 >R78:/FR+R56+R63+R65+R ...... >E72:" ...... >D72:" ...... >B72:"PREF STOCK >A72:+A71+1 >AA71:" ...... >Z71:" ...... >Y71:" ...... >X71:" ...... >W71:" ...... >V71:" ...... >U71:" ...... >T71:" ...... >S71:" ...... >R71:" ...... >Q71:" ...... >P71:" ...... >O71:" ...... >N71:" ...... >M71:" ...... >L71:" ...... >K71:" ...... >J71:" ...... >I71:" ...... >H71:" ...... >G71:" ...... >F71:" ...... >E71:" ...... >D71:" ...... >C71:"CK >B71:"COMMON STO >A71...L55) >K56:@SUM(K51...K55) >J56:@SUM(J51...J55) >I56:@SUM(I51...I55) >H56:@SUM(H51...H55) >G56:@SUM(G51...G55) >F56:@SUM(F51...F55) >E56:@SUM(E51...E55) >D56:@SUM(D51...D55) >C56:"SITS >B56:"TOTAL DEPO >A56:+A55+1 >AA55:" ...... >Z55:" ...... >Y55M(X51...X55) >W56:@SUM(W51...W55) >V56:@SUM(V51...V55) >U56:@SUM(U51...U55) >T56:@SUM(T51...T55) >S56:@SUM(S51...S55) >R56:@SUM(R51...R55) >Q56:@SUM(Q51...Q55) >P56:@SUM(P51...P55) >O56:@SUM(O51...O55) >N56:@SUM(N51...N55) >M56:@SUM(M51...M55) >L56:@SUM(L5 ....... >E60:" ....... >D60:" ....... >C60:"PURCH >B60:"FED FUNDS >A60:+A59+1 >C59:"-------- >B59:"---------- >A59:+A58+1 >C58:"UNDS >B58:"BORROWED F >A58:+A57+1 >A57:+A56+1 >AA56:@SUM(AA51...AA55) >Z56:@SUM(Z51...Z55) >Y56:@SUM(Y51...Y55) >X56:@SU" ....... >S60:" ....... >R60:" ....... >Q60:" ....... >P60:" ....... >O60:" ....... >N60:" ....... >M60:" ....... >L60:" ....... >K60:" ....... >J60:" ....... >I60:" ....... >H60:" ....... >G60:" ....... >F60:" 1:" ...... >H61:" ...... >G61:" ...... >F61:" ...... >E61:" ...... >D61:" ...... >B61:"REPO'S >A61:+A60+1 >AA60:" ....... >Z60:" ....... >Y60:" ....... >X60:" ....... >W60:" ....... >V60:" ....... >U60:" ....... >T60:61:" ...... >W61:" ...... >V61:" ...... >U61:" ...... >T61:" ...... >S61:" ...... >R61:" ...... >Q61:" ...... >P61:" ...... >O61:" ...... >N61:" ...... >M61:" ...... >L61:" ...... >K61:" ...... >J61:" ...... >I6 ...... >L62:" ...... >K62:" ...... >J62:" ...... >I62:" ...... >H62:" ...... >G62:" ...... >F62:" ...... >E62:" ...... >D62:" ...... >C62:"& LOAN >B62:"TREAS TAX >A62:+A61+1 >AA61:" ...... >Z61:" ...... >Y61:" ...... >X:+A62+1 >AA62:" ...... >Z62:" ...... >Y62:" ...... >X62:" ...... >W62:" ...... >V62:" ...... >U62:" ...... >T62:" ...... >S62:" ...... >R62:" ...... >Q62:" ...... >P62:" ...... >O62:" ...... >N62:" ...... >M62:" O62 >N63:@SUM(N60...N62 >M63:@SUM(M60...M62 >L63:@SUM(L60...L62 >K63:@SUM(K60...K62 >J63:@SUM(J60...J62 >I63:@SUM(I60...I62 >H63:@SUM(H60...H62 >G63:@SUM(G60...G62 >F63:@SUM(F60...F62 >E63:@SUM(E60...E62 >D63:@SUM(D60...D62 >C63:"OWED >B63:"TOTAL BORR >A6363:@SUM(AA60...AA62 >Z63:@SUM(Z60...Z62 >Y63:@SUM(Y60...Y62 >X63:@SUM(X60...X62 >W63:@SUM(W60...W62 >V63:@SUM(V60...V62 >U63:@SUM(U60...U62 >T63:@SUM(T60...T62 >S63:@SUM(S60...S62 >R63:@SUM(R60...R62 >Q63:@SUM(Q60...Q62 >P63:@SUM(P60...P62 >O63:@SUM(O60... ...... >N65:" ...... >M65:" ...... >L65:" ...... >K65:" ...... >J65:" ...... >I65:" ...... >H65:" ...... >G65:" ...... >F65:" ...... >E65:" ...... >D65:" ...... >C65:"ILITIES >B65:"OTHER LIAB >A65:+A64+1 >A64:+A63+1 >AABTS >B67:"RES FOR BA >A67:+A66+1 >A66:+A65+1 >AA65:" ...... >Z65:" ...... >Y65:" ...... >X65:" ...... >W65:" ...... >V65:" ...... >U65:" ...... >T65:" ...... >S65:" ...... >R65:" ...... >Q65:" ...... >P65:" ...... >O65:" ...... >Q67:" ...... >P67:" ...... >O67:" ...... >N67:" ...... >M67:" ...... >L67:" ...... >K67:" ...... >J67:" ...... >I67:" ...... >H67:" ...... >G67:" ...... >F67:" ...... >E67:" ...... >D67:" ...... >C67:"D DE1:+A70+1 >C70:"--------- >B70:"---------- >A70:+A69+1 >B69:"CAPITAL >A69:+A68+1 >A68:+A67+1 >AA67:" ...... >Z67:" ...... >Y67:" ...... >X67:" ...... >W67:" ...... >V67:" ...... >U67:" ...... >T67:" ...... >S67:" ...... >R67:" :" ...... >X55:" ...... >W55:" ...... >V55:" ...... >U55:" ...... >T55:" ...... >S55:" ...... >R55:" ...... >Q55:" ...... >P55:" ...... >O55:" ...... >N55:" ...... >M55:" ...... >L55:" ...... >K55:" ...... >J55:" ...... >I55:" ...... >H55:" ...... >G55:" ...... >F55:" ...... >E55:" ...... >D55:" ...... >B55:"LARGE CD'S >A55:+A54+1 >AA54:" ...... >Z54:" ...... >Y54:" ...... >X54:" ...... >W54:" ...... >V54:" ...... >U54:" == >N41:" ======== >M41:" ======== >L41:" ======== >K41:" ======== >J41:" ======== >I41:" ======== >H41:" ======== >G41:" ======== >F41:" ======== >E41:" ======= >D41:" ======== >C41:"========== >B41:"=========== >A41:+A40+1 >AA40:+>A43:+A42+1 >A42:+A41+1 >AA41:" ======== >Z41:" ======== >Y41:" ======== >X41:" ======== >W41:" ======== >V41:" ======== >U41:" ======== >T41:" ======== >S41:" ======== >R41:" ======== >Q41:" ======== >P41:" ======== >O41:" ======"AUGUST >Q46:/FR"JULY >P46:/FR"JULY >O46:/FR"JUNE >N46:/FR"JUNE >M46:/FR"MAY >L46:/FR"MAY >K46:/FR"APRIL >J46:/FR"APRIL >I46:/FR"MARCH >H46:/FR"MARCH >G46:/FR"FEBRUARY >F46:/FR"FEBRUARY >E46:/FR"JANUARY >D46:/FR"JANUARY >A46:+A45+1 >A45:+A44+1 >A44:+A43+1 L >F47:/FR"BUDGET >E47:/FR"ACTUAL >D47:/FR"BUDGET >C47:"S >B47:"LIABILITIE >A47:+A46+1 >AA46:/FR"DECEMBER >Z46:/FR"DECEMBER >Y46:/FR"NOVEMBER >X46:/FR"NOVEMBER >W46:/FR"OCTOBER >V46:/FR"OCTOBER >U46:/FR"SEPTEMBER >T46:/FR"SEPTEMBER >S46:/FR"AUGUST >R46:/FRL >V47:/FR"BUDGET >U47:/FR"ACTUAL >T47:/FR"BUDGET >S47:/FR"ACTUAL >R47:/FR"BUDGET >Q47:/FR"ACTUAL >P47:/FR"BUDGET >O47:/FR"ACTUAL >N47:/FR"BUDGET >M47:/FR"ACTUAL >L47:/FR"BUDGET >K47:/FR"ACTUAL >J47:/FR"BUDGET >I47:/FR"ACTUAL >H47:/FR"BUDGET >G47:/FR"ACTUA=== >J48:" ======= >I48:" ======= >H48:" ======= >G48:" ======= >F48:" ======= >E48:" ======= >D48:" ======= >C48:"========== >B48:"========== >A48:+A47+1 >AA47:/FR"ACTUAL >Z47:/FR"BUDGET >Y47:/FR"ACTUAL >X47:/FR"BUDGET >W47:/FR"ACTUA======= >X48:" ======= >W48:" ======= >V48:" ======= >U48:" ======= >T48:" ======= >S48:" ======= >R48:" ======= >Q48:" ======= >P48:" ======= >O48:" ======= >N48:" ======= >M48:" ======= >L48:" ======= >K48:" ====51:" ...... >I51:" ...... >H51:" ...... >G51:" ...... >F51:" ...... >E51:" ...... >D51:" ...... >B51:"DDA >A51:+A50+1 >C50:"------- >B50:"---------- >A50:+A49+1 >B49:"DEPOSITS >A49:+A48+1 >AA48:" ======= >Z48:" ======= >Y48:" Y51:" ...... >X51:" ...... >W51:" ...... >V51:" ...... >U51:" ...... >T51:" ...... >S51:" ...... >R51:" ...... >Q51:" ...... >P51:" ...... >O51:" ...... >N51:" ...... >M51:" ...... >L51:" ...... >K51:" ...... >J ...... >M52:" ...... >L52:" ...... >K52:" ...... >J52:" ...... >I52:" ...... >H52:" ...... >G52:" ...... >F52:" ...... >E52:" ...... >D52:" ...... >C52:"NOW >B52:"REG SAV & >A52:+A51+1 >AA51:" ...... >Z51:" ...... >3:"STATE OF ILL >A53:+A52+1 >AA52:" ...... >Z52:" ...... >Y52:" ...... >X52:" ...... >W52:" ...... >V52:" ...... >U52:" ...... >T52:" ...... >S52:" ...... >R52:" ...... >Q52:" ...... >P52:" ...... >O52:" ...... >N52:" >Q53:" ...... >P53:" ...... >O53:" ...... >N53:" ...... >M53:" ...... >L53:" ...... >K53:" ...... >J53:" ...... >I53:" ...... >H53:" ...... >G53:" ...... >F53:" ...... >E53:" ...... >D53:" ...... >C53:"LLINOIS >B5..... >E54:" ...... >D54:" ...... >C54:"EPOSIT >B54:"CERT. OF DEPOS >A54:+A53+1 >AA53:" ...... >Z53:" ...... >Y53:" ...... >X53:" ...... >W53:" ...... >V53:" ...... >U53:" ...... >T53:" ...... >S53:" ...... >R53:" ............ >T54:" ...... >S54:" ...... >R54:" ...... >Q54:" ...... >P54:" ...... >O54:" ...... >N54:" ...... >M54:" ...... >L54:" ...... >K54:" ...... >J54:" ...... >I54:" ...... >H54:" ...... >G54:" ...... >F54:" .AA8+AA18+AA27+AA36+AA38 >Z40:+Z8+Z18+Z27+Z36+Z38 >Y40:+Y8+Y18+Y27+Y36+Y38 >X40:+X8+X18+X27+X36+X38 >W40:+W8+W18+W27+W36+W38 >V40:+V8+V18+V27+V36+V38 >U40:+U8+U18+U27+U36+U38 >T40:+T8+T18+T27+T36+T38 >S40:+S8+S18+S27+S36+S38 >R40:+R8+R18+R27+R36+R38 >Q40:+Q8+Q18+Q27+Q36+Q38 >P40:+P8+P18+P27+P36+P38 >O40:+O8+O18+O27+O36+O38 >N40:+N8+N18+N27+N36+N38 >M40:+M8+M18+M27+M36+M38 >L40:+L8+L18+L27+L36+L38 >K40:+K8+K18+K27+K36+K38 >J40:+J8+J18+J27+J36+J38 >I40:+I8+I18+I27+I36+I38 >H40:+H8+H18+H27+H36+H38 >G40:+G8+G18+...... >Y31:" ...... >X31:" ...... >W31:" ...... >V31:" ...... >U31:" ...... >T31:" ...... >S31:" ...... >R31:" ...... >Q31:" ...... >P31:" ...... >O31:" ...... >N31:" ...... >M31:" ...... >L31:" ...... >K31:" .:" ...... >M32:" ...... >L32:" ...... >K32:" ...... >J32:" ...... >I32:" ...... >H32:" ...... >G32:" ...... >F32:" ...... >E32:" ...... >D32:" ...... >C32:"& FIXTURES >B32:"FURNITURE >A32:+A31+1 >AA31:" ...... >Z31:" ..... >B33:"LAND >A33:+A32+1 >AA32:" ...... >Z32:" ...... >Y32:" ...... >X32:" ...... >W32:" ...... >V32:" ...... >U32:" ...... >T32:" ...... >S32:" ...... >R32:" ...... >Q32:" ...... >P32:" ...... >O32:" ...... >N32...... >R33:" ...... >Q33:" ...... >P33:" ...... >O33:" ...... >N33:" ...... >M33:" ...... >L33:" ...... >K33:" ...... >J33:" ...... >I33:" ...... >H33:" ...... >G33:" ...... >F33:" ...... >E33:" ...... >D33:" .4:" ...... >G34:" ...... >F34:" ...... >E34:" ...... >D34:" ...... >B34:"O.R.E.O. >A34:+A33+1 >AA33:" ...... >Z33:" ...... >Y33:" ...... >X33:" ...... >W33:" ...... >V33:" ...... >U33:" ...... >T33:" ...... >S33:" 34:" ...... >V34:" ...... >U34:" ...... >T34:" ...... >S34:" ...... >R34:" ...... >Q34:" ...... >P34:" ...... >O34:" ...... >N34:" ...... >M34:" ...... >L34:" ...... >K34:" ...... >J34:" ...... >I34:" ...... >H3 ...... >K35:" ...... >J35:" ...... >I35:" ...... >H35:" ...... >G35:" ...... >F35:" ...... >E35:" ...... >D35:" ...... >C35:"ERTY >B35:"LEASE PROP >A35:+A34+1 >AA34:" ...... >Z34:" ...... >Y34:" ...... >X34:" ...... >W ...... >Z35:" ...... >Y35:" ...... >X35:" ...... >W35:" ...... >V35:" ...... >U35:" ...... >T35:" ...... >S35:" ...... >R35:" ...... >Q35:" ...... >P35:" ...... >O35:" ...... >N35:" ...... >M35:" ...... >L35:" 36:@SUM(M31...M35) >L36:@SUM(L31...L35) >K36:@SUM(K31...K35) >J36:@SUM(J31...J35) >I36:@SUM(I31...I35) >H36:@SUM(H31...H35) >G36:@SUM(G31...G35) >F36:@SUM(F31...F35) >E36:@SUM(E31...E35) >D36:@SUM(D31...D35) >C36:"ISES >B36:"TOTAL PREM >A36:+A35+1 >AA35:" ) >Y36:@SUM(Y31...Y35) >X36:@SUM(X31...X35) >W36:@SUM(W31...W35) >V36:@SUM(V31...V35) >U36:@SUM(U31...U35) >T36:@SUM(T31...T35) >S36:@SUM(S31...S35) >R36:@SUM(R31...R35) >Q36:@SUM(Q31...Q35) >P36:@SUM(P31...P35) >O36:@SUM(O31...O35) >N36:@SUM(N31...N35) >M ...... >L38:" ...... >K38:" ...... >J38:" ...... >I38:" ...... >H38:" ...... >G38:" ...... >F38:" ...... >E38:" ...... >D38:" ...... >C38:"TS >B38:"OTHER ASSE >A38:+A37+1 >A37:+A36+1 >AA36:@SUM(AA31...AA35) >Z36:@SUM(Z31...Z3539:+A38+1 >AA38:" ...... >Z38:" ...... >Y38:" ...... >X38:" ...... >W38:" ...... >V38:" ...... >U38:" ...... >T38:" ...... >S38:" ...... >R38:" ...... >Q38:" ...... >P38:" ...... >O38:" ...... >N38:" ...... >M38:" 39:/FR"====== >R39:/FR"====== >Q39:/FR"====== >P39:/FR"====== >O39:/FR"====== >N39:/FR"====== >M39:/FR"====== >L39:/FR"====== >K39:/FR"====== >J39:/FR"====== >I39:/FR"====== >H39:/FR"====== >G39:/FR"====== >F39:/FR"====== >E39:/FR"====== >D39:/FR"====== >AG27+G36+G38 >F40:+F8+F18+F27+F36+F38 >E40:+E8+E18+E27+E36+E38 >D40:+D8+D18+D27+D36+D38 >C40:"TS >B40:"TOTAL ASSE >A40:+A39+1 >AA39:/FR"====== >Z39:/FR"====== >Y39:/FR"====== >X39:/FR"====== >W39:/FR"====== >V39:/FR"====== >U39:/FR"====== >T39:/FR"====== >S..... >J31:" ...... >I31:" ...... >H31:" ...... >G31:" ...... >F31:" ...... >E31:" ...... >D31:" ...... >B31:"BUILDING >A31:+A30+1 >C30:"------- >B30:"---------- >A30:+A29+1 >B29:"PREMISES >A29:+A28+1 >A28:+A27+1 >AA27:@SUM(AA22...AA26) >Z27:@SUM(Z22...Z26) >Y27:@SUM(Y22...Y26) >X27:@SUM(X22...X26) >W27:@SUM(W22...W26) >V27:@SUM(V22...V26) >U27:@SUM(U22...U26) >T27:@SUM(T22...T26) >S27:@SUM(S22...S26) >R27:@SUM(R22...R26) >Q27:@SUM(Q22...Q26) >P27:@SUM(P22...P26) >O27:@SUM(O22...O26) >.... >O17:" ...... >N17:" ...... >M17:" ...... >L17:" ...... >K17:" ...... >J17:" ...... >I17:" ...... >H17:" ...... >G17:" ...... >F17:" ...... >E17:" ...... >D17:" ...... >C17:"SOLD >B17:"FED FUNDS >A17:+A16+1 >AA16:" UM(D12...D17) >C18:"STMENT >B18:"TOTAL INVE >A18:+A17+1 >AA17:" ...... >Z17:" ...... >Y17:" ...... >X17:" ...... >W17:" ...... >V17:" ...... >U17:" ...... >T17:" ...... >S17:" ...... >R17:" ...... >Q17:" ...... >P17:" ..8:@SUM(P12...P17) >O18:@SUM(O12...O17) >N18:@SUM(N12...N17) >M18:@SUM(M12...M17) >L18:@SUM(L12...L17) >K18:@SUM(K12...K17) >J18:@SUM(J12...J17) >I18:@SUM(I12...I17) >H18:@SUM(H12...H17) >G18:@SUM(G12...G17) >F18:@SUM(F12...F17) >E18:@SUM(E12...E17) >D18:@S+A19+1 >A19:+A18+1 >AA18:@SUM(AA12...AA17) >Z18:@SUM(Z12...Z17) >Y18:@SUM(Y12...Y17) >X18:@SUM(X12...X17) >W18:@SUM(W12...W17) >V18:@SUM(V12...V17) >U18:@SUM(U12...U17) >T18:@SUM(T12...T17) >S18:@SUM(S12...S17) >R18:@SUM(R12...R17) >Q18:@SUM(Q12...Q17) >P1.. >L22:" ...... >K22:" ...... >J22:" ...... >I22:" ...... >H22:" ...... >G22:" ...... >F22:" ...... >E22:" ...... >D22:" ...... >C22:"MENT >B22:"SINGLE PAY >A22:+A21+1 >C21:"------ >B21:"---------- >A21:+A20+1 >B20:"LOANS >A20:+1 >AA22:" ...... >Z22:" ...... >Y22:" ...... >X22:" ...... >W22:" ...... >V22:" ...... >U22:" ...... >T22:" ...... >S22:" ...... >R22:" ...... >Q22:" ...... >P22:" ...... >O22:" ...... >N22:" ...... >M22:" .... ...... >O23:" ...... >N23:" ...... >M23:" ...... >L23:" ...... >K23:" ...... >J23:" ...... >I23:" ...... >H23:" ...... >G23:" ...... >F23:" ...... >E23:" ...... >D23:" ...... >C23:"NSTALLMENT >B23:"CONSUMER I >A23:+A22. >D24:" ...... >C24:"CREDIT >B24:"REVOLVING >A24:+A23+1 >AA23:" ...... >Z23:" ...... >Y23:" ...... >X23:" ...... >W23:" ...... >V23:" ...... >U23:" ...... >T23:" ...... >S23:" ...... >R23:" ...... >Q23:" ...... >P23:" .. >S24:" ...... >R24:" ...... >Q24:" ...... >P24:" ...... >O24:" ...... >N24:" ...... >M24:" ...... >L24:" ...... >K24:" ...... >J24:" ...... >I24:" ...... >H24:" ...... >G24:" ...... >F24:" ...... >E24:" .....>H25:" ...... >G25:" ...... >F25:" ...... >E25:" ...... >D25:" ...... >C25:"E >B25:"REAL ESTAT >A25:+A24+1 >AA24:" ...... >Z24:" ...... >Y24:" ...... >X24:" ...... >W24:" ...... >V24:" ...... >U24:" ...... >T24:" .... >W25:" ...... >V25:" ...... >U25:" ...... >T25:" ...... >S25:" ...... >R25:" ...... >Q25:" ...... >P25:" ...... >O25:" ...... >N25:" ...... >M25:" ...... >L25:" ...... >K25:" ...... >J25:" ...... >I25:" ...... ...... >L26:" ...... >K26:" ...... >J26:" ...... >I26:" ...... >H26:" ...... >G26:" ...... >F26:" ...... >E26:" ...... >D26:" ...... >B26:"OTHER >A26:+A25+1 >AA25:" ...... >Z25:" ...... >Y25:" ...... >X25:" ......A27:+A26+1 >AA26:" ...... >Z26:" ...... >Y26:" ...... >X26:" ...... >W26:" ...... >V26:" ...... >U26:" ...... >T26:" ...... >S26:" ...... >R26:" ...... >Q26:" ...... >P26:" ...... >O26:" ...... >N26:" ...... >M26:"N27:@SUM(N22...N26) >M27:@SUM(M22...M26) >L27:@SUM(L22...L26) >K27:@SUM(K22...K26) >J27:@SUM(J22...J26) >I27:@SUM(I22...I26) >H27:@SUM(H22...H26) >G27:@SUM(G22...G26) >F27:@SUM(F22...F26) >E27:@SUM(E22...E26) >D27:@SUM(D22...D26) >C27:"S >B27:"TOTAL LOAN > ...... >Z16:" ...... >Y16:" ...... >X16:" ...... >W16:" ...... >V16:" ...... >U16:" ...... >T16:" ...... >S16:" ...... >R16:" ...... >Q16:" ...... >P16:" ...... >O16:" ...... >N16:" ...... >M16:" ...... >L16:" ...... >K16:" ...... >J16:" ...... >I16:" ...... >H16:" ...... >G16:" ...... >F16:" ...... >E16:" ...... >D16:" ...... >C16:"ES PURCH. >B16:"CERTIFICATES >A16:+A15+1 >AA15:" ...... >Z15:" ...... >Y15:" ...... >X15:" ..FR"MAY >K5:/FR"APRIL >J5:/FR"APRIL >I5:/FR"MARCH >H5:/FR"MARCH >G5:/FR"FEBRUARY >F5:/FR"FEBRUARY >E5:/FR"JANUARY >D5:/FR"JANUARY >A5:+A4+1 >C4:/FR >A4:+A3+1 >C3:".......... >B3:"DATE RUN >A3:+A2+1 >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >6:"ASSETS >A6:+A5+1 >AA5:/FR"DECEMBER >Z5:/FR"DECEMBER >Y5:/FR"NOVEMBER >X5:/FR"NOVEMBER >W5:/FR"OCTOBER >V5:/FR"OCTOBER >U5:/FR"SEPTEMBER >T5:/FR"SEPTEMBER >S5:/FR"AUGUST >R5:/FR"AUGUST >Q5:/FR"JULY >P5:/FR"JULY >O5:/FR"JUNE >N5:/FR"JUNE >M5:/FR"MAY >L5:/T6:/FR"BUDGET >S6:/FR"ACTUAL >R6:/FR"BUDGET >Q6:/FR"ACTUAL >P6:/FR"BUDGET >O6:/FR"ACTUAL >N6:/FR"BUDGET >M6:/FR"ACTUAL >L6:/FR"BUDGET >K6:/FR"ACTUAL >J6:/FR"BUDGET >I6:/FR"ACTUAL >H6:/FR"BUDGET >G6:/FR"ACTUAL >F6:/FR"BUDGET >E6:/FR"ACTUAL >D6:/FR"BUDGET >B==== >I7:" ======== >H7:" ======== >G7:" ======== >F7:" ======== >E7:" ======= >D7:" ======== >C7:"========== >B7:"========== >A7:+A6+1 >AA6:/FR"ACTUAL >Z6:/FR"BUDGET >Y6:/FR"ACTUAL >X6:/FR"BUDGET >W6:/FR"ACTUAL >V6:/FR"BUDGET >U6:/FR"ACTUAL >===== >X7:" ======== >W7:" ======== >V7:" ======== >U7:" ======== >T7:" ======== >S7:" ======== >R7:" ======== >Q7:" ======== >P7:" ======== >O7:" ======== >N7:" ======== >M7:" ======== >L7:" ======== >K7:" ======== >J7:" ====:" ...... >M8:" ...... >L8:" ...... >K8:" ...... >J8:" ...... >I8:" ...... >H8:" ...... >G8:" ...... >F8:" ...... >E8:" ...... >D8:" ...... >C8:" FROM >B8:"CASH & DUE >A8:+A7+1 >AA7:" ======== >Z7:" ======== >Y7:" ===10:"S >B10:"INVESTMENT >A10:+A9+1 >A9:+A8+1 >AA8:" ...... >Z8:" ...... >Y8:" ...... >X8:" ...... >W8:" ...... >V8:" ...... >U8:" ...... >T8:" ...... >S8:" ...... >R8:" ...... >Q8:" ...... >P8:" ...... >O8:" ...... >N8....... >L12:" ....... >K12:" ....... >J12:" ....... >I12:" ....... >H12:" ....... >G12:" ....... >F12:" ....... >E12:" ...... >D12:" ....... >C12:"NMENT >B12:"U.S. GOVERNM >A12:+A11+1 >C11:"----- >B11:"---------- >A11:+A10+1 >C ....... >Z12:" ....... >Y12:" ....... >X12:" ....... >W12:" ....... >V12:" ....... >U12:" ....... >T12:" ....... >S12:" ....... >R12:" ....... >Q12:" ....... >P12:" ....... >O12:" ....... >N12:" ....... >M12:" ..... >O13:" ...... >N13:" ...... >M13:" ...... >L13:" ...... >K13:" ...... >J13:" ...... >I13:" ...... >H13:" ...... >G13:" ...... >F13:" ...... >E13:" ...... >D13:" ...... >C13:"IES >B13:"U.S. AGENC >A13:+A12+1 >AA12:" ...... >D14:" ...... >B14:"MUNICIPALS >A14:+A13+1 >AA13:" ...... >Z13:" ...... >Y13:" ...... >X13:" ...... >W13:" ...... >V13:" ...... >U13:" ...... >T13:" ...... >S13:" ...... >R13:" ...... >Q13:" ...... >P13:" ." ...... >S14:" ...... >R14:" ...... >Q14:" ...... >P14:" ...... >O14:" ...... >N14:" ...... >M14:" ...... >L14:" ...... >K14:" ...... >J14:" ...... >I14:" ...... >H14:" ...... >G14:" ...... >F14:" ...... >E14:"... >H15:" ...... >G15:" ...... >F15:" ...... >E15:" ...... >D15:" ...... >C15:" STOCK >B15:"CORP & FRB >A15:+A14+1 >AA14:" ...... >Z14:" ...... >Y14:" ...... >X14:" ...... >W14:" ...... >V14:" ...... >U14:" ...... >T14:.... >W15:" ...... >V15:" ...... >U15:" ...... >T15:" ...... >S15:" ...... >R15:" ...... >Q15:" ...... >P15:" ...... >O15:" ...... >N15:" ...... >M15:" ...... >L15:" ...... >K15:" ...... >J15:" ...... >I15:" ...F1:"L >E1:"T TO ACTUA >D1:"HEET BUDGE >C1:" BALANCE S >B1:"MODEL 13 >A1:1 /W1 /GOC /GRM /GFG /GC10 /X>A1:>A1: >G45:/F$@AVERAGE(G12...G42) >F45:/F$@AVERAGE(F12...F42) >E45:/F$@AVERAGE(E12...E42) >D45:/F$@AVERAGE(D12...D42) >C45:/F$@AVERAGE(C12...C42) >B45:" RATE >A45:+A44+1 >C44:/F$ >B44:"AVERAGE >A44:+A43+1 >G43:"========== >F43:"========== >E43:"========= >D43:>G18:/F$" ....... >F18:/F$" ....... >E18:/F$" ....... >D18:/F$" ....... >C18:/F$" ....... >B18:7 >A18:+A17+1 >G17:/F$" ....... >F17:/F$" ....... >E17:/F$" ....... >D17:/F$" ....... >C17:/F$" ....... >B17:6 >A17:+A16+1 >G16:/F$" ....... >F16:/F$"....... >B21:10 >A21:+A20+1 >G20:/F$" ....... >F20:/F$" ....... >E20:/F$" ....... >D20:/F$" ....... >C20:/F$" ....... >B20:9 >A20:+A19+1 >G19:/F$" ....... >F19:/F$" ....... >E19:/F$" ....... >D19:/F$" ....... >C19:/F$" ....... >B19:8 >A19:+A18+1 :/F$" ....... >C23:/F$" ....... >B23:12 >A23:+A22+1 >G22:/F$" ....... >F22:/F$" ....... >E22:/F$" ....... >D22:/F$" ....... >C22:/F$" ....... >B22:11 >A22:+A21+1 >G21:/F$" ....... >F21:/F$" ....... >E21:/F$" ....... >D21:/F$" ....... >C21:/F$" .. >E25:/F$" ....... >D25:/F$" ....... >C25:/F$" ....... >B25:14 >A25:+A24+1 >G24:/F$" ....... >F24:/F$" ....... >E24:/F$" ....... >D24:/F$" ....... >C24:/F$" ....... >B24:13 >A24:+A23+1 >G23:/F$" ....... >F23:/F$" ....... >E23:/F$" ....... >D23 ....... >F27:/F$" ....... >E27:/F$" ....... >D27:/F$" ....... >C27:/F$" ....... >B27:16 >A27:+A26+1 >G26:/F$" ....... >F26:/F$" ....... >E26:/F$" ....... >D26:/F$" ....... >C26:/F$" ....... >B26:15 >A26:+A25+1 >G25:/F$" ....... >F25:/F$" .....0:19 >A30:+A29+1 >G29:/F$" ....... >F29:/F$" ....... >E29:/F$" ....... >D29:/F$" ....... >C29:/F$" ....... >B29:18 >A29:+A28+1 >G28:/F$" ....... >F28:/F$" ....... >E28:/F$" ....... >D28:/F$" ....... >C28:/F$" ....... >B28:17 >A28:+A27+1 >G27:/F$"... >C32:/F$" ....... >B32:21 >A32:+A31+1 >G31:/F$" ....... >F31:/F$" ....... >E31:/F$" ....... >D31:/F$" ....... >C31:/F$" ....... >B31:20 >A31:+A30+1 >G30:/F$" ....... >F30:/F$" ....... >E30:/F$" ....... >D30:/F$" ....... >C30:/F$" ....... >B3" ....... >D34:/F$" ....... >C34:/F$" ....... >B34:23 >A34:+A33+1 >G33:/F$" ....... >F33:/F$" ....... >E33:/F$" ....... >D33:/F$" ....... >C33:/F$" ....... >B33:22 >A33:+A32+1 >G32:/F$" ....... >F32:/F$" ....... >E32:/F$" ....... >D32:/F$" ....F36:/F$" ....... >E36:/F$" ....... >D36:/F$" ....... >C36:/F$" ....... >B36:25 >A36:+A35+1 >G35:/F$" ....... >F35:/F$" ....... >E35:/F$" ....... >D35:/F$" ....... >C35:/F$" ....... >B35:24 >A35:+A34+1 >G34:/F$" ....... >F34:/F$" ....... >E34:/F$A38+1 >G38:/F$" ....... >F38:/F$" ....... >E38:/F$" ....... >D38:/F$" ....... >C38:/F$" ....... >B38:27 >A38:+A37+1 >G37:/F$" ....... >F37:/F$" ....... >E37:/F$" ....... >D37:/F$" ....... >C37:/F$" ....... >B37:26 >A37:+A36+1 >G36:/F$" ....... >$" ....... >B41:30 >A41:+A40+1 >G40:/F$" ....... >F40:/F$" ....... >E40:/F$" ....... >D40:/F$" ....... >C40:/F$" ....... >B40:29 >A40:+A39+1 >G39:/F$" ....... >F39:/F$" ....... >E39:/F$" ....... >D39:/F$" ....... >C39:/F$" ....... >B39:28 >A39:+"========= >C43:/F$"========= >B43:" ===== >A43:+A42+1 >G42:/F$" ....... >F42:/F$" ....... >E42:/F$" ....... >D42:/F$" ....... >C42:/F$" ....... >B42:31 >A42:+A41+1 >G41:/F$" ....... >F41:/F$" ....... >E41:/F$" ....... >D41:/F$" ....... >C41:/F ....... >E16:/F$" ....... >D16:/F$" ....... >C16:/F$" ....... >B16:5 >A16:+A15+1 >G15:/F$" ....... >F15:/F$" ....... >E15:/F$" ....... >D15:/F$" ....... >C15:/F$" ....... >B15:4 >A15:+A14+1 >G14:/F$" ....... >F14:/F$" ....... >E14:/F$" ....... >D14:/F$" ....... >C14:/F$" ....... >B14:3 >A14:+A13+1 >G13:/F$" ....... >F13:/F$" ....... >E13:/F$" ....... >D13:/F$" ....... >C13:/F$" ....... >B13:2 >A13:+A12+1 >G12:/F$" ....... >F12:/F$" ....... >E12:/F$" ....... >D12:/F$" ....... >C12:/F$ >Q164:+Q83-Q107 >P164:+P83-P107 >O164:+O83-O107 >N164:+N83-N107 >M164:+M83-M107 >L164:+L83-L107 >K164:+K83-K107 >J164:+J83-J107 >I164:+I83-I107 >H164:+H83-H107 >G164:"ECT >F164:"ED TAX EFFE >E164:" OF RELAT >G163:"OSSES, NET >F163:"AINS OR -LOSS >E163:"S65:" ---------- >R165:" ---------- >Q165:" ---------- >P165:" ---------- >O165:" ---------- >N165:" ---------- >M165:" ---------- >L165:" ---------- >K165:" ---------- >J165:" ---------- >I165:" ---------- >H165:" ---------- >S164:+S83-S107 >R164:+R83-R107:@SUM(Q159...Q165) >P166:@SUM(P159...P165) >O166:@SUM(O159...O165) >N166:@SUM(N159...N165) >M166:@SUM(M159...M165) >L166:@SUM(L159...L165) >K166:@SUM(K159...K165) >J166:@SUM(J159...J165) >I166:@SUM(I159...I165) >H166:@SUM(H159...H165) >E166:"NET INCOME >S1== >Q167:" =========== >P167:" =========== >O167:" =========== >N167:" =========== >M167:" =========== >L167:" =========== >K167:" =========== >J167:" =========== >I167:" =========== >H167:" =========== >S166:@SUM(S159...S165) >R166:@SUM(R159...R165) >Q16600,@IF(H164=0,0,(H127*@CHOOSE(H50,C53...C64)/H83*100))) >G171:"--------> >F171:" RATE OF >E171:" EFFECTIVE >G170:"ANNUAL >F170:"TED AT AN >E170:" TAX EFFECT >N169:/FG >G169:"S ARE >F169:"RANSACTIONS >E169:"SECURITY TR >S167:" =========== >R167:" =========0,(K127*@CHOOSE(K50,C53...C64)/K83*100))) >J171:/FI@ABS(@IF(J17>0,J127/J83*100,@IF(J164=0,0,(J127*@CHOOSE(J50,C53...C64)/J83*100))) >I171:/FI@ABS(@IF(I17>0,I127/I83*100,@IF(I164=0,0,(I127*@CHOOSE(I50,C53...C64)/I83*100))) >H171:/FI@ABS(@IF(H17>0,H127/H83*1E(N50,C53...C64)/N83*100))) >M171:/FI@ABS(@IF(M17>0,M127/M83*100,@IF(M164=0,0,(M127*@CHOOSE(M50,C53...C64)/M83*100))) >L171:/FI@ABS(@IF(L17>0,L127/L83*100,@IF(L164=0,0,(L127*@CHOOSE(L50,C53...C64)/L83*100))) >K171:/FI@ABS(@IF(K17>0,K127/K83*100,@IF(K164=0,4)/Q83*100))) >P171:/FI@ABS(@IF(P17>0,P127/P83*100,@IF(P164=0,0,(P127*@CHOOSE(P50,C53...C64)/P83*100))) >O171:/FI@ABS(@IF(O17>0,O127/O83*100,@IF(O164=0,0,(O127*@CHOOSE(O50,C53...C64)/O83*100))) >N171:/FI@ABS(@IF(N17>0,N127/N83*100,@IF(N164=0,0,(N127*@CHOOS>S171:/FI@ABS(@IF(S17>0,S127/S83*100,@IF(S164=0,0,(S127*@CHOOSE(S50,C53...C64)/S83*100))) >R171:/FI@ABS(@IF(R17>0,R127/R83*100,@IF(R164=0,0,(R127*@CHOOSE(R50,C53...C64)/R83*100))) >Q171:/FI@ABS(@IF(Q17>0,Q127/Q83*100,@IF(Q164=0,0,(Q127*@CHOOSE(Q50,C53...C6:+A3+1 >A3:+A2+1 >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >E1:"RATES >D1:" AVERAGE >C1:"- MONTHLY >B1:"MODEL 14 >A1:1 /W1 /GOC /GRM /GC9 /X>A1:>A1: UCT >E9:" PRODUCT >D9:" PRODUCT >C9:" PRODUCT >B9:" DATE >A9:+A8+1 >G8:"--------- >F8:"--------- >E8:"LY RATE-- >D8:"------DAI >C8:"--------- >A8:+A7+1 >A7:+A6+1 >E6:"......... >D6:" FOR >A6:+A5+1 >A5:+A4+1 >F4:"TES >E4:"VERAGE RA >D4:"MONTHLY A >A4" ....... >B12:1 >A12:+A11+1 >G11:" ======= >F11:" ======= >E11:" ======= >D11:" ======= >C11:" ======= >B11:" ===== >A11:+A10+1 >G10:".......... >F10:".......... >E10:".......... >D10:"......... >C10:"......... >A10:+A9+1 >G9:" PRODUCT >F9:" PRODECURITY G >S161:-S124-S27 >R161:-R124-R27 >Q161:-Q124-Q27 >P161:-P124-P27 >O161:-O124-O27 >N161:-N124-N27 >M161:-M124-M27 >L161:-L124-L27 >K161:-K124-K27 >J161:-J124-J27 >I161:-I124-I27 >H161:-H124-H27 >G161:"R TAXES >F161:"/CREDIT FOR TAXES >E161:"-PROVISION >S159:+S150-S152+S154-S156 >R159:+R150-R152+R154-R156 >Q159:+Q150-Q152+Q154-Q156 >P159:+P150-P152+P154-P156 >O159:+O150-O152+O154-O156 >N159:+N150-N152+N154-N156 >M159:+M150-M152+M154-M156 >L159:+L150-L152+L154-L156 >K159:+K150-K152+K154-K156 >J159:+124+P127 >O129:+O124+O127 >N129:+N124+N127 >M129:+M124+M127 >L129:+L124+L127 >K129:+K124+K127 >J129:+J124+J127 >I129:+I124+I127 >H129:+H124+H127 >G129:"YTD >F129:"BENEFIT - >E129:"NET TAX/ -BENEFIT >S128:" --------- >R128:" --------- >Q128:" --------- >P1O43 >N132:+N43 >M132:+M43 >L132:+L43 >K132:+K43 >J132:+J43 >I132:+I43 >H132:+H43 >G132:"ED >F132:"SLY EXPENSED >E132:" PREVIOUSLY >G131:" PROVISION >F131:"F FED. TAX PROVISIO >E131:" AMOUNT OF >S129:+S124+S127 >R129:+R124+R127 >Q129:+Q124+Q127 >P129:+P------ >R133:" --------- >Q133:" --------- >P133:" --------- >O133:" --------- >N133:" --------- >M133:" --------- >L133:" --------- >K133:" --------- >J133:" --------- >I133:" --------- >H133:" --------- >S132:+S43 >R132:+R43 >Q132:+Q43 >P132:+P43 >O132:+O129-O132 >N135:+N129-N132 >M135:+M129-M132 >L135:+L129-L132 >K135:+K129-K132 >J135:+J129-J132 >I135:+I129-I132 >H135:+H129-H132 >G135:"ISION ---> >F135:"MONTH PROVISION >E135:"! CURRENT MON >G134:"---------- >F134:"---------- >E134:"---------- >S133:" ---" ========== >M136:" ========== >L136:" ========== >K136:" ========== >J136:" ========== >I136:" ========== >H136:" ========== >G136:"---------- >F136:"---------- >E136:"---------- >S135:+S129-S132 >R135:+R129-R132 >Q135:+Q129-Q132 >P135:+P129-P132 >O135:+143:" FEFBRUARY >H143:" JANUARY >G143:"TE ------> >F143:"YEAR TO DA >L141:"------ >K141:"---------- >L140:"TEMENT >K140:"INCOME STATE >E140:/FG >E139:/FG >S136:" ========== >R136:" ========== >Q136:" ========== >P136:" ========== >O136:" ========== >N136: >L144:" ========= >K144:" ========= >J144:" ========= >I144:" ========= >H144:" ========= >S143:" DECEMBER >R143:" NOVEMBER >Q143:" OCTOBER >P143:" SEPTEMBER >O143:" AUGUST >N143:" JULY >M143:" JUNE >L143:" MAY >K143:" APRIL >J143:" MARCH >I>Q146:+Q7 >P146:+P7 >O146:+O7 >N146:+N7 >M146:+M7 >L146:+L7 >K146:+K7 >J146:+J7 >I146:+I7 >H146:+H7 >F146:"NCOME >E146:"INTEREST I >S144:" ========= >R144:" ========= >Q144:" ========= >P144:" ========= >O144:" ========= >N144:" ========= >M144:" =========" --------- >K149:" --------- >J149:" --------- >I149:" --------- >H149:" --------- >S148:+S9 >R148:+R9 >Q148:+Q9 >P148:+P9 >O148:+O9 >N148:+N9 >M148:+M9 >L148:+L9 >K148:+K9 >J148:+J9 >I148:+I9 >H148:+H9 >F148:"XPENSE >E148:"INTEREST E >S146:+S7 >R146:+R7 8 >L150:+L146-L148 >K150:+K146-K148 >J150:+J146-J148 >I150:+I146-I148 >H150:+H146-H148 >F150:"ST INCOME >E150:"NET INTEREST >S149:" --------- >R149:" --------- >Q149:" --------- >P149:" --------- >O149:" --------- >N149:" --------- >M149:" --------- >L149:1 >O152:+O11 >N152:+N11 >M152:+M11 >L152:+L11 >K152:+K11 >J152:+J11 >I152:+I11 >H152:+H11 >G152:"OSSES >F152:"FOR LOAN L >E152:"PROVISION >S150:+S146-S148 >R150:+R146-R148 >Q150:+Q146-Q148 >P150:+P146-P148 >O150:+O146-O148 >N150:+N146-N148 >M150:+M146-M1415 >I156:+I15 >H156:+H15 >F156:"NSE >E156:"OTHER EXPE >S154:+S13 >R154:+R13 >Q154:+Q13 >P154:+P13 >O154:+O13 >N154:+N13 >M154:+M13 >L154:+L13 >K154:+K13 >J154:+J13 >I154:+I13 >H154:+H13 >F154:"ME >E154:"OTHER INCO >S152:+S11 >R152:+R11 >Q152:+Q11 >P152:+P157:" ---------- >N157:" ---------- >M157:" ---------- >L157:" ---------- >K157:" ---------- >J157:" ---------- >I157:" ---------- >H157:" ---------- >S156:+S15 >R156:+R15 >Q156:+Q15 >P156:+P15 >O156:+O15 >N156:+N15 >M156:+M15 >L156:+L15 >K156:+K15 >J156:+JJ150-J152+J154-J156 >I159:+I150-I152+I154-I156 >H159:+H150-H152+H154-H156 >G159:"-LOSSES >F159:" GAINS OR >E159:" SECURITY >G158:"XES AND >F158:" BEFORE TAX >E158:"NET INCOME >S157:" ---------- >R157:" ---------- >Q157:" ---------- >P157:" ---------- >O128:" --------- >O128:" --------- >N128:" --------- >M128:" --------- >L128:" --------- >K128:" --------- >J128:" --------- >I128:" --------- >H128:" --------- >S127:+S107 >R127:+R107 >Q127:+Q107 >P127:+P107 >O127:+O107 >N127:+N107 >M127:+M107 >L127:+L107 >K127:+K107 >J127:+J107 >I127:+I107 >H127:+H107 >F127:" (LOSSES) >E127:" GAINS OR >G126:"CURITY >F126:"IT FROM SE >E126:"TAX/-BENEFIT >S124:+S120+S122 >R124:+R120+R122 >Q124:+Q120+Q122 >P124:+P120+P122 >O124:+O120+O122 >N124:+N120+N122 >M124:+M120+M122 >L1===== >L100:" ========== >K100:" ========== >J100:" ========== >I100:" ========== >H100:" ========== >S99:@SUM(S92...S98) >R99:@SUM(R92...R98) >Q99:@SUM(Q92...Q98) >P99:@SUM(P92...P98) >O99:@SUM(O92...O98) >N99:@SUM(N92...N98) >M99:@SUM(M92...M98) >L99:@SUSE(I50,D53...D64)/100)) >H103:/FI@IF(H17>0,H77+(H99-H73),@INT(H99*@CHOOSE(H50,D53...D64)/100)) >F103:"ENEFIT) >E103:"YTD TAX (BE >S100:" ========== >R100:" ========== >Q100:" ========== >P100:" ========== >O100:" ========== >N100:" ========== >M100:" =====3:/FI@IF(L17>0,L77+(L99-L73),@INT(L99*@CHOOSE(L50,D53...D64)/100)) >K103:/FI@IF(K17>0,K77+(K99-K73),@INT(K99*@CHOOSE(K50,D53...D64)/100)) >J103:/FI@IF(J17>0,J77+(J99-J73),@INT(J99*@CHOOSE(J50,D53...D64)/100)) >I103:/FI@IF(I17>0,I77+(I99-I73),@INT(I99*@CHOO,@INT(P99*@CHOOSE(P50,D53...D64)/100)) >O103:/FI@IF(O17>0,O77+(O99-O73),@INT(O99*@CHOOSE(O50,D53...D64)/100)) >N103:/FI@IF(N17>0,N77+(N99-N73),@INT(N99*@CHOOSE(N50,D53...D64)/100)) >M103:/FI@IF(M17>0,M77+(M99-M73),@INT(M99*@CHOOSE(M50,D53...D64)/100)) >L10========== >S103:/FI@IF(S17>0,S77+(S99-S73),@INT(S99*@CHOOSE(S50,D53...D64)/100)) >R103:/FI@IF(R17>0,R77+(R99-R73),@INT(R99*@CHOOSE(R50,D53...D64)/100)) >Q103:/FI@IF(Q17>0,Q77+(Q99-Q73),@INT(Q99*@CHOOSE(Q50,D53...D64)/100)) >P103:/FI@IF(P17>0,P77+(P99-P73)T RELATED >E106:"TAX -BENEF >Q105:/FG >S104:" ========== >R104:" ========== >Q104:" ========== >P104:" ========== >O104:" ========== >N104:" ========== >M104:" ========== >L104:" ========== >K104:" ========== >J104:" ========== >I104:" ========== >H104:" 03-S77 >R107:+R103-R77 >Q107:+Q103-Q77 >P107:+P103-P77 >O107:+O103-O77 >N107:+N103-N77 >M107:+M103-M77 >L107:+L103-L77 >K107:+K103-K77 >J107:+J103-J77 >I107:+I103-I77 >H107:-H77+H103 >G107:"LOSS) >F107:" GAIN OR ( >E107:" SECURITY >G106:" TO THE >F106:"I>E110:"=========== >S108:" ========== >R108:" ========== >Q108:" ========== >P108:" ========== >O108:" ========== >N108:" ========== >M108:" ========== >L108:" ========== >K108:" ========== >J108:" ========== >I108:" ========== >H108:" ========== >S107:+S1======== >R110:"=========== >Q110:"=========== >P110:"=========== >O110:"=========== >N110:"=========== >M110:"=========== >L110:"=========== >K110:"=========== >J110:"=========== >I110:"=========== >H110:"=========== >G110:"=========== >F110:"=========== M115:" JUNE >L115:" MAY >K115:" APRIL >J115:" MARCH >I115:" FEBRUARY >H115:" JANUARY >G115:"TE ------> >F115:"YEAR TO DA >N113:/-- >M113:/-- >L113:/-- >K113:/-- >N112:" (BENEFIT) >M112:"AX EXPENSE >L112:"F INCOME T >K112:"ANALYSIS OF. >S110:"============ >O116:" ========= >N116:" ========= >M116:" ========= >L116:" ========= >K116:" ========= >J116:" ========= >I116:" ========= >H116:" ========= >S115:" DECEMBER >R115:" NOVEMBER >Q115:" OCTOBER >P115:" SEPTEMBER >O115:" AUGUST >N115:" JULY >77 >Q120:+Q77 >P120:+P77 >O120:+O77 >N120:+N77 >M120:+M77 >L120:+L77 >K120:+K77 >J120:+J77 >I120:+I77 >H120:+H77 >F120:"OPERATIONS >E120:" A. FROM >G118:": >F118:"/ -BENEFIT: >E118:"INCOME TAX >S116:" ========= >R116:" ========= >Q116:" ========= >P116:" 23:" ---------- >I123:" ---------- >H123:" ---------- >S122:-S21 >R122:-R21 >Q122:-Q21 >P122:-P21 >O122:-O21 >N122:-N21 >M122:-M21 >L122:-L21 >K122:-K21 >J122:-J21 >I122:-I21 >H122:-H21 >G122:"CREDITS >F122:"TMENT TAX >E122:" B. INVEST >S120:+S77 >R120:+R24:+L120+L122 >K124:+K120+K122 >J124:+J120+J122 >I124:+I120+I122 >H124:+H120+H122 >S123:" ---------- >R123:" ---------- >Q123:" ---------- >P123:" ---------- >O123:" ---------- >N123:" ---------- >M123:" ---------- >L123:" ---------- >K123:" ---------- >J1M(L92...L98) >K99:@SUM(K92...K98) >J99:@SUM(J92...J98) >I99:@SUM(I92...I98) >H99:@SUM(H92...H98) >S98:" ---------- >R98:" ---------- >Q98:" ---------- >P98:" ---------- >O98:" ---------- >N98:" ---------- >M98:" ---------- >L98:" ---------- >K98:" ---------- >J98:" ---------- >I98:" ---------- >H98:" ---------- >S97:/FI@INT(@IF(S86>F96,S86-F96*G97,0)) >R97:/FI@INT(@IF(R86>F96,R86-F96*G97,0)) >Q97:/FI@INT(@IF(Q86>F96,Q86-F96*G97,0)) >P97:/FI@INT(@IF(P86>F96,P86-F96*G97,0)) >O97:/FI@INT(@IF(O86>F96,O86-F96*G90,@IF(K86>F93,F93*G93,K86*G93))) >J93:/FI@INT(@IF(J86<0,0,@IF(J86>F93,F93*G93,J86*G93))) >I93:/FI@INT(@IF(I86<0,0,@IF(I86>F93,F93*G93,I86*G93))) >H93:/FI@INT(@IF(H86<0,0,@IF(H86>F93,F93*G93,H86*G93))) >G93:/FG.16 >F93:25000 >S92:/FG@INT(@IF(S86<0,-S86*G92,6*G93))) >O93:/FI@INT(@IF(O86<0,0,@IF(O86>F93,F93*G93,O86*G93))) >N93:/FI@INT(@IF(N86<0,0,@IF(N86>F93,F93*G93,N86*G93))) >M93:/FI@INT(@IF(M86<0,0,@IF(M86>F93,F93*G93,M86*G93))) >L93:/FI@INT(@IF(L86<0,0,@IF(L86>F93,F93*G93,L86*G93))) >K93:/FI@INT(@IF(K86<0,,0,H86-F93)*G94)) >G94:/FG.19 >F94:50000 >S93:/FI@INT(@IF(S86<0,0,@IF(S86>F93,F93*G93,S86*G93))) >R93:/FI@INT(@IF(R86<0,0,@IF(R86>F93,F93*G93,R86*G93))) >Q93:/FI@INT(@IF(Q86<0,0,@IF(Q86>F93,F93*G93,Q86*G93))) >P93:/FI@INT(@IF(P86<0,0,@IF(P86>F93,F93*G93,P894:/FI@INT(@IF(K86>F94,(F94-F93)*G94,@IF(K86<=F93,0,K86-F93)*G94)) >J94:/FI@INT(@IF(J86>F94,(F94-F93)*G94,@IF(J86<=F93,0,J86-F93)*G94)) >I94:/FI@INT(@IF(I86>F94,(F94-F93)*G94,@IF(I86<=F93,0,I86-F93)*G94)) >H94:/FI@INT(@IF(H86>F94,(F94-F93)*G94,@IF(H86<=F9394,(F94-F93)*G94,@IF(O86<=F93,0,O86-F93)*G94)) >N94:/FI@INT(@IF(N86>F94,(F94-F93)*G94,@IF(N86<=F93,0,N86-F93)*G94)) >M94:/FI@INT(@IF(M86>F94,(F94-F93)*G94,@IF(M86<=F93,0,M86-F93)*G94)) >L94:/FI@INT(@IF(L86>F94,(F94-F93)*G94,@IF(L86<=F93,0,L86-F93)*G94)) >K(S86<=F93,0,S86-F93)*G94)) >R94:/FI@INT(@IF(R86>F94,(F94-F93)*G94,@IF(R86<=F93,0,R86-F93)*G94)) >Q94:/FI@INT(@IF(Q86>F94,(F94-F93)*G94,@IF(Q86<=F93,0,Q86-F93)*G94)) >P94:/FI@INT(@IF(P86>F94,(F94-F93)*G94,@IF(P86<=F93,0,P86-F93)*G94)) >O94:/FI@INT(@IF(O86>FF(J86>F95,(F95-F94)*G95,@IF(J86<=F94,0,J86-F94)*G95)) >I95:/FI@INT(@IF(I86>F95,(F95-F94)*G95,@IF(I86<=F94,0,I86-F94)*G95)) >H95:/FI@INT(@IF(H86>F95,(F95-F94)*G95,@IF(H86<=F94,0,H86-F94)*G95)) >G95:/FG.3 >F95:75000 >S94:/FI@INT(@IF(S86>F94,(F94-F93)*G94,@IFG95,@IF(N86<=F94,0,N86-F94)*G95)) >M95:/FI@INT(@IF(M86>F95,(F95-F94)*G95,@IF(M86<=F94,0,M86-F94)*G95)) >L95:/FI@INT(@IF(L86>F95,(F95-F94)*G95,@IF(L86<=F94,0,L86-F94)*G95)) >K95:/FI@INT(@IF(K86>F95,(F95-F94)*G95,@IF(K86<=F94,0,K86-F94)*G95)) >J95:/FI@INT(@I86-F94)*G95)) >Q95:/FI@INT(@IF(Q86>F95,(F95-F94)*G95,@IF(Q86<=F94,0,Q86-F94)*G95)) >P95:/FI@INT(@IF(P86>F95,(F95-F94)*G95,@IF(P86<=F94,0,P86-F94)*G95)) >O95:/FI@INT(@IF(O86>F95,(F95-F94)*G95,@IF(O86<=F94,0,O86-F94)*G95)) >N95:/FI@INT(@IF(N86>F95,(F95-F94)*-F95)*G96,@IF(I86<=F95,0,I86-F95)*G96)) >H96:/FI@INT(@IF(H86>F96,(F96-F95)*G96,@IF(H86<=F95,0,H86-F95)*G96)) >G96:/FG.4 >F96:100000 >S95:/FI@INT(@IF(S86>F95,(F95-F94)*G95,@IF(S86<=F94,0,S86-F94)*G95)) >R95:/FI@INT(@IF(R86>F95,(F95-F94)*G95,@IF(R86<=F94,0,R95,0,M86-F95)*G96)) >L96:/FI@INT(@IF(L86>F96,(F96-F95)*G96,@IF(L86<=F95,0,L86-F95)*G96)) >K96:/FI@INT(@IF(K86>F96,(F96-F95)*G96,@IF(K86<=F95,0,K86-F95)*G96)) >J96:/FI@INT(@IF(J86>F96,(F96-F95)*G96,@IF(J86<=F95,0,J86-F95)*G96)) >I96:/FI@INT(@IF(I86>F96,(F96>P96:/FI@INT(@IF(P86>F96,(F96-F95)*G96,@IF(P86<=F95,0,P86-F95)*G96)) >O96:/FI@INT(@IF(O86>F96,(F96-F95)*G96,@IF(O86<=F95,0,O86-F95)*G96)) >N96:/FI@INT(@IF(N86>F96,(F96-F95)*G96,@IF(N86<=F95,0,N86-F95)*G96)) >M96:/FI@INT(@IF(M86>F96,(F96-F95)*G96,@IF(M86<=F:/FI@INT(@IF(H86>F96,H86-F96*G97,0)) >G97:/FG.46 >S96:/FI@INT(@IF(S86>F96,(F96-F95)*G96,@IF(S86<=F95,0,S86-F95)*G96)) >R96:/FI@INT(@IF(R86>F96,(F96-F95)*G96,@IF(R86<=F95,0,R86-F95)*G96)) >Q96:/FI@INT(@IF(Q86>F96,(F96-F95)*G96,@IF(Q86<=F95,0,Q86-F95)*G96)) 7,0)) >N97:/FI@INT(@IF(N86>F96,N86-F96*G97,0)) >M97:/FI@INT(@IF(M86>F96,M86-F96*G97,0)) >L97:/FI@INT(@IF(L86>F96,L86-F96*G97,0)) >K97:/FI@INT(@IF(K86>F96,K86-F96*G97,0)) >J97:/FI@INT(@IF(J86>F96,J86-F96*G97,0)) >I97:/FI@INT(@IF(I86>F96,I86-F96*G97,0)) >H970)) >R92:/FG@INT(@IF(R86<0,-R86*G92,0)) >Q92:/FG@INT(@IF(Q86<0,-Q86*G92,0)) >P92:/FG@INT(@IF(P86<0,-P86*G92,0)) >O92:/FG@INT(@IF(O86<0,-O86*G92,0)) >N92:/FG@INT(@IF(N86<0,-N86*G92,0)) >M92:/FG@INT(@IF(M86<0,-M86*G92,0)) >L92:/FG@INT(@IF(L86<0,-L86*G92,0)) >K92:/FG@INT(@IF(K86<0,-K86*G92,0)) >J92:/FG@INT(@IF(J86<0,-J86*G92,0)) >I92:/FG@INT(@IF(I86<0,-I86*G92,0)) >H92:/FG@INT(@IF(H86<0,-H86*G92,0)) >G92:/FG-.46 >F92:/FR" (NOL) >H91:/FG >G90:" ========= >G89:" TAX RATE >S87:" ---------- >R87:" ---------- >Q87:9,0,N59-F69)*G70)) >M70:/FI@INT(@IF(M59>F70,(F70-F69)*G70,@IF(M59<=F69,0,M59-F69)*G70)) >L70:/FI@INT(@IF(L59>F70,(F70-F69)*G70,@IF(L59<=F69,0,L59-F69)*G70)) >K70:/FI@INT(@IF(K59>F70,(F70-F69)*G70,@IF(K59<=F69,0,K59-F69)*G70)) >J70:/FI@INT(@IF(J59>F70,(F70-Q70:/FI@INT(@IF(Q59>F70,(F70-F69)*G70,@IF(Q59<=F69,0,Q59-F69)*G70)) >P70:/FI@INT(@IF(P59>F70,(F70-F69)*G70,@IF(P59<=F69,0,P59-F69)*G70)) >O70:/FI@INT(@IF(O59>F70,(F70-F69)*G70,@IF(O59<=F69,0,O59-F69)*G70)) >N70:/FI@INT(@IF(N59>F70,(F70-F69)*G70,@IF(N59<=F659>F70,J59-F70*G71,0)) >I71:/FI@INT(@IF(I59>F70,I59-F70*G71,0)) >H71:/FI@INT(@IF(H59>F70,H59-F70*G71,0)) >G71:/FG.46 >S70:/FI@INT(@IF(S59>F70,(F70-F69)*G70,@IF(S59<=F69,0,S59-F69)*G70)) >R70:/FI@INT(@IF(R59>F70,(F70-F69)*G70,@IF(R59<=F69,0,R59-F69)*G70)) >@INT(@IF(P59>F70,P59-F70*G71,0)) >O71:/FI@INT(@IF(O59>F70,O59-F70*G71,0)) >N71:/FI@INT(@IF(N59>F70,N59-F70*G71,0)) >M71:/FI@INT(@IF(M59>F70,M59-F70*G71,0)) >L71:/FI@INT(@IF(L59>F70,L59-F70*G71,0)) >K71:/FI@INT(@IF(K59>F70,K59-F70*G71,0)) >J71:/FI@INT(@IF(J >M72:" ---------- >L72:" ---------- >K72:" ---------- >J72:" ---------- >I72:" ---------- >H72:" ---------- >E72:"ANNUALIED >S71:/FI@INT(@IF(S59>F70,S59-F70*G71,0)) >R71:/FI@INT(@IF(R59>F70,R59-F70*G71,0)) >Q71:/FI@INT(@IF(Q59>F70,Q59-F70*G71,0)) >P71:/FIL72) >K73:@SUM(K66...K72) >J73:@SUM(J66...J72) >I73:@SUM(I66...I72) >H73:@SUM(H66...H72) >G73:"PERATIONS >F73:"EFIT) ON OPERAT >E73:" TAX (BENIFIT) >S72:" ---------- >R72:" ---------- >Q72:" ---------- >P72:" ---------- >O72:" ---------- >N72:" ----------== >L74:" ========== >K74:" ========== >J74:" ========== >I74:" ========== >H74:" ========== >S73:@SUM(S66...S72) >R73:@SUM(R66...R72) >Q73:@SUM(Q66...Q72) >P73:@SUM(P66...P72) >O73:@SUM(O66...O72) >N73:@SUM(N66...N72) >M73:@SUM(M66...M72) >L73:@SUM(L66...I77:/FI@INT(I73*@CHOOSE(I50,D53...D64)/100) >H77:/FI@INT(H73*@CHOOSE(H50,D53...D64)/100) >F77:"ENEFIT) >E77:"YTD TAX (BENIF >Q76:/FG >S74:" ========== >R74:" ========== >Q74:" ========== >P74:" ========== >O74:" ========== >N74:" ========== >M74:" ========3*@CHOOSE(O50,D53...D64)/100) >N77:/FI@INT(N73*@CHOOSE(N50,D53...D64)/100) >M77:/FI@INT(M73*@CHOOSE(M50,D53...D64)/100) >L77:/FI@INT(L73*@CHOOSE(L50,D53...D64)/100) >K77:/FI@INT(K73*@CHOOSE(K50,D53...D64)/100) >J77:/FI@INT(J73*@CHOOSE(J50,D53...D64)/100) >====== >J78:" ========== >I78:" ========== >H78:" ========== >S77:/FI@INT(S73*@CHOOSE(S50,D53...D64)/100) >R77:/FI@INT(R73*@CHOOSE(R50,D53...D64)/100) >Q77:/FI@INT(Q73*@CHOOSE(Q50,D53...D64)/100) >P77:/FI@INT(P73*@CHOOSE(P50,D53...D64)/100) >O77:/FI@INT(O7J81:"---------- >I81:"---------- >H81:"---------- >G81:"---------- >F81:"---------- >E81:"---------- >S78:" ========== >R78:" ========== >Q78:" ========== >P78:" ========== >O78:" ========== >N78:" ========== >M78:" ========== >L78:" ========== >K78:" ====M17 >L83:+L17 >K83:+K17 >J83:+J17 >I83:+I17 >H83:+H17 >G83:"OSSES >F83:"AINS OR -L >E83:"SECURITY GAI >S81:"---------- >R81:"---------- >Q81:"---------- >P81:"---------- >O81:"---------- >N81:"---------- >M81:"---------- >L81:"---------- >K81:"---------- >83 >M86:+M59+M83 >L86:+L59+L83 >K86:+K59+K83 >J86:+J59+J83 >I86:+I59+I83 >H86:+H59+H83 >G86:"NS/-LOSS >F86:"CURITY GAIN >E86:" AFTER SECURITY >G85:"NCOME >F85:" TAXIBLE I >E85:"ANNUALIZED >S83:+S17 >R83:+R17 >Q83:+Q17 >P83:+P17 >O83:+O17 >N83:+N17 >M83:+" ---------- >P87:" ---------- >O87:" ---------- >N87:" ---------- >M87:" ---------- >L87:" ---------- >K87:" ---------- >J87:" ---------- >I87:" ---------- >H87:" ---------- >S86:+S59+S83 >R86:+R59+R83 >Q86:+Q59+Q83 >P86:+P59+P83 >O86:+O59+O83 >N86:+N59+NF69)*G70,@IF(J59<=F69,0,J59-F69)*G70)) >I70:/FI@INT(@IF(I59>F70,(F70-F69)*G70,@IF(I59<=F69,0,I59-F69)*G70)) >H70:/FI@INT(@IF(H59>F70,(F70-F69)*G70,@IF(H59<=F69,0,H59-F69)*G70)) >G70:/FG.4 >F70:100000 >S69:/FI@INT(@IF(S59>F69,(F69-F68)*G69,@IF(S59<=F68,0,S59-F68)*G69)) >R69:/FI@INT(@IF(R59>F69,(F69-F68)*G69,@IF(R59<=F68,0,R59-F68)*G69)) >Q69:/FI@INT(@IF(Q59>F69,(F69-F68)*G69,@IF(Q59<=F68,0,Q59-F68)*G69)) >P69:/FI@INT(@IF(P59>F69,(F69-F68)*G69,@IF(P59<=F68,0,P59-F68)*G69)) >O69:/FI@INT(@IF(O59>F69,(F69-F68)*G) >K59:@INT(+K55*@CHOOSE(K50,C53...C64)) >J59:@INT(+J55*@CHOOSE(J50,C53...C64)) >I59:@INT(+I55*@CHOOSE(I50,C53...C64)) >H59:@INT(+H55*@CHOOSE(H50,C53...C64)) >G59:"INS/-LOSS >F59:"ECURITY GAIN >E59:" BEFORE SECURITY >D59:/FG58.33 >C59:/FG1.71 >B59:" JULY @CHOOSE(R50,C53...C64)) >Q59:@INT(+Q55*@CHOOSE(Q50,C53...C64)) >P59:@INT(+P55*@CHOOSE(P50,C53...C64)) >O59:@INT(+O55*@CHOOSE(O50,C53...C64)) >N59:@INT(+N55*@CHOOSE(N50,C53...C64)) >M59:@INT(+M55*@CHOOSE(M50,C53...C64)) >L59:@INT(+L55*@CHOOSE(L50,C53...C64)-------- >P60:" --------- >O60:" --------- >N60:" --------- >M60:" --------- >L60:" --------- >K60:" --------- >J60:" --------- >I60:" --------- >H60:" --------- >D60:/FG66.67 >C60:/FG1.5 >B60:" AUGUST >S59:@INT(+S55*@CHOOSE(S50,C53...C64)) >R59:@INT(+R55*L) >D65:/FG >G64:" ========= >D64:/FG100 >C64:1 >B64:" DECEMBER >G63:" TAX RATE >D63:/FG91.67 >C63:/FG1.09 >B63:" NOVEMBER >E62:/FG >D62:/FG83.33 >C62:/FG1.2 >B62:" OCTOBER >D61:/FG75 >C61:/FG1.33 >B61:" SEPTEMBER >S60:" --------- >R60:" --------- >Q60:" -,-N59*G66,0)) >M66:/FG@INT(@IF(M59<0,-M59*G66,0)) >L66:/FG@INT(@IF(L59<0,-L59*G66,0)) >K66:/FG@INT(@IF(K59<0,-K59*G66,0)) >J66:/FG@INT(@IF(J59<0,-J59*G66,0)) >I66:/FG@INT(@IF(I59<0,-I59*G66,0)) >H66:/FG@INT(@IF(H59<0,-H59*G66,0)) >G66:/FG-.46 >F66:/FR" (NO67,F67*G67,H59*G67))) >G67:/FG.16 >F67:25000 >E67:/FG >S66:/FG@INT(@IF(S59<0,-S59*G66,0)) >R66:/FG@INT(@IF(R59<0,-R59*G66,0)) >Q66:/FG@INT(@IF(Q59<0,-Q59*G66,0)) >P66:/FG@INT(@IF(P59<0,-P59*G66,0)) >O66:/FG@INT(@IF(O59<0,-O59*G66,0)) >N66:/FG@INT(@IF(N59<067:/FI@INT(@IF(L59<0,0,@IF(L59>F67,F67*G67,L59*G67))) >K67:/FI@INT(@IF(K59<0,0,@IF(K59>F67,F67*G67,K59*G67))) >J67:/FI@INT(@IF(J59<0,0,@IF(J59>F67,F67*G67,J59*G67))) >I67:/FI@INT(@IF(I59<0,0,@IF(I59>F67,F67*G67,I59*G67))) >H67:/FI@INT(@IF(H59<0,0,@IF(H59>FIF(Q59>F67,F67*G67,Q59*G67))) >P67:/FI@INT(@IF(P59<0,0,@IF(P59>F67,F67*G67,P59*G67))) >O67:/FI@INT(@IF(O59<0,0,@IF(O59>F67,F67*G67,O59*G67))) >N67:/FI@INT(@IF(N59<0,0,@IF(N59>F67,F67*G67,N59*G67))) >M67:/FI@INT(@IF(M59<0,0,@IF(M59>F67,F67*G67,M59*G67))) >L0,I59-F67)*G68)) >H68:/FI@INT(@IF(H59>F68,(F68-F67)*G68,@IF(H59<=F67,0,H59-F67)*G68)) >G68:/FG.19 >F68:50000 >E68:/FG >S67:/FI@INT(@IF(S59<0,0,@IF(S59>F67,F67*G67,S59*G67))) >R67:/FI@INT(@IF(R59<0,0,@IF(R59>F67,F67*G67,R59*G67))) >Q67:/FI@INT(@IF(Q59<0,0,@8:/FI@INT(@IF(L59>F68,(F68-F67)*G68,@IF(L59<=F67,0,L59-F67)*G68)) >K68:/FI@INT(@IF(K59>F68,(F68-F67)*G68,@IF(K59<=F67,0,K59-F67)*G68)) >J68:/FI@INT(@IF(J59>F68,(F68-F67)*G68,@IF(J59<=F67,0,J59-F67)*G68)) >I68:/FI@INT(@IF(I59>F68,(F68-F67)*G68,@IF(I59<=F67,8,(F68-F67)*G68,@IF(P59<=F67,0,P59-F67)*G68)) >O68:/FI@INT(@IF(O59>F68,(F68-F67)*G68,@IF(O59<=F67,0,O59-F67)*G68)) >N68:/FI@INT(@IF(N59>F68,(F68-F67)*G68,@IF(N59<=F67,0,N59-F67)*G68)) >M68:/FI@INT(@IF(M59>F68,(F68-F67)*G68,@IF(M59<=F67,0,M59-F67)*G68)) >L69)) >G69:/FG.3 >F69:75000 >S68:/FI@INT(@IF(S59>F68,(F68-F67)*G68,@IF(S59<=F67,0,S59-F67)*G68)) >R68:/FI@INT(@IF(R59>F68,(F68-F67)*G68,@IF(R59<=F67,0,R59-F67)*G68)) >Q68:/FI@INT(@IF(Q59>F68,(F68-F67)*G68,@IF(Q59<=F67,0,Q59-F67)*G68)) >P68:/FI@INT(@IF(P59>F6(K59>F69,(F69-F68)*G69,@IF(K59<=F68,0,K59-F68)*G69)) >J69:/FI@INT(@IF(J59>F69,(F69-F68)*G69,@IF(J59<=F68,0,J59-F68)*G69)) >I69:/FI@INT(@IF(I59>F69,(F69-F68)*G69,@IF(I59<=F68,0,I59-F68)*G69)) >H69:/FI@INT(@IF(H59>F69,(F69-F68)*G69,@IF(H59<=F68,0,H59-F68)*G669,@IF(O59<=F68,0,O59-F68)*G69)) >N69:/FI@INT(@IF(N59>F69,(F69-F68)*G69,@IF(N59<=F68,0,N59-F68)*G69)) >M69:/FI@INT(@IF(M59>F69,(F69-F68)*G69,@IF(M59<=F68,0,M59-F68)*G69)) >L69:/FI@INT(@IF(L59>F69,(F69-F68)*G69,@IF(L59<=F68,0,L59-F68)*G69)) >K69:/FI@INT(@IF>G58:"NCOME >F58:" TAXIBLE I >E58:"ANNUALIZED >D58:/FG50 >C58:/FG2 >B58:" JUNE >D57:/FG41.67 >C57:/FG2.4 >B57:" MAY >S56:" ---------- >R56:" ---------- >Q56:" ---------- >P56:" ---------- >O56:" ---------- >N56:" ---------- >M56:" ---------- >L56:" ---------- >K56:" ---------- >J56:" ---------- >I56:" ---------- >H56:" ---------- >D56:/FG33 >C56:3 >B56:" APRIL >S55:+S52-S19+S25-S27+S31+S32-S35-S36 >R55:+R52-R19+R25-R27+R31+R32-R35-R36 >Q55:+Q52-Q19+Q25-Q27+Q31+Q32-Q35-Q36 >P55:+P52-P19+P25-P27+P31+P32-P35-UCT >S32:" ........ >R32:" ........ >Q32:" ........ >P32:" ........ >O32:" ........ >N32:" ........ >M32:" ........ >L32:" ........ >K32:" ........ >J32:" ........ >I32:" ........ >H32:" ........ >E32:" B. >S31:" ........ >R31:" ........ >Q35:" ......... >O35:" ......... >N35:" ......... >M35:" ......... >L35:" ......... >K35:" ......... >J35:" ......... >I35:" ......... >H35:" ......... >G35:"PROFIT >F35:"TY IN SCA >E35:" A. EQUITY >G34:"BLE INCOME >F34:" FROM TAXA >E34:" 2. DED >R36:" ........ >Q36:" ........ >P36:" ........ >O36:" ........ >N36:" ........ >M36:" ........ >L36:" ........ >K36:" ........ >J36:" ........ >I36:" ........ >H36:" ........ >E36:" B. >S35:" ......... >R35:" ......... >Q35:" ......... >P:" JUNE >M40:" MAY >L40:" APRIL >K40:" MARCH >J40:" FEBRUARY >I40:" JANUARY >S39:" YTD >R39:" YTD >Q39:" YTD >P39:" YTD >O39:" YTD >N39:" YTD >M39:" YTD >L39:" YTD >K39:" YTD >J39:" YTD >I39:" YTD >S36:" ........== >R41:" ========= >Q41:" ========= >P41:" ========= >O41:" ========= >N41:" ========= >M41:" ========= >L41:" ========= >K41:" ========= >J41:" ========= >I41:" ========= >S40:" NOVEMBER >R40:" OCTOBER >Q40:" SEPTEMBER >P40:" AUGUST >O40:" JULY >N40. >P43:" ........ >O43:" ........ >N43:" ........ >M43:" ........ >L43:" ........ >K43:" ........ >J43:" ........ >I43:" ........ >G43:"Y EXPENSED >F43:" PREVIOUSLY >E43:" PROVISION >G42:"NCOME TAX >F42:"YTD FED. INC >E42:"AMOUNT OF >S41:" =============== >O45:"=========== >N45:"=========== >M45:"=========== >L45:"=========== >K45:"=========== >J45:"=========== >I45:"=========== >H45:"=========== >G45:"=========== >F45:"=========== >E45:"=========== >S43:" ........ >R43:" ........ >Q43:" .......UALIZA >S48:" DECEMBER >R48:" NOVEMBER >Q48:" OCTOBER >P48:" SEPTEMBER >O48:" AUGUST >N48:" JULY >M48:" JUNE >L48:" MAY >K48:" APRIL >J48:" MARCH >I48:" FEFBRUARY >H48:" JANUARY >S45:"=========== >R45:"=========== >Q45:"=========== >P45:"===D50:" REDUCTION >C50:" -TION >S49:" ========== >R49:" ========== >Q49:" ========== >P49:" ========== >O49:" ========== >N49:" ========== >M49:" ========== >L49:" ========== >K49:" ========== >J49:" ========== >I49:" ========== >H49:" ========== >C49:" ANN2:"XES & SEC. >F52:" BEFORE TAX >E52:"NET INCOME >D52:" ========= >C52:" ========= >D51:" FRACTION >C51:" FRACTION >S50:+R50+1 >R50:+Q50+1 >Q50:+P50+1 >P50:+O50+1 >O50:+N50+1 >N50:+M50+1 >M50:+L50+1 >L50:+K50+1 >K50:+J50+1 >J50:+I50+1 >I50:+H50+1 >H50:1 >-R11+R13-R15 >Q52:+Q7-Q9-Q11+Q13-Q15 >P52:+P7-P9-P11+P13-P15 >O52:+O7-O9-O11+O13-O15 >N52:+N7-N9-N11+N13-N15 >M52:+M7-M9-M11+M13-M15 >L52:+L7-L9-L11+L13-L15 >K52:+K7-K9-K11+K13-K15 >J52:+J7-J9-J11+J13-J15 >I52:+I7-I9-I11+I13-I15 >H52:+H7-H9-H11+H13-H15 >G5---- >Q53:" ---------- >P53:" ---------- >O53:" ---------- >N53:" ---------- >M53:" ---------- >L53:" ---------- >K53:" ---------- >J53:" ---------- >I53:" ---------- >H53:" ---------- >D53:/FG8.33 >C53:12 >B53:" JANUARY >S52:+S7-S9-S11+S13-S15 >R52:+R7-R91+I32-I35-I36 >H55:+H52-H19+H25-H27+H31+H32-H35-H36 >G55:"---------> >F55:" -LOSSES >E55:" GAINS OR >D55:/FG25 >C55:4 >B55:" MARCH >G54:"E SECURITY >F54:"COME BEFORE >E54:"TAXIBLE INCOME >D54:/FG16.67 >C54:6 >B54:" FEBRUARY >S53:" ---------- >R53:" ------P36 >O55:+O52-O19+O25-O27+O31+O32-O35-O36 >N55:+N52-N19+N25-N27+N31+N32-N35-N36 >M55:+M52-M19+M25-M27+M31+M32-M35-M36 >L55:+L52-L19+L25-L27+L31+L32-L35-L36 >K55:+K52-K19+K25-K27+K31+K32-K35-K36 >J55:+J52-J19+J25-J27+J31+J32-J35-J36 >I55:+I52-I19+I25-I27+I331:" ........ >P31:" ........ >O31:" ........ >N31:" ........ >M31:" ........ >L31:" ........ >K31:" ........ >J31:" ........ >I31:" ........ >H31:" ........ >E31:" A. >G30:"NCOME >F30:" TAXABLE INCO >E30:" 1. ADD TO TAX >G29:"ERENCES >F29:"ANENT DIFF >E29:"OTHER PERM >S27:" ........ >R27:" ........ >Q27:" ........ >P27:" ........ >O27:" ........ >N27:" ........ >M27:" ........ >L27:" ........ >K27:" ........ >J27:" ........ >I27:" ........ >H27:" ........ >F27:"EXPENSE >E27:"STATE >I71:/-- >H71:/-- >G71:/-- >F71:/-- >E71:/-- >D71:/-- >C71:/-- >B71:/-- >A71:+A70+1 >H70:/F$ >G70:/F$@SUM(G8...G69 >F70:/F$@SUM(F8...F69 >E70:/F$@SUM(E8...E69 >A70:+A69+1 >I69:/-- >H69:/-- >G69:/-- >F69:/-- >E69:/-- >D69:/-- >C69:/-- >B69:/-- >A69:+A68+1 > 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 >D1:"X >C1:" INCOME TA >B1:"MODEL 15 /W1 /GOC /GRM /GFI /GC10 /X>A1:>A1: >K4:" APRIL >J4:" MARCH >I4:" FEBRUARY >H4:" JANUARY >S3:" YTD >R3:" YTD >Q3:" YTD >P3:" YTD >O3:" YTD >N3:" YTD >M3:" YTD >L3:" YTD >K3:" YTD >J3:" YTD >I3:" YTD >H3:" YTD >S2:" S >R2:" R >Q2:" Q >P2:" ==== >O5:" ========== >N5:" ========== >M5:" ========== >L5:" ========== >K5:" ========== >J5:" ========== >I5:" ========== >H5:" ========== >S4:" DECEMBER >R4:" NOVEMBER >Q4:" OCTOBER >P4:" SEPTEMBER >O4:" AUGUST >N4:" JULY >M4:" JUNE >L4:" MAY ..... >Q7:" ........ >P7:" ........ >O7:" ........ >N7:" ........ >M7:" ........ >L7:" ........ >K7:" ........ >J7:" ........ >I7:" ........ >H7:" ........ >F7:"NCOME >E7:"INTEREST I >S5:" ========== >R5:" ========== >Q5:" ========== >P5:" ======9:" ......... >R9:" ......... >Q9:" ......... >P9:" ......... >O9:" ......... >N9:" ......... >M9:" ......... >L9:" ......... >K9:" ......... >J9:" ......... >I9:" ......... >H9:" ......... >F9:"XPENSE >E9:"INTEREST E >S7:" ........ >R7:" ...>E13:"OTHER INCO >S11:" ........ >R11:" ........ >Q11:" ........ >P11:" ........ >O11:" ........ >N11:" ........ >M11:" ........ >L11:" ........ >K11:" ........ >J11:" ........ >I11:" ........ >H11:" ........ >F11:"PROVISION >E11:"LOAN LOSS >SH15:" ........ >F15:"NSE >E15:"OTHER EXPE >S13:" ........ >R13:" ........ >Q13:" ........ >P13:" ........ >O13:" ........ >N13:" ........ >M13:" ........ >L13:" ........ >K13:" ........ >J13:" ........ >I13:" ........ >H13:" ........ >F13:"ME ..... >H17:" ........ >G17:"ES >F17:"AINS -LOSSES >E17:"SECURITY G >S15:" ........ >R15:" ........ >Q15:" ........ >P15:" ........ >O15:" ........ >N15:" ........ >M15:" ........ >L15:" ........ >K15:" ........ >J15:" ........ >I15:" ........ > ........ >I19:" ........ >H19:" ........ >F19:" INCOME >E19:"TAX EXEMPT >S17:" ........ >R17:" ........ >Q17:" ........ >P17:" ........ >O17:" ........ >N17:" ........ >M17:" ........ >L17:" ........ >K17:" ........ >J17:" ........ >I17:" ...>J21:" ........ >I21:" ........ >H21:" ........ >G21:"TS >F21:" TAX CREDI'S >E21:"INVESTMENT >S19:" ........ >R19:" ........ >Q19:" ........ >P19:" ........ >O19:" ........ >N19:" ........ >M19:" ........ >L19:" ........ >K19:" ........ >J19:" ICIPAL >G24:"TE & >F24:"ONS OF STA >E24:" OBLIGATION >G23:"T ON >F23:"OF DISCOUNT >E23:"ACCRETION >S21:" ........ >R21:" ........ >Q21:" ........ >P21:" ........ >O21:" ........ >N21:" ........ >M21:" ........ >L21:" ........ >K21:" ........ TAX >S25:" ........ >R25:" ........ >Q25:" ........ >P25:" ........ >O25:" ........ >N25:" ........ >M25:" ........ >L25:" ........ >K25:" ........ >J25:" ........ >I25:" ........ >H25:" ........ >G25:"IONS ----> >F25:"L SUBDIVISIO >E25:" MUNH68:/F$+H67-G68 >G68:/F$+F68-E68 >F68:/F$@IF(@OR(B68=G5,B68=0),E68+H67,F5) >E68:/F$.01*@INT(100*(.005+((E5/1200)*H67))) >D68:@IF(B68=0,0,@IF(C67=12,D67+1,D67) >C68:@IF(B68=0,0,@IF(C67=12,1,C67+1) >B68:@IF(@OR(B67=G5,B67=0),0,1+B67) >A68:+A67+1 >H67:/F$+H664=12,D54+1,D54) >C55:@IF(B55=0,0,@IF(C54=12,1,C54+1) >B55:@IF(@OR(B54=G5,B54=0),0,1+B54) >A55:+A54+1 >H54:/F$+H53-G54 >G54:/F$+F54-E54 >F54:/F$@IF(@OR(B54=G5,B54=0),E54+H53,F5) >E54:/F$.01*@INT(100*(.005+((E5/1200)*H53))) >D54:@IF(B54=0,0,@IF(C53=12,D53+1,=0,0,@IF(C55=12,D55+1,D55) >C56:@IF(B56=0,0,@IF(C55=12,1,C55+1) >B56:@IF(@OR(B55=G5,B55=0),0,1+B55) >A56:+A55+1 >H55:/F$+H54-G55 >G55:/F$+F55-E55 >F55:/F$@IF(@OR(B55=G5,B55=0),E55+H54,F5) >E55:/F$.01*@INT(100*(.005+((E5/1200)*H54))) >D55:@IF(B55=0,0,@IF(C5D57:@IF(B57=0,0,@IF(C56=12,D56+1,D56) >C57:@IF(B57=0,0,@IF(C56=12,1,C56+1) >B57:@IF(@OR(B56=G5,B56=0),0,1+B56) >A57:+A56+1 >H56:/F$+H55-G56 >G56:/F$+F56-E56 >F56:/F$@IF(@OR(B56=G5,B56=0),E56+H55,F5) >E56:/F$.01*@INT(100*(.005+((E5/1200)*H55))) >D56:@IF(B560)*H57))) >D58:@IF(B58=0,0,@IF(C57=12,D57+1,D57) >C58:@IF(B58=0,0,@IF(C57=12,1,C57+1) >B58:@IF(@OR(B57=G5,B57=0),0,1+B57) >A58:+A57+1 >H57:/F$+H56-G57 >G57:/F$+F57-E57 >F57:/F$@IF(@OR(B57=G5,B57=0),E57+H56,F5) >E57:/F$.01*@INT(100*(.005+((E5/1200)*H56))) >05+((E5/1200)*H58))) >D59:@IF(B59=0,0,@IF(C58=12,D58+1,D58) >C59:@IF(B59=0,0,@IF(C58=12,1,C58+1) >B59:@IF(@OR(B58=G5,B58=0),0,1+B58) >A59:+A58+1 >H58:/F$+H57-G58 >G58:/F$+F58-E58 >F58:/F$@IF(@OR(B58=G5,B58=0),E58+H57,F5) >E58:/F$.01*@INT(100*(.005+((E5/120INT(100*(.005+((E5/1200)*H59))) >D60:@IF(B60=0,0,@IF(C59=12,D59+1,D59) >C60:@IF(B60=0,0,@IF(C59=12,1,C59+1) >B60:@IF(@OR(B59=G5,B59=0),0,1+B59) >A60:+A59+1 >H59:/F$+H58-G59 >G59:/F$+F59-E59 >F59:/F$@IF(@OR(B59=G5,B59=0),E59+H58,F5) >E59:/F$.01*@INT(100*(.061:/F$.01*@INT(100*(.005+((E5/1200)*H60))) >D61:@IF(B61=0,0,@IF(C60=12,D60+1,D60) >C61:@IF(B61=0,0,@IF(C60=12,1,C60+1) >B61:@IF(@OR(B60=G5,B60=0),0,1+B60) >A61:+A60+1 >H60:/F$+H59-G60 >G60:/F$+F60-E60 >F60:/F$@IF(@OR(B60=G5,B60=0),E60+H59,F5) >E60:/F$.01*@+H61,F5) >E62:/F$.01*@INT(100*(.005+((E5/1200)*H61))) >D62:@IF(B62=0,0,@IF(C61=12,D61+1,D61) >C62:@IF(B62=0,0,@IF(C61=12,1,C61+1) >B62:@IF(@OR(B61=G5,B61=0),0,1+B61) >A62:+A61+1 >H61:/F$+H60-G61 >G61:/F$+F61-E61 >F61:/F$@IF(@OR(B61=G5,B61=0),E61+H60,F5) >E,B63=0),E63+H62,F5) >E63:/F$.01*@INT(100*(.005+((E5/1200)*H62))) >D63:@IF(B63=0,0,@IF(C62=12,D62+1,D62) >C63:@IF(B63=0,0,@IF(C62=12,1,C62+1) >B63:@IF(@OR(B62=G5,B62=0),0,1+B62) >A63:+A62+1 >H62:/F$+H61-G62 >G62:/F$+F62-E62 >F62:/F$@IF(@OR(B62=G5,B62=0),E62(@OR(B64=G5,B64=0),E64+H63,F5) >E64:/F$.01*@INT(100*(.005+((E5/1200)*H63))) >D64:@IF(B64=0,0,@IF(C63=12,D63+1,D63) >C64:@IF(B64=0,0,@IF(C63=12,1,C63+1) >B64:@IF(@OR(B63=G5,B63=0),0,1+B63) >A64:+A63+1 >H63:/F$+H62-G63 >G63:/F$+F63-E63 >F63:/F$@IF(@OR(B63=G5>F65:/F$@IF(@OR(B65=G5,B65=0),E65+H64,F5) >E65:/F$.01*@INT(100*(.005+((E5/1200)*H64))) >D65:@IF(B65=0,0,@IF(C64=12,D64+1,D64) >C65:@IF(B65=0,0,@IF(C64=12,1,C64+1) >B65:@IF(@OR(B64=G5,B64=0),0,1+B64) >A65:+A64+1 >H64:/F$+H63-G64 >G64:/F$+F64-E64 >F64:/F$@IFF$+F66-E66 >F66:/F$@IF(@OR(B66=G5,B66=0),E66+H65,F5) >E66:/F$.01*@INT(100*(.005+((E5/1200)*H65))) >D66:@IF(B66=0,0,@IF(C65=12,D65+1,D65) >C66:@IF(B66=0,0,@IF(C65=12,1,C65+1) >B66:@IF(@OR(B65=G5,B65=0),0,1+B65) >A66:+A65+1 >H65:/F$+H64-G65 >G65:/F$+F65-E65 -G67 >G67:/F$+F67-E67 >F67:/F$@IF(@OR(B67=G5,B67=0),E67+H66,F5) >E67:/F$.01*@INT(100*(.005+((E5/1200)*H66))) >D67:@IF(B67=0,0,@IF(C66=12,D66+1,D66) >C67:@IF(B67=0,0,@IF(C66=12,1,C66+1) >B67:@IF(@OR(B66=G5,B66=0),0,1+B66) >A67:+A66+1 >H66:/F$+H65-G66 >G66:/D53) >C54:@IF(B54=0,0,@IF(C53=12,1,C53+1) >B54:@IF(@OR(B53=G5,B53=0),0,1+B53) >A54:+A53+1 >H53:/F$+H52-G53 >G53:/F$+F53-E53 >F53:/F$@IF(@OR(B53=G5,B53=0),E53+H52,F5) >E53:/F$.01*@INT(100*(.005+((E5/1200)*H52))) >D53:@IF(B53=0,0,@IF(C52=12,D52+1,D52) >C53:@IF(B53=0,0,@IF(C52=12,1,C52+1) >B53:@IF(@OR(B52=G5,B52=0),0,1+B52) >A53:+A52+1 >H52:/F$+H51-G52 >G52:/F$+F52-E52 >F52:/F$@IF(@OR(B52=G5,B52=0),E52+H51,F5) >E52:/F$.01*@INT(100*(.005+((E5/1200)*H51))) >D52:@IF(B52=0,0,@IF(C51=12,D51+1,D51) >C52:@IF(B52=0,0, >E38:/F$.01*@INT(100*(.005+((E5/1200)*H37))) >D38:@IF(B38=0,0,@IF(C37=12,D37+1,D37) >C38:@IF(B38=0,0,@IF(C37=12,1,C37+1) >B38:@IF(@OR(B37=G5,B37=0),0,1+B37) >A38:+A37+1 >H37:/F$+H36-G37 >G37:/F$+F37-E37 >F37:/F$@IF(@OR(B37=G5,B37=0),E37+H36,F5) >E37:/F$.0E39+H38,F5) >E39:/F$.01*@INT(100*(.005+((E5/1200)*H38))) >D39:@IF(B39=0,0,@IF(C38=12,D38+1,D38) >C39:@IF(B39=0,0,@IF(C38=12,1,C38+1) >B39:@IF(@OR(B38=G5,B38=0),0,1+B38) >A39:+A38+1 >H38:/F$+H37-G38 >G38:/F$+F38-E38 >F38:/F$@IF(@OR(B38=G5,B38=0),E38+H37,F5)=G5,B40=0),E40+H39,F5) >E40:/F$.01*@INT(100*(.005+((E5/1200)*H39))) >D40:@IF(B40=0,0,@IF(C39=12,D39+1,D39) >C40:@IF(B40=0,0,@IF(C39=12,1,C39+1) >B40:@IF(@OR(B39=G5,B39=0),0,1+B39) >A40:+A39+1 >H39:/F$+H38-G39 >G39:/F$+F39-E39 >F39:/F$@IF(@OR(B39=G5,B39=0),@IF(@OR(B41=G5,B41=0),E41+H40,F5) >E41:/F$.01*@INT(100*(.005+((E5/1200)*H40))) >D41:@IF(B41=0,0,@IF(C40=12,D40+1,D40) >C41:@IF(B41=0,0,@IF(C40=12,1,C40+1) >B41:@IF(@OR(B40=G5,B40=0),0,1+B40) >A41:+A40+1 >H40:/F$+H39-G40 >G40:/F$+F40-E40 >F40:/F$@IF(@OR(B4042 >F42:/F$@IF(@OR(B42=G5,B42=0),E42+H41,F5) >E42:/F$.01*@INT(100*(.005+((E5/1200)*H41))) >D42:@IF(B42=0,0,@IF(C41=12,D41+1,D41) >C42:@IF(B42=0,0,@IF(C41=12,1,C41+1) >B42:@IF(@OR(B41=G5,B41=0),0,1+B41) >A42:+A41+1 >H41:/F$+H40-G41 >G41:/F$+F41-E41 >F41:/F$3:/F$+F43-E43 >F43:/F$@IF(@OR(B43=G5,B43=0),E43+H42,F5) >E43:/F$.01*@INT(100*(.005+((E5/1200)*H42))) >D43:@IF(B43=0,0,@IF(C42=12,D42+1,D42) >C43:@IF(B43=0,0,@IF(C42=12,1,C42+1) >B43:@IF(@OR(B42=G5,B42=0),0,1+B42) >A43:+A42+1 >H42:/F$+H41-G42 >G42:/F$+F42-EH43-G44 >G44:/F$+F44-E44 >F44:/F$@IF(@OR(B44=G5,B44=0),E44+H43,F5) >E44:/F$.01*@INT(100*(.005+((E5/1200)*H43))) >D44:@IF(B44=0,0,@IF(C43=12,D43+1,D43) >C44:@IF(B44=0,0,@IF(C43=12,1,C43+1) >B44:@IF(@OR(B43=G5,B43=0),0,1+B43) >A44:+A43+1 >H43:/F$+H42-G43 >G41 >H45:/F$+H44-G45 >G45:/F$+F45-E45 >F45:/F$@IF(@OR(B45=G5,B45=0),E45+H44,F5) >E45:/F$.01*@INT(100*(.005+((E5/1200)*H44))) >D45:@IF(B45=0,0,@IF(C44=12,D44+1,D44) >C45:@IF(B45=0,0,@IF(C44=12,1,C44+1) >B45:@IF(@OR(B44=G5,B44=0),0,1+B44) >A45:+A44+1 >H44:/F$+ >A47:+A46+1 >H46:/F$+H45-G46 >G46:/F$+F46-E46 >F46:/F$@IF(@OR(B46=G5,B46=0),E46+H45,F5) >E46:/F$.01*@INT(100*(.005+((E5/1200)*H45))) >D46:@IF(B46=0,0,@IF(C45=12,D45+1,D45) >C46:@IF(B46=0,0,@IF(C45=12,1,C45+1) >B46:@IF(@OR(B45=G5,B45=0),0,1+B45) >A46:+A45+0),0,1+B47) >A48:+A47+1 >H47:/F$+H46-G47 >G47:/F$+F47-E47 >F47:/F$@IF(@OR(B47=G5,B47=0),E47+H46,F5) >E47:/F$.01*@INT(100*(.005+((E5/1200)*H46))) >D47:@IF(B47=0,0,@IF(C46=12,D46+1,D46) >C47:@IF(B47=0,0,@IF(C46=12,1,C46+1) >B47:@IF(@OR(B46=G5,B46=0),0,1+B46)B48=G5,B48=0),0,1+B48) >A49:+A48+1 >H48:/F$+H47-G48 >G48:/F$+F48-E48 >F48:/F$@IF(@OR(B48=G5,B48=0),E48+H47,F5) >E48:/F$.01*@INT(100*(.005+((E5/1200)*H47))) >D48:@IF(B48=0,0,@IF(C47=12,D47+1,D47) >C48:@IF(B48=0,0,@IF(C47=12,1,C47+1) >B48:@IF(@OR(B47=G5,B47=50:@IF(@OR(B49=G5,B49=0),0,1+B49) >A50:+A49+1 >H49:/F$+H48-G49 >G49:/F$+F49-E49 >F49:/F$@IF(@OR(B49=G5,B49=0),E49+H48,F5) >E49:/F$.01*@INT(100*(.005+((E5/1200)*H48))) >D49:@IF(B49=0,0,@IF(C48=12,D48+1,D48) >C49:@IF(B49=0,0,@IF(C48=12,1,C48+1) >B49:@IF(@OR(1,C50+1) >B51:@IF(@OR(B50=G5,B50=0),0,1+B50) >A51:+A50+1 >H50:/F$+H49-G50 >G50:/F$+F50-E50 >F50:/F$@IF(@OR(B50=G5,B50=0),E50+H49,F5) >E50:/F$.01*@INT(100*(.005+((E5/1200)*H49))) >D50:@IF(B50=0,0,@IF(C49=12,D49+1,D49) >C50:@IF(B50=0,0,@IF(C49=12,1,C49+1) >B@IF(C51=12,1,C51+1) >B52:@IF(@OR(B51=G5,B51=0),0,1+B51) >A52:+A51+1 >H51:/F$+H50-G51 >G51:/F$+F51-E51 >F51:/F$@IF(@OR(B51=G5,B51=0),E51+H50,F5) >E51:/F$.01*@INT(100*(.005+((E5/1200)*H50))) >D51:@IF(B51=0,0,@IF(C50=12,D50+1,D50) >C51:@IF(B51=0,0,@IF(C50=12,1*@INT(100*(.005+((E5/1200)*H36))) >D37:@IF(B37=0,0,@IF(C36=12,D36+1,D36) >C37:@IF(B37=0,0,@IF(C36=12,1,C36+1) >B37:@IF(@OR(B36=G5,B36=0),0,1+B36) >A37:+A36+1 >H36:/F$+H35-G36 >G36:/F$+F36-E36 >F36:/F$@IF(@OR(B36=G5,B36=0),E36+H35,F5) >E36:/F$.01*@INT(100*(.005+((E5/1200)*H35))) >D36:@IF(B36=0,0,@IF(C35=12,D35+1,D35) >C36:@IF(B36=0,0,@IF(C35=12,1,C35+1) >B36:@IF(@OR(B35=G5,B35=0),0,1+B35) >A36:+A35+1 >H35:/F$+H34-G35 >G35:/F$+F35-E35 >F35:/F$@IF(@OR(B35=G5,B35=0),E35+H34,F5) >E35:/F$.01*@INT(100*(.005+((E5/F$+H20-G21 >G21:/F$+F21-E21 >F21:/F$@IF(@OR(B21=G5,B21=0),E21+H20,F5) >E21:/F$.01*@INT(100*(.005+((E5/1200)*H20))) >D21:@IF(B21=0,0,@IF(C20=12,D20+1,D20) >C21:@IF(B21=0,0,@IF(C20=12,1,C20+1) >B21:@IF(@OR(B20=G5,B20=0),0,1+B20) >A21:+A20+1 >H20:/F$+H19-G20 22+1 >H22:/F$+H21-G22 >G22:/F$+F22-E22 >F22:/F$@IF(@OR(B22=G5,B22=0),E22+H21,F5) >E22:/F$.01*@INT(100*(.005+((E5/1200)*H21))) >D22:@IF(B22=0,0,@IF(C21=12,D21+1,D21) >C22:@IF(B22=0,0,@IF(C21=12,1,C21+1) >B22:@IF(@OR(B21=G5,B21=0),0,1+B21) >A22:+A21+1 >H21:/23) >A24:+A23+1 >H23:/F$+H22-G23 >G23:/F$+F23-E23 >F23:/F$@IF(@OR(B23=G5,B23=0),E23+H22,F5) >E23:/F$.01*@INT(100*(.005+((E5/1200)*H22))) >D23:@IF(B23=0,0,@IF(C22=12,D22+1,D22) >C23:@IF(B23=0,0,@IF(C22=12,1,C22+1) >B23:@IF(@OR(B22=G5,B22=0),0,1+B22) >A23:+A24=0),0,1+B24) >A25:+A24+1 >H24:/F$+H23-G24 >G24:/F$+F24-E24 >F24:/F$@IF(@OR(B24=G5,B24=0),E24+H23,F5) >E24:/F$.01*@INT(100*(.005+((E5/1200)*H23))) >D24:@IF(B24=0,0,@IF(C23=12,D23+1,D23) >C24:@IF(B24=0,0,@IF(C23=12,1,C23+1) >B24:@IF(@OR(B23=G5,B23=0),0,1+BOR(B25=G5,B25=0),0,1+B25) >A26:+A25+1 >H25:/F$+H24-G25 >G25:/F$+F25-E25 >F25:/F$@IF(@OR(B25=G5,B25=0),E25+H24,F5) >E25:/F$.01*@INT(100*(.005+((E5/1200)*H24))) >D25:@IF(B25=0,0,@IF(C24=12,D24+1,D24) >C25:@IF(B25=0,0,@IF(C24=12,1,C24+1) >B25:@IF(@OR(B24=G5,B >B27:@IF(@OR(B26=G5,B26=0),0,1+B26) >A27:+A26+1 >H26:/F$+H25-G26 >G26:/F$+F26-E26 >F26:/F$@IF(@OR(B26=G5,B26=0),E26+H25,F5) >E26:/F$.01*@INT(100*(.005+((E5/1200)*H25))) >D26:@IF(B26=0,0,@IF(C25=12,D25+1,D25) >C26:@IF(B26=0,0,@IF(C25=12,1,C25+1) >B26:@IF(@12,1,C27+1) >B28:@IF(@OR(B27=G5,B27=0),0,1+B27) >A28:+A27+1 >H27:/F$+H26-G27 >G27:/F$+F27-E27 >F27:/F$@IF(@OR(B27=G5,B27=0),E27+H26,F5) >E27:/F$.01*@INT(100*(.005+((E5/1200)*H26))) >D27:@IF(B27=0,0,@IF(C26=12,D26+1,D26) >C27:@IF(B27=0,0,@IF(C26=12,1,C26+1),0,@IF(C28=12,1,C28+1) >B29:@IF(@OR(B28=G5,B28=0),0,1+B28) >A29:+A28+1 >H28:/F$+H27-G28 >G28:/F$+F28-E28 >F28:/F$@IF(@OR(B28=G5,B28=0),E28+H27,F5) >E28:/F$.01*@INT(100*(.005+((E5/1200)*H27))) >D28:@IF(B28=0,0,@IF(C27=12,D27+1,D27) >C28:@IF(B28=0,0,@IF(C27=0:@IF(B30=0,0,@IF(C29=12,1,C29+1) >B30:@IF(@OR(B29=G5,B29=0),0,1+B29) >A30:+A29+1 >H29:/F$+H28-G29 >G29:/F$+F29-E29 >F29:/F$@IF(@OR(B29=G5,B29=0),E29+H28,F5) >E29:/F$.01*@INT(100*(.005+((E5/1200)*H28))) >D29:@IF(B29=0,0,@IF(C28=12,D28+1,D28) >C29:@IF(B29=0+1,D30) >C31:@IF(B31=0,0,@IF(C30=12,1,C30+1) >B31:@IF(@OR(B30=G5,B30=0),0,1+B30) >A31:+A30+1 >H30:/F$+H29-G30 >G30:/F$+F30-E30 >F30:/F$@IF(@OR(B30=G5,B30=0),E30+H29,F5) >E30:/F$.01*@INT(100*(.005+((E5/1200)*H29))) >D30:@IF(B30=0,0,@IF(C29=12,D29+1,D29) >C3(C31=12,D31+1,D31) >C32:@IF(B32=0,0,@IF(C31=12,1,C31+1) >B32:@IF(@OR(B31=G5,B31=0),0,1+B31) >A32:+A31+1 >H31:/F$+H30-G31 >G31:/F$+F31-E31 >F31:/F$@IF(@OR(B31=G5,B31=0),E31+H30,F5) >E31:/F$.01*@INT(100*(.005+((E5/1200)*H30))) >D31:@IF(B31=0,0,@IF(C30=12,D30B33=0,0,@IF(C32=12,D32+1,D32) >C33:@IF(B33=0,0,@IF(C32=12,1,C32+1) >B33:@IF(@OR(B32=G5,B32=0),0,1+B32) >A33:+A32+1 >H32:/F$+H31-G32 >G32:/F$+F32-E32 >F32:/F$@IF(@OR(B32=G5,B32=0),E32+H31,F5) >E32:/F$.01*@INT(100*(.005+((E5/1200)*H31))) >D32:@IF(B32=0,0,@IF) >D34:@IF(B34=0,0,@IF(C33=12,D33+1,D33) >C34:@IF(B34=0,0,@IF(C33=12,1,C33+1) >B34:@IF(@OR(B33=G5,B33=0),0,1+B33) >A34:+A33+1 >H33:/F$+H32-G33 >G33:/F$+F33-E33 >F33:/F$@IF(@OR(B33=G5,B33=0),E33+H32,F5) >E33:/F$.01*@INT(100*(.005+((E5/1200)*H32))) >D33:@IF(1200)*H34))) >D35:@IF(B35=0,0,@IF(C34=12,D34+1,D34) >C35:@IF(B35=0,0,@IF(C34=12,1,C34+1) >B35:@IF(@OR(B34=G5,B34=0),0,1+B34) >A35:+A34+1 >H34:/F$+H33-G34 >G34:/F$+F34-E34 >F34:/F$@IF(@OR(B34=G5,B34=0),E34+H33,F5) >E34:/F$.01*@INT(100*(.005+((E5/1200)*H33))>G20:/F$+F20-E20 >F20:/F$@IF(@OR(B20=G5,B20=0),E20+H19,F5) >E20:/F$.01*@INT(100*(.005+((E5/1200)*H19))) >D20:@IF(B20=0,0,@IF(C19=12,D19+1,D19) >C20:@IF(B20=0,0,@IF(C19=12,1,C19+1) >B20:@IF(@OR(B19=G5,B19=0),0,1+B19) >A20:+A19+1 >H19:/F$+H18-G19 >G19:/F$+F19-E19 >F19:/F$@IF(@OR(B19=G5,B19=0),E19+H18,F5) >E19:/F$.01*@INT(100*(.005+((E5/1200)*H18))) >D19:@IF(B19=0,0,@IF(C18=12,D18+1,D18) >C19:@IF(B19=0,0,@IF(C18=12,1,C18+1) >B19:@IF(@OR(B18=G5,B18=0),0,1+B18) >A19:+A18+1 >H18:/F$+H17-G18 >G18:/F$+F18-E18 >F18:/ 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>F4:/FR"PAYMENT >E4:/FR"INT RATE >D4:/FR"LOAN AMT >B4:"CUST NAME >A4:+A3+1 >A3:+A2+1 >A2:+A1+1 >D1:"ORTIZATION >C1:"ORTGAGE AM >B1:"MODEL 16 M >A1:1 /W1 /GOR /GRM /GC10 /X>A1:>A1: E6:/-= >D6:/-= >C6:/-= >B6:/-= >A6:+A5+1 >I5:/F$@NPV(H5/1200,F9...F68 >H5:/F$" ........ >G5:/FI" ........ >F5:/F$" ........ >E5:/F$" ........ >D5:/F$" ........ >C5:".......... >B5:" ......... >A5:+A4+1 >I4:/FR"DSC AMT >H4:/FR"DSC RATE >G4:/FR"NO PMTS +A8+1 >I8:/FR/-- >H8:/FR/-- >G8:/FR/-- >F8:/FR/-- >E8:/FR/-- >D8:/FR/-- >C8:/FR/-- >B8:/FR/-- >A8:+A7+1 >H7:/FR"LOAN BAL >G7:/FR"TO PRIN >F7:/FR"PAYMENT >E7:/FR"TO INT >D7:/FR"PMT YR >C7:/FR"PMT MO >B7:/FR"PMT NO >A7:+A6+1 >I6:/-= >H6:/-= >G6:/-= >F6:/-= >B10=0,0,@IF(C9=12,D9+1,D9) >C10:@IF(B10=0,0,@IF(C9=12,1,C9+1) >B10:@IF(@OR(B9=G5,B9=0),0,1+B9) >A10:+A9+1 >H9:/F$+D5-G9 >G9:/F$+F9-E9 >F9:/F$@IF(@OR(B9=G5,B9=0),E9+D5,F5) >E9:/F$.01*@INT(100*(.005+((E5/1200)*D5))) >D9:" ........ >C9:" ........ >B9:1 >A9:0))) >D11:@IF(B11=0,0,@IF(C10=12,D10+1,D10) >C11:@IF(B11=0,0,@IF(C10=12,1,C10+1) >B11:@IF(@OR(B10=G5,B10=0),0,1+B10) >A11:+A10+1 >H10:/F$+H9-G10 >G10:/F$+F10-E10 >F10:/F$@IF(@OR(B10=G5,B10=0),E10+H9,F5) >E10:/F$.01*@INT(100*(.005+((E5/1200)*H9))) >D10:@IF(E5/1200)*H11))) >D12:@IF(B12=0,0,@IF(C11=12,D11+1,D11) >C12:@IF(B12=0,0,@IF(C11=12,1,C11+1) >B12:@IF(@OR(B11=G5,B11=0),0,1+B11) >A12:+A11+1 >H11:/F$+H10-G11 >G11:/F$+F11-E11 >F11:/F$@IF(@OR(B11=G5,B11=0),E11+H10,F5) >E11:/F$.01*@INT(100*(.005+((E5/1200)*H100*(.005+((E5/1200)*H12))) >D13:@IF(B13=0,0,@IF(C12=12,D12+1,D12) >C13:@IF(B13=0,0,@IF(C12=12,1,C12+1) >B13:@IF(@OR(B12=G5,B12=0),0,1+B12) >A13:+A12+1 >H12:/F$+H11-G12 >G12:/F$+F12-E12 >F12:/F$@IF(@OR(B12=G5,B12=0),E12+H11,F5) >E12:/F$.01*@INT(100*(.005+(($.01*@INT(100*(.005+((E5/1200)*H13))) >D14:@IF(B14=0,0,@IF(C13=12,D13+1,D13) >C14:@IF(B14=0,0,@IF(C13=12,1,C13+1) >B14:@IF(@OR(B13=G5,B13=0),0,1+B13) >A14:+A13+1 >H13:/F$+H12-G13 >G13:/F$+F13-E13 >F13:/F$@IF(@OR(B13=G5,B13=0),E13+H12,F5) >E13:/F$.01*@INT(1F5) >E15:/F$.01*@INT(100*(.005+((E5/1200)*H14))) >D15:@IF(B15=0,0,@IF(C14=12,D14+1,D14) >C15:@IF(B15=0,0,@IF(C14=12,1,C14+1) >B15:@IF(@OR(B14=G5,B14=0),0,1+B14) >A15:+A14+1 >H14:/F$+H13-G14 >G14:/F$+F14-E14 >F14:/F$@IF(@OR(B14=G5,B14=0),E14+H13,F5) >E14:/F0),E16+H15,F5) >E16:/F$.01*@INT(100*(.005+((E5/1200)*H15))) >D16:@IF(B16=0,0,@IF(C15=12,D15+1,D15) >C16:@IF(B16=0,0,@IF(C15=12,1,C15+1) >B16:@IF(@OR(B15=G5,B15=0),0,1+B15) >A16:+A15+1 >H15:/F$+H14-G15 >G15:/F$+F15-E15 >F15:/F$@IF(@OR(B15=G5,B15=0),E15+H14,B17=G5,B17=0),E17+H16,F5) >E17:/F$.01*@INT(100*(.005+((E5/1200)*H16))) >D17:@IF(B17=0,0,@IF(C16=12,D16+1,D16) >C17:@IF(B17=0,0,@IF(C16=12,1,C16+1) >B17:@IF(@OR(B16=G5,B16=0),0,1+B16) >A17:+A16+1 >H16:/F$+H15-G16 >G16:/F$+F16-E16 >F16:/F$@IF(@OR(B16=G5,B16=/F$@IF(@OR(B18=G5,B18=0),E18+H17,F5) >E18:/F$.01*@INT(100*(.005+((E5/1200)*H17))) >D18:@IF(B18=0,0,@IF(C17=12,D17+1,D17) >C18:@IF(B18=0,0,@IF(C17=12,1,C17+1) >B18:@IF(@OR(B17=G5,B17=0),0,1+B17) >A18:+A17+1 >H17:/F$+H16-G17 >G17:/F$+F17-E17 >F17:/F$@IF(@OR(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$(NOT FOUND.)"X=11000:X:::210Z a$="{,|,~,}; selects; back 1 level; 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; 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),112405l=ơ):: 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! 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::"ay be of use to the home user in some form or another. We've put themMinto the public domain as part of a continuing attempt to make all formerlyOcommercial Apple /// products (that are not still on the market in some form)!available to the /// cbe used immediately. As the banker gains experience inLVC by using these models, he may wish to use them as a base for developinghis own customized programs.N Note that these models can all be pulled into 3EZ Pieces or Appleworks Mand mVisiCalc models written by community bankers or Banking Industry 7Software Houses and contributed to the publication. $ According to the Introduction:EThe purpose of this book is to provide bank personnel with VisicalcJmodels which can   BANKCALC #2INFORMATION ABOUT THIS DISK :K BANKCALC was written by Anthony Powers and published by Micro Book, IInc. of Arlington Heights, Illinois in 1982. It is a collection of 14 C HO=====|====|====|====|====|====|====|====|====|====|====|====|====|====|====|===lG EAD 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" 79C";"PRESS ANY KEY TO HALT LISTING"::202 1020#2,B$(I),16,B)ž#242:::1160Z=1#2;A$:"78A";A$Z=Z+1:Z>1842:::Z=1980*:=23:=0::"79C";"CONTINUE...?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"10ommunity.MNOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS( A VISICALC FILE RATHER THAN DIF.O We've included Menu.Maker on this disk so that (after you've booted intoOBusiness Basic from another disk or off your hard disk) you can look at theseMfiles or print them if you like. This information file is available in both*Text and 3EZP/Appleworks format as well.L While these models should hold for the present, please be aware that Nthey all Model 16: Mortgage AmortizationL The preparation of a mortgage amortization schedule, and theG development of a price for the mortgage based upon the C present value given a bank's desired rate of return The calculation of monthly average rates given a series of  daily rates.-: Model 15: Income TaxJ The calculation of the banks monthly provisions of federal income taxesLENDING MODEL%-: the actual monthly results .-: Model 13: Balance Sheet Budget to ActualJ A monthly comparison of the asset and liability monthly 6 budget with the actual monthly results-: Model 14: Monthly RatesK on of depreciation on fixed assets for taxJ purposes using the new Accelerated Cost Recovery Guideline%-: Model 12: Budget Income ExpenseJ A monthly comparison between budgeted income and expenses,/ andyears of bankB earnings, based upon historical earnings, current > earnings, and a series of earnings assumptions SIDE TWOACCOUNTING MODELS)-: Model 11: Accelerated Cost RecoveryG The calculati: Interest MarginI A monthly management report of the spread between earning + assets and paid liabilities EARNINGS MODEL$-: Model 10: Earnings ProjectionsG A bank earnings model which projects four ment report of all assets and the 0 monthly yields of earning assets -: Model 8: Liability CostsE A monthly management report of all liabilities and the/ monthly cost of paid liabilities-: Model 9on of monthly yields for all classes of Investments-: Model 6: Deposit CostsB The calculation of monthly costs for all classes of Deposits-: Model 7: Asset YieldsA A monthly manageclasses of ! Real Estate Loans."-: Model 4: Money Market YieldsC The calculation of monthly yields for all classes of# Money Market Yields. -: Model 5: Investment YieldsC The calculatiLoans. &-: Model 2: Installment Loan YieldsC The calculation of monthly yields for all classes of! Installment Loans.'-: Model 3: Real Estate Loan Yields D The calculation of monthly yields for all HEM.JOn Side One of this disk (III.ZAW.08) you'll find the following Visicalc models:YIELD MODELS+-: Model 1: Commercial Loan Yields D The calculation of monthly yields for all classes of " Commercial ut there is no implied guarantee that any of theseEmodels as presented will return information accurate for the 1990s.LNOTE #2: THE BOOKS THAT ACCOMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE9 WAP OFFICE SHOULD YOU NEED TO REFERENCE Tcame out in the early 1980s and reflect the situation at that time.NSome of these models may require some changes based on today's realities. AsMthis is a PD offering, buyer beware takes precidence here. You should findLsome of these useful. B