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:
†)vH
LOAN ANALYSIS:
_12z)vH
DATE INFORMATION:
î)vH ||
OO†©vˆ30030

Ä
ˆ  @HLOOKUP(B7,G2:M3,1)
s.Fred.A…3
Š

@ðŽ’”–˜ž
‚¸½eVŸÂð)ŠH
||
OOŽ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
ssò)¤H
||
OO°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
||
OOÊ
 @ÌÎÐ
Ì)ÊH
- Year ......
ÎIÊ6 ‡21987

)ÊH
||
OOÐ) ÊThe spreadsheet was developed by
Ò
 @Ô^
Ô)ÒH
Total # of Payments
^IÒ30îúî 48
)ÒH
||
OO)ÒTodd Natkin, Attorney.
OÚ
 @ÜÞàâ
…Ü)ÚH
# of Payments/Year
A^>BFÞIÚ3 12
ZK°VsM¼½\¸à)ÚH
1st Pmt - Month ..
ÈfW°j_r¸L;´ÂqâIÚ60

×¼slgaY“ø½½\)ÚH
||
OO)ÚTel (202) 331-0094.
Oæ
 @èê
véøè)æH
- Day ....

{MêIæ60


°U@[)æH
||
OO)æFAX (202) 887-5068.
Oî
 @ðòôö
ð)îH
Balloon Payment
òIî2B.$.00
ÿô)îH
- Year ...
H sxöIî60
0

)îH
||
OO)!îIt is hereby placed in the public
ú
 @ü ’ 
ü)ú
____________________
 )ú
____________________
)ú
_______
’)ú
____________________
)ú
_______
)úH
____||
OO )údomain.

 @
)H
||
OO 
 @
)  H
Date - Loan:
+  Ã
00Oct 25, 1987
  @DATE(E5,E3,E4)
) H
# of Odd Days ....
) ô30

E

ô 5 @if(@diffdate(B13,B12)-G1<=0,0,@diffdate(b13,b12)-G1)
) H
||
OO
 @  
)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
||
OO&
 @(.T
()&H
Principal after
O.)&Odd Da
OOT)&Hys: ||
OO,
 @.0X$
.) ,H
Payments --
0) ,H
Odd Days --
ÿX), >=0
$),H
||
OO4
 @&
º&)4H
||
OO8
 @:<@(
:)8H
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-@) 8B2Ì[$23,500.00

739.7B 3 @IF(E12>0,(@PMT(B3,((B4/100)/365)*@INT(E12),1)),B3)
()8H
||
OOF
 @*
ƒz *)FH
||
OOJ
 @LNR,
L)JH
Odd Days Compound
N)JPPc1$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)
00R) JT2Ì[$23,500.00

582.1T C @IF(E12>0,@FV((@PMT(B3,((B4/100)/365),E12)),((B4/100)/365),E12),B3)
,)JH
||
OOX
 @ì
ì) XH
[PgDn]||
O\
 @^¤b˜ø
>BF^)\
====================
¤)\
====================
b)\
=======
˜)\
====================
ø) \H
==========||
Oh
 @0
lãl0)hH
||
OOl
 @npÈr4
n)
lH
LOAN SUMMARY:
p)lÈ
Odd Days (Smpl.)
r)lÈ
Odd Days (Cmpd.)
4)lH
||
OOv
 @6
6)vH
||
OOz
 @|~‚8
‰
|)zH
Amortized Interest

~)
z²2Bag2$6,761.42

,641.8²  + - 
‚)
z¶2Bag2$6,761.42

,288.6¶  + - 
8)zH
||
OOˆ
 @:
:)ˆH
||
OOŒ
 @Ž”<
Ž)Œ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
||
OOš
 @>
>)šH
||
OOž
 @ ¢¦@
,ÿ )ž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
||
OO¬
 @B

B)¬H
||
OO°
 @²¢¶\ºD
²)°
--------------------
¢)°
--------------------
¶)°
-------
\)°
--------------------
º)°
-------
D)°H
----||
OOÀ
 @F
F)ÀH
||
OOÄ
 @ÆÈÌH
Æ)ÄH
Amort. Prin. Pmts.
$[ØXH ËÈ) ĸ2P#3$23,500.00

000.0¸  + â- è
Ì) ĺ2P#3$23,500.00

000.0º 
+þâ-þè
H)ÄH
||
OOÔ
 @J
J)ÔH
||
OOØ
 @ÚÜàL
Ú)ØH
Balloon Payment
 Ü)ØÞ2.$.00
Þ  +B9
à)Øâ2.$.00
â  +B9
L)ØH
||
OOæ
 @N
N)æH
||
OOê
 @ìîòP
%Ð%Þ%ìì)êH
TOTAL Principal
î) ê¼2P#3$23,500.00

000.0¼  + ü+ þ
ò) ê¾2P#3$23,500.00

000.0¾  + ü+ þ
E NOTE THE P)êH
||
OOø
 @R
­¶R)øH
||
OOü
 @þT
þ)üH
TOTAL PRN + INT
) üÀ2 &03$30,261.42

641.8À  + ö+ þ
) üÂ2 &03$30,261.42

288.6Â  + ö+ þ
T)üH
||
OO

 @V
V) 
H
[End]||
O
 @¦žZ
)
====================
W>W>

¦)====================
)
=======
LVÂ&3ž)
====================
Z) H============
O

  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : LOANS22.ZIP
Filename : LOANS.FW3

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. 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/