Suppose a firm has had the following historic sales figures.Year:2016Sales $1,420,0002017$1,720,000Next year's sales201820192020$1,600,000 $2,010,000 $1,770,000What 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.27

Forecasting refers to the measure of the possible performance of an asset. It is usually calculated…

Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 Sales $1,420,000 $1,720,000 $1,600,000 $2,010,000 2020 $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. Next year's sales

Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 Sales $1,420,000 $1,720,000 $1,600,000 $2,010,000 2020 $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. Next year's sales

Pfin (with Mindtap, 1 Term Printed Access Card) (mindtap Course List)

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter11: Investment Planning

Section: Chapter Questions

Problem 7FPE: Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for...

See similar textbooks

Similar questions

The following are the calendar year rates of return for a S&P 500 ETF (Ticker: IVV) between 2013 and 2017. Year IVV 2013 29.60% 2014 11.39% 2015 -0.73% 2016 9.54% 2017 19.42% What is the geometric mean rate of return? Round to the nearest 0.01, in percentage terms.
The Dow Jones Industrial Average had the following annual returns: Year Return 2019 22.3% 2020 7.3% 2021 19% 2022 -8.7% Using just these last 4 years of data, what is the expected return for the Dow Jones? What is the standard deviation of the returns? Please show and explain your work.
Here are alphas and betas for Company X and Company Y for the 60 months ending April 2019. Alpha is expressed as a percent per month. A month later, the market is up by 5%, X is up by 6% and Y is up by 3%. (3a) What is the abnormal rate of return for X and Y? ] Alpha Beta X 0.57 1.08 Y 0.46 0.65 The table below shows a condensed income statement and balance sheet for a plant. Income Statement Assets at 31 December 2018 Revenue 56.66 Net working capital 7.08 Raw materials cost 18.72 Operating cost 21.09 Depreciation Investment plant & equipment 69.33 4.50 Less accumulated depreciation Net plant & equipment 21.01 Pretax income 12.35 48.32 Tax at 35% 4.32 Net income 8.03 Total assets 55.40 (3b) Calculate the plant's EVA. Assume the cost of capital is 9%. (3c) Assume now that the plant could be sold to another company for $95 million. How should this fact change your calculation of EVA? Explain your answer
Assuming that all sales were on account, calculate the following risk ratios for 2024. Risk Ratios1. Receivables turnover ratio 38.3 times2. Average collection period 9.5 days3. Inventory turnover ratio 15.1 times4. Average days in inventory 24.2 days5. Current ratio 4.0 6. Acid-test ratio ? 7. Debt to equity ratio ? %8. Times interest earned ratio ? times
For the companies Lockheed-Martin (LMT) & Northrop-Grumman (NOC) Use Macrotrends data to calculate Return on Sales, Return on Assets, Debt Ratio, Inventory Turnover, Lead Time for each company Use Fintel to determine EPS forecasts for 2024-2027 for each company, and use those to calculate an average earnings growth rate for each - https://fintel.io/sfo/us/Imt https://fintel.io/sfo/us/noc Assuming MARR = WACC + 3%, calculate a fair market price for the stock of each company, assuming that earnings grow at the calculated rate for the next 50 years, with the following WACC LMT: NOC: 8.00% 8.25% Find the current stock price for each company Based on the above calculations, which company's stock would you buy, and provide your reasoning (If neither or both, explain reasoning)
Suppose a company has had the historic sales figures shown below. What would be the forecast for next years sales using the average approach?
Use the following information to calculate your company's expected return. State Probability Return Boom 20% 0.42 Normal 60% 0.13 Recession 20% -0.19 Round to two decimal places.
What is Microsoft's market value in billion dollars for fiscal year ending in June 2020? What is the market-to-book ratio for MSFT for fiscal year ending in June 2021, 2020. What is the ROE in percentage for MSFT for fiscal year ending in June 2021, 2020.
Suppose we want to compute the four-quarter moving average of Company ABC’s sales as of the beginning of the first quarter of 2022. ABCs sales in the previous four quarters were as follows: 1Q 2021, R 1,200,000; 2Q 2021, R 800,000; 3Q 2021, R 750,000; and 4Q 2021, R 1,600,000. Calculate the four-quarter moving average of sales as of the beginning of the first quarter of 2022.
Question: Calculate the average annual growth rate of Microsoft from the fiscal year ending 2009 until the fiscal year ending. EBIT 2009 - 2019: 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 42,933,000 35,011,000 31,315,000 26,236,000 20,489,000 27,780,000 26,556,000 21,763,000 27,161,000 24,157,000 20,363,000 Is 9.34% correct?
Using data available in the case, calculate the annual growth rate from 2020 to 2021 (in percentages). All calculations should be rounded to two decimals (e.g., 12.77%). > Answer is complete but not entirely correct. 2021 2020 2020-2021 Revenue 2,057,622 1,736,432 18.50 % Cost of Goods Sold 1,259,830 921,980 36.64 % Gross Profit 797,792 814,452 (1.02) % Operating Expenses 789,795 570,245 38.50 % Operating Income 7,997 244,207 2,953.73% Net Income 14,553 191,960 (92.42) %
Q. Using 2008 as the base year, prepare a trend analysis of the following data, and tell whether the situation shown by the trends is favorable or unfavorable. (Round your answers to one decimal place.). 2012 2011 2010 2009 2008 Net sales $25,520 $23,980 $24,200 $22,880 $22,000 Cost of goods sold 17,220 15,400 15,540 14,700 14,000 General and administrative expenses 5,280 5,184 5,088 4,896 4,800 Operating income 3,020 3,396 3,572 3,284 3,200