Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

will upvote Cash collections from services in July, August, and September, are projected to be $91,000, $155,000, and $123,000 respectively. Cash payments for the upcoming

will upvote
image text in transcribed
  1. Cash collections from services in July, August, and September, are projected to be $91,000, $155,000, and $123,000 respectively.
  2. Cash payments for the upcoming third quarter are projected to be $148,000 in July, $102,000 in August, and $132,000 in September.
  3. The cash balance as of the first day of the third quarter is projected to be $35.000.
  4. The health center has a policy that it must maintain a minimum cash balance of $27.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. Sesnie Health Center Days 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 1% 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 by the end of the month when the the cash balance has not met its minimum balance), or paid off by the end of the month (when the cash balance is sufficient). As of the first day of the third quarter, Sesnie Health Center did not have a balance on its line of credit.

image text in transcribed
Sescie Healsh Center provides a variety of medical services. The compary is preparing ts cash budoet lor the upooming third quarter The following transections are expected to oceur: [Cick the isan to view the expected rantactions.] Regulrement pasentheses or a minus sign for negative ending cash balances.) More info a. Cash collections trom services in Juy, August, and September, are projected to be $91,000,$155,000, and $123,000 respectivehy. b. Cash payments for the upocming third quarter are projected to be $148,000 in duh. $102,000 in Augut, and $132,000 in Sectember, c. The cash belasice at of the frst dary of the third euacter is projected to be $35,000. d. The heath cenler has a policy Fat it must maintain a minimum cash balance of $27,000. The hewth center has a ine of credit with the local bark that allows if to borrow funds in months that if would not otherwise have its mirimum belance. If the compary has more fan its mirimum balance at the end of ary piven month, th uses the excess funds to pay of afy eustanding Ine of crecit balance. Each monch, Sesnit thewth Cerfer paya inarest on the prior month's line of tredof esding baiance. The actual inserest rase that the heath center will pay foucs since it is thed bo the prime fate. However, the interest paid during the budget periad is expected is be the of the priot moriti fine of credt ending balance (f the cempany did not have an cutstanding bwance at the end of the prist month. then the hewth center does not have to pay any interest, Aa line of credi borrowings are taken by the end of the mosth fwhen the the cash balance has not met is minimum balancek or pad of by the end of the month (when the cash batance is waticient) As of the frit day of the thind qaarter. Sesnie Heath Ceriler did not have os balance on ins line of credit. (i) (Click the ison to vew the expected transactions.) Pequirement parritheses or a minus sign for negative ending cants balances.) More info a. Caph colections from services in July. Augut, and Septembec, were projected to be 591,000,5156,000, and $129,000 respectively. b. Casi poyments for the upcoming third quanter are projected to be 5148.000 in July, 5102,000 in Auguat, and 5172.000 in Seple-bee. c. The caih balance as of the first tay of the third quarier in projected to be 535,000 . d. The heath center hat a polcy that it must maimtsin a minimem cash balance of 327,000 . hare its minimum balance. If the company tas more than its minimum belance at the exd of ayr given month it uacs the baisnce (A the company ced met have an oustinding bwiance at the end of the proc eonth then the heath center does not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions