Across
- 5. also known as discount rate, it is an interest rate that compares the value of current dollars to future dollars from a series of cash flows
- 6. the difference between the present value of an investment and the initial expenditure on that investment
- 7. calculates the present value of a series of future cash flows
- 8. indicate an error in the value being received from the precedent cell or passed to the dependent cell
- 11. depend on the value in the active cell for their result
- 12. includes commands to fix formula errors and trace formulas to their roots
Down
- 1. supply data values to the active cell
- 2. length of time before an investment recovers its initial cost, which occurs when the values changes from negative to positive
- 3. calculated the internal rate of return for an investment
- 4. the return rate for a series of future cash flows that will result in a net present value of 0.
- 9. track errors to their source by pointing from the precedent cell to the dependent cell
- 10. calculates the per-period interest rate required to repay a loan or reach an investment goal