Calculating Investments
The functions we discuss in this section are used when working with cash flows. All of the functions for calculating investments are available on the Formulas tab, in the Function Library group’s Financial drop-down list.
Table 16-1 lists the arguments used in functions dedicated to calculating investments.
Table 16-1. Investment Function Arguments
|
Argument |
Description |
|---|---|
|
Future value |
The value of an investment at the end of the term (0 if omitted). |
|
value1, value2, …value n |
Periodic payments (inflows) when individual amounts differ. |
|
Number of periods |
Term of investment. |
|
Payment |
Periodic payments when individual ... |
Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
