At the beginning of the school year, Craig Kovar 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,900 Purchase season football tickets in September 190 Additional entertainment for each month 290 Pay fall semester tuition in September 4,600 Pay rent at the beginning of each month 700 Pay for food each month 640 Pay apartment deposit on September 2 (to be returned December 15) 700 Part-time job earnings each month (net of taxes) 1,400 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. 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. b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets? c. What are the budget implications for Craig Kovar? Craig can see that his present plan   sufficient cash. If Craig did not budget but went ahead with the original plan, he would be $fill in the blank 53   at the end of December, with no time left to adjust.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

At the beginning of the school year, Craig Kovar 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,900
Purchase season football tickets in September 190
Additional entertainment for each month 290
Pay fall semester tuition in September 4,600
Pay rent at the beginning of each month 700
Pay for food each month 640
Pay apartment deposit on September 2 (to be returned December 15) 700
Part-time job earnings each month (net of taxes) 1,400

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

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.

b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?

c. What are the budget implications for Craig Kovar?

Craig can see that his present plan   sufficient cash. If Craig did not budget but went ahead with the original plan, he would be $fill in the blank 53   at the end of December, with no time left to adjust.

Personal budget
At the beginning of the school year, Craig Kovar 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,900
Purchase season football tickets in September
190
Additional entertainment for each month
290
Pay fall semester tuition in September
4,600
Pay rent at the beginning of each month
700
Pay for food each month
640
Pay apartment deposit on September 2 (to be returned December 15)
700
Part-time job earnings each month (net of taxes)
1,400
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
Open spreadsheet
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.
Craig Kovar
Cash Budget
For the Four Months Ending December 31
September
October
November
December
Estimated cash receipts from:
Transcribed Image Text:Personal budget At the beginning of the school year, Craig Kovar 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,900 Purchase season football tickets in September 190 Additional entertainment for each month 290 Pay fall semester tuition in September 4,600 Pay rent at the beginning of each month 700 Pay for food each month 640 Pay apartment deposit on September 2 (to be returned December 15) 700 Part-time job earnings each month (net of taxes) 1,400 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet 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. Craig Kovar Cash Budget For the Four Months Ending December 31 September October November December Estimated cash receipts from:
September
October
November
December
Estimated cash receipts from:
Total cash receipts
Less estimated cash payments for:
Total cash payments
Cash increase (decrease)
Cash balance at end of month
$
b. Are the four monthly budgets that are presented prepared as static budgets or
exible budgets?
c. What are the budget implications for Craig Kovar?
Craig can see that his present plan
sufficient cash. If Craig did not budget but went ahead with the original plan, he would be $
at the end of December, with no time left to adjust.
Transcribed Image Text:September October November December Estimated cash receipts from: Total cash receipts Less estimated cash payments for: Total cash payments Cash increase (decrease) Cash balance at end of month $ b. Are the four monthly budgets that are presented prepared as static budgets or exible budgets? c. What are the budget implications for Craig Kovar? Craig can see that his present plan sufficient cash. If Craig did not budget but went ahead with the original plan, he would be $ at the end of December, with no time left to adjust.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education