The Bandon Pine Corporation's purchases from suppliers in a quarter are equal to 60percent 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 $95per quarter. No capital expenditures are planned.Here are the projected quarterly sales:Q1az03Q4Sales $1,860 $2,160 $1,860 $1,560Sales for the first quarter of the following year are projected at $2,190. Calculate thecompany's cash outleys by completing the following: (Do not round intermediatecalculations and round your answers to 2 decimal places, e.g., 32.16.)Payment of accountsWages, taxes, other expensesLong-term financing expenses (interest and dividends)Q1Q2Q3Q4

Q4 Last year Q1Q2Q3Q4Q1 Next yearSales18602160186015602190Purchases (60% of…

Sales for the first quarter of the following year are projected at $2.190. Calculate the company's cash outleys by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g.. 32.16.)

Sales for the first quarter of the following year are projected at $2.190. Calculate the company's cash outleys by completing the following: (Do not round intermediate calculations and round your answers to 2 decimal places, e.g.. 32.16.)

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

Related questions

Q: Primo Management Company is looking at how best to evaluate the performance of its managers. Primo…

A: Total within sector selection=Large cap growth +Mid cap growth +Small cap growth.

Q: Required information [The following information applies to the questions displayed below.] Kate's…

A: A firm must make crucial choices that need significant capital expenditure. Business development and…

Q: ACME, Inc. forecasts that it will have the free cash flows shown below. The free cash flows are…

A: Current price of stock is the price which can be paid for purchase of the stock. It is also called…

Q: Metlock Corporation had net income for the current fiscal year of $ 952, 200, and common shares…

A: Diluted earnings per share is a metric that shows the dilution of the earnings attributed to the…

Q: Stryker Corporation is a leading medical technology company headquartered in Kalamazoo, Michigan,…

A: Here, Sales $ 9,021.00Net Income $ 1,616.00Number if common…

Q: IBM is evaluating a project in Eutopia. The project will create the following cash flows: Year $ 0…

A: The reinvestment rate is 3.5%.The required rate of return is 12%.The cash flows are as follows:

Q: Ying Import has several bond issues outstanding, each making semiannual interest payments. The bonds…

A: After tax cost of debt = Before tax cost of debt * (1-tax rate)Before tax cost of debt = YTM of the…

Q: Steinberg Corporation and Dietrich Corporation are identical firms except that Dietrich is more…

A: Steinberg:ExpansionRecessionEBIT$3,100,000$51,500,000Payoff to debt…

Q: Von Bora Corporation is expected to pay a dividend of $1.40 per share at the end of this year and a…

A: Price at year 1= P1= D2/(1+R)^1 + P2/(1+R)^1= 1.5/(1+10%)^1 + 25/(1+10%)^1= 24.0909 or 24.10Price at…

Q: Use the table to complete following questions: Canadian Dollar: Spot and Forward (CS/S) Euro: Spot…

A: $100=1.2651∗100C$.=126.51C$

Q: a. How many contracts must you purchase to protect your portfolio from exchange rate risk? b.…

A: a):Total exposure in dollar terms = $430,000Total exposure in pound terms = $430,000*0.57 = 245,100…

Q: Your client has $103,000 invested in stock A. She would like to build a two-stock portfolio by…

A: A lower standard deviation indicates less risk in a portfolio. Therefore, when considering…

Q: A proposed project has fixed costs of $35,000 per year. The operating cash flow at 14,000 units is…

A: Degree of operating leverage measures the change in operating income by change in in sales. In above…

Q: Wyatt oil presently pays no dividend. You anticipate Wyatt Oil will begin paying an annual dividend…

A: Current price of stock is the price which can be paid for purchase of the stock. It is also called…

Q: Modigliani and Miller Proposition II states that: the optimal capital structure occurs when the…

A: Modigliani and Miller Propositions are key principles in corporate finance that address the…

Q: market risk premium is 6%. The stock has a beta of 1.20 versus the S&P 500. Calculate the intrinsic…

A: The intrinsic value of a stock, also known as its fundamental or true value, is an estimate of the…

Q: A project has annual cash flows of $7,500 for the next 10 years and then $5,500 each year for the…

A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…

Q: You have looked at the current financial statements for J&R Homes, Company. The company has an EBIT…

A: EBIT =$5,250,000Depreciation=$345,000Increase in net working capital=$75,000Capital…

Q: You want to create a portfolio that is 80% as risky as the market. You can choose to invest in…

A: The objective of the question is to determine the proportion of investment in Stock B to create a…

Q: A lender that makes a loan to an individual whose only income is commission based and who hasn't…

A: This case belongs to financial services where certain norms are to be followed by the banking…

Q: You live in a world where three future states are possible: Boom, Normal and Recession. See the…

A: Standard deviation measures the risk involved in earning a return from the stock. lower the risk…

Q: Your division is considering two projects with the following cash flows (in millions): 2 3 Project A…

A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…

