Heidi Pedersen - Cash Budgeting 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. Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment Credit sales collections: Collected in month of sale: Collected month after sale: Never collected: June credit sales: June credit purchases: Beginning cash balance: $ July 1,375,800 $ August 1,595,928 September $ 1,196,300 765,480 890,160 657,780 348.600 395,620 337,150 29,900 29,900 158,900 29.900 96,300 40% 55% 5% $ 1,235,020 $ 681,012 $ 425.000 All credit purchases are paid in the month after the purchase. a. (80 Points) Complete the cash budget for Wood Products for the next three m Heidi Pedersen - Cash Budgeting Spreadsheet a. (80 Points) Beginning cash balance July $425,000 August September 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 July August