Using Excel for Cash flow Projection

[singcbl]

I have in the past used a standard formula to do cash flow projection for construction project. This formula commonly known as the DHSS formula. I now need a bit of refreshing as I have lost the file I created using this formula. If there is anyone of you have a template or the formula I will be glad to receive a copy.

 

[RalphA]

Is this what you want?

v = 100[x+ax2-ax-(6x3-9x2+3x)/b] (1)
where
x = d/100

 

[sykes]

Found here:

http://eprints.qut.edu.au/archive/00004409/01/4409.pdf


4For comparative purposes, the following notation is adopted
V = total value of the contract (£)
D = total duration of contract (days)
v = percentage value complete
d = percentage of time complete

a and b are constants

The DHSS formula
v = 100[x+ax2-ax-(6x3-9x2+3x)/b] (1)
where
x = d/100


HTH