pay back period
 

i am trying to work out the pay back period for the following:
b6 -80 000
b7 10 000
b8 40 000
b9 100 000

where b6 is the intal cost of the project, b7, b8, b9 represent what the
project returns after 1year 2 years 3years respectively. through working it
out on paper the pay back period for it is 2 years and 16 weeks that was
found by adding the 10 000 and the 40 000 together and minusing that from the
initial value then dividing what is left by the 3 years return and multipling
it by 52 to get weeks. however i have muliptle other columns with different
values and was wondering whether there was just one equation where it could
do it all for me.... any Suggestions???? thanks for any help in advance....

pay back period
 

See if this formula doesn't give you some ideas. Keep in mind that you can
reference a cell anywhere you can put in a number :)
=ABS((((B7+B8)+B6)/B9)*52)
gives me 15.6 weeks for a result using your values and assuming that b9 is
the 3rd year return. The ABS keeps negative numbers out of the result.



"Kake" wrote:

i am trying to work out the pay back period for the following:
b6 -80 000
b7 10 000
b8 40 000
b9 100 000

where b6 is the intal cost of the project, b7, b8, b9 represent what the
project returns after 1year 2 years 3years respectively. through working it
out on paper the pay back period for it is 2 years and 16 weeks that was
found by adding the 10 000 and the 40 000 together and minusing that from the
initial value then dividing what is left by the 3 years return and multipling
it by 52 to get weeks. however i have muliptle other columns with different
values and was wondering whether there was just one equation where it could
do it all for me.... any Suggestions???? thanks for any help in advance....