Chapter 15
Working with investment formulas
In this chapter, you will:
Understand concepts such as compound, nominal, and effective interest rates
Calculate the future value of an investment
Learn formulas that enable you to work toward an investment goal
The time value of money concepts introduced in Chapter 14, “Building loan formulas,” applies equally well to investments. The only difference is that you need to reverse the signs of the cash values. That’s because loans generally involve receiving a principal amount (positive cash flow) and paying it back over time (negative cash flow). An investment, on the other hand, involves depositing money into the investment (negative cash flow) and then receiving interest payments (or whatever) ...
Get Microsoft Excel 2019 Formulas and Functions, First Edition 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.
