PDA

View Full Version : Cash Budget/Cash Receipts


rachel_Max
Jul 29, 2008, 07:58 AM
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

CliffARobinson
Mar 11, 2012, 05:12 PM
Your math is accurate. I would suggest using this Cash Flow Forecasting tool (http://www.mindtools.com/pages/article/newTMC_06.htm) to assist you with calculations.