Create a three-month cash budget including a schedule

Reference no: EM131972244

Problem

Sales were $820,000 in August and $865,500 in September. Material usage was $117,100 in August and $121,800 in September. All sales are on account, and accounts receivable is historically collected 15% in the month of sale, 65% in the month following sales, and the remainder two months after the sale. Materials are paid for 35% in the month used and 65% the following month. All other expenses are paid in the month incurred. The cash balance was $42,000 at the beginning of October, and management wants to determine if the company will have enough cash to pay a year-end bonus.

Prepare a three-month cash budget, including a schedule for cash collections and material payments.

Reference no: EM131972244

Questions Cloud

What is its weighted average cost of capital : Its capital mix is similar to that of its competitors at 5% bonds and 95% common stock. It has a 5.1% pre-tax cost of debt and a 12% cost of equity.

Estimate the annual growth rate of rents : State the house's full address and copy a small picture of the house. Estimate the annual growth rate of rents and explain your answer

Discuss sarbanes-oxley : Why doesn't Sarbanes-Oxley apply to privately-owned companies? (The correct answer is Not "Because it applies only to publicly held companies.")

What is an efficient market : What is an efficient market? How can be efficient if prices behave in a random fashion?

Create a three-month cash budget including a schedule : Sales were $820,000 in August and $865,500 in September. Create a three-month cash budget, including a schedule for cash collections and material payments.

What is the yield to maturity of bond : Suppose that a 20 year 10% annual coupon bond sells for $950, and the bond has a face value of $1,000.

What will be the propertys annual debt coverage ratio : What will be the property's annual debt coverage ratio in its first year of operation?

Retain for investment in new projects : How much of its earnings will Jacobson retain for investment in new projects?

What exact steps will you take to employ this strategy : If you think that the stock will decrease in value but you want to also protect yourself against the chance that the stock goes up, what option strategy can you

User Account

All Pages