At the beginning of the 2012 school year, Candace Thompson decided to prepare a cash budget for
Question:
At the beginning of the 2012 school year, Candace Thompson decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:
Cash balance, September 1 (from a summer job) . . . . . . . . . . . . . . . . . . . . . $6,500
Purchase season football tickets in September. . . . . . . . . . . . . . . . . . . . . . . 120
Additional entertainment for each month . . . . . . . . . . . . . . . . . . . . . . . . . . . 270
Pay fall semester tuition in September . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4,000
Pay rent at the beginning of each month . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250
Pay for food each month . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175
Pay apartment deposit on September 2 (to be returned Dec. 15) . . . . . . 500
Part-time job earnings each month (net of taxes) . . . . . . . . . . . . . . . . . . . . 1,000
a. Prepare a cash budget for September, October, November, and December.
b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?
c. What are the budget implications for Candace Thompson?
A cash budget is an estimation of the cash flows for a business over a specific period of time. These cash inflows and outflows include revenues collected, expenses paid, and loans receipts and payment. Its primary purpose is to provide the...
Step by Step Answer:
Financial and Managerial Accounting Using Excel for Success
ISBN: 978-1111993979
1st edition
Authors: James Reeve, Carl S. Warren, Jonathan Duchac