Solution-Create a chart of sales by year for all years

Create a chart of sales by year for all years

Reference no: EM131462368

Assignment: Forecasting and Trends

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

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.

Attachment:- Assignment_Data.xlsx

Reference no: EM131462368

Questions Cloud

Create the revenue by product or service category : You have been engaged by Mike and Shirley Jones to value their company called Peachtree Plumbing, Inc. The valuation is for the purpose of gifting shares

What is the required return for palm coal stock : If investors feel this growth rate will continue, what is the required return for Palm Coal stock?

How will you find out about job openings : Discovery statement: This chapter discussed human resource management from an organizational and business perspective.

Free-energy change and spontaneity of reactions : Explain the relationship between free-energy change and spontaneity of reactions.

Create a chart of sales by year for all years : Prepare a pro forma income statement and balance sheet for the next year. Create a chart of sales by year for all years, including your pro forma estimate.

What sort of training offered by preceding consulting firms : Although you may believe that your formal learning will end when you graduate and enter the working world, it won't. Companies both large and small spend.

Concentration of the chromate ion : What is the concentration of the chromate ion when the first salt starts to precipitate. (ANSWER - 3 x 10-12)

Annual worth method of comparing alternatives : Select all that apply to the Annual Worth method of comparing alternatives

What are the irrs for project : You are evaluating project that costs $62,000 today. Project has inflow of $134,000 in one year-outflow of $52,000 in two years. What are the IRRs for project

User Account

All Pages

Create a chart of sales by year for all years

Reference no: EM131462368

Reference no: EM131462368

Questions Cloud

Reviews

Write a Review

Corporate Finance Questions & Answers

Impact of the global economic crisis on business environment

Explain the short and the long-run effects on real output

Examine the requirements for measuring assets

Financial analysis report driven by rigorous ratio analysis

Calculate the value of the merged company

Stock market project

Write paper on financial analysis and business analysis

Intermediate finance

Average price-earnings ratio

Determine the financial consequences

Prepare a spread sheet model

Principles and tools for financial decision-making

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT