Topic Thread

Subject: Cash Projections

1.  Cash Projections

Posted 05-02-2017 08:31
What software do you use for cash projections, and how effective is it?

------------------------------
Joseph Harper CPA, CCIFP
Controller
Jedson Engineering
Cincinnati OH
(513) 965-7226
------------------------------


2.  RE: Cash Projections

Posted 05-03-2017 07:42
You can develop an excel based model for projecting cash.  It's the most flexible.

I typically develop a 13 week cash flow model and my 3 statement model in excel.

Are you a service contractor or a project based contractor?  If you are a project based contractor typically you want to look at the cash flow-to-complete each project based on your WIP schedule and develop a cash flow model using the future cash flows of each project.

Let me know if you have questions.

Michael

------------------------------
Michael Beaver CCIFP
Director
Conway Mackenzie
New York NY
(212) 586-2200
------------------------------



3.  RE: Cash Projections

Posted 05-03-2017 09:07
Edited by Melissa Bowers 05-03-2017 09:08
Joseph,
CFMA has a couple good cash forecasting webinars you might check out. The templates I use now were derived from some of their respective course documents. (side note-- mine are also in Excel)

------------------------------
Melissa Bowers
CFO
Rick Scott Construction
Ponca CIty OK
(580) 762-7027
------------------------------



4.  RE: Cash Projections

Posted 05-04-2017 09:05
I have developed a cash flow projection that ties directly to my WIP.  I have the PM's project out billings on their WIP schedule, then I estimate on a monthly basis when the receivables / retainage / payables from those billings will actually be received / disbursed, and then pull that into another tab into a comprehensive spreadsheet that estimates monthly overhead / financing cash disbursements.

Initially I tried to work with other templates, but decided I just needed to start from scratch and create my own.  It took a long time to set up, but now it's become an integral part of my monthly reporting and a great tool for planning.

------------------------------
Beth Quinn CPA
Chief Financial Officer
RF Construction, Inc.
Manhattan KS
(785) 776-8855
------------------------------



5.  RE: Cash Projections

Posted 05-04-2017 10:52

Beth would you be willing to share your template.
I am also trying to develop a cash flow projection that ties to my WIP.



------------------------------
Ursula Polanowski
Controller
Ironshore Contracting LLC
Linthicum MD
upolanowski@ironshoregrp.com
(443) 552-5732
------------------------------



6.  RE: Cash Projections

Posted 05-09-2017 09:30
Good morning Beth,

From all the feedback it sounds like your spreadsheet is amazing. I would appreciate a copy if you are still sharing.

With many thanks,

------------------------------
Marc Leotaud MBT
CFO
Air Control Systems, Inc.
Ontario CA
(909) 786-4128
mleotaud@aircontrolsystems.net
------------------------------



7.  RE: Cash Projections

Posted 05-09-2017 11:00
Beth,

If you are sharing your cash projections spreadsheet could you add me to the list please?

Thanks

Linda Montoya
Director of Finance & Accounting
True Metal Solutions
3530 E Atlanta Ave
Phoenix, AZ  85040
linda.montoya@truemetalsolutions.com

------------------------------
Linda Montoya MBA
Director of Finance & Accounting
True Metal Solutions
Phoenix, AZ 85040
(602) 595-7801
------------------------------



8.  RE: Cash Projections

Posted 05-09-2017 11:31

Beth,

CFMA has a variety of Cash Management online education that can also assist in providing you some industry best practices.
Click on  the link below to view our online recorded sessions including Cash and Advance Cash Management.

http://cfma.digitellinc.com/cfma/conferences/9/view



------------------------------
Brian Summers
Vice President of Content Management and Education
CFMA
Princeton NJ
(609) 452-8000
------------------------------



9.  RE: Cash Projections

Posted 05-05-2017 08:27
That's great! Would you mind sharing an example of a template?

------------------------------
Deborah Congden
Chief Financial Officer
Patriot Towers Inc.
Scottsville NY
(585) 889-3391
------------------------------



10.  RE: Cash Projections

Posted 05-05-2017 09:34
Hi Beth, I too would love to see your spreadsheet so that I can use as a starting template.

Thanks!

------------------------------
Vanessa Von Dohlen-Bertholf
CFO
JK Bernhard Construction
Kerrville TX
(830) 895-1498
------------------------------



11.  RE: Cash Projections

Posted 05-05-2017 10:01
Hi - I'd love to see any and all samples too.  I have one I've developed over the years but our board wants it more 'automated'.  I'm not sure how to do that as every major project is so different.  It really helps me to see how other financial minds spread out a job based cash flow.

------------------------------
Jill Morrow
Vice President / Controller
RBN Roofing
Irving TX
(972) 505-2800
------------------------------



12.  RE: Cash Projections

Posted 05-05-2017 10:53
I would also like to see what others are utilizing for cash projections!

Donna L. Kebel
636-343-1211 ext. 143


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



13.  RE: Cash Projections

Posted 05-08-2017 10:59
I would also like to see your template.


------------------------------
Robert McMaster, CPA
D'Annunzio & Sons, Inc.
South Plainfield NJ
(732) 574-1300 ext 104
------------------------------



14.  RE: Cash Projections

Posted 05-05-2017 10:26
Beth, would love to see template as well.

------------------------------
Timothy Orkins
VP of Finance
Jomco Inc
Gainesville GA
(770) 536-3999
------------------------------



15.  RE: Cash Projections

Posted 05-06-2017 09:50
Beth, would you include me in sharing your templet. There is always more we can learn from each other.
Thanks

------------------------------
James Fowler
President
James W. Fowler Co.
Dallas OR
(503) 623-5373
------------------------------



16.  RE: Cash Projections

Posted 05-08-2017 11:35

Me too please.






17.  RE: Cash Projections

Posted 05-09-2017 09:21
Could I get a copy as well.


------------------------------
Robert Scharfenberg CPA
Skiles Group
Richardson TX
------------------------------



18.  RE: Cash Projections

Posted 05-06-2017 21:14
Beth,  It appears that you could earn some cash sharing your CF template.  If you are willing to share, please add me to the list.  Thanks!

------------------------------
Ann Chen MBA
Fractional CFO
SteepleGroup Consulting, Inc.
Brea CA
(714) 454-3690
achen@steeplegroup.com
------------------------------



19.  RE: Cash Projections

Posted 05-07-2017 15:28
We do something similar incorporating WIP/ Backlog reports.

Would be good to compare notes / models/ tools.

Thanks,

Mike

------------------------------
Michael Robie
CFO/CIO
Glass Solutions, Inc.
Elmhurst IL
(630) 532-1234
------------------------------



20.  RE: Cash Projections

Posted 05-08-2017 07:15
Hi if it is not too late, can you please share with me as well.

Greatly appreciated!!

Thanks,

Michelle D. Thomas
Sent from my Verizon 4G LTE Droid





21.  RE: Cash Projections

Posted 05-09-2017 13:51
I'd like to get a copy as well, thanks very much.

------------------------------
Cynthia Hansen CPA
CFO
McLarney Construction Inc.
San Jose CA
(408) 246-8600
------------------------------



22.  RE: Cash Projections

Posted 05-08-2017 13:13

I would love to be added to the list also to receive a copy of the cash flow template

 

Thanks!

 

Carrie Fortier, CPA
 
 541-687-2320
Connect with me on LinkedIn
 cfortier@jrcpa.com" target="_blank">Send Me Files Securely
​ www.jrcpa.com
​ Bend | Portland | Eugene


<a href=image006.jpg@01D06CBD.9B726A90">
​ 

ii_ilck5wwh1_1533d914df0285cd

Jones & Roth was Voted one of Oregon's
100 Best Companies to Work for in 2016

 

Securities offered through 1st Global Capital Corp., member FINRA,/SIPC. 

8150 N Central Expressway, Dallas, Texas 75206 1-800-959-8440

 

NOTICE: This communication may contain privilege or other confidential information.  If you are not the intended recipient, or believe that you have received this communication in error, please do not print, copy retransmit, disseminate, or otherwise use the information.  Also, please indicate to the sender that you have received this e-mail in error, and delete the copy you received.  Thank you

 






23.  RE: Cash Projections

Posted 05-09-2017 08:32
Hi Beth,
I would appreciate a copy of this template as well.
Thanks for sharing!


------------------------------
Maureen Korody
Cfo
Accurate Acoustical, Inc.
Victor NY
(585) 924-4200
------------------------------



24.  RE: Cash Projections

Posted 05-07-2017 10:02
Beth, I hope I am not too late to reply to this discussion. That sounds like an impressive cash flow spreadsheet. If you are willing to share, please send me a copy. Thank you for sharing your accomplishment.

------------------------------
Christoper Mosgo CPA
Controller
West Roofing Systems, Inc.
LaGrange OH
(440) 355-9929
chrism@westroofingsystems.com
------------------------------



25.  RE: Cash Projections

Posted 05-07-2017 12:02
I concur with everyone above, if you'd be willing to share I'd greatly appreciate it.  I've been working on a similar spreadsheet for our company and I'm always looking for ways to improve the process.

------------------------------
William Gobbel CPA
Controller/VP
Flournoy Construction Company, LLC
Columbus GA
(706) 243-9245
gene.gobbel@flournoyconstruction.com
------------------------------



26.  RE: Cash Projections

Posted 05-08-2017 07:54

Beth,

 

Would love to have a copy of your template as well if you are willing to share.

 

Thanks so much –

 

 

MARSHA FITZGERALD

Controller

 

image007.jpg@01D25A04.4CC95E40

 

M - 704.622.6491 | D - 980.335.1505

doerreconstruction.com

 

map | email       

 

 






27.  RE: Cash Projections

Posted 05-09-2017 11:03
i would appreciate a copy of you template as well.

Thank you.

------------------------------
John Evers CPA
Controller
Century Construction and Realty, Inc.
Tupelo MS
(662) 844-3331
------------------------------



28.  RE: Cash Projections

Posted 05-09-2017 20:59

I would also love  copy






29.  RE: Cash Projections

Posted 05-10-2017 08:37

Hello Beth,

 

Its so kind of you to offer to share your spreadsheet.  As so many others, I would love to have a copy as well if you are still willing to share.

 

Thank you very much for your kindness in sharing!

Sincerely,
 

Brenda S. Shoup
Brenda S. Shoup, Controller, CCIFP
Bilbrey Construction, Inc.
937-228-0046 Phone
937-228-8751 Fax
brenda@bilbrey-construction.com

 



------------------------------
Brenda Shoup CCIFP
Bilbrey Construction
Dayton OH
(937) 228-0046
------------------------------



30.  RE: Cash Projections

Posted 05-08-2017 08:43
Likewise! please share with me as well.

------------------------------
Michael Preyss
Chief Financial Officer
Garmong Construction Services
Indianapolis IN
(317) 682-1001
------------------------------



31.  RE: Cash Projections

Posted 05-09-2017 17:29
If you are still sharing this great resource - I would love a copy!

Thanks!

------------------------------
Elizabeth Frantum
CFO
Ball Team LLC
Urbandale IA
bfrantum@buildwithball.com
------------------------------



32.  RE: Cash Projections

Posted 05-08-2017 08:47
Beth,
Sounds like an impressive spreadsheet.  I developed a spreadsheet to assist our Project Managers in their monthly billings but I would be very interested in seeing what you developed.  If you are willing to share, please send me a copy.  Thank you very much!!

------------------------------
James Frederick BBA-Accounting
CFO
Corcoran Glass & Paint, Inc.
Greenville WI
(920) 757-9900
------------------------------



33.  RE: Cash Projections

Posted 05-08-2017 09:59
Beth,
I agree, that is impressive.  I would also be interested if you are willing to share.

Kellie

------------------------------
Kellie Rowe
Controller
Catworks Construction
Battle Ground WA
(360) 666-1113
------------------------------



34.  RE: Cash Projections

Posted 05-08-2017 12:58

Hello Beth,

 

