Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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 (eg, monthly utiles normally run 5.4% of monthly take-home pay). The information here can be used to create their fourth-quarter budget for 2020 Prepare a quarterly cash budget for Sam and Sury covering the months October through December 2020 b.As there individual months that incur a deficit? What is the cumulative cash surplus or deficit by the end of December 2007 Income Take-home pay Expenses Housing Utilities Food Transportation Medical/Dental Clothing Percent SA 29.8% $ 5.4% $ 10.1% $ 7.3% $ 0.5% $ 2.8% $ October 4 Property taxes Appliances Personal care Entertainment Savings Other Excess cash Total expenses Cash surplus or (deficit) Cumulative cash surplus or (deficit) 11.6% $ 1.4% $ 2.3% $ 6.4% $ 7.5% $ 4.8% $ 4.1% $ $ $ $ Data table 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 Print Done $4,918 29.8% 5.4% 10.1% 7.3% 0.5% 2.8% $441 11.6% 1.4% 2.3% 6.4% $1,542 7.5% 4.8% 4.1% k

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Entrepreneur's Growth Startup Handbook 7 Secrets To Venture Funding And Successful Growth

Authors: David N. Feldman

1st Edition

1118445651, 978-1118445655

More Books

Students also viewed these Finance questions