Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem 4R
Suppose the company has to revise its estimates because of a downturn in the economy. Unit sales for August, September, and October will be half (50%) of the original estimates. Revise the estimates in cells 1311 through 1313. After this is done, check your
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The financial manager of Company X has just received the sales forecast for next year and it indicates that the year's sales are expected to double in the second half. What are the challenges that Company X might face in increasing its production to meet the sales projections and how can these challenges be overcome? What risks does Company X face by ramping-up production to meet the sales forecast?
Which of the following is the most correct?
A. In reference to the time value of money, the present value is always labeled as t=1
B. Negative MVAs indicate that a company's executives are managing the expenses well
C. Nominal rates, or annual percentage rates, always equal the effective annual rate
D. A strong ROE always indicates a strong year for a company
E. Firms should generally try to minimize their days' sales outstanding in order to access their receivables at fast rates.
Jefferson City Computers has developed a forecasting model to determine the additional funds it needs
in the upcoming year. All else being equal, which of the following factors is likely to increase its additional
funds needed (AFN)?
A sharp increase in its forecasted sales and the company's fixed assets are at full capacity.
A reduction in its dividend payout ratio.
The company reduces its reliance on trade credit that sharply reduces, its accounts payable.
Statements a and b are correct.
Statements a and c are correct.
Chapter 22 Solutions
Excel Applications for Accounting Principles
Ch. 22 - Ranger Industries has provided the following...Ch. 22 - Open the file MASTER from the website for this...Ch. 22 - Review the completed master budget and answer the...Ch. 22 - Suppose the company has to revise its estimates...Ch. 22 - Suppose the company has just the opposite news and...Ch. 22 - Prob. 6R
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- The finance staff at Millcreek Company have constructed a forecast of the company’s net income.The chief executive officer (CEO) of Millcreek wonders why the forecast of next year’s interestexpense is the same as this year’s interest expense, whereas next year’s sales are expected toincrease by 20% over this year’s sales. What is the most likely explanation?a) Millcreek is expected to be more aggressive at minimizing its income tax expense next yearb) Millcreek expects its operating expenses to increase by 20% next year, the same as the expectedincrease in salesc) Millcreek is not expected to obtain any new loans next year, not repay any old loansd) Millcreek expects its operating expenses to increase by more than 20% increase in salesexpected next yeararrow_forwardProvident Manufacturing recently began paying all of its invoices within 20 days of receipt, rather than its usual 30 days. How would this adjustment likely affect Provident's chances of receiving a bank loan in the near future? Provident would be less likely to receive a loan, because this adjustment would reduce the firm's current liabilities to a lower level than most banks like to see. O Provident would be less likely to receive a loan, because this adjustment suggests the firm does not anticipate having enough money to pay its debts in the months to come. O Provident would be more likely to receive a loan, because this adjustment would maximize the firm's current liabilities while minimizing its use of long-term debt. O Provident would be more likely to receive a loan, because this adjustment would minimize the firm's current liabilities while also showing the firm's ability to promptly pay off short-term debts.arrow_forwardWhich of the following transactions would decrease total current assets, increase the current ratio, and have no effect on net income? Borrow using short-term debt and use the proceeds to repay debt that has a maturity of more than one year. O Federal income tax due for previous year is paid. O Use cash to repurchase some of the company's own stock. O Marketable securities are sold below cost.arrow_forward
- Data on Shick Inc. for last year are shown below, along with the days sales outstanding of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365 day year. Do not round yourData on Shick Inc. for last year are shown below, along with the days sales outstanding of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365-day year. Do not round your intermediate calculations. Sales $103, 000 Accounts receivable $16,000 Days Sales Outstanding (DSO) 56.699 Benchmarks' Days Sales Outstanding (DSO) 19.000 a. $9,805 b. $11,471 c. $10, 638 d. $4,529arrow_forwardThe following information pertains to Striker Corporation, together with its DSO of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO/ACP to the benchmarks’ average. If this were done, by how much would receivables decline? Use a 365-day year. Sales=P110,000; Accounts receivable= P16,000; Days sales outstanding (DSO/ACP)=53.09; Benchmark days sales outstanding (DSO/ACP)=20.00 *arrow_forwardHamish plc expects to have an overdraft at the end of the next financial year. Which one of the following courses of action would increase the bank overdraft? Select one: A. Increasing the credit period allowed to customers. B. Reducing the level of inventory held. OC. Renting, instead of purchasing, the new company vans. D. Increasing the time taken to pay suppliers.arrow_forward
- Use the "percent of sales method" of preparing pro forma financial statements to determine the projection for next year's accounts receivable. Make the following assumptions: current year's sales are $55,750,000; current year's cost of goods sold is $25,350,000; sales are expected to rise by 25%, The firm's investment in accounts receivable in the current year is $12,600,000. The firm's marginal tax rate is 35%. What is the projection for next year's accounts receivable? $10,320,000 $11,345,000 O $15,750,000 $8,772,000arrow_forwardThe following information pertains to Striker Corporation, together with its DSO/ACP of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO/ACP to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365-day year. Sales=P110,000; Accounts receivable= P16,000; Days sales outstanding (DSO/ACP)= 53.09; Benchmark days sales outstanding (DSO/ACP)=20.00 * P 8,078 O P 8,975 P 9,973 P10,970 P12,067arrow_forwardd. Bowers’ sales are seasonal, and her company produces on a seasonal basis, just aheadof sales. Without making any calculations, discuss how the company’s current anddebt ratios would vary during the year if all financial requirements were met withshort-term bank loans. Could changes in these ratios affect the firm’s ability to obtainbank credit? Explain.arrow_forward
- Why is it important for start-up businesses to come up with monthly cash flow projections, especially during first year?arrow_forwardA Zack Firm is evaluating an Accounts Receivable Change that would increase Bad Debts from 2% to 4% of Sales. Sales are currently 50,000 units, the selling price is $20 per unit, and the Variable Cost per unit is $15. As a result of the proposed change, sales are forecast to increase to 60,000 units. A. What are Bad Debts in Dollars currently? (Format: 11,111) B. What are Bad Debts in Dollars under the Proposed Change? (Format: 11,111) C. Calculate the Cost of the Marginal Bad Debts to the firm. (Format: 11,111)arrow_forwardYour company forecasts that next year's sales will be $67.00 million and the Days Sales Outstanding (DSO) ratio will be 24.71. What is the forecasted accounts receivable for next year? Note: your answer should in millions of dollars.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Business/Professional Ethics Directors/Executives...AccountingISBN:9781337485913Author:BROOKSPublisher:Cengage
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Business/Professional Ethics Directors/Executives...
Accounting
ISBN:9781337485913
Author:BROOKS
Publisher:Cengage
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY