ACCT504 Practice Case Study 3 on Cash Budgeting

This is a practice case study to help you become familiar with how to create a comprehensive cash budget. The cash budget relates to TCO D and is discussed in Chapter 4.

The actual case study assignment should be uploaded to the Week 6 Assignment Dropbox by 11:59 p.m. mountain time on Sunday at the end of Week 6. You are encouraged to use the Excel template file provided in Doc Sharing.

The Cambridge Company has budgeted sales revenues as follows.

Jan Feb Mar__

Credit sales45,00036,00027,000

Cash sales 27,000 76,500 58,500

Total sales72,000112,50085,500

Past experience indicates that 60% of the credit sales will be collected in the month of sale and the remaining 40% will be collected in the...