User Name Remember Me? Password

 Economics Economics Forum - Financial Mathematics, Econometrics, Operations Research, Mathematical Finance, Computational Finance

 April 7th, 2015, 12:44 PM #11 Newbie   Joined: Apr 2015 From: miami Posts: 18 Thanks: 0 I was trying to use your formula in a ms access table calculated field but found out that these fields can not accept brackets [] or braces {} only parentheses() so I tried to substitute () for the brackets and braces but the formula didn't work correctly. Any help is appreciated. [1 - x^(-1/p)]/(x-1) * [ (A+g*n-g) * [y^n - 1]/(y-1) ] - [ g/(y-1) * { [y^n - 1]/(y-1) - n } ] Last edited by skipjack; April 9th, 2015 at 02:59 PM. April 7th, 2015, 04:35 PM #12 Newbie   Joined: Apr 2015 From: miami Posts: 18 Thanks: 0 Here is what I ended up with: ((1-x^-26)/(x-1)*((A+g*n-g)*(y^n-1)/(y-1))-(g/(y-1)*((y^n-1)/(y-1)-n))) Not sure why this is not working MS Access is similar to Excel re order of operations: o Brackets calculated first o Indices (^) calculated next o Multiplication and division calculated next o Addition and subtraction calculated last Last edited by cb123; April 7th, 2015 at 04:41 PM. April 7th, 2015, 09:08 PM #13 Member   Joined: May 2014 From: Rawalpindi, Punjab Posts: 69 Thanks: 5 Code: PV = (1 - x^(-1/p))/(x-1) * ((A+g*n-g)*(y^n - 1)/(y-1) - g/(y-1)*((y^n - 1)/(y-1) - n)) Let me know if you would want the PV formula when number of periods in a year are not a complete figure such as 3.5 years The above formula only works for whole number of years such as 3 years April 7th, 2015, 11:12 PM #14 Newbie   Joined: Apr 2015 From: miami Posts: 18 Thanks: 0 Yes thank you, that would be the formula I need. (Will it also work when the periods are whole years?) Last edited by skipjack; April 9th, 2015 at 03:02 PM. April 7th, 2015, 11:45 PM   #15
Member

Joined: May 2014
From: Rawalpindi, Punjab

Posts: 69
Thanks: 5

Quote:
 Originally Posted by cb123 Yes thank you, that would be the formula I need. (Will it also work when the periods are whole years?)
Yes - give me 5 minutes, please.

Last edited by skipjack; April 9th, 2015 at 03:03 PM. April 8th, 2015, 12:22 AM   #16
Member

Joined: May 2014
From: Rawalpindi, Punjab

Posts: 69
Thanks: 5

Quote:
 Originally Posted by cb123 Yes thank you, that would be the formula I need. (Will it also work when the periods are whole years?)
Here is the complete formula.

When n is complete year such as 3, then n_2 will be 0, thus the sum to the right of the formula will be 0, giving you present value for complete years.

When n has a fractional part such as 3.5, then n_2 will be 0.5, thus the sum to the right of the formula will add to the present value up till complete years of 3, giving you the total present value for 3.5 years.

Please note this is a generic formula, therefore you may use any sort of payment period.

In your example the payments were biweekly, yet you can define payments such as quarterly by using p=1/4.

Any type of interest compounding is also allowed.

Let me know if it worked out in Access code.

Code:
A=100
g=15
i=13% annual cpd biweekly
n=3.5 years
n_1=FLOOR(n)=3
n_2=n-FLOOR(n)= 3.5-3 = 0.5
c=1/26 biweekly interest compounding
p=1/26 period is a biweek

Find PV

PV = (1 - x^(-1/p))/(x-1) * ((A+g*n-g)*(y^n - 1)/(y-1) - g/(y-1)*((y^n - 1)/(y-1) - n)) + (A+g*n_1) * (y^(n_1)) * (1-x^(-(n_2/p)))/(x-1)

aey(i,c) = (1 + i*c)^(1/c) - 1

i=0.13
c=1/26

aey(13%,1/26) = (1 + 0.13/26)^(26) - 1
aey(13%,1/26) = 0.138459553

aey(13%,1/26) = 13.85%

x=[1 + aey(i,c)]^p

p=1/26

x=[1 + 13.85%]^(1/26)
x=[1.1385]^(0.038462)

x=1.005

y=x^(-1/p)

y=(1.005)^(-26)

y=0.87837991

PV = (1 - x^(-1/p))/(x-1) * ((A+g*n_1-g)*(y^n_1 - 1)/(y-1) - g/(y-1)*((y^n_1 - 1)/(y-1) - n_1)) + (A+g*n_1) * (y^(n_1)) * (1-x^(-(n_2/p)))/(x-1)

PV = (1 - 1.005^(-26))/(1.005-1) * ((100+15*3-15)*(0.87837991^3 - 1)/(0.87837991-1) - 15/(0.87837991-1)*((0.87837991^3 - 1)/(0.87837991-1) - 3)) + (100+15*3) * (0.87837991^3) * (1-1.005^(-(0.5*26)))/(1.005-1)

PV = (1 - 1.005^(-26))/(0.005) * (30*(0.87837991^3 - 1)/(-0.12162009) - 15/(0.87837991-1)*((0.87837991^3 - 1)/(-0.12162009) - 3)) + 145 * (0.87837991^3) * (1-1.005^(-13))/(0.005)

PV = $7,329.20 +$1,233.88

PV = \$8,563.08

Last edited by skipjack; April 9th, 2015 at 03:17 PM. Reason: added explanation April 8th, 2015, 05:51 AM #17 Newbie   Joined: Apr 2015 From: miami Posts: 18 Thanks: 0 I will try this out tonight after I get off work and post back. Again, can't thank you enough for all your help and effort. April 8th, 2015, 05:53 PM #18 Newbie   Joined: Apr 2015 From: miami Posts: 18 Thanks: 0 WORKS PERFECTLY!!!! You the man Abraham   April 8th, 2015, 06:11 PM   #19
Member

Joined: May 2014
From: Rawalpindi, Punjab

Posts: 69
Thanks: 5

Quote:
 Originally Posted by cb123 WORKS PERFECTLY!!!! You the man Abraham  You're welcome,

If you ever need other financial formulas, post here.

I have plenty of these formulas in my head, the current count is around 9,000+.

Last edited by skipjack; April 9th, 2015 at 03:18 PM. April 8th, 2015, 06:48 PM #20 Newbie   Joined: Apr 2015 From: miami Posts: 18 Thanks: 0 9000+ formulas in your head. Must be hard to sleep at night. Thanks for sharing your know-how. Last edited by skipjack; April 9th, 2015 at 03:18 PM. Tags present, question ### present value biweekly question

Click on a term to search for related topics.
 Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Similar Threads Thread Thread Starter Forum Replies Last Post Jaider Applied Math 1 February 24th, 2015 02:29 PM n777l Complex Analysis 5 September 15th, 2013 01:11 AM marmozetka Algebra 3 May 21st, 2013 04:21 PM gouhayashi Economics 5 May 19th, 2011 09:39 PM Sandy123 Economics 1 October 6th, 2009 07:16 PM

 Contact - Home - Forums - Cryptocurrency Forum - Top       