PLEASE HELP

0.75 points eBook Hint Print References Exercise 8-7 (Static) Cash Budget [LO8-8] Garden Depot is a retailer that provided the following budgeted cash flows for next year. 2nd Quarter $ 330,000 $ 230,000 Total cash receipts Total cash disbursements 1st Quarter $ 180,000 $ 260,000 The company's beginning cash balance for next year will be $20,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest 3rd Quarter $ 210,000 $ 220,000 Total financing Ending cash balance 4th Quarter $ 230,000 $ 240,000 Garden Depot Cash Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year

Gaden Depot is a retaler that provided the following budgeted cash flows for next yeat The comparys beginning cash balance for next year wal be $20,000. The company requires o nunimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may iepay any part of its loans at the end of any quarter interest payments. based on a quarterly interest rane of 3%, are due on any petincipal at the time it is repald Fod simplicity, assume interest is not compounded. Required: Prepare the compuny's cash budget for next year Note: Repayments, interest, and cash deficiencies should be indicated by a minus sign. Gaden Depot is a retaler that provided the following budgeted cash flows for next yeat The comparys beginning cash balance for next year wal be $20,000. The company requires o nunimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may iepay any part of its loans at the end of any quarter interest payments. based on a quarterly interest rane of 3%, are due on any petincipal at the time it is repald Fod simplicity, assume interest is not compounded. Required: Prepare the compuny's cash budget for next year Note: Repayments, interest, and cash deficiencies should be indicated by a minus sign