The first set of pictures is an example. The second set of pictures is what I need solve, please do all four parts (July, August, September, & Quarter)

Bentfield Health Center provides a variety of medical services. The company is preparing its cash budpet for the upcoming third quarter. The following transactions are expoctod to occur. (i) (Cick the icon to view the expected transactions.) Requirement Prepare a cornbined cash budget for Bentleld Healh Conter for the third quarter, with a column for each month and for the quarter lotal, (If an input foid is not used in the table leave the input feid emply, do eot ertor a zero. Une parentheses or a minus sign for negstive ending cash balances.) More info a. Cash collections from servioes in J.y. Augunt, and Seotember, avo proiected to be 597,000,5154,000, and 5123,000 respectively b. Cash payments for the upocening fird quarter ere proincted to be 314t,000 in July. $107,000 in A.put and $137.000 in Septembet. 6. The cash balance as of the firt day of the third quarter is projected to be $30.000. d. The heoth center has a pelicy that it mul maintain a minimum cath balance of $72.000 The heath center has a line of crest with the local bark hat alows it to borrow Kerds in marets that a woculd rot osentwie have its mirimum balance. If the conpary has more than ia minimum bedance at the end of any oven montry a uses the pricr morth's lire of credt ending balahoe. The achual interest rate that the healtheerter will poy foats since it is tied to the ofine rale. However, the irterest paid during the bubpet period is wapeched to be 2% of the pricr moretis ine of oredt ending balarce (I the conpary did not have in outatinding balance at the ind of the poor mooth then pe hoalth cecter dobs not hate to pay any interest). Al line of crest berrowirgs dere laken by the end of the moreh (whon the the cash balance has not med is minimum balance), or paid of by the end of the moeth (when the cash bulance is wuthodect As of the frat day of the torid quarter, Benafield Hleath Center did nothave a balance on ts line of creot. Monachino Health Conter provides a vatioly of medical sarvicot. Tho company is preparing its cash budget for the upcoming thind ouartor, The folowing transactions are expectod to occur: (i) (cick the icon to view the expectod transections) Requirement: Preparo a combined cash budget for Monechins Health Center for the thind quartoc, wth a column for each morith and for the quarter total. (If an input fiold is not used in the lable leave the input field amply: do not enter a roro, Usa parentheses or a minus sign for negative ending cach belarces: More info a. Cash collections from services in July, Auguat, and September, are projected to be $92,000,$158,000, and $122,000 rospectively. b. Cash payments for the upooming third quartoc are projected to be $140,000 in duly,$108,000 in Augrst, and $138,000 in September. c. The cash balance as of the firt doy of the thind quarter is propected to be $39,000. d. The health center has a pelicy that it must mairtain a minimum cash balance of $76,000. The heakh center has a line of credit with the local bank that abows it to borrow funds in months that it would not otherwise have its minimum balance. If the company has more than is minimum bolance at the end of any given month, it uses the excess funds to pay off any outstanding Ine of crodt balance. Each month, Monachino Health Center pays interest on the prioc month's line of credi ending balance. The achual interest rate that the heath certor will poy foots since it is ted to the prime rate. However, the interest paid during the budget period is expocted to be 2%6 of the prior month's line of cred? ending batance (d the company did not have an outstanding balance at the end of the prior month, then the healt center does not have to pay any interest). Al line of credit borrowings are taken by the end of the morth (when the the cash balance has not met its minimum balance), or pald of by the end of the month (when the cash balance is sulficient). As of the first day of the third quarter, Monachino Health Center did not have a balance on its ine of credit