Fundamentals Of Financial Management, Concise Edition (mindtap Course List)
10th Edition
ISBN: 9781337902571
Author: Eugene F. Brigham, Joel F. Houston
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 16, Problem 6P
Summary Introduction
To compute: The sales
Introduction:
Sales Forecast:
Sales forecast is the important point that arises while making the future plans. The management generally takes 5 years financial records and then studies it and decides the amount of turnover for the current and upcoming years.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Problem: Jasper Jewelry has $150 million in sales. The company expects that its sales will increase 4% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level for a given level of projected sales. On the basis of recent history, the estimated relationship between inventories and sales (in millions of dollars) is as follows:
Inventories = $10 + 0.07(Sales)
Given the estimated sales forecast and the estimated relationship between inventories and sales, what is your forecast of the company's year-end inventory level? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Do not round intermediate calculations. Round your answer to two decimal places.
Jace Furnishings has $325 million in sales. The company expects that its sales will increase 8% this year. Jace's CFO uses a simple linear regression to forecast the company's inventory level for a given level of projected sales. On the basis of recent history, the estimated relationship between inventories and sales (in millions of dollars) is as follows:
Inventories = $30 + 0.105(Sales)
Given the estimated sales forecast and the estimated relationship between inventories and sales, what are your forecasts of the company's year-end inventory level? Write out your answer completely. For example, 5 million should be entered as 5,000,000. Do not round intermediate calculations. Round your answer to the nearest dollar.$
What are your forecasts of the company's year-end inventory turnover ratio? Do not round intermediate calculations. Round your answer to two decimal places. x
Jasper Jewelry has $150 million in sales. The company expects that its sales will increase 5% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level for a given level of projected sales. On the basis of recent history, the estimated relationship between inventories and sales (in millions of dollars) is as follows:
Inventories = $11 + 0.07(Sales)
Given the estimated sales forecast and the estimated relationship between inventories and sales, what is your forecast of the company's year-end inventory level? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Do not round intermediate calculations. Round your answer to two decimal places.$ million
Chapter 16 Solutions
Fundamentals Of Financial Management, Concise Edition (mindtap Course List)
Ch. 16 - Prob. 1QCh. 16 - Assume that an average firm in the office supply...Ch. 16 - Would you agree that computerized corporate...Ch. 16 - Certain liability and net worth items generally...Ch. 16 - Suppose a firm makes the following policy changes....Ch. 16 - AFN EQUATION Carlsbad Corporations sales are...Ch. 16 - AFN EQUATION Refer to Problem 16-1. What...Ch. 16 - AFN EQUATION Refer to Problem 16-1 and assume that...Ch. 16 - PRO FORMA INCOME STATEMENT Austin Grocers recently...Ch. 16 - EXCESS CAPACITY Williamson Industries has 7...
Ch. 16 - Prob. 6PCh. 16 - PRO FORMA INCOME STATEMENT At the end of last...Ch. 16 - LONG-TERM FINANCING NEEDED At year-end 2019, total...Ch. 16 - SALES INCREASE Paladin Furnishings generated 4...Ch. 16 - REGRESSION AND RECEIVABLES Edwards Industries has...Ch. 16 - REGRESSION AND INVENTORIES Charlies Cycles Inc....Ch. 16 - Prob. 12PCh. 16 - ADDITIONAL FUNDS NEEDED Morrissey Technologies...Ch. 16 - EXCESS CAPACITY Krogh Lumbers 2019 financial...Ch. 16 - Prob. 1TCLCh. 16 - FORECASTING THE FUTURE PERFORMANCE OF ABERCROMBIE ...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? Year: 2009 2010 2011 2012 2013 Sales $1,500,000 $1,750,000 $1,400,000 $2,000,000 $1,600,000arrow_forwardSuppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013 Sales $1,420,000 $1,720,000 $1,600,000 $2,010,000 $1,770,000 What would be the forecast for next year's sales using regression to estimate a trend? Next year's salesarrow_forwardSuppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013 Sales $3,300,000 $3,550,000 $3,200,000 $3,800,000 $3,400,000 What would be the forecast for next year's sales using the average approach? Next year's salesarrow_forward
- Suppose a firm has had the following historic sales figures. Year: 2016 Sales $1,420,000 2017 $1,720,000 Next year's sales 2018 2019 2020 $1,600,000 $2,010,000 $1,770,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. 27arrow_forwardFairchild Garden Supply expects $580 million of sales this year, and it forecasts a 15% increase for next year. The CFO uses this equation to forecast inventory requirements at different levels of sales: Inventories = $30.2 + 0.25(Sales). All dollars are in millions. The firm's cost of goods sold is expected to be 70% of sales. What is the projected inventory turnover ratio for the coming year? Please explain process and show calculations.arrow_forwardGrant Communications is forecasting its financial statements for the upcoming year. Highlights include: Current assets of $6 million Current ratio of 2.0 Sales of $20 million Inventory turnover ratio (Sales/Inventory) of 6 The company's CFO is concerned about the forecasted inventory turnover ratio. Her goal is cut inventory enough to obtain an inventory turnover ratio of X, which is the industry average, while still maintaining sales at $20 million. If the company can accomplish this goal, the cash generated from the cut in inventories will be used to cut accounts payable. This will give the firm a Quick Ratio [(Current Assets - Inventory) / Current Liabilities] of 1.50. What is X, the desired inventory turnover ratio? Enter your answer, truncated to 2 decimal places. For example, enter 7.777 as 7.77.arrow_forward
- This year, ABC expects sales of $137,328,000 and a gross profit margin of 16 percent this year, along with an Inventory Turnover Ratio (COGS Basis) of 6.10. What is ABC's projected level of inventory, given these numbers?arrow_forwardUse the following information to determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) ($ thousands) CurrentYear PriorYear Net sales $ 453,100 $ 230,000 Cost of goods sold 222,019 68,080 Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Trend Percent Current Year: / = % Prior Year: / = %arrow_forwardSuppose a firm has had the following historic sales figures. Year: 2009 2010 2011 2012 2013 Sales $2,600,000 $2,850,000 $2,500,000 $3,100,000 $2,700,000 What would be the forecast for next year's sales using the naive approach? Next year's salesarrow_forward
- Suppose a company has had the historic sales figures shown below. What would be the forecast for next years sales using the average approach?arrow_forwardYour company has sales of $97,200 this year and cost of goods sold of $71,200. You forecast sales to increase to $113,100 next year. Using the percent of sales method, forecast next year's cost of goods sold.arrow_forwardSuppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? You must use the built-in Excel function to answer this question. Input area: Year Sales 2016 2017 2018 es es e $ 1,500,000 $ 1,750,000 $ 1,400,000 2019 $ 2,000,000 2020 $ 1,600,000 Output area: Next year's salesarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license