Master it! Solution
a.			July	August	September
	Beginning cash balance
	Cash receipts
	Cash collections from credit sales
	Total cash available
	Cash disbursements
	Purchases
	Wages, taxes, and other expenses
	Interest
	Equipment purchases
	Total cash disbursements
	Ending cash balance

Chapter 16 - Master it! Heidi Pedersen, the Treasurer for Wood Products, Inc. has just been asked by Justin Wood, the company's president, to prepare a memo detailing the company's ending cash balance for the next 3 months. Below, you will see the relevant estimates for this period. $ July 1,275,800 $ 765,480 August September 1,483,500 $ 1,096,300 890,160 657,780 Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment 348,600 29,900 395,620 29,900 158,900 337,150 29,900 96,300 Credit sales collections: Collected in month of sale: Collected month after sale: Never collected: 35% 60% 5% June credit sales: June credit purchases: Beginning cash balance: $ $ $ 1,135,020 681,012 425,000 All credit purchases are paid in the month after the purchase. 25 a. Complete the cash budget for Wood Products for the next three months. Heidi knows that the cash budget will become a standard report completed before each quarter. To help reduce the time preparing the report each quarter, she would like a memo with the appropriate information in Excel linked to the memo. Prepare a memo to Justin that will automatically update when the values are changed in Excel