Category : Lotus and other Spreadsheets
Archive   : LOANS22.ZIP
Filename : LOANS.WK1

 (/


ÿ


ÿÂH
 
 d GAllýÿ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ0
ÿÿÿÿÿÿÿÿ ÿÿÿÿ# ÿÿÿÿgÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿi(ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿfÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ$

%ò&ò'((
HB)
'*ÿÿÿÿÿÿÿÿ-µ
ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿqq
ÿ'LOAN ANALYSIS:ÿ'DATE INFORMATION:
ÿ' ||"À>@
û¿€€
€€€
Z
ÿ
' ||
À
ð?
À
@
À
@
À
@
À

@
À
@
À
(@ÿ'Principal
"
ˆã@ÿ'Loan - Month .....

ÿ' ||
À€v@
À€f@
À^@
À €V@
À
N@
À€F@
À >@ÿ'Int. Rate/Year

*@ÿ' - Day .......
 
ÿ' ||ÿ' - Year ......
 Ÿ@
ÿ' ||ÿ'Total # of Payments
@
N@
ÿ' ||ÿ'# of Payments/Year
@
(@ÿ'1st Pmt - Month ..


ÿ' ||ÿ' - Day ....


ÿ' ||ÿ'Balloon Payment
"
ÿ' - Year ...
l
ÿ' ||ÿ \_ÿ
\_ÿ \_ÿ \_ÿ \_
ÿ '____||
ÿ
' ||ÿ'Date - Loan:%ò
€8ß@
€ù¿l

€÷¿
€ø¿6ÿ'# of Odd Days ....M€>
€ý¿l

€û¿
€ü¿6
ý¿€
€õ¿ 

ý¿
€
ý¿€
€õ¿ 
;
ÿ' ||ÿ 'Date - 1st Pmt:Xò
@ß@I
€ü¿l

€ú¿
€û¿6
€ÿ¿
€ô¿ 

€ÿ¿
€ô¿ 
€ü¿l

€ú¿
€û¿6;
ÿ ' ||ÿ
'Principal afterÿ
' Odd Day
ÿ
'ys: ||ÿ'Payments --ÿ'Odd Days --
ÿ' >=0
ÿ' ||
ÿ' ||ÿ'Odd Days Simple{ÿ
)\ÂõpŒ@l
€
€
€õ¿" ?
€û¿
€ò¿
€ø¿

€ó¿d m

€û¿"
8
€ò¿
€ø¿
;
€ó¿d 
€ö¿" 
€õ¿"8? ?¢ˆã@0

€û¿
þ¿ò¿
þ¿ó¿d m


€û¿"
8
þ¿ò¿;
ÿ' ||
ÿ' ||ÿ'Odd Days Compound‹ÿ
)\ÂõpŒ@|
€€
€ó¿" ?
€ù¿
€ð¿
€ö¿

€ñ¿d m

€ù¿8
€ñ¿d m

€ù¿:
€ð¿
€ö¿
;
€ñ¿d 
€ô¿" 
€ó¿"8? O¢ˆã@@

€ù¿
þ¿ð¿
þ¿ñ¿d m


€ù¿8
þ¿ñ¿d m


€ù¿:
þ¿ð¿;
ÿ' ||ÿ' [PgDn]||ÿ\=ÿ
\=ÿ\=ÿ\=ÿ'===========||
ÿ' ||ÿ'LOAN SUMMARY:ÿ
"Odd Days (Smpl.)ÿ" Odd Days (Cmpd.)
ÿ' ||
ÿ' ||ÿ'Amortized Interest¢
=
×£°‡Ì@
€€
€€
¢=
×£°‡Ì@
€€
€€

ÿ' ||
ÿ' ||ÿ'Balloon Pmt. (Int.)jÿ
[
۔€ë¿"
€é¿d
€ì¿" 
ۖ۔€é¿d m

€ñ¿"
8
€î¿;
۔?zÿk
þ¿î¿
þ¿ë¿"
þ¿é¿d
þ¿ì¿" 

ۖþ¿î¿
þ¿é¿d m


€ñ¿8
þ¿é¿d m


€ñ¿:
þ¿î¿;
þ¿î¿
?
ÿ' ||
ÿ' ||ÿ'TOTAL Interest Dueÿ
=
×£°‡Ì@~
€þ¿
€é¿"
ە۾ۓ
€ç¿d m

€ï¿"
8
۾ۓ;
€ç¿d 
€ê¿" 
€é¿"8 
€é¿"
€ì¿ 
۾?ÿ=
×£°‡Ì@Ž
€þ¿
þ¿é¿"

ەþ¿æ¿
þ¿ì¿

þ¿ç¿d m


€ï¿8
þ¿ç¿d m


€ï¿:
þ¿æ¿
þ¿ì¿
;
þ¿ç¿d 
þ¿ê¿" 
þ¿é¿"8 
þ¿é¿"
þ¿ì¿ 
þ¿æ¿
?
ÿ' ||
ÿ' ||ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-
ÿ'----||
ÿ' ||ÿ 'Amort. Prin. Pmts.¢
ˆã@
ۉۏ¢ ˆã@
þ¿â¿
þ¿è¿

ÿ ' ||
ÿ!' ||ÿ"'Balloon Payment¢
"
€æ¿¢"
þ¿æ¿
ÿ"' ||
ÿ#' ||ÿ$'TOTAL Principal¢
$ˆã@
۟€þ¿ ¢$ˆã@
۟€þ¿ 
ÿ$' ||
ÿ%' ||ÿ&'TOTAL PRN + INT¢
&Âõ(ì©ê@
€ö¿
€þ¿ ¢&Âõ(ì©ê@
€ö¿
€þ¿ 
ÿ&' ||ÿ'' [End]||ÿ(\=ÿ
(\=ÿ(\=ÿ(\=ÿ('=============