Prepare the Cash budget for the quarter ending June 30th, 2022.

B C D E 1.) Dunder Mifflin Paper Company has hired you as a consultant to help prep Michael Scott tells you that: Beginning cash balance April 1st is $74,000. Green Company has an advertising contract of $200,000 per month. Green Company pays $18,000 each month for rent, $7,000 for utilities and $1 Green Company pays sales commissions to its sales staff of 4% of sales, above Green Company will pay a yearly $15,000 dividend in the month of April. Green will purchase $16,000 of equipment in May and $40,000 in June. Green must maintain a minimum cash balance of $50,000 each month. All borrowing is done at the beginning of the month, and any repayments are The interest rate on borrowings is 10% per year, and interest accrues monthly Interest must be paid when borrowings are repaid. B C D E 1.) Dunder Mifflin Paper Company has hired you as a consultant to help prep Michael Scott tells you that: Beginning cash balance April 1st is $74,000. Green Company has an advertising contract of $200,000 per month. Green Company pays $18,000 each month for rent, $7,000 for utilities and $1 Green Company pays sales commissions to its sales staff of 4% of sales, above Green Company will pay a yearly $15,000 dividend in the month of April. Green will purchase $16,000 of equipment in May and $40,000 in June. Green must maintain a minimum cash balance of $50,000 each month. All borrowing is done at the beginning of the month, and any repayments are The interest rate on borrowings is 10% per year, and interest accrues monthly Interest must be paid when borrowings are repaid