July | August | September | |
Beginning balance of Cash | $ 32,000 | $ 23,000 | $ 33,220 |
Plus: Cash Collections | $ 95,000 | $ 1,56,000 | $ 1,20,000 |
Total Cash Available | $ 1,27,000 | $ 1,79,000 | $ 1,53,220 |
Less : Cash Payments | $ 1,43,000 | $ 1,06,000 | $ 1,38,000 |
Ending Cash balance before financing | $ -16,000 | $ 73,000 | $ 15,220 |
Financing | |||
Plus: New borrowings | $ 39,000 | $ 7,780 | |
Less: Debt repayments | $ 39,000 | ||
Less: Interest repayments | $ 780 | ||
Ending Cash balance | $ 23,000 | $ 33,220 | $ 23,000 |
Borrowings for July = $23000+$16000 = $39000
Interest payments in August = $39000 x 2% = $780
Borrowings for Sep = $23000-$15220 = $7780
I
need help finding the new borrowings.
Score: 0 of 4 pts 7 of 98.com HW Score: 78.99% E9-30A (similar to) BQ LaChut 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 cour (Click the icon to view the expected transactions) Requirement Prepare a combined cash budget for Lachut Health Center for the third quarter with a column for each month and for...
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...
a. Cash collections from services in July, August, and September, are projected to be $96,000, $156,000, and $120,000 respectively. b. Cash payments for the upcoming third quarter are projected to be $140,000 in July, $104,000 in August, and $137,000 in September. c. The cash balance as of the first day of the third quarter is projected to be $31,000. d. The health center has a policy that it must maintain a minimum cash balance of $24,000. The health center has...
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 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...
Monachino 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 Monachino 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...
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. A (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....
cash budget for the upcom Gaman Heath Center provides a variety of medical services. The company prepang Click the icono vow the ansactions) Requirement Prepare a contined cash budget for Camaro He Conte for the d ate with energcash balances) ply do not enter szero U s e Gammare Health Center Combined Cash Buget For the Months of the September July August September Cash Colections from services in July September, are proud to be 100.000 150.000 and $122.000 Beginning balance...
3 of 4 (2 complete) HW Score: 5.71%, 3.43 of 60 pts Score: 0 of 10 pts CP22-57 Continuing Problem (similar to) Question Help Assume Dean Consulting began January with $14,000 cash. Management forecasts that cash receipts from credit customers will be $56,000 in January and $60,000 in February. Projected cash payments include equipment purchases (522,000 in January and $45,000 in February) and selling and administrative experises $10,000 each month). Dean's bank requires a $20,000 minimum balance in the firm's...