The Money Mustache Community

Learning, Sharing, and Teaching => Ask a Mustachian => Topic started by: Daisyedwards800 on March 02, 2016, 02:45:05 PM

Title: Net Present Value questions - I know there are some finance geeks here
Post by: Daisyedwards800 on March 02, 2016, 02:45:05 PM
How do you find the net present value at 03/15/2016 of a stream of 37 annual payments at an annual discount rate of 3.5%, when the first payment starts on 12/31/2016?

Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Proud Foot on March 02, 2016, 03:07:47 PM
In order to give the correct answer there are a few things that you did not outline here.  What is the amount of the annual payment and what is the value at the end of the payments?

The Net Present Value (NPV) of the annual payments(P) at 12/31/2016 would be calculated by this formula: P*((1-(1.035^-36))/ 0.035)

You would then calculate the NPV of the previous answer (V) at 3/15/2016 using this formula: V*(1.035^-(291/365))

Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Vanguards and Lentils on March 02, 2016, 03:08:20 PM
So I don't know if this is actually the finance-y to do this, but here goes... We can first find the net present value at 12/31/2016, and then make a correction afterwards. Call the annual payment N.

the first payment on 12/31/2016 is worth N in 12/31/2016 dollars
the second is worth .965*N in 12/31/2016 dollars
...
the 37th is worth .965^36*N in 12/31/2016 dollars

so the total is worth N(1+.965+.965^2+...+.965^36) = (using a geometric sum (https://en.wikipedia.org/wiki/Geometric_progression)) N(1-.965^37)/(1-.965) or roughly 20.93N.

To find the 3/15/2016 present value, you might first compute a "daily" discount rate which is equivalent to the annual discount rate, assuming daily compounding.

(1+daily_rate)^365=1.035, so the daily_rate is roughly .00943%, the amount lost due to inflation each day.

Then the 3/15/2016 present value of 20.93N in 12/31/2016 dollars (which is 291 days later) would be found from

MarchPV(1.0000943^291)=20.93N
MarchPV = 20.36N
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Vanguards and Lentils on March 02, 2016, 03:09:29 PM
I was a minute late but yes, exactly what he said.
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Daisyedwards800 on March 02, 2016, 03:16:52 PM
$5,000,000 for each annual payment
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Daisyedwards800 on March 02, 2016, 03:18:27 PM
and yearly compounding.... actually not sure about this part.
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Daisyedwards800 on March 02, 2016, 03:21:38 PM
In order to give the correct answer there are a few things that you did not outline here.  What is the amount of the annual payment and what is the value at the end of the payments?

The Net Present Value (NPV) of the annual payments(P) at 12/31/2016 would be calculated by this formula: P*((1-(1.035^-36))/ 0.35)

You would then calculate the NPV of the previous answer (V) at 3/15/2016 using this formula: V*(1.035^(291/365))

Curious where you get .35 from ?
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Proud Foot on March 02, 2016, 03:35:28 PM
In order to give the correct answer there are a few things that you did not outline here.  What is the amount of the annual payment and what is the value at the end of the payments?

The Net Present Value (NPV) of the annual payments(P) at 12/31/2016 would be calculated by this formula: P*((1-(1.035^-36))/ 0.035)

You would then calculate the NPV of the previous answer (V) at 3/15/2016 using this formula: V*(1.035^(291/365))

Curious where you get .35 from ?

Sorry that was a typo.  I missed the extra 0 to make it 0.035.  I corrected it above and will correct my original post.
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Daisyedwards800 on March 02, 2016, 03:38:13 PM
Where do you get 36 and .035 from?
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Proud Foot on March 02, 2016, 03:47:01 PM
Where do you get 36 and .035 from?

Good question.  I got the 36 as you are calculating the Present Value as of the first payment date.  Because of this the first payment is not discounted is not counted in the number of payments.  I did leave out the part of what to do with that first payment. 

Here is the updated formula with the payment information you gave below as well as correcting my mistake above.

PV@12/31/16 = 5,000,000+(5,000,000*((1-(1.035^-36))/0.035)
or PV@12/13/16 = 106,452,469

PV@3/15/16 = 106,452,469 * (1.035^-(291/365))
or PV@3/15/16 = 103,572,483

eta: I updated my original post to correctly note that the formula should have a negative exponent where I missed the - when typing it in.
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Daisyedwards800 on March 02, 2016, 03:52:11 PM
Where do you get .035?
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Vanguards and Lentils on March 02, 2016, 03:59:40 PM
That's how percentages work... percent comes from "percentum" which means "by 100". So 3.5% = 3.5/100 = .035, and N% is N/100
Title: Re: Net Present Value questions - I know there are some finance geeks here
Post by: Proud Foot on March 02, 2016, 04:04:19 PM
It is the 3.5% discount rate.


I didn't really explain where the numbers came from in my first post so here are the formulas without numbers
 P*(1-(1+r)^-(n-1))/r)+P 
 and V*(1+r)^-n2

Where P = Annual Payment
r = Discount rate
n = number of payments
V = known future value (in this case the PV of the annual payments discounted to 12/31/2016)
n2 = number of periods until the first payment.