Create a chart of sales by year for all years

Assignment Help Accounting Basics
Reference no: EM131752258

Forecasting and Trends

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.

Reference no: EM131752258

Questions Cloud

What is the expected borrowings : Raymond wants to maintain a balance of at least $30,000 cash at the end of each quarter. What is the expected borrowings
Current planned business activities of product or service : Analyze current planned business activities of the product or service. Provide a SWOT analysis of the condition of the company.
What level of the unemployment rate : What level of the unemployment rate was believed to represent full employment by Walter Heller while serving as chair of the Council of Economic Advisors?
What amount of net income will be reported : Based on the information provided, what amount of net income will be reported in the consolidated financial statements for the year?
Create a chart of sales by year for all years : Create a chart of sales by year for all years, including your pro forma estimate.
Difference between pilot study and full study data : What is the difference between pilot study and full study data?
Calculate ladanions return on assets and return on equity : Calculate LaDanion's return on assets and return on equity ratios
What is the market equilibrium price and quantity : a. What is the market equilibrium price and quantity? Sketch your answer as well as calculate it numerically.
Concept in discussion of organizational behavior : Define the term mindfulness and explain why you believe the authors of our text included this concept in a discussion of organizational behavior.?

Reviews

Write a Review

Accounting Basics Questions & Answers

  If sales are budgeted to be 150000 for march and 200000 for

big wheel inc. collects 25 of its sales on account in the month of the sale and 75 in the month following the sale. if

  Journalize the entry to distribute the remaining cash for

after the accounts are closed on february 3 2014 prior to liquidating the partnership the capital accounts of william

  The following transactions occurred during 2013 assume that

the following transactions occurred during 2013. assume that depreciation of 10 per year is charged on all machinery

  Prepare the current assets section of the balance sheet

Prepare the current assets section of the balance sheet, listing the accounts in proper sequence.

  An investment offers to pay you 10000 a year for five

an investment offers to pay you 10000 a year for five years. ifit costs 33520 what will be your rate of return on the

  Performance report for period based on actual production

Calculate the number of direct labor hours budgeted for actual production of the two products. Prepare a performance report for the period based.

  Calculate the current and debt ratios for the company.

Enter the trial balance on a work sheet and complete the work of Speedy G Internet.

  Determine the test statistic

For each data set, determine the test statistic, T +. What percentage of the observations in each data set has plus signs? Informally, what does this indicate about the possibility  that  the  true median in each  case is as postulated?

  You are about to issue a report on the compiled financial

you are about to issue a report on the compiled financial statements of abc company. however you feel you lack

  A company leases some of the equipment it uses the lease

a company leases some of the equipment it uses. the lease term is 5 years and the lease payment are to be made in

  Compute earnings per share

Compute earnings per share for 2017. Assume that financial statements for 2013Ir were issued in March 2018

  Keenan computer chips inc is experiencing a period of rapid

keenan computer chips inc. is experiencing a period of rapid growth. earnings and dividends are expected to grow at a

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd