No video :(

How to Create a Cash Flow Forecast (in under 20 minutes) {FREE TEMPLATE}

Подписаться 85 тыс.

Просмотров 64 тыс.

50% 1

Get your FREE cashflow template here: claracfo.com/c...
Predicting cash flow (aka forecasting cash flow) is one of the most critical tasks any small business owner can do to help their financial stability.
A good cash flow forecast can help you make decisions, plan ahead for cash shortfalls, scenario plan, and identify financial problems with enough time to make changes!
Update your cash flow forecast at least monthly for best results!
To learn more about CFO services, go to: claracfo.com/c...
💲 Need an accounting system? We use Quickbooks Online with clients and recommend it as the best accounting system for small businesses. Sign up to get a discounted subscription for 12 months! claracfo.com/QBO
🙋‍♀‍Got Employees? Talk to ADP! They can help you if you are a small business owner or an accountant or advisor who works with small businesses. Learn more here: claracfo.com/a...
💸Pay vendors any way they want and get paid faster! Accept credit cards without paying merchant fees! Melio is a fantastic payments solution for every small business! claracfo.com/m...
(As an affiliate or referral partner for these companies, I may earn rewards from qualifying purchases)
Hannah Smolinski is a #CPA and the Founder of Clara CFO Group. Find out more about Clara CFO Group at claracfo.com/
Disclaimer: This video is intended for educational purposes and
should not be taken as legal or tax advice. You should consult with your financial professionals about your unique financial situation before acting on anything discussed in these videos. Clara CFO Group, LLC is providing educational content to help small business owners become more aware of certain issues and topics, but we cannot give blanket advice to a broad audience.
CODE: ASGWZCEHOXFNBQYQ, YCJYEEHMQPU1FEOO

Опубликовано:

28 июн 2023

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 56

@KuboConsulting 17 дней назад

This is a well explained cashflow forcast! Downloaded the file. I will review all the videos.!!

@ClaraCFO 16 дней назад

great!

@yinggao4885 2 месяца назад

Extremely helpful videos❤, Hannah you are my mentor, definitely will stay tuned for all your videos!

@annehui7492 2 месяца назад

Great easy to follow video for me. Your voice is nice to listen to. Appreciate the help.

@user-vd3ij5dc6l 8 дней назад

Thank you very much for the video and presentation. However, I believe this template is somewhat basic and may be more suitable for very small businesses. I noticed that it does not include any sections on working capital investment or scenario options related to changes in DSO, DIO, or DPO. We understand that the main difference between EBITDA and operating cash flow is the investment in working capital. Therefore, without forecasting working capital investments, it’s not possible to accurately forecast cash flows. Additionally, working capital investment is influenced by the company's revenue growth as well as changes in DSO, DIO, and DPO. If these scenario options are added to the template, it would significantly enhance its effectiveness as a tool for forecasting cash flows. Thanks again for the template and the video!

@rafaelvillalobos9145 7 месяцев назад

Thank you for helping me to understand what cash flow really is and how to implement cash flow tracking using a workbook. I had been struggling for days trying to grasp the concept, and finally understood what it is thanks to this video and studying the sample workbook. I'm going to drive for Uber, so of course I made my own workbook after studying yours.

@jennabantjes3077 Месяц назад

Thank you for this! You may have saved our business (and my marriage)

@valv5993 2 месяца назад

THIS IS GREAT! Thank you!

@luqmansuhazeli6630 Год назад

Tq Soo much . I am 16. a form 4. student of accounting.

@aislinnmarcantelli1650 7 месяцев назад

Wow, thank you so much! Trying to keep the books for our small business and numbers are just not my thing. This was so helpful, understanding what a cash flow is and how to use one, I plan to implement it as part of my weekly routine to hopefully get us on track a bit more and expand my knowledge as s small business owner. Thank you so, so so much!

@elisantiago7297 7 месяцев назад

Great presentation and I will recommend you to business in my network.

@mrwah1271 10 месяцев назад

just what I needed right now, concise and well-explained. Subscribed!

@ClaraCFO 10 месяцев назад

Welcome aboard!

@user-jt2me6gp4g 9 месяцев назад

Thanks, this was very handy and educational...

@ClaraCFO 9 месяцев назад

So glad!

@alonzolopez6264 Год назад

Hannah your the BEST. THANK YOU AND HAVE A GREAT WEEKEND

@ClaraCFO Год назад

Thanks Alonzo! Happy 4th!

@basbijl 10 месяцев назад

Thanks, great video, curious to know how now to adjust it to cater to receiving sales payments within 60 days, do I need to shift the revenue cells to the right?

@vishalchopra551 2 месяца назад

Hi Clara one Question how can we adjust it for in a big organizations where weekly payrolls and the working capital changes gets involved

@crazyfarmboys8421 7 месяцев назад

Very helpful

@HeatherLittleton-k7l 8 дней назад

Hi Hannah, can you help please... firstly thank you for sharing such in depth videos and providing this template! What I'd like to know is when using the data from my P&L and Balance sheet, does this need to be downloaded as the 'accrual' or 'cash' basis? We are an accrual based business

@dw1784 Год назад

Thank you very much. This was a great video! I have watched a few so far and haven't been satisfied that I received the information that I am looking for until I watched this one. Great explanations! I am going to subscribe!

@Amigoampang 10 месяцев назад

Agreed, well done Clara. We will certainty take some program from you some time soon to support you service -Amigo/Saudi

@ali.s227 5 месяцев назад

Really appreciate your work

@ClaraCFO 5 месяцев назад

thanks for being here!

@gfernie4 6 месяцев назад

Thank you for your video, really helpful :) I understand including all outflows to the spreadsheet because a lot of them are fixed (the same every month) so we can always account for those type of outflows as a way to project future expenses and how that impacts cash flow. I have a hard time figuring how to include AR as inflows on cash flow as a general contractor, we have payment terms that we need to deal with and consider but how can we incorporate AR into cash flow given that we may not know when exactly that cash will be coming in? also, we have AP vendors to pay of which most are paid once we are paid.. how do we incorporate AP costs to cash flow when paying these vendors is dependent on our payment? I guess in summary, my questions are around including AP/AP sources to cash flow given that they are not fixed or date specific. Does anyone have a template or system they use in the construction industry? We are a small business. Thanks!

