imapoboy2
New member
- Joined
- Jul 2, 2013
- Messages
- 12
- Reaction score
- 0
- Points
- 1
- Age
- 56
- Location
- Wisconsin
- Excel Version(s)
- 2013
I'm tracking funds for a project in which payments are made "as needed" instead of being on a periodic schedule (weekly, monthly, etc...). I am asking for help on how to formulate a funding burn rate and an estimated depletion date for the available funds.
My spreadsheet contains the following:
Cell H1 = Funded Amount
Cell L1 = Today's Date
Column A = Payment # (e.g. 1, 2, 3...)
Column F = Invoiced Amount
Column H = Running total of $ (Amount Paid to Date)
Additional Information:
Contract term - 12 months
Any assistance would be greatly appreciated.
My spreadsheet contains the following:
Cell H1 = Funded Amount
Cell L1 = Today's Date
Column A = Payment # (e.g. 1, 2, 3...)
Column F = Invoiced Amount
Column H = Running total of $ (Amount Paid to Date)
Additional Information:
Contract term - 12 months
Any assistance would be greatly appreciated.