Use the same template for Nov & Dec, thank you!

LIOTIVVOL. IUPIOTTI TIVOLI Score: 0 of 5 pts 9 of 15 (3 complete) HW Score: 10%, 10 of 100 pts :3 Question Help P4-11 (similar to) Preparation of cash budget. Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2020 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 identify the percentage of their income that they pay for most of for their cash outflows. These percentages are based on their take-home pay (e.g., monthly utilities normally run 5.1% of monthly take-home pay). The information here can be used to create their fourth-quarter budget for 2020. a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2020. b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2020? a. Complete the October 2020 cash budget below. (Round to the nearest dollar.) Sam and Suzy Sizeman Personal Budget for the Period October-December 2020 October Income Take-home pay Expenses Housing Utilities Food Transportation Medical Dental Clothing Property taxes Percent 29.9% $ 5.1% $ 10.3% $ 7.1% $ 0.4% $ 2.7% $ 11.9% 5 1.3% 5 2.1% $ 6.4% 5 7.4% 5 5.1% $ 4.2% Appliances Personal care Entertainment Savings Other Excess cash Total expenses Cash surplus or (deficit) Cumulative cash surplus or (deficit) $4,876 29.9% 5.1% 10.3% 7.1% 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 October & November Entertainment for December Savings Other Excess in cash 0.4% 2.7% $439 11.9% 1.3% 2.1% 6.4% $1,502 7.4% 5.1% 4.2%