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 net cash flow for December is coming up incorrect. Would you be able to let me know what the formular or the correct number is?
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.
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 year
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
- Which 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_forwardPrice Mart is considering outsourcing its billing operations. A consultant estimates that outsourcing should result in cash savings of $9,500 the first year, $15.500 for the next two years, and $18,500 for the next two years. Interest is at 10%. Assume cash flows occur at the end of the year. Required: Calculate the total present value of the cash flows. Note: Use tables, Excel, or a financial calculator. Do not round intermediate calculations. Round your final answer to nearest whole dollar. (FV of $1. PV of $1. FVA of $1. PVA of $1, EVAD of $1 and PVAD of $1) Total present value of the cash flowsarrow_forwardHow would answer this question? You are estimating your company's external financing needs for the next year. Your first-pass pro forma financial statements showed a large financing deficit for next year. Which of the following changes to your company's operating plan would reduce the financing deficit if incorporated in revised pro forma financial statements? None of the options are correct. Increase cost of goods sold as a percentage of sales Increase the dividend payout ratio Increase the sales growth rate Reduce the collection periodarrow_forward
- Suppose the government announces that, based on a just-completed survey, the growth rate in the economy is likely to be 2 percent in the coming year, as compared to 5 percent for the past year. Will securityprices increase, decrease, or stay the same following this announcement? Does it make any difference whether the 2 percent figure was anticipated by the market? Explain.arrow_forwardBulldogs inc. will least likely experience which of the following if the firm shifts its credit terms from n/25 to 3/10, n/25 a. the computed days sales outstanding will decrease b. the percentage of credit sales from the total sales revenue will increase c. cash conversion cycle will tend to increase d. decrease in short-term borrowingsarrow_forwardA company expects sales to increase during the coming year, and it is using the AFN equation to forecast the additional capital that it must raise. Which of the following conditions would cause the AFN to DECREASE? Group of answer choices: The company begins to pay employees weekly rather than monthly. The company decides to take discounts on purchased materials. The company’s profit margin increases. The company learns that it has no excess capacity. The company increases its dividend payout ratio.arrow_forward
- You have recently been hired to improve the performance of Multiplex Corporation, which has been experiencing a severe cash shortage. As one part of your analysis, you want to determine the firm's cash conversion cycle. Using the following Information and a 365-day year, your estimate of the firm's current cash conversion cycle would be __________days Current Inventory = P120,000. Accounts receivable = P157,808. Accounts payable = P25,000. Annual sales P600,000. Total annual purchases = P365,000. Purchases credit terms: net 30 days. Receivables credit terms: net 50 days. O 100 O 49 O 144 O 168arrow_forwardWhy is it important for start-up businesses to come up with monthly cash flow projections, especially during first year?arrow_forwardA)What is the amount of RSA, RSL and the income gap amount? B) Calculate the duration gap. C)What is the change in this bank’s net income if the interest rises by 1%, does it go up or does it go down? Show work D) What happens when the interest rises by 1% to this bank’s asset value, liability value and the net worth in dollar amounts? Show work.arrow_forward
- The Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm is expecting a 30 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales. Sales Expenses Earnings before interest and taxes Interest Earnings before taxes Taxes Earnings after taxes Dividends Current assets Income Statement Cash Accounts receivable Inventory Fixed assets Total assets Assets The firm $ 250,000 184,800 $ 65,200 8,600 $ 56,600 16,600 $ 40,000 $ 16,000 Balance Sheet (in $ millions) $ 221,000 Liabilities and Stockholders' Equity $ 4,000 Accounts payable Accrued wages 53,000 68,000 Accrued taxes $ 125,000 96,000 Current liabilities Notes payable Long-term debt…arrow_forwardThe Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm is expecting a 30 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales. Sales Expenses Earnings before interest and taxes Interest Earnings before taxes Taxes Earnings after taxes Dividends Cash Accounts receivable Inventory Current assets Fixed assets Income Statement Total assets Assets $ 280,000 222,800 $ 57,200 7,800 $ 49,400 15,800 $ 33,600 $ 6,720 Balance Sheet (in $ millions) Liabilities and Stockholders' Equity $ 5,000 Accounts payable Accrued wages 86,000 77,000 Accrued taxes $ 168,000 88,000 Current liabilities Notes payable Long-term debt Common stock Retained…arrow_forwardUpon further investigation, you hare found that the amount of account payables for Companies A and X at the start of the year is 20,000 and 30,000, respectively. Apart from that, the amount of credit purchase for Companies A and Bis 250,000 and 280,000, respectively. Based on all this information, recommend on which company that gire lower risk to your company. The recommendation must be ustified by the following analysis:. a) Liquidity analysis. b) Solvency analysis. c) Any other financial analysis that you. think can help in making your decision. Table: Balance Sheet for Company A and Company B Assets 280,000 110,000 140,000 100,000 100,000 730,000 Fixed Assets Other Non-Current Assets 250,000 80,000 120,000 80,000 120,000 650,000 Account Receivables Inventory Cash ТОTAL Liabilities Capital Long Term Debt Account Payables Other Current Liabilities ТОTAL 250,000 120,000 160,000 120,000 650,000 280,000 140,000 180,000 130,000 730,00arrow_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