Sesrie Heath Center provides a variety of modical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur (1) (Click the loon to view the expected trantactiont.) Requirement Prepare a combined cash budget for Sesnie Hoalth Center for the thind quartor, With a column for each month and for the quarter lotal. (If an input fiold is not used in the table leave the input feet empty: do not ontar a zero. Use parentheses or a minus slon for negabive ending cash balances.) More info a. Cash collections ffom services in July. Awgute and 50 ptember, are projected to be $81,000,$157,000, and 5121,000 rospectively b. Cash poyments for the upconing thind quarher are peojected to be \$143.000 in Juy, 5107,000 in August, and $139,000 in Septeribet. e. The canh baiance as of the frit day of the third quater is projectod to be 535,000 d. The heath center has a polcy that it mult maitan a minimum cach balance of 522,000 The nealin center has a ine of credi was the local bank tuat alowe s to borre funds h mones that it would rot oinenise have fs minimum bwance If the compary has more than ak minimum balance at the end of any gven month, if wates the akceis funds to poy of any outatanding the of credi bwanoe. Each month. Seavie Haath Center pays vitarest on the prot morthis ine of credit ending balance. The actuat intorest rate that the heath certer wil pay floots since 4 is sed to the prime rate. Howeve, the inderest paid during the budgat pored is expected to be 3% of the phor morths the of credt ending balance (f the company did not here an colalanding balance at the end of the pror morith, then the beath contar doev not have lo pay any interoes). AI line of codat bairowngt are taken by the end of the monh (when the the cash balonce has nol met is ininimum bolance) of paid oft ty the end of the month (when the cosh balance ia wifficlent. As of the frat day of the third quarter, Sesnie Heath Center did not have a balance on is int of credt. Sesvie thoaith Center provides a variety of medical services. The conpary is preparing its cash budgot for the upooming thind quarter. The following transactions are expected to occur Click the ison to vies the expected transociors ) Requirement Propare a combined cash budget for Sesnie Health Centor for the thind quarioc, with a column for cach month and for the quartor totat: (If an ingut fold is not used in mene tabie leave the input feid ernpty: do not enter a zero. Use parentheses or a minus sign for negalve onding cash balancou.) Sesnie Health Center Combined Cash Budget For the Months of July through September Beginning balance of cash Plus: Cash collections Total cash available Less: Cash payments July350009100012600014300017,000 Financing: Plus: New borrowings Less: Debt repayments Less: Interest payments Ending cash balance Sesrie Heath Center provides a variety of modical services. The company is preparing its cash budget for the upcoming third quarter. The following transactions are expected to occur (1) (Click the loon to view the expected trantactiont.) Requirement Prepare a combined cash budget for Sesnie Hoalth Center for the thind quartor, With a column for each month and for the quarter lotal. (If an input fiold is not used in the table leave the input feet empty: do not ontar a zero. Use parentheses or a minus slon for negabive ending cash balances.) More info a. Cash collections ffom services in July. Awgute and 50 ptember, are projected to be $81,000,$157,000, and 5121,000 rospectively b. Cash poyments for the upconing thind quarher are peojected to be \$143.000 in Juy, 5107,000 in August, and $139,000 in Septeribet. e. The canh baiance as of the frit day of the third quater is projectod to be 535,000 d. The heath center has a polcy that it mult maitan a minimum cach balance of 522,000 The nealin center has a ine of credi was the local bank tuat alowe s to borre funds h mones that it would rot oinenise have fs minimum bwance If the compary has more than ak minimum balance at the end of any gven month, if wates the akceis funds to poy of any outatanding the of credi bwanoe. Each month. Seavie Haath Center pays vitarest on the prot morthis ine of credit ending balance. The actuat intorest rate that the heath certer wil pay floots since 4 is sed to the prime rate. Howeve, the inderest paid during the budgat pored is expected to be 3% of the phor morths the of credt ending balance (f the company did not here an colalanding balance at the end of the pror morith, then the beath contar doev not have lo pay any interoes). AI line of codat bairowngt are taken by the end of the monh (when the the cash balonce has nol met is ininimum bolance) of paid oft ty the end of the month (when the cosh balance ia wifficlent. As of the frat day of the third quarter, Sesnie Heath Center did not have a balance on is int of credt. Sesvie thoaith Center provides a variety of medical services. The conpary is preparing its cash budgot for the upooming thind quarter. The following transactions are expected to occur Click the ison to vies the expected transociors ) Requirement Propare a combined cash budget for Sesnie Health Centor for the thind quarioc, with a column for cach month and for the quartor totat: (If an ingut fold is not used in mene tabie leave the input feid ernpty: do not enter a zero. Use parentheses or a minus sign for negalve onding cash balancou.) Sesnie Health Center Combined Cash Budget For the Months of July through September Beginning balance of cash Plus: Cash collections Total cash available Less: Cash payments July350009100012600014300017,000 Financing: Plus: New borrowings Less: Debt repayments Less: Interest payments Ending cash balance