Cash Budget Project Instruction: Please submit an electronic copy of your homewo
ID: 2801062 • Letter: C
Question
Cash Budget Project Instruction: Please submit an electronic copy of your homework solution for this project to the Blackboard under Assignment. The due date is December 11. Your solution should be in an Excel file. Please read the Cash Budget slides before doing the assignment below Andrea 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 August September Credit sales Credit purchases Cash disbursements 1,483,500 $ 890,160 1,096,300 657,780 765,480 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,000Explanation / Answer
Wood Products Inc. Cash Budget for July, Aug and Sep particulars July August September Beginning cash balance $425,000 $493,030 $427,835 Cash Receipts: Cash Collections from Credit $1,127,542 $1,284,705 $1,273,805 Note.1 Sub-Total: $1,552,542 $1,777,735 $1,701,640 Cash Disbursements: Purchases $681,012 $765,480 $890,160 Note.2 Wages, Taxes and other expenses $348,600 $395,620 $337,150 Interest $29,900 $29,900 $29,900 Equipment purchase $0 $158,900 $96,300 Total Cash Disbursements $1,059,512 $1,349,900 $1,353,510 Ending Cash Balance $493,030 $427,835 $348,130 Note:1 Cash Flow Month June July August September Credit Sales Collections: Credit Sales: $1,135,020 $1,275,800 $1,483,500 $1,096,300 Collections in the month of Sale 35% $446,530 $519,225 $383,705 Collections after the month of Sale 60% $681,012 $765,480 $890,100 Never Collected 5% $0 $0 $0 Cash Collected: $1,127,542 $1,284,705 $1,273,805 Cash Flow Month June July August September Note:2 Credit Purchases payment: Credit Purchase: $681,012 $765,480 $890,160 $657,780 Payments in the same month 0% $0 $0 $0 Payments after the month of purchase 100% $681,012 $765,480 $890,160 Never paid 0% $0 $0 $0 Cash paid for purchases: $681,012 $765,480 $890,160