A B C
Preparation of cash budget. Personal finance problem Sam and Suzy 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 Suzy have been preparing budgets for the past several years and have been able to establish specific percentages for most of their cash outflows. These percentages are based on their take-home pay (that is, monthly utilities normally run 4.6% of monthly take-home pay). The information here can be used to create their fourth-quarter budget for 2016. a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2016, b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2016? a. Complete the October 2016 cash budget below. (Round to the nearest dollar) Sam and Suzy Sizeman Personal Budget for the Period October-December 2016 October Income Take home pay S Expenses Percent Housing 30.3% 5 Uuties 4.6% S Food 10.1% S Transportation 6.8% 5 - Enter any number in the edit fields and then click Check Answer. 4 parts . ff Preparation of cash budget. Personal finance problem Sam and Suzy Sizeman need to prepare a cash budget for the they can cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past several years percentages for most of their cash outflows. These percentages are based on their take-home pay (that is., monthly utilities pay). The information here can be used to create their fourth-quarter budget for 2016. a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2016. b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2016? Transportation 6.8% $ Medical/Dental 0.5% $ Clothing 2.6% $ Property taxes 11.5% $ Appliances 1.5% S y Personal care 2.2% $ 54 Entertainment 6.4% $ 50 Savings 7.99 $ ating Other 5.1% $ Excess cash 4.2% $ Total expenses Cash surplus or (deficit) Cumulative cash surplus or (deficit) at $2 280,0% Enter any number in the edit fields and then click Check Answer. 300 parts Clear All remaining $ $ $ X arte ve Illy (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) $4,934 Income Monthly take-home pay Expenses Housing Utilities Food Transportation Medical/dental Clothing for October & November Clothing for December Property taxes (November only) Appliances Personal Care Entertainment for Oct&ber & November Entertainment for December Savings Other Excess in cash 30.3% 4.6% 10.1% 6.8% 0.5% 2.6% $430 11.5% 1.5% 2.2% 6.4% $1,534 7.9% 5.1% 4.2% Jefil ds Print Done Clear All Check Ans