Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Cash Budget/Cash Receipts (https://www.askmehelpdesk.com/showthread.php?t=242927)

  • Jul 29, 2008, 07:58 AM
    rachel_Max
    Cash Budget/Cash Receipts
    1) Rushmore Kitchen Supply has forecast credit sales for the fourth quarter of the year as:
    March(actual) $75,000
    Fourth Quarter - projected
    April $80,000
    May $70,000
    June $75,000
    Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent in the following month, and 10 percent are never collected.
    Required:
    Prepare a schedule of cash receipts for Rushmore Kitchen Supply for the first quarter.

    Here is my work... does it look like I am on the right track??

    April May June
    80,000 70,000 75,000
    Collections, 30% in current month 24,000 21,000 22,500
    Collections, 60% in the following month 0 48,000 42,000
    Collections, 10% never collected 2,400 6,900 6,450
    Total Cash receipts 21,600 62,100 58,050
  • Mar 11, 2012, 05:12 PM
    CliffARobinson
    Your math is accurate. I would suggest using this Cash Flow Forecasting tool to assist you with calculations.

  • All times are GMT -7. The time now is 03:12 PM.