Cash Flow Budgeting and Forecasting for Service Businesses | Chris Benjamin | Skillshare

Cash Flow Budgeting and Forecasting for Service Businesses

Chris Benjamin, Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Videos (1h 7m)
    • Course Introduction

      2:21
    • Instructor Introduction

      1:42
    • Excel Basics

      10:35
    • Headers and Incoming Cash

      6:52
    • Outgoing Cash

      7:48
    • Totals and Formatting

      5:41
    • Formulas and Formatting

      6:25
    • Test Data

      4:21
    • Budgeting Basics & Summary Tab

      7:40
    • Summary Tab Format and Formulas

      4:14
    • Formulas

      7:38
    • Course Conclusion

      2:12

About This Class

**Template Included** Learn how to use Excel to forecast and budget in your service business. Learn the Ins and Outs

** New Course for 2018! **

Service businesses often run very day to day, without much planning for the future.  As well cash flow is always an issue, making sure there is enough in the bank to pay suppliers, your staff, yourself, and more.  It can definitely be a struggle at times, and where the money has come in and gone to can be a bit of a mystery over time.  Take control and let it be a mystery no more!  Start planning, forecasting and budgeting today with this course. 

Become a cash flow budgeting and forecasting pro!

This course is 100% in Microsoft Excel, showing you from start to finish how to build a proper budget and forecast for your small business / service business.  We start with a blank Excel workbook, and will build the proper structure, formatting, formulas so that you can plan ahead for the future of your company, whether that is next week, month or the entire coming year.

You will be able to see where your money comes in, where it goes out and at the end of the day/month/year where you will stand.  This is most powerful if you compare what you are planning to what you actually achieve. 

As well I provide the template we build in the course for you to download! If you don't have the time or desire to build your own forecast, you can simply use the budget and forecast we build in the course and modify it to meet your needs.  

What We Do In The Course:  

  • Start with a blank Excel workbook which will become your budget and forecast
  • Build the proper structure for a budget and forecast
  • Format the spreadsheet so it is easy to read and follow
  • Place formulas in to calculate totals where appropriate
  • Create a summary tab to show overall totals
  • Show you how to track your actual results against the forecast and budget
  • Teach you how to then use that information to make informed decisions about your business
  • And Much More!!!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, financial reporting, and small business, Excel budgeting and forecasting.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA

9

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Chris Benjamin

Instructor, MBA and CFO

Report class