Topic Thread

Back to discussions
Expand all | Collapse all

Cash Flow Projection- Excel Worksheet

  • 1.  Cash Flow Projection- Excel Worksheet

    Posted 10-05-2018 10:53
    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 10-05-2018 11:50
    I would be interested in this as well.

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

    Original Message


  • 3.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-05-2018 12:06
    I would be interested in this also!

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

    Original Message


  • 4.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-06-2018 17:50
    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
    ------------------------------

    Original Message


  • 5.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-07-2018 19:31
    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
    ------------------------------

    Original Message


  • 6.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-08-2018 07:35
    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





    Original Message


  • 7.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-08-2018 09:09

    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

     




    Original Message


  • 8.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-08-2018 09:03
    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
    ------------------------------

    Original Message


  • 9.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-09-2018 08:03

    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.

     




    Original Message


  • 10.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-09-2018 12:15

    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

     

     




    Original Message


  • 11.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-10-2018 09:28
    Edited by Sara Steffan 10-10-2018 09:28
    I would be interested in a copy of that as well!  Thank you!

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

    Original Message


  • 12.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-08-2018 09:24
    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
    ------------------------------

    Original Message


  • 13.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-08-2018 09:43
    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
    ------------------------------

    Original Message


  • 14.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-09-2018 09:33
    I would be interested as well.
    Thanks for sharing.

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

    Original Message


  • 15.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-10-2018 03:45
    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
    ------------------------------

    Original Message


  • 16.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-11-2018 08:08
    Kevin,

    I would love to see this worksheet as well.

    Thank you!

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

    Original Message


  • 17.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-11-2018 08:25

    ​I would be interested also!



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

    Original Message


  • 18.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-08-2018 08:09
      |   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)

    xlsx
    Cash Flow Projection Example.xlsx   35K 1 version
    Original Message


  • 19.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-09-2018 06:39
    Thank you for sharing your document

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

    Original Message


  • 20.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-09-2018 10:19
    Thank you for sharing!

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

    Original Message


  • 21.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-10-2018 04:06
    Richars,

    Thank you for sharing.


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

    Original Message


  • 22.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-10-2018 06:44
    Thank you for sharing this file.

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

    Original Message


  • 23.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-10-2018 09:36
    Thanks for the share.

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

    Original Message


  • 24.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-09-2018 10:20
    I am interested in such a worksheet as well.

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

    Original Message


  • 25.  RE: Cash Flow Projection- Excel Worksheet

    Posted 10-11-2018 23:26
    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

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

    Original Message