I'd love to see your spreadsheet as well if you're willing to share.

 

Thank you,

 

Cathy Barttelbort| Controller   

image008.png@01D244A6.1A2D1DF0

Building Construction Excellence 

 

2000 Market Street           
Riverside, CA  92501
(951) 684-9303  ext. 238 | office
(951) 367-4615 | fax

cathyb@teamsei.com

www.strongholdengineering.com

SAFETY  |  INTEGRITY  |  TEAMWORK  |  COMMITMENT  |  QUALITY

  http://files.constantcontact.com/d9f38bc6001/d72782e7-32c4-41f9-ac00-a9220a1feab5.png

 






35.  RE: Cash Projections

Posted 05-07-2017 20:22
Beth - I would also appreciate a copy of your template! Thanks!

Wick

------------------------------
J. Wickham Zimmerman
CEO
OTL
Newport Beach CA
(714) 637-4747
------------------------------



36.  RE: Cash Projections

Posted 05-08-2017 07:30
I would love to have a copy as well. Sounds like a great comprehensive projection tool.
Thanks,
Tom



Tom Lowrey, CFO

Scott Bridge Company, Inc.

2641 Interstate Drive

Opelika, AL 36801

Office: 334-749-5045

Cell: 334-321-8628

Sent from my Samsung Galaxy Smartphone 






37.  RE: Cash Projections

Posted 05-09-2017 09:00
Beth,

Can you also share a copy of your Cash Projection spreadsheet with me. It sounds like a great tool.

Thank you,

------------------------------
Robert Pekarsky Robert Morris University
Controller/CFO
Kacin Companies
Murrysville PA
(724) 327-6694
------------------------------



38.  RE: Cash Projections

Posted 05-08-2017 11:10
Beth - Would love to see your template if you could be so kind.

------------------------------
Chae Kim
CFO
Legacy Group, Inc.
Renton WA
(206) 217-0310
------------------------------



39.  RE: Cash Projections

Posted 05-08-2017 11:43

Hi Beth,

Would you mind including me in the distribution of your cash flow sheet?

Thanks! 



------------------------------
Cassandra Castillo
Controller
Advantage Industrial Systems, LLC
c.castillo@aisystemsgroup.com
------------------------------



40.  RE: Cash Projections

Posted 05-11-2017 17:14
Beth I would appreicate a copy too.

------------------------------
Matt Huber CFA, CPA
CFO
Modern Companies, Inc.
Cedar Rapids IA
(319) 841-1170
------------------------------



41.  RE: Cash Projections

Posted 05-08-2017 08:36

I am working to develop a model as well utilizing the WIP report to forecast billings.   Great to share ideas and compare and would also appreciate a copy of your model Beth.   



------------------------------
Mark Lang
Controller
JC Wilkie Construction
Lexington SC
(803) 808-3220
------------------------------



42.  RE: Cash Projections

Posted 05-09-2017 08:21
Hello Beth
I would love a copy of your template if possible. thank you so much.

------------------------------
Penny Orr
Controller
J C Orr & Son Inc.
Altoona PA
(814) 944-8111
------------------------------



43.  RE: Cash Projections

Posted 05-08-2017 08:58
Hello Beth,


Thanks for sharing! I have been using a cash flow spreadsheet to estimate AR, AP, Payroll and fixed monthly overhead for some time now. Have not thought to link to WIP to encourage buy in from Project Management. This seems like a great idea, happy to know it has been working for you. If you are willing to share, please do forward and I can try to implement.



Best,

------------------------------
Parag Kapadia
Controller
(718) 397-9527 X 103
Woodside, NY
Kanta Electric
------------------------------



44.  RE: Cash Projections

Posted 05-09-2017 09:25
Beth,

If your are still sharing, please add me.

Thanks

------------------------------
Cheryl Higgins
Zimmerman MN
------------------------------



45.  RE: Cash Projections

Posted 05-08-2017 09:28
Good morning, Beth.

Could I also get a copy of that spreadsheet? Sounds like it would work perfectly for us.
Thank you!






