example:

Your assignment is to create a monthly personal cash budget using Excel or any other spreadsheet software for your upcoming academic year, July 1, 2020 - June 30, 2021. Feel free to adapt in any way meaningful to you. Be sure to include all potential sources of income: Work income Scholarships/ grants Loans/Financial Aid Parental assistance . And all potential expenses: . Tuition room/board Books Food Rent Utilities Transportation Cell phone Internet Entertainment . Clothes Make it as realistic as you can, but as is the case with a budget in some cases you have to estimate. Remember that every month will not be the same. Some months you have other obligations (think about December and gifts) or maybe you have a family event coming up where you may need extra cash. Master Budgets Exhibit 22-16 shows the completed cash budget. Take time to carefully examine the document to ensure you understand the calculations. Pay special attention to the Total col- umn of the cash budget. As with the production budget and direct materials budget, you cannot simply add across each row to determine the total amounts because this is a sum- mary for the entire year. For example, the beginning cash balance for the year is the same as the beginning cash balance for the first quarter, and not the sum of the beginning balances for each quarter. Exhibit 22-16 Completed Cash Budget Fourth Quarter $ 32,995 318,000 350,995 $ Total 15,000 1,129,000 1,144,000