I am having a hard time with the following problem. Can you please help.

Thank You!

Income-tax payments are made at the beginning of each calendar quarter based on the income of the prior quarter. Alpha-Tech is subject to an income-tax rate of 40 percent Alpha-Tech's operating income for the first quarter of 20x5 is projected to be The company pays 100 percent of the estimated tax payment. Alpha-Tech maintains a minimum cash balance of $540,000. Ifthe cash balance is less than $540,000 at the end of each month, the company borrows amounts necessary to maintain this balance. All amounts borrowed are repaid out of the subsequent positive cash flow. The projected April 1, 20x5, opening balance is $540,000. Alpha-Tech has no short-term debt as of April 1, 20x5_ Alpha-Tech uses a calendar year for both financial reporting and tax purposes. Required: 1. Prepare a cash budget for Alpha-Tech by month for the second quarter of 20x5_ For simplicity, ignore any interest expense associated with borrowing. (Negative amounts should be indicated by a minus sign.) Cash Budget For the Second Quarter of 20x5 A ril June Beginning balance Collections: February sales March sales April sales May sales Total receipts Total cash available Disbursements: Accounts payable Wages General and administrative Property taxes Income taxes Total disbursements Cash balance Cash borrowed Cash repaid Ending balance