I am not sure where to get the beginning cash balance from for this cash budget. the assignment is to create a master budget. I have prepared A sales budget, production budget, raw materials budget, direct labor budget, factory overhead budget, selling expense budget, and a general administrative expense budget.

Tell me what you ReVIEW View "File Homes Ineed Page Layout Formulas Data General - 17 - A A 29 Wrap Text B I U - H A = =3 2 2 Merge & Center Number For Alignment C D E G Nabal Manufacture cash budget July, August, Septriber 20 July August September Beginning cash Eplance 40000 Ade: Cashreceipts from customers Total gushlaps Table 40000 0 a lead Cash pux nights fal Pirest marshals Directlabor 12 Meriable overhead Sales comi zions Sales salaries! General amid abrain axp5. 12 Income Likes parable 16 Dividends 20:090 Interest in tank push 19 Taly Sorank August Swimm x 364 Purchase of equipment 22 Additional loan Mranitank 23 Repayment of loan to sank 24 Endleg cash balance 21 Loan balance, eastineith 26 27 28 OR 29. Beginning cash balance 30 Add: Caso receipts from Oustamers 31 Total cash available 32 Less: Cash payments for 33 Direct material. 34 Direct labor 85 Other soch expenses 36 Total cash payments Preliminary cash balance Lean activity: 39 Repayment of loan to bank 43 Ending cash balance Sales budget Production budget Pick baby andne