WPC 2 B(P Z #|ptpiRoman 12ptRoman 18ptRoman 12pt Italic*XPWorkbook PrinterWORKBOOK.PRS:\  P*0FZSXP2<T"^0,dddvddx 5 #:\  P*JXP#Vl...Vn = a series of cash flows in range; int = interest rate; i= the  5 currnt iteration (l through n)7$(#(#(#(#!A'#$  7  #:\  P*JXP#Each item in the list is the income required at the end of a period. The incomes must be listed in the order of the periods. <!0*0*!'#!'#,!A< STDEV (List of Numbers) Returns the standard deviation of a sample from the list of numbers. The following formula is used to calculate the standard deviation of a sample: #32P0P# dddd,ddd (1) Adddd,ddd (1)  da#x= 0,ddd ddxܥ 5 #:\  P*JXP#Nothing is returned if you include no numbers or only one number in  5 the list of numbers.BVs~ =~ SQRT {~{SMALLSUM~ {x sup 2} ~!~~ {{( SMALLSUM ~x``) sup 2} over n}} over n}32P0P32P0P32P0P,,,s,,x,, ax,,n,,;n,,,=K32,,va(,, a), 2,,,T,,pS,,S,,S,,&S,,S,,JS,,R8 ,]y,,v,] ,,a,, !Bd$(#(#(#(#4!a'#$  7 #:\  P*JXP# TERM (Rate,Present Value,Payment,Future Value,Type) Returns the term (number of periods) for a loan, investment, etc., using the following formulas: If i <> 0, #W\  PP# dddd,ddd (1) adddd,ddd (1)  y#x>Kd,dddvddx*y$(#(#(#(#!'#$  7l #:\  P*JXP#If i = 0, #32P0P# dddd,ddd (1) dddd,ddd (1)  #x0,ddd ddxܶ 5 #:\  P*JXP#i = interest rate; t = type; FV = future value; PMT = payment; PV  5 = present value; ln = natural logarithm{"~~(``FV``+PV~)} over PMT %yo ,,,N",,P(,,*FV,,6+,,PV,,),,;PMT$(#(#>(#(#!'#$