The Bruin Corporation's purchases from suppliers in a quarter are equal to 70 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 25 percent of sales, and interest and dividends are $122 per quarter. No capital expenditures are planned. Projected quarterly sales are: Sales Q1 $1,290 Q2 $1,440 Q3 $1,530 Q4 $1,740 Sales for the first quarter of the following year are projected at $1,410. Calculate Bruin's cash outlays by completing the following: Payment of accounts Wages, taxes, other expenses Long-term financing expenses (interest and dividends) Total Q1 Q2 Q3 Q4

The Bruin Corporation's purchases from suppliers in a quarter are equal to 70 percent of the next quarter's forecast sales. The payables period is 60 days. Wages, taxes, and other expenses are 25 percent of sales, and interest and dividends are $122 per quarter. No capital expenditures are planned. Projected quarterly sales are: Sales Q1 $1,290 Q2 $1,440 Q3 $1,530 Q4 $1,740 Sales for the first quarter of the following year are projected at $1,410. Calculate Bruin's cash outlays by completing the following: Payment of accounts Wages, taxes, other expenses Long-term financing expenses (interest and dividends) Total Q1 Q2 Q3 Q4

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter21: Supply Chains And Working Capital Management

Section: Chapter Questions

Problem 11P: Negus Enterprises has an inventory conversion period of 50 days, an average collection period of 35...

See similar textbooks

Similar questions

Your company forecasts that next year's sales will be $59.00 million, Cost of Goods Sold (COGS) will be 85% of sales, and the Days Payables Outstanding (DPO) ratio will be 22.19. What is the forecasted accounts payable for next year?
Finlay Corporation had sales this year of $3,270 million, and sales are expected to grow by 20 percent next year. Next year the company expects cost of goods sold to be 60 percent of sales, selling expenses to be $40 million per month, depreciation to be $10 million per month, and interest expense to be $24 million per month. Taxes are computed at 21 percent. What is Finlay's expected net income next year?
Distribution Limited projects sales next year to be $4 million and expects to earn 5% of that amount after taxes. The company is currently in the process of projecting its financial needs and has made the following assumptions (projections): - Current Assets will equal 8% of sales, and fixed assets will remain at their current level of $1million. - Common equity is currently $0.6million (made up entirely of Retained earnings), and the company pays out half of its after-tax earnings in dividends. - The company has short-term payables that normally equal 7% of sales each and it has no long-term debt outstanding. What are the company’s financing needs for the coming year?
Camp Manufacturing turns over its inventory eight times each year, has an average payment period of 35 days, and has an average collection period of 60 days. The firm’s annual sales are $3.5 million. Assume there is no difference in the investment per dollar of sales in inventory, receivables, and payables and that there is a 365-day year. If the firm pays 14% for these resources, by how much would it increase its annual profits by favorably changing its current cash conversion cycle by 20 days?
Foreman Publishing Company’s income for the most recent quarter was $500,000, and the averagenet book value (NBV) of assets during the quarter was $1.5 million. If the company has a requiredrate of return of 15% on investment, what was the residual income (RI) for the quarter?
The S&H construction company expects to have total sales next year totaling $14,500,00 In addition, the firm pays taxes at 35 percent and will owe $318,000 in interest expenses. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 58 percent of sales and operating expenses will total 32 percent. What is your estimate of the firm’s net income after taxes for the coming year ? Complete the pro-forma income statement below Round to the nearest dollar Pro-forma income statement Sales Cost of goods sold Gross profit Operating expenses Net operating expenses Interested expenses Earnings before taxes Taxes Net income
(Financial forecasting percent of sales) Tulley Appliances, Inc. projects next year's sales to be $19.9 million. Current sales are at $15.3 million, based on current assets of $5.1 million and fixed assets of $4.9 million. The firm's net profit margin is 5.3 percent after taxes. Tulley forecasts that current assets will rise in direct proportion to the increase in sales, but fixed assets will increase by only $110,000. Currently, Tulley has $1.6 million in accounts payable (which vary directly with sales), $1.9 million in long-term debt (due in 10 years), and common equity (including $3.8 million in retained earnings) totaling $6.3 million. Tulley plans to pay $501,000 in common stock dividends next year. a. What are Tulley's total financing needs (that is, total assets) for the coming year? b. Given the firm's projections and dividend payment plans, what are its discretionary financing needs? c. Based on your projections, and assuming that the $110,000 expansion in fixed assets will…
Violet Sales Corp, reports the year-end information from 2023 as follows: Sales (35,500 units) $284,000 Cost of goods sold 105,000 Gross margin 179,000 Operating expenses 152,000 Operating income $27,000 Violet is developing the 2024 budget. In 2024 the company would like to increase selling prices by 3.5%, and as a result expects a decrease in sales volume of 14%. All other operating expenses are expected to remain constant. Assume that cost of goods sold is a variable cost and that operating expenses are a fixed cost. What is budgeted sales for 2024?
Noah’s ark video games expects sales to grow by 25% next year. Assume that it pays out 95% of its net income. Using the following statements and the percent of sales method, forecast accounts payable
The S&H construction company expects to have total sales next year totaling $15,300. In addition, the firm pays taxes at 35 percent and will owe $280,000 in interest expense. Based on last year’s operations the firm’s management predicts that its cost of goods sold will be 57 percent of sales and operating expenses will total 32 percent. What is your estimate of firm’s net income after taxes for the coming year? Complete the forma income statement below Round to the nearest dollar Pro-forma income statement Sales Cost of goods sold Gross profit Operating expenses Net operating income Interest expenses Earnings before taxes Taxes Net income
Sexton Corporation has projected the following sales for the coming year: Q4 Q3 $1,210 $ 1,450 Sales 01 $ 940 Q2 $ 1,130 Sales in the year following this one are projected to be 15 percent greater in each quarter. a. Assume that the company places orders during each quarter equal to 30 percent of projected sales for the next quar Assuming that the company pays immediately, what is the payables period? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. a. Payables period
Steber Packaging Inc. expects sales next year of $40 million. Of this total, 45 percent is expected to be for cash and the balance will be on credit, payable in 30 days. Operating expenses are expected to total $17 million. Accelerated depreciation is expected to total $12 million, although the company will only report $8 million of depreciation on its public financial reports. The marginal tax rate for Steber is 34 percent. Current assets now total $26 million and current liabilities total $14 million. Current assets are expected to increase to $29 million over the coming year. Current liabilities are expected to increase to $20 million. Compute the projected after-tax operating cash flow for Steber during the coming year. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places. $ million