Q: 9:13MM. kuldeepkumar 4Gl : Just now Synovec Corporation is growing quickly. Dividends are…

A: The objective of this question is to calculate the current share price of Synovec Corporation given…

Q: When a company collects the face value of a bond investment at maturity, total assets increase. O…

A: Given statement:When a company collects the face value of a bond investment at maturity, total…

Q: For an unlevered firm, the cost of capital can be determined by using the ________. A.…

A: The objective of the question is to identify the correct method to determine the cost of capital for…

Q: Project X $0 NPV 0% Project A 19% vvnat is the KK of Project A? 22% OA. 8% OB. 22% OC. 30% OD. 12%…

A: Internal Rate of Return is that cost of capital where present value of cash inflow = present value…

Q: 15. An interest-only loan is an example of a: partially-amortizing loan. fully-amortizing loan…

A: Amortization refers to the systematic repayment of loan which includes principal and interest…

Q: Wonka Candy Inc. would like to buy a new machine that would automatically dip chocolates. The…

A: NPV is also known as Net Present Value.. It is a capital budgeting technique which helps in decision…

Q: If a company reports discontinued operations, EPS must be disclosed for both income from continuing…

A: Earnings Per Share (EPS) serves as a fundamental metric for investors, representing the…

Q: Dynamic - Problem and answer changes with each attempt (consider an Excel solution) Monet,…

A: Net present value (NPV) is the difference between the current value of cash and the future worth of…

Q: arr Company is considering a project that has the following cash flow data. What is the project's…

A: IRR is one of the most used method of capital budgeting based on the time value of money and net…

Q: There is a zero coupon bond that sells for $4,432.06 and has a par value of $10,000. If the bond has…

A: The yield to maturity on the zero coupon bond is calculated using the following equationWhere, FV is…

Q: The company incurs costs of $27.7 million regardless of the output level. It sells 5.68 million…

A: GivenSales units = 5.68 MPrice = 8.79Variable Cost =10.20 mcontribution ratio = (sales price -…

Q: Assume you have taken out a 25-year loan of $177,390 with an annual interest rate of 6.72%,…

A: When the borrower borrows a loan from the lender, he has to pay a rate of interest on the borrowed…

Q: Hooper Chemical Company, a major chemical firm that uses such raw materials as carbon and petroleum…

A: State of economyOutcomesProbabilityRecession$200.30Normal economy$400.40Strong economy$600.30

Q: An investment has an installed cost of $537,800. The cash flows over the four-year life of the…

A: A number of financial computations, including figuring out the present value of future cash flows,…

Q: Graphical Designs is offering 15-15 preferred stock. The stock will pay an annual dividend of $15…

A: Preferred stock represent ownership in a company. This aspect of preferred stock is the same as…

Q: Which of the following measures the total risk of a portfolio? A. Standard Deviation B.…

A: The objective of the question is to identify the correct measure that quantifies the total risk of a…

Q: Find the stock price given that the current dividend is $2 per share, dividends are expected to grow…

A: When the company receives profits and distributes them among the shareholders. That share of profit…

Q: Cori's Corporation, has a book value of equity of $13,185. Long-term debt is $7,475. Net working…

A: Total Assets = Total liabilities + Shareholders' equity(Fixed Assets + Current Assets) = (Long term…

Q: Tartan Industries currently has total capital equal to $9 million, has zero debt, is in the 25%…

A: Recapitalization of stock involves altering a company's capital structure, often through changes in…

Q: Mesmer Analytic, a biotechnology firm, floated an initial public offering of 2,000,000 shares at a…

A: The IPOs are the new issues introduced in the financial market for the first time by the company so…

Q: What is her cash flow under the current capital structure, assuming the firm has a dividend payout…

A: A capital structure is the combination of many funding sources it uses to finance its operations and…

Q: Which is true about IPOs? O The most common type of IPO arrangement with underwriters is the firm…

A: True. In a firm commitment cash offer, the underwriters agree to purchase the entire issue of shares…

Q: Stoneheart Group is expected to pay a dividend of $2.89 next year. The company's dividend growth…

A: The price of the stock can be determined by using the dividend discount model. The dividend discount…

Q: It is 2022. You are investigating the possibility of making an equity investment in Walkerville…

A: Terminal value of firm at year 2 (TV)= FCF2*(1+g)/(WACC - g) = 35*1.02/(0.11-0.02)= 396.6666667

Q: John wants to buy a property for $105,000 and wants an 80% loan for $84,000. A lender indicates that…

A: The mortgage loans are secured loans and these loans are paid by the monthly payments that carry the…

Q: Carmax, Inc. common stock currently sells for $95.89 per share, and the standard deviation of…

A: The gamma for a company refers to the measure of the change in the delta of the option on the…

Q: 1. Todd Mountain Development Corporation is expected to pay a dividend of $4 in the upcoming year.…

A: Required rate

Q: In September 2012, the Argentinian central bank increased its benchmark interest rate via open…

A: In this question, we are required to determine whether the statement regarding the open market…

Question

The Bandon Pine Corporation's purchases from suppliers in a quarter are equal to 60
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 $95
per quarter. No capital expenditures are planned.
Here are the projected quarterly sales:
Q1
az
03
Q4
Sales $1,860 $2,160 $1,860 $1,560
Sales for the first quarter of the following year are projected at $2,190. Calculate the
company's cash outleys by completing the following: (Do not round intermediate
calculations and round your answers to 2 decimal places, e.g., 32.16.)
Payment of accounts
Wages, taxes, other expenses
Long-term financing expenses (interest and dividends)
Q1
Q2
Q3
Q4

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Preparation of budget

