Answered step by step
Verified Expert Solution
Question
1 Approved Answer
l need thee excel formulas. Andrea Pedersen, the Treasurer foi Wo d Products, Inc. has just been asked by Justin Wood, the company's president, to
l need thee excel formulas. Andrea Pedersen, the Treasurer foi Wo d Products, Inc. has just been asked by Justin Wood, the company's president, to prepare a memo detai g the company's ending cash balance for the next 3 months. Below, you wil see the relevant estimates for this period. July August September Credit sales $1,275,800 S1,483,500 $1,096,300 Credit purchases 765,480 890,160 657,780 Cash disbursements Wages, taxes, and expenses 348,600 395,620 337,150 Interest 29,900 29,900 29,900 Equipment 158,900 96,300 Credit sales collections: Collected in month of sale: 3500 Collected month after sale: 60% Never collected: 5% June credit sales: $1,135,020 June credit purchases: S681,012 Beginning cash balance: $425,000 All credit purchases are paid in the month after the purchase. Complete the cash budget for Wood Products for the next three months. Andrea 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 (in Excel too) with the appropriate information in this Excel file linked to the memo. Prepare a memo to Justin that will automatically update when the values are changed in Excel. aster it! Solution July $425,000 R. August September Beginning cash balance Cash receipts $493,030 $427,835 Cash collections from credit sales 1,127,542 1,284,705 1,273,805 Total cash available Cash disbursements $765,480 395,620 29,900 158,900 Purchases Wages, taxes, and other expenses Interest $681,012 348,600 9.900 $890,160 337,150 29,900 Equipment purchases 059 Total cash disbursements Ending cash balance 5348.130
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started