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.

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

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

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. 27
Suppose a firm has had the historical sales figures shown as follows. What would be the forecast for next year's sales using the average approach? Year 2017 2018 Sales $ 750,000 500,000 Multiple Choice O $695,000 $700,000 $750,000 $775.000 2019 $ 700,000 2020 $ 750,000 2021 $ 775,000
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?
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,000
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?
Suppose 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 sales
Suppose 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 sales
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.
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.
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.
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
Self-Test Problem Given are the following possible dollar returns (dividends plus capital gains) over the coming year from a $10,000 investment in General Motors common stock: State of Economy Probability 0.20 0.60 Return $-1,000 1,500 2,500 Recession Normal year Boom 0.20 Convert the dollar returns to percentage returns and then determine the a. Expected return b. Standard deviation of returns