And also show the calculation.

utoSave CF 11h edon Chapter 26 Escel Marher shudent Ecel Hokt Laus le Home Iinsert Page Layouts Formulas Datar Review View P Searchs Help X -12 A A General l Conditional Fomating Pasta 1 Fomat as Table- R% Dulete B I U- o A s - Call Styles- Fomat cleband Fort Alignment Number Style Call .A C F H Chapter 26-Master it! Heidi Pedersen, the Treasurer for Wood Products, Inc. has just been asked by Justin Wood the companys president, to prepare a ne detailing the company' s ending cash balance for the sext 3 months. Below, you will see the relevant estimates for this period September $1,096, 300 657, 780 July $1.275, 800- 765, 480 August Credit sales Credit purchases Cash disbursements: $ 1.483, 500 890, 160 Wages, taxes, and expense Interest Equipeent 348, 600 29, 900 395, 620 337, 150 29,900 158, 900 29, 900 96,300 Credit sales collections: Collected in month of sal Collected month after sal Never collected: 35% 60% S 1, 135,020 681, 012 425, 000 June credi t sales: June eredit purchases: Beginning cash balance: A1l credit purchases are paid in the nonth after the purchase 4 Complete the cash budget for Wood Products for the hext three sonths 5a 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 Iike a neno with the appropriate information in Excel linked to the nemo Prepare a neno to Justin tha will automatically update when the values are changed in Excel. 4 19 Mater a Sheon ection 2 Chacter 24s Pasto I U A Clipboard Font Alignment Numb X 7 A C E F Master it! Solution July August September a. Beginning cash balance Cash receipts Cash collections from credit sales Total cash available 425, 000 Cash disbursements Purchases 2 Wages, taxes, and other expenses 3 4 Interest Equipment purchases Total cash disbursements 6 Ending cash balance 0 1 3 4 5 6 7 8 C 1 2 3 4 5 7 19 10