February 2013
Intermediate to advanced
528 pages
13h 53m
English
Content preview from Excel® 2013 Formulas and Functions
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
19. Building Investment Formulas
In This Chapter
The time value of money concepts introduced in Chapter 18, “Building Loan Formulas,” apply 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) in return (positive cash flow).
With this sign change in mind, this chapter takes you through some Excel tools for building ...