Compute the cash collections from sales for each quarter

Assignment Help Financial Management

Reference no: EM13927908

The sales budget for your company in the coming year is based on a quarterly growth rate of 10 percent with the first-quarter sales projection at $225.8 million. In addition to this basic trend, the seasonal adjustments for the four quarters are 0, −$16.8, −$8.8, and $21.8 million, respectively. Generally, 50 percent of the sales can be collected within the quarter and 45 percent in the following quarter; the rest of the sales are bad debt. The bad debts are written off in the second quarter after the sales are made. The beginning accounts receivable balance is $104.8 million. Assuming all sales are on credit, compute the cash collections from sales for each quarter.

Q1 Q2 Q3 Q4

Collected within quarter

Collection from previous quarter

Cash collections from sales

Reference no: EM13927908

Questions Cloud

Issue a zero coupon bond at an annual interest rate : Assume that HOS could issue a zero coupon bond at an annual interest rate of 4 percent with semi annual compounding for 20 years. If HOS receives $2,264.45 for the bond, how much would it have to pay at the maturity date?

Returns on stocks are perfectly negatively correlate : The returns on stocks A and B are perfectly negatively correlated (\rho_{AB} = -1). Stock A has an expected return of 21 % and a standard deviation of return of 40%. Stock B has a standard deviation of return of 20%. The risk-free rate of interest is..

Projects are of average risk-what is optimal capital budget : Milwaukee Surgical Supplies is evaluating the following projects: Project Cost IRR A $100,000 19% B 75,000 17% C 90,000 16% D 80,000 14% If the firm’s corporate cost of capital is 15% and all projects are of average risk, what is the optimal capital ..

Cost of debt for tax benefit associated with deductibility : A for-profit firm must adjust the cost of debt for the tax benefit associated with its deductibility (multiply by 1-T). A not-for-profit firm also needs to adjust the debt to an after-tax basis even though it does not pay taxes (by using the tax rate..

Compute the cash collections from sales for each quarter : The sales budget for your company in the coming year is based on a quarterly growth rate of 10 percent with the first-quarter sales projection at $225.8 million. In addition to this basic trend, the seasonal adjustments for the four quarters are 0, −..

Achieve its targeted weighted average cost of capital : Central Systems, Inc. desires a weighted average cost of capital of 9 percent. The firm has an after-tax cost of debt of 6 percent and a cost of equity of 12 percent. What debt-equity ratio is needed for the firm to achieve its targeted weighted aver..

What is its cost of common equity and its WACC : Patton Paints Corporation has a target capital structure of 35% debt and 65% common equity, with no preferred stock. Its before-tax cost of debt is 8% and its marginal tax rate is 40%. The current stock price is P0 = $35.00. The last dividend was D0 ..

Determine the value of aggie : The Lanoi Company has EBIT of $30,000 and market value debt of $150,000 outstanding with an 8% coupon rate. The cost of equity for an all equity firm would be 12%. Aggie has a 30% corporate tax rate. Investors face a 20% tax rate on debt receipts and..

Ethics are an important aspect of corporate culture : Ethics are an important aspect of corporate culture. The tone at the top is part of what sets expectations for employees. Describe the tone at the top of your organization. If you were in charge, what would you do differently?

User Account

All Pages