Barnum Stores has six locations. The firm wishes to expand by two more stores and needs...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Barnum Stores has six locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr Barnum, the banker, will finance construction if the firm can present an acceptable three- month financial plan for January through March. The following are actual and forecasted sales. Actual sales October: $280'000 November: $280'000 December: $280'000 Forecasted sales January: $350'000 February: $350'000 March: $300'000 April: $380'000 Of the firm's sales, 40 percent are for cash and the other 60 percent are on credit. Of credit sales, 30 percent are paid in the month after sale, 30 percent are paid in the second month after sale and 30% are paid in the third month after the sale (10% of the credit sales are not collected). Material cost 40 percent of sales and are paid during the month of the respective sales. Labor expense is 30 percent of sales and is paid for in the month of sales. Selling and administrative expense is 6 percent of sales and is also paid in the month of sales. Overhead expense is $25'000 in cash each month. Depreciation expense is $10'000 per month. Taxes of $12'000 for the year will be paid in advance in January and dividends of $2'000 will be paid in March. Cash at the beginning of January is $80'000 and the minimum cash balance that the firm needs to have is $75'000. If needed, the firm may have to borrow to maintain this minimum level of cash, while it repays the loan as soon as possible. For January, February and March, prepare: - a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cash budget with borrowings and repayments (use the Excel table provided, make sure that you use Excel formulas) - a budgeted income statement, showing gross profit, operating income (EBIT) and net income (assuming interest expense is zero). Assume that Material purchased represents the COGS (i.e. it is sold during the month when it is purchased); (1 point) - a flexible budget for $460'000 on the basis of the month of March, showing gross profit and operating income (EBIT). Assume that only COGS is variables, the other costs are fixed; (1 point) Barnum Stores has six locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr Barnum, the banker, will finance construction if the firm can present an acceptable three- month financial plan for January through March. The following are actual and forecasted sales. Actual sales October: $280'000 November: $280'000 December: $280'000 Forecasted sales January: $350'000 February: $350'000 March: $300'000 April: $380'000 Of the firm's sales, 40 percent are for cash and the other 60 percent are on credit. Of credit sales, 30 percent are paid in the month after sale, 30 percent are paid in the second month after sale and 30% are paid in the third month after the sale (10% of the credit sales are not collected). Material cost 40 percent of sales and are paid during the month of the respective sales. Labor expense is 30 percent of sales and is paid for in the month of sales. Selling and administrative expense is 6 percent of sales and is also paid in the month of sales. Overhead expense is $25'000 in cash each month. Depreciation expense is $10'000 per month. Taxes of $12'000 for the year will be paid in advance in January and dividends of $2'000 will be paid in March. Cash at the beginning of January is $80'000 and the minimum cash balance that the firm needs to have is $75'000. If needed, the firm may have to borrow to maintain this minimum level of cash, while it repays the loan as soon as possible. For January, February and March, prepare: - a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cash budget with borrowings and repayments (use the Excel table provided, make sure that you use Excel formulas) - a budgeted income statement, showing gross profit, operating income (EBIT) and net income (assuming interest expense is zero). Assume that Material purchased represents the COGS (i.e. it is sold during the month when it is purchased); (1 point) - a flexible budget for $460'000 on the basis of the month of March, showing gross profit and operating income (EBIT). Assume that only COGS is variables, the other costs are fixed; (1 point)
Expert Answer:
Answer rating: 100% (QA)
Answer To prepare the schedule of monthly cash receipts monthly cash payments and a complete monthly ... View the full answer
Related Book For
Foundations of Financial Management
ISBN: 978-1259194078
15th edition
Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen
Posted Date:
Students also viewed these accounting questions
-
A. Construya su Pedigr Familiar. Investigue en su familia una enfermedad que ms se repita. (10 puntos) Puedes utilizar este enlace para Construir su Pedigr Familiar
-
The following additional information as at 31 May 2019 is available: i)Inventories as at the close of business were valued at RM25,900. ii)Depreciation for the year ended 31 May 2019 has yet to be...
-
Harrys Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mr. Wilson, the banker, will finance construction if the firm can present an...
-
Three friends are choosing a restaurant for dinner. Here are their preferences: a. If the three friends use a Borda count to make their decision, where do they go to eat? b. On their way to their...
-
Suppose the growth rate of Europes money supply exceeds the ECBs reference value, leading the ECB to raise its interest-rate target. Will this action push money growth toward the reference value?...
-
(a) What are the two primary characteristics of skilled hackers? (b) Why are script kiddies dangerous? (Give two reasons.) (c) Why are malware and exploit toolkits expanding the danger of script...
-
Trade at Chinas Domestic Price. Chinas domestic price is 10 containers of toys equals 7 cases of wine. Assume China produces 10,000 containers of toys and exports 2,000 to France. Assume France...
-
Scruffy Murphy is the president and principal stockholder of Scruffys Bar & Grill, Inc. To expand, the business is applying for a $250,000 bank loan. To get the loan, Murphy is considering two...
-
The following events occur for The Underwood Corporation during 2021 and 2022, Its first two years of operations. June 12, 2021 Provide services to customers on account for $39,800. September 17,...
-
Cash Accounts Receivable Inventory Total Current Assets Fixed Assets Wisdom Company Statement of Financial Position December 31, 2020 ASSETS 100,000 200,000 200,000 500,000 500,000 1,000,000 TOTAL...
-
An operational audit performed by an internal auditor is best described as a. An audit of a companys compliance with managements policies and procedures. b. An evaluation of a companys operations to...
-
Mention the circumstances under which an investigation of a company can be ordered by the central government? What should be the procedure of investigation in such a case?
-
What is the role of the AICPA in setting accounting and auditing standards and in policing the profession to ensure the performance of high-quality services by members of the public accounting...
-
Review the discussion of the difference between leadership and management in Chapter 12. Discuss the role of power in effective leader or manager behavior.
-
Explain how the concept of accountability drives the governmental audit profession.
-
Psaki Inc. manufactures and sells a single product called a Shiner. Operating at capacity, the company can produce and sell 22,000 Shiners per year. Costs associated with this level of production and...
-
The diagram shows the two forces acting on a small object. Which of the following is the resultant force on the object? A. 8 N downwards B. 8 N upwards C. 2 N downwards D. 2 N upwards 3 N 5 N
-
Tyson Company bottles and distributes NO-KAL, a diet soft drink. The beverage is sold for 40 cents per 16-ounce bottle to retailers, who charge customers Instructions (a) Prepare a CVP income...
-
ABC, Inc. has a target debt-equity ratio of 0.4. Its cost of equity is 16 percent and its cost of debt is 8 percent. If the tax rate is 32 percent, what is ABC's WACC? a. 10.3847% b. 11.6723% c....
-
Assuming they have the same (positive) expected rate of return, which of the following investments should be cheapest? a. One that promises to pay you $100 in five years. b. One that promises to pay...
Study smarter with the SolutionInn App