Question

10. Preparing a cash budget Brock and Sam started to create a budget (based on last year's income and expense statement) but got stuck. They know that you have learned how to create budgets and are asking for your help. They would like you to input the correct values for the first three months of next year. Income and Expense Statement Name(s): Brock and Sam Wilson For the year ending: As of December 31 Dollars Income Wages and salaries Name: Brock Wilson $20,500 Nam: Sam Wilson 18,450 Bonuses and commissions Brock's bonus 2,050 (1) Total Income: $41,000 Expenses Housing $9,456 Utilities Central Maine Power 1,056 T-Mobile 528 Food Groceries 1,896 Transportation Auto loan 4,320 Public transportation 4,200 Insurance 1,576 Тахes 9,738 Fun money Cruise to Mexico 3,500 Parents' loan 1,225 (2) Total Expenses: $37,495

Answer 1

Three month cash Names: Brock and for Three months - Budget [By month] sum wilson Ending march 31 march Total for Three Januo February months 1281 3843 128) 128) 1153 3459 Brock's salary samt salary 1153 1153 2434 7302 2434 Total Income 2434 expensy 788 788 2364 Rent 788 utilities: Central maine power 88 44 44 158 158 264 132 GAY 1080 1050 158 T mobile food Automobile public transportattoo 360 360 360 350 350 350 १५ 394 I 1oz 102 306 102 ô 292 292 876 292 Insurance parent loan fun money Cash surplus cumulative surplus (deficit) 362 252 (142) 252 504 362

15375 Brock That Income per month - $ 12.81 Income per month - 13838 -4 1153 - Rent per month = 9456 -8788 12- h central maine power per month = 1056 -888 - Tmobile per month - 528 . 144 food per month = 1896 -$158 u 320 + 40- - Transportation cost per month Cautomobile loan ] Insurance cost for quarter a 1576 - $394 1225 parents loan = $ 102 12 fun money = 3500 24892 12 Public transporatation - 4200 - $50