Gammaro Health Center provides a variety of medical services. The company is preparing its cash budget...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Gammaro 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 Gammaro 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 parentheses or a minus sign for negative ending cash balances.) Gammaro 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 a. Cash collections from services in July, August, and September, are projected to be $93,000, $158,000, and $128,000 respectively. b. Cash payments for the upcoming third quarter are projected to be $149,000 in July, $109,000 in August, and $138,000 in September. c. The cash balance as of the first day of the third quarter is projected to be $38,000. d. The health center has a policy that it must maintain a minimum cash balance of $22,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, Gammaro 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 2% 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, Gammaro Health Center did not have a balance on its line of credit. Gammaro 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 Gammaro 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 parentheses or a minus sign for negative ending cash balances.) Gammaro 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 a. Cash collections from services in July, August, and September, are projected to be $93,000, $158,000, and $128,000 respectively. b. Cash payments for the upcoming third quarter are projected to be $149,000 in July, $109,000 in August, and $138,000 in September. c. The cash balance as of the first day of the third quarter is projected to be $38,000. d. The health center has a policy that it must maintain a minimum cash balance of $22,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, Gammaro 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 2% 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, Gammaro Health Center did not have a balance on its line of credit.
Expert Answer:
Answer rating: 100% (QA)
ANSWER Gammaro Health care center Combined cash budget For t... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
The St. Germaine Company is preparing its cash payments budget. The following items relate to cash payments the company anticipates making during the second quarter of the upcoming year. a. The...
-
Doreen Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable: Actual credit sales for March .................$120,000...
-
Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual...
-
Every real number is either a/an number or a/an_______ number.
-
Discuss some of the differences between the traditional approach to data processing and the database approach.
-
The nurse would expect the physician to prescribe epoetin alfa (Epogen) as the drug of choice a. For acute blood loss during surgery. b. To replace blood loss from traumatic injury. c. For treatment...
-
What are the precautions to be taken during use of domestic refrigerator?
-
Natural gas containing a mixture of methane ethane propane and butane is burned in a furnace with excess air. (a) One hundred k mol/h of a gas containing 94.4 mole% methane, 3.40% ethane 0.60%...
-
Consider an investor who purchases a Treasury inflation-indexed note with an original principal amount of $100,000, a 6.500 percent annual coupon rate (coupon is paid semiannually), and 10 years to...
-
You recently took 5,000 square feet of new space that hadn't been built out at all and put in a childcare facility. That project ended up costing $550,000. But, for this project, you have to demo the...
-
6. Show that if f: XY and g : Y Z are both onto then fg: Z- Z is onto. (Note this is function composition NOT multiplication)
-
All of the following are true of an effective system of corporate governance except: A. the system must be continually monitored especially with changes in management and the board. B. a single...
-
Which of the following best defines the concept of corporate governance? A. A system for monitoring managers activities, rewarding performance, and disciplining misbehavior. B. Corporate values and...
-
Given that Zeros directors all previously worked at the company, which of the following would you recommend for a more effective system of corporate governance? A. Ensure that assets are used...
-
What are the two traditional service line costing methods?
-
An analyst gathered the following information about a company and the market: Using the discounted cash flow (DCF) approach, the cost of retained earnings for the company is closest to: A. 15.7%. B....
-
3.1 Explain the Model-View-Controller architecture in detail, including the responsibilities of each component and how they interact with each other. 3.2 Describe the role of a controller in MVC,...
-
Prairie Outfitters, Inc., a retailer, accepts paymnent through credit cards. During August, credit card sales amounted to $12,000. The processor charges a 3% fee. Assuming that the credit card...
-
Can standard costs be used in job-order costing? In process costing? Explain.
-
What is a Pareto chart? What is its function?
-
Great Brands Inc. (GBI) is a retailer of consumer products. The company made two acquisitions in previous years to diversify its product lines. In 2008, GBI acquired a consumer electronics firm...
-
Why is it important to pay attention to cultural differences when interviewing a client?
-
What does the term "unauthorized practice of law" mean, and how does it limit your relationship with a client?
-
Why is it important to acknowledge how a client is feeling at the initial interview?
Study smarter with the SolutionInn App