Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   Hoyt, Inc. has estimated current year sales (in Millions) for the next four quarters. (https://www.askmehelpdesk.com/showthread.php?t=767967)

  • Sep 20, 2013, 07:53 AM
    sky2412
    Hoyt, Inc. has estimated current year sales (in Millions) for the next four quarters.
    Q1 $240 Q2 $250 Q3 $205 Q4 $350

    Sales for 1st quarter next year are projected to be $230.

    Accounts Rec. 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% if sakes in current quarter, 40% in the 1st quarter sale.
    Purchasesfrom suppliers in a quarter are equal to 50% of the next quarter's forecasted sales.
    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 of 30.
  • Sep 20, 2013, 07:55 AM
    pready
    Looks like a simple cash budget problem. What are you stuck on, or what do you need help with.
  • Sep 20, 2013, 08:03 AM
    sky2412
    I am confused with the Q1-240 and the Sales for the 1st quarter next year which is to be projected at 230.00
  • Sep 20, 2013, 08:13 AM
    pready
    You are dealing with 5 quarters, 4 in the current year and 1 in the following year. I would assume that quarter 1 is your current quarter.

    Your cash collections schedule does not make sense. I think it is supposed to be that 60% of sales in the quarter of the sale and 40% in the quarter following the sale are collected.

    If this is correct you start with Quarter 1 sales times 60% equals your cash collections in the first quarter. For quarter 2 you start with quarter 1 sales times 40% then add your quarter 2 sales times 60%. Then you do the following quarters in the same fashion.

    It looks like you are missing previous quarter sales information for the cash collections in the current quarter.

  • All times are GMT -7. The time now is 02:15 AM.