Solution:
Cash Budget - Crane company | |||
Particulars | October | November | Total |
Beginning cash balance | $16,000.00 | $39,637.00 | $16,000.00 |
Add: Budgeted cash receipts | $63,000.00 | $95,000.00 | $158,000.00 |
Total Cash Available | $79,000.00 | $134,637.00 | $174,000.00 |
Less: Cash disbursement | $45,000.00 | $76,000.00 | $121,000.00 |
Excess (deficiency) of cash available over disbursements | $34,000.00 | $58,637.00 | $53,000.00 |
Financing: | |||
Borrowings | $5,637.00 | $0.00 | $5,637.00 |
Repayments | $0.00 | -$5,637.00 | -$5,637.00 |
Interest | $0.00 | -$113.00 | -$113.00 |
Total Financing | $5,637.00 | -$5,750.00 | -$113.00 |
Ending cash balance | $39,637.00 | $52,887.00 | $52,887.00 |
Ending cash balance for november = $52,887
Crane Company is preparing a cash summary budget using the data below. They have already prepared...
Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash $63000 $95000 Receipts Expected Cash Payments $45000 $76000 Management always wants to maintain a $41,492 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...
Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $38,593 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...
Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $41,920 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...
Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $38,714 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...
Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $41,196 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...
Question 1 2 pts Crane Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $39,343 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow...
Sweeney Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Sweeney Health Center for the third quarter, with a column for each month and for the quarter total. (If a box is not used in the table leave the box empty; do not enter a zero. Use...
Sesnie Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur: (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Sesnie Health Center for the third quarter, with a column for each month and for the quarter total. (If a box is not used in the table leave the box empty; do not enter a zero. Use...
Alderman Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to our (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Alderman Health Center for the third quarter, with a column for each month and for the quarter total (a box is not used in the table leave the box empty, do not enter a zero. Use parentheses...
Alderman Health Center provides a variety of medical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for Alderman Health Center for the third quarter, with a column for each month and for the quarter total (a box is not used in the table leave the box empty, do not enter a zero Use parentheses...