<#-- Rebranding: Header Logo--> <#-- Rebranding: Footer Logo-->
  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

    Present and Future Value of Annuities

    Do you want to invest in annuities that get you a series of payments over a period of time. Here's everything you need to account for when calculating the present and future value of annuities.
  2. Investing

    The Basic Types of Annuities and How They Work

    Understanding the three main types of annuities can help you decide which, if any, is a good match to help you meet your financial goals.
  3. 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.
  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. Retirement

    Who Benefits From Retirement Annuities

    Annuities guarantee some degree of fixed income in retirement. But is the security worth the fees and less favorable tax treatment? How to decide.
  6. Financial Advisor

    Annuities: A Good Option in Turbulent Times?

    Annuities can be an enticing option as Americans near retirement, but there are several reasons to be wary of them.
  7. Investing

    Should You Buy an Annuity?

    There are both pros and cons of buying an annuity, so do your due diligence before investing in one.
  8. 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.
  9. 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.
  10. Investing

    What Do You Need to Know About Annuities?

    There are varying views on annuities. Use this basic information to draw your own conclusions.
Trading Center