Course curriculum

  • 02

    Managerial Accounting Overview

  • 03

    Budget Timing and Budget Committee

  • 04

    Sales Budget, Production Budget, & Materials Budget

    • 4 Sales Budget, Production Budget, & Materials Budget

      FREE PREVIEW
    • 210 Master budget Sales, Production & Raw materials

    • 210 Master Budged Sales Budget, Production Budget, & Materials Budget

    • Excel Download

    • Worksheet - 210 Sales Budget, Production Budget, & Materials Budget

    • Excel Download

    • Worksheet - 215 Master Budget, Raw Materials

    • Multiple choice 5

    • Accounting Comic

  • 05

    Direct Labor, Factory Overhead, Selling, & General and Administrative Budgets

  • 06

    Cash Budget

    • 6 Cash Budget

      FREE PREVIEW
    • 230 Master budget - Cash Budget

    • 230 Master Budged 3 Cash Budget

    • Excel Download

    • 230 Master budget, Cash Budget part 5

    • Multiple choice 7

    • Accounting Comic

    • Discussion Question MB 1 MB

  • 07

    Budgeted Cost of Goods Manufactured & Cost of Goods Sold

  • 08

    Budgeted Income Statement

    • 8 Budgeted Income Statement

      FREE PREVIEW
    • 250 Master budget - Income Statement

    • 250 Master Budged 5 Budgeted Income Statement

    • Excel Download

    • Worksheet - 250 Master budget, Income Statement

    • Multiple choice 9

    • Discussion Question MB 3

    • Accounting Comic

  • 09

    Budgeted Balance Sheet

    • 9 Budgeted Balance Sheet

      FREE PREVIEW
    • 260 Master budget - Balance Sheet

    • 260 Master Budget 6 Budgeted Balance Sheet

    • Excel Download

    • Worksheet - 260 Budgeted Balance Sheet

    • Multiple choice 10

    • Discussion Question MB 2

    • Accounting Comic

  • 10

    Verify The Budget

    • 10 Verify The Budget

      FREE PREVIEW
    • Excel Download

    • Worksheet - 270 Verify The Budget

    • Excel Download

    • Multiple choice 11

    • Short Calculation Problems

    • Discussion Question MB 1

    • Accounting Comic

  • 11

    Comprehensive Problem

    • 11 Comprehensive Problem

      FREE PREVIEW
    • Excel Worksheet to Download

    • 210 Sales Budget, Production Budget, & Materials Budget

    • 215 Materials Budget

    • 220 Direct Labor & Factory Overhead

    • 225 Selling & Administrative Budget

    • 230 Master budget, Cash Budget part 5

    • 240 Budgeted Cost of Goods Manufactured & Cost of Goods Sold

    • 250 Budgeted Income Statement

    • 260 Budgeted Balance Sheet

    • 270 Verify The Budgets

    • Multiple choice 12

    • Accounting Comic

  • 12

    Finance Perspective - Forecasting & Budgeting

    • 405 Forecasting Objectives

    • 410 Pro Forma Income Statement

    • 415 Cash Budget

    • 420 Pro Forma Balance Sheet

    • 425 Percent of Sales Method

  • 13

    Finance Perspective - Practice Probs - Forecasting & Budgeting

    • 414 Sales Projection – Multiple Scenarios

    • 416 Estimated Net Sales

    • 418 Projected Units to be Produced

    • 423 Calculate Cost of Goods Sold Using FIFO & LIFO

    • 424 Calculate Cost of Ending Inventory LIFO & FIFO

    • 427 Schedule of Cash Receipts

    • 428 Schedule of Cash Receipts – Multiple Scenarios

    • 430 Schedule of Cash Payments

    • 431 Schedule of Cash Payments – More Complex

    • 432 Production Schedule & Schedule of Cash Payments

    • 434 Cash Budget & Cash Receipts Schedule

    • 435 Cash Budget, Cash Receipts Schedule, Cash Payments Schedule

    • 437 Required New Fund Formula All Balance Sheet Accounts Change Relative to Sales

    • 438 Required New Fund Formula – Current Assets & Liabilities Change Relative to Sales

  • 14

    Finance Perspective - Excel Probs - Forecasting & Budgeting

    • 414 Sales Projection – Multiple Scenarios

    • 416 Estimated Net Sales

    • 418 Projected Units to be Produced

    • 421 Calculate Cost of Goods Sold Using FIFO

    • 423 Calculate Cost of Goods Sold Using LIFO & FIFO

    • 424 Calculate Cost of Ending Inventory LIFO & FIFO

    • 427 Schedule of Cash Receipts

    • 428 Schedule of Cash Receipts – Multiple Scenarios

    • 430 Schedule of Cash Payments

    • 431 Schedule of Cash Payments – More Complex

    • 432 Production Schedule & Schedule of Cash Payments

    • 434 Cash Budget & Cash Receipts Schedule

    • 435 Cash Budget, Cash Receipts Schedule, Cash Payments Schedule

    • 436 Cash Receipts, Cash Payments, & Cash Budget

    • 437 Required New Fund Formula – All Balance Sheet Accounts Change Relative to Sales

    • 438 Required New Fund Formula – Current Assets & Liabilities Change Relative to Sales

