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 fe 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) $11,000 Purchase season football tickets in September 140 Additional entertainment for each month 220 Pay fall semester tuition in September 5,700 Pay rent at the beginning of each month 530 Pay for food each month 480 530 Pay apartment deposit on September 2 (to be returned December 15) Part-time job earnings each month (net of taxes) 1,050 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. X Open spreadsheet

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
Please don't give image based answer..thanku
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:
$11,000
140
220
5,700
530
480
530
Pay apartment deposit on September 2 (to be returned December 15)
Part-time job earnings each month (net of taxes)
1,050
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.
X
Open spreadsheet
Cash balance, September 1 (from a summer job)
Purchase season football tickets in September
Additional entertainment for each month
Pay fall semester tuition in September
Pay rent at the beginning of each month
Pay for food each month.
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: $11,000 140 220 5,700 530 480 530 Pay apartment deposit on September 2 (to be returned December 15) Part-time job earnings each month (net of taxes) 1,050 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. X Open spreadsheet Cash balance, September 1 (from a summer job) Purchase season football tickets in September Additional entertainment for each month Pay fall semester tuition in September Pay rent at the beginning of each month Pay for food each month.
Estimated cash receipts from:
Part-time job
✓
Deposit
Craig Kovar
Cash Budget
For the Four Months Ending December 31
September
October
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 month
$
5
$
November
Cash balance at end of month
b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?
December
Transcribed Image Text:Estimated cash receipts from: Part-time job ✓ Deposit Craig Kovar Cash Budget For the Four Months Ending December 31 September October 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 month $ 5 $ November Cash balance at end of month b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets? December
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 2 images

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