Category : Lotus and other Spreadsheets
Archive : AMORT1X.ZIP
Filename : AMORT1X.WKS
Output of file : AMORT1X.WKS contained in archive : AMORT1X.ZIP
k B ) '* ÿÿ ÿÿ ÿÿ ÿÿ - µ v ~ v ~ v ~ v ~ ÿÿ` ÿÿg ÿÿ` ÿÿg ÿÿ` ÿÿe ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿÿ ÿ LOAN AMORTIZATION SCHEDULE by Richard M. Ross, Jr. YEARS DOLLARS BALANCE CUM. PRINCIPAL CUM. INTEREST CUM. PRIN. CUM. INT. CUM. INT. qq M ÿ '###################################################################### M ÿ '## USING SOFTWARE TOOLS TO DEVELOP EFFICIENT SPREADSHEET TEMPLATES ## M ÿ '### CONTINUE DOWNWARDS - {HOME} TO BEGIN - (ALT-D) FOR DATA ### M ÿ '###################################################################### B ÿ ' " A Study In Loan Amortizations Using LOTUS 1-2-3 " A ÿ ' Prepared For The Phoenix LOTUS 1-2-3 Study Group ÿ ' by R. M. Ross, Jr. ÿ ' Copyright MCMLXXXIV ÿ ^Revised -
ò ëw M ÿ
'###################################################################### M ÿ '###################################################################### M ÿ '###################################################################### J ÿ ' This template is designed to explore techniques of extending the ÿ 'MACRO TO PRINT L ÿ 'potential of several LOTUS 1-2-3 "@-functions", and also to produce a # ÿ 'ENTIRE AMORTIZATION SCHEDULE M ÿ 'variable term-length loan amortization schedule in which the principal ÿ \* ÿ \* J ÿ 'and interest are calculated for each year and then accumulated into ÿ '/P ÿ 'PRINT ÿ '/P J ÿ 'ongoing totals. After the completion of the loan term the variables ÿ 'P ÿ 'PRINTER ÿ 'P I ÿ 'calculate to 'not available', (also LOTUS "@NA"), which avoids the ÿ 'R ÿ 'RANGE ÿ 'R D ÿ 'sometimes annoying phenomenon of "negative amortization" when
ÿ 'TABLE~ ÿ '"RANGE NAME" ÿ 'TEXT~ J ÿ 'payments continue after the loan balance is fully repaid. The user ÿ 'P ÿ 'FORM FEED ÿ 'P I ÿ 'can print the entire amortization schedule using the (ALT-P) macro ÿ 'A ÿ 'ALIGN ÿ 'A H ÿ 'command. The first several years of the loan schedule data can be ÿ 'G ÿ 'GO ÿ 'G L ÿ 'seen in bar-graph form by pressing the 'F10' key on graphics equipped
ÿ '/XQ ÿ 'QUIT
ÿ '/XQ L ÿ 'machines. The user is encouraged to experiment with the settings of J ÿ 'the graph data-ranges to produce different graphic representations. @ ÿ ' The technique used to calculate the actual schedule of L ÿ 'amortization is based upon the fact that the outstanding balance on a ÿ 'MACRO TO GOTO DATA J ÿ 'loan at any given time is exactly equal to the present value of the ÿ \* ÿ \* L ÿ ! 'remaining payments on the loan discounted at the loan interest rate.
ÿ ! '{GOTO} H ÿ " 'This is the old familiar "time value of money" theory numerically ÿ " 'DATA~ D ÿ # 'applied to a practical and common problem. If you are feeling
ÿ # '/XQ F ÿ $ 'energetic, but rusty on the mathematics of this concept, then I L ÿ % 'suggest you consult the early chapters of any managerial finance book I ÿ & 'to find a discussion of the "present value" equations. These basic J ÿ ' 'tools of the world of "Capital Budgeting" are repeatedly able to be D ÿ ( 'applied directly in LOTUS 1-2-3 to produce excellent results. J ÿ * ' We will start by assuming that the life of the loan is no longer E ÿ + 'than fifty years, and also that the ability to choose between L ÿ , 'monthly and yearly compounding is a requirement. In addition to these L ÿ - 'assumptions, it is only required that the loan principal amount, the L ÿ . 'interest rate, the life, and the base year of the loan be specified. M ÿ / 'With this information provided we simply use the powerful @PV and @PMT J ÿ 0 'functions of 1-2-3, and we can quickly have a complete amortization . ÿ 1 'schedule calculated and ready to print. A ÿ 3 ' The "twist" of this application lies in calculating the K ÿ 4 'outstanding balance on the loan at the beginning of each year as the I ÿ 5 'discounted present value of the remaining loan payments. With this D ÿ 6 'series successfully calculated we can immediately produce the E ÿ 7 'principal amortized during any year by subtracting that year's G ÿ 8 'beginning balance from the next year's. The interest is then the G ÿ 9 'difference between the total loan payments for that year and the C ÿ : 'year's principal amount. Voila, we now have a complete loan ÿ ; 'amortization! L ÿ = ' An apparently more subtle issue is faced in making the loan term a H ÿ > 'variable. We must have our cell formulae extended throughout the I ÿ ? 'entire fifty year range of our maximum term, yet we do not want to J ÿ @ 'have extraneous and unsightly negative amortization occurring after G ÿ A 'the term of the loan is completed when the term is less than the L ÿ B 'maximum. This is dealt with by utilizing the conditional @IF command K ÿ C 'of 1-2-3. It makes it possible to determine whether the term of the E ÿ D 'loan is complete, and then we can force all subsequent rows to K ÿ E 'calculate to @NA. The test is done by taking the difference between K ÿ F 'the current year and the base year and comparing it to the term. If H ÿ G 'this difference is greater than the term we will have our formula C ÿ H 'enter the value @NA, otherwise we will have it calculate the ÿ I 'appropriate value. K ÿ K ' This entire worksheet was prepared using only the formulae in the K ÿ L 'first two rows. All subsequent rows were produced by simply copying E ÿ M 'the contents of the second row downward. The judicious use of J ÿ N 'relative and absolute referencing makes this possible. The formula H ÿ O 'in the BEGINNING BALANCE column looks difficult, but if you break G ÿ P 'it into its component parts it is much easier to understand. It I ÿ Q 'maximizes on formula efficiency to achieve results which otherwise G ÿ R 'might have required several columns to calculate. NOTE !!! The E ÿ S 'entire worksheet may be printed by pressing "ALT-P", and a bar B ÿ T 'graph of the first nine years may be had by pressing "F10". C ÿ U 'This text may be printed by using the "ALT-T" macro command. J ÿ W ' I hope you enjoy this presentation. Feel free to call me if you G ÿ X 'have any questions or need some help. My office phone number is I ÿ Y '941-1766, and my home phone is 945-9799. Also, you are welcome to K ÿ Z 'distribute this worksheet to your friends if you like, but please do F ÿ [ 'not sell it or alter it if you do. Thanks for your attention!! ÿ ^ 'Rick Ross ÿ _ 'Scottsdale, AZ ÿ b \# ÿ b \# ÿ b \# ÿ b \# ÿ b \# ÿ b \# ÿ b \# ÿ c \# ÿ c \# ÿ c \# ÿ c \# ÿ c \# ÿ c \# ÿ c \# ÿ e "***** $ ÿ e 'AMORTIZATION DATA TABLE ***** 6 ÿ g ' ENTER LOAN PRINCIPAL AMOUNT HERE --->
" g Àô@ 6 ÿ h ' ENTER LOAN INTEREST RATE HERE --->
4 h R¸ ëQÀ? 6 ÿ i ' ENTER LOAN LIFE (IN YEARS) HERE --->
i 6 ÿ j ' ENTER BASE YEAR OF LOAN HERE --->
j À 0 ÿ k ' ENTER COMPOUNDING FREQUENCY HERE 8 ÿ l ' (ZERO = YEARLY, NON-ZERO = MONTHLY) --->
l ; ÿ m ' ANNUAL LOAN PAYMENTS (PRINCIPAL + INTEREST) B ¢ m eÇì£*Æ@3 ÿ¿ ú¿ û¿ ü¿ 8 ú¿ û¿ ü¿8; 0 ÿ n ' MONTHLY PAYMENTS (IF APPLICABLE) " ¢ n 1_æ/u@ þ¿ ÿ¿ ; ÿ q \# ÿ q \# ÿ q \# ÿ q \# ÿ q \# ÿ q \# ÿ q \# ÿ r \# ÿ r \# ÿ r \# ÿ r \# ÿ r \# ÿ r \# ÿ r \# ÿ s ^BEGINNING ÿ s ^CUMULATIVE ÿ s ^CUMULATIVE ÿ t ^YEAR ÿ t ^BALANCE ÿ t ^PAYMENTS ÿ t ^PRINCIPAL ÿ t ^INTEREST ÿ t ^PRINCIPAL ÿ t ^INTEREST ÿ u ^**** ÿ u ^************** ÿ u ^************** ÿ u ^************** ÿ u ^************** ÿ u ^************** ÿ u ^************** ÿ v @ j ¢ v Àô@ g , ¢ v eÇì£*Æ@ þ¿ v
i
m ; . ¢ v $ÞÀgy@ ý¿ v
i þ¿ þ¿
; ¢ v EÖåe_ Å@ þ¿ ÿ¿
¢ v $ÞÀgy@ þ¿v þ¿ P ¢ v EÖåe_ Å@ þ¿v þ¿ P ÿ w @
ÿ¿ y ¢ w Ü!?¡ô@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ w eÇì£*Æ@ þ¿ v
i
m ; . ¢ w º¼ÙwÝ@ ý¿ v
i þ¿ þ¿
; ¢ w ½ûP&SúÄ@ þ¿ ÿ¿
¢ w @æÝÍ@ þ¿v þ¿ P ¢ w iFY Õ@ þ¿v þ¿ P ÿ x @
ÿ¿ y ¢ x g¨¨K}ô@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ x eÇì£*Æ@ þ¿ v
i
m ; . ¢ x ÿ®ÀåG@ ý¿ v
i þ¿ þ¿
; ¢ x m×áG¬ÓÄ@ þ¿ ÿ¿
¢ x fm½ñ@ þ¿v þ¿ P ¢ x ¸T j/uß@ þ¿v þ¿ P ÿ y @
ÿ¿ y ¢ y hJ
Ý»Tô@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ y eÇì£*Æ@ þ¿ v
i
m ; . ¢ y Kó@ ý¿ v
i þ¿ þ¿
; ¢ y ²Ãj˧Ä@ þ¿ ÿ¿
¢ y à[C:£@ þ¿v þ¿ P ¢ y ·ää@ þ¿v þ¿ P ÿ z @
ÿ¿ y ¢ z Ñ'åõ¯&ô@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ z eÇì£*Æ@ þ¿ v
i
m ; . ¢ z £ ð"@ ý¿ v
i þ¿ þ¿
; ¢ z Õ"¢ûuÄ@ þ¿ ÿ¿
¢ z ìJ½Â©@ þ¿v þ¿ P ¢ z |º?x ê@ þ¿v þ¿ P ÿ { @
ÿ¿ y ¢ { à«jòó@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ { eÇì£*Æ@ þ¿ v
i
m ; . ¢ { U±«@ ý¿ v
i þ¿ þ¿
; ¢ { v'o=Ä@ þ¿ ÿ¿
¢ { °ÌØÔ°@ þ¿v þ¿ P ¢ { ÉZeï@ þ¿v þ¿ P ÿ | @
ÿ¿ y ¢ | u6s²·ó@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ | eÇì£*Æ@ þ¿ v
i
m ; . ¢ | À5ÃVe×@ ý¿ v
i þ¿ þ¿
; ¢ | `ù=ýÃ@ þ¿ ÿ¿
¢ | f}.®Ì´@ þ¿v þ¿ P ¢ | XlZò@ þ¿v þ¿ P ÿ } @
ÿ¿ y ¢ } ) µsó@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ } eÇì£*Æ@ þ¿ v
i
m ; . ¢ } ó0c @ ý¿ v
i þ¿ þ¿
; ¢ } Û=^´Ã@ þ¿ ÿ¿
¢ } àâúF¹@ þ¿v þ¿ P ¢ } 7ÉB4æ~ô@ þ¿v þ¿ P ÿ ~ @
ÿ¿ y ¢ ~ ÒV;'ó@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ~ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ~ À]µ96´@ ý¿ v
i þ¿ þ¿
; ¢ ~ ¶Ü£aÃ@ þ¿ ÿ¿
¢ ~ P:
T¿@ þ¿v þ¿ P ¢ ~ Ù¯ëö@ þ¿v þ¿ P ÿ $@
ÿ¿ y ¢ [,o·jÐò@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ Å6^£@ ý¿ v
i þ¿ þ¿
; ¢ µî%¸¹Ã@ þ¿ ÿ¿
¢ ØuM0Â@ þ¿v þ¿ P ¢ JÞæKù@ þ¿v þ¿ P ÿ (@
ÿ¿ y ¢ EQöÜmò@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ÀGúpø@ ý¿ v
i þ¿ þ¿
; ¢ m~m Â@ þ¿ ÿ¿
¢ оÌA)Æ@ þ¿v þ¿ P ¢ Qú+yµû@ þ¿v þ¿ P ÿ ,@
ÿ¿ y ¢ &hÆ×úýñ@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ À±®À@ ý¿ v
i þ¿ þ¿
; ¢ mÖÐ Â@ þ¿ ÿ¿
¢ Èîâ? Ê@ þ¿v þ¿ P ¢ ?ÍF¸âý@ þ¿v þ¿ P ÿ 0@
ÿ¿ y ¢ '¢c ø~ñ@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ¸sóì¢@ ý¿ v
i þ¿ þ¿
; ¢ EÙg¯Á@ þ¿ ÿ¿
¢ èÜ¿QºÎ@ þ¿v þ¿ P ¢ 4d Ç
A þ¿v þ¿ P ÿ 4@
ÿ¿ y ¢ cȵÈîð@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ /÷YÓu¤@ ý¿ v
i þ¿ þ¿
; ¢ }ûn͵úÀ@ þ¿ ÿ¿
¢ hÔ ÕÑ@ þ¿v þ¿ P ¢ ëSë\rA þ¿v þ¿ P ÿ 8@
ÿ¿ y ¢ æJøKð@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ÐÏæ :§@ ý¿ v
i þ¿ þ¿
; ¢ qóà¤IÀ@ þ¿ ÿ¿
¢ b®uÚ¼Ô@ þ¿v þ¿ P ¢ " úª A þ¿v þ¿ P ÿ <@
ÿ¿ y ¢ Ï(2Å"ï@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ pôr ^ª@ ý¿ v
i þ¿ þ¿
; ¢ ÍE¿@ þ¿ ÿ¿
¢ ð¬ÞØ@ þ¿v þ¿ P ¢ ÇñpÓA þ¿v þ¿ P ÿ @@
ÿ¿ y ¢ ©¾°|í@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ P*Üâî@ ý¿ v
i þ¿ þ¿
; ¢ ¢ù×Ùã8½@ þ¿ ÿ¿
¢ :_ßzÆÛ@ þ¿v þ¿ P ¢ ±?òÝ A þ¿v þ¿ P ÿ D@
ÿ¿ y ¢ ãvPÂë@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ h;òòý°@ ý¿ v
i þ¿ þ¿
; ¢ bSçTÌ2»@ þ¿ ÿ¿
¢ Ð
îà@ þ¿v þ¿ P ¢ /ìæTtÚA þ¿v þ¿ P ÿ H@
ÿ¿ y ¢ v/òq~é@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ pm¬ ¯I³@ ý¿ v
i þ¿ þ¿
; ¢ Z!-<¦æ¸@ þ¿ ÿ¿
¢ 8^o$lâ@ þ¿v þ¿ P ¢ :UÈ©¡A þ¿v þ¿ P ÿ L@
ÿ¿ y ¢ È¡|Ûç@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ½6Ú\åµ@ ý¿ v
i þ¿ þ¿
; ¢ 2Ñ¢møJ¶@ þ¿ ÿ¿
¢ ë5Ê
Ð(å@ þ¿v þ¿ P ¢ Äk5JTA þ¿v þ¿ P ÿ P@
ÿ¿ y ¢ Ê5õ/Xä@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ p´pnSÛ¸@ ý¿ v
i þ¿ þ¿
; ¢ ZÚhÙU³@ þ¿ ÿ¿
¢ yLx:Dè@ þ¿v þ¿ P ¢ ² Y©îA þ¿v þ¿ P ÿ T@
ÿ¿ y ¢ ³gÅ<á@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ÔÐÜ È7¼@ ý¿ v
i þ¿ þ¿
; ¢ ì{ùSñ¯@ þ¿ ÿ¿
¢ æS|3Ëë@ þ¿v þ¿ P ¢ PÂmnA þ¿v þ¿ P ÿ X@
ÿ¿ y ¢ Ù2XkÛ@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ j5mKÀ@ ý¿ v
i þ¿ þ¿
; ¢ tuÝÚ|O¨@ þ¿ ÿ¿
¢ A¡WFÌï@ þ¿v þ¿ P ¢ \¼µ«ÏA þ¿v þ¿ P ÿ \@
ÿ¿ y ¢ Õ}½PsiÓ@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ùo髽.Â@ ý¿ v
i þ¿ þ¿
; ¢ `»ÀgK@ þ¿ ÿ¿
¢ ÎMáú+ò@ þ¿v þ¿ P ¢ ÓC< BA þ¿v þ¿ P ÿ `@
ÿ¿ y ¢ ±õ(¤Ä@j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ eÇì£*Æ@ þ¿ v
i
m ; . ¢ ±õ(¤Ä@ ý¿ v
i þ¿ þ¿
; ¢ @»³å@@ þ¿ ÿ¿
¢ Àô@ þ¿v þ¿ P ¢ ÷! %A þ¿v þ¿ P ÿ d@
ÿ¿ y ¢ j ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ h@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ l@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ p@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ t@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ x@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ |@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ @
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ ¤@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ ¨@
ÿ¿ y ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ðÿ þ¿ v
i
m ; . ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ðÿ þ¿ ÿ¿
¢ ðÿ þ¿v þ¿ P ¢ ðÿ þ¿v þ¿ P ÿ ¡ ¬@
ÿ¿ y ¢ ¡ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ¡ ðÿ þ¿ v
i
m ; . ¢ ¡ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ¡ ðÿ þ¿ ÿ¿
¢ ¡ ðÿ þ¿v þ¿ P ¢ ¡ ðÿ þ¿v þ¿ P ÿ ¢ °@
ÿ¿ y ¢ ¢ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ¢ ðÿ þ¿ v
i
m ; . ¢ ¢ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ¢ ðÿ þ¿ ÿ¿
¢ ¢ ðÿ þ¿v þ¿ P ¢ ¢ ðÿ þ¿v þ¿ P ÿ £ ´@
ÿ¿ y ¢ £ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ £ ðÿ þ¿ v
i
m ; . ¢ £ ðÿ ý¿ v
i þ¿ þ¿
; ¢ £ ðÿ þ¿ ÿ¿
¢ £ ðÿ þ¿v þ¿ P ¢ £ ðÿ þ¿v þ¿ P ÿ ¤ ¸@
ÿ¿ y ¢ ¤ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ¤ ðÿ þ¿ v
i
m ; . ¢ ¤ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ¤ ðÿ þ¿ ÿ¿
¢ ¤ ðÿ þ¿v þ¿ P ¢ ¤ ðÿ þ¿v þ¿ P ÿ ¥ ¼@
ÿ¿ y ¢ ¥ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ¥ ðÿ þ¿ v
i
m ; . ¢ ¥ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ¥ ðÿ þ¿ ÿ¿
¢ ¥ ðÿ þ¿v þ¿ P ¢ ¥ ðÿ þ¿v þ¿ P ÿ ¦ À@
ÿ¿ y ¢ ¦ ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ ¦ ðÿ þ¿ v
i
m ; . ¢ ¦ ðÿ ý¿ v
i þ¿ þ¿
; ¢ ¦ ðÿ þ¿ ÿ¿
¢ ¦ ðÿ þ¿v þ¿ P ¢ ¦ ðÿ þ¿v þ¿ P ÿ § Ä@
ÿ¿ y ¢ § ðÿj ÿ¿ v
i l m m ; l h h ; l i ÿ¿
v i ÿ¿
v ;9; , ¢ § ðÿ þ¿ v
i
m ; . ¢ § ðÿ ý¿ v
i þ¿ ÿÿÿÿ
; ¢ § ðÿ þ¿ ÿ¿
¢ § ðÿ þ¿v þ¿ P ¢ § ðÿ þ¿v þ¿ P ¢ ¨ ¢ ¨ ¢ ¨ ¢ ¨
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/