1
A1
A
Zolezzi Incorporated is preparing its cash budget for March. The budgeted beginning cash balance is $30,000. Budgeted cash receipts tota
B
C
D
E
F
G
Zolezzi Incorporated is preparing its cash budget for March. The budgeted beginning cash balance is $30,000. Budgeted cash
receipts total $106,000 and budgeted cash disbursements total $93,000. The desired ending cash balance is $45,000. The
company can borrow up to $80,000 at any time from a local bank, with interest not due until the following month.
H
I
2
Formula is below Required answer section
3 Required:
4
a) Prepare the company's cash budget for March in good form. Make sure to indicate what borrowing, if any, would be needed to
5
Supporting calculations
6
Cash balance, beginning
8
Total cash available
9
10
Excess (deficiency) of cash available over disbursements
11
12
Cash balance, ending
13
14 b) Now assume the total cash available is the same as in Part a) but the budgeted cash disbursements were $145,000. How much
Supporting calculations
15
16
Total cash available
17
18
Excess (deficiency) of cash available over disbursements
19
20
Cash Balance, Ending
21
22
Formula:
14 Sheet1 New...