Question

SweeneySweeney Health Center provides a variety of medical services. The company is preparing its cash budget...

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

Cash collections from services in​ July, August, and​ September, are projected to be

$94,000​, $158,000​, and $127,000 respectively.

b.

Cash payments for the upcoming third quarter are projected to be

$149,000 in​ July, $103,000 in​ August, and $131,000 in September.

c.

The cash balance as of the first day of the third quarter is projected to be

$30,000.

d.

The health center has a policy that it must maintain a minimum cash balance of

$25,000.

The health center has a line of credit with the local bank that allows it to borrow funds in months that it would not otherwise have its minimum balance. If the company has more than its minimum balance at the end of any given​ month, it uses the excess funds to pay off any outstanding line of credit balance. Each​ month,Sweeney Health Center pays interest on the prior​ month's line of credit ending balance. The actual interest rate that the health center will pay floats since it is tied to the prime rate.​ However, the interest paid during the budget period is expected to be 3% of the prior​ month's line of credit ending balance​ (if the company did not have an outstanding balance at the end of the prior​ month, then the health center does not have to pay any​ interest). All line of credit borrowings are taken or paid off on the first day of the month. As of the first day of the third​ quarter, Sweeney Health Center did not have a balance on its line of credit.

Requirement

Prepare a combined cash budget for Sweeney Health Center for the third​ quarter, July-September, 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 parentheses or a minus sign for negative ending cash​ balances.)

Sweeney Health Center

Combined Cash Budget

For the Months of July through September

July

Beginning balance of cash

Plus: Cash collections

Total cash available

Less: Cash payments

Ending cash balance before financing

Financing:

Plus: New borrowings

Less: Debt repayments

Less: Interest payments

Ending cash balance

Homework Answers

Answer #1

Sweeney Health Center

Combined Cash Budget

For the Months of July through September

JULY AUGUST SEPTEMBER

Beginning balance of cash

30000 25000 28500

Plus: Cash collections

94000 158000 127000

Total cash available

124000 183000 155500

Less: Cash payments

-149000 -103000 -131000

Ending cash balance before financing

-25000 80000 24500

Financing:

Plus: New borrowings

50000 0 500

Less: Debt repayments

0 -50000 0

Less: Interest payments

0 -1500   [50000*3%] 0

Ending cash balance

25000 28500 25000

Minimum balance of 25000 is required at end of each month .so Total borrowings in July = 25000 negative balance+25000 desired ending balance =50000

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
BentfieldBentfield Health Center provides a variety of medical services. The company is preparing its cash budget...
BentfieldBentfield 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: LOADING... (Click the icon to view the expected transactions.) Requirement Prepare a combined cash budget for BentfieldBentfield 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....
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 62,500 $ 78,500 $ 49,500 Budgeted cash payments for Direct materials 16,460 13,740 14,060 Direct labor 4,340 3,660 3,740 Factory overhead 20,500 17,100 17,500 Sales are 25% cash and 75% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...
Dalton Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalton ​Manufacturing's operations: Current Assets as of December 31 (prior year): Cash. . . . . . . . . . . . . . . . . . . . . . . . . . .$4,460 Accounts receivable, net. . . . . . . . . . . $48,000 Inventory. . . . . . . ....
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 140,000 Inventory 66,500 Plant and equipment, net of depreciation 227,000 Total assets $ 508,500 Liabilities and Stockholders’ Equity Accounts payable $ 88,000 Common stock 311,000 Retained earnings 109,500 Total liabilities and stockholders’ equity $ 508,500 Exercise 8-12...
(N ONE)    Beech Corporation is a merchandising company that is preparing a master budget for...
(N ONE)    Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below:                              Beech Corporation                           Balance Sheet June 30 Assets Cash . . . . . . . . . . . . . . . . . . . . . . . . . .                               . . . $ 90,000 Accounts receivable . . ....
The Cash Budget ASNWER THE FOLLING USING EXCELL FORMAT 1.       The Right Target, Inc., a marketing...
The Cash Budget ASNWER THE FOLLING USING EXCELL FORMAT 1.       The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget for July to December 2017. The staff has projected the following cash collections and payments: Month Collections Payments Cash Sales Credit Sales Purchases Wages Miscellaneous Expenses July $10,000 $20,000 $15,000 $6000 $1,500 August $12,000 $24,000 $18,000 $7,200 $2,000 September $14,000 $28,000 $21,000 $8,400 $2,500 October $16,000 $32,000 $24,000 $9,600 $3,000 November $20,000 $40,000 $30,000...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash...
Built-Tight is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for product costs for the quarter follow. July August September Budgeted sales $ 59,500 $ 75,500 $ 52,500 Budgeted cash payments for Direct materials 17,060 14,340 14,660 Direct labor 4,940 4,260 4,340 Factory overhead 21,100 17,700 18,100 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes balances...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 200,000 $ 350,000 $ 230,000 $ 250,000 Total cash disbursements $ 274,000 $ 244,000 $ 234,000 $ 254,000 The company’s beginning cash balance for the upcoming fiscal year will be $24,000. The company requires a minimum cash balance of $10,000 and may...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management...
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 270,000 $ 420,000 $ 300,000 $ 320,000 Total cash disbursements $ 323,000 $ 293,000 $ 283,000 $ 303,000 The company’s beginning cash balance for the upcoming fiscal year will be $38,000. The company requires a minimum cash balance of $10,000 and may...
Your company has projected the following numbers for the third quarter of the year: Month Sales...
Your company has projected the following numbers for the third quarter of the year: Month Sales May $ 70,000 June $ 90,000 July $130,000 August $120,000 September $100,000 Labor & Raw Materials Purchases $75,000 $90,000 $95,000 $70,000 $60,000 Collections occur as follows: 15% pay within the month of sale, 65% pay during the month following the sale, and 20% pay in the second month following the sale. Payments for labor and raw materials occur in the month following the purchase....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT