Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Preparation of cash budget. Personal finance problem Sarn and Suzy Sizerran need to prepare a cash bucget for the last quarter of 2016 in order
Preparation of cash budget. Personal finance problem Sarn and Suzy Sizerran need to prepare a cash bucget 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 narmaly run 5.4% 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 month October through December 2015. b. Are there individual months that incur a detit? c. What is the cumulative cash surnlus ar dcficit by the end of December 2016? a. Complete the October 2016 cash budget below: (Round to the nearest doller.) X Data table Sam and Suzy Sizernan Personal Budget for the Period October-December 2016 October (Click on the icon localed on the low-right comer of the dela table below in order to copy its contents into a spreadsheet $4.871 $ Income Take home way Expenses Housing Percent 28.8% $ 5.456 $ Ulities Food Transportation Income Monthly take home pay Expenses Housing Utilities Food Transportation Medical donta Clothing for October & November Clothing for December Property taxes (November only) Appliances Personal Care Entertainment for October & November Enterlainment for December Sevings Other Excess in cash 8.9% $ 0.46 $ dira Dental 29.8% 5.4% 9.5% 6.9% 0.4% 3.1% $448 11.4% 1.5% 1.7% 5.6% $1,460 7.5% 5.4% 4.5% Clothing Property taxes Appliances Personal care 3.15 $ 11.4% $ 1.59 $ 1.7% $ 5.6% $ 7.5%$ 5.45% S 4.3% S Entertainment Savings Other Excess cash Tolal expenses Cash surplus or delicit) Print Done $ S S Cumulative cash surplus or delicit) S S
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started