Results 1 to 2 of 2

Thread: Cash burn rate and depletion date

  1. #1
    Seeker imapoboy2's Avatar
    Join Date
    Jul 2013
    Posts
    11
    Articles
    0
    Excel Version
    2013

    Cash burn rate and depletion date



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    317
    Articles
    0
    Excel Version
    2019
    It would be very helpful if you attached some sample data (ie. 5-8 records) and then a mocked up solution. Do not load a picture as we can not manipulate data in a picture.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •