Question

Homework: Homework Set4 HW Score: 76.58%, 38.29 of 50 pt Score: 0 of 2 pts 5 of 25 (22 complete) P4-10 (similar to Question Help Preparation of cash budget. Personal finance problem Sam and Sury Sizeman need to prepare a cash budget for the last quarter of 2016 in order to make sure they can cover their expenditures during the period. Sam and Sury have been preparing budgets for the past several years and have been able to establish specific percentages for most of their cash outtows. These percentages are based on their take home pay (that is., monthly utbises normaly un 5.4% af monthly take-home pay). The infommation here can be used to creatn their fourth -quarter budget for 2016 a. Prepare a quarterly cash budget for Sam and Sury covering the months October through December 2016 b. Are there individual months that incur a defici? e. What is the cumulative cash surplus or deficit by the end of December 20167 a. Complete the October 2016 cash budget below: (Round to the nearest dollar.) Sam and Sury Sizeman Personal Budget for the Period October-December 2016 874 Take home pay 30.4% $ 54% s 9.5% 1482 Food Enter any number in the edit fields and then click Check Answer Final Check Clear Al Practice with similar questions MacBook Air 20 5 6 3 4 2 Data Table ick on the icon located on the top-right corner of the data table below in order to py its contente into a spreadsheet.) Income Monthly take-home pay Expenses Housing Utilities Food Transportation Medical/dental $4,874 30.4% 5.4% 9.5% 6.7% 0.5% 2.6% $447 Clothing for October & November Clothing for December Property taxes (November only) 11.2% Appliances Personal Care Entertainment for October & November 1.4% 2.1% 5.7% Entertainment for December Savings Other Excess in cash $1,537 7.4% 4.8% 4.8% PrintDone Fin Practice with similar questions 27 MacBook Ai

Answer 1

New Microsoft Office Excel Worksheet Microsoft Excel HomeInsertPage LayoutFormulas Data Review View s Cut E AutoSum General Copy Paste B 1 프-ER »- , 涅涅主Merge & Center. S , % , 108 Conditional Format -Cell- Insert Delete Format Formatting as Table Styles Sort & FilterSelect Find & Format Painter 2 Clear Cells Alignment Number Styles Editing 373 374 375 376 377 378 379 net sale p 60000-198504 0149.6 cash budget Monthly October November December Monthly take home pay 4874 4874 4874 4874 housine utilities 3040% 1481.696 1481 696 1481.696 5.40% 263.196 263.196 263.196 950% 463 03 463.03 6.70% 326.558 326.558 0 50% 2.60% 126.724 126.724 381 463.03 326.558 24.37 medical clothing for october and november clothing for december property taxes- november only appliances personal care entertainment for october and november entertainment for december savine 24.37 24.37 447 447 545.888 387 140% 68.236 68 236 2.10% 102.354 102.354 102.354 570% 277.818 277 818 68.236 390 1537 740% 360.676 360 676 360.676 4.80% 233.952 233.952 233.952 480% 233.952 391 excess in cash total expenses cash surplus or deficit cumulative cash surplus or deficit 394 395 396 397 398 3962.562 4274.498 5308.068 911.438 599.502-434.068 11.438 1510.94 1076.872 decmebr is the month in which there is cash deficit cumulative cash 1076.872 4MSheet11 Sheet12 Sheet13 Sheet14Sheet15Sheet16 Sheet17 Sheet18 8:14 AM

cash budget
Monthly		October	November	December
Income
Monthly take home pay	4874	4874	4874	4874
expenses
housing	30.40%	1481.696	1481.696	1481.696
utilities	5.40%	263.196	263.196	263.196
food	9.50%	463.03	463.03	463.03
transportation	6.70%	326.558	326.558	326.558
medical	0.50%	24.37	24.37	24.37
clothing for October and November	2.60%	126.724	126.724
clothing for December	447			447
property taxes- November only	11.20%		545.888
appliances	1.40%	68.236	68.236	68.236
personal care	2.10%	102.354	102.354	102.354
entertainment for October and November	5.70%	277.818	277.818
entertainment for December	1537			1537
saving	7.40%	360.676	360.676	360.676
other	4.80%	233.952	233.952	233.952
excess in cash	4.80%	233.952
total expenses		3962.562	4274.498	5308.068
cash surplus or deficit		911.438	599.502	-434.068
cumulative cash surplus or deficit		911.438	1510.94	1076.872
b-	December is the month in which there is cash deficit
c-	cumulative cash surplus at December	1076.872