VIEW

Step 2: Workings in Preparation of budget

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

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?
4. Sovereign-Tea Company projected to make even monthly cash payments of P150,000 during the year. The average return on money market placements is eight percent per annum and payment for cash transfer is expected to be P250 per transaction. Determine the total relevant cost using the Baumol Model.
AB Company’s budgeted sales and cost of sales for the coming year are P72 million and P45 million respectively. Shortterm interest rates are expected to average 10%. If the company can increase inventory turnover from its current levelof 9 times per year to 12 times per year, its cost savings in the coming year are expected to beA. P125,000 C. P375,000B. P300,000 D. P500,000
The demand for a product during the next ten years will be such that revenues will be $100,000 the first year and will increase by $10,000 each year thereafter. If inflation is assumed to be 6% per yuear and the company uses 10% in its economic studies, what is the present worth of the revenues expressed in present dollars?
Projected annual sales of a LED keychain are projected to be 25,00025,00025,000 USD the first year and increase by 10,00010,00010,000 USD per year until 55,00055,00055,000 USD are sold during the fourth year. Sales are then predicted to decrease by 5,0005,0005,000 USD per year in the fifth year and each year thereafter until 25,00025,00025,000 USD are sold in the tenth year. Firm is going to purchase manufacturing equipment costing 100,000100,000100,000 USD with an estimated salvage value of 20,00020,00020,000 USD at the end of 10 years. The variable manufacturing cost per unit is 0.80.80.8 USD. If the interest rate is 9%9\%9%, what is the Present Equivalent cost for a 10-year production period?
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?
Simpson Corporation expects to sell the following number of units of their newest product: Year Unit Sales 1 8,000 2 9,000 3 12,000 4 15,000 The revenue per unit is $180. NWC starts out at $50,000, then rises to 15% of sales. What is the change in cash flow for the NWC balance at the end of year 2?
Data are as follows: In year 2020, sales are 150,000 units with Selling price per unit of 10 and VC per unit iof 6.50 per unit. Fixed cost is 155,000 and Interest cost is 90,000. Q3. Assume that the company expects to have sales increase by 20%, what will be the resulting change in EBIT in year 2021? • 28.38% • 26.45% • 25% • 33.33%
It is December 31. Last year, Galaxy Corporation had sales of $80,000,000, and it forecasts that next year's sales will be $86,400,000. Its fixed costs have been-and are expected to continue to be-$44,000,000, and its variable cost ratio is 10.00 %. Galaxy's capital structure consists of a $15 million bank loan, on which it pays an interest rate of 12%, and 5,000,000 shares of outstanding common equity. The company's profits are taxed at a marginal rate of 35%. The following are the two principal equations that can be used to calculate a firm's DFL value: DFL (at EBIT = $X) = Given this information, complete the following sentences: Percentage Change in EPS Percentage Change in EBIT Consider the following statement about DFL, and indicate whether or not it is correct. 0 0 DFL (at EBITSX) = • The company's percentage change in EBIT is . The percentage change in Galaxy's earnings per share (EPS) is • The degree of financial leverage (DFL) at $86,400,000 is. (Hint: Use the changes in EPS…
Data are as follows: In year 2020, sales are 150,000 units with Selling price per unit of 10 and VC per unit iof 6.50 per unit. Fixed cost is 155,000 and Interest cost is 90,000. Q3. Assume that the company expects to have sales increase by 20%, what will be the resulting change in EBIT in year 2021?(2 Points) • 28.38% • 33.33% • 25% • 26.45%
Data are as follows: In year 2020, sales are 150,000 units with Selling price per unit of 10 and VC per unit iof 6.50 per unit. Fixed cost is 155,000 and Interest cost is 90,000. Q3. Assume that the company expects to have sales increase by 20%, what will be the resulting change in EBIT in year 2021? A• 25% B• 26.45% C• 33.33% D• 28.38%
Hurkin Manufacturing Company pays accounts payable on the tenth day after purchase. The average collection period is 30 days, and the average age of inventory is 40 days. The firm currently has annual sales of about $18 million and purchases of $14 million. The firm is considering a plan that would stretch its accounts payable by 20 days. If the firm pays 12% per year for its resource investment, what annual savings can it realize by this plan? Assume a 360- day year.