Personal Budget At the beginning of the school year, Katherine Malloy decided to prepare a cash...

Free

90.2K

Verified Solution

Question

Accounting

Personal Budget At the beginning of the school year, KatherineMalloy decided to prepare a cash budget for the months ofSeptember, October, November, and December. The budget must planfor enough cash on December 31 to pay the spring semester tuition,which is the same as the fall tuition. The following informationrelates to the budget: Cash balance, September 1 (from a summerjob) $6,350 Purchase season football tickets in September 90Additional entertainment for each month 220 Pay fall semestertuition in September 3,400 Pay rent at the beginning of each month310 Pay for food each month 170 Pay apartment deposit on September2 (to be returned December 15) 400 Part-time job earnings eachmonth (net of taxes) 790 a. Prepare a cash budget for September,October, November, and December. Enter all amounts as positivevalues except an overall cash decrease which should be indicatedwith a minus sign. KATHERINE MALLOY Cash Budget For the Four MonthsEnding December 31 September October November December Estimatedcash receipts from: Part-time job $ $ $ $ Deposit Total cashreceipts $ $ $ $ Estimated cash payments for: Season footballtickets $ Additional entertainment $ $ $ Tuition Rent Food DepositTotal cash payments $ $ $ $ Overall cash increase (decrease) $ $ $$ Cash balance at beginning of month Cash balance at end of month $$ $ $

Answer & Explanation Solved by verified expert
3.6 Ratings (590 Votes)

KATHERINE MALLOY Cash Budget For the Four Months

Sr.No. Purticulers Sep Oct Nov Dec
A Estimated cash receipts from
a.Part-time job $790 $790 $790 $790
b.Deposit 0 0 0 $400
Total cash receipts(A) $790 $790 $790 $1190
B Estimated cash payments
a.Season football tickets $90 0 0 0
b.Additional entertainment $220 $220 $220 $220
c.Tuition $3400 0 0 0
d.Rent $310 $310 $310 $310
e.Food $170 $170 $170 $170
f.Deposit $400 0 0 0
Total cash payments (B) $4590 $700 $700 $700
C Overall cash increase (decrease) [A-B] ($3800) $90 $90 $490
D Cash balance at beginning of month $6350 $2550 $2640 $2730
E Cash balance at end of month [C-D] $2550 $2640 $2730 $3220

Note.

1.Present plan will not provide sufficient cash for payemnt of tution fees of $3400,there is short of $180[$3400-$3220),

2.Advice Katherine Malloy to plan accordigly to avoid the shortfall in budget.


Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students