SuperCalc Ver. 1.05 MOI.CAL Math Of Investment - by W.D. Stainton P.Eng. (416) 489-8590 1/84L· h 5 %" MOI.CAL Math Of Investment - by W.D. Stainton P.Eng. (416) 489-8590 1/84#" << DATA INPUT TO THE LEFT OF THESE MARKS ONLY"" Effective Interest if Cp'df Cp'd57734-!"Semi-I10*100)^(1/12))-1$"Qtr'lyer values opposite these markers - Force Recalculation (!)when done. "Monthly " Dailyte "InfiniteAB P20.5 "<< Nom. i%2 "Real i% =¢B!U%1•�((1+A4/100/2)^2-1)*100)-1)*100¢B"q“G`p((1+A4/100/4)^4-1)*100)-1)*100¢B"TbxˆbP((1+A4/100/12)^12-1)*100)-1)*10091¢B"tTHIx ((1+A4/100/365)^365-1)*100¢B"u%Ic€(EXP(A4/100)-1)*1000^365)-1)*100€B!U%1•�E4!"<< Real i% ="<< Real i% = "i%/Period((1¢B%((1+A5/100)^(1/2)-1)*100)(((1¢APqW((1+A5/100)^(1/4)-1)*100-1)(((1¢A9cV�qd((1+A5/100)^(1/12)-1)*100-1)(((1¢?SH)p(((1+A5/100)^(1/365)-1)*1001))(EXP N/ANA�A9cV�qdG5G5/100)^12$"<< Real i%/Period (from line above to agree with entry below)"^ ^ ^ ^ ^AC$24040""<< Periods (to agree with i%/Period above)@0!"<< Inflation % --->. Int..¢?9cV�qd(A6-A8)/(100+A8))^(1/4))-1)100*!" = Effective Interest 'y'6)^ " [F/P] =10A¢BQ…xD5EEXP(E8*A7))-(1+E6)^A5ERROR100*¢BIVB‡(1+E8)^A7))-(1+E6)^A5ERROR in [F/¢AY“%€(EXP(E8*A7))-(1+E8)^A7ERRORve#" Diff. in [F/P] Continuous to Discrete Compounding(B6- €BIVB‡D9/ $"<< Comp'd: C9 for Continuous or D9 for Discrete (End-of-Period) Compounding %" TABLE OF FACTORS at $1.00 @ y% for. Int.)ds where "x" is P, A, or FAmount ¡A9cV�qdE8*100ive Interest "% over00ri  C$A7A %" Periods for $1 where "x" is P, A, or F Periods where "x" is P, A, or F !" SUMS:Enter BelowE LEFT OF "[x/P]Tr A5  "[x/A] "[x/F] "TOTAL OF $1. " VALUEr A5 P AEV5600074^ ^ ^ ^ "<< Present^( `A1 ¢BYu…�FSW0(A10-1)/(A10*E8)8))/(C7/100)00)) ¡? iu@d91/A107/100)^B8B3 ¢F—A!”A13*D13+A14*E13+A15*F13 ¢�@A!”G13-INT(G13)G10))010^^^^ " PV AC’ 92259028383419fe !"<< Annual(Periodic)20 £?s9˜(�”DA10*E8/(A10-1)C7/100)^(-B8))/100)) `A1 £=3vAG0EE8/(A10-1)7C7/100)^B8-1)(C2/100))*(1+C2/100)^B3 ¢DY9’‰A13*D14+A14*E14+A15*F14 ¢�@9’‰G14-INT(G14)G11))1)))2/100)^B11) !" AV1/12 == ¡CI%2SItG14/12 "= 1/12 AV E8  "<< Future)^(¡BIVB‡A107/100)^B8B3£D)ar€%y(A10-1)/E8^(B8)-1)/(C7/100)100))*(1+C2/100)^B3`A1¢GUyfƒWYA13*D15+A14*E15+A15*F15¡�@–h5u�G15-INT(G15)G12))3 " FV '- Periods= "---i%=B7*B  1!" CHECK on PV AV FV100*¢EU tYCA14*E13+A15*F13A12*F10R*C14¢C“q�A‰(†A13*D14+A15*F14A12*F11R*D14HD11*¢GUyfƒWYA13*D15+A14*E15A12*F12R*E14561"" excludes P in PV, A in AV, and F in FV!" PAYBACK ofEUA11¡EVA13epayment as belo!" with interest @UTURE¡A9cV�qd100*E8^ ^ ^ ^ ^!"% repay @s of¡C’ A14"Paybk N @!" per period (from entries))!" Gives Payback at N =¤C3H`v2A(LN(H18/(H18-C18*E8)))/E86100)))))/LN(1+(C7/100))!" if Continuous Cpding and¤C3u—™‚H”(LOG10(H18/(H18-C18*E8)))/LOG10(1+E8)$" periods if Discrete (End-of-Period)G10(1+E6)(C7/100)0))-ƒA"Y`9˜iƒ E19@BH48""<< n payments as above gives $=above£EUrUhQRRgA10^(A20/A7)*((C18-H18/E8))+H18/E8#" Balance Outstandingat End of PeriodE6