Garden Depot is a retailer that provided the following budgeted cash flows for next year:
tablest Quarter,nd Quarter,rd Quarter,th QuarterTotal cash receipts,$$$$Total cash disbursements,$$$$
The company's beginning cash balance for next year will be $ The company requires a minimum cash balance of $ 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 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.
tableGarden DepotCash Budgetst Quarter,nd Quarter,rd Quarter,th Quarter,YearBeginning cash balanceTotal cash receiptsTotal cash availableTotal cash disbursementsExcess deficiency of cash available over disbursementsFinancing:BorrowingsRepaymentsInterestTotal financingEnding cash balance,,,,,
