Ask Experts Questions for FREE Help !
Ask
    Janelle101's Avatar
    Janelle101 Posts: 60, Reputation: 1
    Junior Member
     
    #1

    Apr 11, 2010, 06:17 AM
    Annuity
    Please help me with the formula for this question.


    Your father is about to retire, and he wants to buy an annuity that will provide him with $50,000 of income a year for 20 years, with the first payment coming immediately. The going rate on such annuities is 6%. How much would it cost him to buy the annuity today?

    In excel: n = 20; I = 6; PMT = 50,000; FV = 0; = 607,905.82
    ArcSine's Avatar
    ArcSine Posts: 969, Reputation: 106
    Senior Member
     
    #2

    Apr 11, 2010, 02:45 PM
    You got it... nice job!
    Janelle101's Avatar
    Janelle101 Posts: 60, Reputation: 1
    Junior Member
     
    #3

    Apr 13, 2010, 05:10 AM

    Sorry what I wanted to know was how to calculate it manually.
    ArcSine's Avatar
    ArcSine Posts: 969, Reputation: 106
    Senior Member
     
    #4

    Apr 13, 2010, 06:32 AM
    By "manually" I assume you mean with nothing more than the 3 Ps: pencil, paper, and pocket calculator.

    Couple or three different ways you could hit it; at the end of the day they're mathematically equivalent. Here's one approach...

    Pricing this annuity as described can be viewed as pricing two separate components: The first 50K which rolls in immediately, and then the other 19 payments taken together as a package which forms an 'ordinary' annuity (i.e. payments rolling in at the end of each year).

    The present value of the immediately-received 50K is, well, 50K.

    For the 19-payment ordinary annuity package you can use the familiar "PV-of-an-ordinary-annuity" shortcut formula...



    For the thrilling finale you just put 'em together... the PV of your annuity is given by



    Equivalently, you could price the whole 20-payment package as an ordinary annuity...

    which would give you the value of the entire cash flow stream as of one year ago. Then multiply by 1.06 to arrive at today's value.

    There is a shortcut formula for pricing 'beginning-of-year' type annuities, but the second method I just gave above is how that shortcut formula is derived.
    Janelle101's Avatar
    Janelle101 Posts: 60, Reputation: 1
    Junior Member
     
    #5

    Apr 13, 2010, 08:37 AM

    Thank you so much.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Future Value: Annuity versus annuity due [ 2 Answers ]

What's the future value of a 7 percent, 5 year ordinary annuity that pays $300 each year? If this were annuity due, what would its future value Be?

Future Value: annuity versus annuity due [ 2 Answers ]

What's the future value of a 7 percent, 5 year ordinary annuity that pays $300.00 each year? If this were an annuity due, what would its future value be? I am using a financial calculator and is having problems arriving at the correct answer. I tried the examples in the book; however my answer...

Annuity rollover to another annuity or bank cd/ira? [ 1 Answers ]

I have an annuity with pacific life, it is a 7 year contract and will mature December 31 2009, it is in a fixed account making only 3% at this time the value is $86,600.00 and if I take it out now it will be $83,600.00. I am 62 and will not start taking rmd's until 2016 when I will be 70 1/2... my...


View more questions Search