------------------------------
Amanda Wiebe
Office Manager / Controller
Trinity Electrical Services
(712) 333-9134
amanda@trinityelectric.com
------------------------------



46.  RE: Cash Projections

Posted 05-08-2017 10:50
I also would love to see a copy of the template.

------------------------------
Dennis Stejskal
Vice President - Strategy
Sage
Beaverton OR
(503) 439-5215
------------------------------



47.  RE: Cash Projections

Posted 05-09-2017 08:33
Beth

If you are sharing, please add me to the list. I would love to compare and have an additional tool to use.

------------------------------
Shawn Sullivan
Assistant Controller
Gulf Stream Construction Co.
Charleston SC
(843) 572-4363
------------------------------



48.  RE: Cash Projections

Posted 05-09-2017 08:55
Good morning
Beth, thank you for sharing the excel spreadsheet you created.  The WIP I use, also an excel spreadsheet, is very similar to the one you use.  I am excited to give the cash flow spreadsheet a go.

Again, thank you so much,
Sue H.

------------------------------
Susan Heffernan BBA
Controller/Treasurer
Martin-Zombek Construction Services Inc
East Syracuse NY
(315) 707-7052
------------------------------



49.  RE: Cash Projections

Posted 05-09-2017 09:42

Beth, Please add me to your list!  I would love to see your spreadsheet too.

Thanks!



------------------------------
Ruth Ford
Senior Financial Manager
Grooms & Pollard Utility Services, LLC
Oklahoma City OK
(405) 286-8034
------------------------------



50.  RE: Cash Projections

Posted 05-09-2017 11:11
Beth,

I too would appreciate a copy of your cash forecast template.

Thanks

------------------------------
John Hobbs
CFO
ATS Companies
Pflugerville TX
(512) 255-9951
jhobbs@atscc.com
------------------------------



51.  RE: Cash Projections

Posted 05-09-2017 11:13
Hi Beth,

I am also interested in your spreadsheet.  Thanks for sharing!

------------------------------
Bradley Hom CCIFP, CPA, CGMA
Chief Financial Officer
RM Mechanical Inc
Boise ID
(208) 362-7814
------------------------------



52.  RE: Cash Projections

Posted 05-09-2017 11:37
Beth,

Can you add me to your distribution list.  I'd love to see your cash projection spreadsheet.

thank you


------------------------------
Stan Prolo
CFO
De Mattei Construction, Inc
San Jose CA
(408) 640-0525
------------------------------



53.  RE: Cash Projections

Posted 05-09-2017 12:10
Beth,
I have developed a cash flow projection from the CFMA courses and added some of the things you're discussing. I also pin down my PMs on their Billings, Expenses and expected savings. Yours sounds 10 steps up from mine and I would love to see it.
I am also wondering if you would share it with CFMAs education steering committee. Currently, we are developing some more advanced courses as well as re-vamping courses.  It would be great to incorporate all your hard work and have another SME to help develop courses.




------------------------------
Patricia Dunn CPA, CFE
Cfo
Siteworks Design|Build
Portland OR
(206) 326-0963
patsy@siteworksportland.com
------------------------------



54.  RE: Cash Projections

Posted 05-09-2017 12:25
Hi Beth,

I would love to see your template as well. It sounds like you are going above and beyond. Maybe we should all make a donation to your favorite charity in return?

Thank you!

------------------------------
Grace Pizzey
Holaday-Parks, Inc.
Seattle WA
(206) 248-8706
gracep@holadayparks.com
------------------------------



55.  RE: Cash Projections

Posted 05-09-2017 12:30
Hi Beth,

I'd love to be added to the list as well if it's possible.
Thank you for sharing your work here and all of your efforts.




------------------------------
Diane Roth
Oakland CA

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



56.  RE: Cash Projections

Posted 05-10-2017 08:55
Beth,
Could you please add me to the list to share your excel cash flow projection.
Thank you,
Ken

------------------------------
Kenneth MacGregor CCIFP, CMA
Controller
Gilmore Construction Corporation
Denver CO
(720) 224-2500
------------------------------



57.  RE: Cash Projections