A
Amnon Wilensky
Hi,
I am a contractor making a public works for the government.
Some times there is a difference between my payments to my workers and
subcontractors and the payments that I received from the government.
What formula do I have to use to calculate my loses as a result from that
gap?
For example:
1.. Contract value $1,000,000
2.. Period of execution – 8 month
3.. Time that I am paying to my workers and subcontractors (average) - 45
days from the end of a giving month
4.. Time I receive the payment from the government -90 days from the end
of a giving month.
5.. Interest rate 9% per year
Using Excel 2002
Thanks,
Amnon
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com
I am a contractor making a public works for the government.
Some times there is a difference between my payments to my workers and
subcontractors and the payments that I received from the government.
What formula do I have to use to calculate my loses as a result from that
gap?
For example:
1.. Contract value $1,000,000
2.. Period of execution – 8 month
3.. Time that I am paying to my workers and subcontractors (average) - 45
days from the end of a giving month
4.. Time I receive the payment from the government -90 days from the end
of a giving month.
5.. Interest rate 9% per year
Using Excel 2002
Thanks,
Amnon
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com