Learn the basics of forecasting and budgeting from a finance perspective, how to create a proforma income statement, and how to create a cash budget. Read more.
Robert (Bob) Steele CPA, CGMA, M.S. Tax, CPI
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Students
- Business professionals
What you’ll learn:
- Forecasting objectives
- How to construct a budget
- How to create a proforma income statement
- How to create a cash budget
- How to make a proforma balance sheet
- How to use a percent of sales method
Requirements:
- General finance foundation needed
This course will cover the concepts of forecasting and budgeting from a finance perspective.
The course includes many example problems, both in presentation form, and many using Excel worksheets. Each Excel worksheet problem will include a downloadable Excel worksheet that has at least two tabs, one having the answer, the second including a preformatted worksheet that can be populated in a step-by-step process along with the instructional video.
To forecast and budget we need to make predictions and projections about the future. This is often done by first taking information from the past as our starting point. The starting point will generally be our prior financial statements, including our prior balance sheet, income statement, and statement of cash flows.
We will then consider changes that we expect to take place, including those we plan on making and changes to the economy and business environment.
When constructing our budgets, we will need to go in a systematic order. We usually need to start with a sales projection because other projections will depend on it.
Our budget process can then consider the production plan. We can then move to the capital budget, cash budget, and budgeted income statement. The budgeted income statement is our primary performance statement.
Once we have the beginning balance sheet and the projected income statement, we can create the projected balance sheet, the statement representing where we expect to be at the end of the budgeted time frame.
Our Promise to You
By the end of this course, you will have learned forecasting and budgeting from a finance perspective.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about forecasting and budgeting.
Course Curriculum
| Section 1 - Forecasting And Budgeting | |||
| Forecasting Objectives | 00:00:00 | ||
| Pro Forma Income Statement | 00:00:00 | ||
| Cash Budget | 00:00:00 | ||
| Pro Forma Balance Sheet | 00:00:00 | ||
| Percent Of Sales Method | 00:00:00 | ||
| Section 2 - Practice Problems - Forecasting And Budgeting | |||
| Sales Projection – Multiple Scenarios | 00:00:00 | ||
| Estimated Net Sales | 00:00:00 | ||
| Projected Units To Be Produced | 00:00:00 | ||
| Calculate Cost Of Goods Sold Using FIFO And LIFO | 00:00:00 | ||
| Calculate Cost Of Ending Inventory LIFO And FIFO | 00:00:00 | ||
| Schedule Of Cash Receipts | 00:00:00 | ||
| Schedule Of Cash Receipts – Multiple Scenarios | 00:00:00 | ||
| Schedule Of Cash Payments | 00:00:00 | ||
| Schedule Of Cash Payments – More Complex | 00:00:00 | ||
| Production Schedule And Schedule Of Cash Payments | 00:00:00 | ||
| Cash Budget And Cash Receipts Schedule | 00:00:00 | ||
| Cash Budget, Cash Receipts Schedule, Cash Payments Schedule | 00:00:00 | ||
| Required New Fund Formula All Balance Sheet Accounts Change Relative To Sales | 00:00:00 | ||
| Required New Fund Formula – Current Assets And Liabilities Change Relative To Sales | 00:00:00 | ||
| Section 3 - Excel Problems - Forecasting And Budgeting | |||
| Downloadable Practice Files | 00:00:00 | ||
| Sales Projection – Multiple Scenarios | 00:00:00 | ||
| Estimated Net Sales | 00:00:00 | ||
| Projected Units To Be Produced | 00:00:00 | ||
| Calculate Cost Of Goods Sold Using FIFO | 00:00:00 | ||
| Calculate Cost Of Goods Sold Using LIFO And FIFO | 00:00:00 | ||
| Schedule Of Cash Receipts | 00:00:00 | ||
| Schedule Of Cash Receipts – Multiple Scenarios | 00:00:00 | ||
| Schedule Of Cash Payments | 00:00:00 | ||
| Schedule Of Cash Payments – More Complex | 00:00:00 | ||
| Production Schedule And Schedule Of Cash Payments | 00:00:00 | ||
| Cash Budget And Cash Receipts Schedule | 00:00:00 | ||
| Cash Budget, Cash Receipts Schedule, Cash Payments Schedule | 00:00:00 | ||
| Cash Receipts, Cash Payments, And Cash Budget | 00:00:00 | ||
| Required New Fund Formula – All Balance Sheet Accounts Change Relative To Sales | 00:00:00 | ||
| Required New Fund Formula – Current Assets And Liabilities Change Relative To Sales | 00:00:00 | ||
About This Course
Who this course is for:
- Students
- Business professionals
What you’ll learn:
- Forecasting objectives
- How to construct a budget
- How to create a proforma income statement
- How to create a cash budget
- How to make a proforma balance sheet
- How to use a percent of sales method
Requirements:
- General finance foundation needed
This course will cover the concepts of forecasting and budgeting from a finance perspective.
The course includes many example problems, both in presentation form, and many using Excel worksheets. Each Excel worksheet problem will include a downloadable Excel worksheet that has at least two tabs, one having the answer, the second including a preformatted worksheet that can be populated in a step-by-step process along with the instructional video.
To forecast and budget we need to make predictions and projections about the future. This is often done by first taking information from the past as our starting point. The starting point will generally be our prior financial statements, including our prior balance sheet, income statement, and statement of cash flows.
We will then consider changes that we expect to take place, including those we plan on making and changes to the economy and business environment.
When constructing our budgets, we will need to go in a systematic order. We usually need to start with a sales projection because other projections will depend on it.
Our budget process can then consider the production plan. We can then move to the capital budget, cash budget, and budgeted income statement. The budgeted income statement is our primary performance statement.
Once we have the beginning balance sheet and the projected income statement, we can create the projected balance sheet, the statement representing where we expect to be at the end of the budgeted time frame.
Our Promise to You
By the end of this course, you will have learned forecasting and budgeting from a finance perspective.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about forecasting and budgeting.
Course Curriculum
| Section 1 - Forecasting And Budgeting | |||
| Forecasting Objectives | 00:00:00 | ||
| Pro Forma Income Statement | 00:00:00 | ||
| Cash Budget | 00:00:00 | ||
| Pro Forma Balance Sheet | 00:00:00 | ||
| Percent Of Sales Method | 00:00:00 | ||
| Section 2 - Practice Problems - Forecasting And Budgeting | |||
| Sales Projection – Multiple Scenarios | 00:00:00 | ||
| Estimated Net Sales | 00:00:00 | ||
| Projected Units To Be Produced | 00:00:00 | ||
| Calculate Cost Of Goods Sold Using FIFO And LIFO | 00:00:00 | ||
| Calculate Cost Of Ending Inventory LIFO And FIFO | 00:00:00 | ||
| Schedule Of Cash Receipts | 00:00:00 | ||
| Schedule Of Cash Receipts – Multiple Scenarios | 00:00:00 | ||
| Schedule Of Cash Payments | 00:00:00 | ||
| Schedule Of Cash Payments – More Complex | 00:00:00 | ||
| Production Schedule And Schedule Of Cash Payments | 00:00:00 | ||
| Cash Budget And Cash Receipts Schedule | 00:00:00 | ||
| Cash Budget, Cash Receipts Schedule, Cash Payments Schedule | 00:00:00 | ||
| Required New Fund Formula All Balance Sheet Accounts Change Relative To Sales | 00:00:00 | ||
| Required New Fund Formula – Current Assets And Liabilities Change Relative To Sales | 00:00:00 | ||
| Section 3 - Excel Problems - Forecasting And Budgeting | |||
| Downloadable Practice Files | 00:00:00 | ||
| Sales Projection – Multiple Scenarios | 00:00:00 | ||
| Estimated Net Sales | 00:00:00 | ||
| Projected Units To Be Produced | 00:00:00 | ||
| Calculate Cost Of Goods Sold Using FIFO | 00:00:00 | ||
| Calculate Cost Of Goods Sold Using LIFO And FIFO | 00:00:00 | ||
| Schedule Of Cash Receipts | 00:00:00 | ||
| Schedule Of Cash Receipts – Multiple Scenarios | 00:00:00 | ||
| Schedule Of Cash Payments | 00:00:00 | ||
| Schedule Of Cash Payments – More Complex | 00:00:00 | ||
| Production Schedule And Schedule Of Cash Payments | 00:00:00 | ||
| Cash Budget And Cash Receipts Schedule | 00:00:00 | ||
| Cash Budget, Cash Receipts Schedule, Cash Payments Schedule | 00:00:00 | ||
| Cash Receipts, Cash Payments, And Cash Budget | 00:00:00 | ||
| Required New Fund Formula – All Balance Sheet Accounts Change Relative To Sales | 00:00:00 | ||
| Required New Fund Formula – Current Assets And Liabilities Change Relative To Sales | 00:00:00 | ||
Related Courses
Are you interested in higher education?
All Rights Reserved