Question: I was recently assigned this difficult financial forecasting problem. Given the sales for 2017, 2018 and total Sales as of June 1st I need to

I was recently assigned this difficult financial forecasting problem. Given the sales for 2017, 2018 and total Sales as of June 1st I need to forecast what the yearly sales will be for 2019. I started off by calculating the percentage growth from 2017 to 2018 (38%) and applied that growth rate to 2019 to get the sales projection of $101. I have no idea how to adjust the forecast/growth rate based on the actual sales up to June. Can someone please provide guidance and an explanation on how I should adjust the forecast based on the actuals and what the 2019 sales forecast should be.

Revenue ($M)	2017	2018	2019 as of Jun-1	2019 Projected	'17-'18 growth	'18-'19 proj. growth
Value Brands	$ 53	$ 73	$ 42	$ 101	38%	38%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Which of the following statements would BEST characterize an individual who is culturally competent in working with others from different cultures? Select: 1 Culturally competent people pay more...

Case Analysis Guide Questions: 1. What is going right with this business? What concerns you? 2. Where is the cash going? 3. Will strong business performance in 2020 improve the cash position? 4. Do...

Part I: Cash Budget Problem In this part, you are required to develop a Six-month Cash Budget (from March 2021 to August 2021 ) analysis for Company A to (1) develop its monthly cash budget; (2)...

please see attachment for instructions,Only the following budget spreadsheets are to be included: Sales, Collections, and Production. Be sure to use Word Wrapping, Alignment, and Punctuation for...

In this section you should read the case and ask yourself, "What's happening here right now?" What are the issues that the firm faces within the context of the case? In many cases there are issues...

FIRE 623 Graded Case Assignment - Mid-Atlantic Container Corporation 100 points Due December 4, 2019 at 7:00 pm 1) Assess the current financial health and recent financial performance of the company....

Please help answer just part f. (in red) for this problem. I will be re-working it before I submit, but I need full guidance to better learn the concepts and how you got to them through Excel....

I need, I am working on GENERAL ELECTRIC AND UNITED TECHNOLOGIES CORP, I need help GE and UTC Financial Statements Forecast for the next 5 year using the attachment. Throughout this course you will...

CASE STUDY Case Study Best Homes, Inc.: Forecasting excel Best Homes is a new home construction company with headquarters in Kansas City, Missouri. They construct only Page 463 residential homes...

Complete the following problems from Chapter 12 in Financial Management: Theory and Practice : Chapter 12: Topics: Additional Funds Needed, Forecasted Statements and Ratios, Financing Deficits...

At the start of 2071 Cowboy Corp. purchased 25% of Bebop Tech Inc. for $45 million. At the time of purchase, the carrying value of Bebop Tech's net assets was $75 million. The fair value of Bebop...

The following table shows the details of the two loans made by Bank ABC. By employing the KMV model, compute the return and risk of Bank ABC's overall loan portfolio which is made up of two loans...

On January 1 , 2 0 2 4 , Rodriguez Window and Pane issued \ ( \ $ 1 9 . 1 \ ) million of 1 0 - year, zero - coupon bonds for \ ( \ $ 7 , 3 6 3 , 8 7 7 \ ) . Required: 2 . Determine the effective rate...

Skills necessary for success in marketing include Multiple select question. analytical thinking advertising industry experience infallibility ability to work with others

How do you track what happens to the information you learn from your customers complaints?

Customers have to repeat information they have already provided.

5.4 Using the uniform probability density function shown in Figure 5.7, find the probability that the random variable X is greater than 1.3.