In: Accounting
Please create a monthly (or semester) cash flow budget that would seem appropriate for a college student.
A cash budget is basically a plan of estimated cash inflows and outflows during a specific period. It is a very useful planning tool, so that one can know his financial position for specifit time in future. I am uploading both image format and table format for youe convenience.
Student Name | ||||
Cash Budget | ||||
For the Four Months Ending December 31 | ||||
September | October | November | December | |
Estimated cash receipts from: | ||||
Part-time job | $ 800.00 | $ 800.00 | $ 800.00 | $ 800.00 |
Rent Deposit | $ 400.00 | |||
Pocket Money - Parents | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 |
Scholarship | $3,000.00 | |||
Total cash receipts | $ 1,000.00 | $1,000.00 | $4,000.00 | $ 1,400.00 |
Less estimated cash payments for: | ||||
Season football tickets | $ 90.00 | |||
Additional entertainment | $ 220.00 | $ 220.00 | $ 220.00 | $ 220.00 |
Tution | $ 3,500.00 | |||
Rent | $ 310.00 | $ 310.00 | $ 310.00 | $ 310.00 |
Food | $ 180.00 | $ 180.00 | $ 180.00 | $ 180.00 |
Rent Deposit | $ 400.00 | |||
Library | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 |
Books | $ 120.00 | $ 90.00 | ||
Total cash payments | $ 4,970.00 | $ 860.00 | $ 950.00 | $ 860.00 |
Cash increase (decrease) | $-3,970.00 | $ 140.00 | $3,050.00 | $ 540.00 |
Plus cash balance at beginning of month | $ 6,470.00 | $2,500.00 | $2,640.00 | $ 5,690.00 |
Cash balance at end of month | $ 2,500.00 | $2,640.00 | $5,690.00 | $ 6,230.00 |