Category : Lotus and other Spreadsheets
Archive   : CHAP123.ZIP
Filename : CHAP.WK1

ÿ
' Load discount points:







ø?5ÿ
' Credit Provided = Loan-NetFees: (B) =¢
bé¶1ê?ð@
ø€€


'DOWN

'N32#ÿ
' Estimated closing costsÿ'ÿ' Percent Down:
2š™™™™™¹?
2 š™™™™™©?
2
"FHA'FEES
'P13#ÿ
' Loan qualification dataÿ'ÿ' Required PMI or MIP:
2{®Gáz„?
2 {®Gáz„?
2
‹lçû©ñ¢?u'y ÿ ' Total finance charge:ÿ"(A)-(B) = ¢Äf>xDA



'FIN.CHG
'Q16ÿ
\-ÿ\-ÿ\-ÿ\-ÿ' Additional monthly PMI:
2-Cëâ6?
2 -Cëâ6?ÿ
' NA ÿ' \"ÿ ' Annual percentage rate:
3c曥 ¥»?)ÿƛð

# WORKING !;3ÿ'FIN.CLOSING
'L26&ÿ
'To return to this menu anytime:ÿ' ÿ' Financed closing costs:ÿ' NAÿ ' NA
"
Üÿ' Fin. MIP?ÿ \-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-'FIN.MIP
'L27ÿ
'Shareware notice and anÿ\-ÿ\-ÿ\-ÿ \-ÿ
\-ÿ\-/ÿ
' Press to Recompute APR
'HAZINS 'I7&ÿ
' important program message:ÿ' 7ÿ' for Main Menu, for Summary of Loan,ÿ
' Press for Main Menu ö
'HUD800
'L78ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ \-ÿ
\-ÿ\-ÿ \-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-
'HUD803
'L72Hÿ' WELCOME to the Conventional Home Amortization Program (CHAP)4ÿ' Summary of Loan, Closing Cash, and TIL/APR1ÿ
' Macro Set-up for TIL/APR Computation
'HUD804
'L73-ÿ
' Version 1.0, 15 January 1990ÿ\-ÿ\-ÿ\-ÿ \-ÿ
\-ÿ\-ÿ \-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-
'HUD900
'L90ÿ\-ÿ
\-ÿ\-ÿ\-ÿ\-ÿ\-ÿ'REQUIRED MORTGAGE AMOUNTÿ ' CASH REQUIRED TO CLOSE
'HUD903
'L88Nÿ' CHAP is user supported software (shareware). You are granted a limitedÿ' Purchase Offer¢ñ@
€ì¿ÿ ' Total closing costs¢Ögf]†Å¶@
‡'INTEREST
'N29Mÿ' license to use CHAP, and to copy it and distribute it, provided that:ÿ' + Closing costs fin'cd$¢p—@
€€FHA
€ø¿;ÿ ' - Financed costs$¢p—@
€€FHA
ÿ€ø¿;ÿ ' --- Labels ---
'MACROS'Y101@ÿ' 1) No fee is charged for copying and distribution, andÿ' - Down payment¢¨@
€€ÿ ' - MIP financed3¢{®G!N¤@$
ý€ï¿
€õ¿Y
€€
ý€ê¿;
ÿ 'UCR
(e.¯-ƒ?


 ÿ"\Xÿ'{let COUNT,0}{goto}M1~'MAX.PITI
'K58Lÿ' 2) CHAP may ONLY be distributed in its original, unmodified state.ÿ' = Basic loan required!¢´ð@
€ý¿
€þ¿
€ÿ¿
ÿ ' + Down payment¢¨@
€€ÿ 'TYPE!
ěð
 FHA;3 
FHA,ÿ'{let APR,+interest+0.1*FEES/MORTGAGE}
'MIP
'N33Kÿ' Please feel free to modify your personal copy in any way that suitsÿ' + MIP financed (FHA)3¢{®G!N¤@$
ے€ó¿Y
€€
€è¿;!ÿ ' = Total cash needed toÿ 'INTEREST3
š™™™™™¹?$
 

û€ï¿
 
ü€ï¿
ý€ï¿;;ÿ'{for COUNT,1,50,1,P31}'MORTGAGE
'I30Jÿ' your home purchase and lender conditions. If you find this programÿ' = Required mortgage ¢¤p=

Wñ@
€þ¿
€ÿ¿ ÿ ' close on deal'¢™]¹uŲ@
€û¿
۟
€ý¿

