23 7 3 1 0 0 0 "Principal" 0 1 1 0 0 2 0 " LR-lf=H" 0 3 0 "22 ff=H23" 0 4 0 " MTG1.DO" 0 5 0 "Spread Mo" 0 6 0 "rtgage Te" 0 7 0 "mplate-wm" 1 0 0 "Int Rate" 1 1 3 14.25 1 2 0 "" 1 3 -7 "+B1/1200" 1 4 0 " For:" 1 5 0 "_________" 1 6 0 "_________" 1 7 0 "_________" 2 0 0 "Term" 2 1 1 20 2 2 0 "" 2 3 -1 "+B2*12" 2 5 0 "_________" 2 6 0 "_________" 2 7 0 "_________" 3 0 0 "Beg Year" 3 1 1 1985 3 2 0 " elap>" 3 3 -1 "(12*(A21-1)+(13-B4))*@>(A21,0)*@>(B0,0)" 3 4 0 " Pay to:" 3 5 0 "_________" 3 6 0 "_________" 3 7 0 "_________" 4 0 0 "Beg Month" 4 1 1 4 4 2 0 " Bal Fwd>" 4 3 -3 "(B0*@=(D19,0)+D19)*@>(B0,0)" 4 5 0 "_________" 4 6 0 "_________" 4 7 0 "_________" 5 0 0 "Escrw/mon" 5 1 3 55 5 2 0 " Mon P&I>" 5 3 -3 "(((1+D1)^(D2-D3)*D4*D1/(((1+D1)^(D2-D3))-1))*@ROUND(2)" 5 5 0 "_________" 5 6 0 "_________" 5 7 0 "_________" 7 0 -1 "+B3+A21*@>(B0,0)" 7 1 0 " To Int" 7 2 0 " To Prin" 7 3 0 " Bal Due" 7 4 0 " To Escrw" 7 5 0 " Totl Pmt" 7 6 0 " Check No" 7 7 0 " Date Pd" 8 0 0 " 1 Jan" 8 1 -3 "+D4*D1*@>=(1+(B4*A21),B4)*@ROUND(2)" 8 2 -3 "((+D5-B8)*@>((D4-B8),D5)+(D4*@<=((D4-B8),D5)))*@>(B8,0)" 8 3 -3 "+D4-C8" 8 4 -3 "+B5*@>(B8,0)" 8 5 -3 "+B8+C8+E8" 8 6 0 " ________" 8 7 0 " ________" 9 0 0 " 2 Feb" 9 1 -3 "+D8*D1*@>=(2+(B4*A21),B4)*@ROUND(2)" 9 2 -3 "((+D5-B9)*@>((D8-B9),D5)+(D8*@<=((D8-B9),D5)))*@>(B9,0)" 9 3 -3 "+D8-C9" 9 4 -3 "+B5*@>(B9,0)" 9 5 -3 "+B9+C9+E9" 9 6 0 " ________" 9 7 0 " ________" 10 0 0 " 3 Mar" 10 1 -3 "+D9*D1*@>=(3+(B4*A21),B4)*@ROUND(2)" 10 2 -3 "((+D5-B10)*@>((D9-B10),D5)+(D9*@<=((D9-B10),D5)))*@>(B10,0)" 10 3 -3 "+D9-C10" 10 4 -3 "+B5*@>(B10,0)" 10 5 -3 "+B10+C10+E10" 10 6 0 " ________" 10 7 0 " ________" 11 0 0 " 4 Apr" 11 1 -3 "+D10*D1*@>=(4+(B4*A21),B4)*@ROUND(2)" 11 2 -3 "((+D5-B11)*@>((D10-B11),D5)+(D10*@<=((D10-B11),D5)))*@>(B11,0)" 11 3 -3 "+D10-C11" 11 4 -3 "+B5*@>(B11,0)" 11 5 -3 "+B11+C11+E11" 11 6 0 " ________" 11 7 0 " ________" 12 0 0 " 5 May" 12 1 -3 "+D11*D1*@>=(5+(B4*A21),B4)*@ROUND(2)" 12 2 -3 "((+D5-B12)*@>((D11-B12),D5)+(D11*@<=((D11-B12),D5)))*@>(B12,0)" 12 3 -3 "+D11-C12" 12 4 -3 "+B5*@>(B12,0)" 12 5 -3 "+B12+C12+E12" 12 6 0 " ________" 12 7 0 " ________" 13 0 0 " 6 Jun" 13 1 -3 "+D12*D1*@>=(6+(B4*A21),B4)*@ROUND(2)" 13 2 -3 "((+D5-B13)*@>((D12-B13),D5)+(D12*@<=((D12-B13),D5)))*@>(B13,0)" 13 3 -3 "+D12-C13" 13 4 -3 "+B5*@>(B13,0)" 13 5 -3 "+B13+C13+E13" 13 6 0 " ________" 13 7 0 " ________" 14 0 0 " 7 Jul" 14 1 -3 "+D13*D1*@>=(7+(B4*A21),B4)*@ROUND(2)" 14 2 -3 "((+D5-B14)*@>((D13-B14),D5)+(D13*@<=((D13-B14),D5)))*@>(B14,0)" 14 3 -3 "+D13-C14" 14 4 -3 "+B5*@>(B14,0)" 14 5 -3 "+B14+C14+E14" 14 6 0 " ________" 14 7 0 " ________" 15 0 0 " 8 Aug" 15 1 -3 "+D14*D1*@>=(8+(B4*A21),B4)*@ROUND(2)" 15 2 -3 "((+D5-B15)*@>((D14-B15),D5)+(D14*@<=((D14-B15),D5)))*@>(B15,0)" 15 3 -3 "+D14-C15" 15 4 -3 "+B5*@>(B15,0)" 15 5 -3 "+B15+C15+E15" 15 6 0 " ________" 15 7 0 " ________" 16 0 0 " 9 Sep" 16 1 -3 "+D15*D1*@>=(9+(B4*A21),B4)*@ROUND(2)" 16 2 -3 "((+D5-B16)*@>((D15-B16),D5)+(D15*@<=((D15-B16),D5)))*@>(B16,0)" 16 3 -3 "+D15-C16" 16 4 -3 "+B5*@>(B16,0)" 16 5 -3 "+B16+C16+E16" 16 6 0 " ________" 16 7 0 " ________" 17 0 0 " 10 Oct" 17 1 -3 "+D16*D1*@>=(10+(B4*A21),B4)*@ROUND(2)" 17 2 -3 "((+D5-B17)*@>((D16-B17),D5)+(D16*@<=((D16-B17),D5)))*@>(B17,0)" 17 3 -3 "+D16-C17" 17 4 -3 "+B5*@>(B17,0)" 17 5 -3 "+B17+C17+E17" 17 6 0 " ________" 17 7 0 " ________" 18 0 0 " 11 Nov" 18 1 -3 "+D17*D1*@>=(11+(B4*A21),B4)*@ROUND(2)" 18 2 -3 "((+D5-B18)*@>((D17-B18),D5)+(D17*@<=((D17-B18),D5)))*@>(B18,0)" 18 3 -3 "+D17-C18" 18 4 -3 "+B5*@>(B18,0)" 18 5 -3 "+B18+C18+E18" 18 6 0 " ________" 18 7 0 " ________" 19 0 0 " 12 Dec" 19 1 -3 "+D18*D1*@>=(12+(B4*A21),B4)*@ROUND(2)" 19 2 -3 "((+D5-B19)*@>((D18-B19),D5)+(D18*@<=((D18-B19),D5)))*@>(B19,0)" 19 3 -3 "+D18-C19" 19 4 -3 "+B5*@>(B19,0)" 19 5 -3 "+B19+C19+E19" 19 6 0 " ________" 19 7 0 " ________" 20 0 0 " Year" 21 0 -1 "(+A21+@>(B0,0))*@>(B0,0)" 21 1 -3 "@SUM(B7,B19)" 21 2 -3 "@SUM(C7,C19)" 21 3 0 " Total" 21 4 -3 "@SUM(E7,E19)" 21 5 -3 "@SUM(F7,F19)" 23 7 0 "entGRPH' here for form feed" -1 -1 0 END