ACCT/505 ACCT505 ACCT 505 Week 5 Course Project
- Devry University / ACCT 505
- 22 Jun 2018
- Price: $8
- Other / Other
ACCT 505 Week 5 Course Project
Week 5 Course Project
Course Project 1 is due this week. Course Project 1 instructions (Links
to an external site.)Links to an external site.Course Project 1 Excel spreadsheet. (Links to an external site.)Links to an external
site.
| PROJECT 1 - Excel Template | ||||||
| Student Name: | ||||||
| SALES BUDGET: | ||||||
| April | May | June | Quarter | |||
| Budgeted unit sales | ||||||
| Selling price per unit | ||||||
| Total sales | ||||||
| SCHEDULE OF EXPECTED CASH COLLECTIONS: | ||||||
| April | May | June | Quarter | |||
| February Sales | ||||||
| March Sales | ||||||
| April Sales | ||||||
| May Sales | ||||||
| June Sales | ||||||
| Total cash collections | ||||||
| MERCHANDISE PURCHASES BUDGET: | ||||||
| April | May | June | Quarter | |||
| Budgeted unit sales | ||||||
| Add desired ending inventory | ||||||
| Total needs | ||||||
| Less beginning inventory | ||||||
| Required purchases | ||||||
| Cost of purchases @ $4 per unit | ||||||
| BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES: | ||||||
| April | May | June | Quarter | |||
| March Purchases | ||||||
| April Purchases | ||||||
| May Purchases | ||||||
| June Purchases | ||||||
| Total cash payments | ||||||
| EARRINGS UNLIMITED | ||||||
| CASH BUDGET | ||||||
| FOR THE 3 MONTHS ENDING JUNE 30 | ||||||
| April | May | June | Quarter | |||
| Cash balance | ||||||
| Add collections from customers | ||||||
| Total cash available | ||||||
| Less disbursements | ||||||
| Merchandise purchases | ||||||
| Advertising | ||||||
| Rent | ||||||
| Salaries | ||||||
| Commissions | ||||||
| Utilities | ||||||
| Equipment purchases | ||||||
| Dividends paid | ||||||
| Total disbursements | ||||||
| Excess (deficiency) of receipts | ||||||
| over disbursements | ||||||
| Financing: | ||||||
| Borrowings | ||||||
| Repayments | ||||||
| Interest | ||||||
| Total financing | ||||||
| Cash balance, ending | ||||||
USA 
India