# Using Excel for Cash flow Projection

#### singcbl

##### Well-known Member
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.

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### RalphA

##### Well-known Member
Is this what you want?

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

#### sykes

##### Well-known Member
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

Replies
0
Views
242
Replies
0
Views
117
Replies
7
Views
211
Replies
4
Views
120
Replies
6
Views
105

1,191,718
Messages
5,988,267
Members
440,146
Latest member
rgomes8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back