€þ¿ ÿ 'TERM3
>@$
 

û€ï¿
 
ü€ï¿
ý€ï¿;;'MPMI
'N342ÿ' useful, you are encouraged to send $10 to:
ÿ 'POINTS3
ø?$
 

û€ï¿
 
ü€ï¿
ý€ï¿;;ÿ'{goto}APR~ 'OFFER 'I5ÿ'MONTHLY PAYMENT (PITI)ÿ ' TRUTH-IN-LENDING (APR)ÿ 'DOWNY
¨@J
 

û€ï¿
û€å¿
 
ü€ï¿
û€å¿îš™™™™™©?
û€å¿
ý€ò¿ ¨a
 ;;<ÿ'{let BALANCE,((1+APR/12)^(TERM*12)*(UCR-APR/12)-UCR)}
'OPTION
'I10Iÿ ' Colin K. Drummond, P.O.Box 770797, Lakewood, OH 44107-0037ÿ ' Principal+Interest(PI)(¢ SàäÇKzƒ@
€ý¿
۟€ý¿ 8ÿ ' Total of payments¢ uÛ‘úcA
ý€€ 
€ý¿
ÿ 'MIP=
›oH££?.
 

û€ï¿
 
ü€ï¿
ý€ï¿u“Vð?;; ÿ '{if BALANCE<0}~{forbreak}  'PI
 'I33ÿ!' Monthly PMI surcharge ¢!
€€
€ü¿ÿ !' Actual creditÿ !'MPMI1
!"
 

û€ï¿
 
ü€ï¿;;ÿ!'{let APR,+APR+0.0001}!'PITI
!'I37Lÿ"' WARNING: This program is intended to faithfully perform calculationsÿ"' Property Taxes (T)¢"«ªªªªÊS@

€ã¿ ÿ "' borrower receives¢"bé¶1ê?ð@

 ÿ "'COUNT

"
"'POINTS
"'N31Oÿ#' based on YOUR inputs; CHAP assumes a specific calculation sequence - itÿ#' Hazard Insurance (I)¢#«ªªªª*-@

€ã¿ ÿ #' Total finance chge¢#Äf>xDA
ÿ #'BALANCE

