I need a formula for doing cash flow projection.
I have the s-curve (Cumulative Time vs Cumulative Cost).
The total cost is provided and the time period during which this will happen.
Now I need to find the monthly cash flow per the s-curve (or distribution curve).
Can someone please guide me how to do this.
Thanks in advance.
The excel file can be downloaded from https://skydrive.live.com/redir?resid=9F6CAF43EE3A0818!115&authkey=!AFf3a7TlgmVDaxI
Thanking again.
Naiyer
I have the s-curve (Cumulative Time vs Cumulative Cost).
The total cost is provided and the time period during which this will happen.
Now I need to find the monthly cash flow per the s-curve (or distribution curve).
Can someone please guide me how to do this.
Thanks in advance.
The excel file can be downloaded from https://skydrive.live.com/redir?resid=9F6CAF43EE3A0818!115&authkey=!AFf3a7TlgmVDaxI
Thanking again.
Naiyer