Question

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...

          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...

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 is30,000. Budgeted cash
receipts total 106,000 and budgeted cash disbursements total93,000. The desired ending cash balance is 45,000. The
company can borrow up to80,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...

Added by Lindsey G.

Question

Please give Ace some feedback