Preparetion of cash budget Personal finance problem Sam and Suty Sceman need o p

ID: 1172692 • Letter: P

Question

Preparetion of cash budget Personal finance problem Sam and Suty Sceman need o prepare a cash budget for the lnt quarter of 2016 in order to make sure they can cover their espenditures during the period Sam and Suzy have been budgets for he past several years and have been abie to establish nformation here fcan be used to create ther fourth-quarler budget for 2016 A Prepare a quaerty cash budget for Sam and Suty covering the monts October through December 2016 c.wi at es ?nuative cash supus or Mct by the end of Decente 20167 a Complete the October 2016 cash budget below (Round to the nearest dolar speaitic percentages for most of heir cash outows These percentages are baned on their take home pay thutis, morly uniabes somaly nun 4r of moty tale-home pay) The here individual ncur a defior Data Tabie Sam and Sury Sunemar Personal Bdget for the Period October December 201 copy ts contents inio a spreadnet Monthly tae home pay 14937 301% Income Take home pay Expenser Food Traneportation Medicaidental Percent 301%s 47% $ Cletning for Decembe Property as (November y 433 112% Personal Can Entertanment for October&Nov; Entertanment for December 2.2% 55% 11 531 F00d 69% $ 31% Excess in cash

Explanation / Answer

Cash budget

Month

OCT

NOV

Dec

Monthly take home salary

4937

Expenses

7000

Housing

30.10%

1486.037

Utilities

4.70%

232.039

food

9.90%

488.763

transportation

6.90%

340.653

medical

0.60%

29.622

clothing for october and november

3.10%

153.047

clothing for december

433

property taxes- november only

11.20%

552.944

Appliances

1.30%

64.181

personal care

2.20%

108.614

entertainment for october and november

5.50%

271.535

entertainmet for december

1531

savings

7.50%

370.275

other

5.10%

251.787

excess in cash

4.30%

212.291

total disbursement of monthly take home

4561.788

6525.788

surplus or deficit for months

375.212

-1588.79

there is deficit in the month of december

C-

Cumulative cash surplus or deficit at the end of year

375.21+375.21-1588.79

-838.37