Category : Lotus and other Spreadsheets
Archive : LOANS22.ZIP
Filename : LOANS.FW3
Output of file : LOANS.FW3 contained in archive : LOANS22.ZIP
Ó ^ @ ) b Î A A
)
Bv¤¾ÊÒÚæîú &,48FJX\hlvz¬°ÀÄÔØæêøü
B Î LOANS
v
@ z î
Pmt:
) v H
LOAN ANALYSIS:
_12 z) v H
DATE INFORMATION:
î) v H ||
O O © v 3 0030
Ä
@HLOOKUP(B7,G2:M3,1)
s.Fred.A 3
@ ð
¸½eV ð) H
||
O O i 3` /1
Á¸Z,þÃWG$ϸ ìY i 3` /2
r_ÃZ±¼\¿¦°»ÏV i 3` 0/3
gclÞP¸VNW«´°a i 3` @/4
Ä i 3` `/6
3
qX´rgÅ°V]V³ i 3` /8
i 3` 012
ÿEz ¤
@¦¨ ª¬ò°²´¶¸º¼
¦) ¤ H
Principal
¨I ¤ 2 Ì[ $23,500.00
000.0 ª) ¤ H
Loan - Month .....
u ¬I ¤ 6
10
s s ò) ¤ H
||
O O °i ¤ 3` 61360
ÿ @erasepro ²i ¤ 3` 1180
@msg,15) ÿ ´i ¤ 3` 1120
¶i ¤ 3` 090
%¬%º%È%Ö ¸i ¤ 3` `060
ºi ¤ 3` E045
X ¼i ¤ 3` 0030
¾
@ÀÂ ÄÆö
À) ¾ H
Int. Rate/Year
ÂI ¾
u:13
0
Ä) ¾ H
- Day .......
ÆI ¾ 6 %025
ö) ¾ H
||
O O Ê
@ ÌÎÐ
Ì) Ê H
- Year ......
ÎI Ê 6 21987
) Ê H
||
O O Ð ) Ê The spreadsheet was developed by
Ò
@Ô^
Ô) Ò H
Total # of Payments
^I Ò 3 0 î ú î 48
) Ò H
||
O O ) Ò Todd Natkin, Attorney.
O Ú
@ÜÞ àâ
Ü) Ú H
# of Payments/Year
A ^> B F ÞI Ú 3 12
ZK°VsM¼½\¸ à) Ú H
1st Pmt - Month ..
ÈfW°j_r¸L;´Âq âI Ú 6 0
×¼slgaYø½½\ ) Ú H
||
O O ) Ú Tel (202) 331-0094.
O æ
@ èê
vé ø è) æ H
- Day ....
{M êI æ 6 0
°U@[ ) æ H
||
O O ) æ FAX (202) 887-5068.
O î
@ðò ôö
ð) î H
Balloon Payment
òI î 2B .$.00
ÿ ô) î H
- Year ...
H s x öI î 6 0
0
) î H
||
O O )! î It is hereby placed in the public
ú
@ü
ü) ú
____________________
) ú
____________________
) ú
_______
) ú
____________________
) ú
_______
) ú H
____||
O O ) ú domain.
@
) H
||
O O
@
) H
Date - Loan:
+ Ã
00Oct 25, 1987
@DATE(E5,E3,E4)
) H
# of Odd Days ....
) ô3 0
E
ô 5 @if(@diffdate(B13,B12)-G1<=0,0,@diffdate(b13,b12)-G1)
) H
||
O O
@
) H
Date - 1st Pmt:
) " Ã ÀNov 24, 1987
" J @if(@diffdate(@date(e9,e7,e8),b12)-g1<=0,@sumdate(b12,g1),@DATE(E9,E7,E8))
@if(@di ) H
||
O O &
@ (.T
() & H
Principal after
O .) & Odd Da
O O T) & H ys: ||
O O ,
@. 0X$
.) , H
Payments --
0) , H
Odd Days --
ÿ X) , >=0
$) , H
||
O O 4
@ &
º &) 4 H
||
O O 8
@:< @ (
:) 8 H
Odd Days Simple
<) 8 > Pc1$630.45
,930.04 > @ROUND(B27/@INT(B6),2)+@ROUND(@PMT(@IF(E12>0,(@PMT((B3-B9),((B4/100)/365)*@INT(E12),1)),(B3-B9)),((B4/100)/@INT(B7)),@INT(B6)),2)
3- @) 8 B2 Ì[ $23,500.00
739.7 B 3 @IF(E12>0,(@PMT(B3,((B4/100)/365)*@INT(E12),1)),B3)
() 8 H
||
O O F
@ *
z *) F H
||
O O J
@LN R ,
L) J H
Odd Days Compound
N) J P Pc1$630.45
,485.18
P @ROUND(D27/@INT(B6),2)+@ROUND(@PMT(@IF(E12>0,@FV((@PMT((B3-B9),((B4/100)/365),E12)),((B4/100)/365),E12),(B3-B9)),((B4/100)/@INT(B7)),@INT(B6)),2)
00 R) J T2 Ì[ $23,500.00
582.1 T C @IF(E12>0,@FV((@PMT(B3,((B4/100)/365),E12)),((B4/100)/365),E12),B3)
,) J H
||
O O X
@ ì
ì) X H
[PgDn]||
O \
@^¤ b ø
> B F ^) \
====================
¤ ) \
====================
b) \
=======
) \
====================
ø) \ H
==========||
O h
@ 0
lãl 0) h H
||
O O l
@npÈr 4
n)
l H
LOAN SUMMARY:
p) l È
Odd Days (Smpl.)
r) l È
Odd Days (Cmpd.)
4) l H
||
O O v
@ 6
6) v H
||
O O z
@|~ 8
|) z H
Amortized Interest
~)
z ²2 Bag2$6,761.42
,641.8 ² + -
)
z ¶2 Bag2$6,761.42
,288.6 ¶ + -
8) z H
||
O O
@ :
:) H
||
O O
@ <
) H
Balloon Pmt. (Int.)
) ,$.00
b @ROUND(B9*@INT(B6)*(B4/(100*@INT(B7)))+(@IF(E12>0,(@PMT(B9,((B4/100)/365)*@INT(E12),1)),B9))-B9,2)
/ ) ,$.00
r @ROUND(B9*@INT(B6)*(B4/(100*@INT(B7)))+(@IF(E12>0,@FV((@PMT(B9,((B4/100)/365),E12)),((B4/100)/365),E12),B9))-B9,2)
+ <) H
||
O O
@ >
>) H
||
O O
@ ¢¦ @
, ÿ ) H
TOTAL Interest Due
V ¢)
¤ Bag2$6,761.42
,641.8
¤ @ROUND((((B27/@INT(B6)+@PMT(@IF(E12>0,(@PMT((B3-B9),((B4/100)/365)*@INT(E12),1)),(B3-B9)),((B4/100)/@INT(B7)),@INT(B6)))*@INT(B6))+B9)-B3,2)
5)*@INT ¦)
¨ Bag2$6,761.42
,288.6 ¨ @ROUND((((D27/@INT(B6)+@PMT(@IF(E12>0,@FV((@PMT((B3-B9),((B4/100)/365),E12)),((B4/100)/365),E12),(B3-B9)),((B4/100)/@INT(B7)),@INT(B6)))*@INT(B6))+B9)-B3,2)
4/100)/ @) H
||
O O ¬
@ B
B) ¬ H
||
O O °
@²¢ ¶\ºD
²) °
--------------------
¢ ) °
--------------------
¶) °
-------
\) °
--------------------
º) °
-------
D) ° H
----||
O O À
@ F
F) À H
||
O O Ä
@ÆÈ Ì H
Æ) Ä H
Amort. Prin. Pmts.
$[ØXH Ë È) Ä ¸2 P#3$23,500.00
000.0 ¸ + â- è
Ì) Ä º2 P#3$23,500.00
000.0 º
+þâ-þè
H) Ä H
||
O O Ô
@ J
J) Ô H
||
O O Ø
@ÚÜ à L
Ú) Ø H
Balloon Payment
Ü) Ø Þ2 .$.00
Þ +B9
à) Ø â2 .$.00
â +B9
L) Ø H
||
O O æ
@ N
N) æ H
||
O O ê
@ìî ò P
%Ð%Þ%ì ì) ê H
TOTAL Principal
î) ê ¼2 P#3$23,500.00
000.0 ¼ + ü+ þ
ò) ê ¾2 P#3$23,500.00
000.0 ¾ + ü+ þ
E NOTE THE P) ê H
||
O O ø
@ R
¶ R) ø H
||
O O ü
@þ T
þ) ü H
TOTAL PRN + INT
) ü À2 &03$30,261.42
641.8 À + ö+ þ
) ü Â2 &03$30,261.42
288.6 Â + ö+ þ
T) ü H
||
O O
@ V
V)
H
[End]||
O
@¦ Z
)
====================
W>W>
¦ ) ====================
)
=======
LV Â&3 )
====================
Z) H ============
O
Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!
This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.
But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/