Relevant estimates for period

Assignment Help Business Management

Reference no: EM13974337

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 three months. Below, you will see the relevant estimates for this period.

Credit sales	$1,275,800	$1,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	0	158,900	96,300
Credit sales collections
Collected in month of sale	35%
Collected month after sale	60%
Never collected	5%
June credit sales	$1,135,020
June credit purchases	$ 681,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.
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

Reference no: EM13974337

Questions Cloud

Estimating the expected inflation premium : The risk-free rate of return is 6 percent, based on an expected inflation premium of 3 percent. The expected rate of return on the market portfolio is 15 percent.

Calculate your payment and interest paid in each quarter. : Create a spreadsheet model with time line to calculate your payment and interest paid in each quarter.

Personal digital assistant division : In 2000 the firm 3Com spun out its personal digital assistant division as Palm Inc. On February 23, 2001, the financial services firm Telerate reported the following information about Palm.

Do you see problems that may arise with this question : A group of men and a group of women take a test which reveals that the average score of the women is higher than that of the men. Do you see problems that may arise with this

Relevant estimates for period : 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 three months. Below, you will see the relevant estimates..

What are the eoq for both printing companies : Using the EOQ's above and volume order information provided, what will be the cost of the programs and inserts if they are purchased from First Printing.

Calculate the wacc for auto parts retailer autozone : You want to calculate the WACC for auto parts retailer AutoZone (AZO). Complete the following steps to construct a spreadsheet that can be updated.

Analyze whether the investment in the truck is profitable. : Explain why limited leverage is good for business.Show the profitability of the project so that Stephanie can convince her father to purchase the truck by borrowing money.

Loan and the cash from savings : Using the payback method, determine the length of time that will be required to recoup the $400,000 investment in the new facility.

User Account

All Pages