))) ) )I) <) <)<) <) <)<) < )< ) ))))X))Xw)Xw)Xw )Xw )< )Xq ):<)@})B)))EE(w_E _E _E _E _E% _E    _E_E% " AMORTIZATIONt ANS_INFOPRTtZ Z ANS_KEEPDATAt  ANS_MACROPRT1ts s ANS_MACROPRT2tt t ANS_MACROPRT3tu u ANS_SWAPDATAt< < ANS_UPDDATAt  BACKGRNDTAt%% BCK_COLTAt-- BCK_LOOPTAt(( CLEAN_LISTt CLEAN_LOOPt COUNTRYOPt CURR_SCENtoo DATA_01Nt  DEL_SCENARIOt DLG_INFOPRTtWW DLG_KEEPDATAt DLG_KHELPTAt DLG_MACPRINTtpp DLG_PERSONALt}} DLG_SAMPLE1tqq DLG_SAMPLE2tzz DLG_SWAPDATAt99 DLG_UPDDATAt DLG_UPDSCAtCC DLG_UPDUNAtLL D_VERSIONSt FRM_UPDSCtFF INFORMATIONt INFO_ABOUTtzz INFO_CONVENTION INFO_CURR_PRTNBB INFO_LISTPRTNMS INFO_NOTESFXNJJ INFO_OVERVIEWN== INFO_PRINTEWN00 INFO_STEPSEWNvv INFO_TIPSEWN INFO_TOPICEWNUU INF_ABOU_RANGE| INF_CONVENTION# INF_COUNTRY_RNG INF_NOTE_RANGELV INF_OVER_RANGE?N INF_STEP_RANGEx INF_TIPS_RANGE KEEPDATARANGE K_EXISTSRANGE K_HELPSRANGE K_LIMITRANGE K_UPDATERANGE K_VERSIONSNGE LIST_ADDRNGE LIST_RNGNGE MACROSGNGE MACROS_RANGEE MACRO_HIDEEEYY MACRO_PRINTEbb MACRO_SHOWEVV NOTES FIELDSE NOTES_FIELDSE NOTES_SHOWSE]] NO_UPDATESE77 PERSONALIZEE{{ PREV_SCENEEnn RES_SCENEE RES_INFOPRTEX X RES_KEEPDATAE  RES_MACROPRTEq q RES_SAMPLE1Er r RES_SAMPLE2E{ { RES_SWAPDATAE: : RES_UPDDATAE  RES_UPDSCAED D RES_UPDUNAEM M RNG_NAMEAE RNG_NUMAE RN_TABLEAE RN_TABLE_RANGE SAMPDATARANGEaa SAMP_RESTOREEjj SCENARIO_LIST  SHEET_RANGET< SHT_PRINTET SWAPDATAET TABLE_CONTENTS UPDATEONTENTS"" UPDATE_LISTTS  UPDATE_LOOPTS11 UPDATE_POSTTS00 UPDATE_TESTTS++ UPDUN_TESTTS UPPER_LEFTTSKK UP_EXISTINGTS UP_UNNAMEDTS ZM_ALLMEDTS ZM_NRMLEDTS ZM_RESTORETS ZM_SCRNRETS   ZM_TABLEETS ZOOM_RTNETS ZOOM_TESTTS \0M_TESTTS XSTESTTS  DF0TESTTS DS0TESTTS  DSKTESTTS  RN0TESTTS| RS0TESTTS!   ?? @VName8LBLBq+q+q+ 6Contents60/C6Amortization60/C 6Macros6_0/C6Information6"0/C  Arial! Arial"  Arial# Arial$  Arial%%Times New Roman&  Arial MT' Arial(  Arial MT)  Arial*  Arial+  Arial, Arial%-Times New Roman.  Arial/ Arial0  Arial1 Arial2  Arial3  Arial4 Arial5  Arial6 Arial MT7  Arial MT8 Arial9  Arial: Arial; Arial MT< Arial=  Arial>  Arial? Arial@  ArialA ArialB ArialC  ArialD ArialE  Arial MTF ArialG ArialH  ArialI  ArialJ  ArialK  ArialL ArialM ArialN Arial MTQ GillSansR ArialJ!3- # )C+: <3 <3 .+'3_  _!,"4#.$=_ %6&;'C (N )J*&+3_ , -__./>0C1)2$3* 4) 5.6C 7)_8>93:5;0<9=9><?_@2AJ+BCC!D!9EAF!9GBHA9IJI2 K1 L0M%N"OJP!2 QJR!2 "SD TKUC_V!2WLXM YJ+Z, [!2\ <] ^J_J`# a b, c?d" eFfF gG hHi" jGkG lF mH n!2 o p22qH rsG t22u22 vH w"{8 |22}22~!2!2 (_ N__ >C&& Q_ &"2@@STYL1R Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2 Normal Undefined"2Normal Undefined"2Normal Undefined"2Normal Undefinedq0*@@@ @@@ @@ @ @  @@ @ @  @ @@@ @@@:@:@@ @@@:@:@@ @@@:@:@@ @@@:@@@ @@@:@@@ @@:;@ @@;   @;@ @#@ ```````` ` ` ` ` ` ` ~ @'@@(@  @#@@@@@@ @&@ @@@@ @@"@@&@ @@@@ @@2@&@ @@@@ @@@&@ @@@@ @@@&@ @@@@ @@@ @ @ @   @@ @ @@ @€@@@ @@@@@@ @@ @ @   @@@€@)@@@@@@ @@@@ @@@ ```````` ` ` ` ` ```````````````````# @@@ @ @ @ @! "!#"$#%$&%'&(')(#*@ @@@ @ @ @ @+*,+-,.-/.0/102132435465768798:9;:<; `!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<` ~ @'@ @ @        @@ @@ @@  @@   ````````` ` ` ` ` ``````````````````` ! "!#"$#%$&%'&(')(*)+*,+-.,/0.102@@@ 32435465768798:9;:<;=<>=?> `!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<`=`>`?`@?A@@ B@@@ C@DCEDFEGFHGIHJ@@@ @@ K@@ @@ LJM@@ N@@ ONPOQ@@ RQSPT1U-VTW@ X@@@@YWZ@@@[Z\@@]\^Y_V@`A`B`C`D`E`F`G`H`I`J`K`L`M`N`O`P`Q`R`S`T`U`V`W`X`Y`Z`[`\`]`^`_``/a_b@@ cbdcedfegfhgiajikjlkmlnUonpmq^rXsqt]utvuwvxsypzx{r|z}w~}~``a`b`c`d`e`f`g`h`i`j`k`l`m`n`o`p`q`r`s`t`u`v`w`x`y`z`{`|`}`~``|y`@@@  @@   ```````````````````````````@@@@```@@@ {@ @````````````````````````````````[h````````````````````````````````o@@ ````````````````````````````````          ````````` ` ` ` ` ``````````````````` !"!#"$%$&%'#(')(*)+*,+-,.-/.0/1021324354657869:;9<=>=?> `!`"`#`$`%`&`'`(`)`*`+`,`-`.`/`0`1`2`3`4`5`6`7`8`9`:`;`<`=`>`?`@?A;B8CAD:ECF@GFHGIHJEKBLJMDNLOIPOQPRQSNTKUVTWVXWYXZY[Z\U][^]_^@`A`B`C`D`E`F`G`H`I`J`K`L`M`N`O`P`Q`R`S`T`U`V`W`X`Y`Z`[`\`]`^`_``_a\b`c@@ d@@ edfegfhgihjikjlkmlnmobpS!q@@@@@r@ @"s@@@@tsutvRwvxpyoz { |{}|~ }``a`b`c`d`e`f`g`h`i`j`k`l`m`n`o`p`q`r`s`t`u`v`w`x`y`z@@{ | } ~   @ y@€@@@@@@@@@@@@@@              ```````````````````@@@@!@@@@@@@@@@@@`````````````````````````````````````````````````````````@@@@@@@@@@@@@@a   @@@@@@@@@@@@@@@@@@@@` @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@          @@@@@@@@@@@@@@@@@@ @@ @@ @@ @@ @@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@ ! "!#"$#%$&%'&(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?> @@!@@"@@#@@$@@%@@&@@'@@(@@)@@*@@+@@,@@-@@.@@/@@0@@1@@2@@3@@4@@5@@6@@7@@8@@9@@:@@;@@<@@=@@>@@?@@@?A@BACBDCEDFEGFHGIHJIKJLKMLNMONPOQPRQSRTSUTVUWVXWYXZY[Z\[]\^]_^@@@A@@B@@C@@D@@E@@F@@G@@H@@I@@J@@K@@L@@M@@N@@O@@P@@Q@@R@@S@@T@@U@@V@@W@@X@@Y@@Z@@[@@\@@]@@^@@_@@`_a`bacbdcedfegfhgihjikjlkmlnmonpoqprqsrtsutvu`@@a@@b@@c@@d@@e@@f@@g@@h@@i@@j@@k@@l@@m@@n@@o@@p@@q@@r@@s@@t@@u@@v@@ ~@'@@ @@ @@@ @ @ @ @ @ @ @@ @ @ @ @ @ @ @ @ @ @    @ @ @ @  @ @ @ @       @ @@ @ @ @@ @ @! "!#"$#%$&%'& ```@@@@@@ @ @ ` ` ```@@``@@@@ @!@"@#@$@%@&@'@(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=@>@@?@@@@A@@B@CBDCEDF@GE(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@= `>@?`@ A`B`C`D`E`F`G`HFIGJIKJLKMLN@@@O@@@ PQPRQSRTSUTVUWVXWYXZY[Z\[]\^]_^`_a`bacbdcedfegfH`I`J`K`L`M`N`O@P@Q@R@S@T@U@V@W@X@Y@Z@[@\@]@^@_@`@a@b@c@d@e@f@g@hgihjikjlkmlnmonpoqprqsrtsut vwux?y@z@@{N|@@@}{~|}~wh@i@j@k@l@m@n@o@p@q@r@s@t@u@v @w@x`y z`{`|`}`~`````@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@xy@ @@` ```````@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@` ```#@@@@@````````````````````````````````          @ @@ #@ @@@ @"@ @@@ @@@  !" #"$%$&%'&` ` ` ` ` ````````@@@` `````` `!`"`#`$@%@&@'@(')(*)+*,+-,.-/.0/102132435465768798:9;:<;=<>=?>@?A@BACBDCEDFEGF(@)@*@+@,@-@.@/@0@1@2@3@4@5@6@7@8@9@:@;@<@=@>@?@@@A@B@C@D@E@F@G@HGIHJKILM@@N@O@@POQPR@@SQTSUTVUWKXWYXZY[Z\[]\^]_^`_a`bacbdcedfegfH@I@J @K@L`M N`O`P`Q`R`S`T`U`V`W@X@Y@Z@[@\@]@^@_@`@a@b@c@d@e@f@g@hgihjikjlkmlnmonpoqprqsrtsutvuwvxwyxzJ{y|L}M~@@@VRh@i@j@k@l@m@n@o@p@q@r@s@t@u@v@w@x@y@z @{@|`} ~``````````{`@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@L@@@@@@@@@ ~@@''^Mortgage Amortization SmartMaster^Table of Contents9^Click a tab or a button to use a SmartMaster sheet.'  'Sheet'Description%bGC SheetnamelAmortization9'Calculate the first 12 months of payments and up to9'30 years of annual payments for your mortgage here. 'Information@ 'Help, tips, and details on file sharing, conventions, and & 'macros used in this SmartMaster.^Mortgage Amortization^Key Figures 'Inputs'Annual Loan Payments'Loan Principal Amount 'Monthly PaymentsL z@<<@123>>ISEMPTY(   8?;'Annual Interest Rate %'Interest in First Calendar YearD z@<<@123>>ISEMPTY( Dec  U;'Loan Period in Years  'Interest Over Term of Loan= z@<<@123>>ISEMPTY( <T;'Base Year of Loan 'Sum of All Payments 'Base Month of Loan  "Jan! ^Payments in First 12 Months "Beginning  "Cumulative  "Cumulative   "Ending  'Year 'Month "Balance  "Payments  "Principal  "Interest  "Principal  "Interest   "Balance C@ @ z@<<@123>>ISEMPTY( ;;DC z@<<@123>>ISEMPTY(U;Jan % ? GC z@<<@123>>ISEMPTY( ;;D>C z@<<@123>>ISEMPTY(U;Feb % ? GlC z@<<@123>>ISEMPTY( ;;D6dC z@<<@123>>ISEMPTY(U;Mar % ? GoC z@<<@123>>ISEMPTY( ;;DC z@<<@123>>ISEMPTY(U;Apr % ? GBC z@<<@123>>ISEMPTY( ;;DL>C z@<<@123>>ISEMPTY(U;May % ? GB~C z@<<@123>>ISEMPTY( ;;DvMC z@<<@123>>ISEMPTY(U;Jun % ? GC z@<<@123>>ISEMPTY( ;;DC z@<<@123>>ISEMPTY(U;Jul % ? GPC z@<<@123>>ISEMPTY( ;;DxC z@<<@123>>ISEMPTY(U;Aug % ? GJC z@<<@123>>ISEMPTY( ;;DoC z@<<@123>>ISEMPTY(U;Sep % ? GBdC z@<<@123>>ISEMPTY( ;;DGC z@<<@123>>ISEMPTY(U;Oct % ? GNC z@<<@123>>ISEMPTY( ;;DwC z@<<@123>>ISEMPTY(U;Nov % ? GC z@<<@123>>ISEMPTY( ;;DMC z@<<@123>>ISEMPTY(U;Dec % ? .^Yearly Schedule of Balances and Payments"Beginning"Cumulative"Cumulative  "Ending 'Year "Balance"Payments"Principal"Interest"Principal"Interest  "Balancec` @ z@<<@123>>ISEMPTY( Jan T;;;& ;%;SJan JanU ;;U   ;;;9Dec  U;9Dec  U;M    9;;;C  @ ;;;&     ;%    ;[    Jan   ;   ;;U        ;;;%   ;%   ;/    9;C! @     ;;;&!!! !;%!!!!;[!!! Jan   ! ;  ! ;;U!!   !!!;;;%!! !;%!! !;/! ! 9;C" @! !!!;;;&""" ";%"""";[""" Jan! !" ;! " ;;U""   """;;;%""!";%""!";/" " 9;C# @" """;;;&### #;%####;[### Jan" "# ;" # ;;U##   ###;;;%##"#;%##"#;/# # 9;C$ @# ###;;;&$$$ $;%$$$$;[$$$ Jan# #$ ;# $ ;;U$$   $$$;;;%$$#$;%$$#$;/$ $ 9;C% @$ $$$;;;&%%% %;%%%%%;[%%% Jan$ $% ;$ % ;;U%%   %%%;;;%%%$%;%%%$%;/% % 9;C&@ @% %%%;;;&&&& &;%&&&&;[&&& Jan% %& ;% & ;;U&&   &&&;;;%&&%&;%&&%&;/& & 9;C'` @& &&&;;;&''' ';%'''';[''' Jan& &' ;& ' ;;U''   ''';;;%''&';%''&';/' ' 9;C( @' ''';;;&((( (;%((((;[((( Jan' '( ;' ( ;;U((   (((;;;%(('(;%(('(;/( ( 9;C) @( (((;;;&))) );%))));[))) Jan( () ;( ) ;;U))   )));;;%))();%))();/) ) 9;C* @) )));;;&*** *;%****;[*** Jan) )* ;) * ;;U**   ***;;;%**)*;%**)*;/* * 9;C+ @* ***;;;&+++ +;%++++;[+++ Jan* *+ ;* + ;;U++   +++;;;%++*+;%++*+;/+ + 9;C, @+ +++;;;&,,, ,;%,,,,;[,,, Jan+ +, ;+ , ;;U,,   ,,,;;;%,,+,;%,,+,;/, , 9;C-N~C, ,,,;;;-&-X>C-- -;-%-BC---;-[-7C-- Jan, ,- ;, - ;;-U-hC-   ---;;;-%-beC-,-;-%-PC-,-;-/- C- 9;- C.*C- ---;;;.&.0C.. .;.%.0C...;.[.,EC.. Jan- -. ;- . ;;.U.hSC.   ...;;;.%.VC.-.;.%.C.-.;./. NdC. 9;. C/oC. ...;;;/&/vC// /;/%/F4C///;/[/wC// Jan. ./ ;. / ;;/U/OC/   ///;;;/%/&GC/./;/%/C/./;/// C/ 9;/ C0neC/ ///;;;0&0hC00 0;0%07C000;0[0BC00 Jan/ /0 ;/ 0 ;;0U0d>C0   000;;;0%0Z~C0/0;0%0MC0/0;0/0 fC0 9;0 C1TlC0 000;;;1&1uC11 1;1%1&HC111;1[1tSC11 Jan0 01 ;0 1 ;;1U18EC1   111;;;1%10C101;1%1$0C101;1/1 6C1 9;1 C2*C1 111;;;2&2PC22 2;2%2@tC222;2[2x"C22 Jan1 12 ;1 2 ;;2U2DCC2   222;;;2%2C212;2%2bC212;2/2 R4C2 9;2 C3vC2 222;;;3&3oC33 3;3%3ZdC333;3[3C33 Jan2 23 ;2 3 ;;3U3 C3   333;;;3%32GC323;3%3 OC323;3/3 wC3 9;3 C4pC3 333;;;4&4C44 4;4%4D[C444;4[42HC44 Jan3 34 ;3 4 ;;4U4uC4   444;;;4%4`lC434;4%4fC434;4/4 MC4 9;4 C5f~C4 444;;;5&5p>C55 5;5%5BC555;5[57C55 Jan4 45 ;4 5 ;;5U5hC5   555;;;5%5zeC545;5%5>C545;5/5 GC8 9;8 C9 C8 888;;;9&9P[C99 9;9%9C999;9[9$C:: :;:%:r~C:::;:[:MC:: Jan9 9: ;9 : ;;:U:fC:   :::;;;:%:llC:9:;:%:uC:9:;:/: >HC: 9;: C;C: :::;;;;&;ޕC;; ;;;%;ށC;;;;;[;SC;; Jan: :; ;: ; ;;;U;PEC;   ;;;;;;;%;1C;:;;;%;<0C;:;;;/; NC; 9;; C<BC; ;;;;;;<&<QC<< <;<%<XtC<<<;<[<"C<< Jan; ;< ;; < ;;<U<\CC<   <<<;;;<%<C<;<;<%<zC<;<;</< tC< 9;< WG'The template also calculates several key figures, including Annual Loan Payments,XH'Monthly Payments, Interest Paid in the First Calendar year, Interest Paid over theNI'Term of the Loan, and the Sum of All Payments over the Term of the Loan.'SCREEN-ADJUST 'CODE'DESCRIPTION'\0'{ZOOM_TEST})'; Senses screen resolution and sets0'{Let ZM_NRML;@Vlookup(ZM_SCRN;ZM_TABLE;1)}$'; view preferences accordingly/'{Let ZM_ALL;@Vlookup(ZM_SCRN;ZM_TABLE;2)}.'{Set "Window-Custom-Zoom";ZM_NRML}{Quit}'ZOOM_TEST>'{If @Info("Screen-Width")<=640}{Let ZM_SCRN;640}{Return}> '{If @Info("Screen-Width")<=800}{Let ZM_SCRN;800}{Return}@ '{If @Info("Screen-Width")<=1024}{Let ZM_SCRN;1024}{Return} '{Let ZM_SCRN;1280}{Return} 'ZM_SCRN  "NORMAL"FULL PAGE'ZM_TABLE@@T\ 'ZOOM FACTOR 'CODE'DESCRIPTION'ZOOM_RTN-'{Set "Window-Custom-Zoom";ZM_ALL}{Quit})'; Sets view to display entire sheet 'ZM_NRML'; Preferred zoom setting 'ZM_ALL@'; View entire sheet'ZM_RESTORE4'{Set "Window-Custom-Zoom";ZM_NRML}{R}{L}{Quit}'; Resets view to normal'PRINT SHEET 'CODE'DESCRIPTION'SHT_PRINTH'{Set "Print-Range";SHEET_RANGE}{Set "Print-Footer-Center-Text";""}'; Prints spreadsheet pageF'{Set "Print-Orientation";"Portrait"}{Set "Print-Fit-Page";"Yes"}$'{Set "Print-Margin-Top";".75"}E '{Set "Print-Margin-Left";".75"}{Set "Print-Margin-Right";".75"}'!'{Set "Print-Margin-Bottom";".25"}&"'{BACKGRND 0}{Print?}{BACKGRND 2} #'{Quit}%'BACKGRND%'{Define BCK_COL:V}-%'; Sets / Resets light yellow background&'{Let RNG_NUM;1}{BCK_LOOP}('BCK_LOOP>('{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+)'{If 1-@Isrange(@@(RNG_NAME))}{Return},*'{Style-Interior BCK_COL;;;;;+RNG_NAME}.+'{Let RNG_NUM;RNG_NUM+1}{Branch BCK_LOOP} -'BCK_COL-/'PRINT INFORMATION /'CODE/'DESCRIPTION0'INFO_PRINT0'{Define INFO_TOPIC:V}00'; Prints Topics from the Information sheet1'{Dialog DLG_INFOPRT}2'{If RES_INFOPRT=0}{Quit}*3'{Set "Print-Footer-Center-Text";"^"})4'{Set "Print-Centered";"Horizontal"}F5'{Set "Print-Orientation";"Portrait"}{Set "Print-Size";"Fit-All"}#6'{Set "Print-Margin-Top";".5"}C7'{Set "Print-Margin-Left";".5"}{Set "Print-Margin-Right";".5"}'8'{Set "Print-Margin-Bottom";".25"}&9'{Let UPPER_LEFT;@Info("Origin")}':'{If ANS_INFOPRT=0}{INFO_CURR_PRT}?;'{If ANS_INFOPRT}{Select @Vlookup(INFO_TOPIC;INFO_LIST;1)}<'{Style-Interior 0}='{Print?}>'{Style-Interior 2}?'{Edit-Goto +UPPER_LEFT} @'{Quit}B'INFO_CURR_PRTB'{Select INF_OVER_RANGE}$C'{Select-Append INF_STEP_RANGE}$D'{Select-Append INF_TIPS_RANGE}%E'{Select-Append INF_COUNTRY_RNG}$F'{Select-Append INF_CONVENTION}$G'{Select-Append INF_NOTE_RANGE}$H'{Select-Append INF_ABOU_RANGE}I'{Return}K'UPPER_LEFTK'$D:$A$379M'INFO_LISTMM'INF_OVER_RANGENN'INF_STEP_RANGEOO'INF_TIPS_RANGEPP'INF_COUNTRY_RNGQ Q'INF_CONVENTIONR R'INF_NOTE_RANGESS'INF_ABOU_RANGEU'INFO_TOPICUW'DLG_INFOPRT W'DIALOGW'InfoPrintXpXX~X|X0XTX'""X'""#X '"Select Information to Print"X  Y'FONTY Y'"Helv"ZZZvZZ(Z@Z'"button"Z'"Current topic"Z Z [[*[p[[*[@['"button"['"All topics"[ [ \\\P\\\@\'"button" \'"OK"\ ]],]P]]]@]'"button"]'"Cancel"] ^'END DIALOG`'SAMPLE DATA `'CODE`'DESCRIPTIONa'SAMPDATA=a'{Let CURR_SCEN;@Scenariolast(@Cellpointer("Filename"))}9a'; Displays Sample data, preserving existing entries5b'{If @Iserr(CURR_SCEN)}{Let CURR_SCEN;"unnamed"}:c'{If @Exact(CURR_SCEN;"sample")}{Branch SAMP_RESTORE}d'{Dialog DLG_SAMPLE1}e'{If RES_SAMPLE1=0}{Quit}f'{Let PREV_SCEN;CURR_SCEN}g'{UPDATE}*h'{Scenario-Show "sample"}{Calc}{Quit}j'SAMP_RESTOREj'{Dialog DLG_SAMPLE2}j'; Restores previous datak'{If RES_SAMPLE2=0}{Quit}+l'{Scenario-Show PREV_SCEN}{Calc}{Quit}n'PREV_SCEN n'unnamedo'CURR_SCEN o'sampleq'DLG_SAMPLE1 q'DIALOG q'Sample1rprrfrxr`rtr'""r'""r '"Sample Data"r  s'FONTs s'"Helv"tttt0tt@t'"static"mt'"You can use a set of sample data to see how this SmartMaster works. You can restore the data that is"t uuuPuuu@u'"button" u'"OK"u vv,vPvvv@v'"button"v'"Cancel"v ww8ww4ww@w'"static"Ww'"currently in this SmartMaster by clicking the Sample Data button a second time."w x'END DIALOGz'DLG_SAMPLE2 z'DIALOG z'Sample2{p{{d{x{`{T{'""{'""{ '"Sample Data"{  |'FONT| |'"Helv"}}}}0}}@}'"static"[}'"Restore the data that was in this SmartMaster before you displayed the sample data?"} ~~~P~~~@~'"button" ~'"OK"~ ,P@'"button"'"Cancel" 'END DIALOG'KEEP DATA 'CODE'DESCRIPTION'KEEPDATAG'{If @Count(SCENARIO_LIST)=@Rows(SCENARIO_LIST)-1}{Branch K_LIMIT}&'; Stores user-data in a scenario'{Dialog DLG_KEEPDATA}'{If RES_KEEPDATA=0}{Quit}*'{If RES_KEEPDATA=3}{Branch K_UPDATE}('{If RES_KEEPDATA=4}{Branch K_HELP}'{If @Length(@S(ANS_KEEPDATA))<1}{Alert "To create a scenario, you must enter a scenario name. Press OK to return to the Keep Data dialog box."}{Branch KEEPDATA}Z'{If 1-@Iserr(@Scenarioinfo("Creator";@Lower(@Trim(ANS_KEEPDATA))))}{Branch K_EXISTS}3'{Scenario-Create @Lower(@Trim(ANS_KEEPDATA))}!'{Let RNG_NUM;1}{K_VERSIONS}>'{Put SCENARIO_LIST;0;@Count(SCENARIO_LIST);ANS_KEEPDATA}1'{Scenario-Show @Lower(@Trim(ANS_KEEPDATA))}'{Calc}{Return}'K_UPDATE&'{CLEAN_LIST}{Dialog DLG_UPDDATA}#'; Check for deleted scenarios'{If ANS_UPDDATA<0}{Quit}'{If RES_UPDDATA=0}{Quit}H'{Scenario-Delete @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}H'{Scenario-Create @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}"'{Let RNG_NUM;1}{UP_EXISTING}L'{Scenario-Show @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}{Quit}'CLEAN_LIST'{Blank ANS_SWAPDATA}'CLEAN_LOOP3'{If ANS_SWAPDATA>@Count(UPDATE_LIST)}{Return}'{If 1-@Iserr(@Scenarioinfo("Creator";@Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))))}{Let ANS_SWAPDATA;ANS_SWAPDATA+1}{Branch CLEAN_LOOP}U'{Recalc LIST_RNG}{Edit-Copy +LIST_RNG}{Recalc LIST_ADDR}{Edit-Paste +LIST_ADDR}' '{Branch CLEAN_LOOP}'UP_EXISTING>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}Q'{Version-Delete +RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}Q'{Version-Create +RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}'{Scenario-Add-Version @Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)));;+RNG_NAME;@Lower(@Trim(@Index(UPDATE_LIST;0;ANS_UPDDATA)))}1'{Let RNG_NUM;RNG_NUM+1}{Branch UP_EXISTING} 'K_HELP'{Dialog DLG_KHELP}'{Branch KEEPDATA} 'K_LIMIT'{Alert +"The maximum number of "&@String(@Count(SCENARIO_LIST);0)&" scenarios is in use. You must delete a scenario before creating a new one."} '{Quit}'K_EXISTSw'{Alert +""""&@Lower(@Trim(ANS_KEEPDATA))&""" already exists. Please use another scenario name."}{Branch KEEPDATA}'K_VERSIONS>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}<'{Version-Create +RNG_NAME;@Lower(@Trim(ANS_KEEPDATA))}_'{Scenario-Add-Version @Lower(@Trim(ANS_KEEPDATA));;+RNG_NAME;@Lower(@Trim(ANS_KEEPDATA))}0'{Let RNG_NUM;RNG_NUM+1}{Branch K_VERSIONS} 'RNG_NUM'RNG_NAME 'DATA_02'DLG_KEEPDATA 'DIALOG'KeepDatap(@'""'"" '"Keep Data"  'FONT '"Helv">@ '"edit"'"" (P@'"button" '"OK" (DP@'"button"'"Cancel" ($P@'"button"'"Update..." (hP@'"button" '"Help" @$@'"static"E'"You can create a new scenario or update an existing scenario." 0@'"static"y'"This SmartMaster can keep more than one set of data in this file. Each set of data you keep is called a scenario." l@'"static"*'"Enter a name for the new scenario:" 'END DIALOG'DLG_UPDDATA 'DIALOG 'UpdateplH'""'"" '"Update"  'FONT '"Helv"H`RFB@'"listbox"'""  'UPDATE_LIST0@'"static"['"Select the scenario you want to update with the data currently in this SmartMaster." , P@'"button" '"OK" ,,P@'"button"'"Cancel" 'END DIALOG'DLG_KHELP 'DIALOG 'KHELPp*@d'""'"" '"Keep Data Help"  'FONT '"Helv"(P@'"button" '"OK" T@'"static"'For more information on using Version Manager to create scenarios and share information, search on "Version Manager" in Help. 'END DIALOG'SWAP DATA 'CODE'DESCRIPTION'SWAPDATA''{CLEAN_LIST}{Dialog DLG_SWAPDATA}3'; Switches to a scenario selected by the user'{If ANS_SWAPDATA<0}{Quit}'{If RES_SWAPDATA=0}{Quit}.'{If RES_SWAPDATA=3}{Branch DEL_SCENARIO}='{Let CURR_SCEN;@Scenariolast(@Cellpointer("Filename"))}5'{If @Iserr(CURR_SCEN)}{Let CURR_SCEN;"unnamed"}''{If CURR_SCEN<>"unnamed"}{UPDATE}%'{If CURR_SCEN="unnamed"}{UPDUN}I'{Scenario-Show @Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}C'{If @Scenariolast(@Cellpointer("Filename"))<>"-blank-"}{Quit}<'{Scenario-Delete "unnamed"}{Scenario-Create "unnamed"}F'{Let RNG_NUM;1}{UP_UNNAMED}{Scenario-Show "unnamed"}{Calc}{Quit} 'UPDUN'{Dialog DLG_UPDUN}'{If RES_UPDUN=3}{Quit} '{If RES_UPDUN=1}{KEEPDATA}'{Let RES;1}{Return}'UP_UNNAMED>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}*'{Version-Delete +RNG_NAME;"unnamed"}*'{Version-Create +RNG_NAME;"unnamed"};'{Scenario-Add-Version "unnamed";;+RNG_NAME;"unnamed"}0'{Let RNG_NUM;RNG_NUM+1}{Branch UP_UNNAMED}'LIST_RNG"?CSheet lCol lRow l< ..Sheet lCol lRow l RC:B257..C:B257'LIST_ADDRL\CSheet lCol lRow l<  C:B256 'RES'DEL_SCENARIO'{If ANS_SWAPDATA<1}{Alert "The scenario named ""-Blank-"" cannot be deleted. This scenario is used to clear data from the SmartMaster and create a blank, unnamed scenario."}{Branch SWAPDATA}k'{Alert +"Delete """&@Index(SCENARIO_LIST;0;ANS_SWAPDATA)&""" scenario?";2;"Stop";RES}{If 1-RES}{Quit}K'{Scenario-Delete @Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}!'{Let RNG_NUM;1}{D_VERSIONS}Y'{If ANS_SWAPDATA=@Count(SCENARIO_LIST)-1}{Recalc LIST_ADDR}{Blank +LIST_ADDR}{Quit},'{Recalc LIST_RNG}{Edit-Copy +LIST_RNG}/'{Recalc LIST_ADDR}{Edit-Paste +LIST_ADDR} '{Quit}'D_VERSIONS>'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+'{If 1-@Isrange(@@(RNG_NAME))}{Return}T'{Version-Delete +RNG_NAME;@Lower(@Trim(@Index(SCENARIO_LIST;0;ANS_SWAPDATA)))}0'{Let RNG_NUM;RNG_NUM+1}{Branch D_VERSIONS}'SCENARIO_LIST '-Blank-@d'UPDATE_LISTt ' < Blank Cell. To increase limit, 1) place cell pointer on blank cell, and 2) insert as many rows as you like. "'UPDATE3"'{Let RNG_NUM;1}{Blank NO_UPDATE}{UPDATE_TEST}#'{If NO_UPDATE}{Return}-$'{If @Exact(CURR_SCEN;"sample")}{Return};%'{If @Exact(CURR_SCEN;"unnamed")}{UPDATE_POST}{Return}*&'{Recalc FRM_UPDSC}{Dialog DLG_UPDSC}''{If RES_UPDSC=3}{Quit}#('{If RES_UPDSC=1}{UPDATE_POST})'{Return}+'UPDATE_TEST>+'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}<,'{If 1-@Isrange(@@(RNG_NAME))}{Let NO_UPDATE;1}{Return}8-'{If @Iserr(@Versioncurrent(@@(RNG_NAME)))}{Return}1.'{Let RNG_NUM;RNG_NUM+1}{Branch UPDATE_TEST}0'UPDATE_POST*0'{Version-Update +RNG_NAME;CURR_SCEN}1'UPDATE_LOOP1'{Let RNG_NUM;RNG_NUM+1}>2'{Let RNG_NAME;+"DATA_"&@Right(@String(RNG_NUM+100;0);2)}+3'{If 1-@Isrange(@@(RNG_NAME))}{Return}D4'{If @Iserr(@Versioncurrent(@@(RNG_NAME)))}{Branch UPDATE_POST}5'{Branch UPDATE_LOOP}7'NO_UPDATE9'DLG_SWAPDATA 9'DIALOG9'SwapData:p: :j:H:::'"":'"": '"Swap Data": : 'RES_SWAPDATA ;'FONT; ;'"Helv"<<4<<t<RF<B@<'"listbox"<'""< < 'SCENARIO_LIST< 'ANS_SWAPDATA====$==@='"static"C='"Select the scenario you want to swap into this SmartMaster."= >,> >P>>>@>'"button" >'"OK"> ?,?,?P???@?'"button"?'"Cancel"? @,@T@P@@@@@'"button"@'"Delete"@ A'END DIALOGC'DLG_UPDSC C'DIALOG C'Update1DpDDDbDhDtD'""D'""D '"Update Scenario"D  E'FONTE E'"Helv"FF FFXFF@F'"static"RF /C:The scenario named "o" has changed. Update "o?">FThe scenario named "sample" has changed. Update "sample?"F GGGPGGG@G'"button" G'"Yes"G HH$HPHHH@H'"button" H'"No"H IINIPIII@I'"button"I'"Cancel"I J'END DIALOGL'DLG_UPDUN L'DIALOG L'unnamedMpMMMxMMtM'""M'""M '"Update Scenario"M  N'FONTN N'"Helv"OOOO6OO@O'"static"CO'"The current scenario is unnamed. Assign a name and keep it?"O PPPPPPP@P'"button" P'"Yes"P QQ$QPQQQ@Q'"button" Q'"No"Q RRNRPRRR@R'"button"R'"Cancel"R S'END DIALOGU'SHOW MACROS U'CODEU'DESCRIPTIONV'MACRO_SHOWV'{Show-Sheets MACROS:A1}%V'; Show / Hide this Macros sheet!W'{Edit-Goto MACROS:A1}{Quit}Y'MACRO_HIDE#Y'{Home}{Hide-Sheets MACROS:A1}&Z'{Edit-Goto INFORMATION:A1}{Quit}\'SHOW NOTES FIELDS \'CODE\'DESCRIPTION]'NOTES_SHOW]'{Show-Sheets MACROS:A1}']'; Navigate to the Notes/FX fields^'{Edit-Goto NOTES_FIELDS}&_'{Edit-Goto "NOTES FIELDS"}{Quit}a'PRINT MACROS a'CODEa'DESCRIPTIONb'MACRO_PRINTb'{Dialog DLG_MACPRINT})b'; Print sections of the macro sheetc'{If RES_MACROPRT=0}{Quit}]d'{If ANS_MACROPRT1}{Set "Print-Range";MACROS_RANGE}{Set "Print-Orientation";"Landscape"}\e'{If ANS_MACROPRT2}{Set "Print-Range";NOTES FIELDS}{Set "Print-Orientation";"Portrait"}^f'{If ANS_MACROPRT3}{Set "Print-Range";RN_TABLE_RANGE}{Set "Print-Orientation";"Portrait"})g'{Set "Print-Centered";"Horizontal"}*h'{Set "Print-Footer-Center-Text";"^"}&i'{Set "Print-Size";"Fit-Columns"}#j'{Set "Print-Margin-Top";".5"}Ck'{Set "Print-Margin-Left";".5"}{Set "Print-Margin-Right";".5"}'l'{Set "Print-Margin-Bottom";".25"}m'{Print?} n'{Quit}p'DLG_MACPRINT p'DIALOGp'MacPrintqpq qq|q0qTq'""q'""#q '"Select Information to Print"q  r'FONTr r'"Helv"sssvss(s@s'"button"s'"Macros"s ttttt*t@t'"button"t'"Notes Fields"t uu4uuu,u@u'"button"u'"Range Name Table"u vvvPvvv@v'"button" v'"OK"v ww,wPwww@w'"button"w'"Cancel"w x'END DIALOG'END OF MACROS^DO NOT ERASE 'Jan,? hkU 'Jan 'Feb'@; 'Feb 'Mar'@; 'Mar 'Apr'@; 'Apr  'May'@; 'May  'Jun'@; 'Jun 'Jul'@; 'Jul 'Aug'@; 'Aug 'Sep'@; 'Sep 'Oct'@; 'Oct 'Nov'@; 'Nov 'Dec'@; 'Dec6@Jan`Jan U0;@1@;@1@;@1@;@ 'Months@ 1@;@'Base Year@ @ 1@;@ 'Years@1@;@'Last Year5 @ hkJan ;1@;@'Mos in Last Yr@1@;@1@;@1@;@1@;@1@;@1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;1@;'NOTES FIELDS'Num_User_Scenarios R'Current_Scenario7filenameOz@<<@123>>SCENARIOLAST('Principal_Amount 'Interest_Rate 'Period_in_Years@ 'Base_Year@ @ 'Base_MonthvC Jan'AMORTIZATION'B:A1..B:A1'ANS_INFOPRT'C:L91..C:L91'ANS_KEEPDATA'C:L186..C:L186'ANS_MACROPRT1'C:L372..C:L372'ANS_MACROPRT2'C:L373..C:L373 'ANS_MACROPRT3 'C:L374..C:L374!'ANS_SWAPDATA!'C:L317..C:L317"'ANS_UPDDATA"'C:L199..C:L199#'BACKGRND#'C:B38..C:B38 $'BCK_COL$'C:B46..C:B46%'BCK_LOOP%'C:B41..C:B41&'CLEAN_LIST&'C:B153..C:B153''CLEAN_LOOP''C:B154..C:B154 ('COUNTRY('D:A222..D:A222)'CURR_SCEN)'C:B112..C:B112 *'DATA_01*'B:J5..B:J9+'DEL_SCENARIO+'C:B242..C:B242,'DLG_INFOPRT,'C:B88..C:B88-'DLG_KEEPDATA-'C:B183..C:B183.'DLG_KHELP.'C:B205..C:B205/'DLG_MACPRINT/'C:B369..C:B3690'DLG_PERSONAL0'C:B382..C:B3821'DLG_SAMPLE11'C:B114..C:B1142'DLG_SAMPLE22'C:B123..C:B1233'DLG_SWAPDATA3'C:B314..C:B3144'DLG_UPDDATA4'C:B196..C:B1965'DLG_UPDSC5'C:B324..C:B3246'DLG_UPDUN6'C:B333..C:B3337'D_VERSIONS7'C:B251..C:B2518'FRM_UPDSC8'C:I327..C:I3279'INFORMATION9'D:A1..D:A1:'INFO_ABOUT:'D:A379..D:A379;'INFO_CONVENTION;'D:A276..D:A276<'INFO_CURR_PRT<'C:B67..C:B67='INFO_LIST='C:B78..C:C84>'INFO_NOTESFX>'D:A331..D:A331?'INFO_OVERVIEW?'D:A62..D:A62@'INFO_PRINT@'C:B49..C:B49A'INFO_STEPSA'D:A119..D:A119B'INFO_TIPSB'D:A170..D:A170C'INFO_TOPICC'C:B86..C:B86D'INF_ABOU_RANGED'D:B381..D:H392E'INF_CONVENTIONE'D:B281..D:H292F'INF_COUNTRY_RNGF'D:B228..D:H236G'INF_NOTE_RANGEG'D:B333..D:H343H'INF_OVER_RANGEH'D:B64..D:H79I'INF_STEP_RANGEI'D:B121..D:H131J'INF_TIPS_RANGEJ'D:B172..D:H180K'KEEPDATAK'C:B132..C:B132L'K_EXISTSL'C:B172..C:B172 M'K_HELPM'C:B166..C:B166 N'K_LIMITN'C:B169..C:B169O'K_UPDATEO'C:B145..C:B145P'K_VERSIONSP'C:B174..C:B174Q'LIST_ADDRQ'C:B239..C:B239R'LIST_RNGR'C:B238..C:B238 S'MACROSS'C:A1..C:A1T'MACROS_RANGET'C:A3..C:L399U'MACRO_HIDEU'C:B346..C:B346V'MACRO_PRINTV'C:B355..C:B355W'MACRO_SHOWW'C:B343..C:B343X'NOTES FIELDSX'C:A494..C:B500Y'NOTES_FIELDSY'C:A492..C:A492Z'NOTES_SHOWZ'C:B350..C:B350['NO_UPDATE['C:B312..C:B312\'PERSONALIZE\'C:B380..C:B380]'PREV_SCEN]'C:B111..C:B111 ^'RES^'C:B240..C:B240_'RES_INFOPRT_'C:L89..C:L89`'RES_KEEPDATA`'C:L184..C:L184a'RES_MACROPRTa'C:L370..C:L370b'RES_SAMPLE1b'C:L115..C:L115c'RES_SAMPLE2c'C:L124..C:L124d'RES_SWAPDATAd'C:L315..C:L315e'RES_UPDDATAe'C:L197..C:L197f'RES_UPDSCf'C:L325..C:L325g'RES_UPDUNg'C:L334..C:L334h'RNG_NAMEh'C:B181..C:B181 i'RNG_NUMi'C:B180..C:B180j'RN_TABLEj'C:A539..C:A539k'RN_TABLE_RANGEk'C:A540..C:B640l'SAMPDATAl'C:B98..C:B98m'SAMP_RESTOREm'C:B107..C:B107n'SCENARIO_LISTn'C:B256..C:B289o'SHEET_RANGEo'B:B2..B:J61p'SHT_PRINTp'C:B30..C:B30q'SWAPDATAq'C:B213..C:B213r'TABLE_CONTENTSr'A:A1..A:A1 s'UPDATEs'C:B291..C:B291t'UPDATE_LISTt'C:B257..C:B289u'UPDATE_LOOPu'C:B306..C:B306v'UPDATE_POSTv'C:B305..C:B305w'UPDATE_TESTw'C:B300..C:B300 x'UPDUNx'C:B226..C:B226y'UPPER_LEFTy'C:B76..C:B76z'UP_EXISTINGz'C:B159..C:B159{'UP_UNNAMED{'C:B231..C:B231 |'ZM_ALL|'C:B25..C:B25 }'ZM_NRML}'C:B24..C:B24~'ZM_RESTORE~'C:B27..C:B27 'ZM_SCRN'C:B14..C:B14'ZM_TABLE'C:B16..C:D19'ZOOM_RTN'C:B22..C:B22'ZOOM_TEST'C:B9..C:B9'\0'C:B4..C:B4^Information ^Index(^Click a button to go to a subject. 'Subject'Description'Overview1'General information about this SmartMaster. 'Steps3'Procedures to follow to use this SmartMaster. 'Tips/ 'Helpful hints for using this SmartMaster. 'Country Specific% 'Instructions for use in Canada.'Conventions6'Details on conventions used in this SmartMaster.'Notes/FX Enabling3'Description of Notes/FX and available fields. 'Macros;'Individual macro commands and their descriptions used'in this SmartMaster. 'About:'Information about the developer of this SmartMaster.1@^Overview: Mortgage Amortization SmartMasterpB'This SmartMaster creates a loan amortization schedule. All figures are based on the following five inputs:cC'principal, interest rate, loan period (years), the base year, and the base month of the loan.0E'The amortization schedule is in two parts:3G'  A monthly table for the first 12 monthsAI'  An annual schedule for the remaining life of the loanjK'This template also calculates several key figures, including annual loan payments, monthly payments,kL'interest paid in the first calendar year, interest paid over the term of the loan, and the sum of all)M'payments over the term of the loan.8y^Steps: Using the Mortgage Amortization SmartMasterY{'1. Enter the amount of money you wish to borrow in the loan principal amount field.W}'2. Enter the annual interest rate in decimal places. For example, .085 for 8.5%.O'3. Enter the length of the loan in years. The maximum length is 30 years.?'4. Enter the year and month that the mortgage will begin. ^Tipsk' Run the model several times using different mortgage rates and loan terms to compare the effective' differences.T' Consult your accountant for all of the tax implications of loan deductions.^Country Specificr'If you are using this SmartMaster in Canada, you will need to change the formula in cell E6 located on the ,'Amortization sheet from @PMT to @PMTC.2'The formula in Amortization:E6 should read: ?'@IF(@ISEMPTY(J5),0,@ROUND(@PMTC(J5,J6/12,Macros:F419),2))^Conventions'Cell Typesi'Shaded cells are data entry areas. Outlined cells contain formulas that are automatically computed.'Printing.'All forms print in portrait orientation. !'Dates"'Enter dates as MM/DD/YY.*M^Using this SmartMaster with Notes/FXnO'Notes/FX lets you exchange data between applications by embedding the data as an object in a Notes form.pP'In 1-2-3, the range called "Notes Fields" can be made available to Notes for exchanging data between NotesQ'and the spreadsheet. iS'This SmartMaster contains fields that can be used for Notes/FX applications. To see the range namedpT'"Notes Fields," click on the Notes Fields button. For more information about using Notes/FX, see the NotesU'documentation.}^About this SmartMasterc'This SmartMaster was developed by KMT Software, Inc. KMT Software is the developer of severald'add-on products that are marketed under the Lotus name through Lotus Selects. KMT Software hasb'worked closely with Lotus to develop the Lotus SmartMaster Collection for 1-2-3 Release 5, ae'collection of dozens of additional SmartMaster templates. The Lotus SmartMaster Collection for f'1-2-3 Release 5 includes SmartMaster templates to help you manage your business as well as your %'personal planning and finances.k'To order or learn more about the Lotus SmartMaster Collection for 1-2-3 Release 5, in the U.S. pleaseL'call Lotus Selects at 1-800-635-6887. In Canada, call 1-800-GO-LOTUS.-U_ ArialSWISSSWISSSWISSSWISSSWISSSWISSSWISS      O <4!*@Z||5 _-oZ/j(5 u|xd2@! >{Home}{Edit-Goto B:A1}8 .*5 u|xd2@+ >"{Home}{Edit-Goto INFORMATION:A1} 8  .*5 _CDJxZa15  _JJxZa7  E15 K'0xe/(Restore Zoom{Branch ZM_RESTORE}5  9 K?Ov1IbAx<< (@5 ,Z<f-x6C# Keep Data{Branch KEEPDATA}: j!85 m+Vx^C# Swap Data{Branch SWAPDATA}j 5!85  \6xUC Print{Branch SHT_PRINT} y!]95  BCcv2xIC. Information{Edit-Goto Information:A1} !95  %o=SSPxIC% Sample Data{Branch SAMPDATA} :!85 #]:xd2CZoom{Branch ZOOM_RTN} !b95 3x$R"TipsN{Edit-Goto INFO_TIPS}  9"5  {LwZaEV2?Ovdx<<dw)>'5 !0 Fx@UC"Print{Branch MACRO_PRINT} ",5 "XVxIC' Hide Macros{Branch MACRO_HIDE} "N5 &N 0xUC-Range Name Table{Edit-Goto RN_TABLE} }"o5 '"  xUCGNotes Fields 4{Edit-Goto NOTES_FIELDS}{Edit-Goto "NOTES FIELDS"}} "P5  {LwZaEV25  |_1ZaE\?Ov ?(x<<(V#5 ',m)#xU)Return to Macros{Home} ?!d5 #9KxI)' Information{Branch MACRO_HIDE} !^5 $j#xU)"Print{Branch MACRO_PRINT} !,? Ov ?(x<<(V#5 (',m)#xU)Return to Macros{Home} ?!d5 )9KxI)' Information{Branch MACRO_HIDE} !^5 *j#xU)"Print{Branch MACRO_PRINT} !,4   ?O 4  x4  4  8r8r4  8$84  8LW84  8|8? _>5 _޸|wZa& A/5 u|xd2@$ >{Edit-Goto INFO_OVERVIEW}8 .*5 _8f֋ xZaE=>$5?Ov?Idx<<==(@5 (`X"xUCPrint{INFO_PRINT 1}=X =[ C$5 n'xIC:Return to Amortization{Edit-Goto Amortization:A1}= = $5 E:xd2C Information Index{Home}= =` $5 _8f֋ wZaEvw$5?OvʞIFx<<vv(@5  (X!xUCPrint{INFO_PRINT 2}vv!C#5 ; }kx@d2C Information Index{Home}vev!h5 _8f֋ wZaE$55 _8f֋ wZaEJK$5?Ov=Ix<<JJ(@5 (SXe%xUCPrint{INFO_PRINT 6}JP JT!C'5 ; x@d2C Information Index{Home}J JX!h5 $mMc%xUC.Notes Fields{Home}{Branch NOTES_SHOW}J J!y'5 _8f֋ wZaEz{$5?Ov?IVx<<zz%@5 ix@UCPrint{INFO_PRINT 7}zz915  3zx@d2C Information Index{Home}zzx5 %3x&)1Go to Amortization{Home}{Edit-Goto B:A1} m5 u|xd2@! >{Edit-Goto INFO_STEPS}8 .*5  u|xd2@  >{Edit-Goto INFO_TIPS} 8  .*5 u|xd2@# >{Edit-Goto INFO_NOTESFX}8 .*5 u|xd2@$ >{Home}{Branch MACRO_SHOW}8 .*5 u|xd2@! >{Edit-Goto INFO_ABOUT}8 .*5 nc*xIC:Return to Amortization{Edit-Goto Amortization:A1}vvr!#?Ov ?x3<<(:#5 x}G7x3UCPrint{INFO_PRINT 3} !*5 xx@d2C Information Index{Home}L !g5 6sx3IC:Return to Amortization{Edit-Goto Amortization:A1} L!5 ){"xIC:Return to Amortization{Edit-Goto Amortization:A1}J J!'5 \&!xIC:Return to Amortization{Edit-Goto Amortization:A1}z\z&? Ovgx@<<<5 +viaXx%UCPrint{INFO_PRINT 4}q X'5 ,PhcHx@d2C Information Index{Home}3 qd5 - Hx@IC:Return to Amortization{Edit-Goto Amortization:A1} 35 .x3d2@ >{Edit-Goto COUNTRY} >  305 /x3d2@& >{Edit-Goto INFO_CONVENTION}> 30? Ov}dx@<< ;'5 0|dx@UCPrint{INFO_PRINT 5}&&)5 1Tzax@d2C Information Index{Home}2c5 2(-AQx@IC:Return to Amortization{Edit-Goto Amortization:A1}? _ U\Use this SmartMaster to calculate monthly payments and a first-year schedule for a mortgage.Amortize a Loan Scott TuckerALIASDefaultALIAS Erin LimanLotus NotesELIMANLAN Manager Paul MoodyLotus NotesErin LimanALIAS"Scott TuckerLotus NotesJeff KahnLotus Notes! SmartMasterLotus Notes) Karen Vona McIntyreLotus Notes/l׍u@C:\SM4\BALSHEET.WK4m ar@D:\DARWIN\WORK\KMT2\BALSHEET.WK4@43F2?j/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: UUUUU@D:\DARWIN\WORK\/B:\NEW_BAL.WK4J DOfq@B:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: Ε$s@D:\DARWIN\WORK\/B:\NEW_BAL.WK4J !-Cs@B:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: SY܏+@D:\DARWIN\WORK\/A:\NEW_BAL.WK4J I+@A:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL.WK4: F+@D:\DARWIN\WORK\/A:\NEW_BAL.WK4K ףp= +@A:\NEW_BAL.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL2.WK4< :b߱ي/@D:\DARWIN\WORK\K/A:\NEW_BAL2.WK4L 5F/@A:\NEW_BAL2.WK4/D:\DARWIN\WORK\KMT2\NEW_BAL2.WK4<  \/@D:\DARWIN\WORK\K/A:\NEW_BAL2.WK4< G;6v0@C:\123R4W\PROGRA/A:\BALSHEET.WK4? Qߦz0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< - {0@I:\KMT\BALSHEET./A:\BALSHEET.WK4? 7&{0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< 8e|{0@I:\KMT\BALSHEET./A:\BALSHEET.WK4? y@Ε0@A:\BALSHEET.WK4/I:\KMT\BALSHEET.WK4< xV40@I:\KMT\BALSHEET./A:\BALSHEET.WK4E =e1@A:\BALSHEET.WK4/D:\DARWIN\WORK\NEW_SM.WK4T T`w1@D:\DARWIN\WORK\NEW_SM.WK4/D:\DARWIN\WORK\KMT2\NEW_SM.WK4@ A01@D:\DARWIN\WORK\KMT/I:\KMT\NEW_SM.WK4? SA@A:\PAUL.WK4/D:\DARWIN\WORK\PAUL.WK44 A@D:\DARWIN\WO/B:\PAUL.WK4? RA@B:\PAUL.WK4/D:\DARWIN\WORK\PAUL.WK44 l(B@D:\DARWIN\WO/A:\PAUL.WK4? ]B@A:\PAUL.WK4/C:\123R4W\WORK\PAUL.WK4Y """""B@D:\CSERVE\DOWNLOAD\PAUL.WK4/D:\FORMS\SSPC\SHEETS\AUTOZOOM.WK4O ŝ ND@D:\FORMS\SSPC\SHEETS\A)/D:\FORMS\SM_MAS02.WK4G 贁N D@D:\FORMS\SM_MAS02.WK4/D:\FORMS\SM_MAS03.WK4E y58O@C:\DATA\SM_MAS03.WK4/C:\DATA\SM_MAS04.WK4G yKs¦R@D:\FORMS\SM_MAS04.WK4/D:\FORMS\SM_MAS05.WK4G djR@D:\FORMS\SM_MAS05.WK4/D:\FORMS\SM_MAS06.WK4G bR@D:\FORMS\SM_MAS06.WK4/D:\FORMS\SM_MAS07.WK4G n;S@D:\FORMS\SM_MAS07.WK4/D:\FORMS\SM_MAS08.WK4S oi^S@D:\FORMS\SM_MAS08.WK4/D:\FORMS\SSPC\SHEETS\SM_MAS09.WK4_ ħS@D:\FORMS\SSPC\SHEETS\SM_MAS09.WK4/D:\FORMS\SSPC\SHEETS\SM_MAS10.WK4W tľX@D:\FORMS\SM_MASTR\INVOICE.WK4/D:\FORMS\SM_MASTR\INVOIC2.WK4W lUJd@D:\FORMS\SM_MASTR\INVOICE.WK4/D:\FORMS\SM_MASTR\INVOIC3.WK4U Sd@C:\DATA\SM_MASTR\INVOIC3.WK4/C:\DATA\SM_MASTR\INVOIC4.WK4U ~9xf@C:\DATA\SM_MASTR\INVOIC4.WK4/C:\DATA\SM_MASTR\INVOIC5.WK4V  f@C:\DATA\SM_MASTR\INVOIC6.WK7/C:\DATA\SM_MASTR\SHELL.WK4T 8e|f@C:\DATA\SM_MASTR\SHELL.WK4/C:\DATA\SM_MASTR\MORTAMOR.WK4Q Gzd@E:\GOLDSM\MORTAMOR.WT4/E:\123R4W\MASTERS\MORTAMOR.WT4Z < Y猑@E:\GOLDSM\WO_SELEC\MORTAMOR.WT4/E:\123R4W\MASTERS\MORTAMOR.WT4a p= o@M:\GOLD_FIL\SMASTER\OLD\MORTAMOR._/M:\GOLD_FIL\SMASTER\MORTAMOR.WT4 DATA_01 sampleDATA_01%sampleDATA_01Sample Data3ejf@sampleDATA_01sample      <    "May  testDATA_01/ t@testDATA_01test         7>  "Jan -blank-DATA_01%-blank-DATA_01Blank Data52>f@-blank-DATA_01-blank-         7>  "Jan unnamedDATA_015et@unnamedDATA_01unnamed. xlUJu@unnamedDATA_01    >  (   7>  "Jansample4sampleOriginal SmartMaster sample data set)ejf@samplesample# ejf@sample9samplesampleScott TuckerLotus NotesDATA_01-blank-4-blank-Original SmartMaster blank data set+|f@-blank--blank-$ 2>f@-blank-;-blank--blank-Scott TuckerLotus NotesDATA_01unnamed+et@unnamedunnamed$ et@unnamed;unnamedunnamedScott TuckerLotus NotesDATA_01CR3CR3 PropertyDoc Info CommentsDoc Info Creation DateDoc Info Editing TimeDoc Info Last Revision DateDoc Info ObjectDoc Info PropertyDoc Info TitleFM3FM3 PropertyWK3WK3 Property  L Z Z$   <`    p`    D .! CMHdrL