Category : Lotus and other Spreadsheets
Archive   : AMORTIZE.ZIP
Filename : AMORTIZE.XLS

 
Output of file : AMORTIZE.XLS contained in archive : AMORTIZE.ZIP
ß\ USDA ©-Â6 !Bä d
ü©ñÒMbP?"*+_‚€%ÿŒÁ1
ÈÿGeneva1
ÈÿGeneva1
ÈÿGeneva1
ÈÿGeneva1
hÿGeneva1
ÈÿGeneva&fPage &pƒ„&è?'è?(ffffffæ?)R¸…ëQè?M düÿüÿ¡ d@V
General00.00#,##0 #,##0.00#,##0_);\(#,##0\)#,##0_);[Red]\(#,##0\)#,##0.00_);\(#,##0.00\)#,##0.00_);[Red]\(#,##0.00\)"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)0%0.00% 0.00E+00 #\ ?/? #\ ??/?? m/d/yy

d\-mmm\-yy d\-mmm
mmm\-yy h:mm\ AM/PMh:mm:ss\ AM/PMh:mm
h:mm:ss m/d/yy\ h:mm Annual_interest_rate,* Beg.BallÀþ,ÿÿ " Calculated_payment,
 4 "Cum.InterestlÀú
lÿÿlÀý "   6 "Ending.BalancelÀû
lÀýlÀÿ " Entered_payment,  First_payment_due,
 First_payment_no,7 )InterestlÀýlÀÿc " Loan_amount,F 5payment.Numlÿÿ lÿÿc b%lÿÿ" Payments_per_year, *