#яIUç&¿#'PTAX #'I6Nÿ$' is impossible to warrant CHAP will mimic calculations of every lender.ÿ$"PITI¢$SàäÇKh†@ €ü¿€ÿ¿P
ÿ $' Actual APR²$c曥 ¥»?
$'STEP
$'P32Jÿ%' CHAP provides Estimates - please use Common Sense. Thank You, CKD.ÿ%\-ÿ%\-ÿ%\-ÿ %\-ÿ
%\-ÿ%\-%'TERM
%'N30,ÿ&' Press for Main Menu ö&
&'TIL
&'Q17ÿ'\-ÿ
'\-ÿ'' Press to STARTÿ''> to STARTÿ'\-ÿ'\-1ÿ'' Press for Loan Qualification''TOT.FIN ''Q4ÿ(\-ÿ(\-ÿ(\-ÿ (\-ÿ
(\-ÿ(\-('TYPE
('N28ÿ)' Loan Qualification)ÿ)'-- Old Macro Execution Routine ---
)'UCR
)'N27ÿ*\-ÿ*\-ÿ*\-ÿ *\-ÿ
*\-ÿ*\-)ÿ*'-- Based on LOTUS old V1.0 /xi --- *'\0*'AC116..AC117"ÿ+' Ave. gross monthly income
" + ÿ+"\Y6ÿ+'{goto}M1~{goto}APR~+interest+0.1*FEES/MORTGAGE~ +'\A+'Z106..Z107
2,ìQ¸…ëÑ?ÿ,' Income Ratio¢ ,ð‘@
ý€€
€ÿ¿ÿ
,'<--1---+ÿ,'{goto}count~0~{goto}M1~ ,'\B,'Z108..Z109
2-
×£p=
×?ÿ-' Debit Ratio (A)¢ -—@
ý€€
€þ¿ÿ
-' |ÿ-'/dfAPR~APR+0.0001~~~ -'\C-'Z110..Z111ÿ
.' |ÿ.'/dfcount~count+1~~~ .'\D.'Z112..Z113ÿ/' Monthly debt payments:ÿ
/' |;ÿ/'{let BALANCE,+(1+APR/12)^(TERM*12)*(UCR-APR/12)-UCR} /'\E/'Z114..Z115ÿ0' Auto Loans
" 0…ëQ¸5m@ÿ
0' |ÿ0'/xibalance<0~/xq 0'\F0'AC106..AC107ÿ1' Student Loans
" 1Eÿ
1' Minimum ofÿ1'/xicount>500~/xq 1'\G1'AC108..AC109ÿ2' Installment debt
" 2ÿ
2' 1 & 2ÿ2'/xgcontinue~ 2'\H2'AC110..AC111)ÿ3' Credit Cards (use 5% of bal.)
" 3Èÿ
3' | 3'\I3'AC112..AC113ÿ4' Other monthly debt
" 4ÿ
4' | 4'\J4'AC114..AC115ÿ5' TOTAL monthly debit
ÿ5"(B)¢ 5áz®GU€@ €û¿€ÿ¿P
ÿ
5' | 5'\P5'Z124..Z133ÿ
6' | 6'\Q6'AC124..AC139ÿ7'Debit Limit = (A) - (B)¢ 7…ëQ¸Ê@
€ö¿
€þ¿
ÿ
7'<--2---+ 7'\R7'Z135..Z140ÿ
8' | 8'\X8'P27..P35+ÿ9'Qualified for loan with MAX PITI of:¢
9…ëQ¸Ê@

