Topic Thread

Cash Flow Projection- Excel Worksheet

  • 1.  Cash Flow Projection- Excel Worksheet

    Posted 14 days ago
    if anyone has developed an Excel worksheet for projecting monthly cash flows on a job by job basis that they would be willing to share, please contact me at ksloan@hardaway.net. Thanks.

    ------------------------------
    Kerry Sloan CPA, CCIFP
    Executive Vice President, Finance
    Hardaway Group, Inc.
    Nashville TN
    (615) 254-5461
    ------------------------------


  • 2.  RE: Cash Flow Projection- Excel Worksheet

    Posted 14 days ago
    I would be interested in this as well.

    ------------------------------
    Brett Taft BS,MBA
    CFO
    JT Electric
    Salt Lake City UT
    (385) 249-5555
    ------------------------------



  • 3.  RE: Cash Flow Projection- Excel Worksheet

    Posted 14 days ago
    I would be interested in this also!

    ------------------------------
    Donna Kebel BA in Business, CPA
    Controller
    Aschinger Electric Co.
    Fenton MO
    (636) 343-1211
    ------------------------------



  • 4.  RE: Cash Flow Projection- Excel Worksheet

    Posted 13 days ago
    Kerry,

    I have developed a worksheet for weekly cashflow forecasting for a 13 week forecast period.  I've found this to be a very useful cashflow management tool. It's based on the assumption that it would be updated weekly.  I can provide a copy of the worksheet at no charge. Feel free to contact me by email (mail@consttech.solutions) if you are interested in a weekly template.

    The template can be modified to be used monthly and will likely need customized/optimized for your business needs.  The current version includes commitments paid to date tracking for those contractors that don't have a full ERP solution.

    Best,

    ------------------------------
    Kevin Halme
    Constructive Tech Solutions
    Omaha, NE
    ------------------------------



  • 5.  RE: Cash Flow Projection- Excel Worksheet

    Posted 12 days ago
    Kevin -
    I would love to see this as well if you don't mind sharing it.
    Thanks so much

    ------------------------------
    Jamie Levendusky
    Controller
    Precision Upstate LLC
    Scotia NY
    (518) 930-4243
    ------------------------------



  • 6.  RE: Cash Flow Projection- Excel Worksheet

    Posted 11 days ago
    Hi Kerry
    I would be interested in the projection worksheet, thank you for sharing.

    Angela



    --
    Angela M. Kirk
    Controller
    Shannon Construction Company


    3257 West Liberty Avenue
    Suite 200
    Pittsburgh, PA  15216

    P - 412-341-1155 - Ext. 9091
    F - 412-341-2955
    Direct - 412-942-9091







  • 7.  RE: Cash Flow Projection- Excel Worksheet

    Posted 11 days ago

    Would really appreciate seeing this as well.

     

    Cameron Weldon Executive Vice President

    Weldon Contractors 3428 W Pioneer Pkwy Arlington, TX 76013

    Main: (817) 460-1111 Direct: (682) 375-2818 Fax: (682) 375-2018

     

    WeldonContractorsLogoVector-page-001_clipped_rev_1

    Since 1984

     






  • 8.  RE: Cash Flow Projection- Excel Worksheet

    Posted 11 days ago
    Hi Kevin,

    I would be interested in this as well.  Thank you for sharing!

    Kim Duncan
    Controller
    Trice Construction
    Chicago, IL
    773-570-3246
    kduncan@triceconstruction.com

    ------------------------------
    Kimberly Duncan
    Controller
    Trice Construction Company
    Chicago IL
    (773) 548-4000
    ------------------------------



  • 9.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago

    I would be interested in this worksheet as well. Thank you very much.

     

    Penny Orr, Controller

    CPA

    orr logo

    438 7th Ave
    Altoona PA 16602
    Office: 814 381 7420
    Fax: 814 381 7421
    Cell: 814 937 4601 

     P Please consider the environment before printing this e-mail.

    NOTICE OF CONFIDENTIALITY
    This communication is intended to be confidential and solely for the use of the person(s) or entities addressed above. If you are not an intended recipient, be aware that the information contained herein may be protected from unauthorized use by privilege or law, and any copying, distribution, disclosure, or other use of this information is prohibited. If you have received this communication in error, please contact the sender by return e-mail or telephone (814-381-7420) immediately, and delete or destroy all copies. Thank you for your cooperation.

     






  • 10.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago

    A copy would be greatly appreciated

     

                    Bernie

    Bernard C. Banks, Jr.

    President/CEO

    American Asphalt Paving Co.

    500 Chase Road

    Shavertown, PA 18708

    570-696-1181 Ext. 224

    570-406-9332 Cell

    Bernie.banks.jr@amerasphalt.com

     

     






  • 11.  RE: Cash Flow Projection- Excel Worksheet

    Posted 9 days ago
    Edited by Sara Steffan 9 days ago
    I would be interested in a copy of that as well!  Thank you!

    ------------------------------
    Sara Steffan
    CFO
    Showcase Builders, LLC
    Kingsland TX
    sara@showcasebuilders.com
    ------------------------------



  • 12.  RE: Cash Flow Projection- Excel Worksheet

    Posted 11 days ago
    Dear Kevin,

    Good morning.  I too would be interested in seeing the template.  Thank you for sharing this.

    Best,

    Alexandra

    ------------------------------
    D. Alexandra Dyer
    Chief Financial Officer
    Armand Corporation
    New York NY
    (212) 542-4179
    ------------------------------



  • 13.  RE: Cash Flow Projection- Excel Worksheet

    Posted 11 days ago
    Kevin,
    I am also interested in a copy of your cash flow worksheet.
    Thank you!
    Emily

    ------------------------------
    Emily Dolson
    CFO
    ATCS, Inc.
    Englewood, OH
    edolson@atcs-inc.com
    ------------------------------



  • 14.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago
    I would be interested as well.
    Thanks for sharing.

    ------------------------------
    Shirley Beard
    Controller
    DEB Construction Inc.
    Anaheim CA
    (714) 632-6680
    ------------------------------



  • 15.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago
    Hi Kerry,

    I would be interested in the projection worksheet.

    Thank you for sharing.




    ------------------------------
    Diana Dai
    Controller
    Su-Mo Builders, Inc.
    Honolulu HI
    (808) 833-3564
    ------------------------------



  • 16.  RE: Cash Flow Projection- Excel Worksheet

    Posted 8 days ago
    Kevin,

    I would love to see this worksheet as well.

    Thank you!

    ------------------------------
    Amy McKelvey
    CFO
    Carocon Corp.
    Charlotte NC
    (704) 525-1410
    ------------------------------



  • 17.  RE: Cash Flow Projection- Excel Worksheet

    Posted 8 days ago

    ​I would be interested also!



    ------------------------------
    Jordan Parker
    Controller
    Pitt Electric ORI LLC
    Greenville NC
    (252) 355-2267
    ------------------------------



  • 18.  RE: Cash Flow Projection- Excel Worksheet

    Posted 11 days ago
      |   view attached

    Attached is an example of cash flow projection I like to use.

     

    This can be modeled into a monthly cash flow projection, but I like to break my cash flow into weeks.  Based on updated information you can adjust the timing of cash receipts and cash outlays on the Weekly AR & AP Detail for jobs.

     

     

     

    Thanks,

     

     

    Brexton

    Richard Baldini / Chief Financial Officer

    Office: 614-495-9463

    Fax: 866-303-6171

    1123 Goodale Blvd., Suite 500

    Columbus, Ohio 43212

    Richard.Baldini@brextonllc.com

    brextonllc.com

     




    Attachment(s)



  • 19.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago
    Thank you for sharing your document

    ------------------------------
    Amy Rines
    VP Finance
    Colarelli Construction
    Colorado Springs CO
    (719) 475-7997
    ------------------------------



  • 20.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago
    Thank you for sharing!

    ------------------------------
    Rosemarie Sopher
    Cost Accountant
    Joe Bland Construction L.P.
    Austin TX
    (512) 821-2808
    ------------------------------



  • 21.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago
    Richars,

    Thank you for sharing.


    ------------------------------
    Diana Dai
    Controller
    Su-Mo Builders, Inc.
    Honolulu HI
    (808) 833-3564
    ------------------------------



  • 22.  RE: Cash Flow Projection- Excel Worksheet

    Posted 9 days ago
    Thank you for sharing this file.

    ------------------------------
    Suzette Bois CPA
    Director of Finance/Sr. Principal
    SMRT Inc.
    Portland ME
    (207) 772-3846
    ------------------------------



  • 23.  RE: Cash Flow Projection- Excel Worksheet

    Posted 9 days ago
    Thanks for the share.

    ------------------------------
    John Dees CPA - CCIFP
    CFO/Controller
    Gulf Equipment Corporation
    Theodore AL
    (251) 653-5075
    ------------------------------



  • 24.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10 days ago
    I am interested in such a worksheet as well.

    ------------------------------
    John Dees CPA - CCIFP
    CFO/Controller
    Gulf Equipment Corporation
    Theodore AL
    (251) 653-5075
    ------------------------------



  • 25.  RE: Cash Flow Projection- Excel Worksheet

    Posted 8 days ago
    I've sent out a link to download the template to the over 100 contractors who have requested this template.  It seems to be a popular topic.  Due to the number of requests, it has come to my attention that some email servers have marked my email as spam. If you have requested the template from me but have not received an email, please check your spam filter. If you still don't see it, feel free to reach out again via email (mail@consttech.solutions).

    ------------------------------
    Kevin Halme
    Constructive Tech Solutions

    ------------------------------