Excel Chapter 9

4. calculates the present value of a loan or an investment
5. positive value that represents money coming to the investor
7. track errors to their source by pointing from the precedent cell to the dependent cell
9. changes values by a constant amount
11. indicate an error in the value being received from the precedent cell or passed to the dependent cell
14. also called a profit an loss statement that displays how much money a person or business makes or loses over a specified period of time
15. calculated the internal rate of return for an investment
17. the return rate for a series of future cash flows that will result in a net present value of 0.
18. calculates the present value of a series of future cash flows
21. the difference between the present value of an investment and the initial expenditure on that investment
23. calculates the payment in each period required to repay a loan or reach an investment goal
25. depend on the value in the active cell for their result
26. also known as cost of goods sold
28. used to fill in a series when you know the starting and ending values of that series
29. negative value that represents cash going away from the investor
30. calculates the number of payments required to repay a loan or reach an investment goal

1. calculates the amount of a loan payment that is applied to the principal
2. calculates the future value of a loan or an investment
3. process of allocating the original cost of an asset over the lifetime of the asset
6. fixed expenses not directly related to production
8. provides the schedule of payments used to repay a loan
10. 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
12. calculates the amount of a loan payment that is used to repay the interest
13. calculates the declining balance depreciation in which asset depreciates by a constant percentage each time
16. includes commands to fix formula errors and trace formulas to their roots
19. supply data values to the active cell
20. used to extend a series from a single value or a few values to project future values
22. length of time before an investment recovers its initial cost, which occurs when the values changes from negative to positive
24. changes values by a constant percentage
27. calculates the per-period interest rate required to repay a loan or reach an investment goal