LnSOS BOOT 1.1 SOS.KERNEL SOS KRNLI/O ERRORFILE 'SOS.KERNEL' NOT FOUND%INVALID KERNEL FILE: xةw,@  ȱlmi8#)!)>P57:/FI+P42-P56 >O57:/FI+O42-O56 >N57:/FI+N42-N56 >M57:/FI+M42-M56 >L57:/FI+L42-L56 >K57:/FI+K42-K56 >J57:"NET INT MAR >I57:+I56+1 >P56:/FI+P53+P54+P55 >O56:/FI+O53+O54+O55 >N56:/FI+N53+N54+N55 >M56:/FI+M53+M54+M55 >L56:/FI+L53+L54+L55 >K56:/FI+K53+K54+K5.BANKCALC.ASCII ۸5۸5(BANKCALCP D۸4۸4BANKCALCP D۸/۸4&I!!&MODEL7g !$!$&MODEL86!'!(&MODEL9n3!,!-*MENU.MAKER 3,8DISKNAME.DAT ۸ ۸ %SEG.T j۸ Ÿ/ III.AWZ.07u' &MODEL16! ! &MODEL2% ! ! &MODEL3.!!&MODEL4=:!!&MODEL5\%NF!!&MODEL6 >dLԡm#i㰼m#iЕOLԡȱfg hi !dLԡ憦  Ljmkm l y`2 Lԡ8(Je稽)ʈ@L5 >J56:"TOT INT LIAB >I56:+I55+1 >H56:/F$" ......... >G56:/F$" .......... >F56:" ......... >E56:" ......... >D56:" ......... >C56:" ......... >B56:"TOT INT LIAB >A56:+A55+1 >P55:/FI+K55 >O55:/FI+K55-(M55+N55) >N55:/FI(F55-E55)*H55 >M55:/FI(H55-  !"#>B44:"LIABILITIES >A44:+A43+1 >I43:+I42+1 >A43:+A42+1 >P42:/FI+P9+P15+P41 >O42:/FI+O9+O15+O41 >N42:/FI+N9+N15+N41 >M42:/FI+M9+M15+M41 >L42:/FI+L9+L15+L41 >K42:/FI+K9+K15+K41 >J42:"TOTAL ASSETS >I42:+I41+1 >H42:/F$" ......... >G42:/F$" ......... >F42:" GS >I46:+I45+1 >H46:/F$" ......... >G46:/F$" ......... >F46:" ......... >E46:" ......... >D46:" .......... >C46:" ......... >B46:" SAVINGS >A46:+A45+1 >J45:"TIME DEPOSIT >I45:+I44+1 >B45:"TIME DEPOSIT >A45:+A44+1 >J44:"LIABILITIES >I44:+I43+1 ......... >F47:" ......... >E47:" ......... >D47:" ......... >C47:" ......... >B47:" IRA >A47:+A46+1 >P46:/FI+K46 >O46:/FI+K46-(M46+N46) >N46:/FI(F46-E46)*H46*M8/365/100 >M46:/FI(H46-G46)*F46*M8/365/100 >L46:+F46-E46 >K46:+D46-C46 >J46:" SAVIN....... >D48:" .......... >C48:" ......... >B48:" NOW >A48:+A47+1 >P47:/FI+K47 >O47:/FI+K47-(M47+N47) >N47:/FI(F47-E47)*H47*M8/365/100 >M47:/FI(H47-G47)*F47*M8/365/100 >L47:+F47-E47 >K47:+D47-C47 >J47:" IRA >I47:+I46+1 >H47:/F$" ......... >G47:/F$" >B49:" T-CERT >A49:+A48+1 >P48:/FI+K48 >O48:/FI+K48-(M48+N48) >N48:/FI(F48-E48)*H48*M8/365/100 >M48:/FI(H48-G48)*F48*M8/365/100 >L48:+F48-E48 >K48:+D48-C48 >J48:" NOW >I48:+I47+1 >H48:/F$" ......... >G48:/F$" ......... >F48:" ......... >E48:" ..I+K49-(M49+N49) >N49:/FI(F49-E49)*H49*M8/365/100 >M49:/FI(H49-G49)*F49*M8/365/100 >L49:+F49-E49 >K49:+D49-C49 >J49:" T-CERT >I49:+I48+1 >H49:/F$" ......... >G49:/F$" ......... >F49:" ......... >E49:" ......... >D49:" ......... >C49:" .........I(H50-G50)*F50*M8/365/100 >L50:+F50-E50 >K50:+D50-C50 >J50:" OTHER CERT >I50:+I49+1 >H50:/F$" ......... >G50:/F$" ......... >F50:" ......... >E50:" ......... >D50:" ......... >C50:" ......... >B50:" OTHER CERT >A50:+A49+1 >P49:/FI+K49 >O49:/F51:" ALL SAVERS >I51:+I50+1 >H51:/F$" ......... >G51:/F$" ......... >F51:" ......... >E51:" ......... >D51:" ......... >C51:" ......... >B51:" ALL SAVERS >A51:+A50+1 >P50:/FI+K50 >O50:/FI+K50-(M50+N50) >N50:/FI(F50-E50)*H50*M8/365/100 >M50:/FF$" ......... >F52:" ......... >E52:" ......... >D52:" ......... >C52:" .......... >B52:" PUBLIC FND >A52:+A51+1 >P51:/FI+K51 >O51:/FI+K51-(M51+N51) >N51:/FI(F51-E51)*H51*M8/365/100 >M51:/FI(H51-G51)*F51*M8/365/100 >L51:+F51-E51 >K51:+D51-C51 >J:" ......... >C53:" ......... >B53:"TOTAL TIME >A53:+A52+1 >P52:/FI+K52 >O52:/FI+K52-(M52+N52) >N52:/FI((F52-E52)*H52*30)/360/100 >M52:/FI((H52-G52)*F52*30)/360/100 >L52:+F52-E52 >K52:+D52-C52 >J52:" PUBLIC FND >I52:+I51+1 >H52:/F$" ......... >G52:/3:/FI@SUM(P46...P52) >O53:/FI@SUM(O46...O52) >N53:/FI@SUM(N46...N52) >M53:/FI@SUM(M46...M52) >L53:/FI@SUM(L46...L52) >K53:/FI@SUM(K46...K52) >J53:"TOTAL TIME >I53:+I52+1 >H53:/F$" ......... >G53:/F$" ......... >F53:" ......... >E53:" ......... >D53N54:/FI(F54-E54)*H54 >M54:/FI(H54-G54)*F54 >L54:+F54-E54 >K54:+D54-C54 >J54:"FED FUND PUR >I54:+I53+1 >H54:/F$" ......... >G54:/F$" ......... >F54:" ......... >E54:" ......... >D54:" ......... >C54:" ......... >B54:"FED FUND PUR >A54:+A53+1 >P5G55)*F55 >L55:+F55-E55 >K55:+D55-C55 >J55:"SEC SOLD UAR >I55:+I54+1 >H55:/F$" ......... >G55:/F$" ......... >F55:" ......... >E55:" ......... >D55:" ......... >C55:" ......... >B55:"SEC SOLD UAR >A55:+A54+1 >P54:/FI+K54 >O54:/FI+K54-(M54+N54) > ......... >E42:" ......... >D42:" ......... >C42:" ......... >B42:"TOTAL ASSETS >A42:+A41+1 >P41:/FI+P26+P35+P40 >O41:/FI+O26+O35+O40 >N41:/FI+N26+N35+N40 >M41:/FI+M26+M35+M40 >L41:/FI+L26+L35+L40 >K41:/FI+K26+K35+K40 >J41:"TOTAL LOANS >I41:+I40+1 >H41:/F$" ......... >G41:/F$" ......... >F41:" ......... >E41:" ......... >D41:" ......... >C41:" ......... >B41:"TOTAL LOANS >A41:+A40+1 >P40:/FI+P37+P38+P39 >O40:/FI+O37+O38+O39 >N40:/FI+N37+N38+N39 >M40:/FI+M37+M38+M39 >L40:/FI+L37+L38+L39 >:" ......... >C29:" ......... >B29:" FHA >A29:+A28+1 >P28:/FI+K28 >O28:/FI+K28-(M28+N28) >N28:/FI((E28-F28)*H28*30)/360/100 >M28:/FI((G28-H28)*F28*30)/360/100 >L28:+E28-F28 >K28:+C28-D28 >J28:" AUTO >I28:+I27+1 >H28:/F$" ......... >G28:/F$" ...A30:+A29+1 >P29:/FI+K29 >O29:/FI+K29-(M29+N29) >N29:/FI((E29-F29)*H29*30)/360/100 >M29:/FI((G29-H29)*F29*30)/360/100 >L29:+E29-F29 >K29:+C29-D29 >J29:" FHA >I29:+I28+1 >H29:/F$" ......... >G29:/F$" ......... >F29:" ......... >E29:" ......... >D2930-F30)*H30*30)/360/100 >M30:/FI((G30-H30)*F30*30)/360/100 >L30:+E30-F30 >K30:+C30-D30 >J30:" PERSONAL >I30:+I29+1 >H30:/F$" ......... >G30:/F$" ......... >F30:" ......... >E30:" ......... >D30:" ......... >C30:" ......... >B30:" PERSONAL > >L31:+E31-F31 >K31:+C31-D31 >J31:" COM INST >I31:+I30+1 >H31:/F$" ......... >G31:/F$" ......... >F31:" ......... >E31:" ......... >D31:" ......... >C31:" ......... >B31:" COM INST >A31:+A30+1 >P30:/FI+K30 >O30:/FI+K30-(M30+N30) >N30:/FI((E >H32:/F$" ......... >G32:/F$" ......... >F32:" ......... >E32:" ......... >D32:" ......... >C32:" ......... >B32:" DISCNTED >A32:+A31+1 >P31:/FI+K31 >O31:/FI+K31-(M31+N31) >N31:/FI((E31-F31)*H31*30)/360/100 >M31:/FI((G31-H31)*F31*30)/360/1000+E31+E32 >D33:+D28+D29+D30+D31+D32 >C33:+C28+C29+C30+C31+C32 >B33:" SUBTOTL >A33:+A32+1 >P32:/FI+K32 >O32:/FI+K32-(M32+N32) >N32:/FI((E32-F32)*H32*30)/360/100 >M32:/FI((G32-H32)*F32*30)/360/100 >L32:+E32-F32 >K32:+C32-D32 >J32:" DISCNTED >I32:+I31+14:+A33+1 >P33:/FI+P28+P29+P30+P31+P32 >O33:/FI+O28+O29+O30+O31+O32 >N33:/FI+N28+N29+N30+N31+N32 >M33:/FI+M28+M29+M30+M31+M32 >L33:/FI+L28+L29+L30+L31+L32 >K33:/FI+K28+K29+K30+K31+K32 >J33:" SUBTOTL >I33:+I32+1 >F33:+F28+F29+F30+F31+F32 >E33:+E28+E29+E334-F34)*H34*M8)/365/100 >M34:/FI((G34-H34)*F34*M8)/365/100 >L34:+E34-F34 >K34:+C34-D34 >J34:" STUDENT >I34:+I33+1 >H34:/F$" ......... >G34:/F$" ......... >F34:" ......... >E34:" ......... >D34:" ......... >C34:" ......... >B34:" STUDENT >A3I+L33+L34 >K35:/FI+K33+K34 >J35:"TOTAL INSTAL >I35:+I34+1 >H35:/F$" ......... >G35:/F$" ......... >F35:" ......... >E35:" ......... >D35:" ......... >C35:" ......... >B35:"TOTAL INSTAL >A35:+A34+1 >P34:/FI+K34 >O34:/FI+K34-(M34+N34) >N34:/FI((E..... >F37:" ......... >E37:" ......... >D37:" ......... >C37:" ......... >B37:" RESIDENT >A37:+A36+1 >P36:/FI >J36:" REAL ESTE >I36:+I35+1 >B36:" REAL ESTE >A36:+A35+1 >P35:/FI+P33+P34 >O35:/FI+O33+O34 >N35:/FI+N33+N34 >M35:/FI+M33+M34 >L35:/F........ >C38:" ......... >B38:" COMM >A38:+A37+1 >P37:/FI+K37 >O37:/FI+K37-(M37+N37) >N37:/FI((E37-F37)*H37*30)/360/100 >M37:/FI((G37-H37)*F37*30)/360/100 >L37:+E37-F37 >K37:+C37-D37 >J37:" RESIDENT >I37:+I36+1 >H37:/F$" ......... >G37:/F$" ....8+1 >P38:/FI+K38 >O38:/FI+K38-(M38+N38) >N38:/FI((E38-F38)*H38*30)/360/100 >M38:/FI((G38-H38)*F38*30)/360/100 >L38:+E38-F38 >K38:+C38-D38 >J38:" COMM >I38:+I37+1 >H38:/F$" ......... >G38:/F$" ......... >F38:" ......... >E38:" ......... >D38:" .*H39*30)/360/100 >M39:/FI((G39-H39)*F39*30)/360/100 >L39:+E39-F39 >K39:+C39-D39 >J39:" GOV GUAR >I39:+I38+1 >H39:/F$" ......... >G39:/F$" ......... >F39:" ......... >E39:" ......... >D39:" ......... >C39:" ......... >B39:" GOV GUAR >A39:+A3K40:/FI+K37+K38+K39 >J40:"TOTAL REAL E >I40:+I39+1 >H40:/F$" ......... >G40:/F$" ......... >F40:" ......... >E40:" ......... >D40:" ......... >C40:" ......... >B40:"TOTAL REAL E >A40:+A39+1 >P39:/FI+K39 >O39:/FI+K39-(M39+N39) >N39:/FI((E39-F39)...... >F28:" ......... >E28:" ......... >D28:" ......... >C28:" ......... >B28:" AUTO >A28:+A27+1 >J27:" INSTALL >I27:+I26+1 >B27:" INSTALL >A27:+A26+1 >P26:/FI+P22+P23+P24+P25 >O26:/FI+O22+O23+O24+O25 >N26:/FI+N22+N23+N24+N25 >M26:/FI+M22+M23+M24+M25 >L26:/FI+L22+L23+L24+L25 >K26:/FI+K22+K23+K24+K25 >J26:"TOTAL COM LN >I26:+I25+1 >H26:/F$" ......... >G26:/F$" ......... >F26:" ......... >E26:" ......... >D26:" ......... >C26:" ......... >B26:"TOTAL COM LN >A26:+A25+1 >P25:/FI+K25 >O >K12:+C12-D12 >J12:" GOV >I12:+I11+1 >H12:/F$" ......... >G12:/F$" ......... >F12:" ......... >E12:" ......... >D12:" ......... >C12:" ......... >B12:" GOV >A12:+A11+1 >J11:"INVESTMENTS >I11:+I10+1 >B11:"INVESTMENTS >A11:+A10+1 >I10:+I9+1 >A ......... >G13:/F$" ......... >F13:" ......... >E13:" .......... >D13:" ......... >C13:" ......... >B13:" STATE >A13:+A12+1 >P12:/FI+K12 >O12:/FI+K12-(M12+N12) >N12:/FI((E12-F12)*H12*M8)/365/100 >M12:/FI((G12-H12)*F12*M8)/365/100 >L12:+E12-F12..... >D14:" ......... >C14:" ......... >B14:" OTHER >A14:+A13+1 >P13:/FI+K13 >O13:/FI+K13-(M13+N13) >N13:/FI((E13-F13)*H13*.54*30)/360/100 >M13:/FI(((G13*.54)-(H13*.54))*F13*30)/360/100 >L13:+E13-F13 >K13:+C13-D13 >J13:" STATE >I13:+I12+1 >H13:/F$" TAL SEC >A15:+A14+1 >P14:/FI+K14 >O14:/FI+K14-(M14+N14) >N14:/FI((E14-F14)*H14*30)/360/100 >M14:/FI((G14-H14)*F14*30)/360/100 >L14:+E14-F14 >K14:+C14-D14 >J14:" OTHER >I14:+I13+1 >H14:/F$" ......... >G14:/F$" ......... >F14:" ......... >E14:" ..../FI+O12+O13+O14 >N15:/FI+N12+N13+N14 >M15:/FI+M12+M13+M14 >L15:/FI+L12+L13+L14 >K15:/FI+K12+K13+K14 >J15:"TOTAL SEC >I15:+I14+1 >H15:/F$" ......... >G15:/F$" ......... >F15:" ......... >E15:" ......... >D15:" ......... >C15:" ......... >B15:"TO ......... >D19:" ......... >C19:" ......... >B19:" SECURED >A19:+A18+1 >J18:" COMMERCIAL >I18:+I17+1 >H18:/F$ >G18:/F$ >B18:" COMMERCIAL >A18:+A17+1 >J17:"LOANS >I17:+I16+1 >B17:"LOANS >A17:+A16+1 >I16:+I15+1 >A16:+A15+1 >P15:/FI+P12+P13+P14 >O15:UNSECURED >A20:+A19+1 >P19:/FI+K19 >O19:/FI+K19-(M19+N19) >N19:/FI((E19-F19)*H19*M8)/365/100 >M19:/FI((G19-H19)*F19*M8)/365/100 >L19:+E19-F19 >K19:+C19-D19 >J19:" SECURED >I19:+I18+1 >H19:/F$" ......... >G19:/F$" ......... >F19:" ......... >E19:" 0:/FI((E20-F20)*H20*M8)/365/100 >M20:/FI((G20-H20)*F20*M8)/365/100 >L20:+E20-F20 >K20:+C20-D20 >J20:" UNSECURED >I20:+I19+1 >H20:/F$" ......... >G20:/F$" ......... >F20:" ......... >E20:" ......... >D20:" ......... >C20:" .......... >B20:" *M8)/365/100 >L21:+E21-F21 >K21:+C21-D21 >J21:" DEMAND >I21:+I20+1 >H21:/F$" ......... >G21:/F$" ......... >F21:" ......... >E21:" ......... >D21:" ......... >C21:" ......... >B21:" DEMAND >A21:+A20+1 >P20:/FI+K20 >O20:/FI+K20-(M20+N20) >N2L20+L21 >K22:/FI+K19+K20+K21 >J22:" SUBTOTL >I22:+I21+1 >F22:+F19+F20+F21 >E22:+E19+E20+E21 >D22:+D19+D20+D21 >C22:+C19+C20+C21 >B22:" SUBTOTL >A22:+A21+1 >P21:/FI+K21 >O21:/FI+K21-(M21+N21) >N21:/FI((E21-F21)*H21*M8)/365/100 >M21:/FI((G21-H21)*F21:+I22+1 >H23:/F$" ......... >G23:/F$" ......... >F23:" ......... >E23:" ......... >D23:" ......... >C23:" ......... >B23:" EQUIPMENT >A23:+A22+1 >P22:/FI+P19+P20+P21 >O22:/FI+O19+O20+O21 >N22:/FI+N19+N20+N21 >M22:/FI+M19+M20+M21 >L22:/FI+L19+ ......... >E24:" ......... >D24:" ......... >C24:" ......... >B24:" BROKERS >A24:+A23+1 >P23:/FI+K23 >O23:/FI+K23-(M23+N23) >N23:/FI((E23-F23)*H23*30)/360/100 >M23:/FI((G23-H23)*F23*30)/360/100 >L23:+E23-F23 >K23:+C23-D23 >J23:" EQUIPMENT >I23 ......... >B25:" AUTO LSE >A25:+A24+1 >P24:/FI+K24 >O24:/FI+K24-(M24+N24) >N24:/FI((E24-F24)*H24*M8)/365/100 >M24:/FI((G24-H24)*F24*M8)/365/100 >L24:+E24-F24 >K24:+C24-D24 >J24:" BROKERS >I24:+I23+1 >H24:/F$" ......... >G24:/F$" ......... >F24:"25:/FI+K25-(M25+N25) >N25:/FI((E25-F25)*H25*M8)/365/100 >M25:/FI((G25-H25)*F25*M8)/365/100 >L25:+E25-F25 >K25:+C25-D25 >J25:" AUTO LSE >I25:+I24+1 >H25:/F$" ......... >G25:/F$" ......... >F25:" ......... >E25:" ......... >D25:" ......... >C25:"10:+A9+1 >P9:+K9 >O9:/FI+K9-(M9+N9) >N9:/FI((E9-F9)*H9*M8)/365/100 >M9:/FI((G9-H9)*F9*M8)/365/100 >L9:+E9-F9 >K9:+C9-D9 >J9:"FED FUNDS >I9:+I8+1 >H9:/F$" ......... >G9:/F$" ......... >F9:" ......... >E9:" ........ >D9:" .......... >C9:" ......... >B9:"FED FUNDS >A9:+A8+1 >M8:" ......... >J8:"DAYS CUR MNT >I8:+I7+1 >H8:" ======== >G8:" =========== >F8:" ========== >E8:" ========== >D8:" ========== >C8:" =========== >B8:"========== >A8:+A7+1 >N7:"VARIANCE >M7:"VARIANCE >L7:"VARIANCE >K7::"OTHER >B43:"INTEREST >A43:+A42+1 >F42:/F$100*((E42*12)/D42) >E42:" ....... >D42:" ....... >C42:"NTS >B42:"NOW ACCOU >A42:+A41+1 >F41:/F$100*((E41*12)/D41) >E41:" ....... >D41:" ....... >C41:"E AGR'MT >B41:"REPURCHAS >A41:+A40+1 >F40:/F$100*((E40*12)/:" -------- >A46:+A45+1 >F45:/F$100*((E45*12)/D45) >E45:@SUM(E36...E44 >D45:@SUM(D36...D44 >C45:"EAR DEP >B45:"TTL INT B >A45:+A44+1 >F44:" -------- >E44:" -------- >D44:" -------- >A44:+A43+1 >F43:/F$100*((E43*12)/D43) >E43:" ....... >D43:" ....... >C4350:+A49+1 >F49:/F$100*((E49*12)/D49) >E49:" ....... >D49:" ....... >C49:"FUNDS >B49:"OTHER MM >A49:+A48+1 >F48:/F$100*((E48*12)/D48) >E48:" ....... >D48:" ....... >C48:" PURCH >B48:"FED FUNDS >A48:+A47+1 >A47:+A46+1 >F46:" ======== >E46:" -------- >D46$&'()*+,C53:"OF FUNDS >B53:"TTL COST >A53:+A52+1 >F52:" ======== >E52:" -------- >D52:" -------- >A52:+A51+1 >F51:/F$100*((E51*12)/D51) >E51:@SUM(E47...E50 >D51:@SUM(D47...D50 >C51:"NDS >B51:"TTL MM FU >A51:+A50+1 >F50:" -------- >E50:" -------- >D50:" -------- >A>F56:/-= >E56:/-= >D56:/-= >C56:/-= >B56:/-= >A56:+A55+1 >F55:/F$(1200*(E32-E53))/D32 >C55:"ARGIN >B55:"NET INT M >A55:+A54+1 >F54:/F$" ========= >E54:" ======== >D54:" ======== >A54:+A53+1 >F53:/F$100*((E53*12)/D53) >E53:@SUM(E45,E51) >D53:@SUM(D45,D51) > K >J2:" J >I2:+I1+1 >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >I1:1 >E1:"S >D1:"SIS OF YIELD >C1:"RIANCE ANALY >B1:"MODEL 1 - VA >A1:1 /W1 /GOC /GRM /GC12 /X>A1:>A1: >K3:"============= >J3:"============ >I3:+I2+1 >H3:"============ >G3:"============= >F3:"============= >E3:"============= >D3:"============= >C3:"============= >B3:" ! >A3:+A2+1 >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" ! ---REPORT >I4:+I3+1 >H4:"--------- >G4:"------------ >F4:" SECTION---- >E4:" CALCULATION >D4:"TA ENTRY AND >C4:"----------DA >B4:" ! >A4:+A3+1 >Q3:"! >P3:"============= >O3:"============ >N3:"============= >M3:"============= >L3:"============ H5:"============= >G5:"============= >F5:"============ >E5:"============ >D5:"============ >C5:"============= >B5:"============= >A5:+A4+1 >Q4:"! >P4:"--------- >O4:"UR MTH ----- >N4:"XCEPT DAYS C >M4:" DATA HERE E >L4:"DO NOT ENTER >K4:" SECTION - >J4:"TH >G6:/FR"THIS MONTH >F6:/FR"LAST MONTH >E6:/FR"THIS MONTH >D6:/FR"LAST MONTH >C6:/FR"THIS MONTH >A6:+A5+1 >Q5:"! >P5:"============ >O5:"============ >N5:"============ >M5:"============ >L5:"============= >K5:"============= >J5:"!============ >I5:+I4+1 >"VARIANCE >I7:+I6+1 >H7:/FR"RATE >G7:/FR"RATE >F7:/FR"AVG VOLUME >E7:/FR"AVG VOLUME >D7:/FR" INCOME >C7:/FR" INCOME >B7:"ASSETS >A7:+A6+1 >P6:"TOTAL >O6:"# DAYS >N6:"VOLUME >M6:"RATE >L6:"AVG VOLUME >K6:"INCOME >J6:" TITLES >I6:+I5+1 >H6:/FR"LAST MOND40) >E40:" ....... >D40:" ....... >C40:"SSBOOK >B40:"GOLDEN PA >A40:+A39+1 >F39:/F$100*((E39*12)/D39) >E39:" ....... >D39:" ....... >C39:"AVINGS >B39:"REGULAR S >A39:+A38+1 >F38:/F$100*((E38*12)/D38) >E38:" ....... >D38:" ....... >C38:"MM >B38:"CERT DEP >A38:+A37+1 >F37:/F$100*((E37*12)/D37) >E37:" ....... >D37:" ....... >C37:"EPOSIT >B37:"CERT OF D >A37:+A36+1 >C36:"---- >B36:/-- >A36:+A35+1 >C35:"UNDS >B35:"COST OF F >A35:+A34+1 >A34:+A33+1 >F33:" ======== >E33:" ======== >D33:" ======== >A33:+A3GAP TO >A47:+A46+1 >I46:+I45+1 >A46:+A45+1 >I45:+I44+1 >F45:/F$+D37/L37*100 >E45:/F$"........... >D45:"ITIES >C45:"TIVE LIABIL >B45:" SENSI >A45:+A44+1 >I44:+I43+1 >D44:"ETS TO RATE >C44:"NSITIVE ASS >B44:" RATE SE >A44:+A43+1 >I43:+I42+1 >F43:"==-/0123456789:;I49+1 >A50:+A49+1 >I49:+I48+1 >F49:/F$(D37-L37)/O32*100 >E49:/F$"........... >D49:"TAL >C49:" TOTAL CAPI >B49:" GAP TO >A49:+A48+1 >I48:+I47+1 >A48:+A47+1 >I47:+I46+1 >F47:/F$(D37-L37)/G37*100 >E47:/F$"........... >D47:"TS >C47:" TOTAL ASSE >B47:" >I53:+I52+1 >F53:/FI+L37+M37 >E53:/FI"........... >D53:"LIABILITIES >C53:"ST BEARING >B53:" INTERE >A53:+A52+1 >I52:+I51+1 >A52:+A51+1 >I51:+I50+1 >F51:/FI+D37+E37 >E51:/FI"........... >D51:"ASSETS >C51:"ST EARNING >B51:" INTERE >A51:+A50+1 >I50:+ >A6:+A5+1 >A5:+A4+1 >F4:/FR >E4:"......... >D4:"......... >C4:"DATE >A4:+A3+1 >A3:+A2+1 >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >D1:"MMARY >C1:" YIELD SU >B1:"MODEL 2 - >A1:1 /W1 /GOC /GRM /GFI /GC9 /X>A1:>A1: +1 >D10:/FR >C10:"ASSETS >B10:"INT EARN >A10:+A9+1 >F9:/-= >E9:/-= >D9:/-= >C9:/-= >B9:/-= >A9:+A8+1 >F8:/FR"RATE >E8:/FR"THIS MO >D8:/FR"THIS MO >C8:"MITTED) >B8:" ($000 O >A8:+A7+1 >F7:/FR"AVERAGE >E7:/FR"INTEREST >D7:/FR"AVE BAL >B7:"CATEGORY >A7:+A6+1IES >B14:"OTHER SEC >A14:+A13+1 >F13:/F$100*((E13*12)/D13) >E13:" ....... >D13:" ....... >C13:"GENCIES >B13:"US GOVT A >A13:+A12+1 >F12:/F$100*((E12*12)/D12) >E12:" ....... >D12:" ....... >C12:"RY >B12:"US TREASU >A12:+A11+1 >C11:/-- >B11:/-- >A11:+A107:"TOTAL SEC >A17:+A16+1 >F16:" -------- >E16:" -------- >D16:" -------- >A16:+A15+1 >F15:/F$100*((E15*12)/D15) >E15:" ....... >D15:" ....... >C15:"INVEST'S >B15:"MISC SEC& >A15:+A14+1 >F14:/F$100*((E14*12)/D14) >E14:" ....... >D14:" ....... >C14:"URIT >A21:+A20+1 >F20:/F$100*((E20*12)/D20) >E20:" ....... >D20:" ....... >B20:"MORTGAGES >A20:+A19+1 >A19:+A18+1 >F18:" ======== >E18:" -------- >D18:" -------- >A18:+A17+1 >F17:/F$100*((E17*12)/D17) >E17:@SUM(E11...E16 >D17:@SUM(D11...D16 >C17:"URITIES >B13) >E23:" ....... >D23:" ....... >C23:"L >B23:"COMMERCIA >A23:+A22+1 >F22:/F$100*((E22*12)/D22) >E22:" ....... >D22:" ....... >C22:"INSTLM'T >B22:"DISCOUNT >A22:+A21+1 >F21:/F$100*((E21*12)/D21) >E21:" ....... >D21:" ....... >C21:"DIT >B21:"CHECK CRE...... >D26:" ....... >B26:"LOAN FEES >A26:+A25+1 >F25:/F$100*((E25*12)/D25) >E25:" ....... >D25:" ....... >C25:"OANS >B25:"STUDENT L >A25:+A24+1 >F24:/F$100*((E24*12)/D24) >E24:" ....... >D24:" ....... >B24:"LEASE >A24:+A23+1 >F23:/F$100*((E23*12)/D2OTHER RE >A30:+A29+1 >F29:" ======== >E29:" -------- >D29:" -------- >A29:+A28+1 >F28:/F$100*((E28*12)/D28) >E28:@SUM(E19...E27 >D28:@SUM(D19...D27 >A28:+A27+1 >F27:" -------- >E27:" -------- >D27:" -------- >A27:+A26+1 >F26:/F$100*((E26*12)/D26) >E26:" .2+1 >F32:/F$100*((E32*12)/D32) >E32:@SUM(E17,E28,E30) >D32:@SUM(D17,D28,D30) >C32:"EARN ASS >B32:"YIELD ON >A32:+A31+1 >F31:" ======== >E31:" -------- >D31:" -------- >A31:+A30+1 >F30:/F$100*((E30*12)/D30) >E30:" ....... >D30:" ....... >C30:"OWNED >B30:"========= >E43:"========== >A43:+A42+1 >I42:+I41+1 >F42:"THIS MONTH >E42:"LAST MONTH >B42:"SUMMARY >A42:+A41+1 >I41:+I40+1 >A41:+A40+1 >I40:+I39+1 >A40:+A39+1 >I39:+I38+1 >A39:+A38+1 >I38:+I37+1 >G38:" ========= >F38:" ========= >E38:" ========= >D38:" ========== >A38:+A37+1 >O37:/FI+O24+O32 >N37:/FI+N24+N32 >M37:/FI+M24+M32 >L37:/FI+L24+L32 >K37:"L >J37:" CAPITA >I37:+I36+1 >G37:/FI+G13+G20+G32+G34 >F37:/FI+F13+F20+F32+F34 >E37:/FI+E13+E20+E32+E34 >D37:/FI+D13+D20+D32+D34 >C37:"S >B37:"TOTAL ASSET >....... >D17:/FI" ......... >C17:"NMENT >B17:" US GOVER >A17:+A16+1 >O16:/FI+L16+M16+N16 >N16:/FI" ......... >M16:/FI" ......... >L16:/FI" ......... >K16:"UNDS >J16:" PUBLIC F >I16:+I15+1 >C16:"------------ >B16:"------------ >A16:+A15+1 >O15:/FI+L15+M8:" STATE AN >A18:+A17+1 >O17:/FI+O11+O12+O13+O14+O15+O16 >N17:/FI+N11+N12+N13+N14+N15+N16 >M17:/FI+M11+M12+M13+M14+M15+M16 >L17:/FI+L11+L12+L13+L14+L15+L16 >K17:"DEPOSITS >J17:"TOTAL TIME >I17:+I16+1 >G17:/FI+D17+E17+F17 >F17:/FI" ......... >E17:/FI" .. ......... >C19:"ES >B19:" CORPORAT >A19:+A18+1 >O18:/FI+O9+O17 >N18:/FI+N9+N17 >M18:/FI+M9+M17 >L18:/FI+L9+L17 >K18:"ITS >J18:"TOTAL DEPOS >I18:+I17+1 >G18:/FI+D18+E18+F18 >F18:/FI" ......... >E18:/FI" ......... >D18:/FI" ......... >C18:"D MUNICIPAL >B1FI" ......... >K20:"WED MONEY >J20:"OTHER BORRO >I20:+I19+1 >G20:/FI+G17+G18+G19 >F20:/FI+F17+F18+F19 >E20:/FI+E17+E18+E19 >D20:/FI+D17+D18+D19 >B20:"TOTAL BONDS >A20:+A19+1 >I19:+I18+1 >G19:/FI+D19+E19+F19 >F19:/FI" ......... >E19:/FI" ......... >D19:/FI"FI >D22:/FI >C22:"ISCOUNTS >B22:"LOANS AND D >A22:+A21+1 >O21:/FI+L21+M21+N21 >N21:/FI" ......... >M21:/FI" ......... >L21:/FI" ......... >K21:"ES >J21:"CAPITAL NOT >I21:+I20+1 >A21:+A20+1 >O20:/FI+L20+M20+N20 >N20:/FI" ......... >M20:/FI" ......... >L20:/A >A24:+A23+1 >I23:+I22+1 >G23:/FI >F23:/FI >E23:/FI >D23:/FI >C23:"--------- >B23:"----------- >A23:+A22+1 >O22:/FI+L22+M22+N22 >N22:/FI" ......... >M22:/FI" ......... >L22:/FI" ......... >K22:"LITIES >J22:"OTHER LIABI >I22:+I21+1 >G22:/FI >F22:/FI >E22:/+1 >O24:/FI+O18+O20+O21+O22 >N24:/FI+N18+N20+N21+N22 >M24:/FI+M18+M20+M21+M22 >L24:/FI+L18+L20+L21+L22 >K24:"ABILITIES >J24:" TOTAL LI >I24:+I23+1 >G24:/FI+D24+E24+F24 >F24:/FI" ......... >E24:/FI" ......... >D24:/FI" .......... >C24:"NS >B24:" TERM LO>G26:/FI+D26+E26+F26 >F26:/FI" ......... >E26:/FI" ......... >D26:/FI" .......... >C26:"ENT >B26:" INSTALLM >A26:+A25+1 >I25:+I24+1 >G25:/FI+D25+E25+F25 >F25:/FI" ......... >E25:/FI" ......... >D25:/FI" .......... >C25:" LOANS >B25:" NON-TERM >A25:+A24T >A28:+A27+1 >I27:+I26+1 >G27:/FI+D27+E27+F27 >F27:/FI" ......... >E27:/FI" ......... >D27:/FI" .......... >B27:" STUDENT >A27:+A26+1 >O26:/FI+L26+M26+N26 >N26:/FI" ......... >M26:/FI" ......... >L26:/FI" ......... >K26:"K >J26:"COMMON STOC >I26:+I25+1 . >C29:"TS >B29:" OVERDRAF >A29:+A28+1 >O28:/FI+L28+M28+N28 >N28:/FI" ......... >M28:/FI" ......... >L28:/FI" ......... >J28:"SURPLUS >I28:+I27+1 >G28:/FI+D28+E28+F28 >F28:/FI" ......... >E28:/FI" ......... >D28:/FI" .......... >C28:"ATE >B28:" REAL ES1 >G30:/FI+G24+G25+G26+G27+G28+G29 >F30:/FI+F24+F25+F26+F27+F28+F29 >E30:/FI+E24+E25+E26+E27+E28+E29 >D30:/FI+D24+D25+D26+D27+D28+D29 >B30:"TOTAL LOANS >A30:+A29+1 >I29:+I28+1 >G29:/FI+D29+E29+F29 >F29:/FI" ......... >E29:/FI" ......... >D29:/FI" .........30+1 >G31:/FI+D31+E31+F31 >F31:/FI" ......... >E31:/FI" ......... >D31:/FI" .......... >C31:"LOAN LOSSES >B31:" RESERVE >A31:+A30+1 >O30:/FI+L30+M30+N30 >N30:/FI" ......... >M30:/FI" ......... >L30:/FI" ......... >K30:"ROFITS >J30:"UNDIVIDED P >I30:+I29+33:/FI >D33:/FI >A33:+A32+1 >O32:/FI+O26+O28+O30 >N32:/FI+N26+N28+N30 >M32:/FI+M26+M28+M30 >L32:/FI+L26+L28+L30 >K32:"ITAL >J32:" TOTAL CAP >I32:+I31+1 >G32:/FI+G30+G31 >F32:/FI+F30+F31 >E32:/FI+E30+E31 >D32:/FI+D30+D31 >B32:"NET LOANS >A32:+A31+1 >I31:+IA37:+A36+1 >K36:"LITIES & >J36:"TOTAL LIABI >I36:+I35+1 >A36:+A35+1 >I35:+I34+1 >A35:+A34+1 >I34:+I33+1 >G34:/FI+D34+E34+F34 >F34:/FI" ......... >E34:/FI" ......... >D34:/FI" .......... >C34:"S >B34:"OTHER ASSET >A34:+A33+1 >I33:+I32+1 >G33:/FI >F33:/FI >E15+N15 >N15:/FI" ......... >M15:/FI" ......... >L15:/FI" ......... >J15:" OTHER CD >I15:+I14+1 >C15:"ECURITIES >B15:"BONDS AND S >A15:+A14+1 >O14:/FI+L14+M14+N14 >N14:/FI" ......... >M14:/FI" ......... >L14:/FI" ......... >J14:" T-CD >I14:+I13+1 >A14:+A13+1 >O13:/FI+L13+M13+N13 >N13:/FI" ......... >M13:/FI" ......... >L13:/FI" ......... >J13:" NOW >I13:+I12+1 >G13:/FI+G10+G11+G12 >F13:/FI+F10+F11+F12 >E13:/FI+E10+E11+E12 >D13:/FI+D10+D11+D12 >C13:"& DUE FROM >B13:"TOTAL CASH >A13:+A12+1 >O12:/FI+L12+M:/F$@IF((B67+1)>D6,@NA,+C67-G67) >B68:@IF((B67+1)>D6,@NA,B67+1) >A68:+A67+1 >H67:/F$@IF((B66+1)>D6,@NA,+365/12) >G67:/F$@IF((B66+1)>D6,@NA,+E67-F67) >F67:/F$@IF((B66+1)>D6,@NA,(((C67*(D67/100))/365)*H67)) >E67:/F$@IF((B66+1)>D6,@NA,+E66) >D67:/F$@IF((B66+1@NA,+C68-G68) >B69:@IF((B68+1)>D6,@NA,B68+1) >A69:+A68+1 >H68:/F$@IF((B67+1)>D6,@NA,+365/12) >G68:/F$@IF((B67+1)>D6,@NA,+E68-F68) >F68:/F$@IF((B67+1)>D6,@NA,(((C68*(D68/100))/365)*H68)) >E68:/F$@IF((B67+1)>D6,@NA,+E67) >D68:/F$@IF((B67+1)>D6,@NA,+D67) >C68@IF((B69+1)>D6,@NA,B69+1) >A70:+A69+1 >H69:/F$@IF((B68+1)>D6,@NA,+365/12) >G69:/F$@IF((B68+1)>D6,@NA,+E69-F69) >F69:/F$@IF((B68+1)>D6,@NA,(((C69*(D69/100))/365)*H69)) >E69:/F$@IF((B68+1)>D6,@NA,+E68) >D69:/F$@IF((B68+1)>D6,@NA,+D68) >C69:/F$@IF((B68+1)>D6,<>?@ABCDEFGHIJKLMNOPQRSTUVWXYZB70+1) >A71:+A70+1 >H70:/F$@IF((B69+1)>D6,@NA,+365/12) >G70:/F$@IF((B69+1)>D6,@NA,+E70-F70) >F70:/F$@IF((B69+1)>D6,@NA,(((C70*(D70/100))/365)*H70)) >E70:/F$@IF((B69+1)>D6,@NA,+E69) >D70:/F$@IF((B69+1)>D6,@NA,+D69) >C70:/F$@IF((B69+1)>D6,@NA,+C69-G69) >B70:>H71:/F$@IF((B70+1)>D6,@NA,+365/12) >G71:/F$@IF((B70+1)>D6,@NA,+E71-F71) >F71:/F$@IF((B70+1)>D6,@NA,(((C71*(D71/100))/365)*H71)) >E71:/F$@IF((B70+1)>D6,@NA,+E70) >D71:/F$@IF((B70+1)>D6,@NA,+D70) >C71:/F$@IF((B70+1)>D6,@NA,+C70-G70) >B71:@IF((B70+1)>D6,@NA,I2:+I1+1 >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >I1:1 >F1:"TION >E1:"NT OF CONDI >D1:"IVE STATEME >C1:"RATE SENSIT >B1:"MODEL 3 - >A1:1 /W1 /GOC /GRM /GC11 /X>A1:>A1: 5:+A4+1 >N4:" NON >M4:" FIXED >L4:" RATE >I4:+I3+1 >F4:" NON >E4:" FIXED >D4:" RATE >A4:+A3+1 >I3:+I2+1 >G3:"........... >F3:/FR" .......... >E3:" AS OF >A3:+A2+1 >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >= >E6:" ========= >D6:" ========= >C6:"=========== >B6:"=========== >A6:+A5+1 >O5:" TOTAL >N5:" PAYING >M5:" RATE >L5:" SENSITIVE >K5:" & CAPITAL >J5:"LIABILITIES >I5:+I4+1 >G5:" TOTAL >F5:" EARNING >E5:" RATE >D5:" SENSITIVE >B5:"ASSETS >A-- >B9:"------------ >A9:+A8+1 >J8:"DEPOSITS >I8:+I7+1 >C8:"FROM BANKS >B8:"CASH & DUE >A8:+A7+1 >I7:+I6+1 >A7:+A6+1 >O6:" ========= >N6:" ========= >M6:" ========= >L6:" ========= >K6:"=========== >J6:"=========== >I6:+I5+1 >G6:" ========= >F6:" ========TS >J10:"TIME DEPOSI >I10:+I9+1 >G10:/FI+D10+E10+F10 >F10:/FI" .......... >E10:/FI" ......... >D10:/FI" ......... >B10:" ON HAND >A10:+A9+1 >O9:/FI+L9+M9+N9 >N9:/FI" ......... >M9:/FI" ......... >L9:/FI" ......... >J9:" DEMAND >I9:+I8+1 >C9:"----------..... >M11:/FI" ......... >L11:/FI" ......... >K11:" OTHER >J11:" SAVING & >I11:+I10+1 >G11:/FI+D11+E11+F11 >F11:/FI" .......... >E11:/FI" ......... >D11:/FI" ......... >C11:" BANKS >B11:" DUE FROM >A11:+A10+1 >O10:/FI >N10:/FI >M10:/FI >L10:/FI >K10:"12+N12 >N12:/FI" ......... >M12:/FI" ......... >L12:/FI" ......... >J12:" IRA >I12:+I11+1 >G12:/FI+D12+E12+F12 >F12:/FI" ........... >E12:/FI" ......... >D12:/FI" ......... >C12:"FUNDS SOLD >B12:" FEDERAL >A12:+A11+1 >O11:/FI+L11+M11+N11 >N11:/FI" ....)>D6,@NA,+D66) >C67:/F$@IF((B66+1)>D6,@NA,+C66-G66) >B67:@IF((B66+1)>D6,@NA,B66+1) >A67:+A66+1 >H66:/F$@IF((B65+1)>D6,@NA,+365/12) >G66:/F$@IF((B65+1)>D6,@NA,+E66-F66) >F66:/F$@IF((B65+1)>D6,@NA,(((C66*(D66/100))/365)*H66)) >E66:/F$@IF((B65+1)>D6,@NA,+E65) >D66:/F$@IF((B65+1)>D6,@NA,+D65) >C66:/F$@IF((B65+1)>D6,@NA,+C65-G65) >B66:@IF((B65+1)>D6,@NA,B65+1) >A66:+A65+1 >H65:/F$@IF((B64+1)>D6,@NA,+365/12) >G65:/F$@IF((B64+1)>D6,@NA,+E65-F65) >F65:/F$@IF((B64+1)>D6,@NA,(((C65*(D65/100))/365)*H65)) >E65:/F$@IF((@IF((B52+1)>D6,@NA,+D52) >C53:/F$@IF((B52+1)>D6,@NA,+C52-G52) >B53:@IF((B52+1)>D6,@NA,B52+1) >A53:+A52+1 >H52:/F$@IF((B51+1)>D6,@NA,+365/12) >G52:/F$@IF((B51+1)>D6,@NA,+E52-F52) >F52:/F$@IF((B51+1)>D6,@NA,(((C52*(D52/100))/365)*H52)) >E52:/F$@IF((B51+1)>D6+D53) >C54:/F$@IF((B53+1)>D6,@NA,+C53-G53) >B54:@IF((B53+1)>D6,@NA,B53+1) >A54:+A53+1 >H53:/F$@IF((B52+1)>D6,@NA,+365/12) >G53:/F$@IF((B52+1)>D6,@NA,+E53-F53) >F53:/F$@IF((B52+1)>D6,@NA,(((C53*(D53/100))/365)*H53)) >E53:/F$@IF((B52+1)>D6,@NA,+E52) >D53:/F$B54+1)>D6,@NA,+C54-G54) >B55:@IF((B54+1)>D6,@NA,B54+1) >A55:+A54+1 >H54:/F$@IF((B53+1)>D6,@NA,+365/12) >G54:/F$@IF((B53+1)>D6,@NA,+E54-F54) >F54:/F$@IF((B53+1)>D6,@NA,(((C54*(D54/100))/365)*H54)) >E54:/F$@IF((B53+1)>D6,@NA,+E53) >D54:/F$@IF((B53+1)>D6,@NA,G55) >B56:@IF((B55+1)>D6,@NA,B55+1) >A56:+A55+1 >H55:/F$@IF((B54+1)>D6,@NA,+365/12) >G55:/F$@IF((B54+1)>D6,@NA,+E55-F55) >F55:/F$@IF((B54+1)>D6,@NA,(((C55*(D55/100))/365)*H55)) >E55:/F$@IF((B54+1)>D6,@NA,+E54) >D55:/F$@IF((B54+1)>D6,@NA,+D54) >C55:/F$@IF((1)>D6,@NA,B56+1) >A57:+A56+1 >H56:/F$@IF((B55+1)>D6,@NA,+365/12) >G56:/F$@IF((B55+1)>D6,@NA,+E56-F56) >F56:/F$@IF((B55+1)>D6,@NA,(((C56*(D56/100))/365)*H56)) >E56:/F$@IF((B55+1)>D6,@NA,+E55) >D56:/F$@IF((B55+1)>D6,@NA,+D55) >C56:/F$@IF((B55+1)>D6,@NA,+C55-58:+A57+1 >H57:/F$@IF((B56+1)>D6,@NA,+365/12) >G57:/F$@IF((B56+1)>D6,@NA,+E57-F57) >F57:/F$@IF((B56+1)>D6,@NA,(((C57*(D57/100))/365)*H57)) >E57:/F$@IF((B56+1)>D6,@NA,+E56) >D57:/F$@IF((B56+1)>D6,@NA,+D56) >C57:/F$@IF((B56+1)>D6,@NA,+C56-G56) >B57:@IF((B56+IF((B57+1)>D6,@NA,+365/12) >G58:/F$@IF((B57+1)>D6,@NA,+E58-F58) >F58:/F$@IF((B57+1)>D6,@NA,(((C58*(D58/100))/365)*H58)) >E58:/F$@IF((B57+1)>D6,@NA,+E57) >D58:/F$@IF((B57+1)>D6,@NA,+D57) >C58:/F$@IF((B57+1)>D6,@NA,+C57-G57) >B58:@IF((B57+1)>D6,@NA,B57+1) >A365/12) >G59:/F$@IF((B58+1)>D6,@NA,+E59-F59) >F59:/F$@IF((B58+1)>D6,@NA,(((C59*(D59/100))/365)*H59)) >E59:/F$@IF((B58+1)>D6,@NA,+E58) >D59:/F$@IF((B58+1)>D6,@NA,+D58) >C59:/F$@IF((B58+1)>D6,@NA,+C58-G58) >B59:@IF((B58+1)>D6,@NA,B58+1) >A59:+A58+1 >H58:/F$@((B59+1)>D6,@NA,+E60-F60) >F60:/F$@IF((B59+1)>D6,@NA,(((C60*(D60/100))/365)*H60)) >E60:/F$@IF((B59+1)>D6,@NA,+E59) >D60:/F$@IF((B59+1)>D6,@NA,+D59) >C60:/F$@IF((B59+1)>D6,@NA,+C59-G59) >B60:@IF((B59+1)>D6,@NA,B59+1) >A60:+A59+1 >H59:/F$@IF((B58+1)>D6,@NA,+1-F61) >F61:/F$@IF((B60+1)>D6,@NA,(((C61*(D61/100))/365)*H61)) >E61:/F$@IF((B60+1)>D6,@NA,+E60) >D61:/F$@IF((B60+1)>D6,@NA,+D60) >C61:/F$@IF((B60+1)>D6,@NA,+C60-G60) >B61:@IF((B60+1)>D6,@NA,B60+1) >A61:+A60+1 >H60:/F$@IF((B59+1)>D6,@NA,+365/12) >G60:/F$@IF(B61+1)>D6,@NA,(((C62*(D62/100))/365)*H62)) >E62:/F$@IF((B61+1)>D6,@NA,+E61) >D62:/F$@IF((B61+1)>D6,@NA,+D61) >C62:/F$@IF((B61+1)>D6,@NA,+C61-G61) >B62:@IF((B61+1)>D6,@NA,B61+1) >A62:+A61+1 >H61:/F$@IF((B60+1)>D6,@NA,+365/12) >G61:/F$@IF((B60+1)>D6,@NA,+E663*(D63/100))/365)*H63)) >E63:/F$@IF((B62+1)>D6,@NA,+E62) >D63:/F$@IF((B62+1)>D6,@NA,+D62) >C63:/F$@IF((B62+1)>D6,@NA,+C62-G62) >B63:@IF((B62+1)>D6,@NA,B62+1) >A63:+A62+1 >H62:/F$@IF((B61+1)>D6,@NA,+365/12) >G62:/F$@IF((B61+1)>D6,@NA,+E62-F62) >F62:/F$@IF(H64)) >E64:/F$@IF((B63+1)>D6,@NA,+E63) >D64:/F$@IF((B63+1)>D6,@NA,+D63) >C64:/F$@IF((B63+1)>D6,@NA,+C63-G63) >B64:@IF((B63+1)>D6,@NA,B63+1) >A64:+A63+1 >H63:/F$@IF((B62+1)>D6,@NA,+365/12) >G63:/F$@IF((B62+1)>D6,@NA,+E63-F63) >F63:/F$@IF((B62+1)>D6,@NA,(((CB64+1)>D6,@NA,+E64) >D65:/F$@IF((B64+1)>D6,@NA,+D64) >C65:/F$@IF((B64+1)>D6,@NA,+C64-G64) >B65:@IF((B64+1)>D6,@NA,B64+1) >A65:+A64+1 >H64:/F$@IF((B63+1)>D6,@NA,+365/12) >G64:/F$@IF((B63+1)>D6,@NA,+E64-F64) >F64:/F$@IF((B63+1)>D6,@NA,(((C64*(D64/100))/365)*,@NA,+E51) >D52:/F$@IF((B51+1)>D6,@NA,+D51) >C52:/F$@IF((B51+1)>D6,@NA,+C51-G51) >B52:@IF((B51+1)>D6,@NA,B51+1) >A52:+A51+1 >H51:/F$@IF((B50+1)>D6,@NA,+365/12) >G51:/F$@IF((B50+1)>D6,@NA,+E51-F51) >F51:/F$@IF((B50+1)>D6,@NA,(((C51*(D51/100))/365)*H51)) >E51:/F$@IF((B50+1)>D6,@NA,+E50) >D51:/F$@IF((B50+1)>D6,@NA,+D50) >C51:/F$@IF((B50+1)>D6,@NA,+C50-G50) >B51:@IF((B50+1)>D6,@NA,B50+1) >A51:+A50+1 >H50:/F$@IF((B49+1)>D6,@NA,+365/12) >G50:/F$@IF((B49+1)>D6,@NA,+E50-F50) >F50:/F$@IF((B49+1)>D6,@NA,(((C50*(D50/1(B37+1)>D6,@NA,+E37) >D38:/F$@IF((B37+1)>D6,@NA,+D37) >C38:/F$@IF((B37+1)>D6,@NA,+C37-G37) >B38:@IF((B37+1)>D6,@NA,B37+1) >A38:+A37+1 >H37:/F$@IF((B36+1)>D6,@NA,+365/12) >G37:/F$@IF((B36+1)>D6,@NA,+E37-F37) >F37:/F$@IF((B36+1)>D6,@NA,(((C37*(D37/100))/365)) >D39:/F$@IF((B38+1)>D6,@NA,+D38) >C39:/F$@IF((B38+1)>D6,@NA,+C38-G38) >B39:@IF((B38+1)>D6,@NA,B38+1) >A39:+A38+1 >H38:/F$@IF((B37+1)>D6,@NA,+365/12) >G38:/F$@IF((B37+1)>D6,@NA,+E38-F38) >F38:/F$@IF((B37+1)>D6,@NA,(((C38*(D38/100))/365)*H38)) >E38:/F$@IF(1)>D6,@NA,+D39) >C40:/F$@IF((B39+1)>D6,@NA,+C39-G39) >B40:@IF((B39+1)>D6,@NA,B39+1) >A40:+A39+1 >H39:/F$@IF((B38+1)>D6,@NA,+365/12) >G39:/F$@IF((B38+1)>D6,@NA,+E39-F39) >F39:/F$@IF((B38+1)>D6,@NA,(((C39*(D39/100))/365)*H39)) >E39:/F$@IF((B38+1)>D6,@NA,+E381:/F$@IF((B40+1)>D6,@NA,+C40-G40) >B41:@IF((B40+1)>D6,@NA,B40+1) >A41:+A40+1 >H40:/F$@IF((B39+1)>D6,@NA,+365/12) >G40:/F$@IF((B39+1)>D6,@NA,+E40-F40) >F40:/F$@IF((B39+1)>D6,@NA,(((C40*(D40/100))/365)*H40)) >E40:/F$@IF((B39+1)>D6,@NA,+E39) >D40:/F$@IF((B39+,@NA,+C41-G41) >B42:@IF((B41+1)>D6,@NA,B41+1) >A42:+A41+1 >H41:/F$@IF((B40+1)>D6,@NA,+365/12) >G41:/F$@IF((B40+1)>D6,@NA,+E41-F41) >F41:/F$@IF((B40+1)>D6,@NA,(((C41*(D41/100))/365)*H41)) >E41:/F$@IF((B40+1)>D6,@NA,+E40) >D41:/F$@IF((B40+1)>D6,@NA,+D40) >C4:@IF((B42+1)>D6,@NA,B42+1) >A43:+A42+1 >H42:/F$@IF((B41+1)>D6,@NA,+365/12) >G42:/F$@IF((B41+1)>D6,@NA,+E42-F42) >F42:/F$@IF((B41+1)>D6,@NA,(((C42*(D42/100))/365)*H42)) >E42:/F$@IF((B41+1)>D6,@NA,+E41) >D42:/F$@IF((B41+1)>D6,@NA,+D41) >C42:/F$@IF((B41+1)>D6,B43+1) >A44:+A43+1 >H43:/F$@IF((B42+1)>D6,@NA,+365/12) >G43:/F$@IF((B42+1)>D6,@NA,+E43-F43) >F43:/F$@IF((B42+1)>D6,@NA,(((C43*(D43/100))/365)*H43)) >E43:/F$@IF((B42+1)>D6,@NA,+E42) >D43:/F$@IF((B42+1)>D6,@NA,+D42) >C43:/F$@IF((B42+1)>D6,@NA,+C42-G42) >B43 >H44:/F$@IF((B43+1)>D6,@NA,+365/12) >G44:/F$@IF((B43+1)>D6,@NA,+E44-F44) >F44:/F$@IF((B43+1)>D6,@NA,(((C44*(D44/100))/365)*H44)) >E44:/F$@IF((B43+1)>D6,@NA,+E43) >D44:/F$@IF((B43+1)>D6,@NA,+D43) >C44:/F$@IF((B43+1)>D6,@NA,+C43-G43) >B44:@IF((B43+1)>D6,@NA)>D6,@NA,+365/12) >G45:/F$@IF((B44+1)>D6,@NA,+E45-F45) >F45:/F$@IF((B44+1)>D6,@NA,(((C45*(D45/100))/365)*H45)) >E45:/F$@IF((B44+1)>D6,@NA,+E44) >D45:/F$@IF((B44+1)>D6,@NA,+D44) >C45:/F$@IF((B44+1)>D6,@NA,+C44-G44) >B45:@IF((B44+1)>D6,@NA,B44+1) >A45:+A44+1G46:/F$@IF((B45+1)>D6,@NA,+E46-F46) >F46:/F$@IF((B45+1)>D6,@NA,(((C46*(D46/100))/365)*H46)) >E46:/F$@IF((B45+1)>D6,@NA,+E45) >D46:/F$@IF((B45+1)>D6,@NA,+D45) >C46:/F$@IF((B45+1)>D6,@NA,+C45-G45) >B46:@IF((B45+1)>D6,@NA,B45+1) >A46:+A45+1 >H45:/F$@IF((B44+1D6,@NA,+E47-F47) >F47:/F$@IF((B46+1)>D6,@NA,(((C47*(D47/100))/365)*H47)) >E47:/F$@IF((B46+1)>D6,@NA,+E46) >D47:/F$@IF((B46+1)>D6,@NA,+D46) >C47:/F$@IF((B46+1)>D6,@NA,+C46-G46) >B47:@IF((B46+1)>D6,@NA,B46+1) >A47:+A46+1 >H46:/F$@IF((B45+1)>D6,@NA,+365/12) >48:/F$@IF((B47+1)>D6,@NA,(((C48*(D48/100))/365)*H48)) >E48:/F$@IF((B47+1)>D6,@NA,+E47) >D48:/F$@IF((B47+1)>D6,@NA,+D47) >C48:/F$@IF((B47+1)>D6,@NA,+C47-G47) >B48:@IF((B47+1)>D6,@NA,B47+1) >A48:+A47+1 >H47:/F$@IF((B46+1)>D6,@NA,+365/12) >G47:/F$@IF((B46+1)>6,@NA,(((C49*(D49/100))/365)*H49)) >E49:/F$@IF((B48+1)>D6,@NA,+E48) >D49:/F$@IF((B48+1)>D6,@NA,+D48) >C49:/F$@IF((B48+1)>D6,@NA,+C48-G48) >B49:@IF((B48+1)>D6,@NA,B48+1) >A49:+A48+1 >H48:/F$@IF((B47+1)>D6,@NA,+365/12) >G48:/F$@IF((B47+1)>D6,@NA,+E48-F48) >F00))/365)*H50)) >E50:/F$@IF((B49+1)>D6,@NA,+E49) >D50:/F$@IF((B49+1)>D6,@NA,+D49) >C50:/F$@IF((B49+1)>D6,@NA,+C49-G49) >B50:@IF((B49+1)>D6,@NA,B49+1) >A50:+A49+1 >H49:/F$@IF((B48+1)>D6,@NA,+365/12) >G49:/F$@IF((B48+1)>D6,@NA,+E49-F49) >F49:/F$@IF((B48+1)>D*H37)) >E37:/F$@IF((B36+1)>D6,@NA,+E36) >D37:/F$@IF((B36+1)>D6,@NA,+D36) >C37:/F$@IF((B36+1)>D6,@NA,+C36-G36) >B37:@IF((B36+1)>D6,@NA,B36+1) >A37:+A36+1 >H36:/F$@IF((B35+1)>D6,@NA,+365/12) >G36:/F$@IF((B35+1)>D6,@NA,+E36-F36) >F36:/F$@IF((B35+1)>D6,@NA,(((C36*(D36/100))/365)*H36)) >E36:/F$@IF((B35+1)>D6,@NA,+E35) >D36:/F$@IF((B35+1)>D6,@NA,+D35) >C36:/F$@IF((B35+1)>D6,@NA,+C35-G35) >B36:@IF((B35+1)>D6,@NA,B35+1) >A36:+A35+1 >H35:/F$@IF((B34+1)>D6,@NA,+365/12) >G35:/F$@IF((B34+1)>D6,@NA,+E35-F35) >F35:/F$@IF100))/365)*H23)) >E23:/F$@IF((B22+1)>D6,@NA,+E22) >D23:/F$@IF((B22+1)>D6,@NA,+D22) >C23:/F$@IF((B22+1)>D6,@NA,+C22-G22) >B23:@IF((B22+1)>D6,@NA,B22+1) >A23:+A22+1 >H22:/F$365/12 >G22:/F$+E22-F22 >F22:/F$(((C22*(D22/100))/365)*H22) >E22:/F$+D15 >D22:/F$+D5*24:/F$@IF((B23+1)>D6,@NA,+E23) >D24:/F$@IF((B23+1)>D6,@NA,+D23) >C24:/F$@IF((B23+1)>D6,@NA,+C23-G23) >B24:@IF((B23+1)>D6,@NA,B23+1) >A24:+A23+1 >H23:/F$@IF((B22+1)>D6,@NA,+365/12) >G23:/F$@IF((B22+1)>D6,@NA,+E23-F23) >F23:/F$@IF((B22+1)>D6,@NA,(((C23*(D23/6,@NA,+E24) >D25:/F$@IF((B24+1)>D6,@NA,+D24) >C25:/F$@IF((B24+1)>D6,@NA,+C24-G24) >B25:@IF((B24+1)>D6,@NA,B24+1) >A25:+A24+1 >H24:/F$@IF((B23+1)>D6,@NA,+365/12) >G24:/F$@IF((B23+1)>D6,@NA,+E24-F24) >F24:/F$@IF((B23+1)>D6,@NA,(((C24*(D24/100))/365)*H24)) >E$@IF((B25+1)>D6,@NA,+D25) >C26:/F$@IF((B25+1)>D6,@NA,+C25-G25) >B26:@IF((B25+1)>D6,@NA,B25+1) >A26:+A25+1 >H25:/F$@IF((B24+1)>D6,@NA,+365/12) >G25:/F$@IF((B24+1)>D6,@NA,+E25-F25) >F25:/F$@IF((B24+1)>D6,@NA,(((C25*(D25/100))/365)*H25)) >E25:/F$@IF((B24+1)>D,+D26) >C27:/F$@IF((B26+1)>D6,@NA,+C26-G26) >B27:@IF((B26+1)>D6,@NA,B26+1) >A27:+A26+1 >H26:/F$@IF((B25+1)>D6,@NA,+365/12) >G26:/F$@IF((B25+1)>D6,@NA,+E26-F26) >F26:/F$@IF((B25+1)>D6,@NA,(((C26*(D26/100))/365)*H26)) >E26:/F$@IF((B25+1)>D6,@NA,+E25) >D26:/F(B27+1)>D6,@NA,+C27-G27) >B28:@IF((B27+1)>D6,@NA,B27+1) >A28:+A27+1 >H27:/F$@IF((B26+1)>D6,@NA,+365/12) >G27:/F$@IF((B26+1)>D6,@NA,+E27-F27) >F27:/F$@IF((B26+1)>D6,@NA,(((C27*(D27/100))/365)*H27)) >E27:/F$@IF((B26+1)>D6,@NA,+E26) >D27:/F$@IF((B26+1)>D6,@NA-G28) >B29:@IF((B28+1)>D6,@NA,B28+1) >A29:+A28+1 >H28:/F$@IF((B27+1)>D6,@NA,+365/12) >G28:/F$@IF((B27+1)>D6,@NA,+E28-F28) >F28:/F$@IF((B27+1)>D6,@NA,(((C28*(D28/100))/365)*H28)) >E28:/F$@IF((B27+1)>D6,@NA,+E27) >D28:/F$@IF((B27+1)>D6,@NA,+D27) >C28:/F$@IF(+1)>D6,@NA,B29+1) >A30:+A29+1 >H29:/F$@IF((B28+1)>D6,@NA,+365/12) >G29:/F$@IF((B28+1)>D6,@NA,+E29-F29) >F29:/F$@IF((B28+1)>D6,@NA,(((C29*(D29/100))/365)*H29)) >E29:/F$@IF((B28+1)>D6,@NA,+E28) >D29:/F$@IF((B28+1)>D6,@NA,+D28) >C29:/F$@IF((B28+1)>D6,@NA,+C28A31:+A30+1 >H30:/F$@IF((B29+1)>D6,@NA,+365/12) >G30:/F$@IF((B29+1)>D6,@NA,+E30-F30) >F30:/F$@IF((B29+1)>D6,@NA,(((C30*(D30/100))/365)*H30)) >E30:/F$@IF((B29+1)>D6,@NA,+E29) >D30:/F$@IF((B29+1)>D6,@NA,+D29) >C30:/F$@IF((B29+1)>D6,@NA,+C29-G29) >B30:@IF((B29@IF((B30+1)>D6,@NA,+365/12) >G31:/F$@IF((B30+1)>D6,@NA,+E31-F31) >F31:/F$@IF((B30+1)>D6,@NA,(((C31*(D31/100))/365)*H31)) >E31:/F$@IF((B30+1)>D6,@NA,+E30) >D31:/F$@IF((B30+1)>D6,@NA,+D30) >C31:/F$@IF((B30+1)>D6,@NA,+C30-G30) >B31:@IF((B30+1)>D6,@NA,B30+1) >+365/12) >G32:/F$@IF((B31+1)>D6,@NA,+E32-F32) >F32:/F$@IF((B31+1)>D6,@NA,(((C32*(D32/100))/365)*H32)) >E32:/F$@IF((B31+1)>D6,@NA,+E31) >D32:/F$@IF((B31+1)>D6,@NA,+D31) >C32:/F$@IF((B31+1)>D6,@NA,+C31-G31) >B32:@IF((B31+1)>D6,@NA,B31+1) >A32:+A31+1 >H31:/F$F((B32+1)>D6,@NA,+E33-F33) >F33:/F$@IF((B32+1)>D6,@NA,(((C33*(D33/100))/365)*H33)) >E33:/F$@IF((B32+1)>D6,@NA,+E32) >D33:/F$@IF((B32+1)>D6,@NA,+D32) >C33:/F$@IF((B32+1)>D6,@NA,+C32-G32) >B33:@IF((B32+1)>D6,@NA,B32+1) >A33:+A32+1 >H32:/F$@IF((B31+1)>D6,@NA,34-F34) >F34:/F$@IF((B33+1)>D6,@NA,(((C34*(D34/100))/365)*H34)) >E34:/F$@IF((B33+1)>D6,@NA,+E33) >D34:/F$@IF((B33+1)>D6,@NA,+D33) >C34:/F$@IF((B33+1)>D6,@NA,+C33-G33) >B34:@IF((B33+1)>D6,@NA,B33+1) >A34:+A33+1 >H33:/F$@IF((B32+1)>D6,@NA,+365/12) >G33:/F$@I((B34+1)>D6,@NA,(((C35*(D35/100))/365)*H35)) >E35:/F$@IF((B34+1)>D6,@NA,+E34) >D35:/F$@IF((B34+1)>D6,@NA,+D34) >C35:/F$@IF((B34+1)>D6,@NA,+C34-G34) >B35:@IF((B34+1)>D6,@NA,B34+1) >A35:+A34+1 >H34:/F$@IF((B33+1)>D6,@NA,+365/12) >G34:/F$@IF((B33+1)>D6,@NA,+E100 >C22:/F$+D7 >B22:1 >A22:+A21+1 >H21:"============= >G21:"============ >F21:"============ >E21:"============ >D21:"============ >C21:"============ >B21:"============ >A21:+A20+1 >H20:" ! PMT DAYS >G20:/FR" ! PRINCIPAL >F20:/FR" ! INTEREST >E20:/FR" ! PAYMENT >D20:/FR" ! INT RATE >C20:/FR" ! BALANCE >B20:/FR"MONTH >A20:+A19+1 >H19:"============= >G19:"============ >F19:"============ >E19:"============ >D19:"============ >C19:"============ >B19:"============ >A19:+A18+1 >H18:"------------ >G18:"-----.E68)>O8,0,+E67+1) >D68:/FL@IF(C68=0,0,@IF(C68=1,D67+1,D67)) >C68:@IF(@COUNT(C24...C68>O8,0,@IF(C67=12,1,C67+1)) >A68:+A67+1 >K67:/F$+F67-J67 >J67:/F$+H66-H67 >I67:/F$+G67-H67 >H67:/F$@IF(E67=0,0,@INT(((O8-E67)+1)*(O8-E67/2)/((O8+1)*(O8/2))*F18*100+.5)/1004...C69>O8,0,@IF(C68=12,1,C68+1)) >A69:+A68+1 >K68:/F$+F68-J68 >J68:/F$+H67-H68 >I68:/F$+G68-H68 >H68:/F$@IF(E68=0,0,@INT(((O8-E68)+1)*(O8-E68/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G68:/F$+G67-F68 >F68:/F$@IF(@COUNT(F24...F68)>O8,0,F14) >E68:@IF(@COUNT(E24.. >I69:/F$+G69-H69 >H69:/F$@IF(E69=0,0,@INT(((O8-E69)+1)*(O8-E69/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G69:/F$+G68-F69 >F69:/F$@IF(@COUNT(F24...F69)>O8,0,F14) >E69:@IF(@COUNT(E24...E69)>O8,0,+E68+1) >D69:/FL@IF(C69=0,0,@IF(C69=1,D68+1,D68)) >C69:@IF(@COUNT(C22))*F18*100+.5)/100 >G70:/F$+G69-F70 >F70:/F$@IF(@COUNT(F24...F70)>O8,0,F14) >E70:@IF(@COUNT(E24...E70)>O8,0,+E69+1) >D70:/FL@IF(C70=0,0,@IF(C70=1,D69+1,D69)) >C70:@IF(@COUNT(C24...C70>O8,0,@IF(C69=12,1,C69+1)) >A70:+A69+1 >K69:/F$+F69-J69 >J69:/F$+H68-H6971:@IF(@COUNT(E24...E71)>O8,0,+E70+1) >D71:/FL@IF(C71=0,0,@IF(C71=1,D70+1,D70)) >C71:@IF(@COUNT(C24...C71>O8,0,@IF(C70=12,1,C70+1)) >A71:+A70+1 >K70:/F$+F70-J70 >J70:/F$+H69-H70 >I70:/F$+G70-H70 >H70:/F$@IF(E70=0,0,@INT(((O8-E70)+1)*(O8-E70/2)/((O8+1)*(O8/[]^_`abcdefghijklmnopqrstuvwxyz{|}~--- >J72:/F$" --------- >F72:/F$" --------- >D72:/FL >A72:+A71+1 >K71:/F$+F71-J71 >J71:/F$+H70-H71 >I71:/F$+G71-H71 >H71:/F$@IF(E71=0,0,@INT(((O8-E71)+1)*(O8-E71/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G71:/F$+G70-F71 >F71:/F$@IF(@COUNT(F24...F71)>O8,0,F14) >E>F78:/F$ >D78:/FL >F77:/F$ >D77:/FL >F76:/F$ >D76:/FL >D75:/FL >K74:/F$" ========== >J74:/F$" ========== >F74:/F$" ========== >D74:/FL >A74:+A73+1 >K73:/F$@SUM(K24...K72) >J73:/F$@SUM(J24...J72) >F73:/F$@SUM(F24...F72) >D73:/FL >A73:+A72+1 >K72:/F$" -----------DATA EN >A4:+A3+1 >A3:+A2+1 >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >E1:"TIZATION >D1:"ST LOAN AMOR >C1:"IMPLE INTERE >B1:"MODEL 4 - S >A1:1 /W1 /GOR /GRM /GC12 /X>A1:>A1: ========== >B8:"============= >A8:+A7+1 >D7:" ......... >C7:"AN >B7:"AMOUNT OF LO >A7:+A6+1 >D6:" ......... >C6:" IN MONTHS >B6:"TERM OF LOAN >A6:+A5+1 >D5:" ......... >C5:"T RATE >B5:"LOAN INTERES >A5:+A4+1 >D4:"------------ >C4:"TRY SECTION- >B4:"CTOR >A14:+A13+1 >D13:1/(1+D12)^D6 >C13:"ONE EQUALS >B13:"LOAN FACTOR >A13:+A12+1 >D12:+D5/12 >C12:"REST RATE >B12:"MONTHLY INTE >A12:+A11+1 >A11:+A10+1 >D10:"------------ >C10:"D DATA------ >B10:"-----COMPUTE >A10:+A9+1 >A9:+A8+1 >D8:"============ >C8:"==------- >F18:"------------ >E18:"------------- >D18:"ON SCHEDULE- >C18:"--AMORTIZATI >B18:"------------ >A18:+A17+1 >A17:+A16+1 >A16:+A15+1 >D15:/F$+D7*D14 >C15:/F$" PAYMENT IS >B15:"LOAN MONTHLY >A15:+A14+1 >D14:+D12/(1-D13) >C14:"TWO EQUALS >B14:"LOAN FA >G67:/F$+G66-F67 >F67:/F$@IF(@COUNT(F24...F67)>O8,0,F14) >E67:@IF(@COUNT(E24...E67)>O8,0,+E66+1) >D67:/FL@IF(C67=0,0,@IF(C67=1,D66+1,D66)) >C67:@IF(@COUNT(C24...C67>O8,0,@IF(C66=12,1,C66+1)) >A67:+A66+1 >K66:/F$+F66-J66 >J66:/F$+H65-H66 >I66:/F$+G66-H66 >H66:/F$@IF(E66=0,0,@INT(((O8-E66)+1)*(O8-E66/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G66:/F$+G65-F66 >F66:/F$@IF(@COUNT(F24...F66)>O8,0,F14) >E66:@IF(@COUNT(E24...E66)>O8,0,+E65+1) >D66:/FL@IF(C66=0,0,@IF(C66=1,D65+1,D65)) >C66:@IF(@COUNT(C24...C66>O8,0,@IF(C6(C24...C56>O8,0,@IF(C55=12,1,C55+1)) >A56:+A55+1 >K55:/F$+F55-J55 >J55:/F$+H54-H55 >I55:/F$+G55-H55 >H55:/F$@IF(E55=0,0,@INT(((O8-E55)+1)*(O8-E55/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G55:/F$+G54-F55 >F55:/F$@IF(@COUNT(F24...F55)>O8,0,F14) >E55:@IF(@COUNT(E2H56 >I56:/F$+G56-H56 >H56:/F$@IF(E56=0,0,@INT(((O8-E56)+1)*(O8-E56/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G56:/F$+G55-F56 >F56:/F$@IF(@COUNT(F24...F56)>O8,0,F14) >E56:@IF(@COUNT(E24...E56)>O8,0,+E55+1) >D56:/FL@IF(C56=0,0,@IF(C56=1,D55+1,D55)) >C56:@IF(@COUNTO8/2))*F18*100+.5)/100 >G57:/F$+G56-F57 >F57:/F$@IF(@COUNT(F24...F57)>O8,0,F14) >E57:@IF(@COUNT(E24...E57)>O8,0,+E56+1) >D57:/FL@IF(C57=0,0,@IF(C57=1,D56+1,D56)) >C57:@IF(@COUNT(C24...C57>O8,0,@IF(C56=12,1,C56+1)) >A57:+A56+1 >K56:/F$+F56-J56 >J56:/F$+H55- >E58:@IF(@COUNT(E24...E58)>O8,0,+E57+1) >D58:/FL@IF(C58=0,0,@IF(C58=1,D57+1,D57)) >C58:@IF(@COUNT(C24...C58>O8,0,@IF(C57=12,1,C57+1)) >A58:+A57+1 >K57:/F$+F57-J57 >J57:/F$+H56-H57 >I57:/F$+G57-H57 >H57:/F$@IF(E57=0,0,@INT(((O8-E57)+1)*(O8-E57/2)/((O8+1)*(8)) >C59:@IF(@COUNT(C24...C59>O8,0,@IF(C58=12,1,C58+1)) >A59:+A58+1 >K58:/F$+F58-J58 >J58:/F$+H57-H58 >I58:/F$+G58-H58 >H58:/F$@IF(E58=0,0,@INT(((O8-E58)+1)*(O8-E58/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G58:/F$+G57-F58 >F58:/F$@IF(@COUNT(F24...F58)>O8,0,F14)9-J59 >J59:/F$+H58-H59 >I59:/F$+G59-H59 >H59:/F$@IF(E59=0,0,@INT(((O8-E59)+1)*(O8-E59/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G59:/F$+G58-F59 >F59:/F$@IF(@COUNT(F24...F59)>O8,0,F14) >E59:@IF(@COUNT(E24...E59)>O8,0,+E58+1) >D59:/FL@IF(C59=0,0,@IF(C59=1,D58+1,D5O8-E60/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G60:/F$+G59-F60 >F60:/F$@IF(@COUNT(F24...F60)>O8,0,F14) >E60:@IF(@COUNT(E24...E60)>O8,0,+E59+1) >D60:/FL@IF(C60=0,0,@IF(C60=1,D59+1,D59)) >C60:@IF(@COUNT(C24...C60>O8,0,@IF(C59=12,1,C59+1)) >A60:+A59+1 >K59:/F$+F524...F61)>O8,0,F14) >E61:@IF(@COUNT(E24...E61)>O8,0,+E60+1) >D61:/FL@IF(C61=0,0,@IF(C61=1,D60+1,D60)) >C61:@IF(@COUNT(C24...C61>O8,0,@IF(C60=12,1,C60+1)) >A61:+A60+1 >K60:/F$+F60-J60 >J60:/F$+H59-H60 >I60:/F$+G60-H60 >H60:/F$@IF(E60=0,0,@INT(((O8-E60)+1)*(,@IF(C62=1,D61+1,D61)) >C62:@IF(@COUNT(C24...C62>O8,0,@IF(C61=12,1,C61+1)) >A62:+A61+1 >K61:/F$+F61-J61 >J61:/F$+H60-H61 >I61:/F$+G61-H61 >H61:/F$@IF(E61=0,0,@INT(((O8-E61)+1)*(O8-E61/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G61:/F$+G60-F61 >F61:/F$@IF(@COUNT(F:+A62+1 >K62:/F$+F62-J62 >J62:/F$+H61-H62 >I62:/F$+G62-H62 >H62:/F$@IF(E62=0,0,@INT(((O8-E62)+1)*(O8-E62/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G62:/F$+G61-F62 >F62:/F$@IF(@COUNT(F24...F62)>O8,0,F14) >E62:@IF(@COUNT(E24...E62)>O8,0,+E61+1) >D62:/FL@IF(C62=0,0@INT(((O8-E63)+1)*(O8-E63/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G63:/F$+G62-F63 >F63:/F$@IF(@COUNT(F24...F63)>O8,0,F14) >E63:@IF(@COUNT(E24...E63)>O8,0,+E62+1) >D63:/FL@IF(C63=0,0,@IF(C63=1,D62+1,D62)) >C63:@IF(@COUNT(C24...C63>O8,0,@IF(C62=12,1,C62+1)) >A63F64:/F$@IF(@COUNT(F24...F64)>O8,0,F14) >E64:@IF(@COUNT(E24...E64)>O8,0,+E63+1) >D64:/FL@IF(C64=0,0,@IF(C64=1,D63+1,D63)) >C64:@IF(@COUNT(C24...C64>O8,0,@IF(C63=12,1,C63+1)) >A64:+A63+1 >K63:/F$+F63-J63 >J63:/F$+H62-H63 >I63:/F$+G63-H63 >H63:/F$@IF(E63=0,0,>D65:/FL@IF(C65=0,0,@IF(C65=1,D64+1,D64)) >C65:@IF(@COUNT(C24...C65>O8,0,@IF(C64=12,1,C64+1)) >A65:+A64+1 >K64:/F$+F64-J64 >J64:/F$+H63-H64 >I64:/F$+G64-H64 >H64:/F$@IF(E64=0,0,@INT(((O8-E64)+1)*(O8-E64/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G64:/F$+G63-F64 >5=12,1,C65+1)) >A66:+A65+1 >K65:/F$+F65-J65 >J65:/F$+H64-H65 >I65:/F$+G65-H65 >H65:/F$@IF(E65=0,0,@INT(((O8-E65)+1)*(O8-E65/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G65:/F$+G64-F65 >F65:/F$@IF(@COUNT(F24...F65)>O8,0,F14) >E65:@IF(@COUNT(E24...E65)>O8,0,+E64+1) 4...E55)>O8,0,+E54+1) >D55:/FL@IF(C55=0,0,@IF(C55=1,D54+1,D54)) >C55:@IF(@COUNT(C24...C55>O8,0,@IF(C54=12,1,C54+1)) >A55:+A54+1 >K54:/F$+F54-J54 >J54:/F$+H53-H54 >I54:/F$+G54-H54 >H54:/F$@IF(E54=0,0,@INT(((O8-E54)+1)*(O8-E54/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G54:/F$+G53-F54 >F54:/F$@IF(@COUNT(F24...F54)>O8,0,F14) >E54:@IF(@COUNT(E24...E54)>O8,0,+E53+1) >D54:/FL@IF(C54=0,0,@IF(C54=1,D53+1,D53)) >C54:@IF(@COUNT(C24...C54>O8,0,@IF(C53=12,1,C53+1)) >A54:+A53+1 >K53:/F$+F53-J53 >J53:/F$+H52-H53 >I53:/F$+G53-H542-H43 >I43:/F$+G43-H43 >H43:/F$@IF(E43=0,0,@INT(((O8-E43)+1)*(O8-E43/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G43:/F$+G42-F43 >F43:/F$@IF(@COUNT(F24...F43)>O8,0,F14) >E43:@IF(@COUNT(E24...E43)>O8,0,+E42+1) >D43:/FL@IF(C43=0,0,@IF(C43=1,D42+1,D42)) >C43:@IF(@CO)*(O8/2))*F18*100+.5)/100 >G44:/F$+G43-F44 >F44:/F$@IF(@COUNT(F24...F44)>O8,0,F14) >E44:@IF(@COUNT(E24...E44)>O8,0,+E43+1) >D44:/FL@IF(C44=0,0,@IF(C44=1,D43+1,D43)) >C44:@IF(@COUNT(C24...C44>O8,0,@IF(C43=12,1,C43+1)) >A44:+A43+1 >K43:/F$+F43-J43 >J43:/F$+H14) >E45:@IF(@COUNT(E24...E45)>O8,0,+E44+1) >D45:/FL@IF(C45=0,0,@IF(C45=1,D44+1,D44)) >C45:@IF(@COUNT(C24...C45>O8,0,@IF(C44=12,1,C44+1)) >A45:+A44+1 >K44:/F$+F44-J44 >J44:/F$+H43-H44 >I44:/F$+G44-H44 >H44:/F$@IF(E44=0,0,@INT(((O8-E44)+1)*(O8-E44/2)/((O8+1,D45)) >C46:@IF(@COUNT(C24...C46>O8,0,@IF(C45=12,1,C45+1)) >A46:+A45+1 >K45:/F$+F45-J45 >J45:/F$+H44-H45 >I45:/F$+G45-H45 >H45:/F$@IF(E45=0,0,@INT(((O8-E45)+1)*(O8-E45/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G45:/F$+G44-F45 >F45:/F$@IF(@COUNT(F24...F45)>O8,0,F+F46-J46 >J46:/F$+H45-H46 >I46:/F$+G46-H46 >H46:/F$@IF(E46=0,0,@INT(((O8-E46)+1)*(O8-E46/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G46:/F$+G45-F46 >F46:/F$@IF(@COUNT(F24...F46)>O8,0,F14) >E46:@IF(@COUNT(E24...E46)>O8,0,+E45+1) >D46:/FL@IF(C46=0,0,@IF(C46=1,D45+1)*(O8-E47/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G47:/F$+G46-F47 >F47:/F$@IF(@COUNT(F24...F47)>O8,0,F14) >E47:@IF(@COUNT(E24...E47)>O8,0,+E46+1) >D47:/FL@IF(C47=0,0,@IF(C47=1,D46+1,D46)) >C47:@IF(@COUNT(C24...C47>O8,0,@IF(C46=12,1,C46+1)) >A47:+A46+1 >K46:/F$T(F24...F48)>O8,0,F14) >E48:@IF(@COUNT(E24...E48)>O8,0,+E47+1) >D48:/FL@IF(C48=0,0,@IF(C48=1,D47+1,D47)) >C48:@IF(@COUNT(C24...C48>O8,0,@IF(C47=12,1,C47+1)) >A48:+A47+1 >K47:/F$+F47-J47 >J47:/F$+H46-H47 >I47:/F$+G47-H47 >H47:/F$@IF(E47=0,0,@INT(((O8-E47)+10,0,@IF(C49=1,D48+1,D48)) >C49:@IF(@COUNT(C24...C49>O8,0,@IF(C48=12,1,C48+1)) >A49:+A48+1 >K48:/F$+F48-J48 >J48:/F$+H47-H48 >I48:/F$+G48-H48 >H48:/F$@IF(E48=0,0,@INT(((O8-E48)+1)*(O8-E48/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G48:/F$+G47-F48 >F48:/F$@IF(@COUNA50:+A49+1 >K49:/F$+F49-J49 >J49:/F$+H48-H49 >I49:/F$+G49-H49 >H49:/F$@IF(E49=0,0,@INT(((O8-E49)+1)*(O8-E49/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G49:/F$+G48-F49 >F49:/F$@IF(@COUNT(F24...F49)>O8,0,F14) >E49:@IF(@COUNT(E24...E49)>O8,0,+E48+1) >D49:/FL@IF(C49=,0,@INT(((O8-E50)+1)*(O8-E50/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G50:/F$+G49-F50 >F50:/F$@IF(@COUNT(F24...F50)>O8,0,F14) >E50:@IF(@COUNT(E24...E50)>O8,0,+E49+1) >D50:/FL@IF(C50=0,0,@IF(C50=1,D49+1,D49)) >C50:@IF(@COUNT(C24...C50>O8,0,@IF(C49=12,1,C49+1)) >1 >F51:/F$@IF(@COUNT(F24...F51)>O8,0,F14) >E51:@IF(@COUNT(E24...E51)>O8,0,+E50+1) >D51:/FL@IF(C51=0,0,@IF(C51=1,D50+1,D50)) >C51:@IF(@COUNT(C24...C51>O8,0,@IF(C50=12,1,C50+1)) >A51:+A50+1 >K50:/F$+F50-J50 >J50:/F$+H49-H50 >I50:/F$+G50-H50 >H50:/F$@IF(E50=01) >D52:/FL@IF(C52=0,0,@IF(C52=1,D51+1,D51)) >C52:@IF(@COUNT(C24...C52>O8,0,@IF(C51=12,1,C51+1)) >A52:+A51+1 >K51:/F$+F51-J51 >J51:/F$+H50-H51 >I51:/F$+G51-H51 >H51:/F$@IF(E51=0,0,@INT(((O8-E51)+1)*(O8-E51/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G51:/F$+G50-F5(C52=12,1,C52+1)) >A53:+A52+1 >K52:/F$+F52-J52 >J52:/F$+H51-H52 >I52:/F$+G52-H52 >H52:/F$@IF(E52=0,0,@INT(((O8-E52)+1)*(O8-E52/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G52:/F$+G51-F52 >F52:/F$@IF(@COUNT(F24...F52)>O8,0,F14) >E52:@IF(@COUNT(E24...E52)>O8,0,+E51+3 >H53:/F$@IF(E53=0,0,@INT(((O8-E53)+1)*(O8-E53/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G53:/F$+G52-F53 >F53:/F$@IF(@COUNT(F24...F53)>O8,0,F14) >E53:@IF(@COUNT(E24...E53)>O8,0,+E52+1) >D53:/FL@IF(C53=0,0,@IF(C53=1,D52+1,D52)) >C53:@IF(@COUNT(C24...C53>O8,0,@IFUNT(C24...C43>O8,0,@IF(C42=12,1,C42+1)) >A43:+A42+1 >K42:/F$+F42-J42 >J42:/F$+H41-H42 >I42:/F$+G42-H42 >H42:/F$@IF(E42=0,0,@INT(((O8-E42)+1)*(O8-E42/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G42:/F$+G41-F42 >F42:/F$@IF(@COUNT(F24...F42)>O8,0,F14) >E42:@IF(@COUNT(E24...E42)>O8,0,+E41+1) >D42:/FL@IF(C42=0,0,@IF(C42=1,D41+1,D41)) >C42:@IF(@COUNT(C24...C42>O8,0,@IF(C41=12,1,C41+1)) >A42:+A41+1 >K41:/F$+F41-J41 >J41:/F$+H40-H41 >I41:/F$+G41-H41 >H41:/F$@IF(E41=0,0,@INT(((O8-E41)+1)*(O8-E41/2)/((O8+1)*(O8/2))*F18*100+.8+1)*(O8/2))*F18*100+.5)/100 >G31:/F$+G30-F31 >F31:/F$@IF(@COUNT(F24...F31)>O8,0,F14) >E31:@IF(@COUNT(E24...E31)>O8,0,+E30+1) >D31:/FL@IF(C31=0,0,@IF(C31=1,D30+1,D30)) >C31:@IF(@COUNT(C24...C31>O8,0,@IF(C30=12,1,C30+1)) >A31:+A30+1 >K30:/F$+F30-J30 >J30:/F0,F14) >E32:@IF(@COUNT(E24...E32)>O8,0,+E31+1) >D32:/FL@IF(C32=0,0,@IF(C32=1,D31+1,D31)) >C32:@IF(@COUNT(C24...C32>O8,0,@IF(C31=12,1,C31+1)) >A32:+A31+1 >K31:/F$+F31-J31 >J31:/F$+H30-H31 >I31:/F$+G31-H31 >H31:/F$@IF(E31=0,0,@INT(((O8-E31)+1)*(O8-E31/2)/((O2+1,D32)) >C33:@IF(@COUNT(C24...C33>O8,0,@IF(C32=12,1,C32+1)) >A33:+A32+1 >K32:/F$+F32-J32 >J32:/F$+H31-H32 >I32:/F$+G32-H32 >H32:/F$@IF(E32=0,0,@INT(((O8-E32)+1)*(O8-E32/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G32:/F$+G31-F32 >F32:/F$@IF(@COUNT(F24...F32)>O8,/F$+F33-J33 >J33:/F$+H32-H33 >I33:/F$+G33-H33 >H33:/F$@IF(E33=0,0,@INT(((O8-E33)+1)*(O8-E33/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G33:/F$+G32-F33 >F33:/F$@IF(@COUNT(F24...F33)>O8,0,F14) >E33:@IF(@COUNT(E24...E33)>O8,0,+E32+1) >D33:/FL@IF(C33=0,0,@IF(C33=1,D3)+1)*(O8-E34/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G34:/F$+G33-F34 >F34:/F$@IF(@COUNT(F24...F34)>O8,0,F14) >E34:@IF(@COUNT(E24...E34)>O8,0,+E33+1) >D34:/FL@IF(C34=0,0,@IF(C34=1,D33+1,D33)) >C34:@IF(@COUNT(C24...C34>O8,0,@IF(C33=12,1,C33+1)) >A34:+A33+1 >K33:OUNT(F24...F35)>O8,0,F14) >E35:@IF(@COUNT(E24...E35)>O8,0,+E34+1) >D35:/FL@IF(C35=0,0,@IF(C35=1,D34+1,D34)) >C35:@IF(@COUNT(C24...C35>O8,0,@IF(C34=12,1,C34+1)) >A35:+A34+1 >K34:/F$+F34-J34 >J34:/F$+H33-H34 >I34:/F$+G34-H34 >H34:/F$@IF(E34=0,0,@INT(((O8-E3436=0,0,@IF(C36=1,D35+1,D35)) >C36:@IF(@COUNT(C24...C36>O8,0,@IF(C35=12,1,C35+1)) >A36:+A35+1 >K35:/F$+F35-J35 >J35:/F$+H34-H35 >I35:/F$+G35-H35 >H35:/F$@IF(E35=0,0,@INT(((O8-E35)+1)*(O8-E35/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G35:/F$+G34-F35 >F35:/F$@IF(@C) >A37:+A36+1 >K36:/F$+F36-J36 >J36:/F$+H35-H36 >I36:/F$+G36-H36 >H36:/F$@IF(E36=0,0,@INT(((O8-E36)+1)*(O8-E36/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G36:/F$+G35-F36 >F36:/F$@IF(@COUNT(F24...F36)>O8,0,F14) >E36:@IF(@COUNT(E24...E36)>O8,0,+E35+1) >D36:/FL@IF(C7=0,0,@INT(((O8-E37)+1)*(O8-E37/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G37:/F$+G36-F37 >F37:/F$@IF(@COUNT(F24...F37)>O8,0,F14) >E37:@IF(@COUNT(E24...E37)>O8,0,+E36+1) >D37:/FL@IF(C37=0,0,@IF(C37=1,D36+1,D36)) >C37:@IF(@COUNT(C24...C37>O8,0,@IF(C36=12,1,C36+1)-F38 >F38:/F$@IF(@COUNT(F24...F38)>O8,0,F14) >E38:@IF(@COUNT(E24...E38)>O8,0,+E37+1) >D38:/FL@IF(C38=0,0,@IF(C38=1,D37+1,D37)) >C38:@IF(@COUNT(C24...C38>O8,0,@IF(C37=12,1,C37+1)) >A38:+A37+1 >K37:/F$+F37-J37 >J37:/F$+H36-H37 >I37:/F$+G37-H37 >H37:/F$@IF(E338+1) >D39:/FL@IF(C39=0,0,@IF(C39=1,D38+1,D38)) >C39:@IF(@COUNT(C24...C39>O8,0,@IF(C38=12,1,C38+1)) >A39:+A38+1 >K38:/F$+F38-J38 >J38:/F$+H37-H38 >I38:/F$+G38-H38 >H38:/F$@IF(E38=0,0,@INT(((O8-E38)+1)*(O8-E38/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G38:/F$+G37@IF(C39=12,1,C39+1)) >A40:+A39+1 >K39:/F$+F39-J39 >J39:/F$+H38-H39 >I39:/F$+G39-H39 >H39:/F$@IF(E39=0,0,@INT(((O8-E39)+1)*(O8-E39/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G39:/F$+G38-F39 >F39:/F$@IF(@COUNT(F24...F39)>O8,0,F14) >E39:@IF(@COUNT(E24...E39)>O8,0,+E-H40 >H40:/F$@IF(E40=0,0,@INT(((O8-E40)+1)*(O8-E40/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G40:/F$+G39-F40 >F40:/F$@IF(@COUNT(F24...F40)>O8,0,F14) >E40:@IF(@COUNT(E24...E40)>O8,0,+E39+1) >D40:/FL@IF(C40=0,0,@IF(C40=1,D39+1,D39)) >C40:@IF(@COUNT(C24...C40>O8,0,5)/100 >G41:/F$+G40-F41 >F41:/F$@IF(@COUNT(F24...F41)>O8,0,F14) >E41:@IF(@COUNT(E24...E41)>O8,0,+E40+1) >D41:/FL@IF(C41=0,0,@IF(C41=1,D40+1,D40)) >C41:@IF(@COUNT(C24...C41>O8,0,@IF(C40=12,1,C40+1)) >A41:+A40+1 >K40:/F$+F40-J40 >J40:/F$+H39-H40 >I40:/F$+G40$+H29-H30 >I30:/F$+G30-H30 >H30:/F$@IF(E30=0,0,@INT(((O8-E30)+1)*(O8-E30/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G30:/F$+G29-F30 >F30:/F$@IF(@COUNT(F24...F30)>O8,0,F14) >E30:@IF(@COUNT(E24...E30)>O8,0,+E29+1) >D30:/FL@IF(C30=0,0,@IF(C30=1,D29+1,D29)) >C30:@IF(@COUNT(C24...C30>O8,0,@IF(C29=12,1,C29+1)) >A30:+A29+1 >K29:/F$+F29-J29 >J29:/F$+H28-H29 >I29:/F$+G29-H29 >H29:/F$@IF(E29=0,0,@INT(((O8-E29)+1)*(O8-E29/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G29:/F$+G28-F29 >F29:/F$@IF(@COUNT(F24...F29)>O8,0,F14) >E29:@IF(@COORTIZATIO >C1:" RULE 78 A >B1:"MODEL 5 - >A1:1 /W1 /GOR /GRM /GC10 /X>L1:>R1: A4+1 >O4:"=========== >N4:"=========== >M4:"========== >A4:+A3+1 >N3:"OAN >M3:"TERMS OF LOAN >A3:+A2+1 >M2:" >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >E1:"N >D1:"MH11:" UNDER RULE >G11:"ON OF LOAN >F11:"AMORTIZATION >A11:+A10+1 >O10:"......... >N10:"ATE (APR) >M10:"INTEREST R >A10:+A9+1 >A9:+A8+1 >O8:"......... >N8:"THS >M8:"NO. OF MONT >A8:+A7+1 >A7:+A6+1 >O6:/F$"......... >N6:"MOUNT >M6:"PROCEEDS A >A6:+A5+1 >A5:+UMBER OF >F14:/FG@INT((O6/(1-((1+(O10/100/12))^-O8)/(O10/100/12)))+.005*100)/100 >E14:"YMENT : >D14:"MONTHLY PAY >A14:+A13+1 >O13:"......... >N13:"TH-1 TO 12 >M13:" WHAT MONTH >A13:+A12+1 >N12:"T MADE IN >M12:"1ST PAYMENT >A12:+A11+1 >I11:"E OF 78'S >INTEREST >A18:+A17+1 >A17:+A16+1 >O16:"......... >N16:"R >M16:" WHAT YEAR >J16:+O10 >I16:"ATE : >H16:"INTEREST R >F16:/F$+O6 >E16:"MOUNT : >D16:"PROCEEDS A >A16:+A15+1 >N15:"T MADE IN >M15:"1ST PAYMENT >A15:+A14+1 >J14:+O8 >I14:"MONTHS : >H14:"NG21:" LOAN >F21:/FG" AMOUNT OF >A21:+A20+1 >O20:"MONTHS. >N20:"ERM IS 48 >M20:" MAXIMUM T >A20:+A19+1 >O19:"EPORT. >N19:"" TO RUN REP >M19:" GOTO "A10" TO >A19:+A18+1 >J18:+F18+F16 >I18:"AYMENTS : >H18:"TOTAL OF P >F18:+F14*O8-F16 >E18:" : >D18:" >E23:" ========= >D23:" ===== >C23:" ====== >A23:+A22+1 >K22:" PAYMENT >J22:" PAYMENT >I22:" PAYOFF >H22:" REBATE >G22:" BALANCE >F22:" PAYMENT >E22:" PAYMENT # >D22:" YEAR >C22:" MONTH >A22:+A21+1 >K21:" PRINCIPAL >J21:" INTEREST >I21:" NET >4 >H24:/F$@IF(E24=0,0,@INT(((O8-E24)+1)*(O8-E24/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G24:/F$+J18-F24 >F24:/F$+F14 >E24:1 >D24:/FL+O16 >C24:+O13 >A24:+A23+1 >K23:" ========= >J23:" ========= >I23:" ========= >H23:" ========= >G23:" ========= >F23:" =========100 >G25:/F$+G24-F25 >F25:/F$@IF(@COUNT(F24...F25)>O8,0,F14) >E25:@IF(@COUNT(E24...E25)>O8,0,+E24+1) >D25:/FL@IF(C25=0,0,@IF(C25=1,D24+1,D24)) >C25:@IF(@COUNT(C24...C25>O8,0,@IF(C24=12,1,C24+1)) >A25:+A24+1 >K24:/F$+F24-J24 >J24:/F$+F18-H24 >I24:/F$+G24-H24...E26)>O8,0,+E25+1) >D26:/FL@IF(C26=0,0,@IF(C26=1,D25+1,D25)) >C26:@IF(@COUNT(C24...C26>O8,0,@IF(C25=12,1,C25+1)) >A26:+A25+1 >K25:/F$+F25-J25 >J25:/F$+H24-H25 >I25:/F$+G25-H25 >H25:/F$@IF(E25=0,0,@INT(((O8-E25)+1)*(O8-E25/2)/((O8+1)*(O8/2))*F18*100+.5)/(C24...C27>O8,0,@IF(C26=12,1,C26+1)) >A27:+A26+1 >K26:/F$+F26-J26 >J26:/F$+H25-H26 >I26:/F$+G26-H26 >H26:/F$@IF(E26=0,0,@INT(((O8-E26)+1)*(O8-E26/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G26:/F$+G25-F26 >F26:/F$@IF(@COUNT(F24...F26)>O8,0,F14) >E26:@IF(@COUNT(E2H27 >I27:/F$+G27-H27 >H27:/F$@IF(E27=0,0,@INT(((O8-E27)+1)*(O8-E27/2)/((O8+1)*(O8/2))*F18*100+.5)/100 >G27:/F$+G26-F27 >F27:/F$@IF(@COUNT(F24...F27)>O8,0,F14) >E27:@IF(@COUNT(E24...E27)>O8,0,+E26+1) >D27:/FL@IF(C27=0,0,@IF(C27=1,D26+1,D26)) >C27:@IF(@COUNT0+.5)/100 >G28:/F$@IF(F28=0,0,+G27-F28) >F28:/F$@IF(@COUNT(F24...F28)>O8,0,F14) >E28:@IF(@COUNT(E24...E28)>O8,0,+E27+1) >D28:/FL@IF(C28=0,0,@IF(C28=1,D27+1,D27)) >C28:@IF(@COUNT(C24...C28>O8,0,@IF(C27=12,1,C27+1)) >A28:+A27+1 >K27:/F$+F27-J27 >J27:/F$+H26-UNT(E24...E29)>O8,0,+E28+1) >D29:/FL@IF(C29=0,0,@IF(C29=1,D28+1,D28)) >C29:@IF(@COUNT(C24...C29>O8,0,@IF(C28=12,1,C28+1)) >A29:+A28+1 >K28:/F$+F28-J28 >J28:/F$+H27-H28 >I28:/F$+G28-H28 >H28:/F$@IF(E28=0,0,@INT(((O8-E28)+1)*(O8-E28/2)/((O8+1)*(O8/2))*F18*10>H73:@IF(D5=0,0,@INT(((1+(+D73/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G73:@IF(D5=0,0,@INT(((1+(+D73/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F73:@IF(D5=0,0,@INT(((1+(+D73/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E5=0,0,@INT((1+(+D65/E16/100))^H16-1*100+.0005*1000)/1000) >D65:/F$+D64+.01 >A65:+A64+1 >H64:@IF(D5=0,0,@INT(((1+(+D64/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G64:@IF(D5=0,0,@INT(((1+(+D64/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)(D5=0,0,@INT(((1+(+D65/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G65:@IF(D5=0,0,@INT(((1+(+D65/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F65:@IF(D5=0,0,@INT(((1+(+D65/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E65:@IF(DD5=0,0,@INT(((1+(+D66/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F66:@IF(D5=0,0,@INT(((1+(+D66/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E66:@IF(D5=0,0,@INT((1+(+D66/E16/100))^H16-1*100+.0005*1000)/1000) >D66:/F$+D65+.01 >A66:+A65+1 >H65:@IF(1+(+D67/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E67:@IF(D5=0,0,@INT((1+(+D67/E16/100))^H16-1*100+.0005*1000)/1000) >D67:/F$+D66+.01 >A67:+A66+1 >H66:@IF(D5=0,0,@INT(((1+(+D66/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G66:@IF(^H16-1*100+.0005*1000)/1000) >D68:/F$+D67+.01 >A68:+A67+1 >H67:@IF(D5=0,0,@INT(((1+(+D67/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G67:@IF(D5=0,0,@INT(((1+(+D67/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F67:@IF(D5=0,0,@INT((0))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G68:@IF(D5=0,0,@INT(((1+(+D68/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F68:@IF(D5=0,0,@INT(((1+(+D68/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E68:@IF(D5=0,0,@INT((1+(+D68/E16/100))))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F69:@IF(D5=0,0,@INT(((1+(+D69/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E69:@IF(D5=0,0,@INT((1+(+D69/E16/100))^H16-1*100+.0005*1000)/1000) >D69:/F$+D68+.01 >A69:+A68+1 >H68:@IF(D5=0,0,@INT(((1+(+D68/E16/10*H16*100+.0005*1000)/1000) >E70:@IF(D5=0,0,@INT((1+(+D70/E16/100))^H16-1*100+.0005*1000)/1000) >D70:/F$+D69+.01 >A70:+A69+1 >H69:@IF(D5=0,0,@INT(((1+(+D69/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G69:@IF(D5=0,0,@INT(((1+(+D69/E16/100>D71:/F$+D70+.01 >A71:+A70+1 >H70:@IF(D5=0,0,@INT(((1+(+D70/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G70:@IF(D5=0,0,@INT(((1+(+D70/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F70:@IF(D5=0,0,@INT(((1+(+D70/E16/100))^182)-1/1827*H16*100+.0005*1000)/1000) >G71:@IF(D5=0,0,@INT(((1+(+D71/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F71:@IF(D5=0,0,@INT(((1+(+D71/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E71:@IF(D5=0,0,@INT((1+(+D71/E16/100))^H16-1*100+.0005*1000)/1000) 05*1000)/1000) >F72:@IF(D5=0,0,@INT(((1+(+D72/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E72:@IF(D5=0,0,@INT((1+(+D72/E16/100))^H16-1*100+.0005*1000)/1000) >D72:/F$+D71+.01 >A72:+A71+1 >H71:@IF(D5=0,0,@INT(((1+(+D71/E16/100))^30.41666667)-1/30.416666673:@IF(D5=0,0,@INT((1+(+D73/E16/100))^H16-1*100+.0005*1000)/1000) >D73:/F$+D72+.01 >A73:+A72+1 >H72:@IF(D5=0,0,@INT(((1+(+D72/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G72:@IF(D5=0,0,@INT(((1+(+D72/E16/100))^91.25)-1/91.25*H16*100+.00/1000) >F64:@IF(D5=0,0,@INT(((1+(+D64/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E64:@IF(D5=0,0,@INT((1+(+D64/E16/100))^H16-1*100+.0005*1000)/1000) >D64:/F$+D63+.01 >A64:+A63+1 >H63:@IF(D5=0,0,@INT(((1+(+D63/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G63:@IF(D5=0,0,@INT(((1+(+D63/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F63:@IF(D5=0,0,@INT(((1+(+D63/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E63:@IF(D5=0,0,@INT((1+(+D63/E16/100))^H16-1*100+.0005*1000)/1000) >D63:/F$5*H16*100+.0005*1000)/1000) >F53:@IF(D5=0,0,@INT(((1+(+D53/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E53:@IF(D5=0,0,@INT((1+(+D53/E16/100))^H16-1*100+.0005*1000)/1000) >D53:/F$+D52+.01 >A53:+A52+1 >H52:@IF(D5=0,0,@INT(((1+(+D52/E16/100))^30.41666667)000)/1000) >E54:@IF(D5=0,0,@INT((1+(+D54/E16/100))^H16-1*100+.0005*1000)/1000) >D54:/F$+D53+.01 >A54:+A53+1 >H53:@IF(D5=0,0,@INT(((1+(+D53/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G53:@IF(D5=0,0,@INT(((1+(+D53/E16/100))^91.25)-1/91.2 >A55:+A54+1 >H54:@IF(D5=0,0,@INT(((1+(+D54/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G54:@IF(D5=0,0,@INT(((1+(+D54/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F54:@IF(D5=0,0,@INT(((1+(+D54/E16/100))^182)-1/182*H16*100+.0005*11000)/1000) >G55:@IF(D5=0,0,@INT(((1+(+D55/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F55:@IF(D5=0,0,@INT(((1+(+D55/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E55:@IF(D5=0,0,@INT((1+(+D55/E16/100))^H16-1*100+.0005*1000)/1000) >D55:/F$+D54+.01F56:@IF(D5=0,0,@INT(((1+(+D56/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E56:@IF(D5=0,0,@INT((1+(+D56/E16/100))^H16-1*100+.0005*1000)/1000) >D56:/F$+D55+.01 >A56:+A55+1 >H55:@IF(D5=0,0,@INT(((1+(+D55/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*NT((1+(+D57/E16/100))^H16-1*100+.0005*1000)/1000) >D57:/F$+D56+.01 >A57:+A56+1 >H56:@IF(D5=0,0,@INT(((1+(+D56/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G56:@IF(D5=0,0,@INT(((1+(+D56/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >@INT(((1+(+D57/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G57:@IF(D5=0,0,@INT(((1+(+D57/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F57:@IF(D5=0,0,@INT(((1+(+D57/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E57:@IF(D5=0,0,@IINT(((1+(+D58/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F58:@IF(D5=0,0,@INT(((1+(+D58/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E58:@IF(D5=0,0,@INT((1+(+D58/E16/100))^H16-1*100+.0005*1000)/1000) >D58:/F$+D57+.01 >A58:+A57+1 >H57:@IF(D5=0,0,/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E59:@IF(D5=0,0,@INT((1+(+D59/E16/100))^H16-1*100+.0005*1000)/1000) >D59:/F$+D58+.01 >A59:+A58+1 >H58:@IF(D5=0,0,@INT(((1+(+D58/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G58:@IF(D5=0,0,@00+.0005*1000)/1000) >D60:/F$+D59+.01 >A60:+A59+1 >H59:@IF(D5=0,0,@INT(((1+(+D59/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G59:@IF(D5=0,0,@INT(((1+(+D59/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F59:@IF(D5=0,0,@INT(((1+(+D591666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G60:@IF(D5=0,0,@INT(((1+(+D60/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F60:@IF(D5=0,0,@INT(((1+(+D60/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E60:@IF(D5=0,0,@INT((1+(+D60/E16/100))^H16-1*1)-1/91.25*H16*100+.0005*1000)/1000) >F61:@IF(D5=0,0,@INT(((1+(+D61/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E61:@IF(D5=0,0,@INT((1+(+D61/E16/100))^H16-1*100+.0005*1000)/1000) >D61:/F$+D60+.01 >A61:+A60+1 >H60:@IF(D5=0,0,@INT(((1+(+D60/E16/100))^30.4+.0005*1000)/1000) >E62:@IF(D5=0,0,@INT((1+(+D62/E16/100))^H16-1*100+.0005*1000)/1000) >D62:/F$+D61+.01 >A62:+A61+1 >H61:@IF(D5=0,0,@INT(((1+(+D61/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G61:@IF(D5=0,0,@INT(((1+(+D61/E16/100))^91.25+D62+.01 >A63:+A62+1 >H62:@IF(D5=0,0,@INT(((1+(+D62/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G62:@IF(D5=0,0,@INT(((1+(+D62/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F62:@IF(D5=0,0,@INT(((1+(+D62/E16/100))^182)-1/182*H16*100-1/30.41666667*H16*100+.0005*1000)/1000) >G52:@IF(D5=0,0,@INT(((1+(+D52/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F52:@IF(D5=0,0,@INT(((1+(+D52/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E52:@IF(D5=0,0,@INT((1+(+D52/E16/100))^H16-1*100+.0005*1000)/1000) >D52:/F$+D51+.01 >A52:+A51+1 >H51:@IF(D5=0,0,@INT(((1+(+D51/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G51:@IF(D5=0,0,@INT(((1+(+D51/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F51:@IF(D5=0,0,@INT(((1+(+D51/E16/10016/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G41:@IF(D5=0,0,@INT(((1+(+D41/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F41:@IF(D5=0,0,@INT(((1+(+D41/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E41:@IF(D5=0,0,@INT((1+(+D41/E16/6/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F42:@IF(D5=0,0,@INT(((1+(+D42/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E42:@IF(D5=0,0,@INT((1+(+D42/E16/100))^H16-1*100+.0005*1000)/1000) >D42:/F$+D41+.01 >A42:+A41+1 >H41:@IF(D5=0,0,@INT(((1+(+D41/E1/182*H16*100+.0005*1000)/1000) >E43:@IF(D5=0,0,@INT((1+(+D43/E16/100))^H16-1*100+.0005*1000)/1000) >D43:/F$+D42+.01 >A43:+A42+1 >H42:@IF(D5=0,0,@INT(((1+(+D42/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G42:@IF(D5=0,0,@INT(((1+(+D42/E1000) >D44:/F$+D43+.01 >A44:+A43+1 >H43:@IF(D5=0,0,@INT(((1+(+D43/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G43:@IF(D5=0,0,@INT(((1+(+D43/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F43:@IF(D5=0,0,@INT(((1+(+D43/E16/100))^182)-666667*H16*100+.0005*1000)/1000) >G44:@IF(D5=0,0,@INT(((1+(+D44/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F44:@IF(D5=0,0,@INT(((1+(+D44/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E44:@IF(D5=0,0,@INT((1+(+D44/E16/100))^H16-1*100+.0005*1000)/10+.0005*1000)/1000) >F45:@IF(D5=0,0,@INT(((1+(+D45/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E45:@IF(D5=0,0,@INT((1+(+D45/E16/100))^H16-1*100+.0005*1000)/1000) >D45:/F$+D44+.01 >A45:+A44+1 >H44:@IF(D5=0,0,@INT(((1+(+D44/E16/100))^30.41666667)-1/30.410) >E46:@IF(D5=0,0,@INT((1+(+D46/E16/100))^H16-1*100+.0005*1000)/1000) >D46:/F$+D45+.01 >A46:+A45+1 >H45:@IF(D5=0,0,@INT(((1+(+D45/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G45:@IF(D5=0,0,@INT(((1+(+D45/E16/100))^91.25)-1/91.25*H16*1046+1 >H46:@IF(D5=0,0,@INT(((1+(+D46/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G46:@IF(D5=0,0,@INT(((1+(+D46/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F46:@IF(D5=0,0,@INT(((1+(+D46/E16/100))^182)-1/182*H16*100+.0005*1000)/10000) >G47:@IF(D5=0,0,@INT(((1+(+D47/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F47:@IF(D5=0,0,@INT(((1+(+D47/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E47:@IF(D5=0,0,@INT((1+(+D47/E16/100))^H16-1*100+.0005*1000)/1000) >D47:/F$+D46+.01 >A47:+AD5=0,0,@INT(((1+(+D48/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E48:@IF(D5=0,0,@INT((1+(+D48/E16/100))^H16-1*100+.0005*1000)/1000) >D48:/F$+D47+.01 >A48:+A47+1 >H47:@IF(D5=0,0,@INT(((1+(+D47/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/10D49/E16/100))^H16-1*100+.0005*1000)/1000) >D49:/F$+D48+.01 >A49:+A48+1 >H48:@IF(D5=0,0,@INT(((1+(+D48/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G48:@IF(D5=0,0,@INT(((1+(+D48/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F48:@IF(+(+D49/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G49:@IF(D5=0,0,@INT(((1+(+D49/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F49:@IF(D5=0,0,@INT(((1+(+D49/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E49:@IF(D5=0,0,@INT((1+(+(+D50/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F50:@IF(D5=0,0,@INT(((1+(+D50/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E50:@IF(D5=0,0,@INT((1+(+D50/E16/100))^H16-1*100+.0005*1000)/1000) >D50:/F$+D49+.01 >A50:+A49+1 >H49:@IF(D5=0,0,@INT(((1))^182)-1/182*H16*100+.0005*1000)/1000) >E51:@IF(D5=0,0,@INT((1+(+D51/E16/100))^H16-1*100+.0005*1000)/1000) >D51:/F$+D50+.01 >A51:+A50+1 >H50:@IF(D5=0,0,@INT(((1+(+D50/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G50:@IF(D5=0,0,@INT(((1+100))^H16-1*100+.0005*1000)/1000) >D41:/F$+D40+.01 >A41:+A40+1 >H40:@IF(D5=0,0,@INT(((1+(+D40/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G40:@IF(D5=0,0,@INT(((1+(+D40/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F40:@IF(D5=0,0,@INT(((1+(+D40/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E40:@IF(D5=0,0,@INT((1+(+D40/E16/100))^H16-1*100+.0005*1000)/1000) >D40:/F$+D39+.01 >A40:+A39+1 >H39:@IF(D5=0,0,@INT(((1+(+D39/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G39,0,@INT((1+(+D30/E16/100))^H16-1*100+.0005*1000)/1000) >D30:/F$+D29+.01 >A30:+A29+1 >H29:@IF(D5=0,0,@INT(((1+(+D29/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G29:@IF(D5=0,0,@INT(((1+(+D29/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/10=0,0,@INT(((1+(+D30/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G30:@IF(D5=0,0,@INT(((1+(+D30/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F30:@IF(D5=0,0,@INT(((1+(+D30/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E30:@IF(D5=00,0,@INT(((1+(+D31/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F31:@IF(D5=0,0,@INT(((1+(+D31/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E31:@IF(D5=0,0,@INT((1+(+D31/E16/100))^H16-1*100+.0005*1000)/1000) >D31:/F$+D30+.01 >A31:+A30+1 >H30:@IF(D5(+D32/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E32:@IF(D5=0,0,@INT((1+(+D32/E16/100))^H16-1*100+.0005*1000)/1000) >D32:/F$+D31+.01 >A32:+A31+1 >H31:@IF(D5=0,0,@INT(((1+(+D31/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G31:@IF(D5=6-1*100+.0005*1000)/1000) >D33:/F$+D32+.01 >A33:+A32+1 >H32:@IF(D5=0,0,@INT(((1+(+D32/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G32:@IF(D5=0,0,@INT(((1+(+D32/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F32:@IF(D5=0,0,@INT(((1+^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G33:@IF(D5=0,0,@INT(((1+(+D33/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F33:@IF(D5=0,0,@INT(((1+(+D33/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E33:@IF(D5=0,0,@INT((1+(+D33/E16/100))^H191.25)-1/91.25*H16*100+.0005*1000)/1000) >F34:@IF(D5=0,0,@INT(((1+(+D34/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E34:@IF(D5=0,0,@INT((1+(+D34/E16/100))^H16-1*100+.0005*1000)/1000) >D34:/F$+D33+.01 >A34:+A33+1 >H33:@IF(D5=0,0,@INT(((1+(+D33/E16/100))6*100+.0005*1000)/1000) >E35:@IF(D5=0,0,@INT((1+(+D35/E16/100))^H16-1*100+.0005*1000)/1000) >D35:/F$+D34+.01 >A35:+A34+1 >H34:@IF(D5=0,0,@INT(((1+(+D34/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G34:@IF(D5=0,0,@INT(((1+(+D34/E16/100))^6:/F$+D35+.01 >A36:+A35+1 >H35:@IF(D5=0,0,@INT(((1+(+D35/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G35:@IF(D5=0,0,@INT(((1+(+D35/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F35:@IF(D5=0,0,@INT(((1+(+D35/E16/100))^182)-1/182*H116*100+.0005*1000)/1000) >G36:@IF(D5=0,0,@INT(((1+(+D36/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F36:@IF(D5=0,0,@INT(((1+(+D36/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E36:@IF(D5=0,0,@INT((1+(+D36/E16/100))^H16-1*100+.0005*1000)/1000) >D31000)/1000) >F37:@IF(D5=0,0,@INT(((1+(+D37/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E37:@IF(D5=0,0,@INT((1+(+D37/E16/100))^H16-1*100+.0005*1000)/1000) >D37:/F$+D36+.01 >A37:+A36+1 >H36:@IF(D5=0,0,@INT(((1+(+D36/E16/100))^30.41666667)-1/30.41666667*H@IF(D5=0,0,@INT((1+(+D38/E16/100))^H16-1*100+.0005*1000)/1000) >D38:/F$+D37+.01 >A38:+A37+1 >H37:@IF(D5=0,0,@INT(((1+(+D37/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G37:@IF(D5=0,0,@INT(((1+(+D37/E16/100))^91.25)-1/91.25*H16*100+.0005*8:@IF(D5=0,0,@INT(((1+(+D38/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G38:@IF(D5=0,0,@INT(((1+(+D38/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F38:@IF(D5=0,0,@INT(((1+(+D38/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E38::@IF(D5=0,0,@INT(((1+(+D39/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F39:@IF(D5=0,0,@INT(((1+(+D39/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E39:@IF(D5=0,0,@INT((1+(+D39/E16/100))^H16-1*100+.0005*1000)/1000) >D39:/F$+D38+.01 >A39:+A38+1 >H300) >F29:@IF(D5=0,0,@INT(((1+(+D29/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E29:@IF(D5=0,0,@INT((1+(+D29/E16/100))^H16-1*100+.0005*1000)/1000) >D29:/F$+D28+.01 >A29:+A28+1 >H28:@IF(D5=0,0,@INT(((1+(+D28/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G28:@IF(D5=0,0,@INT(((1+(+D28/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F28:@IF(D5=0,0,@INT(((1+(+D28/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E28:@IF(D5=0,0,@INT((1+(+D28/E16/100))^H16-1*100+.0005*1000)/1000) >D28:/F$+D21*100 >B54:+B53+.0005 >A54:+A53+1 >C53:((1+(B53/365)^365)-1*100 >B53:+B52+.0005 >A53:+A52+1 >C52:((1+(B52/365)^365)-1*100 >B52:+B51+.0005 >A52:+A51+1 >C51:((1+(B51/365)^365)-1*100 >B51:+B50+.0005 >A51:+A50+1 >C50:((1+(B50/365)^365)-1*100 >B50:+B49+.0005 >A>C58:((1+(B58/365)^365)-1*100 >B58:+B57+.0005 >A58:+A57+1 >C57:((1+(B57/365)^365)-1*100 >B57:+B56+.0005 >A57:+A56+1 >C56:((1+(B56/365)^365)-1*100 >B56:+B55+.0005 >A56:+A55+1 >C55:((1+(B55/365)^365)-1*100 >B55:+B54+.0005 >A55:+A54+1 >C54:((1+(B54/365)^365)-E2:" E >D2:" D >C2:" C >B2:" B >A2:+A1+1 >G1:"DING >F1:"Y COMPOUN >E1:"FROM DAIL >D1:"VE RATES >C1:"- EFFECTI >B1:"MODEL 6 >A1:1 /W1 /GOR /GRM /GC9 /X>A1:>A1: UNDING >D12:" DAILY >A12:+A11+1 >A11:+A10+1 >A10:+A9+1 >A9:+A8+1 >A8:+A7+1 >D7:"......... >C7:"E -----> >B7:"INPUT BASE >A7:+A6+1 >A6:+A5+1 >D5:/F$"......... >C5:"E -----> >B5:"INPUT RAT >A5:+A4+1 >A4:+A3+1 >A3:+A2+1 >H2:" H >G2:" G >F2:" F >D >G18:" INTEREST >F18:"E RATE IF >E18:" EFFECTIVE >A18:+A17+1 >A17:+A16+1 >H16:365 >G16:" IN YEAR: >F16:" DAYS >E16:+D7 >D16:" BASES : >A16:+A15+1 >A15:+A14+1 >A14:+A13+1 >A13:+A12+1 >H12:"RATES >G12:"FFECTIVE RATE >F12:"NDING - EFFE >E12:"LY COMPO==== >G21:" ========= >F21:" ========= >E21:" ========= >D21:" ========= >A21:+A20+1 >H20:" MONTHLY >G20:" QUARTER >F20:" SEMI-ANN >E20:" ANNUAL >D20:" RATE >A20:+A19+1 >H19:/-- >G19:/-- >F19:/-- >E19:" -------- >D19:" NOMINAL >A19:+A18+1 >H18:" IS PAI(((1+(+D23/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F23:@IF(D5=0,0,@INT(((1+(+D23/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E23:@IF(D5=0,0,@INT((1+(+D23/E16/100))^H16-1*100+.0005*1000)/1000) >D23:/F$+D5 >A23:+A22+1 >A22:+A21+1 >H21:" =====6/100))^182)-1/182*H16*100+.0005*1000)/1000) >E24:@IF(D5=0,0,@INT((1+(+D24/E16/100))^H16-1*100+.0005*1000)/1000) >D24:/F$+D23+.01 >A24:+A23+1 >H23:@IF(D5=0,0,@INT(((1+(+D23/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G23:@IF(D5=0,0,@INT.0005*1000)/1000) >D25:/F$+D24+.01 >A25:+A24+1 >H24:@IF(D5=0,0,@INT(((1+(+D24/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G24:@IF(D5=0,0,@INT(((1+(+D24/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F24:@IF(D5=0,0,@INT(((1+(+D24/E16667)-1/30.41666667*H16*100+.0005*1000)/1000) >G25:@IF(D5=0,0,@INT(((1+(+D25/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F25:@IF(D5=0,0,@INT(((1+(+D25/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E25:@IF(D5=0,0,@INT((1+(+D25/E16/100))^H16-1*100+/91.25*H16*100+.0005*1000)/1000) >F26:@IF(D5=0,0,@INT(((1+(+D26/E16/100))^182)-1/182*H16*100+.0005*1000)/1000) >E26:@IF(D5=0,0,@INT((1+(+D26/E16/100))^H16-1*100+.0005*1000)/1000) >D26:/F$+D25+.01 >A26:+A25+1 >H25:@IF(D5=0,0,@INT(((1+(+D25/E16/100))^30.4166005*1000)/1000) >E27:@IF(D5=0,0,@INT((1+(+D27/E16/100))^H16-1*100+.0005*1000)/1000) >D27:/F$+D26+.01 >A27:+A26+1 >H26:@IF(D5=0,0,@INT(((1+(+D26/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G26:@IF(D5=0,0,@INT(((1+(+D26/E16/100))^91.25)-17+.01 >A28:+A27+1 >H27:@IF(D5=0,0,@INT(((1+(+D27/E16/100))^30.41666667)-1/30.41666667*H16*100+.0005*1000)/1000) >G27:@IF(D5=0,0,@INT(((1+(+D27/E16/100))^91.25)-1/91.25*H16*100+.0005*1000)/1000) >F27:@IF(D5=0,0,@INT(((1+(+D27/E16/100))^182)-1/182*H16*100+.050:+A49+1 >C49:((1+(B49/365)^365)-1*100 >B49:+B48+.0005 >A49:+A48+1 >C48:((1+(B48/365)^365)-1*100 >B48:+B47+.0005 >A48:+A47+1 >C47:((1+(B47/365)^365)-1*100 >B47:+B46+.0005 >A47:+A46+1 >C46:((1+(B46/365)^365)-1*100 >B46:+B45+.0005 >A46:+A45+1 >C45:((1+(B45/ >B59:"........... >A59:/FI+A58+1 >M58:/FI+L58/I58 >L58:/F$+D58-K58 >K58:/F$(H58*I58)+J58 >J58:+D58-G58 >I58:/F$((G58-E58)/F58)/365 >H58:/FG" ........ >G58:/F$" ........ >F58:/F$" ....... >E58:/F$" ....... >D58:/F$" ....... >C58:"........... >>K61:/F$ >I61:/F$ >K60:/F$ >I60:/F$ >M59:/FI+L59/I59 >L59:/F$+D59-K59 >K59:/F$(H59*I59)+J59 >J59:+D59-G59 >I59:/F$((G59-E59)/F59)/365 >H59:/FG" ........ >G59:/F$" ........ >F59:/F$" ....... >E59:/F$" ....... >D59:/F$" ....... >C59:"........... C >B2:" B >A2:+A1+1 >D1:"YIELD >C1:" COMPOUND >B1:"MODEL 7 - >A1:1 /W1 /GOC /GRM /GC10 /X>A1:>A1: 10:+B9+.0005 >A10:+A9+1 >C9:((1+(B9/365)^365)-1*100 >B9:+D3 >A9:+A8+1 >A8:+A7+1 >C7:" RATE >B7:" RATE >A7:+A6+1 >C6:"CMPD DAILY >B6:" NOMINAL >A6:+A5+1 >A5:+A4+1 >A4:+A3+1 >D3:" ....... >C3:"NG RATE IS >B3:" BEGINNI >A3:+A2+1 >D2:" D >C2:" +(B14/365)^365)-1*100 >B14:+B13+.0005 >A14:+A13+1 >C13:((1+(B13/365)^365)-1*100 >B13:+B12+.0005 >A13:+A12+1 >C12:((1+(B12/365)^365)-1*100 >B12:+B11+.0005 >A12:+A11+1 >C11:((1+(B11/365)^365)-1*100 >B11:+B10+.0005 >A11:+A10+1 >C10:((1+(B10/365)^365)-1*100 >B005 >A19:+A18+1 >C18:((1+(B18/365)^365)-1*100 >B18:+B17+.0005 >A18:+A17+1 >C17:((1+(B17/365)^365)-1*100 >B17:+B16+.0005 >A17:+A16+1 >C16:((1+(B16/365)^365)-1*100 >B16:+B15+.0005 >A16:+A15+1 >C15:((1+(B15/365)^365)-1*100 >B15:+B14+.0005 >A15:+A14+1 >C14:((1^365)-1*100 >B23:+B22+.0005 >A23:+A22+1 >C22:((1+(B22/365)^365)-1*100 >B22:+B21+.0005 >A22:+A21+1 >C21:((1+(B21/365)^365)-1*100 >B21:+B20+.0005 >A21:+A20+1 >C20:((1+(B20/365)^365)-1*100 >B20:+B19+.0005 >A20:+A19+1 >C19:((1+(B19/365)^365)-1*100 >B19:+B18+.0A27+1 >C27:((1+(B27/365)^365)-1*100 >B27:+B26+.0005 >A27:+A26+1 >C26:((1+(B26/365)^365)-1*100 >B26:+B25+.0005 >A26:+A25+1 >C25:((1+(B25/365)^365)-1*100 >B25:+B24+.0005 >A25:+A24+1 >C24:((1+(B24/365)^365)-1*100 >B24:+B23+.0005 >A24:+A23+1 >C23:((1+(B23/365)0 >B32:+B31+.0005 >A32:+A31+1 >C31:((1+(B31/365)^365)-1*100 >B31:+B30+.0005 >A31:+A30+1 >C30:((1+(B30/365)^365)-1*100 >B30:+B29+.0005 >A30:+A29+1 >C29:((1+(B29/365)^365)-1*100 >B29:+B28+.0005 >A29:+A28+1 >C28:((1+(B28/365)^365)-1*100 >B28:+B27+.0005 >A28:+:((1+(B36/365)^365)-1*100 >B36:+B35+.0005 >A36:+A35+1 >C35:((1+(B35/365)^365)-1*100 >B35:+B34+.0005 >A35:+A34+1 >C34:((1+(B34/365)^365)-1*100 >B34:+B33+.0005 >A34:+A33+1 >C33:((1+(B33/365)^365)-1*100 >B33:+B32+.0005 >A33:+A32+1 >C32:((1+(B32/365)^365)-1*100+.0005 >A41:+A40+1 >C40:((1+(B40/365)^365)-1*100 >B40:+B39+.0005 >A40:+A39+1 >C39:((1+(B39/365)^365)-1*100 >B39:+B38+.0005 >A39:+A38+1 >C38:((1+(B38/365)^365)-1*100 >B38:+B37+.0005 >A38:+A37+1 >C37:((1+(B37/365)^365)-1*100 >B37:+B36+.0005 >A37:+A36+1 >C36365)^365)-1*100 >B45:+B44+.0005 >A45:+A44+1 >C44:((1+(B44/365)^365)-1*100 >B44:+B43+.0005 >A44:+A43+1 >C43:((1+(B43/365)^365)-1*100 >B43:+B42+.0005 >A43:+A42+1 >C42:((1+(B42/365)^365)-1*100 >B42:+B41+.0005 >A42:+A41+1 >C41:((1+(B41/365)^365)-1*100 >B41:+B4B58:"........... >A58:/FI+A57+1 >M57:/FI+L57/I57 >L57:/F$+D57-K57 >K57:/F$(H57*I57)+J57 >J57:+D57-G57 >I57:/F$((G57-E57)/F57)/365 >H57:/FG" ........ >G57:/F$" ........ >F57:/F$" ....... >E57:/F$" ....... >D57:/F$" ....... >C57:"........... >B53+1 >M43:/FI+L43/I43 >L43:/F$+D43-K43 >K43:/F$(H43*I43)+J43 >J43:+D43-G43 >I43:/F$((G43-E43)/F43)/365 >H43:/FG" ........ >G43:/F$" ........ >F43:/F$" ....... >E43:/F$" ....... >D43:/F$" ....... >C43:"........... >B43:"........... >A43:/FI+A42+A44+1 >M44:/FI+L44/I44 >L44:/F$+D44-K44 >K44:/F$(H44*I44)+J44 >J44:+D44-G44 >I44:/F$((G44-E44)/F44)/365 >H44:/FG" ........ >G44:/F$" ........ >F44:/F$" ....... >E44:/F$" ....... >D44:/F$" ....... >C44:"........... >B44:"........... >A44:/FI+A4I+A45+1 >M45:/FI+L45/I45 >L45:/F$+D45-K45 >K45:/F$(H45*I45)+J45 >J45:+D45-G45 >I45:/F$((G45-E45)/F45)/365 >H45:/FG" ........ >G45:/F$" ........ >F45:/F$" ....... >E45:/F$" ....... >D45:/F$" ....... >C45:"........... >B45:"........... >A45:/FI+/FI+A46+1 >M46:/FI+L46/I46 >L46:/F$+D46-K46 >K46:/F$(H46*I46)+J46 >J46:+D46-G46 >I46:/F$((G46-E46)/F46)/365 >H46:/FG" ........ >G46:/F$" ........ >F46:/F$" ....... >E46:/F$" ....... >D46:/F$" ....... >C46:"........... >B46:"........... >A46:/F8:/FI+A47+1 >M47:/FI+L47/I47 >L47:/F$+D47-K47 >K47:/F$(H47*I47)+J47 >J47:+D47-G47 >I47:/F$((G47-E47)/F47)/365 >H47:/FG" ........ >G47:/F$" ........ >F47:/F$" ....... >E47:/F$" ....... >D47:/F$" ....... >C47:"........... >B47:"........... >A47:A49:/FI+A48+1 >M48:/FI+L48/I48 >L48:/F$+D48-K48 >K48:/F$(H48*I48)+J48 >J48:+D48-G48 >I48:/F$((G48-E48)/F48)/365 >H48:/FG" ........ >G48:/F$" ........ >F48:/F$" ....... >E48:/F$" ....... >D48:/F$" ....... >C48:"........... >B48:"........... >A4 >A50:/FI+A49+1 >M49:/FI+L49/I49 >L49:/F$+D49-K49 >K49:/F$(H49*I49)+J49 >J49:+D49-G49 >I49:/F$((G49-E49)/F49)/365 >H49:/FG" ........ >G49:/F$" ........ >F49:/F$" ....... >E49:/F$" ....... >D49:/F$" ....... >C49:"........... >B49:"........... >.. >A51:/FI+A50+1 >M50:/FI+L50/I50 >L50:/F$+D50-K50 >K50:/F$(H50*I50)+J50 >J50:+D50-G50 >I50:/F$((G50-E50)/F50)/365 >H50:/FG" ........ >G50:/F$" ........ >F50:/F$" ....... >E50:/F$" ....... >D50:/F$" ....... >C50:"........... >B50:"............... >A52:/FI+A51+1 >M51:/FI+L51/I51 >L51:/F$+D51-K51 >K51:/F$(H51*I51)+J51 >J51:+D51-G51 >I51:/F$((G51-E51)/F51)/365 >H51:/FG" ........ >G51:/F$" ........ >F51:/F$" ....... >E51:/F$" ....... >D51:/F$" ....... >C51:"........... >B51:"............... >A53:/FI+A52+1 >M52:/FI+L52/I52 >L52:/F$+D52-K52 >K52:/F$(H52*I52)+J52 >J52:+D52-G52 >I52:/F$((G52-E52)/F52)/365 >H52:/FG" ........ >G52:/F$" ........ >F52:/F$" ....... >E52:/F$" ....... >D52:/F$" ....... >C52:"........... >B52:"............... >A54:/FI+A53+1 >M53:/FI+L53/I53 >L53:/F$+D53-K53 >K53:/F$(H53*I53)+J53 >J53:+D53-G53 >I53:/F$((G53-E53)/F53)/365 >H53:/FG" ........ >G53:/F$" ........ >F53:/F$" ....... >E53:/F$" ....... >D53:/F$" ....... >C53:"........... >B53:"............... >A55:/FI+A54+1 >M54:/FI+L54/I54 >L54:/F$+D54-K54 >K54:/F$(H54*I54)+J54 >J54:+D54-G54 >I54:/F$((G54-E54)/F54)/365 >H54:/FG" ........ >G54:/F$" ........ >F54:/F$" ....... >E54:/F$" ....... >D54:/F$" ....... >C54:"........... >B54:"..."........... >A56:/FI+A55+1 >M55:/FI+L55/I55 >L55:/F$+D55-K55 >K55:/F$(H55*I55)+J55 >J55:+D55-G55 >I55:/F$((G55-E55)/F55)/365 >H55:/FG" ........ >G55:/F$" ........ >F55:/F$" ....... >E55:/F$" ....... >D55:/F$" ....... >C55:"........... >B55:".7:"........... >A57:/FI+A56+1 >M56:/FI+L56/I56 >L56:/F$+D56-K56 >K56:/F$(H56*I56)+J56 >J56:+D56-G56 >I56:/F$((G56-E56)/F56)/365 >H56:/FG" ........ >G56:/F$" ........ >F56:/F$" ....... >E56:/F$" ....... >D56:/F$" ....... >C56:"........... >B56:1 >M42:/FI+L42/I42 >L42:/F$+D42-K42 >K42:/F$(H42*I42)+J42 >J42:+D42-G42 >I42:/F$((G42-E42)/F42)/365 >H42:/FG" ........ >G42:/F$" ........ >F42:/F$" ....... >E42:/F$" ....... >D42:/F$" ....... >C42:"........... >B42:"........... >A42:/FI+A41+1 >M41:/FI+L41/I41 >L41:/F$+D41-K41 >K41:/F$(H41*I41)+J41 >J41:+D41-G41 >I41:/F$((G41-E41)/F41)/365 >H41:/FG" ........ >G41:/F$" ........ >F41:/F$" ....... >E41:/F$" ....... >D41:/F$" ....... >C41:"........... >B41:"........... >A41:/FI+A40+1 >M7-K27 >K27:/F$(H27*I27)+J27 >J27:+D27-G27 >I27:/F$((G27-E27)/F27)/365 >H27:/FG" ........ >G27:/F$" ........ >F27:/F$" ....... >E27:/F$" ....... >D27:/F$" ....... >C27:"........... >B27:"........... >A27:/FI+A26+1 >M26:/FI+L26/I26 >L26:/F$+D26-D28-K28 >K28:/F$(H28*I28)+J28 >J28:+D28-G28 >I28:/F$((G28-E28)/F28)/365 >H28:/FG" ........ >G28:/F$" ........ >F28:/F$" ....... >E28:/F$" ....... >D28:/F$" ....... >C28:"........... >B28:"........... >A28:/FI+A27+1 >M27:/FI+L27/I27 >L27:/F$+D2$+D29-K29 >K29:/F$(H29*I29)+J29 >J29:+D29-G29 >I29:/F$((G29-E29)/F29)/365 >H29:/FG" ........ >G29:/F$" ........ >F29:/F$" ....... >E29:/F$" ....... >D29:/F$" ....... >C29:"........... >B29:"........... >A29:/FI+A28+1 >M28:/FI+L28/I28 >L28:/F$+/F$+D30-K30 >K30:/F$(H30*I30)+J30 >J30:+D30-G30 >I30:/F$((G30-E30)/F30)/365 >H30:/FG" ........ >G30:/F$" ........ >F30:/F$" ....... >E30:/F$" ....... >D30:/F$" ....... >C30:"........... >B30:"........... >A30:/FI+A29+1 >M29:/FI+L29/I29 >L29:/F1:/F$+D31-K31 >K31:/F$(H31*I31)+J31 >J31:+D31-G31 >I31:/F$((G31-E31)/F31)/365 >H31:/FG" ........ >G31:/F$" ........ >F31:/F$" ....... >E31:/F$" ....... >D31:/F$" ....... >C31:"........... >B31:"........... >A31:/FI+A30+1 >M30:/FI+L30/I30 >L30:L32:/F$+D32-K32 >K32:/F$(H32*I32)+J32 >J32:+D32-G32 >I32:/F$((G32-E32)/F32)/365 >H32:/FG" ........ >G32:/F$" ........ >F32:/F$" ....... >E32:/F$" ....... >D32:/F$" ....... >C32:"........... >B32:"........... >A32:/FI+A31+1 >M31:/FI+L31/I31 >L3 >L33:/F$+D33-K33 >K33:/F$(H33*I33)+J33 >J33:+D33-G33 >I33:/F$((G33-E33)/F33)/365 >H33:/FG" ........ >G33:/F$" ........ >F33:/F$" ....... >E33:/F$" ....... >D33:/F$" ....... >C33:"........... >B33:"........... >A33:/FI+A32+1 >M32:/FI+L32/I32 >34 >L34:/F$+D34-K34 >K34:/F$(H34*I34)+J34 >J34:+D34-G34 >I34:/F$((G34-E34)/F34)/365 >H34:/FG" ........ >G34:/F$" ........ >F34:/F$" ....... >E34:/F$" ....... >D34:/F$" ....... >C34:"........... >B34:"........... >A34:/FI+A33+1 >M33:/FI+L33/I33/I35 >L35:/F$+D35-K35 >K35:/F$(H35*I35)+J35 >J35:+D35-G35 >I35:/F$((G35-E35)/F35)/365 >H35:/FG" ........ >G35:/F$" ........ >F35:/F$" ....... >E35:/F$" ....... >D35:/F$" ....... >C35:"........... >B35:"........... >A35:/FI+A34+1 >M34:/FI+L34/I36/I36 >L36:/F$+D36-K36 >K36:/F$(H36*I36)+J36 >J36:+D36-G36 >I36:/F$((G36-E36)/F36)/365 >H36:/FG" ........ >G36:/F$" ........ >F36:/F$" ....... >E36:/F$" ....... >D36:/F$" ....... >C36:"........... >B36:"........... >A36:/FI+A35+1 >M35:/FI+L35+L37/I37 >L37:/F$+D37-K37 >K37:/F$(H37*I37)+J37 >J37:+D37-G37 >I37:/F$((G37-E37)/F37)/365 >H37:/FG" ........ >G37:/F$" ........ >F37:/F$" ....... >E37:/F$" ....... >D37:/F$" ....... >C37:"........... >B37:"........... >A37:/FI+A36+1 >M36:/FI+LFI+L38/I38 >L38:/F$+D38-K38 >K38:/F$(H38*I38)+J38 >J38:+D38-G38 >I38:/F$((G38-E38)/F38)/365 >H38:/FG" ........ >G38:/F$" ........ >F38:/F$" ....... >E38:/F$" ....... >D38:/F$" ....... >C38:"........... >B38:"........... >A38:/FI+A37+1 >M37:/FI:/FI+L39/I39 >L39:/F$+D39-K39 >K39:/F$(H39*I39)+J39 >J39:+D39-G39 >I39:/F$((G39-E39)/F39)/365 >H39:/FG" ........ >G39:/F$" ........ >F39:/F$" ....... >E39:/F$" ....... >D39:/F$" ....... >C39:"........... >B39:"........... >A39:/FI+A38+1 >M38:/40:/FI+L40/I40 >L40:/F$+D40-K40 >K40:/F$(H40*I40)+J40 >J40:+D40-G40 >I40:/F$((G40-E40)/F40)/365 >H40:/FG" ........ >G40:/F$" ........ >F40:/F$" ....... >E40:/F$" ....... >D40:/F$" ....... >C40:"........... >B40:"........... >A40:/FI+A39+1 >M39K26 >K26:/F$(H26*I26)+J26 >J26:+D26-G26 >I26:/F$((G26-E26)/F26)/365 >H26:/FG" ........ >G26:/F$" ........ >F26:/F$" ....... >E26:/F$" ....... >D26:/F$" ....... >C26:"........... >B26:"........... >A26:/FI+A25+1 >M25:/FI+L25/I25 >L25:/F$+D25-K25 >K25:/F$(H25*I25)+J25 >J25:+D25-G25 >I25:/F$((G25-E25)/F25)/365 >H25:/FG" ........ >G25:/F$" ........ >F25:/F$" ....... >E25:/F$" ....... >D25:/F$" ....... >C25:"........... >B25:"........... >A25:/FI+A24+1 >M24:/FI+L24/I24 >L24:/F$+D24-K24 :+D11-G11 >I11:/F$((G11-E11)/F11)/365 >H11:/FG" ........ >G11:/F$" ........ >F11:/F$" ....... >E11:/F$" ....... >D11:/F$" ....... >C11:"........... >B11:"........... >A11:/FI+A10+1 >M10:/FI+L10/I10 >L10:/F$+D10-K10 >K10:/F$(H10*I10)+J10 >J10:+12:+D12-G12 >I12:/F$((G12-E12)/F12)/365 >H12:/FG" ........ >G12:/F$" ........ >F12:/F$" ....... >E12:/F$" ....... >D12:/F$" ....... >C12:"........... >B12:"........... >A12:/FI+A11+1 >M11:/FI+L11/I11 >L11:/F$+D11-K11 >K11:/F$(H11*I11)+J11 >J11>J13:+D13-G13 >I13:/F$((G13-E13)/F13)/365 >H13:/FG" ........ >G13:/F$" ........ >F13:/F$" ....... >E13:/F$" ....... >D13:/F$" ....... >C13:"........... >B13:"........... >A13:/FI+A12+1 >M12:/FI+L12/I12 >L12:/F$+D12-K12 >K12:/F$(H12*I12)+J12 >J4 >J14:+D14-G14 >I14:/F$((G14-E14)/F14)/365 >H14:/FG" ........ >G14:/F$" ........ >F14:/F$" ....... >E14:/F$" ....... >D14:/F$" ....... >C14:"........... >B14:"........... >A14:/FI+A13+1 >M13:/FI+L13/I13 >L13:/F$+D13-K13 >K13:/F$(H13*I13)+J13 J15 >J15:+D15-G15 >I15:/F$((G15-E15)/F15)/365 >H15:/FG" ........ >G15:/F$" ........ >F15:/F$" ....... >E15:/F$" ....... >D15:/F$" ....... >C15:"........... >B15:"........... >A15:/FI+A14+1 >M14:/FI+L14/I14 >L14:/F$+D14-K14 >K14:/F$(H14*I14)+J1)+J16 >J16:+D16-G16 >I16:/F$((G16-E16)/F16)/365 >H16:/FG" ........ >G16:/F$" ........ >F16:/F$" ....... >E16:/F$" ....... >D16:/F$" ....... >C16:"........... >B16:"........... >A16:/FI+A15+1 >M15:/FI+L15/I15 >L15:/F$+D15-K15 >K15:/F$(H15*I15)+17)+J17 >J17:+D17-G17 >I17:/F$((G17-E17)/F17)/365 >H17:/FG" ........ >G17:/F$" ........ >F17:/F$" ....... >E17:/F$" ....... >D17:/F$" ....... >C17:"........... >B17:"........... >A17:/FI+A16+1 >M16:/FI+L16/I16 >L16:/F$+D16-K16 >K16:/F$(H16*I16*I18)+J18 >J18:+D18-G18 >I18:/F$((G18-E18)/F18)/365 >H18:/FG" ........ >G18:/F$" ........ >F18:/F$" ....... >E18:/F$" ....... >D18:/F$" ....... >C18:"........... >B18:"........... >A18:/FI+A17+1 >M17:/FI+L17/I17 >L17:/F$+D17-K17 >K17:/F$(H17*I19*I19)+J19 >J19:+D19-G19 >I19:/F$((G19-E19)/F19)/365 >H19:/FG" ........ >G19:/F$" ........ >F19:/F$" ....... >E19:/F$" ....... >D19:/F$" ....... >C19:"........... >B19:"........... >A19:/FI+A18+1 >M18:/FI+L18/I18 >L18:/F$+D18-K18 >K18:/F$(H18(H20*I20)+J20 >J20:+D20-G20 >I20:/F$((G20-E20)/F20)/365 >H20:/FG" ........ >G20:/F$" ........ >F20:/F$" ....... >E20:/F$" ....... >D20:/F$" ....... >C20:"........... >B20:"........... >A20:/FI+A19+1 >M19:/FI+L19/I19 >L19:/F$+D19-K19 >K19:/F$(HF$(H21*I21)+J21 >J21:+D21-G21 >I21:/F$((G21-E21)/F21)/365 >H21:/FG" ........ >G21:/F$" ........ >F21:/F$" ....... >E21:/F$" ....... >D21:/F$" ....... >C21:"........... >B21:"........... >A21:/FI+A20+1 >M20:/FI+L20/I20 >L20:/F$+D20-K20 >K20:/F$:/F$(H22*I22)+J22 >J22:+D22-G22 >I22:/F$((G22-E22)/F22)/365 >H22:/FG" ........ >G22:/F$" ........ >F22:/F$" ....... >E22:/F$" ....... >D22:/F$" ....... >C22:"........... >B22:"........... >A22:/FI+A21+1 >M21:/FI+L21/I21 >L21:/F$+D21-K21 >K21:/23:/F$(H23*I23)+J23 >J23:+D23-G23 >I23:/F$((G23-E23)/F23)/365 >H23:/FG" ........ >G23:/F$" ........ >F23:/F$" ....... >E23:/F$" ....... >D23:/F$" ....... >C23:"........... >B23:"........... >A23:/FI+A22+1 >M22:/FI+L22/I22 >L22:/F$+D22-K22 >K22>K24:/F$(H24*I24)+J24 >J24:+D24-G24 >I24:/F$((G24-E24)/F24)/365 >H24:/FG" ........ >G24:/F$" ........ >F24:/F$" ....... >E24:/F$" ....... >D24:/F$" ....... >C24:"........... >B24:"........... >A24:/FI+A23+1 >M23:/FI+L23/I23 >L23:/F$+D23-K23 >KD10-G10 >I10:/F$((G10-E10)/F10)/365 >H10:/FG" ........ >G10:/F$" ........ >F10:/F$" ....... >E10:/F$" ....... >D10:/F$" ....... >C10:"........... >B10:"........... >A10:/FI+A9+1 >M9:"=========== >L9:"=========== >K9:"=========== >J9:"=========== >I9:"=========== >H9:"=========== >G9:"=========== >F9:"=========== >E9:"=========== >D9:"=========== >C9:"=========== >B9:"=========== >A9:/FI+A8+1 >M8:/FR" ! TO DEPR >L8:/FR" ! BOOK >K8:/FR" ! DEPR >J8:/FR" ! COST >I8:/FR" ! ACCRUAL >H8:*(G29-1)))),0) >G29:/FI" ... >F29:/FI" ... >E29:/FI" ... >D29:" ...... >C29:/-. >B29:" ........ >A29:/FI+A28+1 >S28:.01*@INT(.5+(100*(D28/G28) >R28:(12*F28)+E28 >P28:@IF(@AND(J28<>0,P8=J28),+H28,0) >O28:@IF(@AND(J28<>0,O8=J28),+H28,0) >N2829,0) >M29:@IF(@AND(J29<>0,M8=J29),+H29,0) >L29:@IF(@AND(J29<>0,L8=J29),+H29,0) >K29:@IF(@AND(J29<>0,K8=J29),+H29,0) >J29:/FI" ....... >I29:@IF(R6>=(R29-1+G29),0,D29-((R6-R29+1)*H29)) >H29:@IF(@AND(R6>=R29,R6<=(R29+G29-1)),@IF(R6<(R29+G29-1),S29,(D29-(S29 ... >F30:/FI" ... >E30:/FI" ... >D30:" ...... >C30:/-. >B30:" ........ >A30:/FI+A29+1 >S29:.01*@INT(.5+(100*(D29/G29) >R29:(12*F29)+E29 >P29:@IF(@AND(J29<>0,P8=J29),+H29,0) >O29:@IF(@AND(J29<>0,O8=J29),+H29,0) >N29:@IF(@AND(J29<>0,N8=J29),+HM8=J30),+H30,0) >L30:@IF(@AND(J30<>0,L8=J30),+H30,0) >K30:@IF(@AND(J30<>0,K8=J30),+H30,0) >J30:/FI" ....... >I30:@IF(R6>=(R30-1+G30),0,D30-((R6-R30+1)*H30)) >H30:@IF(@AND(R6>=R30,R6<=(R30+G30-1)),@IF(R6<(R30+G30-1),S30,(D30-(S30*(G30-1)))),0) >G30:/FI" :/-- >G31:/-- >F31:/-- >E31:/-- >D31:/-- >C31:/-- >B31:/-- >A31:/FI+A30+1 >S30:.01*@INT(.5+(100*(D30/G30) >R30:(12*F30)+E30 >P30:@IF(@AND(J30<>0,P8=J30),+H30,0) >O30:@IF(@AND(J30<>0,O8=J30),+H30,0) >N30:@IF(@AND(J30<>0,N8=J30),+H30,0) >M30:@IF(@AND(J30<>0,>O32:@SUM(O9...O30 >N32:@SUM(N9...N30 >M32:@SUM(M9...M30 >L32:@SUM(L9...L30 >K32:@SUM(K9...K30 >I32:@SUM(I9...I30 >H32:@SUM(H9...H30 >D32:@SUM(D9...D30 >B32:"TOTALS >A32:/FI+A31+1 >P31:/-- >O31:/-- >N31:/-- >M31:/-- >L31:/-- >K31:/-- >J31:/-- >I31:/-- >H31>P34:/-= >O34:/-= >N34:/-= >M34:/-= >L34:/-= >K34:/-= >J34:/-= >I34:/-= >H34:/-= >G34:/-= >F34:/-= >E34:/-= >D34:/-= >C34:/-= >B34:/-= >A34:/FI+A33+1 >P33:@SUM(K32...P32)=H32 >O33:/FR"BALANCE? >N33:"COUNTS IN >M33:/FR"ACC >A33:/FI+A32+1 >P32:@SUM(P9...P30 >F2:" F >E2:" E >D2:" D >C2:" C >B2:" B >A2:/FI+A1+1 >D1:"S >C1:"FIXED ASSET >B1:"MODEL 8 - >A1:/FI1 /W1 /GOC /GRM /GF$ /GC11 /X>A1:>A1: >E6:"=========== >D6:"=========== >C6:"=========== >B6:"=========== >A6:/FI+A5+1 >A5:/FI+A4+1 >D4:/FG"........... >C4:"........... >B4:"DATE RUN >A4:/FI+A3+1 >A3:/FI+A2+1 >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G G7:/FR" !ADJUSTED >F7:/FR" ! LIFE >E7:/FR"! SALVAGE >D7:/FR"ORIGINAL >C7:" ! >B7:" ASSET >A7:/FI+A6+1 >M6:"=========== >L6:"=========== >K6:"=========== >J6:"=========== >I6:"=========== >H6:"=========== >G6:"=========== >F6:"=========== /FR" ! SYSTEM >G8:/FR" ! BALANCE >F8:/FR" ! YEARS >E8:/FR" ! VALUE >D8:/FR"COST >C8:" ! >B8:"DESCRIPTION >A8:/FI+A7+1 >M7:/FR" !DAYS LEFT >L7:/FR" ! CURRENT >K7:/FR" ! ACCUM >J7:/FR" ! OTHER >I7:/FR" ! DAILY >H7:/FR" ! DAYS ON >:@IF(@AND(J28<>0,N8=J28),+H28,0) >M28:@IF(@AND(J28<>0,M8=J28),+H28,0) >L28:@IF(@AND(J28<>0,L8=J28),+H28,0) >K28:@IF(@AND(J28<>0,K8=J28),+H28,0) >J28:/FI" ....... >I28:@IF(R6>=(R28-1+G28),0,D28-((R6-R28+1)*H28)) >H28:@IF(@AND(R6>=R28,R6<=(R28+G28-1)),@IF(R6<(R28+G28-1),S28,(D28-(S28*(G28-1)))),0) >G28:/FI" ... >F28:/FI" ... >E28:/FI" ... >D28:" ...... >C28:/-. >B28:" ........ >A28:/FI+A27+1 >S27:.01*@INT(.5+(100*(D27/G27) >R27:(12*F27)+E27 >P27:@IF(@AND(J27<>0,P8=J27),+H27,0) >O27:@IF(@AND(0) >L21:@IF(@AND(J21<>0,L8=J21),+H21,0) >K21:@IF(@AND(J21<>0,K8=J21),+H21,0) >J21:/FI" ....... >I21:@IF(R6>=(R21-1+G21),0,D21-((R6-R21+1)*H21)) >H21:@IF(@AND(R6>=R21,R6<=(R21+G21-1)),@IF(R6<(R21+G21-1),S21,(D21-(S21*(G21-1)))),0) >G21:/FI" ... >F21:/ ... >D22:" ...... >C22:/-. >B22:" ........ >A22:/FI+A21+1 >S21:.01*@INT(.5+(100*(D21/G21) >R21:(12*F21)+E21 >P21:@IF(@AND(J21<>0,P8=J21),+H21,0) >O21:@IF(@AND(J21<>0,O8=J21),+H21,0) >N21:@IF(@AND(J21<>0,N8=J21),+H21,0) >M21:@IF(@AND(J21<>0,M8=J21),+H21,J22),+H22,0) >K22:@IF(@AND(J22<>0,K8=J22),+H22,0) >J22:/FI" ....... >I22:@IF(R6>=(R22-1+G22),0,D22-((R6-R22+1)*H22)) >H22:@IF(@AND(R6>=R22,R6<=(R22+G22-1)),@IF(R6<(R22+G22-1),S22,(D22-(S22*(G22-1)))),0) >G22:/FI" ... >F22:/FI" ... >E22:/FI" -. >B23:" ........ >A23:/FI+A22+1 >S22:.01*@INT(.5+(100*(D22/G22) >R22:(12*F22)+E22 >P22:@IF(@AND(J22<>0,P8=J22),+H22,0) >O22:@IF(@AND(J22<>0,O8=J22),+H22,0) >N22:@IF(@AND(J22<>0,N8=J22),+H22,0) >M22:@IF(@AND(J22<>0,M8=J22),+H22,0) >L22:@IF(@AND(J22<>0,L8=J23<>0,K8=J23),+H23,0) >J23:/FI" ....... >I23:@IF(R6>=(R23-1+G23),0,D23-((R6-R23+1)*H23)) >H23:@IF(@AND(R6>=R23,R6<=(R23+G23-1)),@IF(R6<(R23+G23-1),S23,(D23-(S23*(G23-1)))),0) >G23:/FI" ... >F23:/FI" ... >E23:/FI" ... >D23:" ...... >C23:/+A23+1 >S23:.01*@INT(.5+(100*(D23/G23) >R23:(12*F23)+E23 >P23:@IF(@AND(J23<>0,P8=J23),+H23,0) >O23:@IF(@AND(J23<>0,O8=J23),+H23,0) >N23:@IF(@AND(J23<>0,N8=J23),+H23,0) >M23:@IF(@AND(J23<>0,M8=J23),+H23,0) >L23:@IF(@AND(J23<>0,L8=J23),+H23,0) >K23:@IF(@AND(:/FI" ....... >I24:@IF(R6>=(R24-1+G24),0,D24-((R6-R24+1)*H24)) >H24:@IF(@AND(R6>=R24,R6<=(R24+G24-1)),@IF(R6<(R24+G24-1),S24,(D24-(S24*(G24-1)))),0) >G24:/FI" ... >F24:/FI" ... >E24:/FI" ... >D24:" ...... >C24:/-. >B24:" ........ >A24:/FI0*(D24/G24) >R24:(12*F24)+E24 >P24:@IF(@AND(J24<>0,P8=J24),+H24,0) >O24:@IF(@AND(J24<>0,O8=J24),+H24,0) >N24:@IF(@AND(J24<>0,N8=J24),+H24,0) >M24:@IF(@AND(J24<>0,M8=J24),+H24,0) >L24:@IF(@AND(J24<>0,L8=J24),+H24,0) >K24:@IF(@AND(J24<>0,K8=J24),+H24,0) >J24=(R25-1+G25),0,D25-((R6-R25+1)*H25)) >H25:@IF(@AND(R6>=R25,R6<=(R25+G25-1)),@IF(R6<(R25+G25-1),S25,(D25-(S25*(G25-1)))),0) >G25:/FI" ... >F25:/FI" ... >E25:/FI" ... >D25:" ...... >C25:/-. >B25:" ........ >A25:/FI+A24+1 >S24:.01*@INT(.5+(1025 >P25:@IF(@AND(J25<>0,P8=J25),+H25,0) >O25:@IF(@AND(J25<>0,O8=J25),+H25,0) >N25:@IF(@AND(J25<>0,N8=J25),+H25,0) >M25:@IF(@AND(J25<>0,M8=J25),+H25,0) >L25:@IF(@AND(J25<>0,L8=J25),+H25,0) >K25:@IF(@AND(J25<>0,K8=J25),+H25,0) >J25:/FI" ....... >I25:@IF(R6>+1)*H26)) >H26:@IF(@AND(R6>=R26,R6<=(R26+G26-1)),@IF(R6<(R26+G26-1),S26,(D26-(S26*(G26-1)))),0) >G26:/FI" ... >F26:/FI" ... >E26:/FI" ... >D26:" ...... >C26:/-. >B26:" ........ >A26:/FI+A25+1 >S25:.01*@INT(.5+(100*(D25/G25) >R25:(12*F25)+EJ26),+H26,0) >O26:@IF(@AND(J26<>0,O8=J26),+H26,0) >N26:@IF(@AND(J26<>0,N8=J26),+H26,0) >M26:@IF(@AND(J26<>0,M8=J26),+H26,0) >L26:@IF(@AND(J26<>0,L8=J26),+H26,0) >K26:@IF(@AND(J26<>0,K8=J26),+H26,0) >J26:/FI" ....... >I26:@IF(R6>=(R26-1+G26),0,D26-((R6-R26=R27,R6<=(R27+G27-1)),@IF(R6<(R27+G27-1),S27,(D27-(S27*(G27-1)))),0) >G27:/FI" ... >F27:/FI" ... >E27:/FI" ... >D27:" ...... >C27:/-. >B27:" ........ >A27:/FI+A26+1 >S26:.01*@INT(.5+(100*(D26/G26) >R26:(12*F26)+E26 >P26:@IF(@AND(J26<>0,P8=J27<>0,O8=J27),+H27,0) >N27:@IF(@AND(J27<>0,N8=J27),+H27,0) >M27:@IF(@AND(J27<>0,M8=J27),+H27,0) >L27:@IF(@AND(J27<>0,L8=J27),+H27,0) >K27:@IF(@AND(J27<>0,K8=J27),+H27,0) >J27:/FI" ....... >I27:@IF(R6>=(R27-1+G27),0,D27-((R6-R27+1)*H27)) >H27:@IF(@AND(R6>FI" ... >E21:/FI" ... >D21:" ...... >C21:/-. >B21:" ........ >A21:/FI+A20+1 >S20:.01*@INT(.5+(100*(D20/G20) >R20:(12*F20)+E20 >P20:@IF(@AND(J20<>0,P8=J20),+H20,0) >O20:@IF(@AND(J20<>0,O8=J20),+H20,0) >N20:@IF(@AND(J20<>0,N8=J20),+H20,0) >M20:@IF(@AND(J20<>0,M8=J20),+H20,0) >L20:@IF(@AND(J20<>0,L8=J20),+H20,0) >K20:@IF(@AND(J20<>0,K8=J20),+H20,0) >J20:/FI" ....... >I20:@IF(R6>=(R20-1+G20),0,D20-((R6-R20+1)*H20)) >H20:@IF(@AND(R6>=R20,R6<=(R20+G20-1)),@IF(R6<(R20+G20-1),S20,(D20-(S20*(G20-1)))),0..... >A14:/FI+A13+1 >S13:.01*@INT(.5+(100*(D13/G13) >R13:(12*F13)+E13 >P13:@IF(@AND(J13<>0,P8=J13),+H13,0) >O13:@IF(@AND(J13<>0,O8=J13),+H13,0) >N13:@IF(@AND(J13<>0,N8=J13),+H13,0) >M13:@IF(@AND(J13<>0,M8=J13),+H13,0) >L13:@IF(@AND(J13<>0,L8=J13),+H13,0) ),+H14,0) >J14:/FI" ....... >I14:@IF(R6>=(R14-1+G14),0,D14-((R6-R14+1)*H14)) >H14:@IF(@AND(R6>=R14,R6<=(R14+G14-1)),@IF(R6<(R14+G14-1),S14,(D14-(S14*(G14-1)))),0) >G14:/FI" ... >F14:/FI" ... >E14:/FI" ... >D14:" ...... >C14:/-. >B14:" ...01*@INT(.5+(100*(D14/G14) >R14:(12*F14)+E14 >P14:@IF(@AND(J14<>0,P8=J14),+H14,0) >O14:@IF(@AND(J14<>0,O8=J14),+H14,0) >N14:@IF(@AND(J14<>0,N8=J14),+H14,0) >M14:@IF(@AND(J14<>0,M8=J14),+H14,0) >L14:@IF(@AND(J14<>0,L8=J14),+H14,0) >K14:@IF(@AND(J14<>0,K8=J14. >I15:@IF(R6>=(R15-1+G15),0,D15-((R6-R15+1)*H15)) >H15:@IF(@AND(R6>=R15,R6<=(R15+G15-1)),@IF(R6<(R15+G15-1),S15,(D15-(S15*(G15-1)))),0) >G15:/FI" ... >F15:/FI" ... >E15:/FI" ... >D15:" ...... >C15:/-. >B15:" ........ >A15:/FI+A14+1 >S14:.R15:(12*F15)+E15 >P15:@IF(@AND(J15<>0,P8=J15),+H15,0) >O15:@IF(@AND(J15<>0,O8=J15),+H15,0) >N15:@IF(@AND(J15<>0,N8=J15),+H15,0) >M15:@IF(@AND(J15<>0,M8=J15),+H15,0) >L15:@IF(@AND(J15<>0,L8=J15),+H15,0) >K15:@IF(@AND(J15<>0,K8=J15),+H15,0) >J15:/FI" ......0,D16-((R6-R16+1)*H16)) >H16:@IF(@AND(R6>=R16,R6<=(R16+G16-1)),@IF(R6<(R16+G16-1),S16,(D16-(S16*(G16-1)))),0) >G16:/FI" ... >F16:/FI" ... >E16:/FI" ... >D16:" ...... >C16:/-. >B16:" ........ >A16:/FI+A15+1 >S15:.01*@INT(.5+(100*(D15/G15) >AND(J16<>0,P8=J16),+H16,0) >O16:@IF(@AND(J16<>0,O8=J16),+H16,0) >N16:@IF(@AND(J16<>0,N8=J16),+H16,0) >M16:@IF(@AND(J16<>0,M8=J16),+H16,0) >L16:@IF(@AND(J16<>0,L8=J16),+H16,0) >K16:@IF(@AND(J16<>0,K8=J16),+H16,0) >J16:/FI" ....... >I16:@IF(R6>=(R16-1+G16),7:@IF(@AND(R6>=R17,R6<=(R17+G17-1)),@IF(R6<(R17+G17-1),S17,(D17-(S17*(G17-1)))),0) >G17:/FI" ... >F17:/FI" ... >E17:/FI" ... >D17:" ...... >C17:/-. >B17:" ........ >A17:/FI+A16+1 >S16:.01*@INT(.5+(100*(D16/G16) >R16:(12*F16)+E16 >P16:@IF(@>O17:@IF(@AND(J17<>0,O8=J17),+H17,0) >N17:@IF(@AND(J17<>0,N8=J17),+H17,0) >M17:@IF(@AND(J17<>0,M8=J17),+H17,0) >L17:@IF(@AND(J17<>0,L8=J17),+H17,0) >K17:@IF(@AND(J17<>0,K8=J17),+H17,0) >J17:/FI" ....... >I17:@IF(R6>=(R17-1+G17),0,D17-((R6-R17+1)*H17)) >H1+G18-1)),@IF(R6<(R18+G18-1),S18,(D18-(S18*(G18-1)))),0) >G18:/FI" ... >F18:/FI" ... >E18:/FI" ... >D18:" ...... >C18:/-. >B18:" ........ >A18:/FI+A17+1 >S17:.01*@INT(.5+(100*(D17/G17) >R17:(12*F17)+E17 >P17:@IF(@AND(J17<>0,P8=J17),+H17,0) ),+H18,0) >N18:@IF(@AND(J18<>0,N8=J18),+H18,0) >M18:@IF(@AND(J18<>0,M8=J18),+H18,0) >L18:@IF(@AND(J18<>0,L8=J18),+H18,0) >K18:@IF(@AND(J18<>0,K8=J18),+H18,0) >J18:/FI" ....... >I18:@IF(R6>=(R18-1+G18),0,D18-((R6-R18+1)*H18)) >H18:@IF(@AND(R6>=R18,R6<=(R18,S19,(D19-(S19*(G19-1)))),0) >G19:/FI" ... >F19:/FI" ... >E19:/FI" ... >D19:" ...... >C19:/-. >B19:" ........ >A19:/FI+A18+1 >S18:.01*@INT(.5+(100*(D18/G18) >R18:(12*F18)+E18 >P18:@IF(@AND(J18<>0,P8=J18),+H18,0) >O18:@IF(@AND(J18<>0,O8=J18<>0,N8=J19),+H19,0) >M19:@IF(@AND(J19<>0,M8=J19),+H19,0) >L19:@IF(@AND(J19<>0,L8=J19),+H19,0) >K19:@IF(@AND(J19<>0,K8=J19),+H19,0) >J19:/FI" ....... >I19:@IF(R6>=(R19-1+G19),0,D19-((R6-R19+1)*H19)) >H19:@IF(@AND(R6>=R19,R6<=(R19+G19-1)),@IF(R6<(R19+G19-1)) >G20:/FI" ... >F20:/FI" ... >E20:/FI" ... >D20:" ...... >C20:/-. >B20:" ........ >A20:/FI+A19+1 >S19:.01*@INT(.5+(100*(D19/G19) >R19:(12*F19)+E19 >P19:@IF(@AND(J19<>0,P8=J19),+H19,0) >O19:@IF(@AND(J19<>0,O8=J19),+H19,0) >N19:@IF(@AND(J19>K13:@IF(@AND(J13<>0,K8=J13),+H13,0) >J13:/FI" ....... >I13:@IF(R6>=(R13-1+G13),0,D13-((R6-R13+1)*H13)) >H13:@IF(@AND(R6>=R13,R6<=(R13+G13-1)),@IF(R6<(R13+G13-1),S13,(D13-(S13*(G13-1)))),0) >G13:/FI" ... >F13:/FI" ... >E13:/FI" ... >D13:" ...... >C13:/-. >B13:" ........ >A13:/FI+A12+1 >S12:.01*@INT(.5+(100*(D12/G12) >R12:(12*F12)+E12 >P12:@IF(@AND(J12<>0,P8=J12),+H12,0) >O12:@IF(@AND(J12<>0,O8=J12),+H12,0) >N12:@IF(@AND(J12<>0,N8=J12),+H12,0) >M12:@IF(@AND(J12<>0,M8=J12),+H12,0) >L12:@IF(@OLUME NAME (/DISKNAME) OR DEVICE NAME (.Dx)"P12);::"80C";a$;:Zb$="CHANGING DISKS"$d=23:=0::"80C";b$;::12).n=12:=20:"MAKE A NEW MENU FOR DISK: ";N$xN$)<2110=N$ :210 I=1L(A$(I),A$))200B$(/ WAP /// SIG MENU.MAKER PROGRAM (v. 6.1) =".D1"210: Coldstart (320: Warmstart &*X=11000: TEXT SLOW-DOWN LOOP ,X.1 CHANGE DISK SUBROUTINE23œ202:2200<RFa$=" YOU MAY SELECT YOUR DISK BY V >B2:" B >A2:/FI+A1+1 >D1:"EXPENSES >C1:"- ACCRUE >B1:"MODEL 9 >A1:/FI1 /W1 /GOC /GRM /GF$ /GC9 /X>A1:>A2: FR"MONTH >A5:/FI+A4+1 >C4:"R >B4:"REPORT FO >A4:/FI+A3+1 >A3:/FI+A2+1 >S2:" S >R2:" R >Q2:" Q >P2:" P >O2:" O >N2:" N >M2:" M >L2:" L >K2:" K >J2:" J >I2:" I >H2:" H >G2:" G >F2:" F >E2:" E >D2:" D >C2:" C >O6:"T CHARGED >N6:"SE ACCOUN >M6:" BY EXPEN >L6:"BREAKDOWN >J6:/FR"TO >I6:/FR"BALANCE >H6:/FR"TOTAL >G6:/FR"OVER HOW >F6:"NING >E6:/FR"BEGIN >D6:/FR"AMOUNT >C6:/FI" .... >B6:/FR"YEAR >A6:/FI+A5+1 >J5:/FR"CHARGE >I5:"UNACCRUED >G5:/FR >C5:/FI" .... >B5:/FR"ACCRUED >C8:"E ACCRUED >B8:/FR"ITEM TO B >A8:/FI+A7+1 >S7:/FR"ROUNDED >P7:/-- >O7:/-- >N7:/-- >M7:/-- >L7:/-- >K7:" -------- >J7:/FR"EXPENSE >I7:/FR"IN ACC # >H7:/FR"MONTHS >G7:/FR"MANY >F7:/-- >E7:" -------- >D7:/FR"TO BE >A7:/FI+A6+1 >R6:/FI(12*C6)+C5>B9:/-= >A9:/FI+A8+1 >S8:/FR"ACCRUAL >R8:/FR"MONTHS >P8:/FI" ........ >O8:/FI" ........ >N8:/FI" ........ >M8:/FI" ........ >L8:/FI" ........ >K8:/FI" ........ >J8:/FR"ACCT # >I8:/FR" ....... >H8:/FR"ACCRUAL >G8:/FR"MONTHS >F8:/FR"YEAR >E8:/FR"MONTH >D8:/0*(G10-1)))),0) >G10:/FI" ... >F10:/FI" ... >E10:/FI" ... >D10:" ...... >C10:/-. >B10:" ........ >A10:/FI+A9+1 >S9:/-= >R9:/-= >P9:/-= >O9:/-= >N9:/-= >M9:/-= >L9:/-= >K9:/-= >J9:/-= >I9:/-= >H9:/-= >G9:/-= >F9:/-= >E9:/-= >D9:/-= >C9:/-= H10,0) >M10:@IF(@AND(J10<>0,M8=J10),+H10,0) >L10:@IF(@AND(J10<>0,L8=J10),+H10,0) >K10:@IF(@AND(J10<>0,K8=J10),+H10,0) >J10:/FI" ....... >I10:@IF(R6>=(R10-1+G10),0,D10-((R6-R10+1)*H10)) >H10:@IF(@AND(R6>=R10,R6<=(R10+G10-1)),@IF(R6<(R10+G10-1),S10,(D10-(S1 ... >F11:/FI" ... >E11:/FI" ... >D11:" ...... >C11:/-. >B11:" ........ >A11:/FI+A10+1 >S10:.01*@INT(.5+(100*(D10/G10) >R10:(12*F10)+E10 >P10:@IF(@AND(J10<>0,P8=J10),+H10,0) >O10:@IF(@AND(J10<>0,O8=J10),+H10,0) >N10:@IF(@AND(J10<>0,N8=J10),+,M8=J11),+H11,0) >L11:@IF(@AND(J11<>0,L8=J11),+H11,0) >K11:@IF(@AND(J11<>0,K8=J11),+H11,0) >J11:/FI" ....... >I11:@IF(R6>=(R11-1+G11),0,D11-((R6-R11+1)*H11)) >H11:@IF(@AND(R6>=R11,R6<=(R11+G11-1)),@IF(R6<(R11+G11-1),S11,(D11-(S11*(G11-1)))),0) >G11:/FI" >E12:/FI" ... >D12:" ...... >C12:/-. >B12:" ........ >A12:/FI+A11+1 >S11:.01*@INT(.5+(100*(D11/G11) >R11:(12*F11)+E11 >P11:@IF(@AND(J11<>0,P8=J11),+H11,0) >O11:@IF(@AND(J11<>0,O8=J11),+H11,0) >N11:@IF(@AND(J11<>0,N8=J11),+H11,0) >M11:@IF(@AND(J11<>0AND(J12<>0,L8=J12),+H12,0) >K12:@IF(@AND(J12<>0,K8=J12),+H12,0) >J12:/FI" ....... >I12:@IF(R6>=(R12-1+G12),0,D12-((R6-R12+1)*H12)) >H12:@IF(@AND(R6>=R12,R6<=(R12+G12-1)),@IF(R6<(R12+G12-1),S12,(D12-(S12*(G12-1)))),0) >G12:/FI" ... >F12:/FI" ... J)=A$(I),1,31)!J/2<>J/2)=4:=+1:ۙ=44B$(J);:J=J+1I:1,180,22:2,280,21:2,2380,23:8A$(1000),B$(1000),C%(511),C$(20),name$(20):=10:=0UCA=128:LCA=UCA+32CT=15 IF PREFIX$= PREFIX$+MID$(B$(I),1 MENU.MAKER TEXT MODULESEG=0"MENU.MAKER"890&*X=11000: TEXT SLOW-DOWN LOOP ,X.1,180,22:2,280,21:2,2380,23:z:A$="LISTING "+B$(I),16,B)$=01:=0::"80C";A$;::12)>=23:=0::"BANKCALC #3 202 :F*=08:"78C";"SORRY BUT MENU.MAKER CAN'T READ PASCAL TEXT FILES."04=10:"78C";"ANY KEY RETURNS TO THE MENU.">G$:::320H: Error Routine 202:U=11:"79C";"BAD PATH ERROR (NO DISK IN DISK DRIVE OR DESIRED FILE ,2))=0"12";џ,6);:ٟ;$П,2))=>12" PM-":" AM-" 1830WW=1530 =26:=21 1600 &:WW=1:0 :SEG=1;".D1/S EG.F" SEG=1".D1/SEG.G"diskname$=3802  CATCH PASCAL TEXT FILES "JUNE":1750M$="JULY":1750M$="AUGUST":1750M$="SEPTEMBER":1750M$="OCTOBER":1750M$="NOVEMBER":1750M$="DECEMBER":1750826);"-";M$;" ";Ѡ,2));", ";"19";Р,2);" ";/П,2))=>13П,2))-12;џ,6);:1780$~240:=24:=0:"@ ..... "DATE.TIME.LINE" ....JM=Ҡ,4,2))BTM1630,1640,1650,1660,1670,1680,1690,1700,1710,1720,1730,1740^M$="JANUARY":1750hM$="FEBRUARY":1750rM$="MARCH":1750|M$="APRIL":1750M$="MAY":1750M$=B$(I),"CAT 0")1140*B$(I),"FONT 0")18504B$(I),"FOTO 0")1930>B$(I),"PASTXT 0")2070H540R\A$="RUNNING "+B$(I),16,B)f"79C";A$;:=0pB$(I),16,B) z::SEG=1".D1/SEG.T"t=+B$(I),16,B) yCT=CT+1I=1:I=2I>2=-1:I=I-2:IBOTM<30THPOS=44I=IBOTM/2)*2:=+IBOTM/2)-1:0=+IBOTM/2-.5):I=IBOTM:I/2=I/2)I=I-1 œ2120B=B$(I),16)," ")-1 B$(I),"BASIC 0")850B$(I),"TEXT 0")890 81+LCA):::: RebootN=THPOS:B$(I);XA<8A>11540bA-7640,660,690,720l:=THPOS:B$(I);v:520: 500THPOS=4:I/2=I/2)I=I-1I=IBOTM THPOS=44:I/2<>I/2)I=I+1I13000Zha$="{,|,~,}; selects; to new disk; 1842:::Z=1980*:=23:=0::"79C";"CONTINUE...?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"10ties. As this is a PD offering, buyer beware takes precidence here. You should find some of these useful. But there is no implied guarantee that any of these models as presented will return information accurate for the 1990s. NOTE #2: THE BOOKS THAT ACCand 3EZP/Appleworks format as well. While these models should hold for the present, please be aware that they all came out in the early 1980s and reflect the situation at that time. Some of these models may require some changes based on today's reali RATHER THAN DIF. We've included Menu.Maker on this disk so that (after you've booted into Business Basic from another disk or off your hard disk) you can look at these files or print them if you like. This information file is available in both Text rt of a continuing attempt to make all formerly commercial Apple /// products (that are not still on the market in some form) available to the /// community. NOTE: WHEN LOADING INTO 3EZ PIECES OR APPLEWORKS, LOAD THE DESIRED MODEL AS A VISICALC FILE may wish to use them as a base for developing his own customized programs. Note that these models can all be pulled into 3EZ Pieces or Appleworks and may be of use to the home user in some form or another. We've put them into the public domain as paftware Houses and contributed to the publication. According to the Introduction: The purpose of this book is to provide bank personnel with Visicalc models which can be used immediately. As the banker gains experience in VC by using these models, he BANKCALC #1 INFORMATION ABOUT THIS DISK : BANKCALC was written by Anthony Powers and published by Micro Book, Inc. of Arlington Heights, Illinois in 1982. It is a collection of 14 VisiCalc models written by community bankers or Banking Industry SoEAD PASCAL TEXT FILES."04=10:"78C";"ANY KEY RETURNS TO THE MENU."!>G$:::".D1/MENU.MAKER",320R",220(204::"79A";""; 2D=1:F=1 <#4;a$ FD=D+1 P#5;a$ZD=60#5;12)dD=60D=1nF=F+1::d$;::Y=1100:Y x13402  CATCH PASCAL TEXT FILES 202 :F*=08:"78C";"SORRY BUT MENU.MAKER CAN'T R".D1/MENU.MAKER",220 d$="" A$="PRINTING "+B$(I),16,B)=01:=0::"80C";A$;:#3,B$(I),16,B)Z=1#3;b$:"78A";b$Z=Z+1:Z=18:1290 1260 #4,B$(I),16,B)#5,".PRINTER"+ž#4#5;12):::".D1/MENU.MAKE30C$="N"C$="n"1160;:=23:=0::"79C";"PRESS ANY KEY TO HALT LISTING": $1020.202 8::Z=1B::=23:=0::"79C";"WOULD YOU LIKE A PRINTED COPY?":1C$:C$<>"Y"C$<>"y"C$<>"N"C$<>"n"1170*C$="N"C$="n"OMPANIED BANKCALC (DISKS 1-2-3) ARE ALL IN THE WAP OFFICE SHOULD YOU NEED TO REFERENCE THEM. On Side One of this disk (III.ZAW.07) you'll find the following Visicalc models: MANAGEMENT MODELS -: Model 1: Variance Analysis of Yields The identification of the causes of month-to-month income variance of assets. -: Model 2: Yield Summary The calculation of monthly yields and costs. -: Model 3: Rate Sensitive Statement of Condition A restatemeay 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 #1INFORMATION 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=====|====|====|====|====|====|====|====|====|====|====|====|====|====|====|===\G interest payments. -: Model 14: Credit Analysis -: A statement spread program for potential commercial borrowers which performs a financial analysis on the borrowers financial statements. -: -: t over the same term, and prepares an IRA disbursement schedule. -: Model 13: All Saver CD Yields Develops the appropriate nominal rate for an All Saver CD, given the permitted effective rate and frequency of Maintains a history of donations to specific charaties. LENDING MODELS -: Model 11: IRA Calculations Calculates the value of an IRA Account at retirement. -: Model 12: IRA Vs. CD Compares an IRA to a CD investmenLine Method. -: Model 9: Accrue Expenses Accrues expenses over a variable number of months and prepares monthly journal entries for the expenses. Side Two ACCOUNTING MODELS (Continued) -: Model 10: Charitable Contributions ble of effective effective annual yields resulting from daily compounding at a nominal interst rate. ACCOUNTING MODELS -: Model 8: Fixed Assets Model Calculates the depreciation for fixed assets using the Streight using the rule of 78s. -: Model 6: Effective Rate Model Produces a table of effective interest rates resulting from daily compounding of a nominal interst rate. -: Model 7: Compound Yield Creates a tant of the Statement of Condition in terms of rate Sensitivity. AMORTIZATION MODELS -: Model 4: Simple Loan Amortization Schedule -: Model 5: Rate of 78 Amortization Model A loan amortization schedule with interest calculated ommunity.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  12405l=ơ):: Routine to back up one directory level.a$=С,l-1) s=a$)a$=a$,s-1)a$,1)="/"5060:s=s-1 5030=a$240( MENU.MAKER 6.10 * Thanks to C.M.Davidson for his help!NOT FOUND.)"X=11000:X:::210Z a$="{,|,~,}; selects; back 1 level;