The Income statement and balance sheet for    xx...

  1. Home
  2. Homework Library
  3. Business
  4. Finance
  5. The Income statement and balance sheet for    xx...

QuestionQuestion

The Income statement and balance sheet for    xxx 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.
2. Create a chart of sales by year, 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.

    Solution PreviewSolution Preview

    These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

      By purchasing this solution you'll be able to access the following files:
      Solution.xlsx.

      50% discount

      Hours
      Minutes
      Seconds
      $83.00 $41.50
      for this solution

      or FREE if you
      register a new account!

      PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

      Find A Tutor

      View available Finance Tutors

      Get College Homework Help.

      Are you sure you don't want to upload any files?

      Fast tutor response requires as much info as possible.

      Decision:
      Upload a file
      Continue without uploading

      SUBMIT YOUR HOMEWORK
      We couldn't find that subject.
      Please select the best match from the list below.

      We'll send you an email right away. If it's not in your inbox, check your spam folder.

      • 1
      • 2
      • 3
      Live Chats