Forecasting and Trends

Forecasting and Trends

***Partially Completed Already***

Please check the work that is already completed and make any changes needed (see attached).

Don't use plagiarized sources. Get Your Custom Essay on
Forecasting and Trends
Just from $13/Page
Order Essay

Ensure that ALL 6 steps below are completed. 

The Income statement and balance sheet for Camelot Inc. are provided here.   Note that firm’s capital expenditures are expected to rise by $50,000 in the new year. This will lead to an increase of $5,000 in accumulated depreciation.  Sales next year should be $4.3M

1.  Using percentage of sales analysis techniques prepare a pro forma income statement and balance sheet  for the next year.

2. Create a chart of sales by year for all years, including your pro forma estimate.

3. Add a trend line.

4.  Create a scatter plot of sales vs. cogs.  Add a trend line.

5. Regress COGS against sales .

6. Using your sales trendline and annual sales data forecast the sales level in the next 3 years (3 years after the year with 4.3M in sales).  Forecast using the trend line as well as at least one of the following: trend, linest, regression.

Order your essay today and save 20% with the discount code: GREEN

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal
Live Chat+1(978) 822-0999EmailWhatsApp