Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,530,000 $1,720,000 $1,560,000 $2,100,000 $1,850,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.

Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,530,000 $1,720,000 $1,560,000 $2,100,000 $1,850,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.

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter4: Time Value Of Money

Section4.2: Future Values

Problem 4ST

See similar textbooks

Related questions

Q: mos has one share of stock and one bond. The total value of the two securities is $1,110.00.The bond…

A: Price of bond is the present value of coupon payment plus present value of par value of the bond.

Q: Rate ?? 6.052 6.143 Maturity Month/Year May 32 May 37 May 47 Bid Asked 103.5410 103.5288 104.4900…

A: A bond is a kind of debt security issued by the government and private companies to the public for…

Q: A firm has net working capital of $25,089. Long-term debt is $106,286.6, total assets are $151,838,…

A: Total liabilities will be equal to the sum of the current liabilities and long-term liabilities of…

Q: Calculate yields on 3-month T-bills the T-bills have a maturity value (1 Price (PB) of a 3-Month…

A: Tbills are issued by federal government to give liquidity and maintain liquidity in the financial…

Q: Emusk Inc. is evaluating two mutually exclusive projects. The required rate of return on these…

A: Project BCash Flow for Year 0 = cf0 = -15,000,000Cash Flow for Year 1 = cf1 = 6,000,000Cash Flow for…

Q: The sisyphean company has a bond outstanding with a face value of $1,000 that reaches maturity in 15…

A: The objective of this question is to calculate the Yield to Maturity (YTM) for a bond. The YTM is…

Q: The Burb Corporation is evaluating the following project. The CFO has determined that the…

A: YearCF0-40,000,00014,000,000220,000,000320,000,000411,000,000Discount rate = 12%

Q: son.1

A: The objective of the question is to calculate the present value of an annuity. An annuity is a…

Q: Your firm has a credit rating of A. You notice that the credit spread for five year maturity A debt…

A: Financial instruments known as bonds are loans made by investors to borrowers, usually corporations…

Q: 4. Suppose that there are 2 assets with ri 012 = 0.005. = 0.20, 01 = = 0.40, 2 = 0.10, 02 = 0.25 and…

A: The objective of the question is to calculate the market portfolio return and variance, and the…

Q: Let's consider a company is evaluating a potential investment project: The Project requires an…

A: The objective of this question is to calculate the Internal Rate of Return (IRR) for a potential…

Q: Maynard enterprises paid $ 1,384 in dividends and $1,067 in interest over the past year.The common…

Q: You are evaluating a project for The Farstroke golf club, guaranteed to correct that nasty slice.…

A: The objective of the question is to calculate the change in Net Working Capital (NWC) at the end of…

Q: Durante los últimos 10 años, Orlando, Florida, ha crecido rápidamente,gracias a la generación de…

A: El objetivo de la pregunta es entender por qué, a pesar del crecimiento de la población y del…

Q: klp.1

A: The objective of this question is to find the nominal interest rate necessary to earn a specific…

Q: Och Inc. is considering a project that will result in initial after-tax cash savings of $4.2 million…

A: The weighted average cost of capital is a metric used to evaluate the average cost that the company…

Q: Suppose that call options on XYZ stock with time to expiration 3 months and strike price $90 are…

A: The question is based on the concept of valuation of call option by Black & Scholes model and…

Q: Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 -$ 15,530…

A: Project ACash Flow for Year 0 = cf0 = -$243,567Cash Flow for Year 1 = cf1 = $27,200Cash Flow for…

Q: 1. Ten years ago, Marky Inc's 7.5% bonds were issued with a maturity of 20 years (annual coupons).…

A: Old bond coupon rate = 7.5%Maturity = 20 yearsCurrent price = $1013.03.New bond maturity = 10…

Q: Baghiben

A: The objective of the question is to calculate the Adjusted Present Value (APV) of a project for Gila…

Q: Consider the following returns and states of the economy for TZ.Com.: EconomyProbabilityReturn Weak…

A: The expected return is the product of the probability and returns of the investment.Information…

Q: Laura wants to buy a delivery truck. The truck costs $71,000, and will allow her to increase her…

A: SOLUTION:APV ApproachThe APV method separates the financing effects from the pure operational…

Q: a. If an investor had 5,750 shares before the split, how many shares will the investor have after…

A: In reverse stock split the small stocks are converted into large single stock to increase value of…

Q: Let's imagine that the OIS rates for one year and two years are 2% and 4% respectively. Now, let's…

A: Dear student, kindly check the answer in the explanation box below.Explanation:Part 1: Answer:The…

Q: Consider that you are 45 years old and have just changed to a new job. You have $156,000 in the…

A: Present Value = pv = $156,000Payment = p = $7800Rate of Return = r = 8%Time = t = 20

Q: the U.S. dollar over the next 30 days. You will be making payment on a shipment of imported goods in…

A: Hedging is take opposit position in forward/future market to prevent loss in the spot market.

Q: Assume that you contribute $300 per month to a retirement plan for 15 years. Then you are able to…

A: Future value (FV) in the back signifies the anticipated worth of a venture or resource at an…

Q: Baghiben

A: The objective of the question is to calculate the payback period for Project A. The payback period…

Q: If the risk free rate is 4% and the risk premium is 10, and beta is 1 what is the required rate of…

A: The capital asset pricing model (CAPM) refers to the model that tells us how the financial markets…

Q: Following is information on an investment in a manufacturing machine. The machine has zero salvage…

A: Time value of money is a financial concept which is used to analyze various investments and…

Q: Bhupatbhai

A: The objective of the question is to calculate the total rental cost and total buying cost for…

Q: A bond with 16 years to maturity has an annual interest payment of $40. If the bond sells for its…

A: Bonds are debt instruments issued by companies. The issuing company pays periodic coupons or…

Q: Determine the future value of the following single amounts. Note: Use tables, Excel, or a financial…

A: Future value is the value of an asset or investment at a specified future date, based on the…

Q: Year 12345 Returns X 15% 18 9 -9 10 Y 20% 30 15 -16 20 Using the returns shown above, calculate the…

A: Standard deviation is a measure of how spread out the values in a data set are from the mean. It is…

Q: A firm is considering two mutually exclusive projects, & alia 1, 4 0 1 2 3 -$1,000 $110 $320 $370…

A: YearProject XProject Y0-$1,000-$1,0001$110$1,0002$320$1103$370$504$650$45WACC=10%

Q: You would like to contribute to a savings account over the next three years in order to accumulate…

A: Compound = Quarterly = 4Number of Payment = n = 3 * 4 = 12Interest rate = i = 14 / 4 = 3.5%Payment =…

Q: Calculate working capital and relevant liquidity ratios

A: The working capital is a short term financial position of the company.Working capital is the money…

Q: Suppose in 2023 the expected dividends of Fordson, Inc. stock will equal $260M with a discount rate…

A: SOLUTION:The DDM is a valuation model that estimates the present value of a company's stock based on…

Q: Aleksov Brothers common stock sells for $36.60 a share and pays an annual dividend that increases by…

A: Price of the share (P0) = $36.60Constant growth rate (g) = 1.8% or 0.018Required rate of return =…

Q: The bond J is a bond with a coupon rate of 4%. The bond K is a bond with a coupon rate of 10%. Both…

A: Bonds are obligation securities issued by governments, districts, or organizations to raise stores,…

Q: An investment has an installed cost of $520,800. The cash flows over the four-year life of the…

A: Net present value (NPV) is the difference between present value of all cash inflows and initial…

Q: Carry Trade, Inc., borrows yen when the yen is trading at ¥120/US$. If the nominal annual interest…

Q: Suppose you have a 10-year bond (the bond will mature in 10 years), with a coupon rate of 2.45%.…

A: Bond price will be the aggregate of present value of all coupon payments and present value of face…

Q: You observe the following term structure for Treasury bills: Yield (%) 5.1 5.4 5.6 5.8 6.1 Maturity…

A: Treasury securities refer to the debt instruments issued by the U.S. Department of the Treasury to…

Q: Beagle Beauties engages in the development, manufacture, and sale of a line of cosmetics designed to…

A: Share price refers to the price which is used for buying or sold in the stock market among investors…

Q: vvk.2

A: The objective of the question is to calculate the present value of a 12-year annuity which pays…

Q: Contract Open High hilo Low Eurodollar (CME) -$1,000,000; pts of 100% 97.2400 97.2450 97.2225 Jan…

A: An essential financial tool utilized in the international financial markets is eurodollar futures.…

Q: Decision D6, which has three possible choices (X, Y, or Z), must be made in year 3 of a 6-year study…

A: PW is the present worth analysis method which can be used for evaluating various projects of…

Q: Suppose government economists have forecasted one-year T-bill rates for the following two years.…

A: A T-bill, or Treasury Bill, is a short-term debt security issued by the United States Department of…

Q: Number of years needed to accumulate a future amount For the following case, determine the number of…

A: Present Value (PV) = $12,187Future Value (FV) = $24,600Interest rate (r) = 8% or 0.08We will use the…

Question

Suppose a firm has had the following historic sales figures.

Year:	2016	2017	2018	2019	2020
Sales	$1,530,000	$1,720,000	$1,560,000	$2,100,000	$1,850,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.

Leveraging special tenchniques in analyzing historical data to predict future trends. Forecasting covers the methods and types of forecasting and their application to case studies.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Trending now

This is a popular solution!

Step by step

Solved in 1 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

Using the Value Line Investment Survey report in Exhibit 11.5, find the following information for Apple. What was the amount of revenues (i.e., sales) generated by the company in 2017? What were the latest annual dividends per share and dividend yield? What is the earnings per share (EPS) projection for 2019? How many shares of common stock were outstanding? What were the book value per share and EPS in 2017? How much long-term debt did the company have in the third quarter of 2018?
Financial leverage MicrosoCortrepotied (MSFT) reported the following data (in millions) for a tern year Compute the profit margin, asset turnover, and financial leverage metrics using the expandedDuPont formula. Round profit margin, asset turnover, and financial leverage to two decimalplaces.Round return on stockholders’ equity to one decimal place.
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $3,100,000 $3,350,000 $3,000,000 $3,600,000 $3,200,000 What would be the forecast for next year’s sales using the naïve approach?
Romblon Company reported the following sales: P500,000 (2018); P520,000 (2019) and P551,200 (2020). Using the average growth rate method, the forecasted sales for 2021 and 2022 are" "P562,400 and P573,600" "P576,800 and P602,400" "P578,760 and P607,698" "P595,296 and P654,826"
Consider the following information that you propose to use to obtain an estimate of year 2004 EPS for the MacLog Company. Estimated Year 2019 Year 2020 GDP 11,000 Billion GDP growth 3.5% Sales per share $800 Operating profit margin 12% Depreciation/Fixed Assets 14% Fixed asset turnover 2 Interest rate 3.5% Total asset turnover 0.7 Debt/Total assets 45% Tax rate 36% In addition, a regression analysis indicates the following relationship between growth in sales per share for MacLog, and GDP growth is %Δ Sales per share = 0.015 + 0.75(%Δ GDP) Refer to Exhibit 9.6. Calculate the firm's level of Total Assets per share for the year 2020. a. $1,385.77 b. $1,113.58 c. $1,050.65 d. $1,065.67 e. $1,190.06
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.
he following data represents the annual sales of a Digitech Automation products SAOG. Year 2014 2015 2016 2017 2018 Sales (in Millions) OMR 380 440 520 396 514 Use method of least squares to calculate the trend values and the forecast for the future period. Which of the following is the annual sales forecast for the year 2019 using least squares method? a. 539.6 Million OMR b. 584.4 Million OMR c. 606.8 Million OMR d. 562 Million OMR
A company's annual profits have a trend line given by Y = 20,000t – 10,000, where Y is the trend and t is the year with t = 0 in 2012. What is the forecasted profit for the year 2021 using an additive model if the seasonal variation for that year is –30,000?
Kk.1. Ford has the following information related to 2020: 2020 2021 - Sales $1,000,000 $1,200,000 - Current Assets 350,000. 35% 420,000 - Long-Term Assets 650,000 65% 780,000 - Current Liabilities 120,000 12% 144,000 - Long-Term Liabilities 280,000 N/A - Common Stocks 550,000. N/A - Retained Earnings 50,000. Sales are expected to grow by 20% next year with expected Net Profit Margin 20% and Dividends layout 60% Required: 1.How much discretionary Financing needed by Ford in 2021?
Net Income for Company A is $200,000 in 2014, $300,000 in 2015, $400,000 in 2016, $500,000 in 2017, and $600,000 in 2018. The expected growth for all years after 2018 is 5%, the 90-Day T-Bill Rate is 20%, and the appropriate percentage above risk-free rate is 12%. Using this information, what is the reasonable value for Company A based on its future income stream for 2014 to 2018? A. 1,394,267.03 B. 4,394,267.03 A or B?
At the end of 2012, you forecast the following cash flows (in millions) for a firm with net debt of $759 million: 2013 2014 2015 Cash flow from operations $1,450 $1,576 $1,718 Cash investment 1,020 1,124 1,200 You forecast that free cash flow will grow at a rate of 4 percent per year after 2015. Use a required rate of return of 10 percent in answering the following two questions: The firm’s enterprise value (in millions) at the end of 2012 is equal to: The firm’s equity value (in millions) at the end of 2012 is equal to:
Using the AFN formula in financial forecasting approach, Determine the following for Piano Co. given the following accounting information assuming that the firm’s profit margin remains constant and the company is at full capacity. · Sales this year is P6,000,000· Percentage increase projected for next year sales = 20%· Net income this year amounts to P600,000· Retention ratio = 50%· Accounts payable = P1,100,000· Notes payable = P180,000· Accrued expenses = P500,000· Projected excess funds available next year is determined to be P200,000 Questions: 1. Determine the spontaneous liabilities increase. 2. How much is the increase in Retained Earnings? 3. How much is the total assets?