ÿ€ó¿
ÿ€þ¿S 9'\Y9'P44..P52ÿ:\-ÿ:\-ÿ:\-ÿ :\-ÿ
:\-ÿ:\- :'\Z:'AC119..AC120Gÿ;' for Main Menu, for Estimated Closing Costs ; ;ÿ<\-ÿ<\-ÿ<\-ÿ <\-ÿ
<\-ÿ<\-ÿ <\-ÿ
<\-ÿ<\-ÿ<\-ÿ<\-ÿ<\- < </ÿ=' Estimated Contract Closing Costs ÿ='PITI Sensitivity Analysis = =ÿ>\-ÿ>\-ÿ>\-ÿ >\-ÿ
>\-ÿ>\-ÿ >\-ÿ
>\-ÿ>\-ÿ>\-ÿ>\-ÿ>\- > >
ÿ?'HUD ÿ?'Typical Items To Considerÿ
?^Borrower'sÿ?^Borrower's1ÿ
?'Sensitivity to Interest Rate and Loan Term ? ? ÿ@' # ÿ@'for Closing or Settlementÿ
@^Fractionÿ@^Cost @ @!ÿA' Please be patient....ÿA'---- ----------ÿA\-ÿA\-ÿ A'----------ÿ
A' ----------ÿA' ----------(ÿA' Term of the Loan (years) A A"ÿB'700. TOTAL SALES COMMISSION ¢B
2 BìQ¸…ë±?
2
B%¢B
ý€Û¿ìQ¸…ë±?
ÿ€€u
BSàäÇKh†@
û€â¿
B

B
B B B
2
C{®Gáz´?
"C)ž?¾Û@
"Cí-º“ñ#ˆ@
"CŸA27ƒ@ C C1ÿD'800. ITEMS PAYABLE IN CONNECTION WITH LOAN ¢D
2
DÃõ(\Âµ?
"D&5t+ÆrŽ@
"D£,m7Ɉ@
"DΚ­èþƒ@ D DÿE' Working !!! ÿE'801. Loan Origination Fee
2 E{®Gáz„?
2
E
!¢Eb…@
ý€Ö¿
þ€€
ÿ€€
2
E
×£p=
·?
"E” ýiŸ@
"E]œ£üp‰@
"E2@Í6ÎɄ@ E EÿF'802. Loan Discount
2 F¸…ëQ¸Ž?
2
F
!¢F².n£q¥@
ý€×¿
þ€€
ÿ€€ÿ F' Interest
2
FR¸…ëQ¸?
"Fˆ˜
¾E¦@
"FðŸÎß4Š@
"Fﶚ³«—…@ F FÿG'803. Appraisal Fee
" G®
2
G
¢GÀe@
þ€€
ÿ€€ÿ G' Rate
2
Gš™™™™™¹?
"G’Rä^Z!@
"GOnÓNJ@
"GSàäÇKh†@ G GÿH'804. Credit Report Fee
" H(
2
H
¢HD@
þ€€
ÿ€€
2
Ház®Gáº?
"H®
9êsp@
"H¡³ŸCËv‹@
"H –ñz;‡@ H HÿI'Is your printer on ?#ÿI'805. Lender's Inspection Fee
" I(
2
I¢I
þ€€
ÿ€€
2
I)\Âõ(¼?
"I¯Á%"mÀ@
"I½4(Œ@
"IðɼÁˆ@ I I.ÿJ'806. Mortgage Insurance Application Fee
" J
2
J¢J
þ€€
ÿ€€
2
Jq=
×£p½?
"J4>”C‘@
"J"üº.‘ÛŒ@
"Jÿ6ŽÃèˆ@ J JÿK'807. Assumption Fee
" K
2
K¢K
þ€€
ÿ€€ 
K K KÿL'808. Tax Service Fee
" L
2
L¢L
þ€€
ÿ€€7ÿ
L'Interest Rate Label is named INTEREST (cell N29) L L ÿ
M"TOTAL¢M².n£q®ž@ €ø¿€ÿ¿P
0ÿ
M'Term of the Loan is named TERM (cell N30) M Mÿ N\-ÿ
N\-ÿN\-ÿN\-ÿN\-ÿN\- N NGÿO' Enter for Main Menu or for HUD900-HUD10000ÿ
O'Press to Update Sensitivity Analysis O OÿP\-ÿP\-ÿP\-ÿ P\-ÿ
P\-ÿP\- P P
ÿQ'HUD ÿQ'Typical Items To Considerÿ
Q^Borrower'sÿQ^Borrower's Q Q ÿR' # ÿR'for Closing or Settlementÿ
R^FractionÿR^Cost R RÿS'---- ----------ÿS\-ÿS\-ÿ S'----------ÿ
S' ----------ÿS' ---------- S S:ÿT'900. ITEMS REQUIRED BY LENDER TO BE PAID IN ADVANCE ¢TÿU'901. Int. @ ¥Uÿ¥óiu3@
€Ç¿m


€È¿ÿU'/day for
 Uÿ
U'days¢Uwí0]@
ü€€
þ€€&ÿV'902. Mortgage Insurance Premium¢ V{®G!N¤@
€Ê¿
ÿ€®¿
2
V
¢V{®G!N¤@
þ€€
ÿ€€$ÿW'903. Hazard Insurance Premium¢ Wàe@
ÿ€¯¿
2
W
¢Wàe@
þ€€
ÿ€€#ÿX'904. Flood Insurance Premium
" X
2
X
¢X
þ€€
ÿ€€ 
Y¢YçÐ?¢•¦@ €ü¿€ÿ¿P
+ÿZ'1000. RESERVES DEPOSITED WITH LENDER ¢Zÿ['1001. Hazard Insurance
[ÿ ['months @¢
[«ªªªª*-@

þ€«¿ ¢[àE@
ý€€
ÿ€€ÿ\'1002. Mortgage Insurance
\ÿ \'months @ ¢
\¢\
ý€€
ÿ€€ÿ]'1003. City Property Tax
]ÿ ]'months @¢
]«ªªªªÊS@

þ€¨¿ ¢]
°m@
ý€€
ÿ€€ÿ^'1004. County Prop'ty Tax
^ÿ ^'months @ ¢
^¢^
ý€€
ÿ€€ÿ_'1005. Annual Assessments
_ÿ _'months @ ¢
_¢_
ý€€
ÿ€€ÿ`'1006. Flood Insurance
`ÿ `'months @ ¢
`¢`
ý€€
ÿ€€¢a
”q@ €ú¿€ÿ¿P
Fÿc' Enter for Main Menu or for HUD1100 Panelÿd\-ÿd\-ÿd\-ÿ d\-ÿ
d\-ÿd\-ÿd\-ÿd\-ÿd\-ÿd\-ÿd\-ÿd\-
ÿe'HUD ÿe'Typical Items To Considerÿ
e^Borrower'sÿe^Borrower'sÿe'Macro Definition Window ÿf' # ÿf'for Closing or Settlementÿ
f^Fractionÿf^Costÿf\-ÿf\-ÿf\-ÿf\-ÿf\-ÿf\-ÿg'---- ----------ÿg\-ÿg\-ÿ g'----------ÿ
g' ----------ÿg' ----------ÿg' Input Panels ÿg' View Computed Resultsÿh'1100. TITLE CHARGES ¢h&ÿi'1101. Settlement or closing fee
" iô

2
ià?¢i@o@
þ€€
ÿ€€ ÿi"\Aÿi'{goto}G1~ ÿi"\Fÿi'{goto}G21~%ÿj'1102. Abstract or title search
" j
2
j¢j
þ€€
ÿ€€ÿk'1103. Title examination
" k

2
k¢k
þ€€
ÿ€€ ÿk"\Bÿk'{goto}G61~ ÿk"\Gÿk'{goto}M1~#ÿl'1104. Title insurance binder
" l
2
l¢l
þ€€
ÿ€€%ÿm'1105. Document preparation fee
" m_
2
m¢m
þ€€
ÿ€€ ÿm"\Cÿm'{goto}G141~ ÿm"\Hÿm'{goto}M61~ÿn'1106. Notary fees
" n
2
n¢n
þ€€
ÿ€€ÿo'1107. Attorney's fees
" o(
2
o¢o
þ€€
ÿ€€ ÿo"\Dÿo'{goto}G41~ ÿo"\Iÿo'{goto}A1~ÿp'1108. Title insurance
" pfffffæ~@
2
p)\Âõ(ä?¢pd;ßOws@
þ€€
ÿ€€ÿq'1109. Lender's coverage
" q
2
q¢q
þ€€
ÿ€€ ÿq"\Eÿq'{goto}A1~ ÿq"\Jÿq'{goto}A1~ÿr'1110. Owner's coverage
" r
2
r¢r
þ€€
ÿ€€ÿs'1111. Tax examination
" s
2
s¢s
þ€€
ÿ€€ ÿs"\0ÿs'{goto}A21~ÿt'1112. Other
" t
2
t¢t
þ€€
ÿ€€ÿt\-ÿt\- ÿt'-- ¢ u ²
u¢u²ï§Æ‹@ €ô¿€ÿ¿P
!ÿu' for PRINTER MACROS$ÿu' Move to this macro screenÿv\-ÿv\- ÿv'-- ÿv"\Zÿv'{goto}Y101~Gÿw' Enter for Main Menu or for last HUD panelÿx\-ÿx\-ÿx\-ÿ x\-ÿ
x\-ÿx\-
ÿy'HUD ÿy'Typical Items To Considerÿ
y^Borrower'sÿy^Borrower'sÿy' Print Range Macros ÿz' # ÿz'for Closing or Settlementÿ
z^Fractionÿz^Costÿ{'---- ----------ÿ{\-ÿ{\-ÿ {'----------ÿ
{' ----------ÿ{' ---------- ÿ{"\Pÿ{'{goto}A61~{windowsoff} ÿ{"\Qÿ{'{goto}A61~{windowsoff}6ÿ|'1200. GOVERNMENT RECORDING AND TRANSFER CHARGESÿ|'/ppoh~qÿ|'/ppoh~qÿ}'1201. Recording fees
" }@B@
2
}è?¢}`;@
þ€€
ÿ€€ÿ}'a~rG1..L18~gÿ}'a~rG61..L79~g#ÿ~'1202. City/county tax/stamps
" ~
2
~¢~
þ€€
ÿ€€ÿ~'rG160~gÿ~'rG85..L99~gÿ'1203. State tax/stamps
" $

2
¢
þ€€
ÿ€€ÿ'rG21..L37~gÿ'rG105..L119~g ¢ € ²
€¢€`;@ €ý¿€ÿ¿P
ÿ€'rG160~gÿ€'rG125..L129~g*ÿ'1300. ADDITIONAL SETTLEMENT CHARGESÿ'rG141..L159~gqÿ'rA201~gÿ‚'1301. Survey
" ‚i
2
‚
¢‚@Z@
þ€€
ÿ€€ÿ‚'{windowson}{home}ÿ‚'rG61..L66~gÿƒ'1302. Pest inspection
" ƒF
2
ƒ¢ƒ
þ€€
ÿ€€ÿƒ'{down 13}{right 4}ÿƒ'rG130..L137~gÿ„'1303. Other
" „
2
„¢„
þ€€
ÿ€€ÿ„'rG160~g¢…@Z@ €ý¿€ÿ¿P
ÿ…'rG141..L158~g ÿ†"\R$ÿ†'{goto}A61~{windowsoff}/ppoh~qÿ†'rG141..L141~g ÿ‡'1400. Total Closing Costs3¢‡Ögf]†Å¶@$
ۮ€Ò¿
€Ú¿
۔€ù¿
€þ¿ ÿ‡'a~rG41..L59~gÿ‡'rA201~gqÿˆ\-ÿˆ\-ÿˆ\-ÿ ˆ\-ÿ
ˆ\-ÿˆ\-ÿˆ'rA201~gqÿˆ'{windowson}{home},ÿ‰' Press for Main Menu ö‰ÿ‰'{windowson}{home}ÿ‰'{down 14}{right 4}6ÿŠ' Press

to Print Closing Cost EstimatesÿŠ'{down 15}{right 4}5ÿ‹' Press for Truth-In-Lending AnalysisÿŒ\-ÿŒ\-ÿŒ\-ÿ Œ\-ÿ
Œ\-ÿŒ\-ÿ' Cash Flow Estimateÿ
^Buyer Paysÿ^BalanceÿŽ\-ÿŽ\-ÿŽ\-ÿ Ž\-ÿ
Ž' ----------ÿŽ' ----------2ÿ' 0) TOTAL of closing costs and down payment¢ë3³.CdÁ@
‡

 (ÿ' 1) Deposit to seller to hold bid
¢
è!¢Ögf]†à¾@
‡




3ÿ‘' 2) Items to pay at time of loan application ¢
‘(ÿ’' 803. Appraisal Fee (Y/N)? ’'y$¢
’Àe@
ÿ¿€Y

€µ¿;(ÿ“' 804. Credit Report (Y/N)? “'y$¢
“D@
ÿ¿€Y

€µ¿;%ÿ”' XXX. Other (enter amount)
"
”ÿ•'Subtotal of Item #2:¢
•Àj@ €ý¿€ÿ¿P
!¢•Ögf]†
¾@
ÿ€ý¿ÿ€ÿ¿P

)ÿ–' 3) Prepay hazard insurance (Y/N)? –'y$¢
–àe@
ÿ¿€Y
W;¢–Ögf]†[½@
€ÿ¿
ÿ¿€
'ÿ—' 4) Adjustments on closing date:ÿ —^By Bank"ÿ˜' Financed closing costs¢ ˜p—@
ÿ™' MIP financed¢ ™{®G!N¤@
!¢™1»së°ª@
€ý¿
þ¿ÿ¿

þ¿€
ÿš' Down Payment¢
š¨@

 ¢š$ÿ›' Cash to zero out balance  ›¢
›ˆÙõ˜[Wu@

€þ¿
€ÿ¿
 ¢›ÿœ'Subtotal of Item #3:¢
œ1»së°ª@
€þ¿
€ÿ¿ ¢œ
€ý¿
ÿ¿€
"ÿ' TOTAL CASH BUYER HAS PAID:'¢
™]¹uŲ@
€ó¿
€ø¿
€ù¿
€ÿ¿ ÿž\-ÿž\-ÿž\-ÿ ž\-ÿ
ž\-ÿž\-,ÿŸ' Press for Main Menu öŸ ÿÈ|::