Periodic_ratecc
Pmt_to_use,@ 1PrincipallÀü,ÀþclÀÿb " -,  o `Show.DatelÀÿKc
aEc
T{_0aDlÀÿ c2z_09c
b{_0FaCaA "
Table_beg_bal, Table_prior_interest, Table_start_date, Table_start_pmt,
Term_in_years,+ Total_paymentsc}{_0ccC õÿ ÎC õÿ ôÎC õÿ ôÎC õÿ ôÎC õÿ ôÎC õÿ üÎC õÿ üÎC õÿ üÎC õÿ üÎC õÿ üÎC õÿ üÎC õÿ üÎC õÿ üÎC õÿ üÎC õÿ üÎC  ÎC õÿ øÎC õÿ øÎC
õÿ øÎC  (ÎÁC  ÎÁC  (ÎÁC #ÎC #0ÎÁC  !<ÎÁC   ,ÎÁC !4ÎÁC !4ÎÁC !ÎC !0ÎÁC   ÎC  ÎC   ÎC  ÎC "8ÎÁÁÁC "8ÎÁÁÁC "0ÎÁÁÁC "4ÎÁÁÁC "4ÎÁÁÁC "0ÎÁÁC "4ÎÁÁC "4ÎÁÁC "0ÎÁÁÁC "4ÎÁÁÁC "4ÎÁÁÁ“€ÿ“€ÿ“€ÿ“€ÿU} ¶ÁÁ} IÁÁ} $ ÁÁ} ¶
ÁÁ} m ÁÁ} 
ÁÁ} m ÁÁ
-ÑX"ÿZ$ÿNÿlÑoÿTÿSÿQÿ^ ÿ(
ÿ, ÿ, ÿX
ÿi/ÿ˜ÿTl ÿ->ŒÑŽ_ÿMÿniDÿ‚ÿi ÿçȋÿç/ÿçÿçÿçÿçâŠÿç‹ÿçÿçxŒAmortization TableJBA simple amortization table covering 24 payment periods of a loan.h`1) To use the table, simply change any of the values in the "inital data" area of the worksheet.kc2) To print the table, just choose "Print" from the "File" menu. The print area is already defined. Initial Data LOAN DATA
TABLE DATA Loan amount:~
ˆÓ@Table starts at date:Annual interest rate:~
&@or at payment number:~
ð?Term in years:~
@ Payments per year:~
(@
First payment due:~

À}ß@ PERIODIC PAYMENT       Entered payment: ? 7 The table uses the calculated periodic payment amount
Calculated payment:8
Ë¢-›H'€@&Cp”_0C¼y_0C
B;9
1 unless you enter a value for "Entered payment". CALCULATIONSUse payment of:G Ë¢-›H'€@5C  ## Mw0'BG.o0ÿÿ5Beginning balance at payment C $0A0:!Beginning balance at payment 1:S!ˆÓ@AC'z_0Cï|_0C ŒMw0CŒz_0+C
÷Lw06B91st payment in table:žð?ŒDÀ #DÀ  $À"\D ÀDÀAED
ÀAED ÀDÀADD
ÀAD ADÀACD
ÀAC
BBOdo0ÿÿ=%Cumulative interest prior to payment C ÒMw0,0A0:)'Cumulative interest prior to payment 1:G!5CáMw0C àNw0C
ìMw0!C,
Table""Payment" Beginning"""Ending"
Cumulative #No. #Date#Balance#Interest# Principal#Balance#InterestF$ð?4C Ow0CìLw0 # ]Ow0  B%À}ß@ CX&ˆÓ@FDÀ1C6Ow0 #ØOw0*" B&«ªªªªêf@ C &@ðá;Ùt@ C&?è{›4Ó@ C;&«ªªªªêf@)DÀDÀC B'@ C(@…ß@ C©Ow0)?è{›4Ó@ C)^î¶?шf@ C +Pw0)gΖ(
u@ COPw0)é!nràÒ@ CsPw0)„Ì0õ½¹v@ C*@ CÙPw0+ß@ CýPw0,é!nràÒ@ C!Qw0,ö 6&f@ C EQw0,‰ÊJˆ;u@ CiQw0,Û½´M„‹Ò@ CQw0,È£ ˆcæ€@ C±Qw0$@ CÕQw0%€”ß@ CùQw0&Û½´M„‹Ò@ CRw0&›‚skÂe@ C ARw0&H„Ò|[mu@ CeRw0&ÊsÁßÎ5Ò@ C‰Rw0&oådþV†@ C­Rw0'@ CÑRw0(@œß@ CõRw0)ÊsÁßÎ5Ò@ CSw0)ÇÙÀÖÚ]e@ C =Sw0)²ØúÊ£Ÿu@ CaSw0)gˆ•PPßÑ@ C…Sw0)á:•u®‹@ C©Sw0*@ CÍSw0+¤ß@ CñSw0,gˆ•PPßÑ@ CTw0,h/k<^ød@ C 9Tw0,â­%bÒu@ C]Tw0,¯ñ4ȈÑ@ CTw0,^ØTFv@ C¥Tw0$@ CÉTw0%€«ß@ CíTw0&¯ñ4ȈÑ@ CUw0&žòDzó‘d@ C 5Uw0&GÌ8y—v@ CYUw0&~Pjð/Ñ@ C}Uw0&²¡ Ą“@ C¡Uw0' @ CÅUw0(@³ß@ CéUw0)~Pjð/Ñ@ C
Vw0)ðÿna˜*d@ C 1Vw0)žÅ£E9v@ CUVw0)h9V ×Ð@ CyVw0)°NÐ׍•@ CVw0*"@ CÁVw0+Àºß@ CåVw0,h9V ×Ð@ C Ww0, ·ê½JÂc@ C -Ww0,Æée×kmv@ CQWw0,ÁçÛ¦U}Ð@ CuWw0,¤Ø (!˜@ C™Ww0$$@ C½Ww0%€Âß@ CáWw0&ÁçÛ¦U}Ð@ CXw0&øVYc@ C )Xw0&’I
¢v@ CMXw0&›–¯rÍ"Ð@ CqXw0&¥—Ý2Bqš@ C•Xw0'&@ C¹Xw0(@Êß@ CÝXw0)›–¯rÍ"Ð@ CYw0)ÎûöìÎîb@ C %Yw0)¯Çß¿)×v@ CIYw0)ù.`—áŽÏ@ CmYw0)w|Ϝ@ C‘Yw0 ÿð"!ÿç$"ÿç#ÿç$ÿç%ÿç&ÿç'ÿç(ÿç)ÿç*ÿç+ÿç,ÿç *(@ CµYw0 +@Ñß@ CÙYw0 ,ù.`—áŽÏ@ CýYw0 ,€=œƒb@ C !Zw0 ,Î7›à w@ CEZw0 ,;U£~{ÖÎ@ CiZw0 ,‘z,˜Ÿ@ CZw0!$*@ C±Zw0!%Ùß@ CÕZw0!&;U£~{ÖÎ@ CùZw0!&Ûr3ÿmb@ C [w0!&(ŒÁ6ÚBw@ CA[w0!&ÚHí¬dÎ@ Ce[w0!&vt ¬>± @ C‰[w0"',@ C­[w0"(€àß@ CÑ[w0")ÚHí¬dÎ@ Cõ[w0").h¾ãAªa@ C \w0")|Dpyw@ C=\w0")NhÉ*™`Í@ Ca\w0")ùZEÊâË¡@ C…\w0#*.@ C©\w0#+@èß@ CÍ\w0#,NhÉ*™`Í@ Cñ\w0#,¥e— _w0%)œ}µ7 x@ C1_w0%)ó1KÒ"Ë@ CU_w0%)¥»æ¿=ò¤@ Cy_w0&*2@ C_w0&+@ÿß@ CÁ_w0&,ó1KÒ"Ë@ Cå_w0&,‰ãêïÖ_@ C `w0&,Oc¢;ÕXx@ C-`w0&,Ù<¡ `Ê@ CQ`w0&,î×=?õð¥@ Cu`w0''3@ C™`w0'(`à@ C½`w0')Ù<¡ `Ê@ Cá`w0')[€odfò^@ C aw0')e?÷‘x@ C)aw0')­#Rä{›É@ CMaw0')ñSarˆè¦@ Cqaw0('4@ C•aw0((@à@ C¹aw0()­#Rä{›É@ CÝaw0()ƒ7‘Ä ^@ C bw0()µ7 Ëx@ C%bw0()ïQÁãÕÈ@ CIbw0()­ué–æا@ Cmbw0)*5@ C‘bw0)+ à@ Cµbw0),ïQÁãÕÈ@ CÙbw0),Û†#]@ C ýbw0),ÕÔÔÏy@ C!cw0),x±eð È@ CEcw0),…\ÃþÁ¨@ Cicw0*'6@ Ccw0*(àà@ C±cw0*)x±eð È@ CÕcw0*)ID«M$8\@ C ùcw0*)„tð"ˆ@y@ Cdw0*)Ô-$ìBÇ@ CAdw0*)§¶‡å¿£©@ Cedw0+'7@ C‰dw0+(Àà@ C­dw0+)Ô-$ìBÇ@ CÑdw0+)DçüåK[@ C õdw0+)Å Ü<Ê{y@ Cew0+)vMÒ
wÆ@ C=ew0+)᝷Ä~ª@ Caew0,*8@ C…ew0,+@à@ C©ew0,,vMÒ
wÆ@ CÍew0,,o€ŸAç[Z@ C ñew0,,zeóe—·y@ Cfw0,,J²ìQ©Å@ C9fw0,,ä™Äþ÷P«@ C]fw0=
Ú%ó>
´”Ãè?è?ffffffæ?R¸…ëQè?mqq 
  
ÿ«"


  3 Responses to “Category : Lotus and other Spreadsheets
Archive   : AMORTIZE.ZIP
Filename : AMORTIZE.XLS

  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/