Answer to Question #82322 in Accounting for Stephanie

Question

Build the projected revenue budget for the six months ending in December.

Apollo cash receipts
1.5.20xx – 30.9.20xx
May June July Aug. Sept. Oct. Nov. Dec.
3,000 5,000 7,000 5,000 5,000 4,500 3,000 3,000

Note:
Cash receipts are shown. Credit revenues are twice that of cash each month. Credits sales were $3,000 in March and $5,000 in April. Credit terms are 50% by end of the month; 35% by end of the next month balance by end of third month.
May June July Aug Sept Oct Nov Dec
Cash 3,000 5,000 7,000 5,000 5,000 4,500 3,000 3,000
Total Credit 6,000 10,000 14,000 10,000 10,000 9,000 6,000 6,000
Cr rcvd. 90 days
Cr rcvd. 60 days
Cr rcvd. 30 days
Total $