BudgetingCaseStudy

MATH 108X - Budgeting Case Study Excel File Cash Financial Aid Step 1. #3 Juan's Receipt Record #1 Juan's Background Story Check Other Income Semesterly Income 1st Semester Credit Card Paycheck Step 2. Financial Aid 500.00 1,000.00 Date Store Details Amount Expense Category Payment Method Debit Card Savings Withdrawal Other Income 50.00 50.00 Direct Deposit Step 3. 1,050.00 Payroll Dedu Cell Phone Semesterly Expenses 1st SemesterCombined Total Charitable Donations Housing 975.00 1,950.00 Eating Out Step 4. Tuition 2,150.00 4,300.00 Entertainment Textbooks 385.42 770.84 Gifts School Supplies 14.25 28.50 Groceries Step 5. Tithing (Special Income) 55.00 105.00 Housing 7,154.34 School Supplies Previous Savings Balance New Savings Balance Taxes 8,615.00 2,510.66 Textbooks Tithing Travel #4 Tuition Monthly Income January Miscellaneous Step 6. Paycheck 135.00 135.00 Savings Withdrawal 626.65 761.65 135.00 Monthly Expenses January New Monthly Goa Tithing 13.50 13.50 Charitable Donations 5.00 5.00 Taxes 31.04 15.00 Groceries 414.34 60.00 #5 Eating Out 34.01 0.00 Cell Phone 99.98 15.00 Travel 40.00 10.00 #2 Gifts 58.39 5.00 Entertainment 60.50 10.00 Miscellaneous 4.89 1.50 761.65 135.00 Cash Flow Summary January New Monthly Goal 0.00 0.00 uan's Final Savings Balance at the end of Two Semester 1,884.01 #6 Hover Mouse here to begin. 2-Semester Combined Total Juan just finished the first month of his first semester of college. He has decided it is time to take the advice he heard in his class and start his own personal budget! You will be helping him set a monthly goal that will apply for the 7 remaining months of the school year (there are 8 months in 2 semesters). What he typed in already... Juan collected the receipts from all his purchases since the start of the semester. Today he finally sat down to type his receipts into his budget. Your job is to help him finish. Juan arrived at school on January 3rd and did a lot of spending. As you can see in "Juan's Receipt Record," he bought groceries for $150.78, paid his housing contract for the semester at $975, paid his semester's tuition of $2150, and bought his textbooks for $385.42. He received a $500 scholarship that he will get every semester. He also received a $50 cash birthday gift from his parents. He paid tithing of $55 for the gift and scholarship money he received. On January 5th, Juan took his friend Jenny out for ice cream, which cost $4.88. He paid a $5.00 Fast Offering at church on January 6th. On the first day of school, January 7th, he forgot his lunch and bought lunch at the Crossroads Cafeteria, which cost $9.75. The next day he got his first paycheck for $67.50, which had his taxes of $15.52 taken out directly. He also put $20 worth of gas in his car and paid his tithing online for his paycheck ($6.75). The next day, January 9th, he purchased notebooks and pens from the Bookstore for $14.25. Later he returned to buy ear muffs for $4.89. Rexburg was colder than he expected! He also paid for lunch at the Crossroads Cafeteria with Jenny for $19.38. Friday, the 10th, he played lazer tag for $32. Saturday, the 11th, he bought weekly groceries for $75.32. That night he went to dinner and bowling with Jenny and some friends for $28.50. On the 18th he bought groceries again for $148.22. He also bought a gift for Jenny for $58.39 since he was out shopping already. Later he paid his monthly cell phone bill online for $99.98.He was happy to get his second paycheck of the usual $67.50 on the 23rd and recorded the $15.52 in taxes that was removed. What Juan needs help with... Now is where Step #2 begins. Help Juan finish typing in his last three receipts for January (shown to the left). He purchased "weekly groceries", put in his "regular fill-up for my car", and paid his tithing, or as he would write in the description: "blessings!" One final thing needed for Steps #3 and #4 ... Prior to the start of school, Juan saved up $8,615. He needs your help in coming up with a Monthly Spending Goal to be sure he doesn't run out of money before the end of the first year of school (8 months total). He needs a budget plan! New Monthly Goal Text box for Part #5 Explain your Monthly Budget Goals for Juan here... Okay so for the tithing my parents said if you give to the lord everything will work out so that is what I did in this budget by giving 13.50 to the lord and then if you help others you will be more likely to get help in return so I put 5.00 to help others we are using a friends house to shower so we only have to pay for half of the taxes with the groceries I am are planning on not eating out and eating healthier which is why to put more money into groceries cell phone we are trading in the iPhone for a flip phone that you only have to pay 15 bucks a month for travel we plan on staying close and really enjoying where we are I am planning to make homemade gifts cause they are cheaper and mean more to the person and we can but toilet paper at the dollar store Text box for Part #6 Type your reflection paragraph here...