Pricing options

Explain how different pricing options might be valuable to different segments of your audience.

Description

Master budget construction, including demonstration problems, excel worksheets, practice test questions, discussion questions, and a comprehensive problem we work together using Excel in a step by step format.

The course will provide a managerial accounting overview, comparing managerial accounting and financial accounting, and providing essential managerial accounting tools we will need in the budgeting process.

We will discuss methods of budget timing and the pros and cons of each technique.

The course will discuss the characteristics and functions of the budget committee.

We will discuss the components of a master budget and break it out into its parts, listing the order that those components need to be completed in.

The course will discuss how to put together a sales budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a production budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a materials budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a direct labor budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a factory overhead budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a general and administrative budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a cash budget and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a budgeted cost of goods manufactured statement and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a budgeted cost of goods sold statement and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will discuss how to put together a budgeted income statement and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

The course will discuss how to put together a budgeted balance sheet and will also walk through a step by step process using preformatted Excel worksheets for learners to follow along with.

We will also go over a comprehensive problem in Excel so we can see all the components of the master budget and work through them in one place.

Who this course is for:
  • Accounting students
  • Business owners
  • Anyone who whats to learn accounting

Robert (Bob) Steele CPA CGMA CPI MStax

Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.

Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelor’s Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).

Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.

In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and How Too, and has developed supplemental resources including a Facebook Page, Twitter Page, and Podcasts that can be found on I-tunes, Stitcher, or Soundcloud. Mr. Steele’s teaching philosophy is to make content applicable, understandable, and accessible.

Adult learners are looking for application when they learn new skills. In other words, learners want to be able to apply skills in the real world to help their lives. Mr. Steele’s formal accounting education, practical work experience, and substantial teaching experience allow him to create a curriculum that combines traditional accounting education with practical knowledge and application. He accomplishes the goals of making accounting useful and applicable by combining theory with real-world software like Excel and QuickBooks.

Many courses teach QuickBooks data entry or Excel functions but are not providing the real value learners want. Real value is a result of learning technical skills like applications, in conjunction with specific goals, like accounting goals, including being able to interpret the performance of a business.

Mr. Steele makes knowledge understandable by breaking down complex concepts into smaller units with specific objectives and using step by step learning processes to understand each unit. Many accounting textbooks cram way too much information into a course, making it impossible to understand any unit fully. By breaking the content down into digestible chunks, we can move forward much faster.

Mr. Steele also makes use of color association in both presentations and Excel worksheets, a learning tool often overlooked in the accounting field, but one that can vastly improve the speed and comprehension of learning accounting concepts.

The material is also made understandable through the application of concepts learned. Courses will typically demonstrate the accounting concepts and then provide an Excel worksheet or practice problems to work through the concepts covered. The practice problems will be accompanied by an instructional video to work through the problem in step by step format. Excel worksheets will be preformatted, usually including an answer tab that shows the completed problem, and a practice tab where learners can complete the problem along with a step by step presentation video.

Mr. Steele makes learning accounting accessible by making use of technology and partnering with teaching platforms that have a vision of spreading knowledge.