Question

In: Accounting

Personal Budget At the beginning of the school year, Priscilla Wescott decided to prepare a cash...

Personal Budget

At the beginning of the school year, Priscilla Wescott 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,000
Purchase season football tickets in September 150
Additional entertainment for each month 250
Pay fall semester tuition in September 3,500
Pay rent at the beginning of each month 450
Pay for food each month 400
Pay apartment deposit on September 2 (to be returned December 15) 450
Part-time job earnings each month (net of taxes) 1,300

a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except cash decrease which should be indicated with a minus sign.

Priscilla Wescott
Cash Budget
For the Four Months Ending December 31
September October November December
Estimated cash receipts from:
Part-time job $ $ $ $
Deposit
Total cash receipts $ $ $ $
Less estimated cash payments for:
Season football tickets $
Additional entertainment $ $ $
Tuition
Rent
Food
Deposit
Total cash payments $ $ $ $
Cash increase (decrease) $ $ $ $
Plus cash balance at beginning of the month
Cash balance at end of month $ $ $ $

Solutions

Expert Solution


Related Solutions

Personal Budget At the beginning of the school year, Priscilla Wescott decided to prepare a cash...
Personal Budget At the beginning of the school year, Priscilla Wescott 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) $9,150 Purchase season football tickets in September 120 Additional entertainment for each month 320 Pay...
Personal Budget At the beginning of the school year, Priscilla Wescott decided to prepare a cash...
Personal Budget At the beginning of the school year, Priscilla Wescott 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) $8,140 Purchase season football tickets in September 110 Additional entertainment for each month 280 Pay...
Personal Budget At the beginning of the school year, Priscilla Wescott decided to prepare a cash...
Personal Budget At the beginning of the school year, Priscilla Wescott 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,690 Purchase season football tickets in September 90 Additional entertainment for each month 230 Pay...
Personal Budget At the beginning of the school year, Priscilla Wescott decided to prepare a cash...
Personal Budget At the beginning of the school year, Priscilla Wescott 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) $8,800 Purchase season football tickets in September 120 Additional entertainment for each month 310 Pay...
Personal Budget At the beginning of the school year, Priscilla Wescott decided to prepare a cash...
Personal Budget At the beginning of the school year, Priscilla Wescott 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,000 Purchase season football tickets in September 150 Additional entertainment for each month 250 Pay...
At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for...
At the beginning of the school year, Priscilla Wescott 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,680 Purchase season football tickets in September 90 Additional entertainment for each month 230 Pay fall semester...
At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for...
At the beginning of the school year, Priscilla Wescott 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,680 Purchase season football tickets in September 90 Additional entertainment for each month 230 Pay fall semester...
At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for...
At the beginning of the school year, Priscilla Wescott 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) $7,200 Purchase season football tickets in September 100 Additional entertainment for each month 250 Pay fall semester...
At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for...
At the beginning of the school year, Priscilla Wescott 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,000 Purchase season football tickets in September........................................... 150 Additional entertainment for each month................................................... 250 Pay fall...
At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for...
At the beginning of the school year, Priscilla Wescott 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) $8,260 Purchase season football tickets in September 110 Additional entertainment for each month 290 Pay fall semester...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT