1. Hoyt, Inc. has estimated current year sales (in millions) for the next four quarters.
Q1 $240 Q2 $250 Q3 $205 Q4 $350
• Sales for the 1st quarter next year are projected to be $230.
• Accounts Receivable at the beginning of the year was $100.
• Beginning Accounts Payable were $60.
• The beginning cash balance is $50.
• Hoyt, Inc. cash collection schedule is as follows: 60% of sales in the current quarter, 40% in the 1st quarter after sale.
• Purchases from suppliers in a quarter are equal to 50% of the next quarter’s forecasted sales. (accounts payable)
• Suppliers are normally paid in 50% in the quarter purchases are made and 50% in the following quarter.
• Wages, taxes and other expenses are 20% of current quarter sales
• Hoyt, Inc. maintains a minimum cash balance of $30
Complete a cash budget for Hoyt, Inc.

Interesting homework assignment - thanks for copying it.

Ask Me Help Desk - Announcements in Forum : Homework Help
“Read this first - Expectations for the Homework Help Board:
Do not simply retype or paste a question from your book or study material

We won't do your homework questions for you. You were given the assignment for you to learn.

If you come up with your own answer and post it for us to critique that is within reason.

If you have some SPECIFIC questions that you couldn't find or didn't understand, we may help with that. But this is your assignment, so show us you have at least attempted to complete it on your own.

Thank you.”