304 Sales Forecasting loan am In-class example

# 304 Sales Forecasting loan am In-class example - This...

This preview shows pages 1–3. Sign up to view the full content.

Company XYZ, Inc. Year Period Sales 1998 1 \$9,500 1999 2 \$10,000 2000 3 \$11,000 2001 4 \$10,250 2002 5 \$10,000 2003 6 \$10,750 2004 7 \$11,500 2005 8 \$12,300 2006 9 \$12,000 2007 10 \$11,750 2008 11 ? 1 Plot the data. What trend component(s) is present? Upward linear trend component, cyclical component 2 What is the trend line equation for this data? y = 274.24x + 9396.7 3 What is the 2008 forecasted Sales value? 12413.34 0 2 4 6 8 10 12 \$0 \$2,000 \$4,000 \$6,000 \$8,000 \$10,000 \$12,000 \$14,000 f(x) = 274.24x + 9396.67 Column C Linear Regres- sion for Column C Linear Regres- sion for Column C

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
One of the really great features of Excel is the Loan Amortiztion Template. To use, simply select the Office Button Click on NEW, then under installed templates, select Loan Amortization Schedule, then Create.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: This creates a loan amortization template in a new worksheet. When finished, you can move your product to anot To move to another workbook: 1. Right click on tab 2. Choose Move or Copy… 3. Select tab to Move or Copy (make sure "Create a copy" is selected if you want a copy) 4. Click on dropdown for "To book:" and select workbook to move sheet to. 5. If that won't work, you can right click and copy the entire sheet, then paste it into your workbook Enter in loan information or link to cells containing data. n ther workbook....
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

304 Sales Forecasting loan am In-class example - This...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online