Suppose you have two potential investments with the following cash flows: Open MS Excel or Google Sheets. Put a heading in cell A2: "(1) Year." In B2, put the heading " (1) Cash Flow." The "1" is ...

With those values, you can use a spreadsheet program like Microsoft Excel to calculate the ... Starting with cell D4, the formula is the current day's closing value divided by the previous day's ...