Document Type

Peer-Reviewed Article

Publication Date



The purpose of this article is to demonstrate how to use a template to teach the budgeting process and how to use the same template to do a sensitivity analysis once the budget process is completed. The template can be used as-is by non-accounting majors. They just have to fill in all of their assumptions by replacing the red numbers. The template can be locked so that students cannot modify the formulas by mistake. Simply protect the worksheet (Review tab > Protect Sheet) and students will be able to only change the assumptions. Accounting majors are shown how to build their own template by using formulas. This requires a good understanding of Excel and of the budgeting process. Once the template is constructed, making modifications to the assumptions is very easy and students can see the results immediately.

Separate Budgets Sheets.xlsx (43 kB)
Separate Budget Sheets

Previous Versions

Apr 26 2013



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.