Question

cash budget for the upcom Gaman Heath Center provides a variety of medical services. The company prepang Click the icono vow the ansactions) Requirement Prepare a contined cash budget for Camaro He Conte for the d ate with energcash balances) ply do not enter szero U s e Gammare Health Center Combined Cash Buget For the Months of the September July August September Cash Colections from services in July September, are proud to be 100.000 150.000 and $122.000 Beginning balance of cash Plus Cash collections Total cash available Loss Cash payments Ending cash balance before financing nanong Plus New Borowing Less Debt repayments Less Interest payments Ending cash balance Cashments for the upcoming tha t are p led to be $100.000 5106.000 in August 13 000 in September The cash balance as of the first day of the th i s projected to be $30.000 d. The health center has a policy than mantan a minimum cash balance of 526.000 The heathcorer has a line of credit with the local bank that wiows to borrow funds in months that it would therwise e um bance. If the company has more than mem balance at the end of any given mor the Excess funds to pay off any outstanding in of credit balco Cach month, Gaman Health Center pays hest on the por months in of credit ending balance. The state that the health center will pay fools incested to the pomerate However the interest paid during the budget period is expected to be 5 of the prior months in of credit ending balance the com m o n standing balance at the end of the prior month, then the center does not sve to pay anymoreAline of credit bo g stakon or paid off the furst day of the month As of the first day of Gammaro Hoan Coster ad not have a balance on its line of credit mer any number in the edt fields and then continue to the next question Done

Answer 1

E4 - x fc September C D E F G hampion of Gammaro Health Center Cash Budget for the third quarter July August September Quarter beginning balance of cash $ 39,000 $ 26,000 $37,660 $ 39,000 plus: cash collections $ 99,000 $ 152,000 $ 122,000 $ 373,000 total cash available $ 138,000 $ 178,000 $ 159,660 $ 412,000 less: cash payments $ 146,000 $ 106,000 $ 135,000 $ 387,000 ending cash balance before financing |-$ 8,000 $ 72,000 $ 24,660 $ 25,000 financing: plus: new borrowings $ 34,000 $ 1,340 $ 35,340 less: debt repayments $ 34,000 $ 34,000 less: interest payments $ 340 $ 340 ending cash balance $ 26,000 $ 37,660 $ 26,000 $ 26,000

for formulas and calculations, refer to the image below -

- X fi September В ДА І C D E F G ham noroof Gammaro Health Center Cash Budget for the third quarter July August 39000 =C14 99000 152000 =C5+C6 =D5+D6 146000 106000 =C7-C8 =D7-D8 September =D14 122000 =E5+E6 135000 =E7-E8 Quarter =C5 =SUM(C6:56) =F5+F6 =SUM(C8:E8) =F7-F8 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 = 26000-C9 =26000-E9 =SUM(C11:E11) =C11 =SUM(C12:E12) =C11*1% =SUM(C13:E13) =C9+C11-C12-C13 =D9+D11-D12-D13 =E9+E11-E12-E13 =F9+F11-F12-F13

In case you have any query, kindly ask in comments.