• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 18. Building Investment Formulas > The Future Value of a Lump Sum Plus ...

The Future Value of a Lump Sum Plus Deposits

For best investment results, you should invest an initial amount and then add to it with regular deposits. In this scenario, you need to specify all the FV() function arguments (except type). For example, Figure 18.4 shows the future value of an investment with a $10,000 initial deposit and 100 monthly deposits at 5% over 10 years.

Figure 18.4. This worksheet uses the full FV() function syntax to calculate the future value of a lump sum plus a series of deposits.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint