77 78 79 f. A security has a cost of $1,000 and will return $2,000 after 5 years. What rate of return does the security 80 provide? 31 32 Inputs 33 34 35 26 Outputs 7 Use Excel RATE Function: 8 9 0 1 2 PV = FV = N = PMT = Note: Use zero for Pmt since there are no periodic payments. Note that the PV is given a negative sign because it is an outflow (cost to buy the security). $

f. A security has a cost of $1,000 and will return $2,000 after 5 years. What rate of return does the security provide? \begin{tabular}{|l|l|l|} \hline Inputs & PV = \\ & FV = \\ & \begin{tabular}{l} N = \\ PMT = \end{tabular} \\ Outputs & \\ Use Excel RATE Function: & \end{tabular} Note: Use zero for Pmt since there are no periodic payments. Note that the PV is given a negative sign because it is an outflow (cost to buy the security)