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)*100B"qG`p((1+A4/100/4)^4-1)*100)-1)*100B"TbxbP((1+A4/100/12)^12-1)*100)-1)*10091B"tTHIx ((1+A4/100/365)^365-1)*100B"u%Ic(EXP(A4/100)-1)*1000^365)-1)*100B!U%1E4!"<< Real i% ="<< Real i% = "i%/Period((1B%((1+A5/100)^(1/2)-1)*100)(((1APqW((1+A5/100)^(1/4)-1)*100-1)(((1A9cVqd((1+A5/100)^(1/12)-1)*100-1)(((1?SH)p(((1+A5/100)^(1/365)-1)*1001))(EXPN/ANAA9cVqdG5G5/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..?9cVqd(A6-A8)/(100+A8))^(1/4))-1)100*!" = Effective Interest 'y'6)^ " [F/P] =10ABQxD5EEXP(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- BIVBD9/ $"<< 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 A9cVqdE8*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 BYuFSW0(A10-1)/(A10*E8)8))/(C7/100)00)) ? iu@d91/A107/100)^B8B3 FA!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 DY9A13*D14+A14*E14+A15*F14 @9G14-INT(G14)G11))1)))2/100)^B11) !" AV1/12 == CI%2SItG14/12 "= 1/12 AV E8  "<< Future)^(BIVBA107/100)^B8B3D)ar%y(A10-1)/E8^(B8)-1)/(C7/100)100))*(1+C2/100)^B3`A1GUyfWYA13*D15+A14*E15+A15*F15@h5uG15-INT(G15)G12))3 " FV '- Periods= "---i%=B7*B  1!" CHECK on PV AV FV100*EU tYCA14*E13+A15*F13A12*F10R*C14CqA(A13*D14+A15*F14A12*F11R*D14HD11*GUyfWYA13*D15+A14*E15A12*F12R*E14561"" excludes P in PV, A in AV, and F in FV!" PAYBACK ofEUA11EVA13epayment as belo!" with interest @UTUREA9cVqd100*E8^ ^ ^ ^ ^!"% repay @s ofC 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 andC3uH(LOG10(H18/(H18-C18*E8)))/LOG10(1+E8)$" periods if Discrete (End-of-Period)G10(1+E6)(C7/100)0))-A"Y`9i E19@BH48""<< n payments as above gives $=aboveEUrUhQRRgA10^(A20/A7)*((C18-H18/E8))+H18/E8#" Balance Outstandingat End of PeriodE6