1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide to Excel for Finance: Annuities
  5. Guide To Excel For Finance: Valuation Methods
  6. Guide To Excel For Finance: Goal Seek
  7. Guide To Excel For Finance: HLookup And VLookup
  8. Guide To Excel For Finance: Ratios
  9. Guide To Excel For Finance: Technical Indicators
  10. Guide To Excel For Finance: Advanced Calculations
  11. Guide To Excel For Finance: Conclusion

When it comes to saving or spending, a number of concepts include a cash flow each year, or period in question.  An annuity formula best summarizes how to address these matters in Excel.  (Related: What Is An Annuity? - Video )

Here is both a present and future value formula for an annuity:

PV = C((1 - 1 / (1 + r)t / r)

In the below example, an individual is able to save $10,000 per year for 10 years in the stock market and earn an estimate 10% per year.  The present value of that savings program is $61,445.

The future value of that savings program is $159,374.  At the end of that 10 year program, the savings will have grown to nearly $160,000.


Guide To Excel For Finance: Valuation Methods
Related Articles
  1. Retirement

    How to Calculate the Value of Annuities

    Here's everything you need to account for when calculating the present and future value of annuities.
  2. Investing

    DIY Annuities: What You Need to Know

    Annuities are attractive because they can give you a stream of income, but they can be tricky to buy.
  3. Retirement

    How a Fixed Annuity Works After Retirement

    These popular investments can provide a steady stream of income during your retirement years. Here are the details.
  4. Retirement

    Annuities: How To Find The Right One For You

    Fixed, variable and indexed annuities offer different features. Find out which one fits your needs.
  5. Investing

    The Many Benefits of Deferred Annuities

    Having a deferred annuity can ensure income in retirement above and beyond Social Security.
  6. Retirement

    Guaranteed Retirement Income in Any Market

    By laddering annuities, you can be sure you'll have income no matter what the market does.
  7. Investing

    Why an Annuity May Not Be Right for You

    An annuity, when compared to the many other options available, may not be the best choice.
  8. Financial Advisor

    Are Annuities Right for You?

    Annuities are safe and often appealing, but IRAs and 401(k)s offer advantages that annuities typically can’t match, with little additional risk.
  9. Investing

    An Overview of Annuities

    Annuities provide a guaranteed income stream. Learn how they work and their benefits.
Frequently Asked Questions
  1. What is the history behind the opening and closing bells on the NYSE?

    Similar to school bells, the New York Stock Exchange's (NYSE) opening and closing bells mark the beginning and the end of ...
  2. When do economists use real GDP instead of GDP?

    Learn about the purposes for which economists rely on real GDP. Find out how real GDP is calculated and how it is important ...
  3. What are some examples of cash flow from operating activities?

    Learn about the cash flow statement and cash flows from operating activities. See some examples of cash flows from operating ...
  4. Can stocks be traded on more than one exchange?

    A stock can trade on any exchange on which it is listed. If it chooses to do so, a company can list its shares on more than ...
Trading Center