@unitedrecycling Год назад

Thank you, beautiful lady! Always a treat to listen and watch your work.

@ClaraCFO Год назад

Thanks for being here! Hope it's helpful!

@MasterYourBooks Год назад

Great video & tool!

@ClaraCFO Год назад

Thanks!

@grantwilson3105 Год назад

This is a good explanation. However I would argue this should be daily rather than monthly. It was the first thing I updated every morning after downloading the bank balances.

@ClaraCFO Год назад

Hmm - curious why you would need daily? I think it would be hard to keep track of daily cash flow in excel because of the detail needed. It could get very tedious.

@grantwilson3105 Год назад

@@ClaraCFO I set up the cashflow spreadsheet looking 6 months into the future. Put in all loan repayments, wages estimates, creditors estimates, payroll estimates etc. Then update it each day. I did this for 3 or 4 companies over 10 years and never ran out of cash.

@osamashah1 8 месяцев назад

So beautifully explained as beautiful you are. Love you. Keep it up.

@zekk9 16 дней назад

Thanks !

@billyhofacker1701 13 дней назад

I apologize if you said this and I missed it but I’m assuming this is an active sheet where you update each month as needed. If reality is different (significantly) than the forecast for a short period, do you just update it in real time? For example, if revenue is 5K less one month than expected for a small biz, just adjust and keep going? If not the rest will be off. It sounds obvious but I think I just need that affirmation! Thanks for the awesome content.

@MasterYourBooks Год назад

Many smbs get confused between cash flow forecast & budget & the importance of both..do u have a video comparing the 2.

@ClaraCFO Год назад

I don't, but I think we will get more into budgeting in Q4 as it aligns with our internal initiatives.

@ClaraCFO 9 месяцев назад

Here is our budgeting video! be sure to check out the next videos because we compare a forecast and a budget - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jK4D1JeT6iE.html

@MasterYourBooks 9 месяцев назад

@ClaraCFO thats going to be an AWESOME topic as many SMBs confuse one over the other. Excited to see your explanation of budget vs forecast. Excellent topic!

@nazcpatax Год назад

when are you planning to start your cfo course?

@ClaraCFO Год назад

Ha - you mean how to be a CFO? I have some course ideas, but I want to know what's going to be the most helpful for people first.

@evidencechinaemenma7005 7 месяцев назад

@@ClaraCFO Kindly share the course ideas. Thank you

@naveenkgeorge2000 Год назад

Hannah can you do a video regarding Budgeting

@ClaraCFO Год назад

I'll be working on one! We have a profit planning workshop that goes through the budgeting process here if you don't want to wait: learn.claracfo.com/profit-planning-workshop-reach-your-goals-in-2022?coupon=OVNQ5SG

@ClaraCFO 9 месяцев назад

Here ya go! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-jK4D1JeT6iE.html

@scotolivera8207 Год назад

I have read the simple numbers book , and i have searched the channel for another great book recommendation but couldn’t find find it

@ClaraCFO Год назад

what kind of book recommendation would you like? We have 9 great book recommendations on our shorts if you want to check those out!

@naveenkgeorge2000 Год назад

Can we consider this as a rolling forecast

@ClaraCFO Год назад

This is a rolling cash forecast. It isn't a rolling P&L forecast. I think it matters what you are trying to forecast to answer that question.

@munyanezagodfrey513 2 месяца назад

Please reshare the free template, thank you

@lvrodas23 6 месяцев назад

The formulas are not working. I downloaded the template, changed my expense titles and revenue titles, started plugging numbers and it is only taking account of what I put on the first line of my expense and cash at beginning of period; that is the only math that is working, none of the other cells are computing but it does show they have formulas plugged in.